Data Engineer, Sr.

About The Company
Oldcastle Infrastructure™, a subsidiary of CRH, is a leading provider of utility infrastructure solutions serving the water, energy, and communications sectors across North America. With a strong reputation for innovation and quality, the company manufactures a diverse range of products including precast concrete, polymer concrete, and plastic solutions. Oldcastle Infrastructure is committed to building lasting partnerships with engineers, contractors, distributors, and specifiers by delivering reliable, sustainable, and innovative infrastructure solutions. Operating over 80 manufacturing facilities and employing more than 4,000 dedicated professionals, the company emphasizes safety, operational excellence, and continuous improvement to maintain its leadership position in the industry.
About The Role
We are seeking a highly skilled Senior Data Engineer to join our Infrastructure Products Group remotely from within the United States. This pivotal role involves supporting the modernization of our enterprise data landscape by transforming legacy data sources, implementing Master Data Management (MDM) capabilities, and enhancing data visibility through Tableau dashboards. The ideal candidate will possess a forward-thinking approach, capable of bridging traditional legacy environments with modern cloud-based platforms such as Snowflake, SAP, and NetSuite. You will be responsible for designing, developing, and maintaining scalable, governed data ecosystems that ensure data quality, integrity, and accessibility across multiple systems. Your expertise will enable the organization to leverage high-quality data for strategic decision-making and operational efficiency, supporting enterprise-wide data modernization initiatives.
Qualifications

• 10+ years of experience in a manufacturing or industrial environment.
• Extensive experience in data engineering, data integration, or related roles.
• Strong expertise with Snowflake data platform.
• Proven experience extracting and integrating data from SAP and/or NetSuite systems.
• Proficiency in SQL, Python, Tableau, and ETL/ELT frameworks.
• Solid understanding of data warehousing concepts and best practices.
• Experience working with legacy data sources and flat file processing.
• Knowledge of data governance principles, including metadata management and data lineage.
• Experience with legacy system data extraction and modernization projects.
• Familiarity with integration tools such as Informatica, SAP Data Services, or Fivetran.
• Ability to develop and optimize large-scale data ingestion, transformation, and delivery pipelines.
• Strong analytical and troubleshooting skills to resolve pipeline and integration issues.
• Experience with enterprise data modeling and reverse engineering legacy data structures.
• Excellent collaboration skills working with cross-functional teams including MDM, business analysts, and technical staff.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines to extract data from legacy systems, APIs, databases, and cloud applications.
• Implement and optimize data integration processes between Snowflake, SAP, NetSuite, and other organizational data sources.
• Create scalable and efficient data models within Snowflake to support analytics and reporting needs.
• Transform complex legacy system extracts into structured, analytics-ready datasets.
• Reverse-engineer existing data structures to facilitate migration and modernization efforts.
• Ensure high data quality, consistency, and completeness across all integrated systems.
• Implement data governance practices, including metadata management and data lineage tracking.
• Monitor, troubleshoot, and tune data pipelines to ensure optimal performance and reliability.
• Collaborate with Master Data Management (MDM) teams, business analysts, and technical teams to align data strategies and requirements.
• Support the selection and technical implementation of MDM tools and related infrastructure.
• Stay current with emerging data engineering technologies and best practices to continuously improve data ecosystems.

Benefits

• Competitive salary ranging from $150,000 to $160,000 per year.
• Target annual bonus of 15% of base salary.
• Comprehensive health, dental, and vision insurance plans.
• 401(k) retirement savings plan with company matching.
• Short-term and long-term disability benefits.
• Life insurance coverage.
• Paid time off and paid holidays.
• Access to health and wellness programs.
• Opportunities for professional growth and internal career advancement.
• Inclusive and collaborative work environment that values diversity and opportunity.

Equal Opportunity
Oldcastle Infrastructure, a CRH company, is an Affirmative Action and Equal Opportunity Employer. We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic under applicable law. We welcome applications from all qualified individuals and do not discriminate based on any protected status. AI tools may assist in certain stages of the hiring process; however, all final employment decisions are made by human reviewers to ensure fairness and compliance with our policies.