Payroll Data Analyst

IFRS Foundation; Camden Town; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading finance organization in Camden Town is seeking a Data Analyst to support their payroll team. The role involves managing and improving payroll data quality, performing reconciliations, and preparing for compliance requirements. The ideal candidate will have proven experience in data analysis, strong Excel skills, and the ability to work collaboratively across departments. This opportunity is essential for accurate payroll reporting and process optimization.

Qualifications

• Proven experience in data analysis within payroll or finance.
• Strong proficiency in Microsoft Excel, including advanced functions.
• Experience working with large datasets and performing data cleansing.

Responsibilities

• Clean, structure, and validate large payroll data.
• Identify and correct anomalies in payroll and accounting data.
• Collaborate with Payroll, HR and Finance teams.

Skills

Data analysis

Strong Excel skills

Analytical mindset

Attention to detail

Collaborative work

Tools

HiBob

Microsoft Excel

Job description

Finance team: The role is to support the payroll team in managing and improving data quality, reconciliation and reporting during a period of high operational demand. The role is essential for ensuring accurate payroll reporting, supporting the rollout of a Global Payroll Provider and preparing for upcoming compliance requirements.

Responsibilities

• Clean, structure, and validate large payroll data to ensure accuracy and consistency (both for current operations and during the roll out of the Global Payroll provider).
• Identify and correct anomalies in payroll and accounting data.
• Collaborate with Payroll, HR and Finance teams to ensure data alignment, particularly within the HiBob platform.
• Reconciliations: Perform regular reconciliations between payroll records and general ledger accounts.
• Investigate and resolve discrepancies in payroll transactions and accounting entries.
• Budget & Variance Analysis, Reporting: Assist in preparing payroll-related budget forecasts; analyse actual payroll costs against budgeted figures and explain variances; provide monthly variance reports with actionable insights; maintain year-to-date payroll reports and audit packs; support audits and compliance checks; respond to ad hoc data requests from senior management and external auditors; assist in preparing data and reports for the mandatory payrolling of Benefits in Kind (BiKs) starting April 2026.
• Process optimisation: Identify inefficiencies in workflows and streamline payroll processes.
• UAT Testing – Global Payroll Project: Lead testing and reconciliation during parallel runs for the Global Payroll Provider rollout.

Qualifications

• Proven experience in data analysis within payroll or finance.
• Strong Excel and data manipulation skills; experience with HiBob is a plus.
• Familiarity with payroll systems, accounting principles, and compliance requirements.
• Analytical mindset with attention to detail.
• Ability to work collaboratively across departments.
• Experience supporting audits and compliance processes is desirable.
• Strong proficiency in Microsoft Excel, including advanced functions (pivot tables, lookups, data validation).
• Experience working with large datasets and performing data cleansing, transformation and validation.
• Solid understanding of payroll processes, accounting principles, and financial reconciliations.
• Familiarity with HRIS and payroll systems (e.g. HiBob, Moorepay, Papaya, Justworks or similar platforms).
• Demonstrated ability to produce clear, accurate and insightful reports for stakeholders.
• Experience supporting audits and compliance reporting.
• Strong analytical and problem‑solving skills with high attention to detail.
• Excellent communication and interpersonal skills, with the ability to collaborate across departments.
• Ability to manage multiple priorities and meet deadlines in a fast‑paced environment.

Preferred Qualifications

• Experience working within a global or multi‑country payroll environment.
• Experience participating in system implementations or UAT testing phases.
• Ability to document processes and create user‑friendly guides.

Please note that while we have a closing date for this application, we reserve the right to interview candidates and potentially close the role early should we find a suitable candidate before the closing date.