Data Analyst, Value-Based Care

Houston Dose; Houston (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

Aarista Technology is seeking a Data Analyst focused on Value-Based Care to transform clinical, claims, and attribution data into actionable reporting for ACO programs. You will monitor quality, cost, and utilization, support CMS and payer reporting, and surface opportunities to improve shared savings and outcomes.

The role requires HIPAA/SOC 2 compliant handling of PHI, proficiency with SQL and BI tools, and collaboration with clinical teams to translate findings into interventions.

Qualifications

• 1+ years of experience in a data analyst or BI role, ideally healthcare.
• Working knowledge of value-based care concepts: attribution, quality measures, risk adjustment and shared savings.
• Experience with healthcare claims data (professional and institutional) and CPT/ICD-10 coding.
• Strong SQL skills, including joins, window functions and performance tuning.
• Hands-on experience with BI tools such as Power BI, Tableau or Looker.
• Proficiency in Excel with pivot tables, lookups and modeling.
• Experience handling PHI or regulated data and access-control procedures.
• Clear written and verbal communication to both clinical and non-technical audiences.
• Bachelor's degree in data analytics, statistics, health informatics, public health or related field, or equivalent experience.

Responsibilities

• Build and maintain dashboards tracking ACO/value-based performance (quality, cost, utilization).
• Produce recurring performance reports for leadership, clinical teams, providers and payer partners.
• Process and analyze CMS data feeds and payer files.
• Reconcile results against CMS/payer reports and explain variances.
• Track quality measures (MSSP, ACO REACH, eCQMs, MIPS/APP).
• Identify care gaps and deliver actionable gap lists to clinical teams.
• Analyze attribution, risk, and cost drivers; monitor cost/utilization.
• Write and maintain SQL queries, views, and data models; validate data accuracy.

Skills

SQL

BI tools

Excel

PHI handling

Communication

Education

Bachelor's degree in data analytics/health informatics/public health

Tools

Power BI

Tableau

Looker

Job description

Data Analyst, (Value-Based Care - must have)

• Location Burnaby, BC or Houston, TX (on-site)
• Employment type Full-time

The Data Analyst, Value-Based Care turns Aarista's clinical, claims and attribution data into the reporting that our value-based care and Accountable Care Organization (ACO) programs run on. You will track quality, cost and utilization performance, support CMS and payer reporting, and surface the opportunities that improve shared savings and patient outcomes. Because our data includes protected health information (PHI), every part of the role runs inside our HIPAA and SOC 2 controls.

Key responsibilities

ACO and value-based care performance reporting

• Build and maintain dashboards that track ACO and value-based contract performance: quality scores, total cost of care, utilization and shared savings or loss.
• Produce recurring performance reports for leadership, clinical teams, participating providers and payer partners.
• Process and analyze CMS data feeds, including Claim and Claim Line Feed (CCLF) files and assignment/attribution reports, plus commercial and Medicare Advantage payer files.
• Reconcile internal results against CMS and payer reports and explain variances.

Quality measures

• Track and report quality measures for programs such as the Medicare Shared Savings Program (MSSP) and ACO REACH, including eCQMs and MIPS/APP measures.
• Identify care gaps (e.g., missed screenings, annual wellness visits, chronic condition management) and deliver actionable gap lists to clinical teams.
• Support annual quality reporting submissions with accurate, auditable data.

Attribution, risk and cost analysis

• Analyze beneficiary attribution, panel changes and leakage to out-of-network providers.
• Monitor risk adjustment and HCC coding completeness, and flag documentation gaps.
• Analyze cost and utilization drivers such as ED visits, inpatient admissions, readmissions and post-acute and skilled nursing stays.
• Build benchmark and financial projections to estimate shared savings performance.

Data quality and governance

• Write and maintain SQL queries, views and data models that combine claims, EMR and attribution data.
• Validate data accuracy, investigate discrepancies and work with Engineering to fix root causes.
• Maintain a data dictionary and document measure logic, data sources and lineage in SharePoint.

Security and compliance

• Handle PHI and CMS beneficiary data under the HIPAA minimum-necessary standard and CMS

Data Use Agreement (DUA) terms.

• Follow Aarista's SOC 2 access-control and change-management procedures for data and reports.
• Support audits and program compliance reviews with accurate, reproducible data pulls.

Stakeholder support

• Partner with clinical, care management and operations teams to turn findings into interventions.
• Take requests through a defined intake process and set clear priorities and timelines.
• Train users on self-service reports and dashboards.

Required qualifications

• 1+ years of experience in a data analyst or business intelligence role, ideally in healthcare.
• Working knowledge of value-based care concepts: attribution, quality measures, risk adjustment and shared savings.
• Experience working with healthcare claims data (professional and institutional) and CPT/ICD-10 coding.
• Strong SQL skills, including joins, window functions and query performance tuning.
• Hands-on experience with a BI tool such as Power BI, Tableau or Looker.
• Proficiency in Excel, including pivot tables, lookups and modeling.
• Experience working with PHI or other regulated data and following access-control procedures.
• Clear written and verbal communication, including explaining findings to clinical and non-technical audiences.
• Bachelor's degree in data analytics, statistics, health informatics, public health or a related field, or equivalent experience.

Preferred qualifications

• Direct experience supporting an ACO in MSSP, ACO REACH or a commercial or Medicare Advantage value-based contract.
• Experience with CMS CCLF files, beneficiary assignment reports and quality reporting submissions.
• Familiarity with HCC risk adjustment models, HEDIS, eCQMs and MIPS/APP reporting.
• Familiarity with skilled nursing or post-acute care settings.
• Python or R for data cleaning, automation and statistical analysis.
• Experience with FHIR or HL7 data structures.
• Experience with cloud data warehouses and modern data tools (e.g., Databricks, Microsoft Fabric).

About Aarista

Aarista Technology builds healthcare software used by clinical teams every day. Our data shapes patient care, value-based performance and product decisions, and we protect it as carefully as we use it.

Aarista Technology LLC is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other protected characteristic.