At a Glance
- Tasks: Transform data into insights, build dashboards, and support impactful decision-making.
- Company: Dynamic agency partnership with a focus on data-driven solutions.
- Benefits: Competitive salary, discretionary bonus, wellbeing fund, and flexible working.
- Other info: Enjoy 4pm finishes on Fridays and extra wellbeing days off!
- Why this job: Join a fast-paced environment and make a real impact with your data skills.
- Qualifications: Strong SQL and Power BI skills, problem-solving mindset, and clear communication.
The predicted salary is between 33000 - 33000 € per year.
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.
Benefits
- 10% discretionary bonus
- £1,800 yearly wellbeing fund
- Free Headspace subscription
- £500 yearly Learning Fund for learning
- 4 extra Wellbeing Days off per year
- 4pm finishes every Friday
- Flexible and hybrid working
A Little Bit About You
- 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
What You’ll Be Doing
- 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
Data Analyst in Leeds employer: SMG
Join a dynamic and innovative team as a Data Analyst in our Leeds office, where we prioritise employee wellbeing and professional growth. With a generous benefits package including a 10% discretionary bonus, flexible working arrangements, and dedicated funds for learning and wellbeing, we foster a supportive work culture that encourages collaboration and insight-driven decision-making. Our commitment to your development and the opportunity to work closely with both Insights and Engineering teams makes this an exciting place to advance your career.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst in Leeds
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. We all know that sometimes it’s not just what you know, but who you know that can help you land that Data Analyst role.
✨Tip Number 2
Prepare for those interviews by practising common questions and showcasing your SQL and Power BI skills. We recommend doing mock interviews with friends or using online platforms to get comfortable talking about your experience and how you can add value to the team.
✨Tip Number 3
Showcase your work! Create a portfolio of dashboards or projects you've worked on. This gives you a chance to demonstrate your problem-solving skills and ability to handle large datasets. We love seeing real examples of your work!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we’re always looking for passionate individuals who are ready to make an impact in our Leeds office.
We think you need these skills to ace Data Analyst in Leeds
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Analyst role. Highlight your SQL skills and experience with Power BI, as these are key for us. Use specific examples that showcase your problem-solving abilities and how you've handled large datasets.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Tell us why you're passionate about data analysis and how you can contribute to our team. Mention your adaptability and experience working in fast-paced environments to show us you're a great fit.
Showcase Your Projects:If you've worked on any relevant projects, make sure to include them in your application. Whether it's building dashboards or structuring datasets, we want to see what you've done. This gives us insight into your practical skills and creativity.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It helps us keep track of applications and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at SMG
✨Master Your SQL Skills
Make sure you brush up on your SQL skills before the interview. Be ready to discuss how you've used SQL to query and manipulate datasets in past projects. Practising some common SQL queries can help you feel more confident when discussing your technical abilities.
✨Showcase Your Dashboard Experience
Since building dashboards in Power BI is a key part of the role, prepare to talk about your experience with it. Bring examples of dashboards you've created, and be ready to explain the metrics you tracked and how they impacted decision-making. Visual aids can really help here!
✨Communicate Clearly
This role requires clear communication between teams, so practice articulating complex data concepts in simple terms. Think of examples where you've successfully translated business questions into actionable insights, as this will demonstrate your ability to bridge the gap between Insights and Engineering.
✨Be Ready for Problem-Solving Scenarios
Expect to face some problem-solving scenarios during the interview. Prepare to discuss how you've identified data inconsistencies or gaps in the past. Highlight your analytical thinking and adaptability, especially in fast-paced environments, to show that you're the right fit for the team.
