Principal Analyst, Medicaid Policy Analysis

The role

This role analyzes Medicaid policy and turns program rules into analytic logic, such as cohort definitions and stratification criteria. The person builds data marts, registries and dashboards for a state Medicaid agency and advises its leadership on what the data can support.

What you will do

• Interpret state and federal Medicaid program rules, eligibility and aid-code structures, and benefit design into testable analytic logic, and document the interpretation
• Advise senior customer leadership on what the data can and cannot support, and how policy changes affect the data
• Turn policy and operational questions into member and provider data marts and registry extracts in SQL and Python
• Deliver dashboards, recurring reports, Excel and leadership decks in the format the customer needs
• Root-cause data-quality issues, reconcile counts across sources, and agree definitions with the customer's data staff
• Serve as the senior analytic voice for state program leadership, policy staff, prime contractors and vendor partners
• Set priorities, scope and timelines with Customer Management
• Create client-facing materials such as leadership summaries, methodology decks and decision memos

Required qualifications

• Working knowledge of how health programs and managed care plans work
• Ability to turn policy documents and program rules into analytic logic
• Clinical code and claims fluency: ICD-10, CPT/HCPCS, revenue codes
• Experience with claims, eligibility, and provider/NPI data
• Hands-on fluency with AI coding and analysis tools such as Claude Code or Cursor
• Advanced SQL, including CTEs, window functions and performance on large tables
• Data modeling to an engineering standard
• Experience building dashboards and reports in a BI tool such as QuickSight, Power BI or Tableau, and in Excel
• Experience with customer-facing work with senior stakeholders
• Track record of leading an analytic program end to end for senior audiences
• Sound judgment with sensitive data and PHI

Nice to have

• Direct experience with a state Medicaid agency, a Medicaid-serving contractor, or a Medicaid managed care plan
• California Medi-Cal experience
• Familiarity with population health concepts such as risk stratification, registries and network adequacy
• Experience with Python and dbt
• Familiarity with the AWS ecosystem, including Athena, Redshift and QuickSight
• Experience mentoring less experienced analysts

Benefits

• Competitive compensation
• Unlimited FTO
• Employee-driven programs for personal and professional development
• Flexible, remote-friendly work

Before you apply

• Candidates should show what they have built with AI assistance and how they review and validate it

About the company

Arcadia helps providers and payers reduce cost and improve patient health by aggregating large amounts of data and applying algorithms to identify care opportunities. Backed by Nordic Capital, it serves hundreds of organizations.