Overview
Remote
On Site
Hybrid
BASED ON EXPERIENCE
Accepts corp to corp applications
Contract - W2
Contract - Independent
Skills
Data Warehouse Architecture
Business Intelligence
Data Architecture
Performance Tuning
Data Warehouse
Technical Drafting
Data Integration
Optimization
Extract
Transform
Load
ELT
MMIS
Scalability
Medicaid
Data Validation
Quality Control
Analytics
Dashboard
Reporting
Data Governance
Meta-data Management
Regulatory Compliance
HIPAA
Data Security
Privacy
Collaboration
Information Security
Management
Encryption
Auditing
Job Details
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.