Apply now

First seen by our source: 3 hours ago

Data Analyst, CWM Analytics, GWM

@ Scotia Wealth Management

Ottawa, Ontario

Full-time2+ years experience
Apply now
SIGNALS

Overview

Scotia Wealth Management is hiring a full-time Data Analyst for its CWM Analytics team, based in Toronto or Ottawa, Ontario. The role turns complex data into insights and recommendations for Retail Banking, Wealth Management, Risk and Finance, and builds dashboards, reports and presentations. The posting asks for 2+ years of analytics or BI experience, a bachelor's degree, and strong SQL and visualization skills.

Responsibilities:

  • Analyze large datasets to produce business insights
  • Build dashboards and reports in Power BI, Tableau or Excel
  • Present findings to technical and non-technical stakeholders
  • Validate data quality and support governance standards
  • Automate reporting and support advanced analytics projects

Requirements summary:

  • Bachelor's degree in analytics, statistics, math, computer science, finance or related field
  • 2+ years in data analytics or business intelligence
  • Strong SQL and relational database skills
  • Power BI, Tableau or similar visualization tools
  • Advanced Excel and PowerPoint skills
  • Financial services or risk analytics experience is an asset

Tools & skills

Source and dates

Source type not verified · apify-linkedin

Employer posting date
Not provided
First seen by our source
2026-11-14
Source record updated
2026-11-14

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SeniorityMid level
DepartmentData & analytics
Experience2+ years
Hours per week40 (estimated)
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish
EducationBachelor’s degree (required)
Fields of studyData Analytics, Statistics, Mathematics, Computer Science, Finance

Summary and details written by AI from the posting; the employer’s posting is the authority.

Scotia Wealth Management

FieldValue
Open jobs on Jobsy2
Job description
Requisition ID: 277891

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

Purpose

The Data Analyst plays a key role in driving data-informed decision-making across Scotiabank by transforming complex data into meaningful insights that support business strategy, operational excellence, and customer outcomes. Working closely with business partners, data engineers, and analytics teams, you will leverage data to uncover opportunities, solve business challenges, and deliver actionable recommendations that create measurable impact.

Key Responsibilities

Data Analysis & Insights

  • Analyze large and complex datasets to identify trends, opportunities, and actionable business insights.
  • Develop and maintain dashboards, reports, and visualizations using Power BI, Tableau, Excel, or similar tools.
  • Translate data into clear recommendations that support strategic and operational decision-making.
  • Develop clear and professional PowerPoint presentations to communicate analytical findings, trends, and recommendations to business stakeholders.

Stakeholder Collaboration

  • Partner with business leaders across areas such as Retail Banking, Wealth Management, Risk, and Finance to understand business needs and objectives.
  • Translate business questions into analytical solutions and data-driven recommendations.
  • Present findings effectively to both technical and non-technical audiences.

Data Quality, Governance & Quality Assurance

  • Ensure the accuracy, integrity, and reliability of data used for reporting and analysis.
  • Perform quality assurance reviews to validate the accuracy and completeness of reports, dashboards, and analytical outputs.
  • Apply strong data governance practices to support appropriate data usage, documentation, controls, and adherence to enterprise standards.
  • Perform data validation, reconciliation, and quality assurance activities.
  • Support data governance initiatives and adherence to enterprise standards and best practices.

Advanced Analytics & Innovation

  • Support predictive analytics, customer segmentation, performance measurement, and business improvement initiatives.
  • Collaborate with data scientists and engineers on advanced analytics and innovation projects.
  • Identify opportunities to automate reporting and enhance data processes.

What You'll Bring

Technical Skills

  • Strong SQL and data querying skills.
  • Experience with data visualization tools such as Power BI, Tableau, or similar platforms.
  • Advanced Excel proficiency.
  • Strong proficiency in Microsoft PowerPoint, with the ability to translate data and insights into clear, professional presentations.
  • Knowledge of data quality, quality assurance, and data governance principles and practices.
  • Experience with Python or R is an asset.
  • Familiarity with cloud and data warehousing platforms such as Snowflake, Hadoop, GCP, or similar technologies.

Core Competencies

  • Strong analytical and problem-solving abilities.
  • Excellent communication and data storytelling skills.
  • High attention to detail and commitment to data accuracy.
  • Ability to manage competing priorities in a fast-paced environment.
  • Collaborative mindset with strong stakeholder relationship skills.

Education & Experience

  • Bachelor's degree in Data Analytics, Statistics, Mathematics, Computer Science, Finance, or a related field.
  • 2+ years of experience in data analytics, business intelligence, or a related field.
  • Experience working with large datasets and relational databases.
  • Financial services, banking, customer analytics, or risk analytics experience is considered an asset.
  • This role may be based in either Toronto or Ottawa, Ontario.

Why Join Scotiabank?

  • Work on high-impact projects that influence strategic business decisions.
  • Partner with diverse teams across one of Canada's leading financial institutions.
  • Gain exposure to modern analytics tools, cloud technologies, and enterprise-scale data environments.
  • Be part of a team that values innovation, collaboration, and continuous learning.

#SWM

Location(s): Canada : Ontario : Ottawa

Similar jobs

  • Data Analyst

    Belleville, ON
    Full Time

    Belleville and Quinte West Community Health Centre

    2+ YOECandidates need an undergraduate degree in a data or IT field and at least two years of data analysis experience, preferably in healthcare. Strong skills in Power BI, SQL and Excel, plus experience with survey platforms and data quality management, are required.

    Power BI, SQL, Microsoft Excel, Survey platforms

  • Data Analyst

    Mississauga, ON
    Full Time

    Aramark Canada

    Candidates need advanced Microsoft 365 skills (Excel, PowerPoint, Visio), a bachelor's degree or equivalent business experience in a related field, and experience with system integration or data conversion. Strong communication, SQL or database knowledge, and an interest in responsibly applying AI tools are also expected.

    Excel, PowerPoint, Visio, SQL, APIs

  • Intermediate Data Analyst

    Toronto, ON
    Full Time

    HRbrain Inc.

    5+ YOECandidates need about 5 years of data analysis experience, SQL skills, and experience with Python or R and BI tools such as Tableau or Power BI. They also need knowledge of data warehousing and ETL, strong communication skills, and Spanish language ability.

    SQL, Python, R, Tableau, Power BI

  • Data Analyst - Utilities

    Toronto, ON
    Contract

    Quantum Technology Recruiting Inc. (QTR)

    3+ YOECandidates need 3+ years in data analysis, asset management, maintenance planning or reliability, with strong Power BI and Excel skills. Proven process improvement experience and clear communication with engineers and stakeholders are required.

    Power BI, Excel, Alteryx, Tableau, SAP

  • Data Analyst, Client Data

    Toronto, ON
    Full Time

    FP Inc.

    Candidates need strong hands-on Python and SQL, advanced Excel, and proven ability to find root causes and carry out data fixes independently. Experience with large enterprise datasets, cross-functional financial services programs and clear communication with business and technical stakeholders is required.

    Python, SQL, Excel, FenX, Jira, Git

  • Data Analyst

    Toronto, ON
    Full Time

    York University

    2+ YOECandidates need at least two years of data analysis experience, advanced Excel and Google Analytics skills, and hands-on experience with a relational database such as Oracle or SQL Server. Strong communication, analytical and customer-service skills are essential.

    Excel, Google Analytics, Oracle, SQL Server, SQL Server Reporting Services, Actuate BIRT

  • Data Analyst IV

    Toronto, ON
    Contract

    Motion Recruitment

    8+ YOECandidates need 8+ years in data analytics, business intelligence or product ownership, plus an undergraduate degree in a related field. They need advanced Power BI, strong SQL and Python, and hands-on experience as both a product owner and an analyst.

    Power BI, SQL, Python, Azure Data Factory, Azure Synapse, Databricks

  • Data Analyst

    Toronto, ON
    Full Time

    Bondi Produce and Specialty Foods

    3+ YOECandidates need a bachelor's degree in finance, economics, business or data analytics, plus 3-4 years of pricing or financial analysis experience, ideally in food service or consumer goods. Advanced Excel, Power BI or Tableau, and strong communication skills are required.

    Excel, Power BI, Tableau, ERP systems

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.