Logo
Harnham

Senior Data Modeler

Harnham, Phoenix, Arizona, United States, 85003

Save Job

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.

#J-18808-Ljbffr