Senior Data Modeler

Careers With Purpose

Sanford Health is one of the largest and fastest-growing not-for-profit health systems in the United States. We're proud to offer many development and advancement opportunities to our nearly 50,000 members of the Sanford Family who are dedicated to the work of health and healing across our broad footprint.

Facility: Remote MI (Central Time)

Location: Remote, MI

Shift: 8 Hours - Day Shifts

Job Schedule: Full time

Weekly

Hours:

40.00

Salary Range: $40.00 - $66.00

Pay Info: Pay starts at $40 and increases according to years of applicable experience.

The Senior Data Modeler is responsible for architecting, governing, and advancing the enterprise data modeling framework to ensure data structures support organizational strategy, scalability, and analytic maturity. The role provides expert-level leadership across conceptual, logical, and physical modeling and ensures data assets are accurate, consistent, reusable, and aligned with enterprise architecture standards. The Senior Data Modeler champions data modeling best practices, improves enterprise data quality, and shapes the long‑term direction of data architecture.

The position leads collaboration with data architects, data engineers, and business stakeholders to translate complex business rules and analytical requirements into robust data models. The role designs and governs high‑quality data structures using advanced normalization, dimensional modeling, star schema design, and domain‑driven design, and produces detailed Entity–Relationship Diagrams (ERDs) to ensure clarity, consistency, and alignment across data ecosystems.

Provides authoritative oversight and approval for enterprise‑wide data models, ensuring compliance with architectural standards, data governance policies, and Technology Solutions (TS) and Architecture COE principles. The candidate will establish, refine, and enforce modeling standards, patterns, and best practices across the organization to include comprehensive data dictionaries, metadata, and data flow documentation. The role ensures data models adhere to healthcare security and regulatory requirements such as HIPAA and GDPR.

The candidate designs schemas for data lakes and data warehouses (star, snowflake, normalized, denormalized).

Leads cross‑functional technical discussions, serving as a mediator and subject‑matter expert to ensure data modeling needs are accurately understood and implemented. The Senior Data Modeler contributes to the evolution of healthcare‑based enterprise data models, ensuring interoperability, scalability, and alignment with organizational goals. The candidate collaborates closely with principal data architects to influence data architecture decisions and strategic direction.

Strengthens data modeling discipline across applications and business areas, ensuring high‑quality data capture and data pipeline alignment. The role anticipates and identifies opportunities for optimization, modernization, and innovation in data modeling and proposes enhancements to align with industry advancements. The candidate partners with data engineers, data architects, and analysts to resolve integration challenges.

Mentors and develops data modelers, engineers, and analysts, promoting modeling excellence and knowledge sharing across teams. The Senior Data Modeler designs, builds, and optimizes data models for platforms such as Snowflake, Redshift, and similar cloud‑based database systems, ensuring performance, scalability, and architectural integrity.

• Bachelor’s degree required in computer science, management information systems, or a related field.
• Minimum of five years of experience in data modeling, database design and development, systems or applications development, or a related field.
• Proficiency in data modeling tools such as Erwin, ER/Studio, Power Designer, or other similar tools.
• Proficiency with SQL, and a strong understanding of data pipeline and data warehousing principles and concepts.
• Strong communication and documentation skills, with the ability to explain complex concepts to both technical and non‑technical stakeholders.
• Strong problem‑solving skills and attention to…