> Markdown version of [/jobs/ext/2709497-senior-healthcare-data-architect-lead-data-modeler-healthcare-sql](https://www.wearedevelopers.com/jobs/ext/2709497-senior-healthcare-data-architect-lead-data-modeler-healthcare-sql). 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 Healthcare Data Architect / Lead Data Modeler (Healthcare, SQL) - **Company:** zuven Technologies - **Location:** Eden Prairie, MN, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Data Analysis, Microsoft Azure, Clinical Data Repository, Databases, Data Definition Language, Data Governance, Data Integration, Data Manipulation Languages, Data Migration, Data Profiling, Data Security, Data Systems, Data Warehousing, DIGITAL Command Language, Dimensional Modeling, Information Management, Information Model, Meta-Data Management, Online Analytical Processing, Online Transaction Processing, Query Optimization, Power BI, Standard Sql, Azure Data Lake, Service-Oriented Architecture, SQL Stored Procedures, SQL Databases, Tableau (Software), Data Classification, Azure Data Factory, Snowflake, Data Strategy, Usage Tracking, Data Analytics, Data Management - **Published:** September 4, 2026 - **Apply:** https://www.careerjet.com/jobad/us88fd0a560d15d5c377cbbcabd10c2637 ## About the Role Strong problem solving, influencing, communication, and presentation skills, self-starter. Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client. Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards. Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets. Expertise with normalized OLTP, OLAP, MDM and Dimensional modeling techniques, Star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification. Expert level SQL skills with direct experience writing complex analytic queries, stored procedures, DDL, DML and DCL. Thorough knowledge of query optimization techniques with the ability to write code to ANSI standards and inspect code written by other developers. Expertise in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival and Data Migration strategies using appropriate tools. 13. What skills/attributes are preferred (what will set a candidate apart)? Experience with Microsoft Azure cloud infrastructure and services (Azure Data Lake Storage, Azure Data Factory, Purview, Azure Maps, etc.) Experience with Snowflake DBMS Experience with PowerBI or Tableau 14. Does this position require a professional license or certification? ## Description 12. What skills/attributes are required (please be detailed as to number of years of experience for each skill)?, Optum is currently seeking a hands-on Senior Health Data Modeler to support our CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Modeler will work with large healthcare datasets and will translate client's business requirements into enterprise systems, applications, or process designs for large complex health data solutions. The role will drive and support initiatives for the CT EDW as well as participate in the wider EDW group's areas of data usage and governance, information management, privacy and security, SOA, data analytics and visualization and information modeling. 16. What does the ideal candidate background look like (ex: healthcare specific background, etc.)? We want to be as specific as possible with our firms so they can find the type of candidate you're looking for. Data modeler with Medicaid/Healthcare experience 17. Of the required skills listed, which would you consider the top 3? Please list your expectations regarding years of experience for each requirement. Strong problem solving, influencing, communication, and presentation skills, self-starter. Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client. Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards. Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets. 5+ years of experience with Erwin data modeler 18. What experience will set candidates apart from one another? Data modeler with Medicaid/Healthcare experience 20. What does the team structure look like how many members and what is the break-down of the team's skill sets (ex: 1 PM, 4 Developers, etc.)? Data Manager, Data Modeler, Data Integration Lead, Data Engineers 21. What does the interview process look like? a. How many rounds? 3 b. Video vs. phone? Video c. How technical will the interviews be? Very ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [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) - [ZEISS & Microsoft - Building the Next Generation Medical Ecosystem in the Cloud](https://www.wearedevelopers.com/videos/424-zeiss-microsoft-building-the-next-generation-medical-ecosystem-in-the-cloud) - [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) - [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)