Responsibilities
as our Data Analyst & Report Writer will include:
1. Develop, test, and maintain SQL queries for data extraction and reporting purposes.
2. Create and manage reports using SQL and Power BI to support various college departments.
3. Collaborate with team members to ensure the data management system is optimised.
4. Assist the team in troubleshooting and maintaining reports, and databases, ensuring data integrity and security.
5. Support with data analysis requests and ad hoc report creation for internal stakeholders.
6. Maintain documentation for data processes and reports.
7. Identify improvements in the reporting systems and implement solutions.
8. Provide user training and support for Power BI and SQL reports.
9. Communicate and assist users in their understanding of all reports developed and published by the team.
10. Assist the IT team with updates to the student records system.
11. 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.
12. Work closely with the line management and the other members of the development team to ensure project and regular cycle deadlines are met.
As our Data Analyst & Report Writer, youll ideally have:
13. Level 2 (or equivalent) English and Maths
14. Level 3 IT qualification or relevant experience
15. A good understanding of the SQL language with an ability to write SQL statements with clear and easily readable code
16. Experience working with SQL and report writing in an education or corporate environment
17. Proficiency in SQL and Microsoft SQL Server Management Studio (MSMS)
18. Knowledge of Power BI or similar business intelligence tools
Benefits:
19. 27.5 days annual leave plus bank holidays
20. up to 4 days leave during the Christmas closure period
21. Free parking at all of our college sites (where spaces are available)
22. Access to Discount Schemes at multiple retailers
23. Enrolment into the NEST Pension Scheme