The position is an upper-level technical position, handling complex and technically challenging tasks, and providing design, development, implementation support and guidance to quality improvement and other healthcare projects with database, information and reporting needs.

This is an On-Site Position

• Collaborate with various health system stakeholders to design and develop data models and reporting solutions for quality, patient safety, patient satisfaction, and health system operations.
• Develop and incorporate clinical service line and department patient experience, clinical, quality, and operational reports, scorecards, and databases utilized to improve clinical and operational processes.
• Responsible for the collection, analysis, and reporting of data from multiple data sources to create actionable reports and knowledge for peers and leadership. Abstract information for decision support purposes, including service-line reporting and other duties as may be identified to assist decision-making.
• Provide technical support to other Administrators, Managers, Clinicians, and Executives in utilizing health data. Monitor adherence to data standards, support clients with a broad range of technical expertise, and provide technical and end-user documentation. Prepare and assist in the presentation of the strategic process and outcomes metrics.
• Assist in developing ETL (Extraction, Transformation, and Loading) processes to acquire and load data from internal and external sources.
• Extract, interpret, analyze, and prepare presentations of such information for senior management (e.g., patient experience, service line, DRG, and physician profiling).
• Assist with data for implementing patient experience and quality improvement processes and initiatives. Manage and design reports and benchmarking results clearly and concisely, and process and interpret report data for decision-making effectively and efficiently.

• Performs other duties as assigned.

• Bachelor’s degree in Information Technology or related field preferred with a minimum of 3 years experience with information systems
• Must have excellent communication and interpersonal skills in addition to a proven track record of establishing successful working relationships with varied levels of professionals
• Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures, or governmental regulations
• Ability to write reports, business correspondence and procedure manuals
• Ability to effectively present information and respond to questions from students, faculty, and employees of the medical school
• Ability to work with mathematical concepts such as probability and statistical inference. Ability to apply concepts such as fractions, percentages, ratios and proportions to practical situations

JOB SPECIFIC COMPETENCIES

• Database development and support within the healthcare setting preferred
• Experience with Practice Management software a plus
• Experience with EPIC is a plus
• Experience working in a team environment
• Experience working on multiple projects simultaneously
• Experience sorting through large data sets for reporting analysis, monitoring, trending and forecasting business outcomes
• Must have extensive experience with MS Office Suite, specifically Access, Excel and project
• Must be able to develop, extract, and analyze data from relational and spatial databases. Strong spatial analysis and writing skills, and must have formal training or comparable experience in data analysis, database design, spatial analysis and with application experience.
• Maintains up-to-date knowledge of programming language, including new features, tools, PC techniques, technology related to IT industry.
• Meet with the management and end-users to understand business requirements and reporting needs
• Maintain knowledge of the SQL database schema and data dictionary
• Documenting report specifications, adhering to design principles and coding standards
• Work with management, clinical analysts, and end users to review and refine report specifications
• Write complex SQL queries, stored procedures, and functions for formal adhoc reports
• Validate the results in SQL queries and final reports
• Adhere to all change control policies and procedures
• Establish/implement report delivery procedures
• Provide on-call support for reporting issues that affect production