Medicaid Programmer, Healthcare Innovations at Americaninstitutesforresearch

Americaninstitutesforresearch

Mid LevelFull-timePythonGit

Salary Range

$102,000 - $138,000 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

We are looking for a Medicaid Data Programmer to join our team at the American Institutes for Research (AIR). This role involves working with large-scale Medicaid administrative datasets to transform complex data into high-quality analytic files for health services research and policy analysis.

Key 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.

Requirements

✓Undergraduate degree in Statistics, Epidemiology, Economics, Health Informatics, Computer Science, or a related field.
✓At least 3 years of experience working directly with Medicaid administrative data, including claims and/or encounter data.
✓Strong hands-on experience using one or more programming or analytic languages (e.g., SQL, R, Python, STATA, or similar) to manage and analyze large datasets.
✓Demonstrated experience producing analytic datasets, summary tables, and figures for research or policy projects.
✓Familiarity with Medicaid data structures, coding systems (e.g., ICD, CPT, HCPCS, NDC), and enrollment or eligibility concepts.
✓Experience working with CMS Medicaid and Medicare Research Identifiable Files (RIF) and/or secure data environments (such as the CMS Virtual Research Data Center) preferred, but not required.
✓Experience supporting proposal development or technical write-ups preferred, but not required.