> Markdown version of [/jobs/ext/2034596-senior-data-modeler-enterprise-data-warehouse-remote](https://www.wearedevelopers.com/jobs/ext/2034596-senior-data-modeler-enterprise-data-warehouse-remote). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Modeler - Enterprise Data Warehouse - Remote - **Company:** Unitedhealth Group Inc - **Location:** Chicago, IL, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Data Architecture, Data Dictionary, Data Integrity, Extract Transform Load (ETL), Data Manipulation Languages, Data Mapping, Data Systems, Data Vault Modeling, Data Warehousing, Document-Oriented Databases, Meta-Data Management, Online Analytical Processing, Online Transaction Processing, SQL Databases, Teradata SQL, Data Classification, Snowflake, Data Strategy, Data Layers, Information Technology, Star Schema, Physical Data Models, Azure Synapse Analytics, Data Pipelines, Databricks - **Published:** August 12, 2026 - **Apply:** https://us.experteer.com/career/view-jobs/senior-data-modeler-enterprise-data-warehouse-remote-chicago-il-usa-58916992 ## About the Role modeling and maintain metadata, data dictionaries, and lineage to support a single version of the truth * Contribute to migration of legacy Teradata models to cloud platforms (Azure Synapse / Databricks / Snowflake) and modern cloud target-state designs * Collaborate with ETL architects, SMEs, and other stakeholders to deliver scalable data solutions and ensure data quality and regulatory compliance * Ensure data strategies comply with HIPAA, PHI, and SOX requirements; oversee data mapping, interfaces, and analytics governance * Define keys, indexes, partitioning, constraints, and referential integrity to guarantee data quality and performance * Provide testing criteria and ensure fidelity and performance of data architecture during delivery * Communicate status, risks, and issues to stakeholders and project teams Tasks * 10+ years of IT experience * 7+ years in data modeling, strategy, and roadmaps for large health entities * 5+ years of HIPAA/PHI/PII healthcare data security knowledge * 5+ years of Erwin Data Model or comparable tools * 5+ years of healthcare data domain knowledge (Medicaid, Medicare, Commercial) * 5+ years of SQL with complex analytics, DDL/DML/DCL, optimization * 5+ years of Data Quality, Governance, Metadata Management, MDM, and related areas * Expertise in OLTP/OLAP, Star/Snowflake schemas, SCDs, and data classification Key requirements * remote work flexibility * comprehensive benefits * equity stock purchase * 401k contribution * career development opportunities * incentive and recognition programs ## Description Experteer Overview In this Senior Data Modeler role, you will own the design and governance of data models supporting the Illinois EDW and modernization initiatives. You'll bridge current Teradata systems to cloud platforms, collaborating with data architects, engineers, and business SMEs to deliver scalable, compliant data solutions. You'll shape data architecture, modeling standards, and governance while enabling analytics across Medicaid, Medicare, and Commercial healthcare data. This is a chance to influence large-scale health data strategy and modernization. Compensation / Benefits * Lead data architecture, modeling, and data movement initiatives to support analytics across Medicaid, Medicare, and Commercial healthcare data * Design and maintain conceptual, logical, and physical data models across staging, integration, and semantic layers * Develop and implement dimensional, OLAP, OLTP, and Data Vault patterns with SCDs, surrogate keys, and data classification * Document data architecture and maintain metadata, data dictionaries, and lineage to support a single version of the truth * Contribute to migration of legacy Teradata models to cloud platforms (Azure Synapse / Databricks / Snowflake) and modern cloud target-state designs * Collaborate with ETL architects, SMEs, and other stakeholders to deliver scalable data solutions and ensure data quality and regulatory compliance * Ensure data strategies comply with HIPAA, PHI, and SOX requirements; oversee data mapping, interfaces, and analytics governance * Define keys, indexes, partitioning, constraints, and referential integrity to guarantee data quality and performance * Provide testing criteria and ensure fidelity and performance of data architecture during delivery * Communicate status, risks, and issues to stakeholders and project teams Tasks * 10+ years of IT experience * 7+ years in data modeling, strategy, and roadmaps for large health entities * 5+ years of HIPAA/PHI/PII healthcare data security knowledge * 5+ years of Erwin Data Model or comparable tools * 5+ years of healthcare data domain knowledge (Medicaid, Medicare, Commercial) * 5+ years of SQL with complex analytics, DDL/DML/DCL, optimization * 5+ years of Data Quality, Governance, Metadata Management, MDM, and related areas * Expertise in OLTP/OLAP, Star/Snowflake schemas, SCDs, and data classification Key requirements * remote work flexibility * comprehensive benefits * equity stock purchase * 401k contribution * career development opportunities * incentive and recognition programs ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [OLTP in the Lakehouse: Redefining Data for AI Workloads](https://www.wearedevelopers.com/videos/2038-oltp-in-the-lakehouse-redefining-data-for-ai-workloads) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Best Paying Remote Jobs](https://www.wearedevelopers.com/magazine/255-best-paying-remote-jobs) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)