Key Responsibilities: Lead Enterprise Data Catalog implementation (e.g., Microsoft Purview or Unity Catalog), including business glossary ownership for Medicaid data. 5+ years each of experience in below technical skills: Expert T-SQL for data auditing and parity testing between SQL Server and Azure Synapse.
Numbers & Facts
Location
Washington, DC
Salary
$84,000–$90,000 Per Year
Description
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.