ETL Developer II - IS Data Services

ETL Developer II - IS Data Services Miamisburg, OH Job Details Full-time 16 hours ago Qualifications Performance monitoring Data model design Data modeling Data Integration (Data management) Data analysis skills Application deployment Mid-level 3 years System maintenance Technical solutions implementation Data Architecture Design (Architecture design skills) Improving database performance Mentoring Systems & applications support Epic Certification Metadata Analysis (software development lifecycle) Epic Training Associate's degree Metadata management

T-SQL Full Job Description Job Details:

Support Services|Miamisburg|Full Time|

Days Responsibilities & Requirements:

ETL Developers manage the extract, transform, and load processes for the KH Data Warehouse and the Epic Caboodle Data Warehouse. ETL developers are responsible for utilizing Epic admin tools and developing custom technical solutions when needed. They are responsible for the full life cycle of a request including requirements analysis, development, validation, deployment, and maintenance.

Job Requirements:

Associates degree or equivalent combination of education, certification, and experience. Epic Certification or obtained within 6 months. 3-5 years of experience as an ETL Developer or related field. 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

Job 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 , SlicerDicer, 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

Overview:

Kettering Health is a not-for-profit system of 14 medical centers and more than 120 outpatient facilities serving southwest Ohio. Our mission is to live God's love by promoting and restoring health. Our commitment to our patients is to help individuals be their best. With that context, safety is our top priority. We provide an integrated system of healthcare experts committed to providing exceptional care.