Sr. Analyst, Business Intelligence

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., * 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., * 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.

• 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

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.