Treasury Officer-C1472

Summary of Duties:

Reporting to the Manager, Treasury, the Treasury Officer monitors, analyzes and prepares accounting and financial reporting on cashflow, portfolio investments and debt. This position develops, analyzes and monitors the corporate budget related to Treasury. The Treasury Officer monitors, assesses and reports on portfolio investments, debt, economic data and cashflows. This position completes various tasks and contributes to various treasury related transactions, analysis, research, projects and initiatives.

Work Performed:

• Completes general ledger activities, reconciliations and variance analysis relating to the Treasury portfolio; reviews and approves accounting entries, account reconciliations and variance analysis prepared by the Budget Analyst.
• Completes month-end, quarter-end and year-end close processes and reconciliations, investigates reconciliation discrepancies, and prepares relevant portions of the financial information return, financial statements, notes disclosures and consolidation of ministerial and statutory reporting related to the Treasury portfolio.
• Prepares audit working papers and supports audit related to the Treasury portfolio; liaises with external auditors as required.
• Performs initial analysis on new accounting standards relating to the Treasury portfolio; monitors and ensures compliance with relevant accounting standards.
• Develops, monitors and updates budget models, schedules and analysis relating to the Treasury portfolio; liaises with relevant internal teams to obtain information required for keeping the models up to date.
• Completes initial information gathering on financial markets, screening and analysis in evaluating capital markets and impacts to the City's investment and debt management activities.
• Develops and completes schedules and analysis supporting the administration of investments, debt and cashflows supporting Treasury operations and compliance.
• Records and monitors treasury transactions from trading, matching and settlement activity, reporting issues as they arise with recommendations for resolutions.
• Provides and completes data gathering and calculations to contribute to the process of setting various rates, such as but not limited to discount rates, local improvement rates, investment returns, economic indicators and borrowing rates.
• Completes and reviews various internal reporting schedules, models and forecasts in respect to portfolio investments, debentures and cashflows.
• Maintains and completes work within established internal controls, highlighting any improvements as identified. Performs initial documentation and updates to relevant process documentation.
• Utilizes applications used by the Treasury portfolio; assists in the implementation and updates of Treasury applications, identifies process improvements and ensures vendor invoices are processed; inputs relevant activity and data.
• Gathers and aggregates applicable information and materials in support of the City's credit rating review process.
• Reviews and provides feedback on relevant analysis and work completed by the Budget Analyst.
• Assists in other Financial Planning and Policy functions relating to the budget development process and annual audit.
• Liaises with other members of Financial Planning and Policy and Financial Services regarding Treasury issues given overarching corporate considerations of Treasury impacts from operations.
• Performs other related duties as required.

Qualifications:

• Honours bachelor's degree that incorporates all CPA PREP module requirements or bachelor's degree in Accounting, Finance, or Business Administration and completion of all CPA PREP modules.

Experience:

• Four years of related accounting experience, of which two years must be treasury work that includes investment portfolio analysis, cashflow and working capital analysis, debt analysis and related transactional activities.

Specialized Training & Licenses:

Skills and abilities in the following areas are necessary:

• Demonstrated analytical and quantitative skills, with the ability to perform financial statement analysis, prepare financial reports and interpret complex financial data.
• Ability to consolidate financial statement preparation and account reconciliations.
• Ability to prepare audit working papers and work with external auditors.
• Ability to perform financial analysis, reporting and understanding of full cycle treasury, budgeting, accounting and reporting processes and practices utilizing various costing and fair value techniques.
• Ability to understand financial markets, investments and portfolio management principles.
• Clear communication skills to engage with various internal parties, providing guidance and feedback on deliverables, or working with external auditors and treasury system vendors.
• Proficiency in Microsoft Excel, financial modelling and Enterprise Resource Planning systems.
• Ability to consider and evaluate changing market conditions, internal operations, accounting and budget implications of treasury operational activity.
• Ability to multitask and meet tight deadlines to complete required deliverables as dictated by market conditions, policies and regulations.

Compensation & Other Information:

$62,220 - $90,408 (Level 14)
This posting is for (2) two permanent full-time position being filled on a permanent basis.
Current hours of Work: Monday - Friday from 8:30 a.m. to 4:30 p.m.
Work Arrangement: Hybrid. Subject to change in accordance with business requirements.
These hours of work are subject to change in accordance with the Collective Agreement and may include evening hours and Saturdays.
NOTE: Applicants may be required to complete a job related test.

Police Record Check:

The successful candidate will be required to complete a Criminal Record Check.