Royal Caribbean Group is a vacation-industry company operating global cruise brands and destinations. The Commercial Planning Analyst supports revenue strategy through analytics, reporting, dashboard development, forecasting, and actionable insights for cross-functional stakeholders and senior leadership.
Develop and maintain analytical tools and reporting that support revenue strategy decisions, including cruise ticket pricing and performance management
Extract and analyze data from large, complex datasets using SQL and other analytical programming languages and tools
Combine data from multiple sources using platforms such as Databricks, DBeaver, and similar technologies to produce reliable, insight-driven analyses
Analyze data using Microsoft Excel to identify trends, drivers, and opportunities that address key business questions
Design, build, and enhance Power BI reports and dashboards used by cross-functional stakeholders to monitor revenue performance
Maintain existing Power BI dashboards by resolving data issues, improving functionality, and ensuring ongoing accuracy and usability
Deliver regular and ad hoc reporting that provides clear insights to senior leadership in both formal and informal settings
Develop and maintain forecasting models for daily and weekly bookings, All-Included package sales, and other products to support revenue target-setting and performance management
Create clear, concise PowerPoint presentations that translate analytical findings into actionable insights for senior leaders
Collaborate closely with internal stakeholders to answer analytical questions, troubleshoot reporting issues, and identify appropriate data sources
Identify opportunities to automate reporting and analytical workflows and implement process improvements to drive efficiency, leveraging generative AI tools where appropriate
Qualification
Required
• Bachelor's degree in Data Analytics, Business Administration, Information Systems, or a related field of study
• 1–3 years of professional experience in data analytics, business analysis, finance, or a related field
• Strong proficiency in SQL and other analytical programming languages and tools
• Experience using data query and analytics platforms such as Databricks, DBeaver, or similar technologies
• Experience designing and maintaining dashboards in Power BI
• Working knowledge of database structures, data models, and information systems, with hands-on experience using database tools
• Strong understanding of core business concepts and revenue performance drivers
• Advanced proficiency in Microsoft Excel, including the use of Pivot Tables, VLOOKUP formulas, and similar functions
• Experience using Microsoft PowerPoint to communicate analytical insights through clear and digestible presentations
• Strong written and verbal communication skills, with the ability to present findings clearly to diverse audiences
• Demonstrated analytical curiosity and interest in commercial and revenue-focused insights
• Ability to work independently on defined analytical tasks while managing priorities with limited day-to-day direction
• Strong collaboration skills and ability to work effectively with cross-functional stakeholders
• Ability to explain complex technical concepts and analytical results to non-technical audiences
• Creative and structured problem-solving skills, with a data-driven approach to decision support
Preferred
• Master's degree in Data Analytics, Business Administration, Information Systems, or a related field of study
• Prior experience in the cruise, travel, or hospitality industry
Benefits
Competitive compensation and benefits package
Excellent career development opportunities
The position is onsite and based in Miami, Florida
Royal Caribbean Group is a cruise vacation company with a global fleet of 63 ships traveling around the world.
