How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
Explore all our benefits here.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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:
- Learn about our departments
- Our hiring process
- Life at SMG
- FAQs
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location