Key Responsibilities
Data Management, Ingestion and Architecture
- Own the ingestion of data from hotel and central systems (PMS, RMS, POS, payroll, procurement and the finance ledgers) into a structured, reliable central reporting layer, replacing manual collection with automated data flows.
- Design and maintain the data architecture underpinning group reporting, including the multi-hotel profit and loss database covering prior-year actuals, budget, current-year actuals and forecast at general ledger level, with standardised mapping and chart-of-accounts alignment across entities and properties.
- Establish and run data-quality controls covering completeness, reconciliation to source, exception reporting and validation, and maintain clear documentation of data sources, definitions, transformations and lineage.
Reporting, Insight and Commercial Analysis
- Produce and develop the group’s recurring management reporting, KPI dashboards and variance analysis for hotel, central, executive and board audiences, with clear commentary identifying trends, variances, risks and opportunities.
- Build and maintain self-service dashboards, rationalise duplicated reporting, and establish a single version of the truth for each key measure.
- Analyse trading performance across the portfolio, including occupancy, ADR, RevPAR, segmentation, channel mix, length of stay and booking curve, and support rate, demand, competitor and market analysis for revenue meetings.
- Analyse distribution and channel economics including OTA cost of sale, and bring together commercial, operational, payroll and guest-experience data to analyse profitability and productivity at property, department and segment level.
AI, Automation and Data Governance
- Apply AI tooling, principally Claude, to accelerate and improve recurring analysis, reporting and data preparation, and build repeatable AI workflows such as structured projects, prompt libraries and documented instructions that produce consistent, auditable results.
- Configure and maintain the integrations that give AI tooling controlled access to our data, including the Microsoft 365 and SharePoint environment and the finance ledgers.
- Evaluate new tooling and techniques, run proportionate pilots, and act as the practical enabler for AI adoption, training colleagues and building internal capability rather than concentrating it in one person.
- Co-own the group’s data and AI governance framework with the Finance Director, covering ownership, definitions, access, retention and change control, ensuring personal data is handled in line with UK GDPR, access is segregated appropriately between properties, entities and owners, and card and payment data is excluded from analytical environments in line with PCI DSS.
What We Are Looking For
- Three to four years’ practical experience in a data management, analytics or business intelligence role, with demonstrable ownership of end-to-end delivery.
- Proven experience building and maintaining data ingestion and reporting processes across multiple source systems, including reconciliation and data-quality control.
- Advanced Excel, including formula-driven modelling with centralised assumptions; working knowledge of SQL; and experience with a modern visualisation platform, ideally Power BI.
- Genuine, practical experience applying AI tooling to real analytical or reporting work, with a clear view of where it adds value and where it does not.
- Strong commercial and financial literacy, with confidence in a profit and loss account, margin, variance and driver-based analysis.
- Ability to translate an ambiguous business question into a defined analytical task, and to communicate the answer clearly to a non-technical audience.
- High attention to detail, sound judgement and discretion with confidential and personal data; self-directed and comfortable operating as the sole dedicated data specialist.
apply now: https://talentformula.keka.com/careers/jobdetails/143904?source=indeed%20job%20posts
