Healthcare Programmer, Medicaid and Pharmacy

American Institutes for Research; Chapel Hill (NC); Hybrid; USD 130,000 - 160,000; Full time

Job summary

American Institutes for Research is seeking a Healthcare Programmer, Medicaid and Pharmacy to manage and analyze complex datasets, implement research design, and support project coordination. The role emphasizes data-driven insights and reporting.

The ideal candidate holds a Bachelor's degree in a quantitative field, 5+ years in healthcare data, and experience with SQL, Python, R, and SAS, with knowledge of Medicaid pricing data a plus. Remote work within the U.S. is offered.

Qualifications

• Bachelor's degree in a quantitative field (Statistics, Data Science, Public Health, Economics, Epidemiology, etc.).
• Minimum of 5 years of experience with large-scale healthcare administrative or claims data.
• Direct experience with Medicare/Medicaid or other claims data.
• Experience with pharmaceutical pricing data or related datasets.
• Proficiency in SQL, Python, and/or R; SAS experience in health research settings is a plus.

Responsibilities

• Extract, recode, merge, and de-duplicate datasets for analysis.
• Conduct outlier analyses, manage missing data, and create derived variables.
• Perform statistical analyses to support research and reporting needs.
• Generate customized reports summarizing data analysis results.
• Produce data listings, tables, and data outputs with high quality.

Skills

Data processing

Communication

Organization

Time management

Multitasking

Analytical thinking

Education

Bachelor's degree

Tools

SQL

Python

R

SAS

Job description

Join AIR as a Healthcare Programmer, Medicaid and Pharmacy with our Healthcare Innovations team. Our team works collaboratively to unravel the intertwined challenges of health care quality, costs, and access. Our team of experts-economists, data scientists, statisticians, public health experts, sociologists, nurses, physicians, and psychologists - advance evidence and save lives by leading rigorous research and evaluation; program implementation and monitoring; results-driven technical assistance and training; and leading-edge data science and technology tools.

The Healthcare Programmer - Medicaid and Pharmacy will apply programming skills to manage, analyze, and report on complex datasets, to implement and support research design, documentation, and project coordination, and to ensure high-quality data-driven insights.

Candidates with expertise with Medicaid policy and data, and/or pharmaceutical pricing and related data sources are especially encouraged to apply.

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

About AIR:

Founded in 1946 and headquartered in Arlington, Virginia, the American Institutes for Research (AIR) is a nonpartisan, not-for-profit organization that conducts behavioral and social science research and delivers technical assistance to address some of the most pressing challenges in the United States and globally. We generate evidence and apply data-driven solutions that expand opportunities and improve lives for all.

Responsibilities

• Extract, recode, merge, and de-duplicate datasets to prepare them for analysis.
• Conduct outlier analyses, manage missing data, and create derived analysis variables.
• Perform statistical analyses to support research and reporting needs.
• Generate customized reports summarizing data analysis results.
• Produce high-quality, computer-generated data listings, summary tables, and data collection outputs.
• Provide technical oversight, mentorship, and training to junior SAS programmers.
• Debug and revise code by identifying and resolving programming errors.
• Write and maintain comprehensive documentation for code, programs, and technical specifications.
• Prepare technical reports and contribute to proposal development.
• Perform other related duties and special projects as assigned.

Qualifications

Education, Knowledge, and Experience

• Bachelor's degree in Statistics, Data Science, Public Health, Economics, Epidemiology, or a related quantitative field.
• Minimum of 5 years of experience working with large-scale healthcare administrative or claims data.
• Direct experience processing and analyzing Medicare, Medicaid, and/or other commercial claims data.
• Direct experience with pharmaceutical pricing data, prescription drug encounter data, or other related data sources.
• Experience using SQL, Python, R and/or other data analysis tools.
• Knowledge of data analysis and data management techniques.
• Experience applying SAS in research or analytical settings, particularly in health or social sciences.
• Knowledge and experience with advanced analytic techniques such as machine learning preferred, but not required.
• Proposal and report preparation experience preferred, but not required.

Skills

• Skilled in all aspects of data processing management.
• Effective communication skills with the ability to collaborate efficiently in a virtual work environment.
• Excellent organizational and time management skills.
• Strong ability to manage multiple tasks and prioritize effectively.
• Adept in a fast-paced environment to manage multiple concurrent deliveries.
• Demonstrated analytical, critical thinking, and problem-solving skills with a focus on details.

Disclosures

Applicants must be currently authorized to work in the U.S. on a full-time basis. Employment-based visa sponsorship (including H-1B sponsorship) is not available for this position. Depending on project work, qualified candidates may need to meet certain residency requirements.

American Institutes for Research is an equal employment opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without discrimination on the basis of any characteristic protected by applicable federal, state or local law, including, but not limited to, actual or perceived race (including traits historically associated with race, such as hair texture, hair type, and protective hairstyles such as braid, locks, and twists), creed, color, religion, alienage or national origin, ancestry, citizenship status, age, physical or mental disability, medical condition (e.g., cancer), sex, gender, gender identity or expression (including transgender status), sexual orientation, marital status, civil union status, pregnancy, childbirth or related medical conditions, genetic information, or military or veteran status. AIR adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo reference and background checks. AIR maintains a drug-free work environment.

ACCESSIBILITY NOTICE

If you need a reasonable accommodation for any part of the employment process due to a physical or mental disability, please send an email to Taliba Boone [e-mail] call 202.403.5000.

Salary Range

Anticipated Annual Salary Range: $130,000 – $160,000 USD