THE UNITED COUNTIES OF LEEDS AND GRENVILLE

Community and Social Services Division

Invites applications for the position of:

Financial Analyst

CSS Financial

Status: Permanent Full-Time

Salary (2025 Grid 7): $34.95 - $41.60

Location : Brockville, Ontario

QUALIFICATIONS:

Education, Certification and Licenses

• Post-secondary degree or diploma in Business Accounting or equivalent combination of education and experience.
• An accounting designation (CPA) is preferred.
• Completion of the Municipal Administration Program and the Municipal Finance Course would be considered an asset.
• Valid Class G driver’s license.

Experience

• With a university degree, three (3) years job-related experience in the accounting and finance field, preferably in the municipal sector.
• Without a university degree, five (5) years job-related experience working in an accounting or finance field, preferably in the municipal sector.
• Experience in managerial accounting is preferred.

Knowledge Skills and Abilities

• Knowledge and understanding of financial principles, policies, procedures/processes, and reporting requirements.
• A proficient level of computer literacy in word processing and databases. Experience in systems such as Great Plains, FMW budgeting software and ARCORI, or a similar property management system, would be considered an asset.
• Advanced proficiency in the development and maintenance of Excel spreadsheets.
• Track all payments made to childcare operators by payment type in a spreadsheet; updated monthly.
• Track all payments made under Infant Affordability, Wage Enhancement, Fee Subsidy and Small Waterworks ensuring adherence to the guidelines.
• Review and provide monthly caseload/household data or other statistics as requested/required by the program Manager(s).
• Perform analysis on the financial information received from the childcare operators to ensure compliance with the funding guidelines.
• Advise the Manager of Community and Social Services Finance/Deputy Treasurer if any issues or concerns are noted.
• Provide financial information, tips, resources, etc. to childcare operators to ensure support is being provided on an ongoing basis at regular scheduled childcare operator meetings or when contacted by the operator directly.
• Prepare the annual child care operator funding calculations for Children’s Services and ensure payments are processed in a timely manner.
• Provide the required financial information/allocation amounts required for the preparation of the annual service schedules provided to each childcare operator.
• Post all housing batches including accounts receivable, accounts payable, purchase orders, and journal entries in the ARCORI property management system.
• Ensure the monthly electronic fund transfer (EFT) files are sent to the bank by the required processing dates.
• Assist with monthly Housing bank reconciliations ensuring they are completed in a timely manner.
• Assist with the maintenance of the Housing Allowance spreadsheets and ensure the data is accurately reflected in the General Ledger.
• Perform the month-end close on the property management system.
• Balance the property management system to Great Plains on a monthly basis including preparing the monthly journal entry and working papers.
• Monitor capital expenditures in the property management system to ensure they are recorded in Great Plains.
• Monitor the former rent arrears and work with the Housing Program Supervisor to ensure proper write off and collection procedures are followed.
• Work in cooperation with the Program and Policy Review Analyst to ensure operating and financial compliance.
• Perform all financial aspects of the not-for-profit housing providers program.
• Create the budget documents for the eight not-for-profit providers and input cost factors, rent indices, and new benchmarked revenues and expenditures.
• Review the completed budget documents and determine the annual subsidy.
• Create the Annual Information Return (AIR) template for the housing providers.
• Review the completed AIR’s and audited financial statements, and discuss any issues with the Manager of CSS Finance/Deputy Treasurer.

SUMMARY OF POSITION RESPONSIBILITIES:

• Assist the Manager of Community and Social Services Finance/Deputy Treasurer and CSS Program Managers with a review of the salary plan model to ensure program compliance as per Ministry guidelines.
• Assist the Children’s Services, Housing, and Ontario Works Managers in the development of the annual budgets for all programs.
• Provide assistance with developing financial projections as requested/required.
• Input the details of the annual budget into the FMW budgeting software for Manager approval, ensuring adherence to the legislation and funding guidelines.
• Prepare the annual Ontario Works Administration budget submission in the Ministry format identifying direct and central costs.
• Monitor expenditures and revenues to ensure programs are on budget and notify the Manager of Community and Social Services Finance/Deputy Treasurer if issues are identified.
• Provide assistance with developing financial projections for the Manager of Community and Social Services Finance/Deputy Treasurer and/or CSS Program Manager(s) as requested/required.
• Perform monthly variance analysis of the Children’s Services, Housing, and Ontario Works programs.
• Provide analysis of general ledger accounts as requested/required.
• Prepare journal entries as requested/required.
• Maintain working papers on all revenue and expense accounts related to Children’s Services, Housing, and Ontario Works.
• Prepare the year-end working papers for the annual audit for both operating and capital budgets as requested/required.
• Develop and update spreadsheets, reporting tools, and application forms as requested/required.
• Track all payments made to childcare operators by payment type in a spreadsheet; updated monthly.
• Track all payments made under Infant Affordability, Wage Enhancement, Fee Subsidy and Small Waterworks ensuring adherence to the guidelines.
• Review and provide monthly caseload/household data or other statistics as requested/required by the program Manager(s).
• Perform analysis on the financial information received from the childcare operators to ensure compliance with the funding guidelines.
• Advise the Manager of Community and Social Services Finance/Deputy Treasurer if any issues or concerns are noted.
• Provide financial information, tips, resources, etc. to childcare operators to ensure support is being provided on an ongoing basis at regular scheduled childcare operator meetings or when contacted by the operator directly.
• Prepare the annual child care operator funding calculations for Children’s Services and ensure payments are processed in a timely manner.
• Provide the required financial information/allocation amounts required for the preparation of the annual service schedules provided to each childcare operator.
• Post all housing batches including accounts receivable, accounts payable, purchase orders, and journal entries in the ARCORI property management system.
• Ensure the monthly electronic fund transfer (EFT) files are sent to the bank by the required processing dates.
• Assist with monthly Housing bank reconciliations ensuring they are completed in a timely manner.
• Assist with the maintenance of the Housing Allowance spreadsheets and ensure the data is accurately reflected in the General Ledger.
• Perform the month-end close on the property management system.
• Balance the property management system to Great Plains on a monthly basis including preparing the monthly journal entry and working papers.
• Monitor capital expenditures in the property management system to ensure they are recorded in Great Plains.
• Monitor the former rent arrears and work with the Housing Program Supervisor to ensure proper write off and collection procedures are followed.
• Work in cooperation with the Program and Policy Review Analyst to ensure operating and financial compliance.
• Perform all financial aspects of the not-for-profit housing providers program.
• Create the budget documents for the eight not-for-profit providers and input cost factors, rent indices, and new benchmarked revenues and expenditures.
• Review the completed budget documents and determine the annual subsidy.
• Create the Annual Information Return (AIR) template for the housing providers.
• Review the completed AIR’s and audited financial statements, and discuss any issues with the Manager of CSS Finance/Deputy Treasurer.
• Review and provide monthly caseload data and other statistics as requested/required by the Manager.
• Download monthly SAMS reports required for completing the forms submission.
• Monitor client costs monthly to ensure all client costs are reflected in both the general ledger and SAMS.
• Provide regular financial updates to the Manager of Integrated Program Delivery for administrative and other provincial programs, ensuring adherence to the guidelines.
• Understand the various funding agreements and program requirements to ensure funds are utilized as per Ministry guidelines.
• Assist the Manager of Community and Social Services Finance/Deputy Treasurer in the submission of required Ministry reporting through the Transfer Payments Ontario (TPON) portal for Ontario Works and Housing programs, and the Education Financial Information System (EFIS) in Children’s Services.
• Prepare for the Manager of Community and Social Services/Deputy Treasurer monthly Form 5 submission of Ontario Works through the Social Assistance Management System (SAMS), the Annual Report on Annual Distributions (RAD), and the Service Manager Annual Information Return (SMAIR).
• Assist with the collection and verification of statistical information relating to household data, caseloads and service delivery.

Other related duties, as requested and required.

The foregoing Job Description reflects the general duties necessary to describe the principal functions of the job identified, and shall not be construed to be all of the work requirements that may be inherent in this classification.

How to Apply:

Applications should be marked “Competition # FINAN001309, Financial Analyst PFT and submitted online to the job posting on the Careers section of our website at https://www.leedsgrenville.com/en/government/careers.aspx/ View our Job Opportunities. by 4:00 pm on/before Oct 3, 2025

Applicant information is collected under the Municipal Freedom of Information and Protection of Privacy Act (MFIPPA) and will only be used for candidate selection.

Accommodation at the United Counties of Leeds and Grenville

The United Counties of Leeds and Grenville is committed to providing a recruitment and selection process that is both inclusive and free from barriers. Accommodations for job applicants with disabilities are available upon request, and will be provided in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act.

Applicants are required, in advance, to make any accommodation request know to Human Resources by contacting the department at 1-800-770-2170 or the Bell Relay Service. Human Resources will strive to provide reasonable and appropriate accommodation for all applicants, during the recruitment and selection process, which will ensure the process is conducted in a fair and equitable manner.