Medicaid Data Lead

The Opportunity

As a Medicaid Data Lead you provide hands-on technical leadership in designing, developing, and modernizing enterprise data solutions supporting Medicaid programs. To be successful you will bring strong expertise in Databricks, data engineering, cloud-based data architecture, and Medicaid healthcare data, with experience delivering scalable, secure, and reliable solutions.

You will lead data integration and modernization initiatives, optimize data pipelines, and collaborate with cross-functional teams to support Medicaid program operations, analytics, and reporting requirements.

Core Responsibilities

Medicaid Data Engineering & Modernization

• Lead the design, development, and optimization of Medicaid data solutions using Databricks, PySpark, SQL, and Delta Lake.
• Support Medicaid data modernization, migration, reconciliation, and integration across legacy and cloud platforms.
• Work with Medicaid datasets, including eligibility, enrollment, claims, encounters, providers, managed care, and financial data.
• Implement data processing, orchestration, performance optimization, and governance using Databricks capabilities.

Data Architecture, Quality & Compliance

• Design enterprise data models, data pipelines, and integration solutions supporting Medicaid analytics and reporting.
• Establish data quality, validation, reconciliation, and monitoring processes to ensure data accuracy and integrity.
• Implement data security, access controls, metadata management, and data governance practices.
• Ensure solutions align with HIPAA, CMS, and applicable federal and state Medicaid requirements.

Technical Leadership & Collaboration

• Provide technical direction and mentorship to data engineers, developers, and analysts.
• Establish engineering standards, conduct design and code reviews, and resolve complex technical challenges.
• Coordinate technical deliverables and collaborate with program managers, architects, business analysts, and other stakeholders.
• Support successful delivery of Medicaid data modernization and integration initiatives.

Medicaid Analytics & Data Linkage

• Calculate and validate Medicaid program metrics, including service utilization, quality of care measures, payment and expenditure, and enrollment rates.
• Link Medicaid data with Medicare and other data sources (e.g., public health, immunization, vital records, or state program data) to support integrated analyses and reporting.
• Apply sound matching, de-duplication, and reconciliation methods to linked datasets while protecting privacy and complying with data use requirements.
• Document metric definitions, methodologies, and assumptions, and partner with analysts and stakeholders to interpret and communicate results.

What We Value

• 8+ years of experience in data engineering, data integration, data warehousing, or data architecture.
• Strong hands-on experience with Databricks, PySpark, Python, and SQL.
• Experience with Medicaid or healthcare payer data, including claims, encounters, eligibility, enrollment, and provider information.
• Experience developing ETL/ELT pipelines, Delta Lake solutions, or cloud-based data platforms (Azure or AWS).
• Knowledge of enterprise data modeling, data integration, data quality, and performance optimization.
• Experience providing technical leadership on enterprise-scale data engineering initiatives.
• Strong communication, problem-solving, and stakeholder collaboration skills.
• Experience with CMS Medicaid reporting and data standards, including T-MSIS and T-MSIS Analytic Files (TAF).
• Experience with Databricks Unity Catalog, Lakeflow Spark Declarative Pipelines, and Databricks Workflows.
• Databricks Data Engineer Professional or relevant cloud certification.
• Bachelor's degree in Computer Science, Information Technology, or a related field; equivalent relevant experience may be considered.
• Demonstrated experience calculating Medicaid metrics such as utilization, quality of care, payment, and enrollment rates.
• Experience linking Medicaid data with Medicare (e.g., Medicare claims, enrollment, or dual-eligible data) and other external data sources.

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, Inc. 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 $110,000 to $155,000. Salary offers are made based on internal equity and market analysis.

Disclaimer: Abt will never ask candidates for money in exchange for an offer of employment.