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.
Numbers & Facts
Location
Washington, DC
Salary
$84,000–$90,000 Per Year
Skills
Analysis Skillsunmatched
Auditingunmatched
Business Intelligence Softwareunmatched
Cisco Unityunmatched
Cloud Computingunmatched
Consultingunmatched
Cost Controlunmatched
Data Analysisunmatched
Data Formatsunmatched
Data Managementunmatched
Data Qualityunmatched
Data Setsunmatched
Data Warehousingunmatched
DevOpsunmatched
English Languageunmatched
Informaticaunmatched
Leadershipunmatched
Medicaidunmatched
Metadataunmatched
Microsoft Product Familyunmatched
Microsoft SQL Serverunmatched
Microsoft Transact-SQL (T-SQL)unmatched
Microsoft Windows Azureunmatched
Multilingualunmatched
Power BIunmatched
Project Lifecycleunmatched
Project Trackingunmatched
Quality Monitoringunmatched
Reporting Dashboardsunmatched
SQL Server Analysis Services (SSAS)unmatched
SQL Server Integration Services (SSIS)unmatched
SQL Server Reporting Services (SSRS)unmatched
System Lifecycleunmatched
Systems Analysisunmatched
Systems Engineeringunmatched
Tableauunmatched
Team Foundation Server (TFS)unmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.