Data Analytics & Visualization Lead

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

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

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 serving as a technical lead and mentor for junior data analysts or engineers

No benefits information provided in the job description.

AECOM is seeking a Data Analytics & Visualization Lead to support the Chicago Department of Water Management's (DWM) Capital Improvement Program.