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 creating analytics solutions and dashboards that directly improve daily operations and long-term planning for water management.

Required skills and experience:

• Technical expertise in SQL Server, stored procedures, ETL frameworks, and Power BI dashboard development
• Experience integrating diverse datasets (EAM, GIS, operational, maintenance, engineering) into analytical models
• Ability to develop KPI frameworks for engineering and utility management
• Experience mentoring junior data analysts or engineers and providing technical oversight

No compensation, perks, or culture highlights mentioned in the job description.

AECOM is a global infrastructure consulting firm that supports public utilities like the Chicago Department of Water Management's Capital Improvement Program through technical solutions and data analytics.