PIH Health · 2 days ago
Caboodle ETL Developer I, II Epic-(100% Onsite)
Whittier, CA
Full-time
Onsite
Entry, Mid, Senior Level
$84K/yr - $146K/yr
10+ years expPIH Health is a nonprofit, regional healthcare network serving approximately 3 million residents in Southern California. The Caboodle ETL Developer is responsible for developing custom import packages for the Caboodle database and requires proficiency in SQL and a strong understanding of healthcare data and reporting needs.
Health Care
Responsibilities
Develops custom import packages to move additional data sets into the Caboodle database
Demonstrates proficiency in writing SQL
Demonstrates proficiency with SQL Server Integration Services
Demonstrates proficiency in data architecting and data modeling
Demonstrates flexibility with respect to changing end‐user business needs
Communicates information clearly and concisely with project leadership and subject matter experts
Gains trust and establishes effective relationships with Epic counterparts
Learns new software and systems
Listens attentively to ensure that the intended message has been accurately received
Seeks, logically examines, and interprets information from different sources to determine a problem's cause and develops a course of action to resolve the problem
Perseveres in difficult situations, overcomes obstacles, and reaches high levels of performance when faced with stressful work situations and time pressures
Qualification
Required
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
Experience in SQL
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
Company
PIH Health
PIH Health is a nonprofit, regional healthcare network.
5001-10000 employees
H1B Sponsorship
PIH Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Late StageLeadership Team
Charlotte A. Weaver
PIH Health, Vice Chair, Finance Committee, Audit Committee, Executive Committee
Recent News
2025-11-10
Company data provided by crunchbase