Job ID #31856: Financial Reporting Analyst

Contribute to the City of Hamilton, one of Canada’s largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometers of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented and ambitious staff who embody our values of sensational service, courageous change, steadfast integrity, collective ownership and being engaged empowered employees. Help us achieve our vision of being the best place to raise a child and age successfully. #BeTheReason

• Job ID #31856: Financial Reporting Analyst 
• Union: CUPE Local 5167
• Job Description ID #: 441
• Close date: Interested applicants please submit your application online at www.hamilton.ca/city-council/jobs-city
  by 4:00 p.m. on April 8 2026.
• Vacancy type: This posting is for an existing vacancy 
• Internal applicants should apply with your work e-mail address. External applicants are considered only after the internal posting process has been completed. Only applicants chosen for an interview will be contacted.
  

SUMMARY OF DUTIES

Reporting to the Manager, Accounting Services, perform a variety of complex programming, accounting and financial reporting functions using ERP and MS Fabric Data Queries . Assume leadership role in the co-ordination and completion of the Year-End Financial Information Return (F.I.R.) Schedules and consolidated Financial Report.  Provide direction, training, functional and procedural support to staff, other departments and outside agencies.

GENERAL DUTIES

Assume leadership role in the co-ordination and completion of the year-end F.I.R. Schedules and Financial Report.  Responsible for overseeing the preparation of individual schedules, inter-fund balancing, completion and submission to the Ministry of Municipal Affairs.  Provide direction, advice and training to other staff as required.

Design, create, modify and implement System Financial Reports using ERP and MS Fabric to meet the needs of users as well as annual financial requirements including F.I.R. schedules, and F.I.R. Current Budget Variance Reports.

Design, create and download transactional data reports using query, a data management tool within the ERP to facilitate the analytical aspect of the requirements of this position.

Develop, implement and maintain the reporting F.I.R. Tree Structure and the corporation's chart of accounts in adherence to the Provincial Financial Reporting Guidelines.

Co-ordinate and maintain in the ERP system, the porting and reporting data parameters.  Ensure the timeliness and accuracy of the reporting process including scheduling the month end open and close processes as well as the Fiscal Year-End Close.

Review, analyze and interpret the Ministry of Municipal Affairs Accounting F.I.R. Guidelines and Instructions. Communicate changes to affected teams. Compile, summarize, analyze and classify the corporations' accounts by manipulating MS Fabric and ERP reports and transcribing annually onto the F.I.R. Schedules  Oversight and preparation of F.I.R. schedules and reconciliation of the Financial Report to F.I.R. submission.

Review annually and assist in the implementation of new or changes to the Public Sector Accounting Board standards  to be reported on the Financial Report and F.I.R.

Compile, analyze and classify the Corporation's Long Term Debt financial data using spreadsheets and preparing the year-end financial working papers.

Compile, analyze, and complete Corporation’s year-end consolidated financial statements using Financial Reporting software and preparing supporting year-end financial working papers. 

Provide pertinent debt information to establish and allocate the annual Budget for Long Term Debt.

Prepare, input system journal entries regarding Long Term Debt and oversee journal entries processed to the Sinking Funds account.

Liaise with various outside entities to confirm and advise of outstanding debt, Sinking Fund Actuarial and future repayment schedules.

Coordinate year-end journal entries posted by departments.

Create and oversee the year-end transfers from/to reserves including the final year-end Surplus/Deficit entries.

Review journals and ensure proper accounting procedures are met, proper accounts are used and inter-functional transfers are accurate.  Initiate and process the necessary corrections as required.

Review, interpret the Ministry of Finance reporting requirements, determine and implement the proper accounting Procedures and Policies.

Liaise and assist the City's outside auditors at year-end by compiling data, investigating discrepancies, performing detailed analysis, and explaining the variances between actual to budget and/or current year to prior year's comparative numbers.

Monthly and year-end analysis/reconciliation of various balance sheet accounts using a variety of database applications within theERP and MS Fabric GL/AP/AR inquiry.

Compile various detailed and analytical reports for Statistic Canada.

Review annual changes to account structure, usage and year-end transfers.

Perform other duties as assigned which are directly related to the responsibilities of this position.

QUALIFICATIONS

1. Demonstrated experience in accounting procedures and principles normally acquired through the completion of a University Degree in Business, Commerce or Accounting or an equivalent combination of education and relevant work experience.
2. Must be currently enrolled in a recognized accounting program working towards completion of CPA designation.
3. Demonstrated working experience and proficiency in Windows and MS Office applications, including Microsoft Word, Excel, PowerPoint, Outlook and Internet Searches.
4. Demonstrated knowledge and thorough understanding of a computerized accounting program including General Ledger Reporting Foundation, General Ledger set-up, GL Query, ERP and MS Fabric  Reporting and GL Journal Creation.
5. Demonstrated knowledge and thorough understanding of consolidation requirements in accordance with Public Sector Accounting Standards and the use of CaseWare.
6. Excellent analytical, report writing and interpersonal skills to communicate effectively with all levels of City staff, external auditors and outside agencies.
7. Demonstrated knowledge and thorough understanding of computerized applications in accounts receivables, accounts payable, purchasing, workflow and approved to post procedures.
8. Able to assume responsibility to develop ideas into completed projects independently.

Disclaimer:

Be advised that Human Resources frequently audits resumes of internal/external applicants to ensure/validate information provided is consistent and trustworthy. Falsification of information provided at any time throughout the recruitment process may be grounds for disqualification, and for internal applicants, subject to discipline up to and including termination.

Terms:

The City is an equal opportunity employer that is committed to inclusive, barrier-free recruitment and selection processes. Consistent with our Values and Corporate Culture Pillars, the City of Hamilton is committed to providing equitable treatment to all with respect to barrier-free employment and accommodation without discrimination. The City will provide accommodation for applicants in all aspects of the hiring process, up to the point of undue hardship.  If you have an accommodation need, please contact Human Resources as soon as possible to make appropriate arrangements.