Hybrid Data Engineer

Crescent Electric•Des Moines, IA

3d•Hybrid

About The Position

As a Data Engineer at Crescent Electric Supply, you will be responsible for the architecture, development, and management of Crescent’s data pipelines, enabling reliable analytics and downstream business processes across all entities (Crescent, STWY, WMCK, LOWE). You will build and maintain the platform’s Bronze/Silver/Gold data layers, ensures a single source of truth for critical data, and provides indirect leadership and mentorship to the SQL Developers on the data platform team. You will partner closely with the BI & Analytics Developer(s) and business stakeholders to ensure the underlying data is accurate, well-governed, and structured to support self-service reporting and advanced analytics.

Requirements

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.
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.
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.
Willingness to learn and apply AI coding tools (e.g., Claude Code) to optimize development work and streamline pipeline delivery.

Nice To Haves

Experience supporting multi-entity or multi-ERP environments a plus.
Scripting/programming experience (Python or similar) for automation and data transformation a plus.
Experience with ERP systems (Eclipse/Epicor) a plus.
Hands-on AI experience a plus.

Responsibilities

Design, build, and maintain scalable ETL/ELT data pipelines that move data from source systems (Eclipse/Epicor, Salesforce, Workday, and others) into the governed data platform.
Develop and maintain data models and schemas (Bronze/Silver/Gold medallion architecture) that eliminate redundant business logic and establish a single source of truth.
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.
Learn and leverage AI coding tools (such as Claude Code) to optimize pipeline code, accelerate development, and streamline data delivery processes; evaluate and champion effective AI-assisted engineering practices across the data platform team.
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.
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.
Partner with the DBA, BI Developer(s), and business stakeholders to translate business and reporting requirements into technical pipeline and data structure designs.
Maintain clear technical documentation of data flows, transformations, and architecture to support team continuity and knowledge transfer.
Ensure data pipelines adhere to data handling, access control, and security standards across all four ERP instances.