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
Using strong analytical capabilities and attention to detail, the Senior Financial Analyst – Investments & Treasury actively manages and reports on the City’s large investment portfolio and ensures the City’s investment returns are maximized, investment risk is minimized, and cash is available when required to meet the City’s financial obligations. The position supports the financial sustainability of the City through developing, implementing, and maintaining cash-flow modelling for both the short and long-term horizons, as well as debt and reserve funds and strategic review of the capital budget. Reporting to the Manager of Accounting and Financial Reporting within the Financial Services Division of the Corporate Services Department, you will be responsible for the following duties:
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.
Your compensation
This position is within Grade 5 of the non-union Salary Schedule and has an annual salary range of $91,036 – $111,020. 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).
Posting closing date
To apply, please visit www.cambridge.ca/careers. This posting closes on May 22, 2024.
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 HRServices@Cambridge.ca to make your needs known in advance.
For more information on our Employment Equity, please read our full policy.
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.
