Roles & Responsibilities

3–5+ years of experience as an Epic Report Writer or Epic Data Analyst.
Strong proficiency in SQL (complex joins, CTEs, window functions, query optimization) and expertise with Epic Reporting Workbench (RWB).
Experience with Epic Clarity and Caboodle data models, data warehouse concepts (ETL, STAR schemas), and dashboard/report development.
Epic Clarity Data Model certification preferred (Clarity Ambulatory, Inpatient, ADT, ClinDoc, Resolute HB/PB, Cadence/Prelude).

Requirements:

Develop, validate, and optimize Epic Clarity and Caboodle reports using SQL, Epic toolsets, and BI platforms (Tableau, Power BI, Crystal Reports).
Translate end-user requirements into detailed business specifications and reporting solutions.
Work closely with clinical, revenue cycle, and operational stakeholders to support reporting needs.
Design, build, and maintain dashboards and recurring operational reports; assist in data extraction for regulatory programs (CMS, Meaningful Use, Quality Measures, HEDIS).

Job description

IKS Health takes on the chores of healthcare, reducing administrative, clinical, and operational burdens so that staff can focus on their core purpose: delivering exceptional care. Combining pragmatic technology and dedicated experts, IKS enables stronger, financially sustainable enterprises. Our Care Enablement Platform delivers data-driven value and expertise across the care journey, and IKS is a partner for clinician enterprises looking to effectively scale, improve quality and achieve cost savings through forward-thinking solutions. Founded in 2006, IKS Health’s global workforce supports large health systems across the United States.

Overview

We are seeking an experienced Epic Report Writer with strong expertise in Epic Clarity, Caboodle, and SQL-based analytics. This role will support clinical, operational, and financial reporting needs across multiple Epic modules. The ideal candidate has hands-on experience building complex reports, validating data, supporting ambulatory/inpatient reporting workflows, and partnering with clinical/operations leaders to deliver high-quality insights.

This is a 9-month contract to support a major reporting backlog, optimization initiative, and new program rollouts.

Key Responsibilities

Develop, validate, and optimize Epic Clarity and Caboodle reports using SQL, Epic toolsets, and BI platforms (e.g., Tableau, Power BI, Crystal Reports).

Translate end-user requirements into detailed business specifications and reporting solutions.

Work closely with clinical, revenue cycle, and operational stakeholders to support reporting needs.

Analyze Epic data models and ensure alignment with organizational KPIs and quality metrics.

Design, build, and maintain dashboards and recurring operational reports.

Assist in data extraction for regulatory programs (CMS, Meaningful Use, Quality Measures, HEDIS, etc.).

Troubleshoot data discrepancies between Epic Hyperspace, Clarity, and Caboodle.

Participate in testing, validation, documentation, and change-control workflows.

Support enterprise data warehouse initiatives and ETL processes where needed.

Required Skills & Experience

3–5+ years experience as an Epic Report Writer or Epic Data Analyst.

Epic Clarity Data Model certification preferred (any of the following):

Clarity Ambulatory

Clarity Inpatient

Clarity ADT

Clarity ClinDoc

Clarity Resolute HB / PB

Clarity Cadence / Prelude

Strong proficiency in:

SQL (complex joins, CTEs, window functions, query optimization)

Epic Reporting Workbench (RWB)

Radar dashboards

Crystal Reports / Tableau / Power BI

Experience with Caboodle Data Warehouse, STAR schemas, and ETL processes.

Deep understanding of Epic data structures, Chronicles vs. Clarity architecture, and extract tables.

Ability to gather requirements and work independently with SMEs and business users.

Strong documentation skills and familiarity with SDLC/change management workflows.

Healthcare domain expertise (clinical, operational, quality, or revenue cycle).

Preferred Qualifications

Epic Caboodle Certification

Experience in population health, quality reporting, or operational analytics.

Familiarity with cloud data platforms (Snowflake, Azure Synapse, BigQuery, Redshift).

Experience writing reports for leadership dashboards or service-line scorecards.

Background in supporting ambulatory specialty practices or hospital departments.

Compensation The copmpensation range for this role $70hr- $110hr. Pay is based on several factors including but not limited to current market conditions, location, education, work experience, certifications, etc. IKS Health is an equal opportunity employer and does not discriminate based on race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.