Job Overview: We are looking for Medicaid Data Systems Analyst for supporting data modernization efforts. This is on-site role in Washington, DC and project is expected to for 12+ months so our preference is locals applicants. Medicaid Data Systems Analyst must have 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 FinOps 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.
5+ years each of experience in below 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 DevOps 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, FinOps, 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.