Epicor Technical Consultant

Job Title:

Department:

Location:

Employment Type:

Experience Level:

Roles and Responsibilities

• Data Integration & Development:

  Design, build, and maintain

  Epic Caboodle data models

  , ETL pipelines, and data marts to support enterprise reporting, analytics, and population health initiatives.

• Reporting & Analytics (Epic Cogito):

  Develop and manage

  Epic Cogito

  reporting solutions, including

  Clarity reports, Reporting Workbench templates, SlicerDicer models

  , and

  Caboodle-based dashboards

  .

• Stakeholder Collaboration:

  Partner with clinical, financial, and operational teams to gather business requirements, translate them into technical designs, and deliver meaningful, actionable insights.

• Performance Optimization:

  Analyze existing reports, data models, and ETL jobs for accuracy and efficiency. Implement performance tuning, indexing, and optimization strategies across Caboodle and Cogito platforms.

• Data Quality & Validation:

  Ensure the accuracy, completeness, and consistency of data across Epic systems. Conduct rigorous testing and validation of reports, extracts, and visualizations before deployment.

• System Integration:

  Work closely with the database administration, ETL, and BI teams to ensure seamless integration between

  Epic Clarity, Caboodle, and external data sources

  .

• Documentation & Compliance:

  Maintain detailed technical documentation for data models, reports, and ETL processes. Ensure compliance with

  HIPAA

  ,

  PHI

  , and organizational data governance standards.

• User Support & Training:

  Provide end-user training and support for Cogito tools, dashboards, and reports. Assist departments in understanding and using analytics effectively to drive performance improvement.

Desired Candidate Profile

• Experience:

• 3 to 6 years of experience in

  Epic reporting, data warehousing, or healthcare analytics

  .
• Proven experience with

  Epic Caboodle

  (data warehouse) and

  Epic Cogito

  tools.
• Prior work with

  Epic Clarity

  and

  SQL-based reporting

  is strongly preferred.

• Technical Skills:

• Proficiency in

  SQL

  ,

  T-SQL

  , and

  ETL design

  .
• Strong knowledge of

  Microsoft SQL Server

  ,

  SSIS

  ,

  SSRS

  , or equivalent BI tools.
• Experience with

  Epic Cogito suite

  , including

  Reporting Workbench, SlicerDicer, Clarity Reports

  , and

  Caboodle data models

  .
• Familiarity with

  data visualization tools

  (e.g., Power BI, Tableau) is a plus.

• Certifications (Preferred):

• Epic Caboodle Data Warehouse Certification

• Epic Cogito Tools or Clarity Data Model Certification (Inpatient, Ambulatory, etc.)

• Other Epic or BI tool certifications are advantageous.

• Soft Skills:

• Strong analytical, problem-solving, and data interpretation skills.
• Excellent communication and documentation abilities.
• Ability to work collaboratively with cross-functional and clinical teams.
• High attention to detail with a focus on data integrity and reliability.
• Bachelors degree in

  Computer Science, Information Systems, Health Informatics

  , or a related field (required).
• Master’s degree in

  Health Informatics, Data Analytics

  , or

  Information Technology

  (preferred).

Key Attributes

• Deep understanding of healthcare data and reporting workflows.
• Ability to translate business questions into data-driven insights.
• Passion for leveraging Epic’s data ecosystem to improve patient care and operational efficiency.
• Strong commitment to quality, compliance, and innovation in healthcare analytics.