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

Address
12401 Washington Blvd.

Salary
84302.40-146057.60

Shift
Days

Caboodle ETL Developer I, II Epic-(Open to experienced remote in ID, NE, MO, OK, TX)