Hybrid Data Engineer

Crescent Electric Supply Co; Madison (WI); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401(k) plan

PTO

Company-paid holidays

Job summary

Crescent Electric Supply Co is seeking a Data Engineer to architect, develop, and manage data pipelines across multiple entities, enabling reliable analytics and governed data platforms. You will shape Bronze/Silver/Gold data layers and mentor SQL developers on the data platform team.

The role emphasizes cross-functional collaboration with BI developers and business stakeholders, with a hybrid work model and a near Crescent branch location requirement.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 5-7+ years of data engineering, ETL development, or database development.
• Experience supporting multi-entity or multi-ERP environments a plus.
• Strong hands-on SQL and relational DB expertise; NoSQL knowledge a plus.
• Experience building ETL/ELT pipelines using SSIS, Azure Data Factory, or equivalents.
• Experience with cloud data platforms (Google Cloud, Azure, AWS); Google Cloud preferred.
• Solid understanding of data modeling concepts, including medallion architecture.
• Scripting/programming (Python) for automation 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 for multi-system environments.
• Excellent written and verbal communication skills.

Responsibilities

• Pipeline Architecture & Development: Design, build, and maintain scalable ETL/ELT data pipelines.
• Data Modeling: Develop data models and Bronze/Silver/Gold schemas.
• Platform Modernization: Lead data platform build-out for Google Cloud migration.
• AI-Enabled Engineering: Explore AI coding tools to optimize pipeline code.
• Data Quality & Governance: Engineer governance and validation into pipelines.
• Technical Mentorship & Leadership: Provide indirect leadership and code-review guidance.
• Cross-Functional Collaboration: Partner with DBA, BI Developers, and stakeholders.
• Documentation: Maintain clear technical documentation of data flows.

Skills

SQL

ETL/ELT

Data Modeling

Google Cloud

Azure/AWS

Python

Mentoring/Leadership

Data Governance

NoSQL

Eclipse/Epicor

Education

Bachelor's Degree in Computer Science or related field

Tools

SSIS

Azure Data Factory

Job description

This is a hybrid position. You must be located near a Crescent branch. Please click here to view a list of our locations.

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.

PRIMARY DUTIES:

• Pipeline Architecture & Development: 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.

• 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 (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.

• 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.

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.

PHYSICAL DEMANDS:

• Frequent sitting, standing, and occasional walking.

• Occasional reaching, twisting, bending.

• Extensive use of technology, such as phone, computer, and keyboard.

• Close vision with clear vision at 20 inches or less.

• Color vision with the ability to identify and distinguish colors.

• May be required to work more than 40 hours per week.

#LI-CECE

Total Rewards and Benefits

Crescent Electric's compensation package includes an array of top-tier benefit options, including:

• Eligibility for health, and dental, vision coverage, 401(k) plan, and flexible spending accounts, subject to plan terms.
• Eligibility for company-paid benefits such as life insurance, short-term disability, long-term care, and Employee Assistance Program, subject to applicable waiting periods.
• Excused Absence time off and Paid Time Off (PTO).
• Company-paid holidays.
• Other benefits for which you may be eligible includes supplemental life insurance, hospital indemnity, and accident and critical illness benefits with cancer coverage.
• Eligibility: Employees are eligible for health, dental, vision, and life insurance benefits on the first of the month following 30 days of employment. Employees who are 21 years of age or older will be automatically enrolled in the company's 401(k) plan once they achieve 90 days of employment.

Family Owned. Culture of Quality. Opportunities to Advance.

Crescent is transforming and we are on a missionto power the communities we serve through teamwork and relentless customer focus. We have a visionof uncompromising teamwork committed to becoming the industry leader for our employees, suppliers, and shareholders. At Crescent, you will have the opportunity to develop professionally, grow personally and have the flexibility to balance your life's priorities. Let's serve together. Let's power our communities together. Let's become THE industry leaders...together.

Crescent Electric Supply Company is proudly an Equal Opportunity Employer. Crescent Electric does not discriminate on the basis of age, color, race, national origin, gender, religion, marital status, disability, veteran, military status, sexual identity or expression, sexual orientation, or any other basis prohibited by local, state, or federal law.

Veterans and military spouses are highly encouraged to apply. We recognize and value the unique strengths of the military community in supporting our mission to serve those who have served.

Candidates are subject to pre-employment assessments, Motor Vehicle Record review, criminal background checks, references check, and a post-offer drug screen. Crescent Electric is committed to the full inclusion of all qualified individuals. As part of this commitment, Crescent Electric will ensure that persons with disabilities are provided reasonable accommodations for the hiring process. If reasonable accommodation is needed, please contact [e-mail]