Treasury Operation Analyst
Job Summary
Note: Applications will be accepted until 11:59 PM on the Posting End Date.
Job End Date
OngoingThis position is subject to the satisfactory completion of required background checks.
At UBC we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research innovation and learning for all faculty staff and students. Our commitment to employment equity helps achieve inclusion and fairness brings rich diversity to UBC as a workplace and creates the necessary conditions for a rewarding career.
Job Summary
This position supports the Senior Financial Specialist and the Treasury Accounting Manager across a broad range of treasury operations including complex bank reconciliations cheque and fraud controls merchant services administration accounting journals and revaluations Treasury Accounts Receivable invoicing (Residential Services Levy General Municipal Services Levy Sundry Leases and Licenses) customer contract management and treasury records management. Interacts with departments across campus and with external banks payment processors the Digital Payments Program (DPP) the Integrated Service Centre (ISC) and Sundry Lease/License tenants. The position ensures timely and consistent reconciliations accurate invoicing and appropriate contract administration in order to maintain the accuracy of the universitys financial information and promptly identify errors duplication omissions or fraud in cash transactions and receivables.
Organizational Status
This position is accountable to the Senior Financial Specialist and the Treasury Accounting Manager. Works closely with the Manager Treasury Contracts & Real Estate on customer contracts GMSL billing and Internal Service Delivery entries and coordinates with the Executive Assistant on records archiving and retrieval. Interacts with departments across campus as well as external banks payment processors the Digital Payments Program (DPP) the Integrated Service Centre (ISC) and Sundry Lease/License tenants.
Work Performed
Bank Reconciliation
- Handles monthly reconciliations for assigned bank accounts dummy and/or intermediate accounts including maintaining legacy accounts until closure.
- Investigates and resolves reconciliation exceptions collaborating with internal stakeholders financial institutions and system support teams to ensure the accuracy and completeness of financial records.
- Maintains Workday reconciliation rules.
- Collects and summarizes reconciliations for departmental and imprest bank accounts.
Banking Operations & Payment Administration
- Administers cheque fraud controls (Payee Match and Positive Pay) reviewing daily exceptions and verifying with Accounts Payable and departments as needed.
- Processes returned cheques escheatment cancellations and related clearing entries coordinating with banks and departments to trace and record returns.
- Administers merchant services including user access to card portals and monthly card settlement fee allocations GST rebates and reconciliations.
- Processes cash deposits.
- Responds to departmental inquiries regarding deposits withdrawals cheque investigations and returned items.
- Supports treasury supplier invoicing and payment and arranges supplier EFT conversion.
Treasury Accounting
- Prepares and submits general accounting journals in Workday across multiple journal sources ensuring correct ledger accounts Worktags supporting documentation and approvals including but not limited to banking journals foreign currency revaluation hedge revaluation journals and other accounting journal entries required to support Treasury operations
- Records Internal Service Delivery (ISD) transactions for GMSL real estate and housing loans in coordination with the Manager Treasury Contracts & Real Estate.
Accounts Receivable Invoicing & Contract Administration
- Administers the Treasury Accounts Receivable invoicing in Workday (Residential Services Levy GMSL Sundry Leases and Licenses) including issuing invoices maintaining customer records and processing adjustments and payment trackers.
- Administers the annual GMSL billing cycle including annual Mill Rate calculation CPI-indexed unit rates unit confirmation and invoice generation and distribution.
- Interprets contract terms and BC Assessment files to issue invoices in accordance with contractual provisions and to update customer contract and billing records in Workday.
- Handles lease and license renewals and GMSL collections monitoring expiry dates coordinating renewal documentation with tenants and the Manager Treasury Contracts & Real Estate and following up on outstanding payments.
Treasury Administration
- Obtains and tracks director signatures on treasury and banking documents and maintains signing authority records.
- Orders office supplies and coordinates with other OAB tenants.
- Maintains Treasury records and filing (SharePoint shared drive and physical) including key listings custodial statements letters of credit debenture and share certificates and executed agreements coordinating with the Executive Assistant on archiving and retrieval.
Continuous Improvement
- Monitors Workday and banking/payment platforms for system issues reporting problems and working with the ISC banks and service providers toward timely resolution.
- Participates in training process improvement and ad-hoc projects.
- Maintains Standard Operating Procedures (SOPs) for assigned processes to reflect current practices.
- Supports and completes tasks as assigned by the Senior Financial Specialist and the Treasury Accounting Manager ensuring priorities and deadlines are met.
Consequence of Error/Judgement
Follows well-defined methods and procedures. Attention to detail sound judgement and knowledge of UBC policies and procedures are critical. Incorrect processing may result in inaccurate or incomplete accounting records misdirected fraud controls incorrect merchant fee allocations or errors in customer invoicing and contract administration. Failure to follow up on bank reconciliation items returned cheques or GMSL collections can result in incorrect revenue figures being reported in Workday lost revenue or strained tenant and customer relationships. Errors in contract interpretation GMSL rate calculation or records management may lead to disputes missed renewal deadlines or gaps in institutional record retention.
Supervision Received
Work is supervised by the Senior Financial Specialist and the Treasury Accounting Manager. Coordinates with the Manager Treasury Contracts & Real Estate on customer contracts and GMSL matters. Organizes and prioritizes workload independently to meet monthly close the annual GMSL billing cycle (AprilAugust) and other cyclical deadlines within established guidelines.
Supervision Given
Is not required to supervise staff; however guides the Treasury team on payment policies and procedures set by Financial Operations and may explain work procedures to new or inexperienced staff.
Minimum Qualifications
High school graduation plus Certificate in Accounting or Payroll CPA Level 1 plus four years of related experience or an equivalent combination of education and related experience.
- Willingness to respect diverse perspectives including perspectives in conflict with ones own
- Demonstrates a commitment to enhancing ones own awareness knowledge and skills related to equity diversity and inclusion
Preferred Qualifications
- Completion of a diploma or degree in Accounting Finance Business Administration or a related field.
- Experience with bank reconciliations merchant services (Moneris or equivalent) or Accounts Receivable invoicing preferred.
- Experience with contract administration lease/license management or property invoicing (e.g. GMSL Mill Rate calculation BC Assessment records) is an asset.
- Ability to interpret contract terms BC Assessment files and municipal tax-rate sources.
- Workday experience preferred; experience with other ERP or payment platforms considered.
- Proficiency in data entry with strong analytical and technical problem-solving skills.
- Detail-oriented with the ability to exercise tact and discretion.
- Effective organizational oral and written communication skills.
- Ability to multi-task set priorities manage workflow effectively and meet deadlines.
- Effective interpersonal and customer service skills; able to work independently and in a team environment.
- Ability to maintain accuracy and attention to detail.
- Computer experience required in Microsoft Office particularly intermediate-level Excel.
Required Experience:
IC