> Markdown version of [/jobs/ext/3709148-transportation-and-financial-data-analysis-and-visualization-specialist](https://www.wearedevelopers.com/jobs/ext/3709148-transportation-and-financial-data-analysis-and-visualization-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Transportation and Financial Data Analysis and Visualization Specialist

- **Company:** AECOM
- **Location:** New York, NY, United States
- **Salary:** $160,000.0 - $180,000.0
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Big Data, Extract Transform Load (ETL), Enterprise Content Management, Python (Programming Language), Power BI, SQL Databases, Tableau (Software), Data Analytics, Oracle Erp, Legacy Systems, Programming Languages
- **Published:** October 13, 2026
- **Apply:** https://dejobs.org/x/x/F628BEC80BF84019958B1E923EEC00C5/job/

## About the Role

* 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.

Preferred Qualifications:

 * 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.

## Description

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.

In this role, you can expect to:

 * 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.