Job Title: EPIC Caboodle Developer
Location: Fully remote
Salary
Note: EPIC Caboodle Certification is mandatory
Educational Qualification
Bachelor's or Master's degree in Computer Science, Engineering, or related field.
Experience Range
5 to 8 years
Primary (Must have skills) - To be Screened by TA Team
• 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.
Job Description of Role (RNR) - To be Evaluated by Technical Panel (Define it to give more clarity)
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.
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.
Soft skills/other skills - To be Evaluated by Hiring Manager (To define how this will be evaluated)
Communication Skills:
Communicate effectively with internal and customer stakeholders
Communication approach: verbal, emails and instant messages
Interpersonal Skills:
Strong interpersonal skills to build and maintain productive relationships with team members
Provide constructive feedback during code reviews and be open to receiving feedback on your own code.
Problem-Solving and Analytical Thinking:
Capability to troubleshoot and resolve issues efficiently.
Analytical mindset
Task/ Work Updates
Prior experience in working on Agile/Scrum projects with exposure to tools like Jira/Azure DevOps
Provides regular updates, proactive and due diligent to carry out responsibilities
Certifications (Preferred)
• Epic Cogito - Caboodle Data Model Certification
• Epic Clarity Data Model Certification
Expected Outcome
• Reliable and scalable ETL pipelines populating Epic Caboodle from Clarity and external data sources
• Accurate, timely, and consistent Caboodle fact and dimension data enabling enterprise reporting and analytics
• Improved data quality, reconciliation, and ETL stability through strong monitoring, logging, and error handling
• Seamless support for ongoing data refreshes and Epic Cogito upgrades with minimal disruption to reporting
Secondary Skills to be planned Post Hiring - Training Plan
• SSIS or equivalent ETL tooling experience
• Exposure to BI tools (Power BI, Tableau)
• Healthcare domain knowledge (Epic Resolute, EpicCare, OpTime)