К содержимому

Principal Operations Planning Analyst

The Port Authority of NY & NJNew York, New York, United States

About the Role

The Principal Operations Planning Analyst will report to the Manager of Toll Collection Systems within the Tunnels, Bridges & Terminals Department Tolls Revenue Operations & Systems Division, and will work closely with the Senior Program Manager, E- ZPass Toll System Technology & Maintenance and other managers. The successful candidate will collaborate with roadside systems, toll collection back-office, and other operational and technical teams to develop and maintain data analytics solutions, dashboards, and business intelligence tools. These efforts will support the identification of transaction anomalies, data discrepancies, operational trends, and potential toll revenue impacts.

The position will play a key role in protecting the Port Authority’s toll revenue by improving system performance visibility and translating complex data into actionable insights and recommendations that support management oversight and decision making. The selected candidate will join a growing team responsible for supporting the performance, integrity, and continuous improvement of electronic toll collection systems.

Responsibilities

  • Data Analysis and Validation: collect, validate, reconcile, and analyze data from multiple toll collection facilities and operational systems to confirm completeness and accuracy and identify data-quality issues, discrepancies, and anomalies
  • Business Intelligence and Reporting: design, develop, and maintain interactive dashboards, reports, and performance metrics using business intelligence data visualization tools including Microsoft Power BI, Tableau, to support operational monitoring and management decision-making.
  • Toll Revenue Protection: analyze toll transaction data to identify potential revenue leakage, duplicate transactions, processing irregularities, and other exceptions requiring investigation or corrective action.
  • Database Query Development: develop, optimize, and maintain advanced Oracle SQL queries and PL/SQL scripts to extract, transform, validate, and analyze large volumes of toll transaction and system data.
  • Data Automation and Scripting: develop and maintain Python scripts and other automated processes to improve data analysis, reporting efficiency, and identification of recurring data issues.
  • Trend Analysis and Forecasting: identify patterns, trends, and performance variations in toll collection data and develop quantitative analyses and forecasts to support operational planning and management decisions.
  • Performance Monitoring: Monitor toll collection system data and key performance indicators to identify unusual activity, emerging issues, and deviations from expected operating conditions.
  • Data Management and Standardization: establish and maintain reusable queries, analytical methodologies, reporting templates, and data validation procedures to promote consistency, accuracy, and efficiency.
  • Cross-Functional Coordination: collaborate with roadside systems, toll collection back-office teams, vendors, and other stakeholders to investigate data discrepancies, validate findings, and support the development and implementation of corrective actions.
  • Management Reporting: present analytical findings, performance trends, and identified issues in a clear, concise, and actionable format for operational leadership and senior management.
  • Continuous Improvement: identify opportunities to enhance data quality, automate reporting, improve analytical capabilities, and strengthen the monitoring and performance management of electronic toll collection operations.
  • Operational Support: provide periodic after-hours, weekend, and holiday coverage on a rotating basis to support the monitoring and analysis of toll collection systems, as required by the operational needs of a 24-hour environment.

Minimum Qualification s

  • Bachelor’s degree from an accredited college or university in Data Science, Computer Science, Information Systems, Statistics, Mathematics, or a related analytical field, or equivalent experience
  • Strong proficiency in Oracle SQL, including the ability to develop, troubleshoot, and optimize complex queries involving large datasets.
  • Working knowledge of PL/SQL and experience developing database scripts for data extraction, validation, and analysis.
  • Experience with business intelligence and data visualization tools, including Microsoft Power BI, Tableau, or comparable platforms.
  • Demonstrated experience collecting, validating, analyzing, and interpreting data from multiple sources.
  • Advanced Microsoft Excel skills, including data manipulation, analysis, and reporting.
  • Strong quantitative, analytical, problem-solving, and organizational skills.
  • Excellent written and verbal communication skills, including the ability to explain complex analytical findings to technical and nontechnical audiences.
  • Ability to manage multiple assignments, prioritize competing demands, meet deadlines, and work efficiently in a collaborative environment.
  • Ability to support a rotating schedule that includes occasional off-hours, weekend, and holiday coverage.
  • Valid driver’s license to travel to Port Authority facilities and participate in testing using Port Authority vehicles as required.

Desired Qualifications

  • Experience developing and maintaining interactive dashboards, reports, and performance scorecards using Microsoft Power BI.
  • Experience developing Python scripts to automate data analysis, reporting, and data validation processes.
  • Familiar with data warehousing, data integration, and extract, transform, and load (ETL) processes.
  • Knowledge of toll collection systems, electronic tolling operations, and toll collection back-office processes.
  • Experience analyzing high-volume transaction data to identify discrepancies, anomalies, trends, and potential revenue impacts.
  • Familiarity with database administration concepts, query performance tuning, and data management practices.
  • Experience with Excel macros, VBA, or other reporting automation techniques.
  • Knowledge of UNIX/Linux environments and shell scripting.
  • Familiarity with cloud computing platforms, including Microsoft Azure.
  • Experience with SAS or other statistical analysis tools.
  • Experience developing quantitative analyses, forecasting models, and operational performance metrics

Selection Process

The application process varies by position but typically includes an initial phone interview for qualified candidates, followed by a more in-depth interview(s) and/or assessment(s). Selected candidates who are made a conditional job offer will be asked to undergo a background check.

Compensation, Benefits & On-Site Collaboration Requirements

The Port Authority of New York and New Jersey offers a competitive benefits package and a professional environment that supports development and recognizes achievement.​ Click here for more information about benefits, our culture, and career development opportunities.​The Port Authority of New York and New Jersey anticipates that the actual salary offered to a successful candidate will depend on aspects such as experience, knowledge, skills, abilities, and internal factors. The expected compensation range for this role is:​

​

Minimum: $ 90 ,012 Midpoint : $ 117,018 Maximum : $ 144,014

In accordance with Port Authority policy, this position permits employees to work remotely a maximum of one day per week, subject to operational and business needs.

openqareer не кадровое агентство: вакансия собрана с открытого источника, отклик подаётся на сайте работодателя.