Insight Executive

SMG; Nottingham; Hybrid; GBP 25,000 - 31,000; Full time

Benefits offered by this job

10% discretionary bonus

Wellbeing fund £1,800 yearly

Headspace subscription

Uni Fund £500 yearly

Wellbeing Days off

Annual Summer conference

4pm finishes on Fridays

Flexible and hybrid working

Job summary

SMG is hiring an Insight Executive to join the Nottingham team supporting BMG. You’ll deliver the BMG IQ suite by integrating Boots first‑party data with campaign performance and broader insights.

The role requires turning data into clear, commercially relevant recommendations and presenting them to clients. You’ll manage end-to-end insight projects, build dashboards, and collaborate with cross‑functional teams to ensure high‑quality outputs and client impact.

Qualifications

• Turn complex analysis into a simple, compelling story with a clear “so what”.
• Ability to work with large datasets and structure outputs for analysis.
• Experience building dashboards and visualising data using Power BI.
• Strong working knowledge of Excel/Google Sheets and PowerPoint/Slides.
• Clear communication skills and the ability to tailor insight to different audiences.

Responsibilities

• Analyse campaign and channel performance to identify trends and opportunities.
• Combine Boots first-party data, campaign results and wider sources to build a complete picture.
• Translate analysis into actionable, client-ready recommendations.
• Create compelling presentations and dashboards for clients.
• Manage insight projects from brief to delivery within timelines.
• Quality-check outputs to maintain high standards.
• Build dashboards and tools to enable self-service insights for clients.
• Present findings and recommendations confidently to clients.
• Build strong relationships with client teams and stakeholders.
• Ensure insight meets client objectives and brief.

Skills

Data storytelling

Large datasets

Power BI

Excel/Google Sheets

PowerPoint/Slides

SQL (desirable)

Python (desirable)

Stakeholder management

Tools

Power BI

Excel

Google Sheets

PowerPoint

SQL

Python

Job description

Location: Nottingham, minimum 2 days per week in office
Salary: From £28,000 + 10% discretionary bonus
Level: 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’re looking for an Insight Executive to join our agency partnership with BMG, based in Nottingham.

Sitting within the Insights team, you’ll have a primary focus on delivering BMG IQ, our suite of insight products designed to help suppliers understand performance, identify opportunities and make more effective retail media decisions.

You’ll take projects from brief through to delivery, combining Boots first-party data, campaign performance and wider insight sources to uncover the “so what”. You’ll transform your analysis into compelling stories and clear, commercially relevant recommendations for clients.

What you’ll do

• Analyse campaign and channel performance to identify trends, opportunities and performance drivers for key brands.
• Bring together Boots first-party data, campaign results and wider insight sources to build a complete picture.
• Go beyond what happened to explain why it matters, translating analysis into actionable recommendations.
• Create compelling, client-ready presentations and dashboards.
• Manage insight projects from initial brief through to client delivery, keeping them on track against agreed timelines.
• Quality-check analysis and outputs to maintain consistently high standards.
• Build dashboards and tools that help client and campaign teams self-serve insights.
• Present findings and recommendations confidently to clients.
• Build strong relationships with BMG client teams, suppliers and wider stakeholders.
• Understand client objectives and make sure your insight answers the brief.

What we’re looking for

• The ability to turn complex analysis into a simple, compelling story with a clear “so what”.
• Confidence working with large datasets and structuring outputs for analysis.
• Experience building dashboards and visualising data using Power BI.
• Strong working knowledge of Excel/Google Sheets and PowerPoint/Google Slides.
• Strong problem-solving skills, including identifying data inconsistencies and gaps.
• Clear communication skills and the ability to tailor insight and recommendations to different audiences.
• The ability to work effectively with multiple stakeholders across different teams.
• Experience querying and manipulating datasets using SQL is desirable but not essential.
• A basic understanding of Python and its application to data analysis is desirable but not essential.

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
• Annual Summer conference + 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.