Job Description

Questrade Financial Group (QFG), through its companies - Questrade, Inc., Questrade Wealth Management Inc., Community Trust Company, ThinkInsure, Zolo, and Flexiti, provides securities and foreign currency investment, professionally managed investment portfolios, mortgages, insurance, real estate services, financial services and more. Questrade uses cutting-edge technologies to develop innovative products that give customers better, more affordable ways to take control of their money.



We are everything a traditional financial institution is not. At QFG, you will be constantly moving forward, bringing the future of fintech into existence. You will be a part of a collaborative team that cares deeply about our mission and each other. Your team members will help you conquer challenges, push boundaries and discover what you are truly capable of.



This is a place where you can explore, discover and learn with continuous growth. As a diverse and inclusive place to work, with a hybrid working environment you can unleash your creativity and curiosity with no limits. If you share the same sense of infinite possibility, come shape your future at QFG.



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 Financial Reporting Analyst. Could it be you?

The Financial Reporting Analyst is a key member of the finance team, supporting regulatory reporting and related processes for CTC and the future Bank. The purpose of this role 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. 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:

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 other Canadian regulators like CMHC, CDIC, Stats Canada, and the Bank of Canada. Maintaining a thorough understanding of evolving regulatory reporting standards and implementing necessary changes. Creating and maintaining a database to support regulatory and other ad-hoc reports and performing ETL operations on large databases. Gathering, analyzing, and validating financial data from various sources to ensure accuracy and completeness of regulatory reports. Performing reconciliations and variance analysis to ensure data integrity. Identifying and recommending process improvements to enhance the efficiency and accuracy of regulatory reporting processes. 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.

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.

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

Have advanced level MS Excel skills and knowledge of VBA editing, SQL, XML Are an expert in working with databases and creating reports in Power BI Have 3+ years of financial and management reporting experience, preferably within the Canadian banking or trust industry 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

Additional kudos if you...

Have a Bachelor's degree in Accounting, Finance, or a related field Have a professional accounting designation (CPA) or are actively pursuing one Have an understanding of Canadian regulatory reporting requirements, including OSFI and Bank of Canada guidelines

Sounds like you? Click below to apply!

#LI-NP1

#LI-Hybrid



At Questrade Financial Group of Companies, with multiple office locations around the world, we are committed to fostering a diverse, inclusive and accessible work environment. This is an environment where individuals are treated with dignity and respect. Here, the unique skills and experience you bring will be valued. You will be supported and motivated, so that you can harness your unlimited potential. Our team reflects the diversity of the communities we serve and operate in. Having a collaborative and diverse team helps us push boundaries to bring the future of fintech into existence--not only for the benefit of our customers, but for those who build their career with us.



Questrade Financial Group of companies Applicant Tracking System utilizes artificial intelligence (AI) for application screening. The AI system operates on predetermined criteria, with final decisions subject to human review.



Candidates selected for an interview will be contacted directly. If you require accommodation during the recruitment/selection process, please let us know and we will work with you to meet your needs.