Medicaid Programmer, Healthcare Innovations

AIR is currently seeking aMedicaid Data Programmer. This role is ideal for a programmer with deep experience working with Medicaid administrative data, including eligibility, enrollment, claims, and managed care encounter data. The Medicaid Data Programmer II will contribute to applied health services research and policy analysis by transforming complex administrative datasets into high-quality analytic files and research-ready outputs.

The ideal candidate will participate in all aspects of project work, including data ingestion, data quality assessment, analytic file development, statistical analysis, and documentation. This position emphasizes Medicaid data expertise, data engineering, and analytic rigor over reliance on any single programming language.

The Medicaid Data Programmerwill report to AIR's Healthcare Innovations Team, which supports high-quality implementation and produces rigorous evidence on the effectiveness of new approaches to care and payment-translating findings into actionable insights for policymakers, payers, providers, and patients.

This position has the flexibility to work remotely within the United States (U.S.) or from one of AIR'sU.S. office locations. This does not include U.S. territories.

Responsibilities:

• Work with large-scale Medicaid administrative datasets, including eligibility, enrollment, claims, encounters, and provider files.
• Extract, clean, recode, merge, and de-duplicate complex administrative data from multiple sources.
• Convert and integrate data across analytic environments and formats (e.g., STATA, R, Python, SQL-based systems, mainframe extracts, or cloud-based platforms).
• Perform data quality checks, logic checks, and validation analyses to ensure accuracy and completeness of analytic datasets.
• Handle missing data, conduct outlier analyses, and construct derived variables and analytic measures.
• Develop research-ready datasets to support health policy analysis, program evaluation, and reporting.
• Produce tables, figures, and customized analytic outputs for internal and external stakeholders.
• Contribute to statistical analyses under the direction of senior researchers.
• Write and maintain clear documentation for data processing steps, analytic decisions, and code changes.
• Troubleshoot and revise existing code and workflows to improve performance, reproducibility, and accuracy.
• Provide technical guidance or informal mentoring to junior programming staff, as appropriate.
• Contribute to technical sections of reports and proposals.
• Perform other related duties as assigned.