Medicaid Data Analyst: T-MSIS Insights & Validation

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

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.