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 employer: SMG
Join our dynamic team as a Data Analyst in Leeds, where we prioritise employee wellbeing and professional growth. With a flexible hybrid working model, generous benefits including a yearly learning fund and extra wellbeing days, and a collaborative work culture, we empower our employees to thrive both personally and professionally. Be part of an innovative environment that values your insights and contributions, making a meaningful impact on our clients' success.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst
✨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 your data projects, dashboards, and any analyses you've done. This gives us a tangible way to see your skills in action and understand how you approach problem-solving.
✨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 love seeing candidates who are genuinely interested in joining our team at StudySmarter.
We think you need these skills to ace Data Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Data Analyst role. Highlight your SQL prowess, dashboard-building experience in Power BI, and any relevant projects that showcase your problem-solving skills.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're the perfect fit for this position. Share specific examples of how you've tackled data inconsistencies or transformed business questions into actionable insights. Make it personal and engaging!
Showcase Your Communication Skills:Since you'll be working closely with both Insights and Engineering teams, it's crucial to demonstrate your ability to communicate complex data findings clearly. Use your application to show us how you can bridge the gap between technical and non-technical stakeholders.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
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 prepared to discuss how you've used SQL to query and manipulate datasets in past projects. You might even be asked to solve a problem on the spot, so practice writing queries that extract and clean data.
✨Showcase Your Dashboard Experience
Since building dashboards in Power BI is a key part of the role, come ready 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.
✨Communicate Clearly
This role requires translating business questions into actionable data outputs, so practice articulating complex data concepts in simple terms. Think of examples where you've successfully communicated insights to stakeholders and how that influenced their decisions.
✨Be Ready for Problem-Solving Scenarios
Expect to face some problem-solving scenarios during the interview. Prepare by thinking through how you would identify and address data inconsistencies or gaps. Highlight your adaptability and how you've thrived in fast-paced environments in the past.
