Senior Data Modeler Job at Harnham, Phoenix, AZ

U0FVQXlXUkM5SjRiM3ZWb3NsZDlhYWQ2dGc9PQ==
  • Harnham
  • Phoenix, AZ

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

Allegheny Health Network

Clinical Psychologist Job at Allegheny Health Network

 ...The Allegheny Health Network (AHN), Psychiatry & Behavioral Health Institute (PBHI) is seeking full-time Clinical Testing Psychologist or Neuropsychologist with specific expertise in the assessment of autism spectrum disorder (ASD), attention-deficit/hyperactivity disorder... 

Arrow Workforce Solutions

Safety Coordinator Job at Arrow Workforce Solutions

 ...Title Safety Coordinator Location: Charlotte, NC 28273 Hours: AM Shift Pay Rate: $55,000-$70,000 About AVL Manufacturing: AVL Manufacturing is a global leader in advanced manufacturing solutions, specializing in the design and production of high-quality industrial... 

Jefferies

Investment Banking Analyst | Energy (Oil & Gas) Job at Jefferies

Group Description The Jefferies Energy team represents one of the largest dedicated Energy sector investment banking teams globally. Our unique structure combines corporate finance and advisory capabilities with a large technical team of geologists and engineers, delivering...

R Systems

Data Architect Job at R Systems

 ...Healthcare Experience Preferred **** We are seeking an experienced Data Architect with deep expertise in NoSQL database platforms ,...  ...performance tuning, capacity planning, backup, disaster recovery, and high-availability strategies for NoSQL databases. Lead database... 

NatureSweet

Greenhouse Supervisor Job at NatureSweet

 ...operational standards. This role acts as the link between the growing team and production associates, coordinating labor, monitoring plant performance, and ensuring the timely execution of cultural practices such as pruning, harvesting, and crop maintenance. The...