Data Warehouse Specialist

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.

What you’ll bring:

• 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.
  • Work experience may substitute for some educational requirements.
• Existing or ability to obtain Epic Clarity or Caboodle Data Model certification.

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.

Salary Range: Minimum 41.32/hour - Maximum 72.31/hour. Compensation will be commensurate with equity and experience for roles of similar scope and responsibility. In cases where the range is displayed as a $0 amount, salary discussions will occur during candidate screening calls, before any subsequent compensation discussion is held between the candidate and any hiring authority.

We are committed to creating a welcoming and inclusive environment, where we embrace and celebrate our differences, where all employees feel valued, contribute to our mission of serving the community, and engage in equitable healthcare delivery and workforce practices.

Johns Hopkins Health System and its affiliates are drug-free workplace employers.