Sr Analyst, Market Planning and Analysis

Position Summary

The Sr. Analyst, Market Planning & Analysis will be responsible for leveraging data to help drive the global growth and success of Royal Caribbean International by providing performance measurements and strategic analysis to influence priorities for the E-commerce and Marketing teams. They will be responsible for interacting with various departments within Royal Caribbean Group to consolidate data from multiple data sets; analyze and understand results; and create reports, presentations and/or dashboards for the E-commerce and Marketing leadership while providing actionable insights. Types of analysis could include business performance, promotional effectiveness, guest profile, market planning, or business process related

Essential Duties and Responsibilities:

• Influence business decisions through analytics and identify actionable insights that inform our strategy.
• Effectively communicate results to a cross functional group as well as department executives.
• Tracking Key Performance Indicators, as well as revenue performance to support strategic business plans.
• Forecast Key Performance Indicators based on historical data and identify variances versus forecast.
• Aggregate large and diverse data sets using Power BI, Excel, and other analytical tools.
• Create dashboards with advanced data visualization tools, such as Power BI, to provide an easy-to-understand interface for end users to identify key themes within data.
• Develop and report campaign and promotion effectiveness to the commercial trading group.
• Lead ad-hoc projects that provide insight into competitor marketing efforts.
• Responsible for daily/weekly/monthly reporting on business trends and the status of E-commerce strategies to senior management.
• Qualified in developing and delivering high quality, clear and concise presentations to Marketing Leadership.
• 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, Knowledge and Skills:

• Bachelor’s degree in economics, Business, Finance, Analytics, Computer Science, Mathematics, and similar.
• MBA or relevant master’s degree preferred.
• 3+ years of work experience required, with experience performing either strategic digital analysis, financial analysis, or business intelligence/marketing analytics highly preferred.
• Knowledge writing SQL queries and experience using Tableau or Power BI.
• Experience in travel/leisure hospitality is preferred.
  
  
  Foundational Knowledge: Understanding of eCommerce, operations, marketing and finance principles to lead management on short and long-term strategies.
• Complex Problem Solving: Ability to identifying the root cause of complex problems, develop options and recommend solutions.
• Analytical: Data combined with critical thinking to identify strengths, weaknesses, and opportunities
• Presentation & Storytelling: Able to present complex data analyses into simple, concise, and engaging stories that bring insights to the forefront using Power Point
• Research: Ability to find and interpret syndicated research studies and credible sources to answer competitor, market, and additional applicable required research.
• Results-driven: Ability to complete tasks efficiently and thoroughly by meticulously ensuring data and insights presented are accurate.
• Technical Skills: Intermediate SQL, Advanced Excel, Power BI and PowerPoint required

Power Skills:

• Action Oriented
• Collaborates Effectively
• Communicates Effectively
• Drives Results
• Situational Adaptability