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.

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

• 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.