Financial Analyst - Budgets (Temporary Approx. 16 months)

City of Cambridge; Cambridge; On-site; CAD 58,000 - 71,000; Full time

Job summary

City of Cambridge is seeking a Financial Analyst - Budgets (temporary, approx. 16 months) to support multi-year budgets and forecasts from the Financial Planning team.

You will analyze financial data, prepare budget documents, and maintain salary plans in a dynamic municipal environment. Responsibilities include variance analysis, reporting, journal entries, and collaboration with divisions to keep fee schedules accurate while ensuring GAAP compliance.

Qualifications

• Two years of accounting at an intermediate level with experience using financial software.
• Two years of advanced Excel experience for budgeting and forecasting.
• Experience with SAP and FMW systems is considered an asset.

Responsibilities

• Provide analytical support for multi-year operating budgets, business plans and forecasts.
• Prepare financial analysis, variance and trend analyses to support budgeting.
• Run budget system reports and prepare departmental budget summaries for management.
• Maintain salary plans and prepare salary variance analyses for forecasting.
• Prepare journal entries and support budget and financial system reconciliations.
• Coordinate with divisions to review and maintain municipal fee schedules and ensure GAAP compliance.
• Assist in implementing and supporting financial applications and enhance reporting capabilities.

Skills

Advanced Excel

Financial analysis

Budgeting

Education

Bachelor-level degree in Business/Finance/Accounting/Economics

CPA designation in progress (preferred)

Tools

SAP

FMW

Job description

Career Opportunities: Financial Analyst - Budgets (Temporary Approx. 16 months) (5042)

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

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.

What you will be doing

• 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.

Education

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

Experience and Knowledge

• 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.

We will ask you for these items if you are hired

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

Your compensation

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.

Hours of work

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.

Location of position

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

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 [e-mail] 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.