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
#LI-REMOTE
Total Rewards and BenefitsCrescent 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.
