Medicaid Data Analyst

Abt Global•Rockville, AL

1d•Remote

About The Position

TSPi, a division of Abt Global, is seeking a Medicaid Data Analyst to support data analysis, quality validation, and reporting using Medicaid Transformed Medicaid Statistical Information System (T-MSIS) data and T-MSIS Analytic Files (TAF). The role analyzes large-scale Medicaid enrollment, eligibility, and claims data to evaluate healthcare utilization, identify data quality issues, and support CMS analytical initiatives. The analyst uses Databricks and programming languages such as SQL and PySpark to analyze complex healthcare datasets, develop and execute data validation procedures, and produce actionable findings. The analyst collaborates with technical and program teams to ensure the accuracy, consistency, and reliability of Medicaid data used for research, reporting, and program oversight. The position requires a bachelor's degree in a relevant field or equivalent qualifying experience, along with at least three years of relevant experience; a master's degree with relevant experience is also listed. Candidates must have US work authorization and be able to obtain and maintain a Public Trust clearance, which may include fingerprinting. The anticipated annual base salary range is approximately $73,000 to $93,000, with potential variation of ten percent depending on candidate geographic location. Salary offers are based on internal equity and market analysis. The employer describes comprehensive benefits, flexible schedules, and professional development, and identifies the position as remote in the posting.

Requirements

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.
Ability to obtain and maintain a Public Trust clearance, which may include fingerprinting.

Nice To Haves

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.

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 Medicaid data completeness, accuracy, consistency, and reliability.
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 in T-MSIS and TAF datasets.
Support compliance with applicable healthcare data security, privacy, and governance requirements.
Collaborate with technical and program teams to ensure the accuracy, consistency, and reliability of Medicaid data used for research, reporting, and program oversight.