EDW Health Data Modeler

Clover Consulting has a direct client in Springfield, IL in need of an EDW Health Data Modeler for a 12+ months contract. Job details are below. Thank you!

EDW Health Data Modeler

Remote - occasional travel to Illinois possible

12+ months contract, extensions possible

$56 W2 - $66 C2C

Seeking a hands‑on Senior Health Data Modeler to support the Illinois Enterprise Data Warehouse (EDW) within the Enterprise Data Warehouse & Analytics group. The Data Modeler will work with large healthcare datasets and translate the client’s business requirements into enterprise systems, applications, and process designs for large, complex health data solutions.

This role owns the design, governance, and evolution of the conceptual, logical, and physical data models that underpin the EDW platform and its modernization initiatives. It drives and supports initiatives for the IL EDW while participating in the wider EDW group’s focus areas — data usage and governance, information management, privacy and security, data analytics and visualization, and information modeling — bridging the current-state Teradata EDW to the future-state cloud (Azure / Snowflake) architecture.

Working closely with data architects, ETL/data engineers, BI developers, DBAs, and business subject matter experts, the Senior Health Data Modeler ensures data structures are scalable, standards‑compliant, well‑documented, and aligned to enterprise and regulatory requirements across the Health and Human Services ecosystem.

• Develop and deliver long‑term strategic goals for data architecture vision and standards in conjunction with data users, clients, and other key stakeholders.
• Lead data architecture, data modeling, and data movement initiatives to enhance the data warehouse supporting analytics for Medicaid, Medicare, and Commercial healthcare data — including domains such as claims, provider, TPL, and member information subject areas.
• Create an end‑to‑end vision for how logical design translates into one or more physical databases and how data flows through successive stages.
• Document data architecture and the enterprise environment to maintain a current, accurate view that supports a single version of the truth and scales to future analytical needs.

• Analyze and translate business needs into long‑term solution data models; evaluate existing data systems and work with the development team to create conceptual data models and data flows.
• Design and maintain conceptual, logical, and physical data models across staging, integration, and semantic/presentation layers.
• Develop dimensional models (Kimball star/snowflake), normalized (OLTP/3NF), OLAP, and Data Vault patterns; implement Slowly Changing Dimensions, role‑playing dimensions, dimensional hierarchies, surrogate keys, and data classification.
• Define primary/foreign keys, indexes, partitioning, constraints, and referential integrity rules to ensure data quality and performance.
• Produce and maintain entity‑relationship diagrams (ERDs), data flow diagrams, and model documentation using Erwin or equivalent tools.

• Ensure data strategies and architectures are in regulatory compliance; identify where existing policies and procedures require change or where new ones are needed.
• Oversee the mapping of data sources, data movement, interfaces, and analytics with the goal of ensuring data quality.
• Create and maintain data model and metadata policies and procedures for functional design; maintain data dictionaries, business glossaries, and lineage documentation.
• Support classification and protection of sensitive data (PII, PHI) in alignment with HIPAA, PHI, and SOX requirements.

• Provide…