Systems Developer

Contract Type: Part time (up to 15 hours/week). Term time (39 weeks) plus 4 weeks holiday working (43 weeks total). Fixed term to 31 August 2027. Salary: Point 12 to Point 20 on the SFCA Support Staff Scale (£29,544 to £37,734 FTE, £11,409 to £14,572 actual salary based on 15 hours pw / 43 weeks pa) starting point to be determined by relevant experience. Closing Date: Midday, Monday 24th August 2026. This is a role for someone able to own the College's back-end MIS work and translate technical data needs into reliable reports and processes. As the sole Systems Developer you will maintain and develop the Civica REMS database and related systems, write and run SQL queries, produce SSRS/Power BI reports, and provide technical support to MIS, Exams and Admissions during peak cycles. The post suits an experienced SQL/BI developer who prefers autonomy, practical problem-solving, and a direct impact on college operations. What you'll be doing Maintain and administer the Civica REMS back-end: database tuning, troubleshooting, preserving bespoke scripts and custom code. Write, test and optimise SQL (queries, views, stored procedures) to support operational needs and ad-hoc requests. Design, develop and maintain reports and dashboards using SSRS, Power BI, Report Builder and Visual Studio; schedule and deliver outputs to curriculum, pastoral teams, students and parents/carers. Configure and run mass-communication back-end processes (mail-merge/data streams, surveys, digital communications). Support key operational cycles (timetabling, student records, enrolment periods, exams administration), including hands-on support at peak times which may include occasional evening work. Prepare and test back-end actions required for system updates and assist with the planned transition to a cloud-based REMS when available. Produce clear technical documentation, specifications and guidance so non-technical staff can use reports and systems reliably. Ensure all work complies with data p