Analyst, CAM Air Travel Planning

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 CAM Air Initiatives Team has an exciting career opportunity for a full time Spec, SHRS&S Travel.

Position Summary:

The CAM Air Travel Planning Analyst supports the end‑to‑end operation of global crew air travel by managing large, complex datasets, optimizing automation tools, resolving system issues, and ensuring operational continuity across a 24/7 environment. This role is responsible for analyzing airline spending, monitoring performance of air robotics, maintaining critical air systems, and providing cross‑functional insights to Air Operations, HR, Finance, and other internal partners. The analyst plays a key role in ensuring efficient, cost‑effective, and reliable air travel solutions for shipboard crew worldwide while supporting ongoing systems improvement, compliance, and operational integrity. This role  requires strong analytical capability, advanced GDS and SQL proficiency, and the ability to 
respond to urgent, time‑sensitive operational needs.

Essential Duties and Responsibilities

• Extract, process, and analyze large-scale datasets related to bookings, refunds, automation performance, vendor utilization, and crew travel trends to identify inefficiencies and improvement opportunities.
• Analyze airline-specific data to monitor spending patterns, booking behaviors, and contract performance to support Finance and vendor strategy.
• Apply deep SQL expertise to build, validate, and maintain datasets and dashboards in Power BI to deliver executive-level reporting.
• Conduct root-cause analyses to resolve failures in robotic processes, booking flows, or system integrations.
• Manage 50+ air automation tools (“air robotics”) tied to $220M+ in annual airline spend, ensuring accuracy, compliance, and performance stability.
• Monitor robotic reshopping tables to validate pricing accuracy and confirm application of contracted fares, tariffs, and rule updates.
• Review and enhance booking robotics/script applications to automate repetitive tasks and reduce error rates.
• Conduct detailed PNR audits to validate data flow across Sabre, JDE, TravelMart, and AFMS.
• Perform detailed checks and balances for AFMS exceptions, including debit memos, refunds, and other back‑office workflows.
• Develop and maintain custom SABRE PFKEYS, Quick Keys, and Script Builder configurations to optimize frontline workflows.
• Extract and interpret operational data from JDE, Sabre booking robotics, AFMS, ARC, and internal systems to support policy and process refinement.
• Own the standard cost setup process for new builds in JDE (E1), ensuring data accuracy and completeness.
• Create and maintain SOPs for all air systems to standardize operations and ensure system reliability and compliance.
• Support shipboard crew by providing ad hoc issue resolution, including troubleshooting, escalations, and exception handling.
• Provide analytics and insights to HR, Finance, Revenue, and the Air/Sea department to ensure alignment on workforce movement, budget, and operational priorities.
• Execute strategic analyses—such as gateway modeling, logistic planning, and cost analysis—to support network planning and cost efficiency.
• Support and maintain mission-critical systems related to crew movement and compliance (e.g., CBP requirements, parameter updates).
• Provide on‑call availability 24/7, including holidays and weekends, to respond to operational emergencies, system outages & disruptions and automation failures.

Qualifications – Education & Experience

• Bachelor’s degree preferred, ideally in Business, Analytics, Operations, or a related quantitative field.
• 2+ years of experience in air travel operations, business analytics, GDS systems, or a related analytical role.
• Experience with airline, travel operations, or large‑scale data environments preferred.

Technical Skills:

• Advanced proficiency with SABRE GDS, RED Apps, RED Workspace, SABRE BI, and AgentStream.
• Strong SQL skills with demonstrated experience managing large datasets and building reports/visualizations (Power BI preferred).
• Strong proficiency in Excel and other analytical tools.
• Familiarity with Oracle-based environments, JDE (E1), AFMS, ARC data, and travel automation platforms.

Competencies: 

• Ability to analyze and interpret complex operational and financial data.
• Strong problem-solving capability with comfort managing ambiguity and resolving urgent issues.
• Ability to communicate clearly with technical and non‑technical audiences.
• High attention to detail, particularly in financial accuracy and system integrity.
• Ability to operate in a fast-paced, global, 24/7 environment.
• Demonstrated ownership, accountability, and composure under pressure

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.

#LI-FE1