Senior Business Intelligence Analyst - School Census Lead

Senior Business Intelligence Analyst – School Census Lead

Base pay range
:
Provided by Stockport Council.
Role 37 hours, full-time, permanent, hybrid Stopford House office.
Final date to receive applications: 11:59pm 11th January 2026.
Shortlisting date: 12th January 2026.
Assessments/interviews: 14th January 2026.
Interview format: One-hour online assessment followed by a Microsoft Teams interview.

While we embrace AI as an innovative tool to maximise our services, we value authentic applications. Please ensure your application is written by you and reflects your skills and enthusiasm. Think carefully before using AI in your application.

Your role

We are seeking a talented School Performance Senior Analyst to join the Education Data Team at Stockport Council. The successful candidate will work with the Education Data Manager and a School Performance Analyst, leading the School Census submissions and analytics for education attendance and school demographics.

Key responsibilities

• Lead and drive the termly School Census statutory data return
• Prepare pre-Census activities, delegate tasks, and manage team workload
• Cleanse, validate, and link data across systems using SQL, MS Access, and Tableau
• Liaise with schools and run reports on DfE platform and Tableau dashboards
• Create, edit, and maintain Tableau dashboards on Attendance, Suspensions/Exclusions, Electively Home Educated Children, and Census/demographic profiles

Essential qualifications

• Previous experience working with SQL, including writing and editing queries
• Experience using Tableau (or Power BI) to produce interactive dashboards
• Proficient in MS Excel and other Microsoft tools; experience with MS Access or other relational database systems desirable
• Track record of leading projects from scoping to completion, meeting time and quality objectives
• Excellent interpersonal skills, high standard of written and oral communication
• Ability to work flexibly and support teams in implementing change or delivering key projects
• Enthusiasm for personal development, learning new techniques, and improving processes
• Strong analytical skills, interpreting information, identifying inaccuracies, and informing solutions
• Experience delivering complex data to non-technical audiences with confident presentation style
• Maths and English GCSEs at Grade C/Level 4 or higher (or equivalent)

Desirable background

• Previous experience in an Education or Education Data environment, especially with systems such as School Management Information Systems within a Council, school, or Academy Trust

Seniority level
:
Mid-Senior

Employment type
:
Full-time

Job function
:
Analyst |
Industry
:
Data Infrastructure and Analytics

If you would like to find out more about the role, please contact Stephen Bray at s for an informal discussion.

Secondment opportunities are available for Stockport Council employees, subject to manager approval.

Stockport Council holds a Visa sponsorship licence; however this role does not currently qualify for sponsorship.

Referrals will increase your chances of interviewing at Stockport Council.