Data Analytics & Visualization Lead at Aecom USA

Chicago, Illinois, United States -

Full Time

Start Date

Immediate

Expiry Date

06 May, 26

Salary

135000.0

Posted On

05 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Analytics, Visualization, SQL, ETL, Power BI, Data Modeling, GIS, KPI Development, Collaboration, Mentoring, Data Quality, Predictive Analytics, Statistical Modeling, Communication, User Experience, Technical Oversight

Industry

Civil Engineering

Description

Company Description Work with Us. Change the World. At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's trusted infrastructure consulting firm, partnering with clients to solve the world’s most complex challenges and build legacies for future generations. There has never been a better time to be at AECOM. With accelerating infrastructure investment worldwide, our services are in great demand. We invite you to bring your bold ideas and big dreams and become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction managers and other professionals delivering projects that create a positive and tangible impact around the world. We're one global team driven by our common purpose to deliver a better world. Join us. Job Description AECOM is seeking a Data Analytics & Visualization Lead to support the Chicago Department of Water Management’s (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 DWM’s 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 Bachelor’s degree in data analytics, computer science, engineering, information systems, or related field and 4+ years of relevant experience or demonstrated equivalency of experience and/or education. Preferred Qualifications Experience integrating GIS data or understanding geospatial concepts. Experience in utilities, public infrastructure, engineering, construction, or operations. Experience informally or formally leading or mentoring a small BI/analytics team. Familiarity with UI/UX or dashboard design best practices (formal certification not required). Experience with predictive analytics, forecasting, or statistical modeling. Relevant technical certifications (Power BI, SQL Server, PMP, BI/Analytics). Strong hands-on proficiency with Power BI, SQL, and data modeling Experience in integrating data from different operational data systems (i.e. asset management and maintenance systems). Strong communication skills and ability to work directly with non-technical stakeholders. Additional Information Sponsorship is not available for this position now or in the future. Relocation may be available for this position. 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 aecom.com. 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, you’ll 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 you’ve always envisioned. Here, you’ll find a welcoming workplace built on respect, collaboration and community—where 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. State/Province: Illinois Business Group: DCS Legal Entity: AECOM Technical Services Inc Business Line: Water Work Location Model: On-Site Operating Group: Americas Primary Location: US - Chicago, IL - 130 East Randolph Compensation: USD120000 - USD135000 - yearly

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Data Analytics & Visualization Lead will develop analytics solutions and dashboards to improve the Chicago Department of Water Management’s operations. This role involves building data pipelines, integrating datasets, and collaborating with stakeholders to deliver actionable insights.