Payroll Reconciliation Analyst

University of British Columbia•Vancouver, BC

2d•CA$6,950 - CA$9,993•Onsite

About The Position

The University of British Columbia (UBC) is seeking a Payroll Reconciliation Analyst to join their Payroll Services & Analytics department. This role is crucial for managing large, complex datasets and ensuring the accuracy and compliance of payroll operations, which account for approximately $2B annually. The incumbent will coordinate with the Payroll Operations team and the Payroll Lead on payroll run items, and collaborate with the Manager, Payroll Services and Analytics on reconciliation improvements and targets. The position requires a strong understanding of overall payroll operations, change management capabilities, and the ability to investigate and correct payroll accounting flows and processes. Key responsibilities include processing payroll reconciliation tasks, assisting in correcting pay errors, monitoring and improving reconciliation efficiency and accuracy, ensuring compliance with relevant legislation, and managing a high-volume workload with competing priorities.

Requirements

Undergraduate degree in a relevant discipline.
Enrolled in the CPA Professional Education Program (PEP) modules.
Minimum of three years of related experience, or the equivalent combination of education and experience.
Willingness to respect diverse perspectives, including perspectives in conflict with one’s own.
Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion.

Nice To Haves

Payroll Compliance Practitioner (PCP) designation.
Experience with Workday or similar ERP systems, with the ability to learn and adapt to new technologies.
Strong knowledge of payroll, accounting, and financial processes, including the ability to apply accounting principles to complex transactions and reconciliation issues.
Advanced Excel skills (e.g., pivot tables, lookups, and complex formulas) and proficiency in Microsoft Office tools.
A positive, solution-focused approach that supports accurate and efficient payroll operations, responsive customer service, and strong collaboration across teams.
Demonstrated ability to manage a high-volume workload with multiple competing priorities, balancing operational responsibilities with process improvements and analysis.
Strong analytical and problem-solving skills, with a high degree of attention to detail, accuracy, and sound professional judgment.
Excellent communication and interpersonal skills, with the ability to liaise effectively between technical teams and end users, and provide clear, professional guidance on complex issues.
Demonstrated ability to work independently and collaboratively in a complex, fast-paced environment.
Experience supporting process improvements, documentation, and change initiatives.
Strong commitment to confidentiality, privacy, and compliance with legislative and regulatory requirements.

Responsibilities

Manages detailed payroll ledger and program reconciliations across the university.
Investigates accounting flow within Workday and implements corrective controls.
Ensures compliance with CRA, WCB, and EI regulations and supports audit readiness.
Prepares complex Payroll Accounting Journals (PAJs) and EIB mass journal entries.
Develops and maintains reconciliation controls and financial process documentation.
Performs analysis and complex reconciliation tasks such as periodic BCEHT, WCB, and Union Dues including large data sets over multiple years, using Workday reports.
Reviews work done by teammates for accuracy, materiality, relevance, and completeness.
Reconciles and reviews all payroll Ledger Accounts and Programs in accordance with accounting principles, and implements controls to prevent or identify mis-applied amounts.
Investigates accounting flow in accordance with accounting principles for all payroll processes and coordinates with Manager, Payroll Services and Analytics and the ISC to correct any incorrectly posting processes.
Researches and advises payroll staff concerning the accounting treatment of complex transactions in accordance with accounting principles, documenting accounting flow.
Identifies areas for improved efficiency in Payroll Reconciliation Analyst tasks, and assists, along with Payroll Lead, to implement and manage change to improve processes and analysis methods.
Ensures compliance with union agreements, University policies, and Federal and Provincial legislation and regulations, such as for tax remittance deadlines.
Performs ad-hoc data analysis for data from Workday, such as investigation of year-over-year discrepancies, and internal and external audit information requests in accordance with accounting principles.
Prioritizes any improvements and changes along with justification.
Monitors and improves controls for Payroll Reconciliation Analyst tasks.
Develops and maintains process and training documentation for Payroll Reconciliation Analyst tasks and relevant use of Workday.
Creates and posts Payroll Accounting Journals (PAJs) and PAJ EIBs (mass loads), ensuring correct transactions are posted in accordance with accounting principles for transfers of amounts between ledger accounts and worktags for correction and reconciliation activities.
Ensures Payroll Reconciliation Analyst coverage for on-cycle and off-cycle payroll runs and other ongoing cyclical tasks.
Assists with ad-hoc projects for improvements to payroll operations procedures, documentation, and reporting, such as improving ServiceNow Ticket Dashboards.
Assists the payroll Business Analyst with the testing phase of Workday report improvement and development for Payroll Operations owned reports.
Identifies and recommends to the payroll Business Analyst potential improvements to Workday reports.
Documents issues with Workday in Service Now tickets and coordinates with Payroll Lead to prioritize and assign tickets to relevant area such as ISC – Payroll.
Assists, along with Payroll Lead, in defining roles and responsibilities of Payroll Reconciliation Analysts for items and issues that have cross coverage with Payroll Support Specialists or other areas of Payroll Operations.
Completes monthly bank reconciliation for payroll bank accounts, addresses payroll payments via cheque that have not been cashed, and creates of Ad Hoc Bank Transactions to record repayment of payroll overpayments.
Monitors and improves controls for bank reconciliation and related tasks.
Investigates any discrepancies in bank reconciliation.
Assists with reconciliation of re-submitted bank files due to potential bank file integration errors.
Sets up garnishment requests in WD; ensure the deductions go through during on cycle; create AP request to pay CRA/Prov of BC/Court; answer CRA inquires and respond to employee's questions; mail out the checks with remittance vouchers; filing.
Reviews in-progress ROEs and submit ROEs to Service Canada.
Prepares weekly, semi-monthly, monthly and quarterly tax remittances.
Uploads EIBs prior to on-cycle pay run such as for loading hours for units that do not have access to Workday.
Troubleshoots submission errors and corrects EIB data to load properly.
Create Accounts Payable requests such as to pay union dues to each union.
Resolves ServiceNow tickets that have been assigned to Payroll Reconciliation Analysts.
Other projects as required.