as our Data Analyst & Report Writer will include :

Develop, test, and maintain SQL queries for data extraction and reporting purposes.
Create and manage reports using SQL and Power BI to support various college departments.
Collaborate with team members to ensure the data management system is optimised.
Assist the team in troubleshooting and maintaining reports, and databases, ensuring data integrity and security.
Support with data analysis requests and ad hoc report creation for internal stakeholders.
Maintain documentation for data processes and reports.
Identify improvements in the reporting systems and implement solutions.
Provide user training and support for Power BI and SQL reports.
Communicate and assist users in their understanding of all reports developed and published by the team.
Assist the IT team with updates to the student records system.
Provide information in a variety of visual formats including statistical reports, graphs and diagrams for use by internal and external clients ensuring the information presented is clear and unambiguous.
Work closely with the line management and the other members of the development team to ensure project and regular cycle deadlines are met.

Level 2 (or equivalent) English and Maths
Level 3 IT qualification or relevant experience
A good understanding of the SQL language with an ability to write SQL statements with clear and easily readable code
Experience working with SQL and report writing in an education or corporate environment
Proficiency in SQL and Microsoft SQL Server Management Studio (MSMS)
Knowledge of Power BI or similar business intelligence tools

27.5 days annual leave plus bank holidays
up to 4 days leave during the Christmas closure period
Free parking at all of our college sites (where spaces are available)
Access to Discount Schemes at multiple retailers
Enrolment into the NEST Pension Scheme