Medicaid Data Systems Analyst

Veteran Firm Seeking a Medicaid Data Systems Analyst for a Hybrid Assignment in Washington, DC

My name is Stephen Hrutka, and I lead a Veteran-owned consulting firm in Washington, DC, focused on strategic sourcing, supply chain, and IT Staffing.

We want to fill a Medicaid Data Systems Analyst role for the DHCF - Department of Health Care Finance in the DC Government.

The ideal candidate is a DMV resident with 5+ years of experience leading advanced technology projects, strong consulting leadership, and full project lifecycle delivery expertise. They should have expert-level T-SQL skills for data auditing and parity testing between SQL Server and Azure Synapse, hands‑on experience with SSIS/SSAS/SSRS, advanced proficiency in Azure Databricks and Azure Synapse, and MMIS data experience including claims (837), eligibility (270/271), and T-MSIS reporting.

If you’re interested, I’ll gladly provide more details about the role and further discuss your qualifications.

Thanks,

HRUCKUS is looking for a Medicaid Data Systems Analyst to assist in the data modernization efforts associated at DHCF.

The Medicaid Data Systems Analyst is the functional anchor for the agency’s data modernization. This role ensures the technical infrastructure remains trustworthy by leading the implementation of an Enterprise Data Catalog and managing the transition of business logic from TFS/SSIS to the Azure/Databricks environment. They act as the "Metadata Architect," ensuring that all raw MMIS schemas are translated into governed, auditable, and BI‑ready assets.

• Business Glossary Ownership:
  Lead the implementation of the Enterprise Data Catalog (e.g., Microsoft Purview or Unity Catalog) from a functional perspective. Define and maintain the business glossary for all Medicaid data.
• Data Lineage Mapping:
  Document and verify end‑to‑end data lineage—from the raw MMIS source table through the transformation layer in Databricks to the final PowerBI report.
• Discovery & Search:
  Organize the catalog so that policy analysts and actuaries can easily discover Medicaid datasets, understand their sensitivity (PHI/PII), and view their update frequency.

• Data Reliability Engineering:
  Support the infrastructure’s health by monitoring Data Quality (DQ) dashboards. Alert the Senior Data Engineer if upstream MMIS schema changes cause data drift or pipeline failures.
• Fin Ops
  
  Collaboration:
  
  Partner with the Senior Data Engineer to analyze cloud consumption. Identify unused or redundant datasets that can be purged or archived to optimize Azure storage and compute costs.
• Infrastructure Validation:
  Verify that the "Infrastructure as Code" deployments (Managed by the Engineer) correctly apply the Row‑Level Security (RLS) and masking rules defined by the Lead Architect.

• Legacy‑to‑Cloud Logic Audit:
  Translate legacy SSIS logic stored in TFS into clear business requirements for the Engineer to rebuild in Azure Data Factory and Databricks.
• Target Mapping:
  Take raw table schemas from the current MMIS and define the "Target" format for the Data Warehouse, ensuring it meets the specific needs of modern BI tools.

• Expert T‑SQL skills for deep‑dive data auditing and parity testing between legacy SQL Server and Azure Synapse.
• Experience with MMIS data, specifically claims (837), eligibility (270/271), and T‑MSIS federal reporting.
• Familiarity with TFS (for reviewing legacy logic) and Azure Dev Ops (for modern project tracking).
• Industry certification/training in specific IT product/platform or service.
• 5 yrs. leading advanced technology projects or service projects.
• Hands‑on experience in specific product or IT platform.
• 5 yrs full system engineering lifecycle.

• Certification in Data Governance (e.g., CDMP) or Cloud Fundamentals (e.g., Azure AZ-900).
• Experience with Power BI or Tableau to validate that transformed data meets visualization requirements.
• Hands‑on experience with Microsoft Purview, Collibra, Informatica and Alation.
• Bachelor’s degree in Information Technology or related field or…