UNKNOWN

ADAPTED_NOW

The Senior Data Modeler leads collaboration with data architects, data engineers, and business stakeholders to translate complex business rules and analytical requirements into robust conceptual, logical, and physical data models. Responsible for designing, building, and optimizing data models for platforms such as Snowflake, Redshift, and similar cloud-based database systems, ensuring performance, scalability, and architectural integrity.

HOUR

**Careers With Purpose** **Sanford Health, the largest rural health system in the United States, is dedicated to transforming the health care experience and providing access to world-class health care in America’s heartland.** **Facility:** Stevens Center Building **Location:** Sioux Falls, SD **Address:** 900 East 54th St N, Sioux Falls, SD 57104, USA **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. **Job Summary** 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. Provides expert-level leadership across conceptual, logical, and physical modeling and ensures data assets are accurate, consistent, reusable, and aligned with enterprise architecture standards. Champions data modeling best practices, improves enterprise data quality, and shapes the long-term direction of data architecture. The Senior Data Modeler leads collaboration with data architects, data engineers, and business stakeholders to translate complex business rules and analytical requirements into robust conceptual, logical, and physical data models. Designs and governs high-quality data structures using advanced normalization, dimensional modeling, star schema design, and domain-driven design. Produces and maintains 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. Will establish, refine, and enforce modeling standards, patterns, and best practices used across the organization to include comprehensive data dictionaries, metadata and data flow documentation. Ensures data models adhere to healthcare security and regulatory requirements (e.g. HIPAA, GDPR, etc.). Design 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. Contributes to the evolution of healthcare-based enterprise data models, ensuring interoperability, scalability, and alignment with organizational goals. Will collaborate 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. Must anticipate and identify opportunities for optimization, modernization, and innovation in data modeling and propose enhancements to align with industry advancements. Partners with data engineers, data architects and data analysts to resolve integration challenges. Will mentor and develop data modelers, engineers, and analysts, promoting modeling excellence and knowledge sharing across teams. Responsible for designing, building, and optimizing data models for platforms such as Snowflake, Redshift, and similar cloud-based database systems, ensuring performance, scalability, and architectural integrity. **Qualifications** Bachelor’s degree required in computer science, management information systems, or related field. Minimum of five years of experience in data modeling, database design and development, systems or applications development, or related field. Must be proficient in data modeling tools such as Erwin, ER/Studio, PowerDesigner, or other similar tools. Proficiency with SQL, strong understanding of data pipeline and data warehousing principles and concepts is required. 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 detail. Experience in data modeling and design within the health insurance or health care industry is preferred. Experience with cloud data platforms (e.g., Azure, AWS, or Google Cloud) and healthcare analytics platforms (e.g., Epic Caboodle). Understanding of data lake and lakehouse architectures. Experience with data governance, data quality, and MDM principles. Familiarity with BI/analytics tools and data science needs. **Benefits** Sanford offers an attractive benefits package for qualifying full-time and part-time employees. Depending on eligibility, a variety of benefits include health insurance, dental insurance, vision insurance, life insurance, a 401(k) retirement plan, work/life balance benefits, and a generous time off package to maintain a healthy home-work balance. For more information about Total Rewards, visit https://sanfordcareers.com/benefits . Sanford is an EEO/AA Employer M/F/Disability/Vet. If you are an individual with a disability and would like to request an accommodation for help with your online application, please call 1-877-673-0854 or send an email to talent@sanfordhealth.org . Sanford has a Drug Free Workplace Policy. An accepted offer will require a drug screen and pre-employment background screening as a condition of employment. **Req Number:** R-0257716 **Job Function:** Information Technology **Featured:** No

Sanford Health

Senior Data Modeler

Amazon Web Services (AWS)

Analysis Skills

Architectural Analysis

Architectural Services

Best Practices

Business Intelligence

Business Strategy

Cloud Computing

Communication Skills

Computer Science

Cross-Functional

Data Analysis

Data Collection

Data Lake

Data Management

Data Modeling

Data Modeling Tools

Data Quality

Data Science

Data Structures

Data Warehousing

Database Design

Database Programming

Database Technology

Detail Oriented

Dimensional Modeling

Documentation

Ecosystems

Embarcadero ER/Studio

Enterprise Architecture

Entity Relationship Diagram (ERD)

Epic Caboodle

Epic Systems

HIPAA (Health Insurance Portability and Accountability Act)

Health Insurance

Healthcare

Information Technology & Information Systems

Interoperability

Leadership

Maintain Compliance

Management of Information Systems/Technology (MIS)

Master Data Management (MDM)

Mentoring

Microsoft Windows Azure

Problem Solving Skills

Quality Management

Regulatory Compliance

Regulatory Requirements

Requirements Management

SQL (Structured Query Language)

Snowflake Schema

Software Development

Star Schema

Strategic Planning

Sybase PowerDesigner

erwin Data Modeler

Sanford Health Jobs

Data Modeler Jobs in South Dakota

Data Modeler Jobs in South Dakota

Resume Resources

Similar Job Searches

Get noticed by top employers!

Data Modeler Jobs in South Dakota

Senior Data Modeler Sanford Health

Resume Resources

Similar Job Searches