Data Analyst

Data Analyst Use SQL and data storytelling to uncover the impact of omnichannel campaigns for some of the UK's biggest retail brands. Location: Hybrid, Nottingham, 2 days per week in the office Salary: From £40,000 + 10% discretionary bonus Level: Senior Executive Level Who are we? 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. About the role 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. What we’re looking for 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. Don’t meet every single requirement? We still want to hear from you. If you believe you’d thrive in this role, your unique perspective might be just what we’re looking for. Why SMG? 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. ● 10% discretionary bonus ● £1,800 yearly wellbeing fund (on top of your salary!) ● Free Headspace subscription ● £500 yearly “Uni Fund” for learning ● 4 extra Wellbeing Days off per year ● Summer & Winter conferences + year-round celebrations ● 4pm finishes every Friday ● Flexible and hybrid working Explore all our benefits here Useful Links Before You Apply Learn about our agencies Our values Our hiring process EDI at SMG FAQs Our full data retention policy can be found here . Department Insight Locations Nottingham Remote status Hybrid Nottingham Life at SMG Our workplace culture is super important to us and we have a team dedicated to making SMG a great place to work. Whether it's Wellbeing Wednesday, a virtual quiz, or giving back to our charity partner The Trussell Trust, there is always something going on here at SMG. Take a look at some of the things we've been up to on our Life at SMG page.