Transportation and Financial Data Analysis and Visualization Specialist

AECOM•New York, NY

3d•$160,000 - $180,000•Hybrid

About The Position

AECOM is actively growing the NYC Transportation Planning practice and is seeking a creative, highly talented Transportation Data Analysis and Visualization Specialist within the Transportation Business Line. The successful candidate will have experience overseeing and developing planning projects focused on using data analytics, transportation/transit planning, benchmarking, and financial analysis in support of capital program tracking, budgeting, and sequencing projects and capital programs for various federal/State/City agency clients in the NY Metropolitan Region.

Requirements

BA/BS in civil engineering, environmental science, economics, statistics, data science, urban planning, natural resources, or an earth science-related field plus 8 years of experience of demonstrated equivalency of experience and / or education.
Experience with the ETL process and programming language for data analysis, like SQL/Python/R.
Experience with New York Metro agencies including Metro North, MTA, PANYNJ, NJT.

Nice To Haves

15+ years industry experience, preferably with data analytics and data modeling.
Certification in project management (i.e. - PMP or similar).
Experience with large-scale data sets.
Experience with the ETL process and programming language for data analysis, like SQL/Python/R.

Responsibilities

Lead efforts to collect, organize, analyze, and visualize transportation data to support agency decision-making for infrastructure projects within the New York Metro area.
Develop frameworks and execute coding of data analysis for large-scale data sources, including ETL processes and data platform integration.
Create intuitive dashboards and reports using Power BI, Tableau, and other visualization platforms to support design, maintenance, planning, and budgeting departments.
Serve as primary interface with clients and regulatory personnel on complex projects and business development initiatives.
Manage financial modeling, cost controls, capital programming, and performance tracking to support regulatory agency requirements and project delivery.
Coordinate and direct project field and data collection efforts, including client visits and field activities as necessary.
Develop and deliver high-quality proposals, manage interdisciplinary teams, and produce comprehensive report deliverables.
Maintain, update, and integrate legacy systems (CPAS, Oracle ERP, PRINTS AUX, ECMS, FTA TrAMs) to automate capital project data reporting.
Mentor junior and mid-level staff and provide technical support to Project Managers and Planning Department personnel.
Proactively enforce a culture of high-quality work and Health & Safety standards within the team.
Stay current with emerging technologies, industry trends, and best practices in data analytics and transportation planning.
Support design-bid-build and design-build infrastructure projects and collaborate across AECOM offices and business lines.