Data Analyst

Franklin Sixth Form College; Grimsby; On-site; GBP 32,000 - 34,000; Full time

Benefits offered by this job

Generous Local Government Pension

Free on-site gym facilities

Free parking

Cycle to Work Scheme

Excellent on-site catering provisions

Job summary

Franklin Sixth Form College in Grimsby is seeking a Data Analyst to join the MIS team. You will develop and optimise SQL queries, views and stored procedures, and create reports and dashboards using Power BI, SSRS and Excel to provide accurate management information for decision-making.

You will ensure data integrity across enrolment and curriculum data, contribute to ILR returns and funding reports, and support audit and quality assurance activities.

Qualifications

• Strong SQL skills with the ability to write efficient queries and optimise data loads.
• Experience building reporting dashboards in Power BI and SSRS.
• Advanced Excel skills for data analysis and modelling.

Responsibilities

• Develop reports and dashboards to support informed decision-making.
• Maintain accuracy and integrity of MIS data; resolve data errors.
• Support learner enrolment, curriculum data processes, and ILR returns.
• Provide KPI reporting, trend analysis and insights for improvement.

Skills

SQL

Power BI

Excel

Tools

SSRS

SQL Server

Job description

Data Analyst

Full time - 37 hours per week, Permanent, All year round

Are you passionate about data and enjoy turning information into meaningful insight?

Do you have strong analytical skills, an eye for detail and the ability to develop reports that support effective decision-making?

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.

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 12th November 2026

Interview date: Friday 20th 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.