Analyst, BI & Analytics

Company DescriptionFairmont Hotels & ResortsJoin 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.Raffles Hotels & ResortsThe 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.Job DescriptionThe role supports a best-in-class BI platform designed to provide key information to hotel and corporate commercial teams and enable data-driven decision making. Responsibilities cover the full product cycle including data sourcing, cleaning, validation, building dashboards and reports, conducting training, troubleshooting and other user support.Dashboard and report developmentBuild dashboards providing critical metrics and business intelligenceContinuously optimize user experience with reporting tools e.g. TableauAchieve operational efficiency by automating routine reporting requestsProvide reporting and analysis on top-line performanceLiaise with Central data teams to manage user on-boarding and maintain Tableau & Snowflake environmentsTraining & SupportCreate and maintain documentation on all dashboards and reportsMonitor customer support inbox and promptly engage with usersRun webinars as needed on new dashboards, refreshers, FAQs, etcDocument user requirements for creating or enhancing reportsData Collection and GovernanceSource data from relevant sources including PMSs, RMS, outside benchmarking data vendors and othersDesign & build data warehouse structuresMonitor regular data flows to ensure accuracy and completeness. Build data governance structures to quickly alert of discrepanciesManage processes to correct data deficiencies as quickly as possibleResearch and AnalysisConduct ad-hoc analysis to answer business questions – understanding requirements, designing methodology, presenting conclusionsOther Duties and Projects as RequestedQualificationsFour year degree from an accredited University in Hospitality, Computer Science, Engineering, Quantitative Analysis or a related field3-5 years working experience in hospitality or data analysisMin 3 years experience in TableauMin 3 years experience with databases like SnowflakeFamiliarity with automation scripts eg. VBA, Power Automate, BashProfessional Written and Verbal communication skills in English