Technical Lead - Medicaid Enterprise Data Warehouse (MEDW) - Remote

Medicaid Enterprise Data Warehouse Architect

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.

Oversee 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).

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.