Data Engineer: ELT Pipelines, dbt, BigQuery & Tableau

Aldridge Electric; Libertyville (IL); In loco; USD 120.000 - 150.000; Tempo pieno

Vantaggi offerti da questo lavoro

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)

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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

Conoscenze

SQL

Python

dbt

Tableau

Data pipelines

Formazione

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

Strumenti

dbt

Google BigQuery

Azure SQL Server

ETL pipelines

SQL tooling

Descrizione del lavoro

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.