Senior Data Modeler Job at Harnham, Phoenix, AZ

TzQ0SWVWN3MzWC9tVzY0dVNVWEREWHRCZ2c9PQ==
  • Harnham
  • Phoenix, AZ

Job Description

Job Description

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.

Job Tags

Flexible hours,

Similar Jobs

STATE STREET CORPORATION

Head of Fund Accounting Asset Managers (AMs) (North America), Managing Director (Boston) Job at STATE STREET CORPORATION

 ...Who we are looking for North America Head of Fund Accounting, AMs is a key leadership position within the Global Fund Accounting Team in Global Delivery. The role is responsible for organization, management and delivery of the entire suite of accounting services to... 

Datadog

Director of Enterprise Security Solutions - Sales Eng (San Francisco) Job at Datadog

 ...A dynamic SaaS company is seeking a Director of Enterprise Security Sales Engineering to lead a global team of specialists. You will engage with key security leaders to drive the adoption of security platforms in enterprises. Your responsibilities include overseeing strategic... 

ThedaCare

Hospice Certified Nursing Assistant (CNA) Job at ThedaCare

 ...cost sharing premiums, daycare About ThedaCare! Summary : Under the supervision of the LPN, RN, or nurse leader, the Certified Nursing Assistant (CNA) performs patient-centered, evidence-based nursing care activities to meet the physical and psychosocial... 

Naytahwaush Community Charter School

Special Education Teacher Job at Naytahwaush Community Charter School

Job Title: Special Education Teacher Overview: Join our team as a dedicated Special Education Teacher, where you will play a crucial role in providing tailored support and educational services to students with diverse learning needs. We are seeking a passionate individual... 

Polar Air

HVAC-R & Commercial Kitchen Equipment Technician Job at Polar Air

Job Description Job Description Job Title: Experienced HVAC/Refrigeration Technician Location: [RIO GRANDE VALLEY, LAREDO, CORPUS CHRISTI, SAN ANTONIO AREA] Job Type: Full-Time About Us: We are a well-established HVAC and Refrigeration service company, specializing...