Senior Data Modeler

Senior Data Modeler

Hybrid 3-4 days onsite

Location: Phoenix, Arizona

Salary: $130,000 - $150,000 base

A large, operationally complex organization is undergoing a major modernization of its data platform and is building a new, cloud-native analytics foundation from the ground up. This is a greenfield opportunity for a senior-level data modeler to establish best practices, influence architecture, and help shape how data is organized and used across the business.

This role sits at the center of a multi-year transformation focused on modern analytics, scalable data products, and strong collaboration between data and business teams.

What You’ll Be Working On

• Designing and implementing enterprise data models across conceptual, logical, and physical layers
• Establishing Medallion architecture patterns and reusable modeling assets
• Building dimensional and semantic models that support analytics and reporting
• Partnering closely with domain experts and functional leaders to translate business needs into data structures
• Collaborating with data engineers to align models with ELT pipelines and analytics frameworks
• Helping define modeling standards and upskilling senior engineers in modern data modeling practices
• Contributing hands-on to data engineering work where needed (SQL, transformations, optimization)
• Proactively identifying analytics opportunities and recommending data structures to support them

This role is roughly 40% data modeling, 30% hands-on engineering, and 30% cross-functional collaboration.

Must-Have Experience

• Strong, hands-on experience with data modeling (dimensional, canonical, semantic)
• Deep understanding of Medallion architecture
• Advanced SQL and experience working with a modern cloud data warehouse
• Experience with dbt for transformations and modeling
• Hands-on experience in cloud-native data environments (AWS preferred)
• Ability to work directly with business stakeholders and explain technical concepts clearly
• Experience collaborating closely with data engineers on execution

Nice to Have

• Python experience
• Familiarity with Informatica or reverse-engineering legacy data models
• Exposure to streaming or near-real-time data pipelines
• Experience with visualization tools (tool choice is flexible)

Who Will Thrive in This Role

• A senior individual contributor who enjoys building from scratch
• Someone who can act as a modeling expert and mentor in an organization formalizing this practice
• Comfortable working in ambiguity and taking initiative
• Strong communicator who enjoys partnering with both technical and non-technical teams
• Equally comfortable discussing business concepts and physical data models

Why This Role Is Unique

• Greenfield data modeling initiative with real influence
• Opportunity to define standards that will be used across the organization
• Work on large-scale, real-world operational and analytical data
• High visibility within a growing data organization
• Flexible work setup for individual contributors

If you’re excited about shaping a modern data foundation and want to be the person who defines how data is modeled, understood, and used, this is a rare opportunity to make a lasting impact.