FP&A Analyst - Raffles & Fairmont Global
Core
FP&A Analyst supporting the FP&A Manager in developing financial analysis, forecasting, and reporting for Raffles & Fairmont global hotels to enhance revenue and cost efficiency.
Role type
FP&A Analyst
Builds
Monthly, quarterly, and annual performance review reporting packages; annual corporate budget; rolling forecasts; P&L reports and KPI dashboards.
Domain
Hospitality (Hotels) + Financial Planning & Analysis
Deliverable
dashboards & analysis
Required skills
Financial data analysis, Budgeting and forecasting, Variance analysis (Actual vs. Budget/Forecast), Financial reporting, Data consolidation, OneStream, Tableau, Advanced Excel (VBA preferred), Data quality checks, Business performance presentation
Preferred skills
BI and data visualization tools knowledge, Network statistics analysis, EBITDA analysis, Accounts receivable analysis
Technologies
OneStream, Tableau, Excel
Responsibilities
Support preparation and upload of corporate Last Estimates forecasts into OneStream; Assist in preparation of annual corporate budget; Collect, consolidate, validate, and analyze financial data from stakeholders; Produce monthly, quarterly, and annual performance review reporting packages; Perform Actual vs. Budget and Actual vs. Forecast analyses; Consolidate financial and operational data and conduct data quality checks; Prepare and distribute monthly P&L reports and related analyses; Participate in development and enhancement of reporting tools and dashboards; Produce management reports including topline reporting, P&L analyses, waterfall analyses, and KPI dashboards.
Seniority
Individual Contributor, Analyst level