Service Analyst Manager in London

Located in the heart of South London, Lambeth Borough is a vibrant community of over residents. Stretching from the dynamic neighbourhood of Streatham in the South to the iconic landmarks of Waterloo in the North, we are proud to be the th largest borough in London. Our diversity is our strength, with more than languages spoken, making Lambeth the home of the Windrush generation, London's largest LGBTQ+ community, and a thriving Portuguese-speaking community.

It is an exciting time to join Lambeth Council, we have bold ambitions for the future of Lambeth’s communities and residents through our exceptional schools, lush green spaces including Brockwell Park, cultural gems like the Black Cultural Archives, and world-renowned institutions such as St Thomas's Hospital, Lambeth offers an enriching and dynamic environment.

The 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. Our integrated approach helps children and young people fulfil their potential and make positive contributions to their communities.

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.

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: th March at midnight.