Business Intelligence (BI) & Reporting Analyst – Power BI - Bank/Finance

About the Role

The incumbent will be working within Investor Services (IS) and closely collaborating with the teams principally focused on the initiatives relating to migration of legacy reporting. We’re at the center of everything Data and Digital. We’re building a team that embraces innovation & enthusiasm to bring fresh perspectives. We’ve been on a journey to build out high performing, highly resilient data and BI solutions that’s scalable with the continuous demands from Internal and External stakeholders.

We’re looking for talented and passionate Business Intelligence (BI) & Analytics professionals to join our team. With an analytical mind-set, you will work as part of an agile team to deliver highly scalable solutions built on various technologies. We believe in continuous growth and expanding your capabilities. Join our team today and have a big impact influencing the strength of our Data and Digital capabilities.

Key Responsibilities

Requirements Gathering

• Elicit, analyze and document business requirements, business rules and user stories and work with business teams, Product teams, other internal stakeholders and in-house development teams throughout solution building and delivery.
• A key member of the project team, the Measurement & Reporting Analyst works with Digital delivery leads, Developers, and Data Domain experts to ensure that the project is delivered on time and within budget.

Stakeholder Management

• Pro-actively communicate and collaborate with internal stakeholders to analyze functional requirements and deliver the appropriate artefacts as needed: business requirement documents, functional specifications, data specifications, data catalogues, use cases, workflow analysis, reports, etc.
• Act as the first line of contact to interface with internal stakeholders – Operations team, Client Success team, Data Engineering team and others.

Business Analytics

• Review data to ensure its integrity for data analysis to deliver business insights and validation of hypothesis.
• Build compelling Power BI reports/dashboards and translate findings into executive communications.
• Demonstrable ability to analyze data/trends, interpret results, build KPIs, explain KPI drivers and communicate in simple terms.

Project Scope

Investment Accounting/Pension Accounting Reporting (IA/PA)

• Migrate legacy reporting onto Power BI & Report Builder including testing & deployment.

ICS Reporting

• Migrate legacy reporting onto Power BI, including testing & deployment.

Required Technical Skills

• In-depth knowledge of database systems such as relational databases, OLAP, and Kimball methodologies.
• Strong understanding of ETL processes and data modelling processes.
• Hands-on experience with visualization software such as Power BI and Report Builder.
• Proficiency in Microsoft Power BI and Excel.

Must-Have Skills & Experience

• Data analysis and reporting skills, with the ability to explore new technologies to enhance the delivery of operations.
• Business and financial acumen with strong analytical, organization, communication, and presentation skills.
• Strong analytical mindset and problem-solving capabilities.

Nice-to-Have Skills & Experience

• Broad knowledge of financial products, processes, and systems.
• Strong aptitude to learn and improve knowledge.

The expected base salary range for this position is $50 – $60 per hour, depending on experience, skills, and internal equity.

The Company offers a total rewards package in accordance with all applicable federal, provincial, and local laws and requirements. Benefit eligibility and offerings vary based on role, employment status, and work location.

For contractor positions, benefits are limited to those entitlements and protections required by applicable law, which may include (as applicable) vacation pay, public holidays, leaves of absence, and other legally mandated benefits or payments.

We may use AI-enabled and/or automated tools to support parts of our recruitment process, including application screening, interview scheduling, and candidate communications. These tools are used to enhance consistency and efficiency. All hiring decisions involve human review and are not based solely on automated processing.