via LinkedIn
$120K - 160K a year
Lead design and maintenance of Medicaid data warehouse architecture, oversee ETL/ELT processes, ensure data quality and compliance with Medicaid and CMS standards, and enforce data governance and security.
Experience in data warehouse architecture, ETL/ELT development, Medicaid and CMS data standards, data governance, and compliance with HIPAA and CMS security requirements.
• Lead the design, implementation, and maintenance of the Medicaid Enterprise Data Warehouse architecture (data models, ETL/ELT pipelines, metadata, and BI layers). • Define and enforce data architecture standards, integration patterns, and performance optimization strategies. • Collaborate with the Data Warehouse Manager and Enterprise Architect to align MEDW technical design with enterprise data strategy and Medicaid business needs. • Provide technical guidance and code reviews for data engineers and developers. • Data Integration & EngineeringOversee the development and optimization of ETL/ELT processes to extract, transform, and load data from MMIS, MCOs, and other Medicaid source systems. Design and maintain logical and physical data models, ensuring scalability and compliance with Medicaid and CMS data standards. Implement data validation, quality control, and reconciliation processes for inbound and outbound data exchanges. Ensure the accuracy and timeliness of data used for analytics, dashboards, and CMS reporting (e.g., T-MSIS, CMS-64, CMS-21). Governance, Security & Compliance • Implement and enforce data governance, lineage tracking, and metadata management standards. • Ensure compliance with HIPAA, CMS, and state data security and privacy requirements. • Collaborate with information security teams to manage user access, encryption, and audit processes.
This job posting was last updated on 11/25/2025