In 6 months

• Own the day-to-day analytic workstream — the weekly customer cadence, request prioritization, and same-day ad hoc asks — as a credible presence with state program staff, prime-contractor and vendor counterparts, and data owners, with the current owner stepping back to an oversight role
• Own production-grade registries, data marts, and dashboards, with documented methodology, data dictionaries, and calibration against the customer's published figures
• Bring other analysts up to speed on the work — the data, the logic, and the customer context — starting in your first months, so coverage and capacity extend beyond any one person

In 12 months

• Be the recognized expert on Medicaid program policy and its analytic implications for Arcadia's state program work, trusted with the most ambiguous and highest-stakes questions
• Hold the methodology standard for the body of work — reviewing major deliverables, codifying playbooks, and keeping the work resilient so the account's analytic capability keeps running smoothly as the scope and team grow
• Extend the work into the broader analytic roadmap — cost and utilization, access and equity, care management effectiveness, and state program performance — as scope grows

What You'll Be Doing

• Interpret state and federal Medicaid program rules, eligibility and aid-code structures, benefit and coverage design, and program guidance — translating them into precise, testable analytic logic (cohort definitions, code sets, exclusions, stratification criteria) and documenting the interpretation so decisions are auditable
• Advise senior customer leadership on what the data can and cannot support — whether a proposed definition is measurable, what the volumes look like, what a threshold does to caseload, cost, or provider capacity — and anticipate how policy changes (fee-for-service transitions, waivers, provider network rules) affect the data and the questions ahead
• Turn ambiguous policy and operational questions into member and provider data marts, cohort and stratification logic, and registry extracts — in SQL (and Python where needed) on Foundry and Redshift/Athena
• Deliver them in the format the customer needs — dashboards, recurring reports, Excel, and leadership decks
• Root-cause data-quality issues — reconcile counts across sources, trace bad fields to the source, and agree definitions for undocumented fields and codes with the customer's data staff
• Serve as the senior analytic voice for state program leadership, policy and data staff, prime contractors, and vendor partners — participating in recurring working sessions and translating between policy, operational, and technical audiences
• Set priorities, scope, and timelines with Customer Management, and hold real authority to push back on what is and isn't feasible or worth building
• Create client-facing materials — leadership summaries, detailed methodology decks, decision memos, technical explainers — tailored to audiences from highly technical data counterparts to policy and executive stakeholders

What You'll Need To Have

• Working knowledge of how health programs and managed care plans work, and the ability to turn policy documents and program rules into analytic logic. Direct Medicaid or managed care plan experience is a plus
• Clinical code and claims fluency — ICD-10, CPT/HCPCS, and revenue codes to build clinical cohorts; claims, eligibility, and provider/NPI data (NPPES, enrollment files); and judgment about claims timing and completeness 
• Hands-on, demonstrable fluency with AI coding and analysis tools (Claude Code, Cursor, or similar) as the core of how you work. Picking these tools up quickly and using them heavily is central to how you will onboard and how much you can deliver in this role. Be ready to show us what you have built with AI assistance, how fast you turn work around, and how you review and validate it
• Advanced SQL (CTEs, window functions, performance on large claims and eligibility tables) and data modeling, to a real engineering standard 
• Hands-on experience building dashboards and reports in a BI tool (QuickSight, Power BI, Tableau) and Excel, plus executive-ready decks 
  Direct customer-facing experience with senior stakeholders — comfortable scoping ambiguous requests, navigating competing priorities, and exercising sound analytical judgment about what to build and what the data can support, on short timelines and without close oversight 
  A track record of leading an analytic program end to end for senior customer or executive audiences — setting your own priorities, and operating without a project manager or close direction  
• Sound judgment with sensitive data and PHI  

Would Love For You To Have

• Direct experience with a state Medicaid agency, a Medicaid-serving prime contractor or consultancy, or a Medicaid managed care plan — California Medi-Cal experience is a real plus
• Familiarity with population health concepts: risk stratification, registries, care management, network adequacy, and access and equity analysis
• Experience with Python and dbt; familiarity with the AWS ecosystem and its analytics tools (e.g., Athena, Redshift, QuickSight); comfort with orchestration tooling, Jira, Confluence, and GitHub-based workflows
• Experience mentoring less experienced analysts

What You'll Get

About Arcadia 

Arcadia.io helps innovative providers and payers across the country transform healthcare to reduce cost while improving patient health. We do this by aggregating large amounts of disparate data, applying algorithms to identify opportunities to provide better patient care, and making those opportunities actionable by physicians at the point of care in near-real time. We are passionate about helping our customers drive meaningful outcomes. We are growing fast and have emerged as a market leader in the highly competitive population health management software market and have been recognized by industry analysts KLAS, IDC, Forrester, and Chilmark for our leadership. For a better sense of our brand and products, please explore our website.

Protect Yourself

If you have concerns about the authenticity of a job offer or recruitment-related communication claiming to be from Arcadia, verify it by calling us directly at (781) 202-3600 and selecting option 3. You can find more information at Arcadia Careers.

In this role, you are responsible for following all security policies and procedures to protect all PHI under Arcadia's custodianship, as well as Arcadia intellectual property. For security-specific roles, the hiring manager defines any additional responsibilities.

Arcadia does not discriminate based on race, color, sex (including pregnancy and related conditions, sexual orientation, or transgender status), national origin, religion, age (40 and older), equal pay, disability or genetic information (including family medical history or genetic tests or services), and retaliation for filing a charge, reasonably opposing discrimination, or participating in a discrimination lawsuit, investigation, or proceeding.

Compensation: USD 190,000 – 215,000 per year salary