Senior Health Data Modeler – Remote EDW

Myticas Consulting Inc.; Springfield (IL); Remote; USD 116,000 - 137,000; Full time

Job summary

Clover Consulting currently seeks a Senior EDW Health Data Modeler for a 12+ month contract, with remote work and occasional travel to Illinois. You will own the design of conceptual, logical, and physical data models for the Illinois EDW, aligning with governance, security, and regulatory requirements across Medicaid, Medicare, and Commercial datasets.

You will collaborate with data architects, ETL/data engineers, BI developers, and business SMEs to deliver scalable, compliant data solutions

Qualifications

• 10+ years IT experience with data modeling in healthcare environments.
• 5+ years in HIPAA/PHI/PII security and regulatory compliance.
• Strong SQL and data governance experience.

Responsibilities

• Design conceptual/logical/physical data models for the EDW, including Dimensional models.
• Govern data architectures, standards, and documentation to support analytics.
• Migrate legacy Teradata models to cloud platforms (Azure/Snowflake).
• Collaborate with ETL, BI, DBAs and business SMEs across projects.

Skills

Data modeling

SQL

Healthcare domain

Dimensional modeling

Data governance

Teradata

Azure

Snowflake

ETL tooling

Education

BS or MS in CS/IS/Engineering

Tools

Erwin

ER/Studio

Job description

Clover Consulting currently seeks a Senior EDW Health Data Modeler for a 12+ month contract, with remote work and occasional travel to Illinois. You will own the design of conceptual, logical, and physical data models for the Illinois EDW, aligning with governance, security, and regulatory requirements across Medicaid, Medicare, and Commercial datasets.

You will collaborate with data architects, ETL/data engineers, BI developers, and business SMEs to deliver scalable, compliant data solutions