Job Title: Population Health Database Engineer
Company: Good Samaritan Hospital
City/State: Suffern, NY
Department: Administrative Admin
Position: Full Time
Req #: 21164
Posted Date: Nov 10, 2020
The Population Health Database Engineer is responsible for the review, analysis, and development of specifications for the preparation of specialized automated reports and dashboards for quality and Population Health applications. This position provides data expertise and consulting services to the Population Health Departments and various user departments while ensuring data and reporting integrity. The Database Engineer will contribute to the development of the Enterprise Data Warehouse and supporting Data Marts.
Reports directly to the Director, Data Management and Analytics Designs and develop database objects, stored procedures, views, tables, and triggers; ensure their stability, reliability, and performance under the guidance of the Director, Data Management and Analytics. Creates automated Extract Transform and Load (ETL) programs Monitors the status of automated processes on a daily basis. Assesses reporting needs of customers through research, analysis and evaluation Develops dashboards that highlight opportunities for quality improvement and cost reduction in support of clinical transformation throughout the system. Present data findings and recommendation to leadership and other key stakeholders. Identifies and validates the appropriate technological solution for various reporting needs. Prioritizes and manages multiple projects simultaneously, and follow through on issues in a timely manner. Provides information to the Director, Data Management and Analytics to organize and determine analyst’s schedules for report development. Designs and documents specifications for reporting and complies with enterprise change control policies and procedures. Coordinates report distribution with the Director, Data Management and Analytics. Tests reports for functionality and validity in coordination with end users to assure data quality prior to production. Maintains confidentiality of all materials handled within the System as well as the proper release of information in accordance with established procedures and regulatory requirements. Performs other duties as assigned.
Qualifications / Requirements:
SQL skills required, including creating and modifying tables, stored procedures, and views, as well as troubleshooting and debugging (Microsoft SQL Server preferred) Experience with ETL Tools, (Microsoft SSIS preferred) Experience with health care datasets strongly preferred, Epic Clarity experience a plus Knowledge of Tableau or other dashboard tools is ideal
Bachelor’s degree is required
Licenses / Certifications:
Certification in at least 1 Epic Cogito Reporting module Epic Certification classes will be provided and candidate will be required to pass applicable Certification Projects/Exams
If applicable, the individual performing this job may reasonably anticipate coming into contact with human blood and other potentially infectious materials. Individuals in this position are required to exercise universal precautions, use personal protective equipment and devices, and learn the policies concerning infection control.