Data Analyst

OLIVER Agency · London, United Kingdom

// classified as

Other (Adjacent or hard to classify.)

> stack

sqlbigquerylookersparktableau

> description

<div class="content-intro">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. </div>Data Analyst Location: London, United Kingdom    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.  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 on, retailer 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  Marketing & Sales Performance Analytics   <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">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. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1">Define the underlying data model, transform source files and design the reporting layer to support consistent, scalable KPI delivery. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1">Identify and quantify the impact of retailer investment, including uplift in sales and market share during campaign periods. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1">Analyse correlations between campaign activity and commercial performance to determine which marketing levers are most effective. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1">Measure and report on halo effects across products and retailers resulting from promotional and campaign activity. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1">Define and calculate key performance metrics including uplift, baseline, market share, activity intensity and halo effects. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="18" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1">Work with GFK or other syndicated market data sources to enrich performance analysis with market volume and share context. </li> </ul> Customer Experience & Digital Analytics  <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Conduct analysis of the current customer experience, including user behaviour, content and campaign performance and conversion pathways. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1">Benchmark key customer journeys against competitor websites to identify gaps and opportunities. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1">Provide regular insight into paid promotions, post-purchase experience and customer satisfaction trends. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1">Support planning, optimisation and operational management of post-purchase and onboarding experience. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1">Analyse content utilisation, engagement and drop-off points, and recommend enhancements. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1">Collaborate with HQ and local teams on onboarding content production and implementation. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1">Support feature management including evaluation, testing performance and monitoring adoption, with ongoing analysis of content effectiveness and customer experience updates. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="8" data-aria-level="1">Reporting, Dashboards & Stakeholder Insight </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="9" data-aria-level="1">Build and maintain dashboards, reports and ad hoc analyses across customer experience, onboarding, e-commerce, retail performance and promotion activity. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="10" data-aria-level="1">Translate data into clear insights that guide decision-making within marketing, CX, digital and commercial teams. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="11" data-aria-level="1">Present findings clearly to stakeholders at all levels, ensuring insight is embedded in planning and operational processes. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="12" data-aria-level="1">Use platforms like GWI to build digital personas and audience profiles that support broader marketing planning. </li> </ul> What You Need to Be Great in This Role  Essential  <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Proven experience as a data or insight analyst within digital, e-commerce, retail, marketing or agency environments. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1">Strong proficiency in Google BigQuery and advanced SQL, including data modelling and reporting layer design. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1">Hands-on experience building dashboards in Looker Studio, with a clear understanding of how to structure underlying data models for robust, scalable dashboard performance. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1">Demonstrable experience combining sell-out sales, market share and campaign activity datasets to generate commercial insight. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1">Ability to define and calculate metrics including uplift, baseline, market share, activity intensity and halo effects. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1">Strong marketing analytics capability, including campaign effectiveness measurement across paid and promotional channels. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1">Good understanding of digital customer journeys, content performance metrics and e-commerce KPIs. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="8" data-aria-level="1">Experience with analytics platforms such as Google Analytics GA4, Adobe Analytics or similar. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="9" data-aria-level="1">Excellent communication and storytelling ability — capable of translating complex business questions into dashboard logic and presenting findings clearly to non-technical audiences. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="10" data-aria-level="1">Experience working with multi-market teams and managing stakeholder expectations across business functions. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="15" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="11" data-aria-level="1">A passion for data-driven decision-making and an interest in how AI can enhance analytics workflows. </li> </ul> Preferred:  <ul> <li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Proficiency in Python (pandas) for data transformation, automation and workflow scripting. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1">Broader experience with Google Cloud Platform (GCP), including automating data ingestion and transformation workflows. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1">Experience working in retail, e-commerce or retailer media environments. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1">Familiarity with GfK or other syndicated market data sources. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1">Experience with additional BI tools such as Tableau or Power BI. </li> </ul> 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  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.  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. <div class="content-conclusion">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. 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.     OLIVER 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.</div>