Marketing Analytics Data Analyst – Looker Studio & BigQuery

oliver; Greater London; On-site; GBP 42,000 - 60,000; Full time

Job summary

OLIVER, part of the Brandtech Group, is seeking a Data Analyst in the UK to deliver insight across customer experience, onboarding, and e-commerce promotions. You’ll design and manage dashboards using Looker Studio and BigQuery, translating complex data into actionable business recommendations.

You will collaborate closely with CX, marketing, product and e-commerce teams, supporting planning and optimization across multiple markets.

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 data 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 — 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 marketing and sales performance dashboards in Looker Studio, underpinned by BigQuery, combining sell-out data, market share and activity logs.
• Define data models, transform source files and design reporting layers for scalable KPI delivery.
• Quantify retailer investment impact and halo effects on sales and market share.
• Analyze campaign activity vs. performance to identify effective marketing levers.
• Measure halo effects across products/retailers from promotions and campaigns.
• Define metrics like uplift, baseline, market share and activity intensity.
• Collaborate with data sources like GFK to enrich performance analysis.

Skills

Google BigQuery

SQL

Looker Studio

Data dashboards

Marketing analytics

Stakeholder communication

Multi-market collaboration

AI in analytics

Tools

GWI

Google Analytics GA4

Adobe Analytics

Tableau

Power BI

Job description

OLIVER, part of the Brandtech Group, is seeking a Data Analyst in the UK to deliver insight across customer experience, onboarding, and e-commerce promotions. You’ll design and manage dashboards using Looker Studio and BigQuery, translating complex data into actionable business recommendations.

You will collaborate closely with CX, marketing, product and e-commerce teams, supporting planning and optimization across multiple markets.