MD
Medicaid Data Systems Analyst
Macpower Digital Assets Edge Private Limited
πΊπΈ United States
On-site
5 days ago
$84,000 β $90,000 / year
- Microsoft Purview
- Unity Catalog
- Databricks
- Power BI
- FinOps
- Azure
- IaC
- SSIS
- TFS
- Azure Data Factory
- T-SQL
- Azure Synapse
- SSRS
- Azure Databricks
- Azure DevOps
- Tableau
- Collibra
- Informatica
- Alation
5 days ago
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.
- 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.
- Leading advanced technology or service projects through full system engineering lifecycle.
- Hands-on experience with specific IT platforms/products.
- Strong consulting leadership and full project lifecycle delivery.
- Metadata architecture and governance expertise.
- Collaboration with engineers, architects, and stakeholders on reliability, FinOps, and validation.
- 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.
- Native or bilingual English proficiency.
- DMV-area resident preferred.
- Available for phone/video interview followed by in-person.
Medicaid Data Systems Analyst Β· Macpower Digital Assets Edge Private Limited