Senior Revenue Planning Analyst

Royal Caribbean International - Miami, FL

Full-time - Mid Level

Miami, FL

Food Services and Drinking Places

About the position

The Senior Revenue Planning Analyst at Royal Caribbean Group plays a crucial role in the financial forecasting and revenue management processes of the company. This position is responsible for building an accurate forecast and developing components within the Net Ticket Revenue (NTR) and Other Revenue forecasts, which collectively exceed $11 billion annually. The Senior Analyst will own the forecast model and ensure that all revenue reporting is accurate and consistently updated. This includes staying informed about all impacts to the brand's deployments and regularly communicating any revenue or volume impacts to relevant stakeholders. The role requires providing key financial information to the technical accounting team for external financial reporting, emphasizing the importance of attention to detail and accuracy. In addition to managing the NTR model, the Senior Analyst will maintain and upload the consolidation of the NTR Forecast for all versions of Forecast and Plan, necessitating close communication with brand Revenue Management leaders and finance teams. The position also involves providing NTR statistics to various teams, ensuring the accuracy of weekly revenue reports, and contributing to external financial reporting. The Senior Analyst will prepare for quarterly Earnings Calls and perform risk and opportunity analyses of forecasts and plans, reporting findings to leadership. Furthermore, the role includes supporting ancillary revenue products and providing detailed variance analyses at month-end and quarter-end results to senior leadership. The Senior Revenue Planning Analyst will foster relationships with various teams, including revenue management leadership, brand finance, and accounting, while continuously seeking potential business improvements and revenue opportunities. This position is based on-site in Miami, FL, and reports to the Revenue Senior Manager.

Responsibilities

• Build and maintain an accurate forecast model for Net Ticket Revenue and Other Revenue.
• Update all deployment changes, sailing characteristics, and relevant data in the NTR model.
• Maintain and upload the consolidation of the NTR Forecast exceeding $11B annually for all versions of Forecast and Plan.
• Provide NTR statistics to Port Ops Finance and brand revenue teams for forecasting purposes.
• Manage the Forecast Automation Tool and ensure all inputs are updated according to changes in financial systems.
• Validate weekly revenue reports and collaborate with the RMDS team to address any issues.
• Ensure reporting accuracy through frequent analysis and maintenance of financial standards.
• Contribute to external financial reporting and provide statistics for quarterly financial variance explanations.
• Prepare documents and presentations for quarterly Earnings Calls.
• Conduct risk and opportunity analyses of forecasts and plans, reporting findings to leadership.
• Perform ad-hoc analyses on current trends and external impacts to the business as requested.
• Serve as a subject matter expert for net ticket revenue forecast topics and improve revenue tools with the RM Development and Systems team.
• Support ancillary revenue products, including Cancellation penalty revenue.
• Provide detailed variance analyses at month-end and quarter-end results to senior leadership.
• Work closely with accounting teams to reconcile accounting actuals to revenue reports and research variances.
• Foster relationships with various teams to enhance collaboration and efficiency.

Requirements

• Master's degree (M.B.A. or M.A.) preferred; Bachelor's degree (B.A.) required.
• Three or more years of work experience in an analytical field.
• Demonstrated understanding of revenue management and complex economic concepts.
• Experience in project management.
• Ability to develop and deliver high-quality, clear, and concise presentations.
• Strong organizational skills to analyze and interpret large volumes of data.
• Understanding of basic accounting principles.
• Familiarity with revenue management concepts and problem-solving aptitude.
• Strong financial skills to analyze and interpret complex financial data.
• Superior skills in Excel, PowerPoint, Hyperion, and Power BI.
• Ability to logically structure complex quantitative analyses.
• Effective communication skills for both business and technical audiences.
• Attention to detail and willingness to accept immediate product and project responsibility.
• Excellent interpersonal skills and demonstrated maturity.
• Ability to teach and coach a team of analysts.
• Ability to manage multiple projects and responsibilities independently.

Benefits

• Competitive compensation package
• Career development opportunities
• Unique ways to explore the world