PIH Health is looking to develop custom import packages to move additional data sets into the Caboodle database, requiring an ETL Developer with hands-on experience with Epic's Clarity and Caboodle data models, proficiency in SQL, and a strong understanding of healthcare data and reporting needs.
Requirements
- Demonstrated proficiency in writing SQL
- Demonstrated proficiency with SQL Server Integration Services
- Demonstrated proficiency in data architecting and data modeling
- Experience with SQL Server, including T-SQL, schema design, and performance tuning
- Experience with SSIS development and ETL processes
- Experience with SSRS and other visualization tools (i.e. Tableau, Power BI, Looker, etc)
- Certified in Epic Clarity Data Model, Epic Caboodle Data Model, or Epic Caboodle Development
Responsibilities
- Develops custom import packages to move additional data sets into the Caboodle database
- Writes SQL queries to extract and transform data
- Designs and develops ETL processes using SQL Server Integration Services
- Architects and models data to meet reporting needs
- Troubleshoots technical issues and resolves problems
- Develops and maintains data pipelines and data models
- Works with Epic counterparts to integrate data
Other
- Strong analytical, technical, and troubleshooting skills
- Ability to communicate information clearly and concisely with project leadership and subject matter experts
- Ability to gain trust and establish effective relationships with Epic counterparts
- Ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance when faced with stressful work situations and time pressures
- Bachelor's degree or higher in a related field (not explicitly stated but implied)
