Sr. Analyst, Business Intelligence

Royal Caribbean Group; Miami (FL); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Royal Caribbean Group's Onboard Revenue Data & Analytics team seeks a Senior Analyst to drive Shore Excursions and PCP revenue growth through scalable analytics and predictive modeling.

You will collaborate with IT and data teams to migrate data to the cloud platform, build Power BI dashboards, and deliver insights to executives.

This on-site role at the Royal Caribbean Headquarters in Miami requires strong SQL/Python skills, hands-on BI experience, and the ability to communicate complex results.

Qualifications

• Bachelor's degree or MBA/MS preferred; 4-year degree or equivalent with strong financial analytics background is common
• Familiarity with revenue management, pricing concepts, and inventory management is preferred
• Cruise, hospitality, or related industry experience is advantageous

Responsibilities

• Design, develop, and deploy ML models and analytics to forecast revenue and optimize pricing for Shorex and PCP
• Collaborate with IT and data teams to migrate to the Alpha Data platform and ensure data integrity and scalable architecture
• Develop Power BI dashboards to replace Hyperion queries and provide actionable insights to leadership

Skills

SQL

Python

Power BI

VBA

Alteryx

Education

Bachelor's degree or MBA/MS preferred

Tools

Hyperion

SAS

Essbase

Job description

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

This position is on – site in our Royal Caribbean Headquarters 1050

Journey with us!

Combine your career goals and sense of adventure by joining our incredible team of employees at Royal Caribbean Group. We are proud 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.

Royal Caribbean Group’s Royal Caribbean International, Onboard Revenue team has an exciting career opportunity for a full-time Senior Analyst, Business Intelligence reporting to the Manager, Data Science.

Position Summary

The Senior Analyst, Onboard Revenue Data & Analytics will play a pivotal role in leveraging advanced data science and technology to drive Shore Excursions (Shorex) and Pre-Cruise Purchases (PCP) revenue growth. This position will focus on building scalable analytics solutions, developing predictive models, and implementing automation across all reporting and operational processes.

The Senior Analyst will collaborate with cross-functional teams to migrate and optimize data infrastructure and deliver actionable insights to executive leadership. This role will work with IT and data teams to migrate all onboard revenue and hotel operations data from Oracle to the cloud-based corporate data platform. This role will also develop new data objects and power BI reports when the new reservation system is rolled out.

Essential Duties and Responsibilities

• Design, develop, and deploy machine learning models and advanced analytics to forecast revenue, optimize pricing, and improve inventory management for Shorex and PCP.
• Collaborate with IT and the data engineering team to oversee the migration to the Alpha Data platform, ensuring alignment with business needs, data integrity, and scalable architecture
• Develop Power BI Dashboards to replace all Hyperion queries.
• Engineer and maintain robust data pipelines using modern ETL tools and cloud platforms (e.g., Azure, AWS, GCP) to support real-time and batch analytics.
• Develop New Data Objects and Power BI dashboards to pull data from the new reservation system.
• Assists Shorex and PCP in revenue generation by utilizing data and implementing a wide range of operational as well as analytical solutions and influence the business by effectively communicating results to management.
• Helps manage pricing, inventory, and promotional efforts in multiple online systems and provides a wide range of solutions and support to grow onboard revenue.
• Ensure data quality, governance, and security across all analytics and reporting activities.
• Performs analysis to prove effectiveness of pricing changes during frequent PCP online promotions
• Works closely with Shorex and PCP teams to understand their business challenges and objectives and identify opportunities to develop potential business improvements, and efficiency gains
• Mentor team members and promote best practices in data science, analytics, and technology adoption.
• Stay current with emerging technologies, tools, and methodologies in data science, analytics, and cloud computing.
• Responds to ad-hoc data and analysis needs while supporting various projects and conducts analyses of business data, evaluate trends and pattern changes, and learn to disperse results in a format appropriate for the audience
• Assists with the development of revenue and Shorex forecasts using benchmarking and other techniques to continually improve the accuracy of these forecasts
• Transform large data sets into insightful components that will effectively develop pricing strategies and lead to continued iterative growth of revenue
• Represents onboard revenue when required specifically with many of the Shared Services departments, to gain support for initiatives
• Performs any other job-related duties assigned by their supervisor or management

Performs other duties as required. This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.

Qualifications and Education

• Four-year Bachelor's or equivalent (MBA or MS preferred); or two to three years related financial and business analysis experience and/or training; or equivalent combination of education and experience
• Familiarization and experience in revenue management, inventory and pricing concepts strongly preferred
• Experience in cruise, casino, hospitality or a similar industry preferred
• Microsoft Office (Excel, Word, PowerPoint) and basic analytical skills are required
• Proficiency in SQL, Python, Power BI, VBA, Alteryx is required
• SAS, Essbase, Hyperion, and database management/administration (DBM/DBA) preferred

Knowledge and Skills

• Strong written as well as verbal communication skills, interpersonal skills and ability to work in global environment
• Able to define problems, collect data, establish facts, and draw valid conclusions
• Finding and understanding the correct data sources for a given analysis
• Ability to work in a fast-paced environment while managing multiple projects and responsibilities at once with little direction
• Proven experience in project management
• Understanding of the business to validate findings and conclusions and always ensure data integrity and accuracy
• Willingness to accept immediate product and project responsibility
• Facilitate meetings and present solutions to issues with groups while dealing with variety of variables in situations where no standardization exists
• Ability to respond to inquiries from other departments, customers, or members of the business community
• Knowledge and support of Photo, Internet, and all onboard revenue categories, with the ability to analyze and optimize data and reporting for these areas.
• Demonstrated experience in database management and administration (DBM/DBA), including support for cloud and on-premises data platforms.
• This position requires travel up to 10% of total time working onboard to support and improve shipboard operations
• Support reporting, systems to support daily and strategic revenue decisions and analyses for the onboard revenue department, impacting the company’s annual net onboard revenue stream of over $1 Billion

Working Conditions

The physical demands described here are representative of those requirements employees must meet to perform the essential functions of this job with or without reasonable accommodation. While performing job functions the employee is regularly required to sit, stand, write, review and type reports, compile data, operate a pc, communicate, listen, and assess information.

The employee may move about the office complex, may travel to other office locations, and may lift, push, pull or move 10 - 15 pounds. Visual requirements include distant, close and color vision, and ability to adjust focus.

We knowthere'sa lot to consider.

As you go through the application process, our recruiters will be glad to provide guidance, and more relevant details to answer anyadditionalquestions. Thank you again for your interest in Royal Caribbean Group.

It is the policy of the Company to ensure equal employment and promotion opportunity to qualified candidates without discrimination or harassmenton the basis ofrace, 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.

We are committed to providing equal employment opportunities and to providing reasonable accommodation to support candidates with disabilities during our hiring process.If you need a reasonable accommodation, please reach out to us at . This email is for disability-related accommodation requests only.