What’s in it for you as an employee of QFG?

• Health & wellbeing resources and programs

• Paid vacation, personal, and sick days for work-life balance

• Competitive compensation and benefits packages

• Work-life balance in a hybrid environment with at least 3 days in office

• Career growth and development opportunities

• Opportunities to contribute to community causes

• Work with diverse team members in an inclusive and collaborative environment

We’re looking for our next Senior Financial Reporting Analyst. Could it be you?

The purpose of the Senior Financial Reporting Analyst is to provide support to the Controllership Group to prepare various regulatory reports for the Trust and the future Bank, ensuring compliance with regulatory guidelines. The Senior Financial Reporting Analyst is a key member of the finance team, supporting regulatory reporting and related processes for the Trust and the future Bank. This role requires collaboration with finance team members, other business units, and the business intelligence team to develop and prepare key regulatory reports.

This role necessitates advanced Excel skills, including VBA editing, Power Bi, Power Query, SQL, XML, and database creation. Additionally, the candidate must possess a keen eye for detail and financial reporting experience within a financial institution.

Need more details? Keep reading...

In this role, responsibilities include but are not limited to:

Database Creation & Management:

• Creating and maintaining a database which will be used to support regulatory and other ad-hoc reports, perform ETL operations on large databases.

• Documenting development and usage of such databases.

• Working across business units to refine databases and create customized reports for regulatory reporting purposes.

• Knowledge of VBA editing, Power Query, SQL, XML, etc.

• Proficiency in utilizing BI tools for creation of reports, scorecards, dashboards and other solutions (MS Excel Power BI, DAX Query, Prospector, Delta 360, Portfolio Plus, etc.).

Data Analysis and Validation:

• Gathering, analyzing, and validating financial data from various sources to ensure accuracy and completeness of regulatory reports.

• Identifying and investigating data discrepancies and implementing corrective actions.

• Performing reconciliations and variance analysis to ensure data integrity.

• Creating and validating data quality reports.

• Working with the Business Intelligence team to support development of new reports or enhance or change existing reports.

• Identifying and recommending process improvements to enhance the efficiency and accuracy of regulatory reporting processes.

• Participating in system implementations and upgrades related to regulatory reporting.

• Collaborating with various departments to gather necessary data and information.

• Communicating effectively with regulatory bodies and internal stakeholders.

• Providing support and training to other team members as needed.

Regulatory Reporting and Compliance:

• Accurate and timely preparation of all reports to the Office of the Superintendent of Financial Institutions (OSFI).

• Accurate and timely preparation of reports to the other Canadian regulators like CMHC, CDIC, Stats Canada, Bank of Canada and other ad-hoc reports.

• Ensuring compliance with all applicable regulatory requirements guidelines.

• Contributing to the integrity of the financial reporting and highlighting areas of improvement.

• Maintaining a thorough understanding of evolving regulatory reporting standards and implementing necessary changes.

• Assisting controllership team in identifying changes or impacts to future reported figures and balances arising from business decisions and/or transactions.

• Assisting in the development and implementation of internal controls to ensure compliance with regulatory reporting requirements.

• Participating in external, internal and regulatory audits as applicable.

• Documenting and maintaining up-to-date procedures and process flows.

So are YOU our next Senior Financial Reporting Analyst? You are if you…

• Hold a Bachelor’s degree in Accounting, Finance, or a related field

• Have 5+ years of financial and management reporting experience, preferably within the Canadian banking or trust industry

• Hold a professional accounting designation (CPA) or actively pursuing one

• Have advanced level MS Excel skills and knowledge of VBA editing, SQL, XML

• Have expertise in working with databases and creating reports in Power BI

• Have strong proficiency in financial analysis, data validation, and problem-solving, with impeccable attention to detail and accuracy

• Are able to work independently and collaboratively, while building strong working relationships and communicating effectively

• Understand Canadian regulatory reporting requirements, including OSFI and Bank of Canada guidelines

• Possess strong business acumen and analytical skills including ability to conduct quantitative analysis

• Are capable of attention to detail and accuracy while being able to step back to consider the impacts on the consolidated entity

• Have the aptitude to work with large amounts of data and to manipulate, arrange and manage it effectively

• Are able to recognize issues and take initiative to work on finding an effective solution

• Bring a positive, can-do attitude to our organization, using creative solutions to solve problems

• Are a strong team player who motivates others to achieve group success

• Establish and build on healthy working relationships with your team and peers

• Use open communication and collaboration to solve problems and manage deliverables

• Work well in a dynamic and fast paced environment with the ability to navigate through organizational change

Sounds like you? Click below to apply!

#LI-NP1

#LI-Hybrid