Data Analyst - On Premise Insights

We are seeking a Data Analyst to join our On Premise Insights team. You will play a crucial role in driving strategic business decisions and tracking performance across multiple departments.

Responsibilities

• Build and own the total GB outlet universe: define what counts as an outlet in each channel, then size and segment it by combining licensed premises data, food business registers, points of interest data, wholesaler and distributor records, and our own field sales data.
• Work with Data Science at HQ to design methodologies for estimating the universe and our distribution in channels where no single provider covers the market.
• Establish and run a monthly tracking cycle for horizontal distribution: numeric distribution by channel and account type.
• Validate modelled estimates against ground truth from field audits, wholesaler and distributor sell-out data and customer data.
• Turn the market read into action: prioritised outlet target lists, white space maps and channel opportunity sizing.
• Translate business questions into data requirements and ensure data assets meet these needs.
• Act as a liaison between business users and technical teams.
• Work with the Performance Insights team and with On Premise sales, field and channel teams to define key performance indicators (KPIs).
• Analyse large volumes of structured and unstructured data from various sources.
• Use SQL, Power BI and Excel to independently interrogate, combine and analyse complex commercial datasets.
• Design and document appropriate quantitative methods for incomplete data.
• Develop and maintain robust approaches to entity matching and de-duplication.
• Leverage tools such as Snowflake, Power BI, or other BI platforms to develop and maintain On Premise reporting and data visualisation needs.
• Automate recurring reporting and manual data preparation.

Requirements

• Curiosity: Continuously eager to learn, improve systems, processes, and tools.
• Quantitative Methods: comfortable with sampling, estimation and extrapolation.
• SQL: Strong SQL skills, with the ability to independently interrogate and analyse complex datasets.
• BI & Excel: Strong Power BI and Excel skills, covering reporting, modelling and ad-hoc commercial analysis.
• Programming: Experience of applying Python or R to analysis or automation challenges is a strong plus.
• Working with Incomplete Data: experience building a usable view of a market from fragmented or imperfect sources.
• Data Literacy: Ability to prepare high-quality datasets that preserve the core meaning of the data.
• Communication: a great communicator at all levels, capable of managing stakeholders’ expectations.
• FMCG Knowledge: prior experience working at an FMCG company in a data or analytics focused role is a plus.

Performance Goals

• Deliver a documented On Premise universe methodology covering all priority channels in the first six months.
• Validate against an independent field audit sample each quarter.
• Baseline the recurring reporting and data preparation effort across the On Premise team.
• Remove an agreed number of hours per month.
• Prepare the core On Premise datasets for AI use.