Data Analyst

SMG

Nottingham

Hybrid

GBP 34,000 - 46,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

10% discretionary bonus

Wellbeing fund

Headspace subscription

Uni Fund

Wellbeing days

Conferences

Early finish Fridays

Flexible/hybrid working

Job summary

SMG is seeking a Data Analyst to support Boots Media Group partnership in Nottingham. You will be part of the Insights team, ensuring data accuracy and accessibility for campaign evaluation and client delivery.

You will query and analyse data for omnichannel campaigns and work with Operations to source data for agencies, delivering accurate results and timely insights.

Qualifications

Strong ability to query, join and manipulate large datasets.
Experience turning raw data into clean, structured outputs for analysis.
Ability to translate business questions into data outputs and insights.

Responsibilities

Write and optimise SQL queries to extract and analyse large datasets.
Transform raw data into clean, structured datasets for campaign evaluation.
Combine data from multiple sources to produce reliable insights.
Act as main point of contact for agency data requests and manage timelines.
Coordinate evaluation requests and identify missing data or dependencies.
Analyse omnichannel campaign performance to uncover key insights.
Collaborate with Data Scientists and stakeholders to validate results.
Translate complex data into actionable recommendations for clients.
Produce client-ready reports and presentations using Excel and PowerPoint.
Present findings clearly to clients and answer questions confidently.
Collaborate with teams to deliver timely and commercially valuable campaign measurement.

Skills

SQL

Data analysis

Python (basic)

Tools

Excel

PowerPoint

Job description

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.