Data Engineer – ELT/Pipelines, BigQuery & Tableau

Aldridge Electric; Libertyville (IL); On-site; USD 75,000 - 105,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401(k) Matching

Paid Time Off

EAP

Job summary

Aldridge Electric is seeking a Data Engineer to build and optimize data pipelines that feed our cloud data platform. You will develop dbt models, manage project structure, and ensure reliable data for analytics teams.

Strong SQL and Python skills are required, along with experience in BigQuery or Azure SQL Server and Tableau. You will collaborate with analysts and operations to understand data needs, implement data quality checks, and document sources and models.

Qualifications

• Bachelor's degree in a related field.
• Experience building or supporting data pipelines.
• Proficiency in SQL and Python; dbt for transformation.
• Experience building Tableau data sources, dashboards, and reports.
• Hands-on with Google BigQuery and/or Azure SQL Server.
• Experience designing and maintaining ELT/ETL pipelines and data models.

Responsibilities

• Build, maintain, and optimize batch and ELT pipelines to load data into BigQuery and Azure SQL Server.
• Develop and test dbt models from staging to mart-level transformations.
• Own dbt project structure, macros, testing, and CI/CD deployment.
• Write SQL transformations and Python scripts; automate data processes.
• Build and maintain Tableau data sources and dashboards with analytics team.
• Integrate data from ERP, field operations, and finance systems.

Skills

SQL

Python

dbt

Tableau

BigQuery

Azure SQL

Education

Bachelor's degree

Tools

Google BigQuery

Azure SQL Server

Job description

Aldridge Electric is seeking a Data Engineer to build and optimize data pipelines that feed our cloud data platform. You will develop dbt models, manage project structure, and ensure reliable data for analytics teams.

Strong SQL and Python skills are required, along with experience in BigQuery or Azure SQL Server and Tableau. You will collaborate with analysts and operations to understand data needs, implement data quality checks, and document sources and models.