Epic Tapestry Reporting Analyst

Overview

A new Medicare Advantage health plan launching in 2025 is seeking a hands-on Business Analyst with strong Epic Tapestry and SQL/reporting expertise. This role supports reporting, data validation, and CMS-related analytics. The ideal candidate combines deep Tapestry knowledge, Medicare Advantage/CMS experience, and advanced SQL/report-building skills.

Key Responsibilities

• Meet with business stakeholders to gather requirements and translate them into actionable reporting and data solutions.
• Design, build, test, and deliver reports, dashboards, extracts, and datasets.
• Work with Epic data models (Clarity, Caboodle) to support Medicare Advantage reporting needs.
• Perform data validation, QA, troubleshooting, and root-cause analysis.
• Support CMS/Medicare Advantage reporting, submissions, and data quality checks.
• Collaborate with IT, finance, operations, and clinical teams to deliver accurate and timely analytics.
• Maintain documentation, including KPIs, data models, inventories, and BI assets.
• Support system and Epic upgrades, assessing impacts on existing BI/reporting solutions.
• Provide user training and support on dashboards, data tools, and analytics assets.

Required QualificationsEpic Tapestry Experience

• 3+ years of hands-on experience with Epic Tapestry in at least one of the following areas:
• Claims
• Benefits/Eligibility
• Membership
• Encounters/Workflows
• Tapestry → Clarity reporting, integration, or data validation

SQL & Reporting

• Strong SQL skills: able to write, modify, and optimize queries.
• Experience building or modifying reports, dashboards, and datasets.
• Ability to perform in-depth data validation and QA.
• Experience with reporting tools such as Power BI, Tableau, SSRS, Excel.

Medicare Advantage / CMS Expertise

• 5+ years working in Medicare Advantage.
• Knowledge of HCC coding, risk adjustment, and the 837 submission process.
• Familiarity with MAO, MOR, MMR files and CMS data requirements.

Preferred Qualifications

• Epic Certifications (Tapestry, Clarity, or other Epic modules).
• Experience with Epic Caboodle, Clarity Data Marts, and advanced Epic reporting tools.
• Experience with Epic Reporting Workbench, Radar Dashboards, or Slicer Dicer.

Tools & Technologies

• SQL
• Power BI, Tableau, SSRS, Excel
• Epic Clarity & Caboodle
• Reporting Workbench, Radar, Slicer Dicer

Soft Skills

• Strong verbal and written communication skills.
• Ability to translate technical concepts for non-technical users.
• Highly organized, detail-oriented, and able to work independently.
• Effective collaborator across multidisciplinary teams.

Job Type: Contract

Pay: $ $65.00 per hour

Application Question(s):

• Provide an example of a reporting or CMS-related project where you personally wrote SQL queries, validated Tapestry/Clarity data, and supported Medicare Advantage workflows (e.g., HCC, 837 submissions, MOR/MMR files). What was your role and the SQL work you did?
• Describe your hands-on experience with Epic Tapestry. Specifically, which Tapestry areas have you worked with (claims, benefits/eligibility, membership, encounters, reporting, Clarity validation), and what were your day-to-day responsibilities?

Work Location: Remote