Data Analyst

OLIVER | The Brandtech Group; Guildford; On-site; GBP 55,000 - 75,000; Full time

Job summary

OLIVER, part of The Brandtech Group, is hiring a Data Analyst to join an onsite London team supporting the Weybridge area. The role focuses on delivering insights across customer experience, marketing, e‑commerce and promotions using Looker Studio dashboards powered by Google BigQuery.

You will translate complex commercial questions into actionable dashboards, collaborate with CX, marketing and product teams, and drive data‑driven decisions across multi‑market environments with a modern

Qualifications

• Proven experience as a data or insight analyst within digital, e‑commerce, retail, marketing or agency environments.
• Strong proficiency in Google BigQuery and advanced SQL, including data modelling and reporting layer design.
• Hands‑on experience building dashboards in Looker Studio, with a clear understanding of how to structure underlying data models.

Responsibilities

• Design, build and maintain a marketing and sales performance dashboard in Looker Studio, underpinned by BigQuery.
• Define the underlying data model, transform source files and design the reporting layer to support KPI delivery.
• Identify and quantify retailer investment impact and campaign effects on market share and uplift.
• Analyse correlations between campaign activity and commercial performance to guide decisions.
• Build dashboards across customer experience, onboarding, e‑commerce, retail performance and promotions.

Skills

SQL

Google BigQuery

Looker Studio

Data modelling

Dashboards

Stakeholder management

Communication

AI in analytics

GA4

Adobe Analytics

Python

GCP

Tableau

Power BI

Tools

Google BigQuery

Looker Studio

SQL

Python

Tableau

Power BI

Job description

Company Overview

Established in 2004, OLIVER is the world’s first and only specialist in designing, building, and running bespoke in‑house agencies and marketing ecosystems for brands. We partner with over 300 clients in 40+ countries and counting. Our unique model drives creativity and efficiency, allowing us to deliver tailored solutions that resonate deeply with audiences.

As part of The Brandtech Group, we are at the forefront of leveraging cutting‑edge AI technology to revolutionise how we create and deliver work. Our AI solutions enhance efficiency, spark creativity, and drive insightful decision‑making, empowering our teams to produce innovative and impactful results.

Role

Data Analyst

Location: Weybridge, Surrey, United Kingdom

We are now looking for a skilled Data Analyst to join our onsite team supporting in London.

About the Role

As the Data Analyst, you will be responsible for delivering insight that drives improvements across the full commercial ecosystem spanning customer experience, retail investment effectiveness, marketing and sales performance, and the broader post‑purchase, onboarding and promotional landscape.

A core part of your remit will be the design, build and ongoing management of a marketing and sales performance dashboard, underpinned by Google BigQuery and delivered in Looker Studio. This will serve as a critical decision‑making tool for marketing, e‑commerce, retail and CX teams surfacing insight such as campaign uplift, halo effects, retailer investment impact and share performance across products and markets.

Alongside this, you will analyse customer journeys, benchmark competitors, oversee content performance and support the planning and execution of onboarding and e‑commerce promotions using platforms like GWI to create digital personas and audience profiles.

You will collaborate closely with CX, marketing, product and e‑commerce teams as well as HQ and local market stakeholders to ensure insight informs decisions at every stage.

This role requires strong analytical capability, expertise in data modelling and SQL, and the ability to translate complex commercial questions into dashboard logic and actionable recommendations.

What You Will Be Doing

• Design, build and maintain a marketing and sales performance dashboard in Looker Studio, underpinned by BigQuery, combining sell‑out sales data, market volume and share data, and campaign activity logs.
• Define the underlying data model, transform source files and design the reporting layer to support consistent, scalable KPI delivery.
• Identify and quantify the impact of retailer investment, including uplift in sales and market share during campaign periods.
• Analyse correlations between campaign activity and commercial performance to determine which marketing levers are most effective.
• Measure and report on halo effects across products and retailers resulting from promotional and campaign activity.
• Define and calculate key performance metrics including uplift, baseline, market share, activity intensity and halo effects.
• Work with GFK or other syndicated market data sources to enrich performance analysis with market volume and share context.

Customer Experience & Digital Analytics

• Conduct analysis of the current customer experience, including user behaviour, content and campaign performance and conversion pathways.
• Benchmark key customer journeys against competitor websites to identify gaps and opportunities.
• Provide regular insight into paid promotions, post‑purchase experience and customer satisfaction trends.
• Support planning, optimisation and operational management of post‑purchase and onboarding experience.
• Analyse content utilisation, engagement and drop‑off points, and recommend enhancements.
• Collaborate with HQ and local teams on onboarding content production and implementation.
• Support feature management including evaluation, testing performance and monitoring adoption, with ongoing analysis of content effectiveness and customer experience updates.
• Build and maintain dashboards, reports and ad‑hoc analyses across customer experience, onboarding, e‑commerce, retail performance and promotion activity.
• Translate data into clear insights that guide decision‑making within marketing, CX, digital and commercial teams.
• Present findings clearly to stakeholders at all levels, ensuring insight is embedded in planning and operational processes.
• Use platforms like GWI to build digital personas and audience profiles that support broader marketing planning.

What You Need to Be Great in This Role

• Proven experience as a data or insight analyst within digital, e‑commerce, retail, marketing or agency environments.
• Strong proficiency in Google BigQuery and advanced SQL, including data modelling and reporting layer design.
• Hands‑on experience building dashboards in Looker Studio, with a clear understanding of how to structure underlying data models for robust, scalable dashboard performance.
• Demonstrable experience combining sell‑out sales, market share and campaign activity datasets to generate commercial insight.
• Ability to define and calculate metrics including uplift, baseline, market share, activity intensity and halo effects.
• Strong marketing analytics capability, including campaign effectiveness measurement across paid and promotional channels.
• Good understanding of digital customer journeys, content performance metrics and e‑commerce KPIs.
• Experience with analytics platforms such as Google Analytics GA4, Adobe Analytics or similar.
• Excellent communication and storytelling ability — capable of translating complex business questions into dashboard logic and presenting findings clearly to non‑technical audiences.
• Experience working with multi‑market teams and managing stakeholder expectations across business functions.
• A passion for data‑driven decision‑making and an interest in how AI can enhance analytics workflows.

Preferred

• Proficiency in Python (pandas) for data transformation, automation and workflow scripting.
• Broader experience with Google Cloud Platform (GCP), including automating data ingestion and transformation workflows.
• Experience working in retail, e‑commerce or retailer media environments.
• Familiarity with GfK or other syndicated market data sources.
• Experience with additional BI tools such as Tableau or Power BI.

Our Values

Be Ambitious to succeed
Be Imaginative to push the boundaries of what’s possible
Be Inspirational to do groundbreaking work
Be always learning and listening to understand
Be Results‑focused to exceed expectations
Be actively pro‑inclusive and anti‑racist across our community, clients and creations

Equal Opportunity Statement

Inside Ideas Group, a part of the Brandtech Group, is an equal opportunity employer committed to creating an inclusive working environment where all employees are encouraged to reach their full potential, and individual differences are valued and respected. All applicants shall be considered for employment without regard to race, ethnicity, religion, gender, sexual orientation, gender identity, age, neurodivergence, disability status, or any other characteristic protected by local laws.

Sustainability Commitment

Inside Ideas Group has set ambitious environmental goals around sustainability, with science‑based emissions reduction targets. Collectively, we work towards our mission, embedding sustainability into every department and through every stage of the project lifecycle.