Job ID: 497331

CRH's Americas Materials, a division of CRH, is the leading vertically integrated supplier of aggregates, asphalt, ready mixed concrete and paving and construction services in North America. Our operations span North America with over 28,000 employees at close to 1,600 locations in 43 US States and 2 Canadian provinces.

Position Overview

The Extract, Transform and Load (ETL) Developer will be responsible for ETL projects and develop ETL / ELT processes into enterprise data solutions. The ETL Developer will also work closely with business analysts and stakeholders in other departments in order to identify, recommend, develop, implement, and support data solutions.

Key Responsibilities (Essential Duties and Functions)

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

• Deliver high quality, transactional consistent and efficient enterprise ETL / ELT solutions
• Provide support, and documentation of new and existing ETL / ELT processes and solutions
• Present the solution to business user and communicate with end user solution details
• Work with Enterprise, ETL and Data Architect to define, develop and deliver Data Engineering Roadmap
• Develop, test & implement ETL / ELT solutions using an agile methodology
• Ability to handle multiple projects at once
• Collaborate with other ETL and / or application developers and business users
• Ability to work with on/off shore extended teams
• Be a proactive member of the data services team
• Maintain professional demeanor at all times while representing the company
• Regular and predictable attendance at assigned times is required
• Other duties as required

Qualifications

Education/Experience

• Master or Bachelor’s Degree in Engineering/Computer related discipline, or equivalent experience required
• 5 years of ETL / ELT Design, development and implementation experience using standard ETL/ ELT tool
• 5 years of SQL Development Experience
• 5 years of experience defining and managing ETL / ELT using tools and industry standard practices
• 3 years of Cloud (Azure) experience
• 3 years of Snowflake experience
• 3 years of SQL Server Reporting Services

Knowledge/Skill Requirements

• Advanced knowledge of SQL databases and queries
• Advanced knowledge of CDC (Change Data Capture) & CT (Change Tracking) inner workings
• Experience in implementing and supporting several different ETL / ELT solutions
• Experience in working with many different data sets, large and small
• Experience working with data in multiple ERP and data movement technologies
• Experience with normalizing and de-normalizing data
• Knowledge of ETL best practices and standards
• Ability to quickly resolve issues
• Experience with Cloud (Azure), Snowflake, SQL Server 2014 – SQL Server 2019 , SQL Server Reporting Services , SQL Server Integration Services
• Ability to present ideas in concise, business-friendly and user-friendly language
• Excellent written, interpersonal and verbal communication skills
• Experience with managing and collaborating with multidisciplinary teams
• Experience with design and development of EDW (Enterprise Data warehouse) is preferred
• Expereince with Data Lakehouse, Data Fabric architecture framework is preferred

Work Requirements

• Must have expert proficiency in Microsoft Word, Excel, PowerPoint, and Outlook
• Must be 18 years in age or older.
• Must pass pre-employment drug screen and criminal background check.
• Strict adherence to safety requirements and procedures as outlined in the Employee Handbook.
• Willingness to work independently within in a team environment and assist the team with other duties as required.
• The position will require travel 0-10%

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• Able to communicate with others by telephone and in person
• Able to utilize a computer for word processing, email communication, and preparation of documents and presentations.
• May require sitting for extended periods of time

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

• Usually, normal office working conditions. The noise level in the work environment is usually quiet
• The position may require work outside of normal business hours

The statements included in this job description are not intended to be all-inclusive. They represent typical elements and criteria necessary to successfully perform the job. Other duties may be assigned as required. Requirements for this job are subject to modification by the Company and its designees, and reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

What CRH Offers You

• Highly competitive base pay
• Comprehensive medical, dental and disability benefits programs
• Group retirement savings program
• Health and wellness programs
• A diverse and inclusive culture that values opportunity for growth, development, and internal promotion

About CRH

CRH has a long and proud heritage. We are a collection of hundreds of family businesses, regional companies and large enterprises that together form the CRH family. CRH operates in a decentralized, diversified structure that allows you to work in a small company environment while having the career opportunities of large international organization.

If you’re up for a rewarding challenge, we invite you to take the first step and apply today! Once you click apply now, you will be brought to our official employment application. Please complete your online profile and it will be sent to the hiring manager. Our system allows you to view and track your status 24 hours a day. Thank you for your interest!

CRH Americas Materials Inc. is an Affirmative Action and Equal Opportunity Employer.

EOE/Vet/Disability--If you want to know more, please click on this link.