Data Engineer, Sr.
Role summary
Oldcastle Infrastructure is seeking a Senior Data Engineer to modernize enterprise data systems. This role involves transforming legacy data, implementing Master Data Management (MDM), and enhancing data visibility using tools like Tableau. The ideal candidate will have extensive experience with complex data environments, including legacy systems, database integrations, and ETL/ELT pipelines, bridging traditional systems with modern cloud platforms. Responsibilities include designing and maintaining ETL/ELT pipelines, optimizing data integrations with Snowflake, SAP, and NetSuite, and ensuring high data quality and governance. The position requires strong expertise in SQL, Python, and Snowflake, with a minimum of 10 years of experience in a manufacturing or related environment.
About The Company
Oldcastle Infrastructure™, a CRH company, is a leading provider of utility infrastructure solutions across North America, serving the water, energy, and communications markets. With a robust network of over 80 manufacturing facilities and a dedicated workforce of more than 4,000 employees, the company is committed to innovation, quality, and safety. More than just a manufacturer of precast concrete, polymer concrete, and plastic products, Oldcastle Infrastructure is a strategic partner to engineers, contractors, distributors, and various industry stakeholders. The organization prides itself on its forward-thinking approach, industry leadership, and a safety-first mindset that drives its operations and growth.
About The Role
The Senior Data Engineer will play a pivotal role in the modernization of enterprise data systems within the Infrastructure Products Group. This position involves transforming legacy data sources, implementing Master Data Management (MDM) capabilities, and enhancing data visibility through tools like Tableau. The ideal candidate will have extensive experience working with complex data environments, including legacy system extracts, database integrations, and enterprise-scale ETL/ELT pipelines. The role requires a strategic thinker who can bridge traditional legacy systems with modern cloud-based platforms, ensuring scalable, governed, and high-quality data ecosystems. The Senior Data Engineer will collaborate closely with cross-functional teams, including MDM, business analysts, and technical staff, to deliver reliable data solutions that support business growth and operational efficiency.
Qualifications
- 10+ years of experience in a manufacturing environment or related industry
- Extensive experience in data engineering or integration engineering
- Strong expertise with Snowflake data platform
- Proven experience extracting and integrating data from SAP and/or NetSuite
- Proficiency in SQL, Python, Tableau, and ETL/ELT frameworks
- Familiarity with data warehousing concepts and best practices
- Experience working with legacy data sources and flat file processing
- Knowledge of data governance principles, including metadata and lineage management
- Experience with data migration, modernization, and reverse engineering of data structures
- Ability to troubleshoot and optimize data pipelines for performance and reliability
- Experience with MDM tools and implementation
- Preferred: Experience with integration tools such as Informatica, SAP Data Services, or Fivetran
- Preferred: Background in manufacturing, supply chain, or ERP-focused environments
- Familiarity with APIs and event-driven architectures
Responsibilities
- Design, develop, and maintain robust ETL/ELT pipelines to extract data from legacy systems, APIs, databases, and cloud applications
- Develop and optimize data integration processes between Snowflake, SAP, NetSuite, and other organizational data sources
- Implement strategies for large-scale data ingestion, transformation, and delivery to support analytics and reporting
- Create and maintain scalable data models within Snowflake to facilitate analytics and business intelligence
- Ensure high data quality, completeness, and consistency across all systems
- Transform complex legacy system extracts into structured, analytics-ready datasets
- Reverse engineer existing data structures to support migration and modernization efforts
- Implement data governance practices, including metadata management and data lineage tracking
- Monitor, troubleshoot, and tune data pipelines for optimal performance and reliability
- Collaborate with cross-functional teams including MDM, business analysts, and technical staff to ensure seamless data integration
- Assist in the selection and technical implementation of MDM tools
- Troubleshoot and resolve integration and pipeline issues promptly to minimize downtime
Benefits
- Competitive salary range of $150,000 to $160,000 per year
- 15% annual bonus target
- 401(k) retirement savings plan
- Short-term and long-term disability benefits
- Life insurance coverage
- Comprehensive health, dental, and vision insurance plans
- Paid time off and paid holidays
- Health and wellness programs to support employee well-being
- Opportunities for professional growth and internal promotion within a global organization
- Inclusive workplace culture 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, protected veteran status, or any other legally protected characteristic. We ensure that employment decisions are made based on qualifications and merit, and we welcome applications from individuals of all backgrounds. AI tools may be used in certain stages of the employment process, but all final hiring decisions will be made by a human recruiter or hiring manager.
