Data Engineer

As a Data Engineer at Crescent Electric Supply you will be responsible for the architecture development and management of Crescents data pipelines enabling reliable analytics and downstream business processes across all entities (Crescent STWY WMCK LOWE). You will build and maintain the platforms 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:

• Bachelors 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 Electrics 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 companys 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 lifes priorities. Lets serve together. Lets power our communities together. Lets 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