Data Warehouse Specialist
About the position Johns Hopkins Health Plans is a leader in provider-sponsored health plans. If you are interested in improving how healthcare is delivered, and have a passion to be at the forefront of change, JHHP is the place to call home. YOU belong here. What awaits you: Work-life balance - This is a remote role. Applicants living in MD, DC, VA, PA, DE, or FL will be given first consideration. Medical, Dental, and Vision Insurance. 403B Savings Plan w/employer contribution. Paid Time off & Paid holidays. Employee and Dependent Tuition assistance benefits. Health and wellness programs and MORE! As a EPIC Data Aggregation Specialist, you’ll: Assists in the design, development, documentation, and management of ETL (Exchange, Transfer, Load) processes for the Epic Cogito Environment, including requirements gathering, and best practices analysis. This position will be responsible for developing and maintaining ETL mappings for multiple development projects. Will interact with business users and decision support staff as part of the support work for error resolution and design enhancements. Will participate in data quality initiatives to profile and cleanse data prior to loading into the warehouse. Responsible for full life-cycle of large/long-term highly complex projects. The responsibilities listed below are typical examples of the work performed by this position. Not all duties assigned to this position are included, nor is it expected that everyone in this position will be assigned every job responsibility. Who we are: Johns Hopkins Health Plans (JHHP) is the managed care and health services business of Johns Hopkins Medicine. JHHP is a $3B business serving over 500,000 active members with lines of business in Medicaid, Medicare, commercial, military health, health solutions, and venture investments. JHHP is a leader in provider-sponsored health plans and is poised for future growth. Many organizations talk about transforming the future of healthcare, at Johns Hopkins Health Plans, we are setting the pace for change within the healthcare industry. We develop innovative, analytics-driven health programs in collaboration with provider partners to drive improved quality and better health outcomes for our members and the communities we serve.
Responsibilities
- Assists in the design, development, documentation, and management of ETL (Exchange, Transfer, Load) processes for the Epic Cogito Environment, including requirements gathering, and best practices analysis.
- Responsible for developing and maintaining ETL mappings for multiple development projects.
- Will interact with business users and decision support staff as part of the support work for error resolution and design enhancements.
- Will participate in data quality initiatives to profile and cleanse data prior to loading into the warehouse.
- Responsible for full life-cycle of large/long-term highly complex projects.
Requirements
- 5+ years experience with ETL tools and ETL programming.
- 3+ years experience designing ETL solutions for data migration or data integration.
- 10+ years experience with IT projects and software development
- 1+ years of SQL Server experience.
- Requires a degree in Computer Science or related technology field; Master’s Degree Preferred.
- Existing or ability to obtain Epic Clarity or Caboodle Data Model certification.
Benefits
- Medical, Dental, and Vision Insurance
- 403B Savings Plan w/employer contribution
- Paid Time off & Paid holidays
- Employee and Dependent Tuition assistance benefits
- Health and wellness programs
Apply tot his job Apply To this Job