Analyst, Insights and Reporting

Scotiabank; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading bank in North America is seeking a Senior Analyst to drive insights and reporting in Toronto, Ontario. This position involves delivering business intelligence and data analytics to support Sales Channels and Customer Profitability. The successful candidate will leverage tools like Power BI, SQL, and Python to analyze data and provide actionable recommendations that enhance customer performance. A commitment to team collaboration and high standards of accuracy is essential. Competitive rewards and career development opportunities are offered.

Benefits

Performance bonus

Employee Share Ownership Program

Pension Plan Matching

Health Benefits

Work-life balance

Career development opportunities

Qualifications

• Experience in Banking, Reporting, Analytics and Strategy, Finance.
• Experience in manipulating large data sets.
• Strong skills in Excel, PowerBI and SQL.
• Strong problem solver with attention to detail.

Responsibilities

• Develop and maintain dashboards and reports in Power BI and Excel.
• Provide business insights to support decision-making.
• Analyze financial metrics to identify profitability trends.
• Collaborate with business teams to provide recommendations.

Skills

Banking

Reporting

Analytics

Strategy

Finance

Excel

PowerBI

SQL

Problem solving

Communication

Tools

Power BI

SQL

BigQuery

SAS

Python

Advanced Excel

Job description

Requisition ID: 244639

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Senior Analyst, Insights and Reporting contributes to the overall success of Canadian Banking, ensuring specific individual goals, plans, initiatives are executed / delivered in support of the Bank’s business strategies and objectives.

The role will primarily be accountable for delivery of business intelligence and data analytics in support of Sale Channels, Customer Performance and Customer Profitability. Using analytics tools (e.g., PowerBI, SQL, BigQuery, SAS, Python, Advanced Excel, SAS), this role will have access to a wide range of data sources to uncover insights and support various business initiatives. The position supports the Director, Client Data Insights & Reporting, and works with various stakeholders including Analytics, Strategy, Business Lines and Channels. They will also ensure all activities conducted are in compliance with governing regulations, internal policies and procedures.

Is this role right for you?

In this role, you will:

• Champion a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Provide Business Insight and Strategic Support:
  • Develop and maintain dashboards and reports in Power BI and Excel to monitor key performance metrics.
  • Leverage SQL and Python for automation and process efficiency in reporting workflows.
  • Ensure all outputs meet high standards of accuracy, consistency, and timeliness to support fact-based decision-making.
  • Perform ad-hoc analysis to support business decisions related to retail banking products and channels.
  • Collaborate with business teams to draw insights from key customer and financial data to establish trends, understand history and provide recommendations to Business Lines and Channels
• Provide dynamic reporting and analysis on key performance metrics to various stakeholders in Retail, Small Business, Product lines, Channels, and other strategic groups.
• Analyze and interpret critical financial metrics including Revenue, Provisions for Credit Losses (PCLs), Risk-Weighted Assets (RWA), Expenses, and KPIs to identify trends and drivers of profitability.
• Collaborate with business teams to translate data findings into actionable recommendations that improve channel and customer performance.
• Knowledge of Power BI and SQL required.
• BigQuery, Advanced Excel, SAS and Python skills are considered an asset.
• Provide strategic analysis that will assist the business to optimize strategy and product mix from various channels.
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Actively pursue effective and efficient operations of their respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
• Champion a high-performance environment and contributes to an inclusive work environment.

Do you have the skills that will enable you to succeed?

We’d love to work with you if you have experience with:

• Experience in Banking, Reporting, Analytics and Strategy, Finance
• Experience in working with and manipulating large data sets.
• Strong skills in Excel, PowerBI and SQL
• Proactive with solid presentation and written communication skills
• Flexibility is required to adapt to a wide variety of tasks & functions with changing demands.
• Strong problem solver and have a flair for getting things done.
• Excellent analytical skills with strong attention to detail
• Curious and experimental mindset to drive innovation amidst uncertainty.
• Strong verbal and written communication skills with the ability to engage and influence stakeholders at different levels in the organizations

What's in it for you?

• In-depth training to prepare you for the role, as well as ongoing coaching and feedback to help you succeed!
• You’ll be part of a diverse, collaborative, innovative, and high-performing team
• We offer a competitive rewards package:
• Performance bonus, Employee Share Ownership Program, and Pension Plan Matching
• Health Benefits from day one!
• You will relish work-life balance, team events, and opportunities to participate in the community.
• Your career matters! You will have access to career development and progression opportunities.

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.