Financial Analyst - Budgets; Temporary Approx

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.

Reporting to the Supervisor of Financial Planning but taking direction from the entire Financial Planning team, the Financial Analyst – Budgets provides analytical support to the Financial Planning team with the timely development of multi-year operating budget, business plans and forecasts. Prepares financial analysis and reconciliations. Assists in the writing and compilation of the City’s budget and reports. Maintains salary plan, prepares journal entries, and supports the maintenance and development of financial and budget systems.

• Provides analytical support to the Financial Planning function by assisting Senior Financial Analysts, Supervisor and management with the timely development of multi-year operating budget, business plans and forecasts.
• Prepares financial analysis, variance and trend analysis, economic analysis, account reconciliations and ad-hoc research to support budget preparation and forecasting. Identifies opportunities and risks in financial forecasts.
• Runs reports from the budget system, compiles divisional and departmental budget summary documents for management throughout the City. Assists in the writing and compilation of the City’s budget document and reports.
• Maintains the salary plan throughout the year, reflecting and tracking ad hoc position changes. Prepares salary variance analysis to support forecasting.
• Prepares journal entries for various transfers and adjustments as needed.
• Maintains the financial plan (budget/forecast) in the financial system through periodic imports from the budget software. Reconciles actuals in the budget system against the financial source system.
• Coordinate with divisions to review, update and maintain municipal user fee schedules.
• Maintains account structure and hierarchies in financial reporting systems.
• Ensures compliance with policies and Generally Accepted Accounting Principles (GAAP).
• Assists in the ongoing implementation, training, and support of financial applications. Recommends software solutions to enhance reporting capabilities for the budget and forecasting processes and reporting.
• Other budget and accounting duties as assigned.

• University Degree in Business, Finance, Accounting, Economics or suitable equivalent.
• Working towards accounting designation (CPA) preferred.

• Two (2) years Accounting at an intermediate level and experience using financial and computer applications.
• Two (2) years Advanced experience using Excel.

Experience with SAP and FMW systems is considered an asset.

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

Valid G driver's license.

Worker Health and Safety Awareness Training Certificate from the Ministry of Labour

This position is located in Band Level 3 of the Non-Union Salary Scale and has an hourly range of $42.00 - $51.24. We offer a comprehensive benefit package and are an Ontario Municipal Employees Retirement System (OMERS) employer.

The current regular hours of work are 8:30 a.m. to 4:30 pm. (35 hours per week), Monday to Friday, with occasional evenings as required.

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

The City of Cambridge recognizes and appreciates…