Senior Data Engineer in Phoenix

Energy Jobline ZR; Phoenix (AZ); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Energy Jobline ZR is seeking a Data Engineer III specializing in enterprise data modeling to design and implement scalable data solutions across domains. The role blends hands-on data engineering with strategic modeling leadership in a hybrid Phoenix setting.

You will drive conceptual, logical, and physical models, establish enterprise standards, and collaborate with architects, analysts, and business teams to enable analytics, reporting, and self-service BI at scale.

Qualifications

• 6+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• Strong hands-on experience building and supporting enterprise data platforms and data integration solutions.
• Experience designing conceptual, logical, and physical data models.
• Experience with enterprise data modeling methodologies (Normalized, Dimensional, Data Vault).
• Experience with modeling tools such as ER/Studio, Erwin, sqlDBM; strong SQL skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines and integrations supporting enterprise data initiatives.
• Lead conceptual, logical, and physical data models across multiple business domains.
• Translate business requirements into scalable enterprise data solutions with stakeholders and engineering teams.
• Develop enterprise data structures to support reporting, analytics, and self-service BI.
• Analyze source systems, profile data, and define mappings for high-quality data solutions.
• Build and optimize dimensional models (facts and dimensions) for analytics workloads.
• Establish enterprise modeling standards, governance, and data design best practices.
• Contribute to long-term evolution of the data platform and mentor junior engineers.
• Collaborate with Data Engineers, Data Architects, BI Developers, and business leaders to align data initiatives.

Skills

SQL

Data modeling

Data warehousing

ETL pipelines

Data governance

AWS

dbt

Git CI/CD

Tools

ER/Studio

Erwin

sqlDBM

Informatica

Git

Job description

Job Description

Data Engineer III (Enterprise Data Modeling)

• Hybrid | Phoenix, AZ
• $120,000 - $150,000 + Bonus
• U.S. and Green Card Holders Only
• No sponsorship available now or in the future

Overview

We are partnering with a well-established enterprise organization that is investing heavily in the modernization of its data ecosystem and cloud-based data platform. As part of this initiative, they are seeking a Data Engineer III who combines strong hands-on data engineering capabilities with deep expertise in enterprise data modeling.

This role is ideal for someone who enjoys building data solutions while also taking ownership of the organization’s data modeling strategy. You will play a key role in designing and implementing scalable data solutions, leading conceptual, logical, and physical data modeling efforts, and helping establish enterprise-wide data standards that support analytics, reporting, and operational use cases across the business.

This position is hybrid in Phoenix, Arizona.

What You’ll Do

• Design, develop, and maintain scalable data pipelines and integrations supporting enterprise data initiatives.
• Lead the creation and evolution of conceptual, logical, and physical data models across multiple business domains.
• Partner with business stakeholders, architects, analysts, and engineering teams to translate business requirements into scalable enterprise data solutions.
• Develop and implement enterprise data structures that support operational reporting, analytics, and self-service BI initiatives.
• Analyze source systems, profile data, and define data mappings to ensure high-quality, sustainable data solutions.
• Build and optimize dimensional models, including fact and dimension structures, for analytics and reporting workloads.
• Establish and promote enterprise modeling standards, naming conventions, governance processes, and data design best practices.
• Participate in architecture discussions and contribute to the long-term evolution of the organization’s modern data platform.
• Mentor junior engineers and provide technical leadership on data modeling, data architecture, and engineering best practices.
• Collaborate closely with Data Engineers, Data Architects, BI Developers, and business leaders to ensure alignment across data initiatives.

Required Qualifications

• 6+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• Strong hands-on experience building and supporting enterprise data platforms and data integration solutions.
• Extensive experience designing and leading:
• Conceptual data models
• Logical data models
• Physical data models
• Proven expertise with enterprise data modeling methodologies, including:
• Normalized data models
• Dimensional modeling (Star/Snowflake schemas)
• Data Vault modeling

Experience using enterprise data modeling tools such as:

• ER/Studio, Erwin, sqlDBM or Similar modeling platforms
• Strong SQL skills and experience working with large-scale relational databases and data warehouses.
• Demonstrated ability to translate complex business requirements into scalable, reusable enterprise data solutions.
• Experience with data profiling, source-to-target mapping, data lineage, and data quality practices.
• Strong understanding of data governance, metadata management, and enterprise data management principles.
• Excellent communication skills with the ability to collaborate effectively across technical and business teams

Qualifications

• Experience with dbt and modern data transformation frameworks.
• Knowledge of Medallion Architecture (Bronze, Silver, Gold).
• AWS cloud platform experience.
• Informatica (IICS or PowerCenter).
• Git-based development practices and CI/CD pipelines.
• Data governance, cataloging, and metadata management tools.
• SQL Server modernization or migration experience.
• Master Data Management (MDM) experience.
• Experience supporting enterprise analytics and reporting environments.

Ideal Candidate

The ideal candidate is a hands-on Data Engineer first, but possesses the depth of experience typically found in a Data Architect or Senior Data Modeler. They have successfully led enterprise data modeling initiatives, established data standards and governance processes, and helped organizations modernize their data platforms while remaining actively involved in design, development, and implementation.

If you are passionate about building scalable data solutions and shaping the enterprise data foundation that powers critical business decisions, we’d love to speak with you.