Lead Data Warehouse Engineer New York City

Location: New York City

 

      Responsibilities:

1. 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.

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

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

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

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

6. Conduct code walkthroughs, peer reviews, and produce technical documentation

      Candidate Skills and Qualifications:

1. Bachelors degree in a technical discipline; Masters degree preferred

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

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

4. 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

5. Strong SQL coding and SSIS package development skills a must

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

7. Understanding of full life cycle development methodology

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

9. Experience with the OMOP Common Data Model is a plus.

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