
AECOM Data Analyst (Engineering) Case Interview – Infrastructure Analytics and Client Presentation
What this covers: - AECOM-style live case mirroring project lifecycle work in transportation and water. You’ll frame a client problem, analyze multi-source infrastructure data, and present actionable recommendations with ESG and equity implications. Scenario prompt (example): - You are supporting a metropolitan corridor safety and capital program. Provided are: (1) 6 months of traffic sensor data (speeds, volumes, incidents), (2) transit ridership by stop and route, (3) cost/schedule extracts from a PM system, and (4) a simple GeoJSON of corridors overlaid with a census-based equity index. The client asks: “Where should we prioritize near-term safety investments, and are we at risk of finishing over budget or behind schedule?” What you’ll do in-session: - 10 min: Clarify objectives, KPIs, and constraints; state assumptions and risks. - 35 min: Analyze and synthesize. Typical actions: join/clean datasets; handle missing sensors; compute hot spots (e.g., incidents per MVMT), simple trend or regression for ridership recovery, and a light schedule/cost risk indicator (EVM or Monte Carlo-lite). Optional: quick spatial join to flag equity-priority segments. - 15 min: Present a 4–5 slide client story with a one-page executive summary and 1–2 visuals (Power BI/Tableau/Excel). Emphasize trade-offs, dependencies, and ESG/EDI considerations aligned to AECOM’s “deliver a better world” mandate. - 5 min: Q&A on limitations, next steps, and data governance. Tools allowed (choose your strength): - SQL (window functions, joins), Excel/Python (pandas), Power BI/Tableau; basic GIS (ArcGIS/QGIS) is a plus. Evaluation rubric (AECOM-specific): - Problem framing to client context; clarity of objectives and risks. - Data hygiene and method selection (joins, null/outlier handling, reproducibility). - Decision-grade metrics and visualization for non-technical stakeholders. - Stakeholder awareness and collaboration in a multi-disciplinary, PM/CM setting; explicit ESG and equity lens. - Communication under time constraints; ability to defend trade-offs and assumptions. Why this format: - AECOM processes often blend online/technical assessments with case- or presentation-based rounds and behavioral fit, so this case mirrors real patterns candidates report. ([interviewquery.com](https://www.interviewquery.com/interview-guides/aecom-data-analyst?utm_source=chatgpt.com), [aecom.com](https://aecom.com/americas-graduate-careers-archive-2/our-recruitment-process/?utm_source=chatgpt.com), [glassdoor.com](https://www.glassdoor.com/Interview/AECOM-Interview-Questions-E5632.htm?utm_source=chatgpt.com))
8 minutes
Practice with our AI-powered interview system to improve your skills.
About This Interview
Interview Type
PRODUCT SENSE
Difficulty Level
3/5
Interview Tips
• Research the company thoroughly
• Practice common questions
• Prepare your STAR method responses
• Dress appropriately for the role