Commercial Planning Analyst

About Us

Celebrity Cruises is a global multi-billion dollar luxury cruise line based in Miami Florida with local offices in Sydney Celebrity Cruises has a fleet of fifteen ships sailing the Caribbean Europe Alaska Asia South America Galapagos and Australia/New Zealand Since 2010 Celebrity Solstice series ships have sailed the summer season in Australia and New Zealand sourcing both local and international guests to the region In 2023 Celebrity is set to revolutionise cruising in our region as we bring Celebrity Edge down under for her highly anticipated inaugural season The Australia and New Zealand region contributes nearly 60000 guests annually to the Celebrity brand 50% of which travel internationally

With this investment the brand is targeting significant growth over the coming years with all global regions expected to source more guests and grow revenues

Position Summary

The Commercial Planning Analyst is responsible for the delivery and maintenance of the organisation’s business reporting of key revenue metrics to ensure maximization of guests and revenue for the Celebrity Cruises brand in Australia & New Zealand The position has responsibility for reporting and interpretation of business performance at a local product level as well as providing insights and reporting on performance of our globally deployed ships to achieve the market’s annual guest and revenue plan

Key Responsibilities

Business analysis - responsible for preparing / updating the weekly performance reporting including the weekly trading meeting and the sailing level performance summary Continually thinks of ways to improve reporting to be more efficient and to drive further insights

Pricing Analysis – continual review (weekly/monthly) of the booked APD (Average Per Day) position vs forecast and report key findings and opportunities/risks to revenue team to help shape pricing and inventory decisions Provide concise summaries of recommended changes to the North America Revenue Team

Competitor Pricing – Monitors competitor pricing and promotions Reports on competitor trends to the North America Revenue Team and senior management

Market Sourcing – continual review of market performance against annual sourcing plan Provide concise summaries of how our sourcing requirements have changed between forecast rounds Makes recommendations to the business on the optimisation of our rest of world sourcing mix based on itinerary length of sailing and proximity to sailing

Channel Analysis - performs analysis on channel performance and share against track and forecast Review channel share at sailing level and provide concise summaries back to the business on what this means for the remaining guests we need to book

Track Performance & Analysis – continual review of booking performance vs track identifying any sailings which require additional focus Responsible for the optimisation of the future track curve; through booking window analysis (both passenger and APD) overlayed with promotional and strategic initiatives Owns communicating changes and working with Miami to ensure loaded successfully Recommends and implements improvements to the local track override model

Retention Analysis – Develop a good understanding of retention rate models and the impact on the booked position Be the ‘first line of defence’ in identifying any unexpected movements in our booked position which could be driven by unexpected retention behaviour Work with Commercial Director to investigate this further

Promotional Reporting Analysis – Provide regular analysis on booking performance in relation to the promotional strategy including but not limited to key promotional periods (eg Black Friday) strategic partnerships and specific (eg product focused) promotional offers

Annual Operating Plan – Provides strategic insights and performance analysis to Senior Management as part of the Annual Operating Plan process helping to support the overall strategic goals of the business for future years

Liaise with Miami – Establishes and maintains successful relationships with peers in the Revenue Management Revenue Planning and the International Business Performance teams in Miami to understand live projects and to advocate for the Australia office Work with Miami Revenue Strategy & Commercial teams to adopt latest reporting tools and/or request resourcing to support local business

Perform other duties as required This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position

Experience / Knowledge & Skills

Experience gained within the travel industry is preferred

Proactive and positive way of working

Commercial vision and a highly analytical approach

Developed strategic and business analysis skills and effective decision making

Highly numerate Able to work with mathematical concepts ie probability percentages ratios etc

Proven experience using data visualisation tools (i e Power BI)

MS Excel advanced level

SQL experience is preferred

Strong personal organization required & ability to work to deadlines

Demonstrated ability to communicate present and influence credibly

An ability to demonstrate sound judgment and resourcefulness in decision making and problem solving

Qualification and Education

Bachelor’s degree in business analytics

or finance related topic

2 years in an analytical financial or commercial role