At a Glance
- Tasks: Lead data analysis to improve outcomes for children and young people in Lambeth.
- Company: Join a vibrant community-focused team at Lambeth Borough.
- Benefits: Competitive salary, professional development, and a supportive work environment.
- Other info: Dynamic role with opportunities for innovation and career progression.
- Why this job: Make a real impact using your data skills to shape youth services.
- Qualifications: Experience in data analysis with strong skills in Power BI, SQL, and Excel.
The predicted salary is between 54360 - 57495 € per year.
Located in the heart of South London, Lambeth Borough is a vibrant community of over 317,600 residents. Our diversity is our strength, with more than 130 languages spoken, making Lambeth the home of the Windrush generation, London's largest LGBTQ+ community, and a thriving Portuguese-speaking community. Lambeth Youth Justice Service is a dynamic multi-disciplinary team, committed to supporting children, young people and their families. We work to address vulnerabilities, reduce risks and tackle the factors that lead to offending behaviour.
We are collaborative, inclusive and guided by our core values: Equity, Accountability, Ambition and Kindness. These principles shape how we work with families, partners, and each other, ensuring fairness, responsibility, compassion and drive for excellence in everything we do. Our team values creativity, respect and partnership both with families and across agencies to achieve meaningful outcomes. We invest in our people. You will have access to professional development opportunities, specialist training and the chance to work alongside experienced practitioners in a supportive environment that encourages innovation and career progression.
About the Role: Are you a highly skilled data professional ready to shape outcomes for children and young people? We’re looking for an experienced Service Analyst Manager to lead performance and insight within our Youth Justice Service. This is a strategic role where your expertise in Power BI, SQL, and advanced Excel will directly influence service delivery, statutory reporting, and evidence-based decision-making.
What You’ll Do:
- Lead service performance analysis and reporting.
- Build and maintain dynamic Power BI dashboards.
- Write and optimise SQL queries to extract and transform complex datasets.
- Use advanced Excel (PivotTables, Power Query, data modelling, complex formulas) to deliver high-quality insight.
- Ensure accurate statutory returns and KPI reporting.
- Present clear, actionable analysis to senior leaders and partners.
What We’re Looking For:
- Proven experience in data analysis within public sector, youth justice, or criminal justice settings.
- Strong technical capability in Power BI, SQL, and Excel.
- Experience developing performance frameworks and translating data into strategic insight.
- Excellent communication skills — able to explain complex data to non-technical stakeholders.
This is a key leadership role for someone who combines technical excellence with a passion for improving outcomes through data. This pivotal role ensures the service has robust systems, processes, and resources to access accurate, high-quality data that drives decision-making and improves outcomes for children and young people. You will manage a small team, oversee reporting, and case management systems, and lead on data projects that enhance business intelligence and reduce information overload.
As the data specialist, you will work closely with senior leaders and partner agencies to provide insight, support strategic planning, and prepare for inspections. You will also take responsibility for system administration, data quality, compliance with legislation, and the development of innovative solutions to improve service delivery.
How to Apply:
To be considered for interview, your CV and supporting statement will clearly evidence how you meet the shortlisting criteria on the personal specification marked “A” for application. We operate an anonymised application process, so be sure to remove personal details when uploading your CV or personal statement. Advert closing date: 29th March at midnight. You will be required to undertake a Cifas check.
For an informal discussion about the role, please contact Maxine Whittaker, mwhittaker@lambeth.gov.uk. At Lambeth, we are dedicated to providing quality services and equal opportunities for all. We are committed to safer recruitment and are proud to be a Stonewall diversity champion, a Living Wage Employer, and to guarantee interviews for all disabled candidates who meet the minimum criteria of the role.
Service Analyst Manager employer: Datatoinsight
Lambeth Borough is an exceptional employer, offering a vibrant and inclusive work culture that prioritises equity, accountability, ambition, and kindness. As part of the Youth Justice Service, you will have access to professional development opportunities and specialist training, all while working in a dynamic environment that values creativity and collaboration. Located in the heart of South London, this role not only allows you to make a meaningful impact on the lives of children and young people but also provides a supportive atmosphere for career progression and innovation.
StudySmarter Expert Advice🤫
We think this is how you could land Service Analyst Manager
✨Tip Number 1
Network like a pro! Reach out to people in your field, especially those connected to Lambeth or youth services. A friendly chat can open doors and give you insights that a job description just can't.
✨Tip Number 2
Prepare for the interview by practising your storytelling skills. Think of examples from your past that showcase your data analysis prowess and how it led to positive outcomes. We want to hear about your impact!
✨Tip Number 3
Show off your tech skills! Be ready to discuss your experience with Power BI, SQL, and Excel in detail. Maybe even bring along a sample dashboard or report to demonstrate your capabilities—visuals can speak volumes!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets the attention it deserves. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Service Analyst Manager
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to highlight your experience in data analysis, especially in public sector or youth justice settings. Use keywords from the job description to show that you’re a perfect fit for the Service Analyst Manager role.
Craft a Compelling Supporting Statement:Your supporting statement is your chance to shine! Clearly demonstrate how you meet the shortlisting criteria marked 'A'. Use specific examples from your past work to illustrate your skills in Power BI, SQL, and Excel.
Keep It Professional but Personal:While we want you to be professional, don’t shy away from showing a bit of your personality. Let us see your passion for improving outcomes for children and young people through data. A personal touch can make your application stand out!
Follow Application Guidelines:Remember, we operate an anonymised application process. So, remove any personal details from your CV and supporting statement before uploading. Following these guidelines shows attention to detail, which is crucial for this role!
How to prepare for a job interview at Datatoinsight
✨Know Your Data Tools
Make sure you brush up on your skills with Power BI, SQL, and advanced Excel before the interview. Be ready to discuss specific projects where you've used these tools to drive insights or improve outcomes, as this role heavily relies on them.
✨Understand the Youth Justice Context
Familiarise yourself with the current challenges and trends in youth justice. Being able to speak knowledgeably about how data can influence service delivery and support vulnerable young people will show your passion for the role and its impact.
✨Prepare for Scenario Questions
Expect questions that ask you to demonstrate your problem-solving skills. Think of examples where you've had to analyse complex datasets and present findings to non-technical stakeholders. This will highlight your communication skills and ability to translate data into actionable insights.
✨Showcase Your Leadership Skills
As a Service Analyst Manager, you'll be leading a small team. Be prepared to discuss your leadership style and how you've successfully managed teams in the past. Highlight any experience you have in mentoring or developing others, as this aligns with the values of collaboration and support.
