Senior Analyst

Derby City Council; East Midlands; Hybrid; GBP 39,000 - 41,000; Full time

Benefits offered by this job

LGPS pension

Hybrid working

Generous annual leave

Learning & development

Wellbeing support

Job summary

Derby City Council is seeking a Senior Analyst to join the SEND Sufficiency, Partnership and Compliance service. You will turn complex data into clear insight, producing reports and dashboards to support decision-making for children, young people and families.

You will work with SEND, education, children’s and adult social care, health information, extracting and transforming data using SSMS and Power BI. You will provide statistical returns, contribute to service planning, and mentor

Qualifications

• Experience in management information, performance or BI environment.
• Experience producing performance data for managers and senior leaders.
• Strong analytical skills to interpret complex data.

Responsibilities

• Provide clear analytics and insight across SEND and related services.
• Develop and maintain reports and interactive dashboards using Power BI.
• Extract, transform and analyse data from multiple systems.
• Produce concise reports and briefings for senior managers.
• Support statutory data returns (SEND2, Alternative Provision Census, CLD).
• Contribute to service planning and improvement initiatives.

Skills

Analytical skills

Tools

Power BI

SSMS

Job description

The job requirements are detailed below. Where applicable the skills, qualifications and memberships required for this job have also been included.

Job details

Job title Senior Analyst Job reference 000012522 Date posted 29/09/2026 Application closing date 21/10/2026 Working Pattern Blank Salary Grade H £38,510 - £41,177 a year Contractual hours 37 Basis Full time Job category/type Social Care - Children Attachments Blank Job description Salary: £38,510 - £41,177 a year Hours: 37 hours per week Contract Type: Permanent Location: The Council House/Hybrid DBS Requirement: No Closing Date: 21st October 2026 Are you an experienced analyst who enjoys turning complex data into clear, meaningful insight? We are looking for a Senior Analyst to join Derby City Council’s SEND Sufficiency, Partnership and Compliance service. This is an opportunity to use your analytical and business intelligence skills to support decision-making across SEND, inclusion and related services, helping managers and senior leaders understand performance, identify trends and use evidence to improve services for children, young people and families. You will work with a wide range of data, including SEND, education, inclusion, children’s and adult social care and health information. You will extract and transform data, undertake analysis, produce statutory returns and develop reports and dashboards that turn complex information into something accessible and useful. You’ll also have the opportunity to work directly with managers and senior colleagues, helping them develop their understanding of data and how it can be used to inform service planning, sufficiency, commissioning and improvement. All of this during the incredibly exciting SEND Reforms.

The Opportunity

• Provide clear, accessible analysis and insight across SEND, inclusion and related services.
• Work with managers and senior leaders to understand performance, activity, trends and emerging issues.
• Extract, transform and analyse complex datasets from a range of systems and sources.
• Develop and maintain reports and interactive dashboards using Power BI and other business intelligence tools.
• Use SQL Server Management Studio (SSMS) to extract and interrogate data.
• Complete important statutory data returns, including the SEND2 return, - Alternative Provision Census and Client Level Data returns.
• Support improvements in data quality by identifying issues, investigating their causes and providing information to support corrective action.
• Bring together data from SEND, education, children’s and adult social care and health to provide meaningful insight across services.
• Produce concise reports, presentations and briefings for different audiences, including senior managers.
• Support strategic projects and programmes through robust analysis and evidence.
• Deputise for senior colleagues, including the Commissioning and Finance Manager, Statutory SEND Service Manager and Designated Social Care Manager, as appropriate.

About You

• Experience working in a management information, performance or business intelligence environment, ideally within local government or another complex public service organisation.
• Experience producing performance and management information for managers and senior leaders.
• Strong analytical skills, with the ability to identify, quality assure, interpret and explain complex data.
• Experience extracting and manipulating data from a range of databases and information systems.
• Experience developing reports and dashboards using Power BI or an equivalent business intelligence tool.
• Knowledge of statistical techniques and their practical application.
• The ability to produce clear, concise reports and presentations for a range of audiences.
• Strong attention to detail and the ability to work accurately to challenging deadlines.
• The ability to work collaboratively with colleagues who have different levels of data and analytical expertise.

Experience of working with SEND, education, children’s social care, adult social care, health, neighbourhoods or housing data would be advantageous.

Most importantly, we’re looking for someone who is curious about what the data is telling us, can challenge and explore information constructively, and can translate analysis into insight that helps people make better-informed decisions.

Who We Are

At Derby City Council, we're proud to deliver over 250 essential services that support our residents, communities and businesses. Guided by our vision to create an Inclusive, Green, Growing and Vibrant City, we put people at the heart of everything we do. Our values shape how we work every day. We believe in Great People, One Team, we’re Bold in embracing change, Strong in delivering for our communities, and We Care about making a positive difference. Join us and you'll be part of an ambitious, collaborative organisation where you can develop your career while helping to shape Derby's future. Why join Derby City Council? At Derby City Council, you'll have the opportunity to make a real difference while building a rewarding career in an organisation that values, supports and invests in its people. Alongside the opportunity to help shape the future of Derby, you'll benefit from a comprehensive range of employee benefits, including:

Financial Benefits

• Local Government Pension Scheme (LGPS) – a secure, defined benefit pension with life cover
• Team Derby Rewards – discounts across a wide range of retail, leisure and lifestyle brands
• Tusker Car Benefit Scheme – a salary sacrifice scheme for leasing a brand-new, fully maintained and insured vehicle

Work-Life Balance

• Generous annual leave, starting at 27 days and rising to 32 days after five years' service (plus bank holidays, depending on your contract)
• The option to purchase additional annual leave
• Flexible and hybrid working arrangements for many roles
• Flexible retirement options, where eligible
• Support for colleagues with caring responsibilities

Learning and Development

• Learning and development opportunities, with regular career conversations to support your growth
• Leadership and management development programmes, mentoring and professional qualifications
• Modern workspaces designed to support collaboration, productivity and wellbeing

Health and Wellbeing

• Employee Assistance Programme, wellbeing support and a year-round wellbeing calendar
• Free annual flu vaccinations
• Cycle2Work Scheme and free cycle training

Community and Inclusion

• Up to 1 hours of volunteering leave each year
• Recognition through initiatives including the Here for Derby Awards and Long Service Awards
• The opportunity to join one of our Employee Networks, including LGBTQ+, Disabled Employees and Carers, Black, Asian and Minority Ethnic Employees, and Neurodiversity

At Derby City Council, we believe our people are our greatest strength. Whatever stage you're at in your career, you'll be joining an inclusive organisation where you'll be supported to develop, feel valued and make a meaningful difference to the communities we serve. Some benefits are dependent on your role, contract or length of service.

Equality, Diversity and Inclusion

At Derby City Council, we're committed to creating an inclusive workplace where everyone feels valued and can thrive. We welcome applications from people of all backgrounds and believe our workforce should reflect the diverse communities we serve.

As a Disability Confident Leader, disabled applicants who meet the essential criteria for the role can choose to apply through our Guaranteed Interview Scheme. We are also proud to hold the Ministry of Defence Employer Recognition Scheme Silver Award, recognising our commitment to supporting serving personnel, veterans and their families. Members of the Armed Forces community, veterans and their close family members who meet the essential criteria are also eligible for our Guaranteed Interview Scheme.

If you need any reasonable adjustments at any stage of the recruitment process, including during your application, interview or onboarding, we’ll work with you to provide the support you need.