Supervisor, Toll Forecasting and Business Planning

Port Authority of NY & NJ•New York, NY

6d•Hybrid

About The Position

Reporting to the Manager of E- ZPass Finance and Traffic Analytics, the selected candidate will be responsible for overseeing the traffic and toll revenue forecasting process for TB&T, with responsibilities also including short term and historical traffic and toll revenue analysis and trending. The successful candidate will work closely with the TB&T E- ZPass Unit, entities outside of the department like Planning, OFP and MBD.

Requirements

Bachelor’s Degree in Planning , Business / Public Administration, Operations Research, Finance, Engineering, Data Science and/or Economics or related fields from an accredited college or university.
Must have three or more years of related experience which should include performing data analytics, database management, research, and providing resource and funding recommendations.
Demonstrated excellent analytical skills and the ability to identify multi-disciplined issues and recommend solutions/alternatives.
Demonstrated advanced knowledge of Excel, Access (or other database management programs), and Power BI (or Tableau).

Nice To Haves

Master’s Degree in Planning , Business / Public Administration, Operations Research, Finance, Engineering, Data Science and/or Economics or related fields from an accredited college or university.
PC proficiency with experience in Microsoft Office applications, with strong experiences in Power BI, Access, Excel, Word and PowerPoint.
Demonstrated knowledge of SQL for querying and manipulating data.
Demonstrated knowledge of enterprise resource planning (ERP), such as SAP.
Demonstrated knowledge of Port Authority policies and procedures.
Ability to perform financial evaluations and summarize results for non-financial staff with demonstrated ability to interpret and communicate complex information accurately and clearly.
Ability to interact with internal and external staff at all levels.
Demonstrated ability to handle multiple tasks and projects with competing time constraints.
Possess excellent written and oral communications skills.
Possess the ability to work both independently and as part of a team, as required.

Responsibilities

Produce in-depth analysis and reporting of traffic levels to understand trends and provide information to executive management for decision-making purposes. This includes but is not limited to daily, weekly, and monthly reports for the Director of TB&T and the Executive Director.
Provide traffic volume estimates for inclusion in Press Releases issued by Media Relations.
Develop detailed Spring and Fall typical day traffic distribution at each facility.
Perform special impact analysis relevant to traffic and toll revenue.
Compile traffic information for public posting on the Port Authority website.
Respond to requests for traffic data and analysis within PA and externally.
Maintain TB&T traffic reporting functions using RTCS (Replacement Toll Collection System) for performance analysis.
Develop SQL scripts to query toll system database.
Monitor issues related to toll system traffic data and CSC (Customer Service Center) transaction processing.
Streamline and update traffic reports to improve the dissemination of key traffic information as well as organize all traffic files/folders to better ensure accessibility of data and reports.
Manage traffic database and develop traffic analytics Power BI dashboards for informational and planning purposes for the department.
Develop models to forecast toll revenue on TB&T crossings with a 20-year planning horizon.
Produce accurate and timely revenue forecast submissions on a quarterly basis based on traffic forecasts and revenue inputs , including talking points.
Develop traffic and revenue distributions by time of day, day of week, facility, vehicle type, and payment method.
Optimize efficiency of toll revenue models and incorporate model changes.
Work on projects such as tolling policy to provide insightful analysis to executive management.
Work with Planning Department, TB&T staff and other relevant parties on forecast inputs and improvements to the long-range forecast.
Assess variances in actual toll revenues as compared to plan based on an analysis of recent traffic and financial trends.
Estimate monthly toll revenue for the six Port Authority vehicular crossings between New York and New Jersey.
The estimates are adopted as accruals in the monthly TB&T Budget Performance Report prepared by Revenue Accounting.
Produce monthly financial results and detailed variance explanations reported to the CFO.
Report on toll revenue-related metrics such as E- ZPass participation rates, revenue by facility and average toll by vehicle type.
Develop ad-hoc reports and presentations; prepare responses to internal and external inquiries.