Hybrid Data Engineer: Cloud Platform Architect

Crescent Electric Supply Company; Phoenix (AZ); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health, dental, vision coverage

401(k) plan

Paid Time Off

Company-paid holidays

EAP and life insurance

Job summary

Crescent Electric Supply Company seeks a Data Engineer to architect, develop, and manage data pipelines across multiple ERP entities, ensuring a single source of truth. You will build Bronze/Silver/Gold data layers, partner with BI teams, and guide SQL Developers with governance and best practices.

The role emphasizes Cloud migration, data quality, and secure, auditable processes, with mentorship and collaboration across business stakeholders. Hybrid work near a Crescent location.

Qualifications

• Bachelor’s Degree in Computer Science, Information Systems, or related field, or equivalent practical experience.
• 5-7+ years of experience in data engineering, ETL development, or database development.
• Experience supporting multi-entity or multi-ERP environments a plus.
• Strong hands-on expertise in SQL and relational database systems; working knowledge of NoSQL a plus.
• Experience building and maintaining ETL/ELT pipelines using tools such as SSIS, Azure Data Factory, or equivalent.
• Experience with cloud data platforms (Google Cloud, Azure, or AWS); Google Cloud experience strongly preferred.
• Solid understanding of data modeling concepts, including medallion (Bronze/Silver/Gold) or similar layered architectures.
• Scripting/programming experience (Python or similar) for automation and data transformation a plus.
• Experience with ERP systems (Eclipse/Epicor) a plus.
• Demonstrated ability to mentor and guide less-experienced developers.
• Strong analytical and problem-solving skills, with the ability to diagnose and resolve data integrity issues in complex, multi-system environments.
• Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Hands-on AI experience a plus.
• Willingness to learn and apply AI coding tools (e.g., Claude Code) to optimize development work and streamline pipeline delivery.

Responsibilities

• Pipeline Architecture & Development: Design, build, and maintain scalable ETL/ELT data pipelines that move data from source systems into the governed data platform.
• Data Modeling: Develop and maintain data models and schemas (Bronze/Silver/Gold medallion architecture) that eliminate redundant business logic and establish a single source of truth.
• Platform Modernization: Lead the technical build-out of the data platform in support of the Google Cloud migration, retiring shadow data paths and truncate-and-reload patterns in favor of governed, auditable processes.
• AI-Enabled Engineering: Learn and leverage AI coding tools to optimize pipeline code, accelerate development, and streamline data delivery processes; evaluate and champion effective AI-assisted engineering practices across the data platform team.
• Data Quality & Governance: Engineer governance, validation, and error-handling directly into pipeline design rather than relying on downstream policy; monitor pipeline health and proactively resolve data integrity issues.
• Technical Mentorship & Leadership: Provide indirect leadership, coaching, and code-review guidance to the SQL Developers on the data platform team; set standards and best practices for SQL development and pipeline design.
• Cross-Functional Collaboration: Partner with the DBA, BI Developer(s), and business stakeholders to translate business and reporting requirements into technical pipeline and data structure designs.
• Documentation: Maintain clear technical documentation of data flows, transformations, and architecture to support team continuity and knowledge transfer.
• Security & Compliance: Ensure data pipelines adhere to data handling, access control, and security standards across all four ERP instances.

Skills

SQL

ETL development

Data modeling

Cloud platforms

Python

Mentoring

AI coding tools

Education

Bachelor’s degree in Computer Science or related field

Tools

SSIS

Azure Data Factory

Google Cloud

Eclipse/Epicor

Job description

Crescent Electric Supply Company seeks a Data Engineer to architect, develop, and manage data pipelines across multiple ERP entities, ensuring a single source of truth. You will build Bronze/Silver/Gold data layers, partner with BI teams, and guide SQL Developers with governance and best practices.

The role emphasizes Cloud migration, data quality, and secure, auditable processes, with mentorship and collaboration across business stakeholders. Hybrid work near a Crescent location.