Senior Medicaid Data & Policy Consultant - Remote

Optum; United States; Hybrid; USD 113,000 - 193,000; Full time

Job summary

Optum is seeking a Senior Consultant to support Medicaid data and policy work for CMS Innovation Center's LEAD model. This hands-on role analyzes T-MSIS data, translates policy into data specifications, and develops code for attribution, payments, and quality measures.

The position requires experience with SQL, Python, and Medicaid data, plus the ability to work independently and in teams. Remote work is allowed within the U.S. with in-office four days weekly for Minneapolis or DC area.

Qualifications

• 6+ years of relevant experience with a Master's; or 8+ with a Bachelor's.
• 2+ years direct experience with T-MSIS data.
• Experience in CMS IDR in Snowflake or Databricks.
• Translate policy into data specs and code (attribution, payment, quality).
• Proficient in SQL for building analytic files from large datasets.
• Strong knowledge of Medicaid eligibility, enrollment, and claims data.
• Clear written and verbal communication for technical and non-technical audiences.
• Detail-oriented with accurate, well-documented work.

Responsibilities

• Conduct hands-on analysis of Medicaid data including T-MSIS.
• Translate policy into data specifications and code for core functions.
• Write and test SQL; use Python where appropriate.
• Assess data quality across states and delivery systems.
• Link Medicaid with Medicare data as needed.
• Document specifications, code, data sources, and QA checks.
• Perform QA of analytic outputs and reconcile results.
• Summarize findings for CMS in memos, tables, and slides.
• Share Medicaid data knowledge with colleagues.

Skills

SQL

T-MSIS

IDR

Policy translation

Python

Data analysis

Communication

Independence

Education

Master's or higher in relevant field

Tools

Snowflake

Databricks

Job description

Optum is seeking a Senior Consultant to support Medicaid data and policy work for CMS Innovation Center's LEAD model. This hands-on role analyzes T-MSIS data, translates policy into data specifications, and develops code for attribution, payments, and quality measures.

The position requires experience with SQL, Python, and Medicaid data, plus the ability to work independently and in teams. Remote work is allowed within the U.S. with in-office four days weekly for Minneapolis or DC area.