Data Analyst and Report Writer

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