HRUCKUS · 4 hours ago
Medicaid Data Systems Analyst
Washington, DC
Contract
Hybrid
Mid, Senior Level
$84K/yr - $90K/yr
5+ years expHRUCKUS is a Veteran-owned consulting firm focused on strategic sourcing, supply chain, and IT staffing, looking for a Medicaid Data Systems Analyst to assist in data modernization efforts at the DHCF. The role involves leading the implementation of an Enterprise Data Catalog, managing metadata governance, and ensuring data reliability and infrastructure support.
Business DevelopmentIT ManagementManagement Consulting
Hiring Manager
Mandy Arevalo
Responsibilities
Lead the implementation of the Enterprise Data Catalog (e.g., Microsoft Purview or Unity Catalog) from a functional perspective
Define and maintain the business glossary for all Medicaid data
Document and verify end-to-end data lineage—from the raw MMIS source table through the transformation layer in Databricks to the final PowerBI report
Organize the catalog so that policy analysts and actuaries can easily discover Medicaid datasets, understand their sensitivity (PHI/PII), and view their update frequency
Support the infrastructure’s health by monitoring Data Quality (DQ) dashboards
Alert the Senior Data Engineer if upstream MMIS schema changes cause data drift or pipeline failures
Partner with the Senior Data Engineer to analyze cloud consumption
Identify unused or redundant datasets that can be purged or archived to optimize Azure storage and compute costs
Verify that the 'Infrastructure as Code' deployments (Managed by the Engineer) correctly apply the Row-Level Security (RLS) and masking rules defined by the Lead Architect
Translate legacy SSIS logic stored in TFS into clear business requirements for the Engineer to rebuild in Azure Data Factory and Databricks
Take raw table schemas from the current MMIS and define the 'Target' format for the Data Warehouse, ensuring it meets the specific needs of modern BI tools
Qualification
Required
Expert T-SQL skills for deep-dive data auditing and parity testing between legacy SQL Server and Azure Synapse
Experience with MMIS data, specifically claims (837), eligibility (270/271), and T-MSIS federal reporting
Familiarity with TFS (for reviewing legacy logic) and Azure DevOps (for modern project tracking)
Industry certification/training in specific IT product/platform or service
5 yrs. leading advanced technology projects or service projects
Hands-on experience in specific product or IT platform
5 yrs full system engineering lifecycle
Bachelor's degree
Preferred
Certification in Data Governance (e.g., CDMP) or Cloud Fundamentals (e.g., Azure AZ-900)
Experience with Power BI or Tableau to validate that transformed data meets visualization requirements
Hands-on experience with Microsoft Purview, Collibra, Informatica and Alation
Company
HRUCKUS
Hruckus is a management consultancy that offers strategic sourcing, IT strategy, business case analysis and program management services.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase