Azure Data Factory Jobs in Iowa (NOW HIRING)

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 jobs@cesco.com