Insight Executive

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.