Pursue Your Passion with Purpose Job Washington area,District of Columbia USA,IT/Tech

Medicaid Data Systems Analyst

We are looking for a Medicaid Data Systems Analyst for supporting data modernization efforts. This is an on-site role in Washington, DC and the project is expected to last for 12+ months so our preference is for local applicants. The Medicaid Data Systems Analyst must have a bachelor's degree and 5+ years of relevant experience.

Key Responsibilities:

Lead Enterprise Data Catalog implementation (e.g., Microsoft Purview or Unity Catalog), including business glossary ownership for Medicaid data.
Document and verify end-to-end data lineage from raw MMIS sources through Databricks transformations to PowerBI reports.
Organize catalog for easy discovery by policy analysts, highlighting dataset sensitivity (PHI/PII) and update frequency.
Monitor Data Quality dashboards, alert on MMIS schema changes causing data drift or pipeline failures.
Collaborate on Fin Ops to analyze Azure consumption and purge unused datasets for cost optimization.
Validate Infrastructure as Code deployments for Row-Level Security and masking rules.
Audit and translate legacy SSIS logic from TFS into business requirements for Azure Data Factory and Databricks.
Map raw MMIS schemas to target Data Warehouse formats for BI tools.

Technical

Skills:

Expert T-SQL for data auditing and parity testing between SQL Server and Azure Synapse.
Hands-on with SSIS, SSAS, SSRS, Azure Databricks, and Azure Synapse.
MMIS data experience, including claims (837), eligibility (270/271), and T-MSIS reporting.
Familiarity with TFS for legacy logic review and Azure Dev Ops for project tracking.
Industry certification or training in relevant IT products/platforms/services.

Functional

Skills:

Leading advanced technology or service projects through full system engineering lifecycle.
Hands-on experience with specific IT platforms/products.

Behavioral

Skills:

Strong consulting leadership and full project lifecycle delivery.
Metadata architecture and governance expertise.
Collaboration with engineers, architects, and stakeholders on reliability, Fin Ops, and validation.

Nice-to-Have

Skills:

Certification in Data Governance (e.g., CDMP) or Cloud Fundamentals (e.g., Azure AZ-900).
Experience with Power BI or Tableau for data validation.
Hands-on with Microsoft Purview, Collibra, Informatica, or Alation.

Key Requirements:

Native or bilingual English proficiency.
DMV-area resident preferred.
Available for phone/video interview followed by in-person.