FirstBank Jobs

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 and 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 and 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) and 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 smal . 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...

Equal Opportunity Employer - minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity