Revenue & Forecasting Analyst — Passenger Rail

KiwiRail Freight; Auckland; On-site; NZD 90,000 - 130,000; Full time

Job summary

KiwiRail is seeking a Commercial Analyst to turn passenger, booking, and financial data into clear insights that support better commercial decisions. You will work with the Revenue Optimisation Lead and cross-functional teams to identify opportunities in revenue, pricing, forecasting, and service performance.

You will develop forecasts, support fare reviews, prepare performance reporting, and translate complex analyses into practical recommendations, while helping improve data quality and

Qualifications

• At least three years' experience in commercial analysis, revenue management, financial analysis, or a related analytical role.
• Strong analytical and problem-solving skills with an understanding of pricing, revenue, demand, forecasting, and financial performance.
• Experience developing forecasts, analytical models, and performance reports, alongside advanced Excel skills and Power BI or similar tools.
• Confidence working with large datasets from multiple sources, maintaining data quality, and translating complex findings into practical recommendations.
• A curious, collaborative, and adaptable approach, with an interest in using AI and emerging analytical tools appropriately.

Responsibilities

• Analyse passenger demand, booking patterns, revenue, yield, capacity utilisation, and booking lead times to identify trends, risk, and commercial opportunities.
• Develop and maintain passenger demand and revenue forecasts, supporting budgets, reforecasts, and longer‑term planning.
• Support fare reviews, pricing initiatives, and the development of revenue management capability.
• Prepare commercial performance reporting, investigate variances, and translate complex analysis into clear recommendations.
• Evaluate pricing, promotional and other commercial initiatives to understand their impact on demand, yield, and revenue.
• Work with Finance, Sales, Marketing, Product, Customer Experience and Operations to improve commercial outcomes.
• Improve analytical processes, data quality, and reporting, and support the commercial requirements of future booking‑system capability.
• Monitor tourism trends and provide meaningful insights to the Passenger team.

Skills

Advanced Excel

Power BI

Forecasting

Data analysis

Cross-functional collaboration

Education

Tertiary qualification in Commerce/Finance/Economics/Statistics/Business

Tools

Power BI

Excel

Job description

KiwiRail is seeking a Commercial Analyst to turn passenger, booking, and financial data into clear insights that support better commercial decisions. You will work with the Revenue Optimisation Lead and cross-functional teams to identify opportunities in revenue, pricing, forecasting, and service performance.

You will develop forecasts, support fare reviews, prepare performance reporting, and translate complex analyses into practical recommendations, while helping improve data quality and