Caboodle ETL Developer I, II Epic-(100% Onsite)

The Caboodle ETL Developer develops custom import packages to move additional data sets into the Caboodle database. This role may not be required depending on how you plan to use Caboodle at your organization and how non‐Epic data will help contribute to your reporting needs. budget, and upcoming milestones. The ideal candidate will have hands-on experience with Epic's Clarity and Caboodle data models, proficiency in SQL, and a strong understanding of healthcare data and reporting needs.

PIH Health is a nonprofit, regional healthcare network that serves approximately 3 million residents in the Los Angeles County, Orange County and San Gabriel Valley region. The fully integrated network is comprised of PIH Health Downey Hospital, PIH Health Good Samaritan Hospital, PIH Health Whittier Hospital, 37 outpatient medical office buildings, a multispecialty medical (physician) group, home healthcare services and hospice care, as well as heart, cancer, digestive health, orthopedics, women’s health, urgent care and emergency services. The organization is nationally recognized for excellence in patient care and patient experience, and the College of Healthcare Information Management Executives (CHIME) has identified PIH Health as one of the nation’s top hospital systems for best practices, cutting-edge advancements, quality of care and healthcare technology. For more information, visit PIHHealth.org or follow us on Facebook, Twitter, or Instagram.

Required Skills

• Strong analytical, technical, and troubleshooting skills

• Demonstrated proficiency in writing SQL

• Demonstrated proficiency with SQL Server Integration Services

• Demonstrated proficiency in data architecting and data modeling

• Demonstrating flexibility with respect to changing end‐user business needs

• The ability and willingness to recognize assignments or tasks that need to be completed, to seek

• out additional assignments or tasks, and to help others

• The ability to communicate information clearly and concisely with project leadership and subject

• matter experts

• The ability to gain trust and establish effective relationships with Epic counterparts

• The ability and willingness to learn new software and systems

• Listening attentively to ensure that the intended message has been accurately received, holding

• responses until the person have finished making their point, and repeating information to ensure

• accuracy

• Seeking, logically examining, and interpreting information from different sources to determine a

• problem's cause and developing a course of action to resolve the problem and to prevent its

• recurrence

• The ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance when faced with stressful work situations and time pressures

Required Experience

Caboodle ETL Developer I

Required:

• Experience in SQL

Preferred:

• Epic Train Track: Caboodle Development for Clarity Data

• Epic Train Track: Caboodle Development for Non‐Epic Data

Caboodle ETL Developer II

Required:

• 10 or more years of strong experience in SQL server, including T-SQL, schema design, performance tuning, solid background in SSIS development with ETL processes and data pipeline designs

• 5 years of experience in a data role in a healthcare setting

• 5 years of experience with SSRS and other visualization tools (i.e. Tableau, Power BI, Looker, etc)

Preferred:

• Epic Train Track: Caboodle Development for Clarity Data

• Epic Train Track: Caboodle Development for Non‐Epic Data

• Certified in Epic Clarity Data Model

• Certified in Epic Caboodle Data Model

• Certified in Epic Caboodle Development

• Strong analytical, technical, and troubleshooting skills

• Demonstrated proficiency in writing SQL

• Demonstrated proficiency with SQL Server Integration Services

• Demonstrated proficiency in data architecting and data modeling

• Demonstrating flexibility with respect to changing end‐user business needs

• The ability and willingness to recognize assignments or tasks that need to be completed, to seek

• out additional assignments or tasks, and to help others

• The ability to communicate information clearly and concisely with project leadership and subject

• matter experts

• The ability to gain trust and establish effective relationships with Epic counterparts

• The ability and willingness to learn new software and systems

• Listening attentively to ensure that the intended message has been accurately received, holding

• responses until the person have finished making their point, and repeating information to ensure

• accuracy

• Seeking, logically examining, and interpreting information from different sources to determine a

• problem's cause and developing a course of action to resolve the problem and to prevent its

• recurrence

• The ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance when faced with stressful work situations and time pressures