Apprentice Systems and Reporting Analyst

This is an exciting opportunity to work within a dynamic Further Education environment, where your expertise will contribute to improving outcomes for learners and supporting key business objectives across the College.

• Provide support to the Business Intelligence: Senior Analyst
• Assist and participate with current and future Business Intelligence projects
• Develop and maintain a good knowledge of the functionality and structures of various cross-college management information systems (MIS), processes and departments (for example Registry and Admissions)
• Develop timely and accurate reports using reporting tools such as SQL/SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio, Power Automate and Power BI. Core College SQL database systems include but are not limited to: Tribal EBS (Education Business System), ProMonitor, Strata, Power BI, and Power Automate etc.
• Implement, develop and maintain integration between the Learner Record System (EBS) and other College systems where required
• Contribute to the ongoing development of the College’s dashboard system
• Be proactive in the testing of releases of EBS, including occasional BETA release testing
• General maintenance of EBS, including the management of staff records, logging calls, track and follow up with relevant MIS software providers
• Be the main contact point for teaching staff training on EBS for electronic registers, OnTrack and Reports. This includes maintaining notes and videos and conducting training face to face or via Teams where necessary
• Support a variety of staff on all EBS modules and encourage staff to access data using the appropriate MI system
• Maintain, update, and monitor automated report schedules
• Take an active role in the set up and smooth running of the College enrolment process and contribute ideas to its further development
• Assist in the collection and input of learner qualifications relating to GCSE point scores (value added)
• Develop and maintain an understanding of the technical aspect of the job and keep abreast of technical development and report strategies
• Occasional work outside of regular hours to assist at enrolment, open events and representing the department at Staff Council meetings
• General duties such as typing, photocopying and dealing with face to face, telephone and email queries from staff, learners and the public
• Maintain an understanding of General Data Protection Regulation (GDPR)
• Attend meetings when required
• To carry out additional roles within the college as may be agreed from time to time

• Communication skills
• IT skills
• Attention to detail
• Organisation skills
• Problem solving skills
• Administrative skills
• Number skills
• Analytical skills
• Team working
• Initiative

• English GCSE, grade 4 and above (Essential)
• Maths GCSE, grade 4 and above (Essential)
• IT/Admin Level 3 Administration/IT qualification, grade Pass/relevant work experience (Essential)