Payroll Reconciliation Analyst - UBC, Vancouver

AI Summary

This Payroll Reconciliation Analyst position at UBC in Vancouver, BC, involves managing complex payroll ledger and program reconciliation, investigating accounting flow within Workday, and ensuring compliance with financial regulations. Key duties include processing payroll accounting journals and performing monthly bank reconciliation tasks. Top requirements include an undergraduate degree, enrollment in the CPA Professional Education Program, and a minimum of three years of related experience with strong accounting and Workday system knowledge.

About the Opportunity at UBC

The University of British Columbia, a leading Canadian institution and a major employer in British Columbia, processes approximately $2 billion in payroll annually for its 50,000 faculty and staff. This significant financial operation necessitates a meticulous Payroll Reconciliation Analyst to maintain accuracy and compliance across all payroll functions. The incumbent will play a crucial role within the Payroll Services & Analytics department, contributing to the financial integrity of the university's extensive payroll operations. This analyst position is integral to ensuring that all payroll accounting and reconciliation processes are robust, efficient, and adhere to both internal policies and external legislative requirements, including those from the CRA, WCB, and EI. The role demands a high level of awareness of overall payroll operations and a proactive approach to identifying and implementing process improvements.

Key Responsibilities and Workday Expertise

As a Payroll Reconciliation Analyst, you will be responsible for a wide array of critical tasks, focusing on detailed payroll ledger and program reconciliations across the university. A significant part of this role involves investigating accounting flow within Workday, implementing corrective controls, and ensuring the accurate posting of transactions. You will prepare complex Payroll Accounting Journals (PAJs) and mass journal entries, developing and maintaining robust reconciliation controls and financial process documentation. This includes performing in-depth analysis of large data sets for periodic BCEHT, WCB, and Union Dues using Workday reports. The position also entails completing monthly bank reconciliation for payroll bank accounts, addressing uncashed payments, and resolving discrepancies. Furthermore, the analyst will assist Payroll Specialists in correcting pay errors, manage garnishment requests, and prepare various tax remittances, all while leveraging Workday for efficient payroll operations. Your expertise will be vital in monitoring and improving these payroll reconciliation tasks to enhance efficiency and accuracy.

Qualifications and Skills for Success

To excel as a Payroll Reconciliation Analyst at UBC, candidates must possess an undergraduate degree in a relevant discipline and be actively enrolled in the CPA Professional Education Program (PEP) modules. A minimum of three years of related experience, or an equivalent combination of education and experience, is essential. Preferred qualifications include a Payroll Compliance Practitioner (PCP) designation and demonstrated experience with Workday or similar ERP systems, showcasing an ability to adapt to new technologies. Strong knowledge of payroll, accounting, and financial processes, coupled with advanced Excel skills (pivot tables, lookups, complex formulas), is crucial for managing the complex data sets and reconciliation tasks. The successful candidate will exhibit strong analytical and problem-solving abilities, meticulous attention to detail, and sound professional judgment. Excellent communication and interpersonal skills are also required to effectively liaise with technical teams and end-users, providing clear guidance on intricate payroll and accounting issues. This role demands a proactive individual committed to continuous improvement in payroll operations and compliance.