Data Analytics & Visualization Lead

AECOM is seeking a Data Analytics & Visualization Lead to support the Chicago Department of Water Managements (DWM) Capital Improvement Program. This hands-on technical role will lead the development of analytics solutions and dashboards that transform engineering operations and maintenance data into actionable insights that directly improve DWMs daily operations and long-term planning.

In this position you will serve as a technical team lead who develops BI / analytics solutions ensures data quality collaborates with DWM stakeholders and guides junior staff without needing full managerial oversight responsibilities. This position plays a pivotal role in transforming a major public utility into a more data-driven organization.

Key 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.
• Build semantic data models and optimized data sets for end users and dashboards.
• Lead development enhancement and maintenance of Power BI dashboards supporting operations engineering maintenance capital planning and leadership decision-making.
• Ensure dashboards are intuitive user-friendly and designed according to strong visualization and UX best practices (formal HCI / UI training not required).
• Collaborate with stakeholders to refine requirements prototype iterate and deliver value-driven visual tools.
• Work closely with DWM staff and internal teams to gather business requirements develop prototypes and iterate rapidly.
• Serve as a technical lead and mentor for junior data analysts or engineers; provide design review and technical oversight.
• Coordinate with cross-functional teams (Engineering GIS EAM Water Quality Program Controls) to ensure data alignment.

Qualifications : Minimum Requirements

Preferred Qualifications

Additional Information :

About AECOM

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status AECOM benefits may include medical dental vision life AD&D disability benefits paid time off leaves of absences voluntary benefits perks flexible work options  well-being resources employee assistance program business travel insurance service recognition awards retirement savings plan and employee stock purchase plan.

AECOM is the global infrastructure leader committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities we solve our clients complex challenges in water environment energy transportation and buildings. Our teams partner with public- and private-sector clients to create innovative sustainable and resilient solutions throughout the project lifecycle from advisory planning design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2024. Learn more at .

What makes AECOM a great place to work

You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting-edge technology and a network of experts youll have the resources to make a real impact. Our award-winning training and development programs are designed to expand your technical expertise and leadership skills helping you build the career youve always envisioned. Here youll find a welcoming workplace built on respect collaboration and communitywhere you have the freedom to grow in a world of opportunity.

As an Equal Opportunity Employer we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines.

Remote Work : No

Employment Type : Full-time

Key Skills

Adobe Analytics,Data Analytics,SQL,Attribution Modeling,Power BI,R,Regression Analysis,Data Visualization,Tableau,Data Mining,SAS,Analytics

Experience : years

Vacancy : 1