Reconciliation Assistant

Details


1099929


University of Warwick


11/08/2025


Other - See Job


Monday-Friday: 08:30-16:30


Smart Casual

Pay


£14.00


£1.69

Description

Role

We are seeking a detail-oriented and analytical Temporary Reconciliation Assistant for a 6-week assignment. You will support the Payroll Team in ensuring accurate, complete, and timely reconciliation of contributions. The role focuses on reconciling payroll and finance data using Microsoft Excel, with a strong emphasis on VLOOKUPs, pivot tables, and data validation. This is a great opportunity for someone confident in handling large datasets and identifying discrepancies across systems.

Duties and responsibilities

  • Assist in reconciling employer-submitted data against scheme records (e.g., salary, service, and contributions).
  • Collaborate with payroll and finance teams to verify and match records
  • Use VLOOKUPs, pivot tables, and other advanced Excel functions to identify and resolve discrepancies
  • Escalate unresolved or complex issues to the Team Leader.
  • Maintain accurate audit trails and documentation for all reconciliations and adjustments.
  • Ensure compliance with TPS rules, GDPR, and relevant financial and audit standards.

Skills and experience

  • Experience in financial reconciliation, data processing, or pension administration.
  • Strong numerical accuracy and attention to detail.
  • Proficient in Microsoft Excel and data management tools.
  • Ability to analyse and interpret complex data.
  • Strong communication skills – written and verbal.
  • Able to prioritise tasks and work to deadlines under pressure.
  • Team player with a proactive approach to problem-solving.

Desirable Skills & Experience

  • Strong skills in Microsoft Excel, especially VLOOKUP, pivot tables, and formulas
  • Familiarity with pension payroll systems or contribution monitoring tools.
  • Experience working with large datasets and multiple employer records.
  • Familiarity with payroll or finance systems (e.g., Sage, Xero, ADP) is a plus
  • High attention to detail and ability to spot data inconsistencies
  • Comfortable working with large datasets under tight deadlines

Location
Coventry

Additional information

  • May be required to work extended hours during peak periods (e.g., end-of-year reconciliation).
  • Training will be provided on TPS-specific systems and procedures.
  • Due to the nature of the role an Enhanced DBS will required which will include 2 employment references.

Apply for job