Payroll Reconciliation Analyst

The Payroll Reconciliation Analyst provides strong customer service and payroll and benefits expertise to the campus community on behalf of Financial Operations. This role contributes to the reliability and availability of UBC's payroll and benefits system by providing Tier 3 support, problem resolution, and ensuring services meet or exceed customer service levels at all times.

The Payroll Reconciliation Analyst will troubleshoot complex payroll and benefits systems issues, lead the pay processing function in Workday, provide recommendations on how capabilities of the University's financial systems can be used and optimized to improve business processes, and solve business problems to support the short-and-long-term direction of financial operations. The incumbent will also manage the reconciliation of Payroll and Benefits activities and ensure that the University is in compliance with Canada Revenue Agency (CRA) and other governing agencies.

Organizational Status

The Payroll Reconciliation Analyst reports to the Manager, Payroll Operations and Control. Interacts directly with the Integrated Service Centre (ISC), Financial Operations stakeholders, other UBC client units.

Work Performed

- Maintain payroll-related accounts and is responsible for the reconciliation and accuracy of ledger accounts and ensure timely identification and resolution of issues, within a complex accounting system. - Prepare various accounting papers, schedules, exhibits summaries, and accounting corrections

- Perform all payroll related activities such as reconciliation of CRA statement of accounts for current source deductions and including prepare materials for external or internal auditors.

- Research and advise payroll staff concerning the accounting treatment of complex transactions. - Recover of Payroll and Benefit operational service fees for our paymaster agreements.

- Ensure account activity is appropriate, closing balances are accurate and reconciliations provide meaningful information to Payroll Manager.

- Works with the Payroll Manager for year-end reporting such as annual payroll tax and payment summary reconciliations, and EI rebate reconciliation.

- Continuously review and update reconciliation procedures, year-end procedures and year-end processes.

-Monitors out of province benefits (WCB), age related benefit reports, housing loan taxable benefits, and parking (EIB load files, interface files and month end reports).

-Daily analysis of payroll and benefit related reports to perform quality assurance checks to ensure Workday employee data is accurate and complete.

- Responsible for ensuring WCB (Workers Compensation Board) advances and payments received are processed in Workday and recorded on a timely basis, reporting of WCA(Workers Compensation Award cheques),

-Advise on systems management issues specific to the payroll and benefits module of Workday

- Provides Tier 3 operational expertise for the payroll and benefits module, policies and process inquiries, including troubleshooting system, resolving issues, defining complex financial operational processes, and providing end user support.

-Monitors workflow logs, performs pro-active checking of the key workflow routing data, analyzes each failed workflow, and escalates technical issues that are causing workflow processes to fail.

- Identifies, analyzes, troubleshoots, and diagnoses root causes and applies appropriate solutions to restore issues.

-Troubleshoots system issues and simulates/recreates user problems to resolve operating difficulties. - Analyzes incidents and initiates system improvements and modifications, and process improvements, to reduce user problems and improve data integrity

-Develops and maintains business and functional documentation, including operations and support procedures relating to various financial systems for internal and external consumption, including central IT support. .

- Develops, analyzes and defines business cases and project schedules for system upgrades and other improvement initiatives working with the Integrated Service Center (ISC)

Consequence of Error/Judgement

Failure to detect and correct errors could result in serious consequences such as a breach of a collective agreement, financial penalties from Canada Customs and Revenue Agency, fines pursuant to the Employment Insurance commission Act and Employment Standards Act, law suits from employees and fines and penalties. Errors could result in poor financial decisions and misallocation of resources. As this position advises the University campus faculties and departments, errors could have a significant impact throughout the University. The accountability of this position requires the incumbent to deal effectively with the appropriate personnel, both professional and nonprofessional, at all such levels of involvement and responsibility, both within and outside the University.

Supervision Received

The Payroll Reconciliation Analyst works independently under broad directives from the Manager, Payroll Operations and Control. Works in collaboration with the Financial Operations Customer Support Centre (CSC) while expected to demonstrate a fair degree of autonomy, critical thinking and judgement. Work is reviewed in terms of service provided to the Financial Operations team and other UBC client units, soundness of judgment, adherence to deadlines, achievement of objectives, and overall effectiveness of analytical and problem-solving skills demonstrated.

Supervision Given

Acts as a mentor or coach to peers as required. Provides functional advice and technical direction to Financial Operations and distributed users regarding payroll and benefits functions and workflow. Serves as a point of contact for project and team members.

Minimum Qualifications

Undergraduate degree in a relevant discipline. Completion of at least 7 of the 14 CPA academic prerequisites. Minimum of two 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

Preferred Qualifications

Completion of the Payroll Compliance Practitioner PCP and/or Certified Payroll Manager CPM designation.

Experience with Workday is an asset.

Applies privacy and information security practices specifically on the handling of personal information documenting, transferring, securing and the requirements for transferring and for setting confidential tickets.

Follows service management best practices and procedures to link between incidents, problems to incidents, incidents to change, and incidents to knowledge sources

Ability to communicate effectively both verbally and in writing.

Able to liaise between technical staff and end users effectively.

Able to communicate solutions and recommendations through collaboration with impacted stakeholders in a professional and diplomatic fashion while maintaining constant awareness of sensitive issues.

Advanced level computer experience required including Excel, Access, PowerPoint, and Word. Demonstrated ability to prioritize and manage multiple issues simultaneously. Basic project management skills desirable.

Demonstrated interpersonal, organization and problem-solving skills.

Proven ability to adapt and to work effectively in a dynamic and rapidly evolving environment under pressure with high volume and critical deadlines.

Ability to take initiative, to work both independently and within a team environment.