Data Engineer

Aldridge Electric; Libertyville (IL); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Wellness Incentive Programs

Short and Long Term Disability

Flexible Spending Accounts

Life Insurance

Legal Assistance

Identity Protection

Accident & Critical Illness Insurance

Company 401(k) Matching Contributions

Paid Time Off (PTO)

Employee Assistance Program (EAP)

Job summary

Aldridge Electric seeks an experienced Data Engineer to build, maintain, and optimize data pipelines moving data from source systems into our cloud data platform, ensuring clean, reliable data for analytics and reporting.

You will design dbt models, manage pipelines in BigQuery and Azure SQL Server, develop Tableau dashboards with the analytics team, and champion data quality through tests, monitoring, and documentation within a collaborative culture.

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field.
• 5+ years experience building, supporting, or architecting data pipelines, preferably in the construction industry.
• 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.

Responsibilities

• Building, maintaining, and optimizing batch and ELT pipelines that load data into Google BigQuery and Azure SQL Server
• Designing, developing, and testing dbt models - from staging and intermediate models through mart-level transformations
• Owning dbt project structure, macros, testing, and CI/CD deployment
• Writing clean, well-documented SQL transformations and Python scripts and automation to process and prepare data
• Building, maintaining, and optimizing Tableau data sources and dashboards in partnership with the analytics team
• Building and maintaining integrations from ERP, field-operations, and finance source systems
• Implementing data-quality tests, data-freshness checks, and monitoring on owned datasets
• Acting as a point of contact for pipeline failures and data-freshness alerts, and troubleshooting root causes
• Identifying bottlenecks in existing data workflows and implementing automated solutions
• Documenting data sources, pipelines, and dbt models to support team consistency
• Collaborating with analysts, operations teams, and leadership to understand data requirements and present solutions
• Applying and helping establish team standards for data quality, testing, version control, and documentation
• Writing and maintaining recurring operational and departmental reports in Tableau to defined specifications
• Supporting the department's report writers with curated Tableau data sources and report-writing guidance
• Continually building skills through training and professional development opportunities
• Performing other duties as assigned and directed

Skills

SQL

Python

dbt

Tableau

Data pipelines

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field

Tools

dbt

Google BigQuery

Azure SQL Server

ETL pipelines

SQL tooling

Job description

Data Engineer

What we are looking for:

Aldridge is seeking an experienced and dedicated Data Engineer to join our talented and energetic team. The Data Engineer builds, maintains, and continuously improves the pipelines and projects that move data from our source systems into our cloud data platform, helping ensure clean, reliable data is available to the teams who depend on it.

What you'll do:

• Building, maintaining, and optimizing batch and ELT pipelines that load data into Google BigQuery and Azure SQL Server
• Designing, developing, and testing dbt models - from staging and intermediate models through mart-level transformations
• Owning dbt project structure, macros, testing, and CI/CD deployment
• Writing clean, well-documented SQL transformations and Python scripts and automation to process and prepare data
• Building, maintaining, and optimizing Tableau data sources and dashboards in partnership with the analytics team
• Building and maintaining integrations from ERP, field-operations, and finance source systems
• Implementing data-quality tests, data-freshness checks, and monitoring on owned datasets
• Acting as a point of contact for pipeline failures and data-freshness alerts, and troubleshooting root causes
• Identifying bottlenecks in existing data workflows and implementing automated solutions
• Documenting data sources, pipelines, and dbt models to support team consistency
• Collaborating with analysts, operations teams, and leadership to understand data requirements and present solutions
• Applying and helping establish team standards for data quality, testing, version control, and documentation
• Writing and maintaining recurring operational and departmental reports in Tableau to defined specifications
• Supporting the department's report writers with curated Tableau data sources and report-writing guidance
• Continually building skills through training and professional development opportunities
• Performing other duties as assigned and directed

Who you are:

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field
• 5 plus years experience building, supporting, or architecting data pipelines, preferably in the construction industry
• 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 the ability to manage data initiatives independently
• Good communication and relationship-building skills, with the ability to present data and recommendations to stakeholders
• Strong organizational and time-management skills, with the ability to prioritize work
• Strong Tableau report-writing skills, with the ability to present data clearly and accurately

Who we are:

At Aldridge, we invite you to be a part of our dynamic team, where your skills are not only valued but crucial to our success. As we pursue our vision to be the First Choice for Energy and Transportation infrastructure projects, we welcome fresh perspectives and prioritize teamwork to drive our industry-leading safety, innovation, and execution.

Our culture is rooted in family-centeredness, with third-generation leadership guiding our unwavering spirit of innovation and entrepreneurship. With over 2,000 industry experts dedicated to our vision, we actively contribute to and uplift the communities impacted by our infrastructure projects and our Aldridge family.

Built on collaboration and a commitment to mental wellness, our core values create an unparalleled sense of unity and camaraderie within our organization. Through team-building events, open-door policies, and visible executive presence, we foster an environment where everyone can thrive, innovate, and make a meaningful difference. Join us in building the infrastructure that keeps the world moving and connected - become a part of the A-team to start building and strengthening your career today!

What we offer:

The annual base pay for this role is between $120,000 - $150,000. The actual pay is dependent upon many factors, including: location, work experience, education, training, transferable skills, business needs, and market conditions. The base pay range is subject to change and may be modified in the future. The role may also be eligible for a bonus. Aldridge provides a comprehensive benefits package that includes the following:

• Health Insurance
• Dental Insurance
• Vision Insurance
• Wellness Incentive Programs
• Short and Long Term Disability
• Flexible Spending Accounts
• Life Insurance
• Legal Assistance
• Identity Protection
• Accident & Critical Illness Insurance
• Company 401(k) Matching Contributions
• Paid Time Off (PTO)
• Employee Assistance Program (EAP)

Aldridge is an EEO Employer and will recruit, hire, train, and promote people in all job classifications without regard to race, color, national origin, age, religion, disability status, gender, sexual orientation, gender identity, genetic information, veteran status, marital status or any other characteristic protected by law.