Marketing Data Analyst: Looker Studio + BigQuery Expert

OLIVER | The Brandtech Group; Guildford; On-site; GBP 42,000 - 60,000; Full time

Job summary

OLIVER, part of The Brandtech Group, is seeking a Marketing Data Analyst to join our onsite team in London. You will deliver insight across marketing, e-commerce, and CX, building dashboards in Looker Studio powered by BigQuery to surface campaign uplift and share performance.

Collaborate with CX, marketing, product and e-commerce teams, translate data into clear insights for stakeholders, and use platforms like GWI to build digital personas.

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 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.

Responsibilities

• 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.

Skills

Google BigQuery

SQL

Looker Studio

Data modelling

Dashboards

GWI

GA4

Adobe Analytics

Python (pandas)

Tools

Looker Studio

BigQuery

GWI

GA4

Adobe Analytics

Tableau

Power BI

Job description

OLIVER, part of The Brandtech Group, is seeking a Marketing Data Analyst to join our onsite team in London. You will deliver insight across marketing, e-commerce, and CX, building dashboards in Looker Studio powered by BigQuery to surface campaign uplift and share performance.

Collaborate with CX, marketing, product and e-commerce teams, translate data into clear insights for stakeholders, and use platforms like GWI to build digital personas.