Sign upLog in

Medicaid Data Systems Analyst

Macpower Digital Assets Edge Private Limited

Washington, DC

Apply
JOB DETAILS
SALARY
$84,000–$90,000 Per Year
SKILLS
Analysis Skills, Auditing, Business Intelligence Software, Cisco Unity, Cloud Computing, Consulting, Cost Control, Data Analysis, Data Formats, Data Management, Data Quality, Data Sets, Data Warehousing, DevOps, English Language, Informatica, Leadership, Medicaid, Metadata, Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Multilingual, Power BI, Project Lifecycle, Project Tracking, Quality Monitoring, Reporting Dashboards, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), System Lifecycle, Systems Analysis, Systems Engineering, Tableau, Team Foundation Server (TFS)
LOCATION
Washington, DC
POSTED
9 days ago
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.

About the Company

M

Macpower Digital Assets Edge Private Limited

Resume Resources

Free Resume TemplatesFree Resume Builder