Head of Analytics at Distil.ai (BiG Business Intelligence Ltd) (2015 – Present)
Distil.ai is a customer data and analytics platform for hospitality and retail brands. I lead analytics across the business, from the data warehouse to the reports clients use every day.
- Restaurant analytics and client delivery (2023 – present)
- Helped design, and now maintain and extend, the standard multi-tenant analytics schema that unifies reservations, reviews and restaurant data from OpenTable, SevenRooms, Google, Tripadvisor and Yelp for each restaurant group.
- Helped build, and now run and improve, The ONE Group's data warehouse in PostgreSQL and Snowflake: scheduled stored procedures, views and materialised views, plus Slack alerts when any destination table goes stale.
- Delivered dashboards and reports for Hawksmoor, Gordon Ramsay Restaurants, The ONE Group, Wolseley Hospitality Group, Côte, Blacklock, Caprice Holdings and others, including marketing sales attribution, change logs and shifts, capacity and reviews reporting.
- Rebuilt customer attributes and segments for Hawksmoor, Wolseley and Gordon Ramsay during the move to Distil's new Single Guest Profile platform, and added new data sources such as Purple WiFi and Wireless Social.
- Created a repeatable AI-assisted method for validating analytics reports (a Claude Code command plus a standard testing workbook). I used it to test Marketing Sales, Capacity, Turn Times and Group Covers reports across six restaurant groups, finding and fixing defects before release.
- Set up secure data warehouse access for partner agencies (Fanatic, Tandem and others) and wrote the guides they use to query it.
- Retired legacy analytics databases and repointed client portals to the new warehouse, supporting the company's cloud cost reduction.
- Service operations and analytics products (2019 – 2023)
- Led Service Operations as part of the leadership team: client onboarding and support, product documentation, internal product analytics and professional services.
- Ran Distil's hosted Tableau BI portal for customers, then designed Distil's packaged analytics modules in the Superset-based Analytics Portal: Marketing Analytics (ROAS), UTM Tags, Data Verification and Customer Analytics dashboards, with user roles and best-practice standards for every deployment.
- Ran managed data warehouse and BI services for retail, finance, engineering and travel clients, including TWI in Cambridge (SQL Server data warehouse with SSIS ETL, Tableau Server and exam reporting, 2018 – 2022), CMO Group (SQL Server and SSIS ETL, Power BI and an Azure migration), Crowdcube, Crowdfunder, Rothwell & Towler and the Eden Project.
- Committed more than 1,100 changes to Distil's analytics and custom-views code base between 2021 and 2026.
- BI and analytics consulting, BiG Consultancy (2015 – 2019)
- Consulted on BI development and data analytics for clients in the defence, fintech, energy, telecoms and transport sectors, specialising in Tableau dashboard development.
- Network Rail Digital Railway, with Deloitte (2017 – 2018): helped build the logical data model for the Digital Railway Data Exchange Platform as a graph database (OrientDB), loaded from a versioned data specification, with automated test batches in Azure SQL and Tableau test reporting. The first cycle cut the model from 547 entities and 1,265 attributes to 245 entities and 1,094 attributes, and resolved more than 80% of 1,400 data issues. Later built KNIME workflows to load signalling asset data for an asset criticality analysis.
- Ministry of Defence (2016 – 2017): built airworthiness, hazard and configuration dashboards for the NAMMS aviation engineering system using SQL Server stored procedures, functions and SharePoint web parts. For the Military Aviation Authority, analysed air safety occurrence report (DASOR) data from ASIMS, including keyword analysis of causal factors, using SQL and Excel.
- Maintained client dimensional data warehouses on Amazon Redshift and Azure, with reporting in Tableau, SSRS, Qlik and Power BI.
- Ran an Azure data warehouse and Power BI proof of concept for a telecoms provider, comparing Power BI with Tableau, and built Power BI sales dashboards for other clients.
Business Process Analyst at BT Global Services (2015-04 – 2015-05)
Management information and processes during a move to a new managed-service provider.
Business Process Analyst; earlier Business Support Analyst at Capita Secure Information Solutions (formerly SunGard Public Sector) (2005 – 2015)
Management and financial reporting for IT managed-service clients; presented performance to senior client stakeholders; ran the department in my manager's absence.
Reports Analyst at ClientLogic (2004 – 2004)
Service quality, service level and margin reporting.
Analyst at Balfour Beatty Utility Solutions (2000 – 2004)
Sales and unit cost analysis and KPI reporting.
