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.