Computer Science, Data Mapping, Data Modeling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Epic Caboodle, Epic Certification, Epic Chronicles, Epic Clarity, Epic Cogito Data Warehouse, Epic Systems, Error Handling, Financial Systems, Healthcare, Microsoft Transact-SQL (T-SQL), Performance Tuning/Optimization, Process Improvement, Query Optimization, Reconciliation, SQL (Structured Query Language), Star Schema
Role: EPIC Caboodle Developer
Location: Remote
Type: Contract/Fulltime
Experience Range: 10+ Years
Note: EPIC Caboodle Certifications mandatory
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.
Educational Qualification:
Bachelor's or Master's degree in Computer Science, Engineering, or related field.
Primary (Must have skills)
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.