Senior Revenue Forecasting Analyst

We are looking for an amazing Senior Analyst, Revenue Forecasting. This role involves analyzing data and making recommendations based on your analysis, ensure forecast submission is accurate as well as presenting your recommendation in a precise and compelling manner. Scope also includes routine and ad-hoc tasks that may be frequent or in-frequent in nature as well as assisting Ancillary Revenue team in data analysis and forecast. The role is responsible for project managing the process by taking input/guidance from other departments to compile a detailed forecast. This incumbent will need to interact with various levels of the organization from analysts to Senior Leaders. You will need to have a strong analytical background and experience compiling multi-year forecasts.

Here’s a summary of what Princess is looking for in its Senior Analyst,Revenue Forecasting. Is this you? 

This position is responsible for compiling and submit multi-year revenue and occupancy forecast in quarterly basis. This position is also responsible for developing and executing models associated with various forecast components. Responsible for identifying and/or responding to requests to execute various ad hoc analyses that results in calculable insights pertaining to variance analyses (actual vs forecast).

Responsibilities

Revenue Component Forecasting
- Responsible for forecasting ticket revenue components
- Create reports and models that provide meaningful insights into past performance and future trends to support and guide decision making 
- Drive continuous improvement in the forecasting process and methodology
- Automate and streamline forecast data collection and reporting 
- Present new findings and summarize forecast recommendation to management prior to forecast submission
- Drive story-telling for each component and how they resonate with company trends 
- Analyse and compare actual vs forecast in monthly basis
- Study forecast misses and how to incorporate improvement in future forecasts
- Ensure actuals are loaded in the right manner

Compiling and Submitting forecast 
- Ensure forecast is submitted in correct format and signage
- Drive regular meeting with finance to understand changes and update in Hyperion format
- Facilitate process and communication with Finance team and ensure little to no topside needed

Ancillary Revenue Support
- Assist Ancillary revenue team in data analysis
- Assist Ancillary revenue team in forecasting revenue and cost

Ad hoc Reporting
- Lead ad-hoc projects by gathering information, scope, and develop ad hoc analysis and reporting that provide insight into our business

Performs other duties as assigned

 Requirements

• Advanced Excel and PowerPoint required
• Intermediate SQL
• Experience using data visualization tools such as Tableau or Power BI
• Excellent presentation and story-telling skill, able to present complex data analyses into simple, concise, and engaging stories using Power Point
• Detail oriented
• Resilience and ability to work with ambiguous information
• Ability to work across multiple teams and drive development with little guidance
• Ability to tell a compelling story using analysis and company trend
• Self-starter with the ability to work both independently and on a team
• Excellent organizational and communication skills 
• Ability to work in fast paced environment and meet critical deadlines 
• Flexible regarding peak-time work requirements 
• Ability to work well with individuals at all levels

 Problem solving:
Problem solving is critical for this role as well as ability to navigate issues and trouble shoot. Resourcefulness, ability to find the right person in the organization to assist you to problem solve.

Impact:
Become expert in revenue components and point of contact for any component related topic.

Leadership:
Lead commercial and finance effort and organize findings which assist in more accurate forecast
Lead effort in incorporating new finding and analysis into forecasting model

Knowledge:  Understanding of workplace policies and procedures / Familiarity with team collaboration tools and techniques.
Skills:  Strong time managem