Hybrid Data Platform Engineer: ETL & Analytics

Crescent Electric Supply Company; Des Moines (IA); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401(k) plan

Job summary

Crescent Electric Supply Company is seeking a Data Engineer to design, build, and govern data pipelines across ERP environments, enabling reliable analytics and self-service reporting.

In this hybrid role based near Des Moines, you will contribute to Bronze/Silver/Gold data layers, lead platform modernization, and mentor SQL Developers while partnering with BI and business stakeholders to ensure data quality and security.

Qualifications

• Bachelor’s degree in CS/IS 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; 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.
• Scripting/programming experience (Python or similar) for automation and data transformation a plus.
• Demonstrated ability to mentor and guide less-experienced developers.

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 and accelerate development.
• Data Quality & Governance: Engineer governance, validation, and error-handling directly into pipeline design; monitor pipeline health.
• Technical Mentorship & Leadership: Provide indirect leadership and code-review guidance to the SQL Developers; set standards and best practices.

Skills

SQL proficiency

Relational databases

ETL/ELT design

NoSQL knowledge

Cloud platforms

Python scripting

AI tooling awareness

Mentoring

Data governance

Education

Bachelor’s degree in CS/IS or related field

Tools

SSIS

Azure Data Factory

Google Cloud

SQL Server

Job description

Crescent Electric Supply Company is seeking a Data Engineer to design, build, and govern data pipelines across ERP environments, enabling reliable analytics and self-service reporting.

In this hybrid role based near Des Moines, you will contribute to Bronze/Silver/Gold data layers, lead platform modernization, and mentor SQL Developers while partnering with BI and business stakeholders to ensure data quality and security.