Analyst, Commercial Planning

class="jobdescription"> 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 Management Team 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 role is responsible for developing and maintaining revenue management dashboards used daily by cross-functional stakeholders, including Revenue Management, Sales, Marketing, eCommerce, and International teams. 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 commercial objectives. Essential Duties and Responsibilities: 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. Qualifications, Knowledge and Skills: 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 Qualifications 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. Agency and Third-Party Submissions: Please note this is a direct search by the Company, and applications through agencies and other third parties will not be accepted, nor will fees be paid for unsolicited resumes. Any unsolicited resumes will be considered the Company's property. We know there's a lot to consider. As you go through the application process, our recruiters will be glad to provide guidance, and more relevant details to answer any additional questions. Thank you again for your interest in Royal Caribbean Group. We'll hope to see you onboard soon! 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 Group and each of its subsidiaries prohibit and will not tolerate discrimination or harassment. Nearest Major Market: Miami Apply now » Apply now Apply Now Start applying with LinkedIn Start Please wait... Find similar jobs: Careers Home Top Jobs View All Jobs Royal Caribbean Corporate Site Applicants with Disabilities Opens in a new tab. Opens in a new tab. Opens in a new tab. Copyright © 2021 Royal Caribbean Group. All rights reserved. × Cookie Consent Manager When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. Required Cookies These cookies are required to use this website and can't be turned off. Required Cookies Show More Details Required Cookies Provider Description Enabled SAP as service provider We use the following session cookies, which are all required to enable the website to function: "route" is used for session stickiness "careerSiteCompanyId" is used to send the request to the correct data center "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another Cookies from provider SAPasserviceprovider are required and cannot be turned off Advertising Cookies These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies. Consent to all Advertising Cookies Show More Details Advertising Cookies Provider Description Enabled LinkedIn LinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn. Cookie Policy Cookie Table Privacy Policy Terms and Conditions Consent to cookies from provider LinkedIn AddThis Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. Cookie Information Privacy Policy Terms and Conditions Consent to cookies from provider AddThis Confirm My Choices Accept All Cookies // <