Revenue Analytics & Planning Analyst

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

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