Data Analyst - Power BI & KPI Insights for Education

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

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.