Principal Epic Cogito Analytics Consultant

Job Description – Principal Epic Cogito Analytics Consultant

Project: Epic Cogito Support
Location: San Francisco, CA, United States
Work Schedule: 9:00 AM–5:00 PM PST
Work Arrangement: Remote with onsite presence 3–5 days per month
Reports To: Data Analyst Supervisor

Position Overview

We are seeking a Principal-level Epic Cogito Analytics Consultant to support its Epic-centered data architecture, enterprise reporting, and healthcare intelligence initiatives. The consultant will work with operational, clinical, finance, and IT stakeholders to deliver production-ready analytics, mentor internal analysts, resolve complex data/reporting issues, and contribute to scalable future-state data infrastructure.

Key Responsibilities

• Assess current Epic data architecture, reporting pipelines, and analytics workflows and identify gaps and optimization opportunities.
  
• Design and implement scalable data models and BI architecture supporting enterprise reporting and population health.
  
• Perform root-cause analysis for data quality issues, reporting discrepancies, and pipeline failures.
  
• Translate clinical, operational, and executive requirements into technical analytics solutions.
  
• Contribute to the future healthcare intelligence platform, including Microsoft Fabric or equivalent modern data-stack architecture.
  
• Conduct stakeholder interviews, workshops, and discovery sessions.
  
• Manage analytics requests through Jira, including requirements gathering, estimation, tracking, and delivery.
  
• Develop production-ready reports and dashboards using Epic Chronicle, Clarity, and Caboodle.
  
• Work with Power BI, SSRS, Reporting Workbench, and SlicerDicer.
  
• Support non-Epic data integration through Microsoft Fabric and REST APIs.
  
• Maintain report specifications, data lineage, data dictionaries, and technical documentation.
  
• Provide knowledge transfer and mentorship to internal analysts.
  
• Recommend automation and process improvements to reduce manual reporting efforts.
  

Requirements

• 7–10 years of progressive hands-on healthcare data analytics experience.
  
• Experience owning enterprise BI or data-platform initiatives.
  
• Strong analytical problem-solving and root-cause analysis skills.
  
• Experience translating business requirements into validated analytics deliverables.
  
• Experience designing or contributing to healthcare data warehouse/lakehouse architecture.
  
• Knowledge of healthcare domains including:
  
  • FQHC operations
    
  • Revenue cycle
    
  • Population health
    
  • Value-based care
    
  • UDS
    
  • HEDIS
    
  • MIPS
    
  • CMS
    
• Strong communication skills with both technical and executive stakeholders.
  
• Ability to independently manage multiple concurrent requests.
  

Technical Requirements

• Expert SQL, including complex queries, stored procedures, and data transformations.
  
• Strong hands-on experience with Power BI and SSRS.
  
• Direct experience with Epic Chronicle, Clarity, and Caboodle.
  
• Familiarity with Microsoft Fabric and REST API-based data integration.
  
• Experience working in Agile environments with Jira, sprint planning, and iterative delivery.
  

Preferred Epic Certifications

• Epic Cogito Fundamentals
  
• Caboodle Data Model
  
• Clarity Data Model
  
• Revenue Data Model
  
• Clinical Data Model
  

Preferred Qualifications

• Additional Epic certifications such as Healthy Planet, Compass Rose Analytics, or Caboodle Development.
  
• Experience in an FQHC, community health, or multisite ambulatory environment.
  
• Experience with Microsoft Fabric, Databricks, Snowflake, or similar platforms.
  
• Healthcare data governance and data dictionary experience.
  
• Exposure to AI/ML-assisted healthcare analytics.
  
• Knowledge of value-based care, population health, and clinical quality measures.
  
• Experience mentoring junior analysts.
  
• Experience supporting Epic analytics in a live post-go-live environment.
  
• Knowledge of HIPAA, healthcare data privacy, security, and enterprise architecture.
  
• Second-language proficiency in Cantonese, Mandarin, Vietnamese, or Spanish is an asset.
  

Engagement Expectations

• Full-time, 40 hours/week.
  
• business hours: 9:00 AM–5:00 PM PST.
  
• Onsite presence 3–5 days per month at Client.
  
• Work within DataOps SOPs, including version control, peer review, and documentation.
  
• Participate regularly in knowledge-transfer sessions.
  
• Meet sprint commitments and proactively communicate risks.
  
• All work must comply with HIPAA, and healthcare data governance requirements.