Analyst, BI & Analytics - Raffles and Fairmont Hotels & Resorts

Raffles Hotels & Resorts
The Birthplace of stories and legends since 1887, Raffles is a legendary brand, steeped in history and loved by generations past, present and future.  Raffles, at distinguished landmark addresses around the world, is the vibrant heart of its destination, curating experiences that are culturally enriching, intellectually stimulating and always respectful of local communities, heritage and the environment. Its timeless elegance, refined manners and spirit of generosity ensure that every visitor arrives as a guest, leaves as a friend and returns as family.
 

Fairmont Hotels & Resorts

Join a dynamic team and be part of the Fairmont family – with 90+ spectacular properties, and 34 more in the pipeline, in 30 countries around the globe, stretching from the beaches of Hawaii, to the unspoiled national parks of Canada, to the heart of London, to the deserts of the United Arab Emirates. 

The Analyst, BI, RM & Analytics, Fairmont Raffles role supports a best-in-class Business Intelligence platform designed to provide key information to hotels, corporate commercial teams, senior leadership team and enable data-driven decision making. This role will help manage the entire data-to-dashboard pipeline including data sourcing, cleaning and validation; automation of data feeds; monitoring for quality and freshness; building new dashboards, reports and other analytics assets to support hotel needs; and provide training and support for the platform. The role is part of a larger Commercial team responsible for driving top-line revenue from over 120 properties leading hotels globally and as such will also be responsible for supporting Digital/Ecommerce, Sales, Loyalty and Revenue teams across corporate office as well as other revenue generating departments such as Spa, F&B etc. Serving as a key point of contact for the central Commercial Business Performance team, the role involves multiple weekly touchpoints with central commercial leadership and brand leaders. Additionally, the Analyst will oversee market share reporting and deliver quarterly macroeconomic updates for both hotel teams and corporate stakeholders.

Dashboard and report development

• Design, create and maintain dashboards providing critical metrics and business intelligence to allow other commercial teams to better run their respective portfolios
• Continuously optimize the user experience with reporting tools including Tableau to ensure needs are being met with minimal friction and frustration.
• Achieve operational efficiency by automating routine reporting requests
• Analyze, visualize, and deliver business intelligence to Revenue stakeholders to allow informed action 
• Provide reporting and analysis on Revenue performance & market performance to corporate, regional and property sales teams 
• Liaise with Central data teams to manage user on boarding, partake in Tableau training, maintain snowflake Data warehouse, and collaborate in other common areas of responsibility
• Manage multiple projects, whilst maintaining daily/weekly reporting to various stakeholders.
• Proactive implementation of AI from dashboard creation to reporting

Training & Support

• Create and maintain documentation on all owned dashboards and reports including documents and video
• Monitor customer support inbox for questions and promptly engage with users to assist
• Troubleshoot and triage any dashboard or data issues including follow-ups
• Maintain positive relationships with users including calls/chat support to walk through how-tos as needed
• Maintain strong connection with central business performance team, sharing insights and recommendations based on performance
• Run webinars as needed on new dashboards, refreshers, FAQs, etc
• Document user requirements for creating new reports and enhancing existing ones
• Support with new hotel onboarding and data feed connections.

Data Collection and Governance

• Source data from relevant sources including but not limited to Property Management Systems, Revenue Management Systems, outside benchmarking data vendors and other data sources
• Design and build data warehouse structures to allow reporting on collected data
• Monitor daily, weekly, or monthly data flows to ensure accuracy and completeness
• Put in place data governance structures to quickly alert of discrepancies and gaps
• Manage processes to correct data deficiencies as quickly as possible

Research and Analysis

• Conduct ad-hoc analysis to answer business questions, both asked and anticipated, covering the full cycle of requirements gathering, data discovery, methodology creation, execution, communication documentation, results presentation, and addressing follow-on questions
• Supply quarterly macro-economic outlook with the aim of guiding hotels and corporate for future topline planning
• Conduct topline budget/ forecast preparation and support presentation/ defense against various stakeholders.
• Other Duties and Projects as Requested

Required Skills/Qualifications

• Minimum of 3 years of experience with Tableau
• Minimum of 3 years of experience with databases like Snowflake and SQL query languages
• Familiarity with programming scripts and automation such as Shell scripting, VBA, Power Automate, etc
• Strong knowledge of hotel topline business
• High level understanding of hospitality market
• Professional written and verbal communications skills
• Four year degree from an accredited university in Hospitality, Marketing, Computer Science, Engineering, Quantitative Analysis or a related field

Language skills

• Speaking and writing English
• French knowledge an asset

Our Commitment to Diversity & Inclusion: we are an inclusive company and our ambition is to attract, recruit and promote diverse talent.