Analyst, Sr. Revenue Planning

Journey with us! Combine your career goals and sense of adventure by joining our exciting team of employees. Royal Caribbean Group is pleased to offer a competitive compensation and benefits package, and excellent career development opportunities, each offering unique ways to explore the world.

The Royal Caribbean Group has an exciting career opportunity for a full time Senior Analyst, Revenue Planning reporting to the Revenue Sr Manager.

This position sits on-site in Miami, FL

Position Summary:

The Senior Analyst, Revenue Planning is responsible for building an accurate forecast and the development of components within the Net Ticket Revenue (in excess of $11B annually) and Other Revenue forecasts, including the ownership of the forecast model. The Senior Analyst ensures that all revenue reporting is accurate and updated on a consistent basis; this includes staying abreast of all impacts to our brand's deployments and communicating any revenue and/or volume impacts on a regular basis. The Senior Analyst will be responsible for providing key financial information to our technical accounting team for external financial reporting (attention to detail and accuracy are paramount for the role). The Senior Analyst will assist in the opportunity/risk analysis of our corporate net revenue forecast and is expected to stay abreast of current business trends. The Senior Analyst also acts as a key point of contact for Forecast within the Revenue Planning team.

• Responsible for the Net Ticket Revenue model including updating all deployment changes, sailing characteristics, and all relevant data. Ability to work with complex models and datasets.
• Maintains and uploads the consolidation of the Net Ticket Revenue Forecast in excess of $11B annually for all versions of Forecast and all versions of Plan. This includes close communication with the brand Revenue Management leaders and brand finance teams.
• Provide NTR stats to Port Ops Finance and brand revenue teams, as well as any person or team in need of NTR data for forecasting purposes.
• Responsible for the Forecast Automation Tool, and ensuring all inputs are updated in relation to any changes to our financial systems.
• Validation of weekly revenue reports; working with RMDS team on a consistent basis if any issues arise/ to make changes as necessary. This is a critical report for the revenue management and revenue planning teams and drives key business decisions.
• Responsible for reporting accuracy - this includes the frequent analysis, updating, and maintenance of the financial standards process within our reporting.
• Contributes to external financial reporting, works alongside technical accounting to provide stats for financial reporting as well as quarterly financial variance explanations. Accuracy is essential.
• Involvement in the preparation of the quarterly Earnings Call preparation document and presentation.
• Provides consistent risk/opportunity analyses of our forecast/plan. Reports clear/concise findings to leadership.
• Performs thoughtful and insightful ad-hoc analyses as requested on current trends, external impacts to our business, and any other relevant request.
• Serve as subject matter expert for all net ticket revenue forecast topics. Work with RM Development and Systems team to develop and improve revenue tools with the goal of facilitating better decision making, reporting, and forecasting.
• Support ancillary revenue products including Cancellation penalty revenue totaling over $200 million annually.
• Provide detailed variance analyses at month-close, provide summary of month-end and quarter-end results to senior leadership.
• Work closely with accounting teams to reconcile accounting actuals to revenue reports at a component level, if needed. Research any known variances and work with the accounting team to reconcile any differences.
• Foster relationships with revenue management leadership, brand finance, port ops, air/sea, sales planning, accounting, and deployment teams.
• Continuously search for potential business improvements, revenue opportunities and efficiency gains.

• Masters of Business Administration (M.B.A.) or master's degree (M. A.) preferred. Bachelor's degree (B. A.) from four-year University required
• Three or more years work experience in an analytical field
• Demonstrated understanding of revenue management and complex economic concepts
• Demonstrated experience in project management.
• Demonstrated ability to develop and deliver high quality, clear and concise presentations required.
• Demonstrated ability to organize, analyze, and interpret large volumes of data
• Demonstrated understanding of basic accounting principles
• Familiarity with revenue management concepts and demonstrated aptitude for problem solving
• Strong financial skills / ability to analyze and interpret complex financial data Superior skills in Excel, PowerPoint, Hyperion, Power BI
• Ability to logically structure complex quantitative analyses.
• Ability to communicate clearly and effectively to business and technical audiences in both spoken and written formats.
• Attention to detail required. 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 on an ongoing basis.