Data Engineer II

Overview

This position sits within our Product Development division, which develops, tests, and improves our software solutions in an innovative and collaborative environment. 

ConstructConnect has built up multiple sources of data over the course of many years and acquisitions. Our data engineers work to build bridges and pathways between data sources. Our goal of one source of truth is accomplished with a myriad of tools as we build out the company’s data lake and data warehouse. This role has the unique opportunity to consume and manage the nation’s largest collection of construction data.

The ideal candidate for this role is excited about data in all its forms, desires to build a source of data truth, and is looking forward to leveraging Google Cloud’s vast array of data technologies.

The Data Engineer Level II enhances and builds our data pipelines using a combination of advanced technologies and standard engineering practices. They are responsible for working with the software engineering, marketing, product, data science, and customer service teams to ensure our data is delivered in a timely and scalable fashion.

Responsibilities

• Assembling large, complex sets of data that meet business requirements
• Modernizing and innovating data delivery pipelines using cloud technologies
• Ensuring data is properly curated and transformed for analysis and consumption
• Collaborating with data scientists and architects
• Lead code reviews and mentor junior team members, fostering best practices in data engineering
• Implementing best practices for data governance and security
• Optimizing data workflows and performance tuning
• Identify and resolve complex data pipeline issues independently
• Apply software engineering principles (version control, CI/CD, testing) to maintain a scalable data ecosystem
• This job description in no way implies that the duties listed here are the only ones that team members can be required to perform

Qualifications

• Bachelor’s Degree or equivalent experience in Computer Sciences, Database Development, or a related discipline
• 3-5 years of experience in directly related positions
• Creative problem-solver who is passionate about digging into complex problems and devising new approaches to reach results
• Strong communication skills and experience distilling and presenting complex quantitative analysis into action-oriented recommendations
• Advanced understanding of programming languages such as Python, JavaScript, C#, or other language
• Advanced understanding of SQL Queries, Stored Procedures, Views, and Triggers
• Advanced understanding of the concepts of ETL or ELT (Extract, Transform, Load) processes
• Familiarity with cloud-based data technologies (GCP preferred)
• Handles sensitive and confidential data/information
• The physical activities of this position include frequent sitting, telephone communication, working on a computer for extended periods of time. Visual acuity is required to perform activities close to the eyes. 
• This position is a hybrid position and team members are expected to have a dedicated and established remote workspace.   
• Ability to work hybrid in the Greater Cincinnati/Northern Kentucky Area. 

Physical Demands and Work Environment 

• The physical activities of this position include frequent sitting, telephone communication, working on a computer for extended periods of time. Visual acuity is required to perform activities close to the eyes. 

• This position is a hybrid position and team members are expected to have a dedicated and established remote workspace.   

• Ability to work hybrid in the Greater Cincinnati/Northern Kentucky Area. 

E-Verify StatementConstructConnect utilizes the E-Verify program with every potential new hire. This makes it possible for us to make certain that every employee who works for ConstructConnect is eligible to work in the United States. To learn more about E-Verify you can call 1-800-255-7688 or visit their website. E-Verify® is a registered trademark of the United States Department of Homeland Security.

Privacy Notice