Data Engineer

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 dbt 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 youll do:

Building maintaining and optimizing batch and ELT pipelines that load data into Google BigQuery and Azure SQLServer

Designing developing and testing dbt models from staging andintermediate models through mart-leveltransformations

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 departments 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:

Bachelors degree in Computer Science Data Engineering Information Systems or a related field

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 ELT/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 2000 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 $75000 - $105000. 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)

This job-specific task list covers only the most important job duties. Employees assigned to this position title will also perform other occasional work assignments not mentioned above including temporary assignments training assignments and other related duties. 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.