Remote Health Data Modeler: EDW & Cloud Modernization

Myticas Consulting Inc.; Illinois; Remote; USD 77,000 - 91,000; Part time

Job summary

Clover Consulting is seeking a Senior Health Data Modeler to support the Illinois EDW program. You will own data models from conceptual to physical, ensuring governance, security, and scalability across large healthcare data sets.

The role spans data architecture, modeling, and collaboration with ETL, BI, and DBA teams to modernize Teradata EDW toward Azure/Snowflake. 12+ month contract with remote work and IL travel as needed.

Qualifications

• 10+ years of IT experience.
• 7+ years in data modeling and data strategy for large health entities.
• 5+ years of knowledge of HIPAA/PHI/PII security standards.

Responsibilities

• Develop long-term data architecture and standards.
• Lead data modeling and data movement initiatives for Medicaid, Medicare, and commercial healthcare data.
• Design conceptual, logical, and physical data models across staging, integration, and presentation layers.
• Define keys, indexes, partitions, constraints, and referential integrity.
• Produce ERDs and data flow diagrams using Erwin or equivalents.

Skills

Data modeling

Data architecture

SQL

HIPAA/PHI/PII

Erwin Data Modeler

Healthcare domain knowledge

Regulatory compliance

Education

BS or MS in Computer Science / BI Systems / Engineering

Tools

Erwin Data Modeler

ER/Studio

SQL Developer Data Modeler

Job description

Clover Consulting is seeking a Senior Health Data Modeler to support the Illinois EDW program. You will own data models from conceptual to physical, ensuring governance, security, and scalability across large healthcare data sets.

The role spans data architecture, modeling, and collaboration with ETL, BI, and DBA teams to modernize Teradata EDW toward Azure/Snowflake. 12+ month contract with remote work and IL travel as needed.