Data Analyst
Turn data into impact! đź’» Build dashboards, solve problems, and power smarter decisions in a fast-moving, collaborative team.
Location: Hybrid - 3 days per week in our Leeds office
Salary: From ÂŁ33,000 + 10% discretionary bonus
About the Role
We are looking for a Data Analyst (internally titled Senior Insight Executive) to join our agency partnership with LS Eleven (LS11) based in Leeds. In this role, you will play a key part in ensuring data is accurate, accessible, and ready for analysis, supporting campaign evaluation and client delivery. You will work closely with both Insights and Engineering teams to transform business questions into structured data outputs, enabling impactful, insight-driven decisions.
If you love variety, thrive in a fast-paced environment, and embrace change with energy, this could be your right role.
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.
Our culture is everything. If you’re someone who stays honest, stays hungry, stays foolish, and has fun, you’ll feel right at home here.
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 “Learning Fund” for learning
4 extra Wellbeing Days off per year
4pm finishes every Friday
Flexible and hybrid working
Are We What You’re Looking For?
We move fast, adapt quickly, and like to challenge each other. 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.
This isn’t for everyone, but if you thrive in this environment, we’d love to meet you!
A Little Bit About You
You’ll bring:
Strong SQL skills, with the ability to query, join, and manipulate datasets independently
Experience building dashboards in Power BI, including working with DAX
Confidence handling large datasets and structuring them for analysis
Strong problem-solving skills, with the ability to identify data inconsistencies and gaps
Clear communication skills, translating business questions into actionable data outputs
Experience managing stakeholders across Insights and Engineering teams
Adaptability and comfort working in a fast-paced, evolving environment
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.
What You’ll Be Doing
Your days will be dynamic. You might find yourself:
Writing and running SQL queries to extract and manipulate data from established data models
Structuring raw data into clean, analysis-ready datasets
Combining and transforming data from multiple sources
Building and maintaining Power BI dashboards to track campaign performance
Creating and refining key metrics such as ROI and conversion rates using DAX
Translating business questions into structured datasets and reporting outputs
Ensuring data outputs directly address stakeholder briefs
Owning and maintaining evaluation trackers, ensuring accuracy and completeness
Identifying missing data or briefing gaps and flagging dependencies
Acting as the link between Insights and Engineering teams, clearly communicating requirements and escalating issues where needed
Our Values:
Stay honest. Stay hungry. Stay foolish. Have fun.
Explore what that means to us here
Useful Links Before You Apply:
Still Curious?
We always send a confirmation email - check your spam if you don’t see it. Problems? Email: careers@smg.team
Our full data retention policy can be found here.
Current vacancies
Leeds
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.