Medicaid Data Analyst

Abt Global; United States; On-site; USD 73,000 - 93,000; Full time

Job summary

TSPi, a division of Abt Global, is seeking a Medicaid Data Analyst to support data analysis, quality validation, and reporting using T-MSIS data and TAF. The role will leverage Databricks and programming languages such as SQL and PySpark to analyze complex healthcare datasets and deliver actionable findings.

The analyst will collaborate with technical and program teams to ensure accuracy, consistency, and reliability of Medicaid data used for research, reporting, and CMS oversight.

Qualifications

• Bachelor's degree or equivalent experience in a relevant field.
• 3+ years of experience or a Master’s degree with relevant experience.
• Proficiency in SQL and/or PySpark for data extraction, transformation, and analysis.
• Experience with large healthcare or administrative claims data.
• US work authorization with ability to obtain Public Trust clearance.

Responsibilities

• Analyze Medicaid T-MSIS and TAF data for enrollment, eligibility and utilization.
• Develop and execute SQL/PySpark queries and data workflows in Databricks.
• Perform data profiling, validation, and quality assurance on Medicaid data.
• Assess trends, beneficiary characteristics, service utilization, and claims patterns.
• Identify data anomalies and document quality issues; ensure data governance compliance.
• Support CMS analytical initiatives and data security requirements.

Skills

SQL

PySpark

Data analysis

Education

Bachelor's degree or equivalent in CS/Analytics/Statistics/Math/Public Health

Tools

Databricks

Job description

The Opportunity

TSPi, a division of Abt Global, is seeking a

Job Description

The Opportunity

TSPi, a division of Abt Global, is seeking a Medicaid Data Analyst to support data analysis, quality validation, and reporting activities using Medicaid Transformed Medicaid Statistical Information System (T-MSIS) data and T-MSIS Analytic Files (TAF). The ideal candidate will have hands-on experience working with large-scale Medicaid enrollment, eligibility, and claims data to evaluate healthcare utilization, identify data quality issues, and support CMS analytical initiatives.

This role will leverage Databricks and programming languages such as SQL and PySpark to analyze complex healthcare datasets, develop and execute data validation procedures, and produce actionable analytical findings. The analyst will collaborate with technical and program teams to ensure the accuracy, consistency, and reliability of Medicaid data used for research, reporting, and program oversight.

Key Responsibilities

• Analyze Medicaid T-MSIS and T-MSIS Analytic Files (TAF) to support enrollment, eligibility, healthcare utilization, and data quality assessments.
• Develop and execute analytical queries and data processing workflows using SQL and/or PySpark within Databricks.
• Perform data profiling, validation, and quality assurance to assess the completeness, accuracy, consistency, and reliability of Medicaid data.
• Analyze Medicaid enrollment trends, beneficiary characteristics, service utilization, and claims patterns across states and reporting periods.
• Identify, investigate, and document data anomalies, discrepancies, and potential quality issues within T-MSIS and TAF datasets.
• Support compliance with applicable healthcare data security, privacy, and governance requirements.

Required Qualifications

• Bachelor's degree in Computer Science, Data Analytics, Statistics, Mathematics, Public Health, Health Informatics, or a related field, or equivalent qualifying experience.
• Minimum of 3 years of relevant experience, or a Master's degree with relevant experience.
• Programming experience with SQL and/or PySpark for data extraction, transformation, validation, and analysis.
• Experience working with large healthcare or administrative claims datasets.
• Strong analytical, problem-solving, and technical documentation skills.
• US work authorization required and the ability to obtain and maintain a Public Trust clearance, which may include fingerprinting.

Preferred Qualifications

• Experience working with CMS Medicaid data systems, data quality initiatives, or federal healthcare analytics programs.
• Familiarity with T-MSIS and TAF data structures, file layouts, data dictionaries, and data quality requirements.
• Experience analyzing Medicaid beneficiary enrollment, eligibility categories, managed care enrollment, and healthcare service utilization.
• Experience working with Medicaid claims and encounter data, including inpatient, outpatient, pharmacy, and long-term services and supports.
• Experience with Python or other statistical programming tools.Understanding of Medicaid program operations, healthcare claims processing, and federal healthcare reporting requirements.
• Familiarity with healthcare data privacy, security, and governance practices.

What We Offer

We foster an environment where you can Thrive Your Way. Our innovative total rewards programs are designed to help balance your work and personal life. The approach toward your wellbeing centers around comprehensive benefits, flexible schedules, and professional development. TSPi, a Division of Abt Global is an Equal Opportunity employer committed to fostering an inclusive work environment. Abt provides market-competitive salaries and comprehensive employee benefits. This position offers an anticipated annual base salary range of approximately$73,000 to$93,000and may vary by ten percent depending on candidate geographic location. Salary offers are made based on internal equity and market analysis.