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