Data Engineer

Aldridge Group•Green Oaks, IL

1d•$120,000 - $150,000•Onsite

About The Position

Aldridge is seeking an experienced Data Engineer to build, maintain, and continuously improve pipelines and projects that move data from source systems into its cloud data platform. The role helps ensure clean, reliable data is available to the teams that depend on it. This position is onsite at the company’s Libertyville, Illinois office. The Data Engineer develops and optimizes batch and ELT pipelines, dbt models and project infrastructure, SQL transformations, Python automation, and Tableau data sources and dashboards. The role also integrates data from ERP, field-operations, and finance systems; monitors data quality and freshness; troubleshoots pipeline issues; documents data assets; and partners with analysts, operations teams, leadership, and report writers to deliver useful data and reporting. Aldridge describes its culture as collaborative, family-centered, and committed to innovation, safety, execution, and mental wellness. The company has more than 2,000 industry experts and says it supports communities affected by its infrastructure projects. The annual base salary range is $120,000–$150,000, with potential bonus eligibility. Aldridge offers a comprehensive benefits package.

Requirements

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
At least 5 years of experience building, supporting, or architecting data pipelines; construction-industry experience is preferred.
Proficiency in SQL and Python, with experience using dbt for transformation and pipeline management.
Experience building, optimizing, and mentoring others on Tableau data sources, dashboards, and reports.
Hands-on experience with Google BigQuery and/or Azure SQL Server.
Experience designing, maintaining, and optimizing ETL pipelines and data models.
Strong attention to detail and accuracy in deliverables.
Strong problem-solving skills and ability to manage data initiatives independently.
Good communication and relationship-building skills, including the ability to present data and recommendations to stakeholders.
Strong organizational and time-management skills, including the ability to prioritize work.
Strong Tableau report-writing skills and ability to present data clearly and accurately.

Nice To Haves

Experience building, supporting, or architecting data pipelines in the construction industry.

Responsibilities

Build, maintain, and optimize batch and ELT pipelines that load data into Google BigQuery and Azure SQL Server.
Design, develop, and test dbt models, from staging and intermediate models through mart-level transformations.
Own dbt project structure, macros, testing, and CI/CD deployment.
Write clean, well-documented SQL transformations and Python scripts and automation to process and prepare data.
Build, maintain, and optimize Tableau data sources and dashboards in partnership with the analytics team.
Build and maintain integrations from ERP, field-operations, and finance source systems.
Implement data-quality tests, data-freshness checks, and monitoring on owned datasets.
Serve as a point of contact for pipeline failures and data-freshness alerts, and troubleshoot root causes.
Identify bottlenecks in existing data workflows and implement automated solutions.
Document data sources, pipelines, and dbt models to support team consistency.
Collaborate with analysts, operations teams, and leadership to understand data requirements and present solutions.
Apply and help establish team standards for data quality, testing, version control, and documentation.
Write and maintain recurring operational and departmental reports in Tableau to defined specifications.
Support department report writers with curated Tableau data sources and report-writing guidance.
Build skills through training and professional development opportunities.
Perform other duties as assigned and directed, including occasional related work assignments and temporary or training assignments.