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 

• 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 non‐Epic Caboodle datasets to identify required data elements to be moved into Caboodle/KH Warehouse.
• Map non‐Epic 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 non‐Epic 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