Data Analyst

Use SQL and data storytelling to uncover the impact of omnichannel campaigns for some of the UK's biggest retail brands., We are looking for a Data Analyst to join our Boots Media Group partnership based in Nottingham. This role sits within the Insights team and is focused on ensuring data is accurate, accessible, and ready for analysis to support campaign evaluation and client delivery.

You will play a key role in querying and analysing data for a top supplier Omnichannel campaigns (a multichannel Test vs Control using Boots Advantage Card data). You'll also work in tandem with our Operations team to source data for agencies, supporting them by delivering accurate and quick results.

Working closely with both Insights, Agency and Boots teams, you will have a comprehensive view of our campaign effectiveness workstream, whilst being able to analyse the data deeply and present back to clients.

• Write and optimise SQL queries to extract, manipulate and analyse large datasets.
• Transform raw data into clean, structured datasets ready for campaign evaluation.
• Combine data from multiple sources to produce accurate and reliable insights.
• Act as the main point of contact for agency data requests, managing priorities and delivery timelines.
• Coordinate evaluation requests, ensuring all required information is captured and identifying any missing data or dependencies.
• Analyse omnichannel campaign performance to uncover meaningful insights and answer key business questions.
• Work closely with Data Scientists and internal stakeholders to investigate anomalies and validate results.
• Translate complex data into clear, actionable recommendations that drive better business decisions.
• Produce client-ready reports and presentations using Excel and PowerPoint.
• Present campaign findings confidently to clients, explaining insights clearly and responding to questions with confidence.
• Collaborate with Insights, Agency and Boots teams to deliver accurate, timely and commercially valuable campaign measurement.

• Strong working knowledge, able to query, join, and manipulate datasets independently
• Comfortable working with large datasets and structuring outputs for analysis
• Light experience with Python is a plus
• Ability to identify data inconsistencies and gaps
• Able to translate business questions into data outputs clearly

We're looking for people who enjoy the buzz of change, the satisfaction of building something better, and the joy of working with a close-knit, values-driven team. If you love variety, thrive in a fast-paced environment, and embrace change with energy, this could be your right role.

We're the original pioneers in connected commerce marketing. Since 2008, we've been partnering with major retailers, powering global brands, and building meaningful connections with shoppers. We simplify the mind-boggling complexity of today's retail media landscape. We deliver impactful campaigns that connect with people where it matters. We create seamless and personalised shopping experiences. Above all, we deliver amazing results for our partners, driven by our unshakeable desire for growth. Time after time, we change the game. SMG is home to a world-class suite of commerce advertising capabilities powered by data and cutting-edge technology. We constantly push ourselves, our tech and our industry to discover innovative new ways to connect, sell and grow., At SMG, we hire for the future, which is fast-moving and changing shape. Do you have the potential to help shape our business? We're looking for brilliant, diverse talent who want to grow with us - people who are curious, ambitious, and eager to learn, whether as specialists or across teams. We value those who take ownership of their growth and bring fresh perspectives. That's why we're committed to equity, inclusion, and building a place where everyone feels empowered to grow. At SMG, it's not just about filling a role but building the future together.