Senior Financial Analyst - Investments & Treasury

People, Place, Prosperity

Working within our Strategic Plan, Cambridge Connected, and committing to our values of Integrity, Respect, Inclusiveness and Service, the successful candidate will work together to help the City of Cambridge achieve our vision: A place for people to prosper – alive with opportunity.

Job Profile

What you will be doing

Investments

• Develops, implements, and maintains treasury related financial models, analysis, reporting and reconciliations. Conducts daily cash position analysis and prepares cash flow modelling for both the short- and long-term planning horizons. Regularly monitors cash flow needs and assess progress against reported forecasted values.
• Liaises with bank and investment dealers to execute transactions in accordance with Council approved policies and legislative requirements, while ensuring appropriate cash flow is maintained. Analyzes and recommends investment decisions to management.
• Performs ongoing research and monitoring of economic activity and market trends, product availability, and comparative benchmarking.
• Calculates and records investment-related journal entries, and allocates investment income to appropriate areas (i.e. reserve funds, trust funds, general operating fund).
• Develops, implements and performs ongoing monitoring of treasury activity including performance indicators to monitor, measure and report on quantifiable progress and outcomes.

Debt

• Maintains the comprehensive debt model that tracks historical/projected debt. Implements changes to the model to improve its effectiveness.
• Ensures appropriate recording of debt activities in the general ledger. Manages payment and debt amortization schedules.
• Monitors debt forecasting with respect to Council approved policies and legislative requirements, as well as relative to comparator municipalities. Prepares reports and/or presentations to management and Council with respect to debt forecasts and policy.
• Analyzes and provides recommendations regarding timing of debt issuance based on cash flow needs, project progress, and market and economic conditions. Liaises with the Region of Waterloo regarding debt timing and issuances.

Reserve Funds and Capital Management

• Develops, implements and maintains the comprehensive reserve and reserve fund model that tracks historical and projected reserve/reserve fund transactions. Ensures projected reserve/reserve fund levels meet legislative requirements and are within Council approved policies, and recommends appropriate funding plans for operational initiatives and capital projects.
• Strategically reviews the consolidated ten-year capital budget and ongoing capital forecast to ensure investments are maturing as required to meet cashflow requirements. Ensures compliance with various financial policies, the reserve and reserve fund by-law, and municipal finance best practices. Reviews and provides feedback to other members of Finance team regarding capital budgeting and capital forecasting.

Other

• Coordinates and leads the Community Grants Program. Coordinates with community groups, reviews submissions to ensure compliance with the Community Grants Program Policy, consolidates reporting packages, and provides presentations and insights to the Community Grants Committee of Council.
• Prepares reports and/or presentations to management and Council on investments and cash management, debt, reserve funds, capital, and Community Grants.
• Assists with applying, tracking, and reporting of grant opportunities from other levels of government and outside agencies. Reviews grant application and reporting submissions prepared by staff from other departments, ensuring accuracy of financial information.
• Prepares what-if scenarios related to potential funding options for projects and as part of business case analysis, including analyzing potential impacts on reserve/reserve fund projections and debt models.
• Investigates best practices, conducts research and makes recommendations regarding policies and processes.
• Supports the year-end financial reporting process and audit, preparing audit confirmations for bank, investments, and long-term debt, reconciling and investigating any identified differences with City accounts.
• Assists in the ongoing implementation, training, and support of financial applications. Recommends software solutions to enhance reporting capabilities for relevant processes and reporting.
• Participating member of management team involved in union contract negotiations responsible for financial implications of the collective agreement.
• Performs special projects as required.
• Other duties as assigned.

Education

Undergraduate Level - Four years or equivalent in Business Administration.

Experience and Knowledge

• Canadian Chartered Professional Accounting (CPA) designation.
• Minimum 3-4 years of related experience in municipal investments, debt, reserves, capital financial management considered an asset.
• Advanced Excel, analytical, and data modelling skills.

We will ask you for these items if you are hired

Proof of your current and valid certificate(s) and/or educational qualifications.

Worker Health and Safety Awareness Training certificate from the Ministry of Labour. (may be obtained post offer)

Your compensation

This position is within Grade 5 of the non-union Salary Schedule and has an annual salary range of $97,048 - $118,348. We offer a comprehensive benefit package and are an Ontario Municipal Employees Retirement System (OMERS) employer.

Location of position

This position is located at Cambridge City Hall, 50 Dickson Street, Cambridge.

Hours of work

Monday to Friday, 8:30 a.m. to 4:30 p.m. (35 hours per week).

Advertisement expiration date

Interested candidates should apply at This posting will close on July 11.

Accommodation needs and protection of privacy

The City of Cambridge recognizes and appreciates diversity and inclusion enhances our public value commitment.

We strive to create an accessible and inclusive experience and encourage all qualified people to apply, including and especially people from equity-deserving groups. Qualified applicants will receive consideration for employment with honour and respect toward their individual dimensions of diversity.

We strive to remove barriers that may prevent qualified applicants from fully participating in the recruitment and selection process. Accommodation in accordance with the Ontario Human Rights Code and other applicable legislation is available throughout all stages of the recruitment and selection process. Contact View email address on ca.workus.org to make your needs known in advance.

Personal information collected in relation to the recruitment process is collected under the authority outlined in the Municipal Freedom of Information and Protection of Privacy Act and used solely to determine eligibility for employment with the City of Cambridge only.