Data Engineer II

About this role

Based in St. Louis, Core & Main is a leader in advancing reliable infrastructure™ with local service, nationwide®. As a specialty distributor with a focus on water, wastewater, storm drainage and fire protection products and related services, Core & Main provides solutions to municipalities, private water companies and professional contractors across municipal, non-residential and residential end markets, nationwide. With over 370 locations across the U.S., the company provides its customers local expertise backed by a national supply chain. Core & Main’s 5,700 associates are committed to helping their communities thrive with safe and reliable infrastructure. Visit
coreandmain.com
to learn more.


Job Summary
Design, build, test, and maintain reliable data pipelines and data solutions that support analytics, reporting, and operational use cases. This role owns end‑to‑end data pipelines or data flows within defined domains and works independently on moderately complex data engineering tasks.


Partner closely with senior engineers, architects, and stakeholders to deliver high‑quality, secure, and well‑documented data solutions that meet business and technical requirements.


Major Tasks, Responsibilities And Key Accountabilities

• Design, develop, and maintain production‑ready data pipelines, data transformations, and data models.
• Collaborate with business and technical stakeholders to understand data requirements and translate them into scalable solutions.
• Implement and maintain data warehouse, data lake, or lakehouse solutions aligned with architectural standards.
• Perform unit testing and support QA, regression, and user acceptance testing for data solutions.
• Troubleshoot, debug, and resolve data pipeline failures, performance issues, and data quality defects.
• Contribute to technical documentation, including design artifacts, data mappings, and operational runbooks.
• Participate in peer code reviews and apply feedback to improve ...