Data Analyst

Job overview

Haydon is a large, friendly and creative school in North West London. We have been judged as good by OFSTED. We are looking for a passionate Data Analyst to join our friendly Operations Team. We are an energetic and passionate department that is dedicated to cultivating a love of collaborative and inclusive working environment.

The Data Analyst will be responsible for the effective management, integrity and use of student, assessment and performance data across the school and sixth form. The role supports teaching and learning, accountability, reporting and statutory requirements by ensuring accurate, timely and meaningful data is available to staff, students, parents and external agencies.

The post holder will lead on assessment systems using our MIS system currently:
Bromcom, data reporting cycles, target setting, performance tracking, examination-related data processes, and the maintenance of linked systems including Hay Net (in-house developed), Google Workspace and external performance software such as SMID and FFT.

• Set up, maintain and update assessment marksheet templates using MIS (Bromcom) for all year groups and subjects.

• Work closely with Heads of Year, Heads of Department and Senior Leaders to design and refine mark sheets, broadsheets and reporting structures.

• Manage termly data drops
  , including:

  • Monitoring and chasing completion of mark sheets.

  • Locking completed columns and preparing subsequent data collection points.

  • Create and maintain Bromcom reports for each year group and reporting cycle, incorporating:

    • Attendance

    • Behaviour

    • MEG, Potential, ATL, Mock and Predicted grades as appropriate.

• Produce and maintain Microsoft Word mail merge report templates
  , ensuring correct merge fields and layouts for each reporting cycle.

• Generate, publish and distribute student reports via:

  • MIS:
    Bromcom

  • My Child At School (MCAS)

  • Student Portal

• Ensure reports are uploaded to the Document Management System (DMS) and published accurately.

• Use Fisher Family Trust (FFT) to obtain target grades for relevant year groups.

• Match FFT target data with timetable and subject data (via Hay Net) to create accurate import files for Bromcom.

• Generate GCSE prior attainment scores for Year 12 students new to the school.

• Update and maintain school performance software (SMID) with each data drop, ensuring correct formatting and validation.

• Produce Google Sheets and analysis documents for:

  • MEGs

  • Potential / Mock / Predicted grades

  • ATL grades and averages

  • Horsfall matrices for KS4 and KS5.

• Set up and maintain fine grade assessment sheets for subjects using granular assessment data (e.g. Maths, Science, History, DT etc..).

• Ensure correct configuration of fine grades within Bromcom and their aggregation into overall scores.

• Support internal and external examination processes, including:

  • Downloading exam data from Bromcom.

  • Managing examination data via Microsoft Access.

  • Producing exam labels and documentation not available through standard MIS reports.

• Support GCSE and A Level Results Days
  , including:

  • Exporting and manipulating results data.

  • Preparing files for upload into SMID.

• Create and manage exam-related student accounts and documentation where required (e.g. word processing access).

• Support and maintain Hay Net
  , ensuring accurate integration of data from:

  • MIS:
    Bromcom

  • Network systems

  • Google Workspace

  • Other third-party platforms (e.g. Kerboodle).

• Use data from Hay Net to support:

  • Reporting processes

  • Exams administration

  • Google account and system maintenance.

• Work with Microsoft Access, SQL queries and spreadsheets to extract, transform and present data as required.

• Maintain and support Google Forms and Sheets used for:

  • Year 9 Options process

  • Attendance reporting

  • Behaviour and safeguarding-related forms

  • Invigilator availability

  • On-call and phone pouch systems.

• Support annual rollover processes, including archiving and resetting data for new academic years.

• Use scripts and automated processes to improve efficiency and data accuracy.

• Ensure compliance with data protection legislation (GDPR) and school data policies.

• Maintain high standards of data accuracy, consistency and security.

• Produce documentation and guidance for staff on data processes.

• Identify opportunities to improve data systems, reporting and automation.

• Provide support and training to staff where appropriate.

Any other duties as reasonably required by the Network Manager, Head teacher, or Member of the SLT which is consistent with the overall level, nature and grading of the post. This job description and the allocation of the particular responsibilities may be amended from time to time.

To play a full part in the life of the school community, to support the school’s distinctive mission and ethos and to encourage students and staff to follow this example.

• All teaching…