Financial Planning and Analysis - Financial Analyst

at  Municipality of Lakeshore

Position: Financial Analyst
Salary: CUPE Pay Band 8
Union: CUPE
Reports to: Division Leader - Financial Planning & Analysis
This posting closes on August 14, 2024.

QUALIFICATIONS & EXPERIENCE:

• 3 year University degree or College diploma in Business Administration (Accounting) Diploma, or equivalent
• Must have a Professional Accounting designation (CPA) and be a member in good standing.
• 3 years of related experience required including accounting and general office administration as well as preparing, processing and presenting statistical information (including graphs); preference given to municipal experience.
• Valid Ontario Class “G” drivers’ license
• Must have experience demonstrating effective written and verbal communication skills.
• Must have a clear police clearance

KNOWLEDGE & SKILLS:

• Must possess advanced accounting skills with attention to detail.
• Must have experience in demonstrating organizational, analytical, planning, research and problem-solving abilities with effective interpersonal skills.
• Computer literacy at an advanced skill level utilizing financial, database and MS Office software including word processing, spreadsheet, database, and presentation applications.
• Must have demonstrated mathematical and analytical skills.
• A demonstrated self-starter with strong analytical skills combined with superior organizational skills.
• A general understanding of municipal administration is an asset to the position.

PURPOSE OF POSITION:

Reporting to the Division Leader- Financial Planning & Analysis, this position assists with providing financial analysis, monthly reconciliations and allocations, and preparation of year-end working documents as well as providing analytical support to the Accounting & Revenue Division.

MAJOR RESPONSIBILITIES:

• Maintain capital accounting and reporting system, updated tangible capital asset database for all municipal departments, ensuring compliance with approved policies and procedures including PSAB requirements.
• Monitor capital project budgets, include grant and partnership contributions, prepare capital variance review, and follow up with the project managers.
• Provide financial analysis support including preparation of variance analysis and statistical data reports.
• Preparation and analysis of financial reports for forecasting and trending
• Updating and maintaining financial spreadsheets
• Generation of ad hoc reports as requested.
• Responding to departmental inquiries
• Assist in the research, analysis, cost, and implement financial projects.
• Assist in the Operating, Capital and Salary budget preparations, providing analysis and assistance in financial forecasting.
• Maintain required spreadsheets for the purpose of producing financial reports.
• Track subsidies and grants, and expedite payments, ensuring financial obligations in various Municipal agreements are met.
• Prepare and reconcile working papers for external audit.
• Prepare year-end reports and journal entries.
• Complete cost and rate analysis and annual review to ensure full cost recovery where required.
• Liaise with staff, external agencies and consultants as required.
• Assist the Manager with research, analyze, cost, and implement financial projects, policies and procedures.
• Prepare Monthly Reserve Reconciliations
• Assist in data collectionand analysisfor the Asset Management Plan.
  Prepare bank reconciliations.Provide support in Financial Planning & Analysis as required.Understand and adhere to the Occupational Health and Safety Act and Town Health and Safety policies and procedures.Other duties as assigned.