ETL Developer II - IS Analytic Svcs at Kettering Health Network – Miamisburg, Ohio

ETL Developer II - IS Analytic Svcs

US-OH-Miamisburg

Job ID: 2025-56500
Type: Full-Time
# of Openings: 1
Category: Information Technology
Admin Support Bldg

Overview

Kettering Health is a not-for-profit system of 13 medical centers and more than 120 outpatient facilities serving southwest Ohio. We are committed to transforming the health care experience with high-quality care for every stage of life. Our service-oriented mission is in action every day, whether it’s by providing care in our facilities, training the next generation of health care professionals, or serving others through international outreach.

Responsibilities

Responsibilities

• Work with Business Intelligence Developers to provide data needed for reports.
• Monitor, Maintain and Contribute to the technical metadata found in the Caboodle metadata repositories.
• Analyze nonEpic Caboodle datasets to identify required data elements to be moved into Caboodle/KH Warehouse.
• Map nonEpic datasets to existing database structures within Caboodle/KH Warehouse.
• Design and develop custom database structures within the KH Warehouse or Epic Caboodle as needed.
• Develop custom imports to move additional pieces of Epic data from Clarity to Caboodle.
• Develop custom import packages to move nonEpic data into Caboodle/KH Warehouse.
• Modify the Clarity, KH Warehouse or Caboodle ETL processes to meet organizational reporting needs.
• Add new Clarity tables and columns to the data model as needed.
• Ensure optimal performance and integrity of all ETL processes by maintaining KH best practices.
• Design, build, test, document, and maintain custom extracts to be shared with KH Partners and third party vendors as needed.
• Troubleshoot custom extracts and resolve errors.
• Coordinate with integration team to schedule delivery of custom extracts and troubleshoot/resolve issues as needed.
• Maintain and update existing SSAS cubes.
• Design and implement SSAS cubes.
• Support and troubleshoot the Clarity, Caboodle, Slicer Dicer, BI RESTful, and Interconnect based Cogito tools as needed.
• Train/mentor new members of the team.
• Serve as point person for production downtimes to disable/enable impacted schedules.
• Mentor/assist other team members to ensure optimal performance and integrity of all ETL processes by maintaining KH best practices.
• Respond to emergency and after-hours issues.

Job Requirements

• Associates degree or equivalent combination of education, certification, and experience
  -3-5 years of experience as an ETL Developer or related field
• Epic Certification or obtained within 6 months

Preferred Job Qualifications

• Knowledge in a variety of data warehouse applications and tools
  
• Knowledge of data structures, database solutions, and best practice data management principles
  
• SQL Server Integration Services package development, configuration and deployment
  
• Experience with TSQL, performance monitoring and query tuning
  
• Prior experience working in healthcare industry with Epic EMR