Senior Analyst

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

Benefits offered by this job

Hybrid working

Job summary

Derby City Council is seeking a Senior Analyst to turn SEND, education and health data into clear insight. You will create dashboards, produce statutory returns and support decision-making for managers and senior leaders across SEND, inclusion and related services.

The role involves extracting data from multiple systems, combining datasets to provide meaningful insights, and presenting findings to senior stakeholders. Hybrid working is available within the Council House location.

Qualifications

• Experience in a management information, performance or BI environment.
• Experience producing performance and management information for managers and senior leaders.
• Strong analytical skills to identify and explain complex data.
• Experience extracting and manipulating data from various databases/systems.
• Experience developing reports and dashboards using Power BI or similar BI tools.
• Knowledge of statistical techniques and their practical application.
• Ability to produce clear, concise reports and presentations for varied audiences.
• Strong attention to detail and meeting deadlines.
• Ability to collaborate with colleagues with different data/analytical skills.

Responsibilities

• Provide clear, accessible analysis and insight across SEND, inclusion and related services.
• Work with managers and senior leaders to understand performance and trends.
• Extract, transform and analyse complex datasets from multiple systems.
• Develop and maintain reports and interactive dashboards using Power BI and other BI tools.
• Use SSMS to extract and interrogate data.
• Complete statutory data returns (SEND2, Alternative Provision Census, CLD returns).
• Improve data quality by identifying issues and supporting corrective action.
• Combine data from SEND, education, children’s and adults’ services to provide insights.
• Produce concise reports, presentations and briefings for senior managers.
• Support strategic projects through robust analysis and evidence.
• Deputise for senior colleagues as appropriate.

Skills

MIS / BI environment

Performance / management info

Power BI

SQL / SSMS

Data quality

Data interpretation

Data storytelling

Collaborative working

Tools

Power BI

SSMS

SQL databases

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.

This is a varied role where your analysis will have a direct connection to how services are understood, planned and improved.

About You

To be successful in this role, you’ll ideally have...

• 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.

Important Information

Links to the full Job Description and Person Specification are available below.

All employees will normally be appointed to the minimum of the grade for the role.

Where a DBS requirement is indicated at the top of this advert, the successful candidate will be subject to the appropriate Disclosure and Barring Service (DBS) check as part of our safer recruitment process.

Where a Market Rate Supplement is indicated at the top of this advert, it is paid in addition to the basic salary and is subject to regular review. The supplement may be reduced or withdrawn and will reduce in line with incremental progression and pay awards.

The Council has a legal obligation to consider suitable redeployment opportunities for employees at risk of redundancy. Consequently, this vacancy may be withdrawn before the advertised closing date if it is filled through the Council's redeployment process.

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.

If you have any questions about this vacancy or need assistance with your application, please contact the Recruitment Team on 01332 640844 (Relay UK: 18001 01332 640844) or email [e-mail]

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.

References: Please see here for Job Description & Person Specification. Please see Declaration Form for CV Applications here. Please see Equalities Form for CV Applications here. Please see here for DBS Code of Conduct.