Senior Data Modeler Job at Harnham, Phoenix, AZ

bE9lVXdwcHo0Q3Fuc2gzMUpzNWpDS3czRGc9PQ==
  • 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

Burns Dirt

Takeoff Technician I Job at Burns Dirt

Burns Dirt - Columbus, Mississippi Burns Group is a family-owned business, established in 1977 serving the civil construction and aggregates industry in the Southeast. Our portfolio includes heavy civil, logistics, and recycling divisions. Our core values and dedication...

Global Connect Technologies

Automation Control Engineer Job at Global Connect Technologies

 ...construction, agricultural, or other off-highway equipment domains. Knowledge of CAN, J1939, or other vehicle communication protocols. Exposure to model-based development tools (MATLAB/Simulink). Experience working in Agile or V-model development environments.... 

Excelon Solutions

Pega Developer Job at Excelon Solutions

Job Description Area of Focus - Core Actions Backend Engineering -Code complex logic using advanced Activities, Job Schedulers, and Queue Processors. Pega CDH Configure Next-Best-Action strategies, Data Flows, and adaptive models. Architecture - Lead migration...

Bowman Williams

Help Desk Engineer Tier 2 (Partial WFH / MSP) Job at Bowman Williams

 ...looking for an L2 Client Support Engineer with MSP experience who enjoys working directly with clients and taking ownership of issues from first response through resolution. This is a hybrid work from home role based in Boston. You will split time between remote support... 

Bask Health

Security Operations Engineer (Threat Detection & Penetration Testing) Job at Bask Health

 ...About This Role You will be leveraging your security operations experience to analyze and respond to security notifications, events, and inquiries. You will be performing initial triage of potential security incidents through log and data analysis to determine whether...