Hybrid Data Platform Engineer | AI-Driven Analytics

Crescent Electric Supply Co; Elk Grove Village (IL); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health, dental, vision coverage

401(k) plan

PTO

Paid holidays

Life insurance

Job summary

Crescent Electric Supply Co is seeking a Data Engineer to architect, develop, and manage Crescent's data pipelines across multiple ERP environments. You will build Bronze/Silver/Gold data layers, ensure a single source of truth, and mentor SQL Developers on the data platform team.

You will partner with BI developers and business stakeholders to ensure data accuracy, governance, and self-service reporting, while guiding modernization efforts including a Google Cloud migration and AI-enabled

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

Python

AI experience

Data modeling

Data governance

Mentoring

Communication

Education

Bachelor's Degree in Computer Science, Information Systems, or related field

Tools

SSIS

Azure Data Factory

Google Cloud

NoSQL

ERP (Eclipse/Epicor)

Job description

Crescent Electric Supply Co is seeking a Data Engineer to architect, develop, and manage Crescent's data pipelines across multiple ERP environments. You will build Bronze/Silver/Gold data layers, ensure a single source of truth, and mentor SQL Developers on the data platform team.

You will partner with BI developers and business stakeholders to ensure data accuracy, governance, and self-service reporting, while guiding modernization efforts including a Google Cloud migration and AI-enabled