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. Work Shift: 8 Hours - Day Shifts (United States of America) Scheduled Weekly Hours: 40 Compensation: Salary Range: $40.00 - $66.00 Union Position: No Department Details 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. Job Description 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. 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-949-5678 or send an email to talent@sanfordhealth.org.

• Design, develop, and maintain scalable ETL/ELT pipelines using Databricks, PySpark, Python, and SQL • Optimize data workflows and SQL/Spark queries for performance, cost efficiency, and reliability • Contribute to the design of our enterprise Data Lake and curated data assets • Build robust ingestion frameworks, transformation logic, and reusable data engineering components • Support data migrations and modernization efforts from legacy systems to cloud-based platforms • Use AI coding copilots (Databricks Assistant, GitHub Copilot, SQL copilots) to accelerate development, code review, test creation, and documentation • Automate repetitive tasks (schema evolution, config generation, logging templates, test data creation) with generative AI tools • Leverage AI to auto-detect pipeline anomalies, data drift, quality issues, and performance bottlenecks • Incorporate AI-assisted query optimization tools to improve Spark & SQL performance • Collaborate cross-functionally with Product, data consumers to deliver high-quality data solutions • Participate in Agile ceremonies & contribute to sprint planning & technical design discussions • Mentor junior data engineers, promote best practices in AI-assisted data engineering • Ensure strong documentation, standards adoption, & continuous improvement across the team.

• Develop and maintain dbt transformation pipelines under the direction of a senior technical lead. • Write and optimize SQL used for transformation logic, data preparation, and warehouse-based development work. • Work in Snowflake to query, transform, and manage data in support of production delivery. • Build and maintain dbt models, including staging and transformation layers. • Support data quality and validation activities, including dbt tests and automated testing practices. • Follow established schemas, data models, naming standards, and delivery patterns defined by the senior lead and enterprise architecture team. • Document models, transformations, and workflow logic as required. • Participate in Agile delivery processes and collaborate effectively across time zones within a pod-based team structure.

About the Role We are seeking a visionary, operationally sharp Chief Product Officer to lead our product strategy, with a deep focus on the public sector. This executive will own the full product lifecycle — from discovery through delivery — and serve as the bridge between our SaaS capabilities and the complex procurement, compliance, and mission requirements of federal agencies. The ideal candidate brings a rare combination of commercial product leadership and hands-on experience navigating the federal landscape. Core Responsibilities - Define and drive the overall product vision, strategy, and multi-year roadmap aligned to federal agency missions and emerging government priorities - Lead product solutioning efforts in response to federal opportunities — including RFIs, RFPs, and Sources Sought — translating SaaS capabilities into compliant, compelling technical solutions - Partner closely with the Head of Federal Sales, Capture, and Proposals teams to shape win themes and product positioning for federal bids - Build and maintain deep relationships with federal agency stakeholders, program offices, and end users to drive continuous discovery and feedback loops - Own the product compliance roadmap — including FedRAMP authorization (In Process, Moderate/High), FISMA, NIST 800-53, IL2/IL4/IL5, as applicable - Oversee the product management organization, establishing best-in-class agile and iterative development practices tuned for government delivery timelines - Develop and present product briefings, demos, and capability overviews to C-suite stakeholders, agency CIOs, and technical evaluators - Collaborate with engineering and architecture teams to balance commercial innovation with the security and compliance demands of classified and unclassified federal environments - Track federal technology policy shifts (e.g., Executive Orders, OMB memos, NDAA provisions) and translate their implications into product decisions - Drive competitive differentiation by monitoring the GovTech landscape, incumbent contract holders, and emerging agency technology needs