Data Analyst

Franklin Sixth Form College is seeking a Data Analyst to join our Management Information Systems (MIS) team. Reporting to the Head of IT & MIS, you will play a key role in providing accurate, reliable and timely management information to support the College's operational and strategic objectives.

You will develop and optimise SQL queries, views and stored procedures, and create reports and dashboards using tools such as Power BI, SQL Server Reporting Services (SSRS) and Excel. Working with colleagues across the College, you will provide performance metrics, KPI reporting, trend analysis and insights to support planning, performance monitoring and continuous improvement.

Alongside your analytical responsibilities, you will help maintain the accuracy and integrity of the College's management information systems. This will include checking and resolving data errors, supporting learner enrolment and curriculum data processes, contributing to ILR returns and funding reports, and providing evidence for audit, inspection and quality assurance activities. You will also help improve reporting processes and ensure data is managed in accordance with UK GDPR and College policies.

Do you have strong analytical skills, an eye for detail and the ability to develop reports that support effective decision-making?, We are looking for someone with strong SQL skills, excellent analytical ability and a meticulous approach to data quality. You should be confident working with relational databases and large volumes of data, translating reporting requirements into practical solutions and communicating findings clearly. Experience of Power BI, SSRS and advanced Excel would be advantageous, alongside a proactive approach to problem-solving and continuous improvement.

In return, you will join a supportive and collaborative team within a college committed to innovation, continuous improvement and student success.

Salary: Sixth Form Colleges Support Staff Pay Scale, NJC Points 15 to 17, currently £32,199 -£34,253 FTE, with a pay award increase anticipated, subject to approval

Closing date: 12pm on Thursday 12^th November 2026

Interview date: Friday 20^th November 2026

Additional benefits include:

· Generous Local Government Pension Scheme

· Free on-site gym facilities

· Free parking

· Cycle to Work Scheme

· Excellent on-site catering provisions

If you are enthusiastic about data analysis, enjoy developing reporting solutions and want to use your skills to support better decision-making and outcomes for students, we would welcome your application.