Treasury Analyst

**Date**:May 3, 2023

**Location**: Waterloo, CA

**Company**:Wilfrid Laurier University

**Department**: Finance

**Job Type**: Continuing

**Full-time/Part-time**: Full Time (>=1249 hrs/year)

**Campus**: Waterloo

**Reports to**:Director, Treasury

**Employee Group**: WLUSA

**Application Deadline**:May 10, 2023

**Requisition ID**:5582

Wilfrid Laurier University is a leading multi-campus university that excels at educating with purpose. Through its exceptional employees, students, researchers, leaders, and educators, Laurier has built a reputation as a world-class institution known for its rich student experience, academic excellence, and global impact. With a commitment to Indigenization and commitment to equity, diversity, inclusion, Laurier’s thriving community has a place for everyone.

Laurier has more than 19,000 students and 2,100 faculty and staff across campuses in Waterloo and Brantford, as well locations in Kitchener and Milton. The university is committed to providing an inclusive workplace, a flexible work policy and employing a workforce that is reflective of local and national demographics. Our locations are situated on the traditional territories of the Neutral, Anishnawbe, and Haudenosaunee peoples. We recognize the unique heritages of Indigenous peoples and support their intentions to preserve and express their distinctive Indigenous cultures, histories, and knowledge through academic programming and co-curricular activities. Laurier’s Centre for Indigegogy is one example of how Laurier honours Indigenous knowledge.

**Position Summary**

This position is responsible for the accounting and reporting of the university investments, pension, endowments and debt. Reporting to the Manager, Treasury and Cash Management, this position will also develop cash flow forecasts and help make short-term investment decisions. This position will support the administration of various university treasury functions and will be a key contributor to finance projects and process improvements of the Financial Resources Department.

**Accountabilities**
- **Accounting**
- Prepares the annual pension plan financial statements and pension HST return.
- Tracks capital asset debt allocations and updates debt schedules as principal payments are made.
- Updates the ledger for changes in the market value of endowments and other investments, allocating earnings to appropriate accounts. Monitors investment fees and calculates inflation.
- Assists with year-end audit, including the preparation of lead sheets, reconciliations of various accounts and financial statements. Interacts with external auditors to answer their specific questions.
- Prepares journal entries for the internal loan program, charging for principle and interest and updating amortizing loan balances.
- **Forecasting & Reporting**
- Forecasts university cash levels, considering historical operating trends and the timing of capital project transactions. Determines excess cash available for short-term investments.
- Calculates investment returns and amounts due to/from investment and cash accounts. Makes recommendations on account transfers.
- Estimates the pension plan cash balance based on member contributions and benefit payments. Advises on the timing of additional investments.
- Forecasts the annual capacity of the internal loan program.
- Creates credit card transaction activity reports and assists with PCI compliance reporting.
- Prepares the CAUBO Investment Survey and analyzes results. Works with external investment consultant.
- **Administration**
- Tracks and coordinates investment subscriptions and redemptions including preparing letters of direction to external banks and investment managers.
- Coordinates new internal loan requests, completing loan schedules for borrowing departments. Maintains catalog of all internal loan forms.
- Prepares relevant material and analysis for the Investment Oversight Committee and Finance & Investment Committee.
- **Other**
- Assists with Financial Resources projects, process improvements, and policy development.
- Serves as a backup for other Treasury staff.
- Prepares special analysis & reporting as required.
- Helps implement new treasury solutions.

**Qualifications**
- CPA Designation required
- Minimum 3 years of experience in a similar role
- Knowledge and experience in financial modelling and data analysis
- Advanced spreadsheet skills (Excel), and knowledge of other MS office products (Word, Powerpoint, Access) and ERP systems
- Knowledge of Millennium, Banner, Cognos, are an asset
- Self-motivated, goal-orientated individual who is capable of working in a dynamic and challenging work environment;
- Excellent communication (verbal and written), problem solving, time management, and interpersonal skills with a focus on providing exceptional customer service in a team environment.

This position** **has** been deemed eligible for educational equivalencies. Please refer to the attached link for det