FIR System Support Analyst

Fonction publique de l'Ontario; Toronto; On-site; CAD 69,000 - 88,000; Full time

Job summary

Ontario Public Service is seeking a FIR System Support Analyst to maintain and support the Financial Information Return (FIR) system used for municipal data collection. This role involves Excel/VBA expertise, Hyperion/Essbase, and website support within the FIR unit of the Ministry of Municipal Affairs and Housing in Toronto.

You will work under the FIR System/Website Administrator and help develop financial models, ensure proper user documentation, and mentor other staff on best practices for

Qualifications

• Advanced knowledge of Microsoft Excel and VBA.
• Experience with Hyperion Planning / Essbase / Smart View.
• Experience with SQL and Oracle Apex.

Responsibilities

• Provide technical support to municipalities and municipal auditors in the FIR reporting template.
• Provide technical support for FIR reporting applications.
• Maintain FIR year changes in Hyperion Planning / Essbase cube.
• Assist in FIR website updates and maintenance.
• Mentor staff on FIR data modelling best practices.

Skills

Excel VBA

Tools

Hyperion Planning / Essbase / Smart View

WordPress / HTML

SQL

Oracle Apex

Job description

Apply By:Thursday, October 8, 2026 11:59 pm EDT

Ministry of Municipal Affairs and Housing

Division:

Local Government & Planning Policy

City:

Toronto

Position(s) language:

Job term:

1 Temporary - up to 12 months with possible extension

Job code:

17158 - Systems Officer 4

$1,512.75 - $1,933.38 Per week*
*Indicates the salary listed as per the OPSEU Collective Agreement.

Calling all Excel and Visual Basics for Applications (VBA) Expert Users.
The Ministry of Municipal Affairs and Housing is looking for a FIR System Support Analyst to help maintain and support the system underlying the province's primary tool for the collection of municipal financial information, the Financial Information Return (FIR).

About the job

FIR data is collected through a complex Excel workbook and is stored in a Hyperion Planning / Essbase cube which is maintained by the FIR Unit of the Ministry of Municipal Affairs and Housing. In addition, FIR data and other information is regularly posted on the FIR website which is also maintained by the unit.

Working with and under the direction of the FIR System / Website Administrator you will:

• Provide technical support to municipalities and municipal auditors in the use of the FIR reporting template.
• Provide technical support for all associated FIR reporting applications.
• Set up / remove OPS BPS Secure and Smart FIR accounts.
• Maintain all reporting applications to reflect any changes made to the current year FIR including any required changes to the Hyperion Planning / Essbase cube.
• Provide backup to the FIR Website Administrator in the update and maintenance of the FIR website.
• Participate in the development of new applications / financial models in support of government priorities as required.
• Provide mentoring, leadership, and functional expertise to branch / Ministry staff on best practices / methodologies in the use of FIR data when designing / developing financial models.
• Ensure that all user documentation / support memos are kept up to date

What you bring to the team

Technical Knowledge and Expertise:

• Advanced knowledge of Microsoft Excel and Visual Basic for Applications (VBA).

You have knowledge of:

• Current and emerging I&IT trends
• Methods and techniques for systems analysis, design and development and knowledge of programming concepts
• Accessibility for Ontarians with Disabilities Act (AODA) concepts

You have experience with:

• Hyperion Planning / Essbase / Smart View
• WordPress / HTML
• SQL
• Oracle Apex

Analytical and Problem-Solving Skills:

• You have excellent problem-solving skills and can analyze user problems and recommend / initiate solutions.
• You can evaluate requirements, review options, and recommend approaches and options.
• You have excellent time management skills and can manage numerous conflicting priorities in an effective manner.
• You have analytical skills and can work with and review large amounts of data and provide advice on various types of data issues.

Communication and Interpersonal Skills:

• You have excellent customer service skills to assist a wide variety of users both internally, and from the municipal sector.
• You can communicate both verbally and in writing to respond effectively to end users requiring support
• You can effectively present and discuss options and analysis with audiences both technical and non-technical.
• You can prepare system documentation, user manuals and technical bulletins.
• You have excellent inter-personal skills and can work effectively with a wide variety of people both technical and non-technical.

Don't meet every qualification?

If you are excited about this position and meet most, but not all, of the listed qualifications, please still consider applying. We recognize that no one person might have every qualification in this job ad, and you just might be the right candidate!

How we support diversity, inclusion and accessibility

We are building an inclusive workforce that reflects the communities we serve. We encourage everyone interested in working with us to apply, including people with disabilities, Indigenous, Black and racialized individuals, as well as people from all ethnicities, cultures, sexual orientations, gender identities and gender expressions.

Our hiring process is accessible, consistent with Ontario's Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005. We are working to prevent and remove barriers in our hiring processes and can offer accommodation to address specific needs related to Code-protected grounds such as disability, family status and religion. For more information about accommodation during the hiring process please contact us.

Learn more about the work the OPS is doing to create an inclusive, anti-racist, accessible and diverse workplace:

• diversity, equity and inclusion initiatives
• accessibility
• Anti-Racism Policy

• 1 English Temporary, duration up to 12 months, 777 Bay St, Toronto, Toronto Region

Language requirements and assessment: All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.