About the Role
The Data Analyst will be responsible for delivering insights that drive improvements across the full commercial ecosystem, including customer experience, retailer investment effectiveness, marketing and sales performance, and the post-purchase, onboarding, and promotional landscape. A key part of the role involves designing, building, and managing a marketing and sales performance dashboard using Google BigQuery and Looker Studio to aid decision-making for various teams.
Responsibilities
- Design, build, and maintain a marketing and sales performance dashboard in Looker Studio, underpinned by BigQuery.
- Combine 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 for consistent KPI delivery.
- Identify and quantify the impact of retailer investment, including sales uplift and market share during campaign periods.
- Analyze correlations between campaign activity and commercial performance to determine effective marketing levers.
- Measure and report on halo effects across products and retailers from promotional and campaign activity.
- Define and calculate key performance metrics including uplift, baseline, market share, activity intensity, and halo effects.
- Utilize GFK or other syndicated market data sources to enrich performance analysis with market context.
- Conduct analysis of the customer experience, including user behavior, content and campaign performance, and conversion pathways.
- Benchmark key customer journeys against competitor websites to identify opportunities.
- Provide regular insight into paid promotions, post-purchase experience, and customer satisfaction trends.
- Support planning, optimization, and operational management of post-purchase and onboarding experiences.
- Analyze content utilization, 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, performance testing, and monitoring adoption.
- 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 to 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 for marketing planning.
Requirements
- 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 modeling 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.
- 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.
Skills
- Google BigQuery
- SQL
- Looker Studio
- Data Modeling
- Reporting
- Marketing Analytics
- Campaign Effectiveness Measurement
- Digital Customer Journeys
- Content Performance Metrics
- E-commerce KPIs
- Google Analytics GA4
- Adobe Analytics
- Python
- pandas
- Google Cloud Platform (GCP)
- Tableau
- Power BI
- GWI
Location
- Weybridge, Surrey, United Kingdom
- London
Work Type
- Onsite
Experience Level
- Proven experience
- Broader experience
About the Company
- 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 a part of The Brandtech Group, we're 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.
- Established in 2004, Inside Ideas Group is a rapidly growing global agency network that helps clients drive their businesses forward from the inside.
- We partner with over 300 clients in more than 40 countries, delivering ideas, technology and creativity that make a measurable impact.
- As part of The Brandtech Group, we are pioneers in using advanced AI technologies to transform the way we create, optimise and deliver work.
- Our AI capabilities enhance efficiency, support smart decision making and unlock new levels of creativity for our teams and clients.
- 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.
- 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.
- Our values shape everything we do: 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.
- OLIVER, 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.
- OLIVER has set ambitious environmental goals around sustainability, with science-based emissions reduction targets.
Equal Opportunity
- 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.
