Data Engineer II

ConstructConnect • Full-time • Cincinnati, Ohio, United States • 3m ago

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 Statement
ConstructConnect 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