Lead Data Warehouse Engineer

The Lead Data Warehouse Engineer providing expertise and leading technical ETL development, deployment and maintains of ETL jobs for both internal and external stakeholders. The incumbent will develop and transform databases and data marts across multiple platforms, technologies (e.g., Relational, Columnar) and computing environments (e.g., host based, distributed systems, cloud) resources and projects. The incumbent will design, develop, and manage these resources in a high-performance computing and data warehousing environment, utilizing a thorough understanding of available technology, tools, and best practices. Specific responsibilities are listed below

Responsibilities

Lead designing, testing, implementing, maintaining, and controlling data pipelines and ETL jobs for integrating data into the Epic Caboodle Data Warehouse, and transforming data from Epic Caboodle into an Observational Medical Outcomes Partnership (OMOP) common data model database for medical research.

Responsible for the entire flow of the data into the Data Warehouse

Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for MSDW

Provides guidance for other team ETL team members involved in the development of the EDW and on ETL architecture, ETL standards, and ETL documentation

Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for EDW

Conduct code walkthroughs, peer reviews, and produce technical documentation

Qualifications

Bachelors degree in a technical discipline Master's degree preferred

Ten years of related experience, In -depth knowledge of associated technology areas that could impact area of responsibility; healthcare technology experience preferred.

At least seven years of demonstrated experience supporting, creating, modifying and maintaining ETL jobs

Minimum of 5 years’ experience working with electronic health record (EHR) and/or healthcare claims data; experience with Epic’s Clarity & Caboodle databases is strongly preferred

Strong SQL coding and SSIS package development skills a must

Strong analytical, problem solving, troubleshooting and multi-tasking skills

Understanding of full life cycle development methodology

The ability to communicate effectively and manage multiple conflicting priorities simultaneously.

Experience with the OMOP Common Data Model is a Plus

Demonstrate ability to remain effective and productive in a fast-paced and changing environment

Job Type: Full-time

Salary: $55.00 - $62.00 per hour

Schedule:

• Monday to Friday
• Weekends as needed

Experience:

• total work: 1 year (Preferred)

Work Location: Remote