AIR is currently seeking a Medicaid 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 Programmer will 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’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: - 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. Qualifications: Education, Knowledge, and Experience - 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. Skills - Strong data management and data processing skills. - Excellent attention to detail and commitment to data accuracy and documentation. - Strong organizational and time-management skills. - Ability to clearly communicate technical concepts to non-technical audiences. - Strong interpersonal skills and ability to collaborate effectively in a multidisciplinary team environment. - Ability to learn new tools, data structures, and analytic approaches quickly. - Experience applying data programming skills in a health policy or health services research context preferred. 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 age, race, color, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability. 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 at tboone@air.orgor call 202.403.5000. Fraudulent Job Scams Warning & Disclaimer: AIR is aware of individuals falsely presenting themselves as AIR representatives. Fraudulent job scams seek to extract sensitive information or money from victims. To protect yourself, please be aware that AIR recruitment will only email you from an “@air.org” domain. Please take extra caution while examining the email address, for example jdoe@air.org is correct and jdoe@aircareers.org is not a legitimate AIR email address. If you are unsure of the legitimacy of a communication you have received, please reach out torecruitment@air.org. If you see a job scam, or lose money to one, report it to the Federal Trade Commission (FTC) atReportFraud.ftc.gov. You can also report it to your state attorney general. Find out more about how to avoid scams atftc.gov/scams. #LI-AS1 #LI-REMOTE AIR’s Total Rewards Program, is designed to reward our staff competitively and motivate them to achieve our critical mission. This position offers the anticipated annual salary as listed. Salary offers are made based on internal equity within the institution and external equity with competitive markets. Please note this is the annual salary range for candidates that are based in the United States. Anticipated Annual Salary Range $12,500—$166,800 USD

Role: Senior Data Engineer Remote Work *Must be a US Citizen & have a USA Passport Primary Responsibilities: - Design, develop, and maintain scalable data pipelines using Python, PySpark, and other modern programming languages to support both batch and streaming workloads - Build and optimize data processing frameworks on cloud platforms such as Databricks or Snowflake, ensuring performance, reliability, and cost efficiency - Design and implement robust data models, including transactional (OLTP) and dimensional (OLAP) schemas, to support analytics, reporting, and application integration - Develop high quality SQL code including complex queries, stored procedures, and views, with a focus on performance tuning and efficient data access patterns - Create and manage workflow orchestration using Apache Airflow or similar tools, ensuring reliable scheduling, dependency management, and monitoring - Implement and enforce data governance and metadata standards through tools such as Microsoft Purview, including data lineage, classification, cataloging, and security policies - Build automated data quality and validation frameworks to ensure accuracy, completeness, and reliability of production datasets - Collaborate with cross functional teams including data architects, analysts, scientists, and business stakeholders to understand requirements and deliver scalable, well designed data solutions - Lead technical design sessions and code reviews, promoting engineering best practices, reusability, and maintainability - Support cloud infrastructure and DevOps practices, including CI/CD pipelines, version control, testing automation, and environment management - Monitor and troubleshoot production data pipelines, proactively addressing issues, performance bottlenecks, and system failures - Contribute to the evolution of the enterprise data platform, recommending tools, frameworks, and architectures to improve scalability and efficiency You’ll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in. Required Qualifications: - 7+ years of experience in data engineering, software engineering, or similar disciplines - Hands-on experience with Databricks or Snowflake - Experience with orchestration tools such as Apache Airflow - Experience working with cloud ecosystems (Azure preferred; AWS/GCP acceptable) - Advanced SQL skills and experience with OLTP and OLAP data modeling - Solid understanding of modern data warehousing, data lake, and ELT/ETL design patterns - Familiarity with data governance tools, especially Microsoft Purview - Solid programming expertise in Python, PySpark, or similar languages - If you are offered this position, you will be required to provide extensive personal information to obtain and maintain a suitability or determination of eligibility for a Confidential/Secret or Top Secret security clearance as a condition of your employment - United States Citizenship Preferred Qualifications: - Healthcare industry experience, including claims, clinical, FHIR, HL7, or provider data - Experience with containerization (Docker, Kubernetes) for data workloads - Experience supporting machine learning workflows or analytical data science pipelines - Knowledge of distributed computing concepts and performance tuning This is a remote position.

Role: Senior Data Engineer Remote Work: INDIA *Only Consultants local to INDIA are eligible. *No visa Sponsorship Primary Responsibilities: - Design, develop, and maintain scalable data pipelines using Python, PySpark, and other modern programming languages to support both batch and streaming workloads - Build and optimize data processing frameworks on cloud platforms such as Databricks or Snowflake, ensuring performance, reliability, and cost efficiency - Design and implement robust data models, including transactional (OLTP) and dimensional (OLAP) schemas, to support analytics, reporting, and application integration - Develop high quality SQL code including complex queries, stored procedures, and views, with a focus on performance tuning and efficient data access patterns - Create and manage workflow orchestration using Apache Airflow or similar tools, ensuring reliable scheduling, dependency management, and monitoring - Implement and enforce data governance and metadata standards through tools such as Microsoft Purview, including data lineage, classification, cataloging, and security policies - Build automated data quality and validation frameworks to ensure accuracy, completeness, and reliability of production datasets - Collaborate with cross functional teams including data architects, analysts, scientists, and business stakeholders to understand requirements and deliver scalable, well designed data solutions - Lead technical design sessions and code reviews, promoting engineering best practices, reusability, and maintainability - Support cloud infrastructure and DevOps practices, including CI/CD pipelines, version control, testing automation, and environment management - Monitor and troubleshoot production data pipelines, proactively addressing issues, performance bottlenecks, and system failures - Contribute to the evolution of the enterprise data platform, recommending tools, frameworks, and architectures to improve scalability and efficiency Required Qualifications: - 5+ years of experience in data engineering, software engineering, or similar disciplines - Hands-on experience with Databricks or Snowflake - Experience with orchestration tools such as Apache Airflow - Experience working with cloud ecosystems (Azure preferred; AWS/GCP acceptable) - Advanced SQL skills and experience with OLTP and OLAP data modeling - Solid understanding of modern data warehousing, data lake, and ELT/ETL design patterns - Familiarity with data governance tools, especially Microsoft Purview - Solid programming expertise in Python, PySpark, or similar languages Preferred Qualifications: - Healthcare industry experience, including claims, clinical, FHIR, HL7, or provider data - Experience with containerization (Docker, Kubernetes) for data workloads - Experience supporting machine learning workflows or analytical data science pipelines - Knowledge of distributed computing concepts and performance tuning

Are you passionate about transforming raw data into meaningful insights? Do you thrive in a collaborative, innovation‑driven environment? Become a Data Engineer at Royal Credit Union! In this role, you’ll help build our cloud‑based Business Intelligence platform, solve complex analytical challenges, and create data systems that empower teams across the organization. Why Royal? - Member and Community Focused: We are dedicated to making a positive impact on our Members and the communities we serve, going beyond financial services to enrich lives and foster growth. - Supportive Environment: Join a collaborative, values-driven workplace that is always evolving. We support each other and work together to achieve our goals. - Professional Growth: We offer numerous opportunities for training and advancement, helping you continuously develop and advance your skills. - Empowerment: We empower our team members to make decisions and drive initiatives that help our Members achieve their financial goals. Your ideas and contributions are valued and encouraged. - Community Involvement: Engage with your local community through various initiatives and events, making a tangible difference where you live and work. Be part of something bigger. What You’ll Do: The Data Engineer will work in a team that is building the Business Intelligence platform at Royal. This includes the use of various methods to analyze and transform raw data into useful cloud-based data systems. Involving increasingly complex level of data and statistical analysis in support of creating and shaping data systems, pipelines, and other business-related activities. Resolutions may require more in-depth quantitative analysis with non-routine solutions. Support line of business for all quantitative needs to include leading mid-size initiatives. Our Commitment To You: - Compensation: $99,600 - $131,900 (candidates with significant related experience may be higher. pay also depends on candidates location) - Benefits: Royal is proud to take care of our team members and their families! In addition to our comprehensive medical, dental, and vision insurance plans, Royal offers a 5% 401k employer match, paid family and sick leave, vacation and sick time accruals, childcare reimbursement, tuition and student loan debt assistance, pet insurance, and much more! What’s Needed For This Position: - Bachelor’s Degree or the Equivalent in Experience in software engineering, data engineering, data science, information systems, computer science, mathematics, machine learning, or related field of study - Three years’ experience in data engineering, data science, or software engineering experience, including knowledge of extensive data ecosystem - Must be bondable - Advanced data architecture and system design expertise, including experience working with multiple file structures (flat files, JSON, XML), building and maintaining cloud-based data systems, and developing scalable data infrastructures, pipelines, and warehouses. - Proficiency in modern programming and analytical tools, including strong skills in SQL, R, and/or Python, data management principles, and implementing cloud-based analytic solutions (AWS, Azure, etc.). - Strong data connectivity and integration capabilities, including working with APIs (REST/SOAP), ODBC/JDBC, HTTP webhooks, and overseeing data cleansing, standardization, and advanced analytic solution development. - Effective communication and collaboration abilities, including summarizing technical concepts for non‑technical audiences, working within Agile environments (Azure DevOps), using version control (Git, Kubernetes), and contributing to cross-departmental documentation and process improvement. - Exceptional problem‑solving and adaptability, with the ability to perform root‑cause analysis, handle ambiguity, juggle multiple projects, embrace change, and leverage technology solutions while respecting confidentiality and security standards. We’d Love To See: - Experienced in implementing Data and Advanced Analytic solutions, or related experience in the Cloud (AWS, Azure, etc.) - Experience implementing an end-to-end Cloud native platform for Datawarehouse (Snowflake, Databricks, Big Query, Redshift, etc.) - Experience with data connectivity methodologies such as APIs (Rest/Soap), ODBC/JDBC, HTTP web hooks, JSON, etc. - Intermediate experience with data management principles Work Schedule: - This is a full-time, exempt level position. Hours will generally be Monday through Friday, 8:00am – 5:00pm with occasional evening and weekend hours, as needed. - This position is eligible to be fully remote within the United States. Please note - Royal Credit Union reserves the right to determine remote status eligibility and the state we allow team members to work from. Training: - Prior to starting a normal work schedule, new Royal team members must attend Foundation Training at our Corporate Center in Eau Claire, WI from 9:00am - 4:30pm on Monday and Tuesday during their first week of employment. Out of town learners will be reimbursed costs related to travel and lodging. - Foundation Training covers fundamental information about Royal’s culture and core values which sets the stage for team members to be successful within our organization. Ready to make a positive impact? APPLY NOW if you are ready to take on this exciting challenge and become a part of the Royal Credit Union family!