ADC Management Solutions · 16 hours ago
Medicaid Data Systems Analyst
DC - Washington, DC 20010
Full-time
Onsite
Mid, Senior Level
$40/hr - $55/hrADC Management Solutions is a small woman-owned business located in Washington, DC, offering IT consulting and administrative solutions to Government and Commercial Clients. The Medicaid Data Systems Analyst is responsible for leading the implementation of an Enterprise Data Catalog and managing the transition of business logic to the Azure/Databricks environment, ensuring the technical infrastructure remains trustworthy.
Human Resources
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
Leads the adoption or implementation of an advanced technology or platform
Expert on the functionality or usage of a particular system, platform, or technology product
Serves as a consultant to clients, guiding the efficient use or adoption of a particular IT product or platform
Creates implementation, testing, and/or integration plans
Demonstrates expertise in a particular IT platform or service, allowing for maximum IT investment
Qualification
Required
Bachelor's degree in Information Technology or related field or equivalent experience
Training or certification in a particular product or IT platform/service, as required
Must be able to pass a criminal history background investigation and fingerprinting
Benefits
Solid benefits package
Company
ADC Management Solutions
ADC is a woman and minority-owned human capital outsourcing company providing consulting and administrative management solutions.
Founded in 2003
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Kodjo G Ahiake
Controller/CFO
M. Harrison Boyd
Vice President, Chief Operating Officer
Company data provided by crunchbase