EPIC Caboodle Developer

Role: EPIC Caboodle Developer

Location: Remote

Type: Contract/Fulltime

Experience Range: 10+ Years

Role Summary
The Epic Caboodle ETL Developer is responsible for building, maintaining, and optimizing ETL processes that populate the Caboodle data warehouse from Epic Clarity and external data sources. This role focuses on reliable data ingestion, transformation, and data quality.

Bachelor's or Master's degree in Computer Science, Engineering, or related field.

5 8+ years of experience in ETL development.
5+ years of experience with Epic Caboodle ETL.
5+ years of experience in SQL (advanced), performance tuning, and query optimization
5+ years of experience in working with EPIC Clarity data models and architecture expertise

Proficiency in:
o SQL (T SQL)
o ETL concepts (incremental loads, Slowly Changing Dimensions)
Experience working with large healthcare datasets (clinical, financial).
5+ Years of experience in Data warehousing concepts (dimensional modeling, star schema, fact/dimension tables)
5+ Years of Experience in Epic Cogito, Clarity, and Chronicles data flow.
5-8 years of experience in integrating external/non Epic data into Caboodle

Key Responsibilities
Develop and maintain ETL pipelines populating Epic Caboodle.
Implement and manage Caboodle ETL packages (Epic provided and custom).
Transform extracted data into Caboodle compliant fact and dimension tables.
Perform data mapping from Clarity to Caboodle.
Support data loads from external systems (claims, registries, financial systems).
Monitor and troubleshoot ETL job failures and performance issues.
Validate ETL outputs and reconcile data between Clarity, Caboodle, and reports.
Implement audit, logging, and error handling mechanisms.
Collaborate with Caboodle Architects and BI teams for data requirements.
Support data refresh cycles (daily, incremental, historical reloads).
Participate in Epic upgrades and Cogito releases.