Analyst, Commercial Planning

Royal Caribbean Group; Miami (FL); Hybrid; USD 70,000 - 95,000; Full time

Job summary

Royal Caribbean Group in Miami is seeking a full-time Commercial Planning Analyst to support the company’s revenue strategy through analytics and reporting. You will develop and maintain dashboards used daily by cross-functional teams, including Revenue Management, Sales, Marketing, eCommerce, and International teams.

The role involves ad hoc analyses of large datasets, creating actionable insights for leadership, forecasting models for daily and weekly bookings, and presenting findings in

Qualifications

• Bachelor’s degree in Data Analytics, Business Administration, Information Systems, or a related field.
• 1–3 years of professional experience in data analytics, business analysis, finance, or a related field.
• Strong proficiency in SQL and other analytical languages and tools.
• Experience using Databricks and DBeaver.
• Experience designing and maintaining Power BI dashboards.
• Excellent Excel skills including Pivot Tables and VLOOKUP.
• Strong communication and collaboration skills.

Responsibilities

• Develop and maintain analytical tools and reporting to support revenue strategy decisions.
• Extract and analyze data from large datasets using SQL.
• Combine data from multiple sources using Databricks and DBeaver to produce insights.
• Design, build, and enhance Power BI reports and dashboards for cross-functional stakeholders.
• Deliver regular and ad hoc reporting for senior leadership.
• Develop forecasting models for bookings and product sales.
• Create PowerPoint presentations translating findings for senior leaders.
• Collaborate with stakeholders to answer analytical questions and troubleshoot reporting issues.
• Identify opportunities to automate reporting and improve workflows.

Skills

SQL

Databricks

DBeaver

Power BI

Excel

PowerPoint

Data analysis

Cross-functional collaboration

Education

Bachelor's degree in Data Analytics, Business Administration, Information Systems, or related field

Master's degree preferred

Tools

Databricks

DBeaver

Power BI

Job description

Select how often (in days) to receive an alert:

Analyst, Commercial 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.

We are proud to be the vacation-industry leader with global brands — including Royal Caribbean International, Celebrity Cruises and Silversea Cruises — the most innovative fleet and private destinations, and the best people. Together, we are dedicated to turning the vacation of a lifetime into a lifetime of vacations for our guests.

The Royal Caribbean Group’s Revenue ManagementTeam has an exciting career opportunity for a full time Commercial Planning Analyst reporting to the Commercial Strategy Manager.

The position is onsite and based in Miami, Florida.

The position is also not eligible for work authorization sponsorship.

Position Summary:

The Revenue Strategy Analyst is a member of the Celebrity Cruises Revenue Management department and plays a key role in supporting the company’s commercial strategy through analytics and reporting. This roleis responsible fordeveloping andmaintainingrevenue management dashboards used daily by cross-functional stakeholders, including Revenue Management, Sales, Marketing, eCommerce, andInternationalteams. The Analyst conducts ad hoc analyses using large, complex datasets and translates findings into actionable insights that inform leadership decision-making. The Revenue Strategy Analyst is an integral contributor to enabling the Revenue Management team to achieve the brand’s commercialobjectives.

Essential Duties and Responsibilities:

• Develop andmaintainanalytical 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 toidentifytrends, drivers, and opportunities that address key business questions.
• Design, build, and enhance Power BI reports and dashboards used by cross-functional stakeholders tomonitorrevenue performance.
• Maintain existing Power BI dashboards by resolving data issues, improving functionality, and ensuring ongoing accuracy and usability.
• Deliver regular and ad hoc reporting thatprovidesclear insightstosenior leadership in both formal and informal settings.
• Develop andmaintainforecasting 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 identifyappropriate datasources.
• Identifyopportunities to automate reporting and analytical workflows and implement process improvements to drive efficiency,leveraginggenerative AI tools whereappropriate.

Qualifications, Knowledge and Skills:

• Bachelor’s degree in DataAnalytics, Business Administration, Information Systems, ora relatedfield of study.
• 1–3 years of professional experience in data analytics, business analysis, finance, or a related field.
• Strongproficiencyin SQL and other analytical programming languages and tools.
• Experience using data query and analytics platforms such as Databricks,DBeaver, or similar technologies.
• Experience designing andmaintainingdashboards 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.
• Advancedproficiencyin 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 Qualifications

• Master’s degree in DataAnalytics, Business Administration, Information Systems, ora relatedfield of study.
• Prior experience in the cruise, travel, or hospitality industry.

It is the policy of the Company to ensure equal employment and promotion opportunity to qualified candidates without discrimination or harassment on the basis of race, color, religion, sex, age, national origin, disability, sexual orientation, sexuality, gender identity or expression, marital status, or any other characteristic protected by law. Royal Caribbean Groupand each of its subsidiaries prohibit and will not tolerate discrimination or harassment.