Senior Analyst, Financial Reporting

Questrade Financial Group (QFG), through its companies - Questrade, Inc., Questrade Wealth Management Inc., Community Trust Company, Zolo, and Flexiti Financial Inc., provides securities and foreign currency investment, professionally managed investment portfolios, mortgages, 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.

At QFG, we have a culture of innovation where technology serves people—both our team and our customers. We see AI as a collaborative and transformative enabler, and we are seeking forward-thinking individuals who can effectively integrate it into their daily work. The ideal candidate will be a catalyst for change, helping us use AI to create a more efficient and rewarding employee experience while also developing cutting-edge solutions that delight and serve our customers. Join us in shaping a future where AI empowers our team to do their best work and helps us deliver unparalleled customer experiences.

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 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
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.