EPIC Data Aggregation Specialist

Johns Hopkins Medicine; Northern (KY); Hybrid; USD 58,000 - 101,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

403(b) Plan

Paid Time Off

Paid holidays

Tuition assistance

Wellness programs

Job summary

Johns Hopkins Health Plans is seeking an EPIC Data Aggregation Specialist to design, develop, and manage ETL processes for the Epic Cogito Environment. The role involves mapping data, collaborating with business users, and leading data quality initiatives across large projects.

The position emphasizes remote work with first-consideration for candidates in MD, DC, VA, PA, DE, or FL, and offers comprehensive health and retirement benefits.

Qualifications

• 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.
• Work experience may substitute for some educational requirements.

Responsibilities

• Assists in the design, development, documentation, and management of ETL processes for the Epic Cogito Environment, including requirements gathering and best practices analysis.
• Develops and maintains ETL mappings for multiple development projects.
• Interacts with business users and decision support staff for error resolution and design enhancements.
• Participates in data quality initiatives to profile and cleanse data prior to loading into the warehouse; manages full life-cycle of large/long-term projects.

Skills

ETL tools

ETL programming

Data migration

Data integration

SQL Server

IT project experience

Software development

Education

Bachelor’s degree in Computer Science or related field

Master’s degree preferred

Tools

Epic Clarity Certification

Caboodle Data Model Certification

Job description

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 frontöund 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 offers four programs, including Priority Partners Managed Care Organization, Johns Hopkins Employer Health Programs (EHP), Johns Hopkins US Family Health Plan (USFHP) and Johns Hopkins Advantage MD.

Salary Range:

Minimum 41.94/hour - Maximum 73.39/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.

The Hospital reserves the right to modify employee schedules as needed.

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.