Sr. Transportation Programs Analyst

The Port Authority of NY & NJ • New York, NY

10d • Hybrid

About The Position

Reporting to the Sr. Supervisor E-ZPass Customer Services, the Sr. Transportation Programs Analyst will be responsible for developing analytical tools to track all data related to related to the collection and reporting of toll revenue data. The ideal candidate will also be able to expand our reporting to provide data analytics on our revenue recovery efforts.

Requirements

• Must possess a bachelor's degree from an accredited college or university in Computer Science, Applied Analytics, Statistics or a related field.
• Expert knowledge of MS Access databases including the ability to create user forms, reports, queries and VBA code.
• Expert knowledge of MS Excel including creating VBA code.
• Expert knowledge of SQL including advanced Oracle SQL queries.
• Advanced knowledge of Power BI or a similar dashboard tool.
• Excellent written and verbal communication skills.
• Able to assess multiple requests and deliver quality work in a timely manner.

Nice To Haves

• Experience with providing insightful analytics on large data sets.
• Experience with SharePoint and Power Automate workflows.
• Experience with FTP sites and XML.
• Experience with MS Word mail merge.
• Knowledge of toll collection and/or back-office operations.

Responsibilities

• Maintaining and enhancing the Revenue Recovery MS Access production databases.
• Running reports and analysis for internal and external clients and management.
• Performing research on accounts utilizing a combination of online systems and databases.
• Running Oracle SQL queries to extract violator data from the Customer Service Center database.
• Processing payment files received from external collection agencies for reporting and crediting purposes.
• Updating the Revenue Recovery metrics and dashboard.
• Identifying and implementing improvements to current processes.
• Occasional off-hours support required

Benefits

• The Port Authority of New York and New Jersey offers a competitive benefits package and a professional environment that supports development and recognizes achievement.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees