Manager, Reporting & Insights

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

Job summary

A leading bank in the Americas is seeking a Manager, Reporting & Insights in Toronto. This role is pivotal in generating actionable insights and optimizing reporting processes to support the business strategy. Ideal candidates will possess a university degree in a related field and substantial experience with Power BI, SQL, and analytical tools. Join a dynamic team committed to fostering an inclusive workplace and delivering exceptional results for clients.

Qualifications

• University degree in Business Analytics, Statistics, Computer Science, or related field.
• Strong experience in Power BI, including DAX coding and dashboard design.
• Experience with SQL, Python, or SAS.

Responsibilities

• Design and create reports to analyze and improve understanding of branches.
• Develop reports to support management using visualization tools.
• Validate data extraction for accuracy in reporting.

Skills

Power BI

SQL

Python

SAS

Analytical skills

Communication skills

Data visualization

Automation

Education

University degree in Business Analytics or related discipline

Tools

Tableau

Google Cloud Platform

Job description

Join a purpose-driven winning team, committed to results, in an inclusive and high-performing culture. The Manager, Reporting & Insights contributes to the overall success of the Goal Planning and Performance Department in Canada by owning reporting and ad-hoc requests and generating actionable insights for individual goals, plans, and initiatives that support business strategies and objectives. This role ensures compliance with regulations, policies, and procedures.

Is this role right for you? In this role, you will:

• Design and create reports using data to analyze and improve our understanding of branch staff and customer behaviour, and monitor the impact of strategic decisions and initiatives.
• Design and develop new reports to support management, including visualization tools such as Tableau & PowerBI, complex data and logic tools, SAS, SQL, and self-service dashboards.
• Analyze data and evaluate results, identify emerging business issues, and prepare recommendations for management.
• Continuously acquire and enhance knowledge of business/product strategies, portfolio management principles, branch processes and procedures, regulatory requirements, and advanced analytical tools/methodologies to provide business solutions.
• Validate data extraction to ensure accuracy and accountability of reporting and insights.
• Work closely with other stakeholders, Retail Customer Value, Goal Planning and Performance employees to support our Retail and Small Business Banking, reporting, and business intelligence processes.
• Automate and increase efficiencies on data extraction, transformation and reporting processes.
• Understand how the Bank’s risk appetite and risk culture should be considered in day‑to‑day activities and decisions.
• Champion a customer‑focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Champion a high-performance environment and implement a people strategy that attracts, retains, develops and motivates the team by fostering an inclusive workplace, communicating vision, values, business strategy and managing succession and development planning.

Do you have the skills that will enable you to succeed in this role?

• A university degree in Business Analytics, Statistics, Computer Science, Mathematics, Database Marketing, Finance, Business Management, or a related discipline.
• Strong Power BI experience, including DAX coding, Power Query (M), building dataflows and semantic models, and designing insightful dashboards.
• Experience with report automation, including automated refreshes, data pipelines, and workflow orchestration in Power BI Service.
• Experience with SQL, Python or SAS.
• Experience working with cloud platforms such as Google Cloud Platform (GCP), including BigQuery or similar cloud data warehousing tools.
• Excellent analytical and problem‑solving skills with the ability to interpret complex data and generate meaningful insights.
• Strong communication skills, both written and verbal.
• Flexible, motivated, and results‑oriented.
• Curious and passionate about data, visualization, automation, and continuous improvement.

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.