Hybrid Financial Reporting Analyst

at City of Hamilton, Ohio

• Job title: Financial Reporting Analyst
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: CA$45 - CA$51 per hour
• Degree requirement: Bachelor's Degree
• Tech skills: ERP
• Location requirements: Hybrid, Hamilton, Canada

About the role

• Financial Reporting Analyst at City of Hamilton, overseeing accounting and reporting functions. Collaborate with departments to ensure financial compliance and accurate reporting.

Responsibilities

• 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.
• Responsible for overseeing the preparation of individual schedules, inter-fund balancing, completion and submission to the Ministry of Municipal Affairs.
• 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.
• 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 the ERP and MS Fabric GL/AP/AR inquiry.

Requirements

• 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.
• Must be currently enrolled in a recognized accounting program working towards completion of CPA designation.
• Demonstrated working experience and proficiency in Windows and MS Office applications, including Microsoft Word, Excel, PowerPoint, Outlook and Internet Searches.
• 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.
• Demonstrated knowledge and thorough understanding of consolidation requirements in accordance with Public Sector Accounting Standards and the use of CaseWare.
• Excellent analytical, report writing and interpersonal skills to communicate effectively with all levels of City staff, external auditors and outside agencies.
• Demonstrated knowledge and thorough understanding of computerized applications in accounts receivables, accounts payable, purchasing, workflow and approved to post procedures.
• Able to assume responsibility to develop ideas into completed projects independently.