Description

Business Intelligence Specialist with deep expertise in predictive modelling, advanced analytics and statistical techniques, with a strong track record of delivering high‑impact insight across Social Care, Education, Housing, Communities, Strategy, and Corporate Services. Highly skilled in regression modelling, Markov Chain methods, cluster analysis, hypothesis testing, and building predictive models from scratch using large and complex datasets.

Recognised for leading several major forecasting and modelling projects, including Education and Adult Social Care demand and cost forecasting, Poverty Predictive modelling, Temporary Accommodation demand modelling, and a wide range of Deep Dive analyses for Corporate Management Team. Experienced in Power BI development, KPI performance analysis and transforming raw data into clear, actionable insight for senior decision‑makers.

A collaborative and highly effective communicator with a strong commitment to developing others, providing mentoring, coaching and hands‑on support to analysts, including those on Data Analyst Apprenticeship pathways. Passionate about improving data literacy, knowledge sharing, and embedding an evidence‑based culture across the organisation. Frequently present insights to senior leaders, corporate teams and external partners, and recognised for outstanding contributions through internal awards.

Languages

English
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

LOCAL GOVERNMENT
BUSINESS INTELLIGENCE SPECIALIST
April 2023 - Today (3 years and 2 months)
Aylesbury, United Kingdom
• • Lead analyst for major predictive modelling projects across Adults, Children's Services, Housing and Communities, using statistical modelling, Markov Chain methods, regression techniques and scenario planning
• • Developed forecasting models for Adult Social Care demand and client costs to support the Medium Term Financial Plan
• • Co‑developed a high‑profile SEND Projections Model to inform SEND sufficiency strategy
• • Designed and delivered Power BI dashboards for Information Governance, enabling improved KPI tracking, performance understanding and evidence‑based decision‑making
• • Led analysis for multiple Consultations, collaborating with Comms and Finance to redesign methodology, increasing responses and delivering high‑quality analysis to tight deadlines
• • Developed Predictive Modelling Strategy and Action Plan
• • Provided support and guidance to several analysts during their Data Analyst Apprenticeship journeys
• • Received "Employee of the month" for implementation of Poverty Predictive model for targeting communications campaign
• • Produced multiple Deep Dive analyses for the Corporate Management Team on topics such as Domestic Abuse, voluntary turnover, employee sickness and ratings and complaints analysis
• • Supported data governance and responsible data use, including completing DPIAs for projects involving sensitive data
• • Recognised internally for high‑quality modelling work, collaboration, and contribution to organisation‑wide insight capability
Microsoft Power BI Business intelligence Business analysis
LOCAL GOVERNMENT
BI & INSIGHT ANALYST
January 2017 - April 2023 (6 years and 3 months)
• • Delivered, as part of a team, several key projects, the most significant being a projections model which included scenario testing for future planning. Built using Markov Chain and Monte-Carlo Simulation. Created Excel user-friendly interface using VBA.
• • Collating and linking data from several disparate data sources, and highlighting any data quality issues for improvement. Working with Service Areas to understand the data.
• • Investigating performance issues and identifying key factors to help drive improvement
• • Reviewing Observatory tools for making data more accessible, and putting forward recommendations for Assistant Chief Executive
• • Profiling client transport costs and building model to forecast for Medium Term Financial Plan.
• • Investigating Buckinghamshire's 'Infrastructure Footprint' to understand the flow of residents and non-residents out of and into the county for various services (schools, GPs etc.) following request from Chief Executive
WAITROSE
RESEARCH ANALYST
April 2007 - December 2016 (9 years and 8 months)
• • Delivered numerous projects around the business (Marketing, Finance, Customer Insight, Ecommerce, B2B, Personnel)
• • Developed interactive charts and branch sales performance reporting tools for my team and wider business
• • Statistical modelling for Store, Ecommerce, B2B to assist with sales forecasting
• • Database maintenance (e.g. GIS, competition, Census and socio-demographic data) – liaising with suppliers, arranging software updates and installation, data validation
• • Created branch Acorn and demographic profiles, market share maps, customer location maps, and catchment areas for the Waitrose estate using the Partnership Customer Database
• • Coordinated customer surveys and external research to obtain insight on customer behaviour
• • Awarded "One Step Beyond" recognition for the support provided to Waitrose Ecommerce
• • Delivered cluster analysis to help inform the decisions on the correct checkout mix for branches, and provided extensive support for branch segmentation project
• • Provided extensive support for the Ecommerce Branch Network Optimisation Model and support for DotCom Fulfilment Centre location planning analysis
• • Delivered analysis for and shared knowledge and expertise with Thames Hospice