Reveal HealthTech

Medical Data Analyst – Actuarial Analyst

Reveal HealthTech

full-time

Posted on:

Location Type: Hybrid

Location: Bengaluru • India

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

SQL

About the role

  • Build analytics products: Own the full Power BI lifecycle—data modeling, DAX, visuals, RLS, deployment, and documentation.
  • Enable value-based care (VBC): Define and track measures (e.g., readmissions, avoidable ER/IP, adherence, risk acuity, PMPM/TCOC), attribution logic, and cohorting.
  • Actuarial & contract performance analysis: Support actuarial-oriented analyses including PMPM + risk-adjusted cost modeling, benchmarking, savings reconciliation, trend analysis, and scenario modeling.
  • Data wrangling & QA: Ingest, clean, validate, and reconcile claims, eligibility, EMR, and care-management data.
  • Performance tracking: Build scorecards and drill-downs for executives, clinicians, care teams, actuarial partners, and payer counterparts.
  • Operationalize insights: Create recurring datasets, alerts, and self-service dashboards; document metric definitions, lineage, and reconciliation rules.
  • Governance & compliance: Uphold HIPAA/privacy requirements and contribute to data quality standards.
  • Ad-hoc analysis: Run cohort analyses, payer/provider comparisons, utilization analysis, risk-adjusted benchmarking, leakage patterns, and trend studies.

Requirements

  • 3+ years in healthcare analytics, actuarial services, population health, or payer/provider performance.
  • Strong Power BI (DAX, Power Query/M, data modeling, RLS).
  • Solid SQL (CTEs, window functions, performance tuning) and comfort with large datasets.
  • Hands-on with claims/eligibility (837/835 concepts, CPT/HCPCS/ICD-10, NPI, taxonomy), EMR extracts, and payer/provider data nuances.
  • Experience collaborating with provider groups and payers—requirements gathering, walkthroughs, and iteration.
  • Understanding of value-based care concepts (TCOC, PMPM, savings reconciliation, attribution, risk adjustment, quality measures).
  • Ability to convert ambiguous analytic questions into concrete business metrics with documented methodologies.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Power BIDAXdata modelingSQLCTEswindow functionsclaims dataEMR datarisk-adjusted cost modelingdata wrangling
Soft skills
collaborationrequirements gatheringanalytical thinkingproblem-solvingcommunication