Data Engineer Tech Lead - Atlanta, GA

Atlanta, GA, US, 30338

CRH Americas Materials Inc

 

 

 

Job ID:  489781


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 Data tech lead will bring substantial experience in data solutions to help unlock the power of our data for our stakeholders. As a data tech lead you will handle the increasing complexity and demand for data from various sources, enabling business to make informed decisions. You will provide technical leadership to team of ETL developers in designing and implementing a cutting-edge data platform and pipelines. Data tech lead will also work closely with business analysts and stakeholders in other departments to identify, recommend, develop, implement, and support data solutions.

 

Key Responsibilities (Essential Duties and Functions)

 

  • Effectively communicate complex technical concepts to business stakeholders, helping them understand the development process and set realistic expectations.
  • Offer guidance and recommendations to the development team, stakeholders based on best practices and industry trends and maximize the return on the investment.
  • Clarify/translate requirements, data strategy into Epics/Stories & remove ambiguity and provide accurate estimates of the time and resources needed to complete tasks.
  • Anticipate potential challenges or edge cases, addressing them before they escalate into significant issues.
  • Collaborate between business stakeholders and development teams, ensuring everyone’s input is considered, and the project stays on track.
  • Lead the design and implementation of the data & analytics architecture ensuring compliance, quality and a sustainable growth of the platform.
  • Mentor and train other data team members and business users as needed.
  • Build scalable data pipelines to integrate and model datasets from different sources that meet functional and non-functional requirements.
  • Provide the technology, the tools and data to support enterprise-wide reporting, analytics, data science and self-service need.
  • Delegating tasks and work with the technical team to achieve established timeline.
  • Ensure the data quality by implementing and monitoring a data quality framework together with the data source teams.
  • Formulate and complete end-to-end analysis that includes data gathering, analysis, ongoing scaled deliverables, and presentations.
  • Help to grow our data team with right talents.

 

Qualifications

 

Education/Experience

 

  • Master or Bachelor’s Degree in Engineering/Computer related discipline, or equivalent experience required
  • 10+ years of ETL / ELT Design, development and implementation experience using standard ETL/ ELT tool
  • 10+ years of SQL Development Experience
  • 7+ 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
  • 2+ years of experience leading, coaching, and providing mentorship to ETL developers in an agile environment.
  • Hands-on and deep experience using Star/Snowflake for schema design, data modeling, data pipelines.

Work Requirements

 

  • 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.

 

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 and creating different fit-for-purpose data model. 
  • 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.
  • Experience with Data Lakehouse, Data Fabric architecture framework is preferred.

 

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.
  • Sitting for extended periods of time.
  • Ability to safely lift up to 50 pounds.

 

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

 

 

 

Date:  Nov 14, 2023


Nearest Major Market: Atlanta

Job Segment: Data Modeler, Database, SQL, Construction, Manufacturing Engineer, Data, Technology, Engineering