Climate & Environment Full-time

Data Analytics & Visualization Lead

AECOM

Location

USA

Type

Full-time

Posted

Jan 22, 2026

Mission

What you will drive

Core responsibilities:

  • Build, maintain, and optimize data pipelines using SQL Server, stored procedures, and ETL frameworks
  • Integrate EAM, GIS, operational, maintenance, and engineering datasets into centralized analytical models
  • Develop operational and strategic KPI frameworks for engineering and utility management
  • Lead development, enhancement, and maintenance of Power BI dashboards supporting operations, engineering, maintenance, capital planning, and leadership decision-making

Impact

The difference you'll make

This role transforms a major public utility into a more data-driven organization by developing analytics solutions and dashboards that turn engineering, operations, and maintenance data into actionable insights that directly improve daily operations and long-term planning.

Profile

What makes you a great fit

Required skills and qualifications:

  • Experience with SQL Server, stored procedures, and ETL frameworks
  • Proficiency in Power BI dashboard development and maintenance
  • Ability to build semantic data models and optimized data sets
  • Experience collaborating with stakeholders to refine requirements and deliver value-driven visual tools

Benefits

What's in it for you

No benefits information provided in the job description.

About

Inside AECOM

AECOM is a global infrastructure consulting firm that supports the Chicago Department of Water Management's Capital Improvement Program.