Financial Reporting Analyst

**About the City of Hamilton**

**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 kilometres 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 POSTING**

JOB ID #: 21806

Financial Reporting Analyst
Corporate Services
Financial Services, Taxation & Corporate Controller
28 James St. N, 4th Floor

NUMBER OF VACANCIES: 1 Full-Time Regular

UNION/NON-UNION: CUPE Local 5167 Inside

HOURS Of WORK: 35 per week
- GRADE: L
- SALARY/HOUR: $42.214 - $47.970 per hour- Note: See appropriate Collective Agreement or the Non Union Salary Range for details.

STATUS/LENGTH: Full-Time Regular

Job Description ID #: 441

SUMMARY OF DUTIES

Reporting to the Manager, Accounting Services, perform a variety of complex programming, accounting and financial reporting functions using NVision and Query in PeopleSoft System. Assume leadership role in the co-ordination and completion of the Year-End Financial Information Return Schedules and 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 Financial Information Return (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 NVision 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 PeopleSoft System to facilitate the analytical aspect of the requirements of this position.

Develop, implement and maintain the PeopleSoft 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 PeopleSoft 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. Compile, summarize, analyze and classify the corporations' Current Revenue and Expenditure accounts by manipulating Nvision and Query system reports and transcribing annually onto the Financial Information Return Schedules 10, 12, 40 and 42 (Current Expenses and Revenues).

Review annually the Public Sector Accounting Board recommendations and changes for local government financial reporting liabilities for Long Term Debt, Employee Benefits and Post Employment Benefits and Consolidation requirements 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 Corporation’s year-end consolidated financial statements using CaseWare 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.

Compile various detailed and analytical reports for Statistic Canada.

Assist the Manager, Taxation with the overall comp