Data Analyst
SMG · Leeds, England, United Kingdom · £33K/yr
Advertising Services · 201-500 employees
About the role
The Data Analyst will ensure data accuracy and accessibility while transforming business questions into structured data outputs. They will build and maintain Power BI dashboards and act as a bridge between the Insights and Engineering teams.
What they look for
Requirements
Candidates must possess strong SQL skills and experience building dashboards in Power BI using DAX. The role requires the ability to handle large datasets, solve complex problems, and communicate effectively with stakeholders.
Benefits
Full description
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
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.
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.
