Caboodle ETL Developer , II Epic-( experienced remote in , NE, MO, OK, TX

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.

• Strong analytical, technical, and troubleshooting skills
• Proficiency in writing SQL
• Proficiency with SQL Server Integration Services (SSIS)
• Proficiency in data architecting and data modeling
• Flexibility with changing end‑user business needs
• Ability and willingness to recognize assignments or tasks that need to be completed and to seek additional assignments or tasks, and to help others
• 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 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 has 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 prevent recurrence
• Ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance when faced with stressful work situations and time pressures

• 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 experience in SQL Server, including T‑SQL, schema design, performance tuning, and 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 (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