Lead Data Analyst

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

Job summary

A leading bank in the Americas is seeking a Lead Data Analyst. You'll play a key role in designing and implementing business solutions using Google Cloud. Candidates should have over 10 years of experience in data analysis and performance optimization for large applications, as well as expertise in data streaming technologies and relational/NoSQL databases. This role includes collaboration with various teams to enhance data-driven decision-making and improve business practices.

Benefits

Diversity and Inclusion initiatives

Upskilling opportunities

Flexible vacation and benefits from day one

Community Engagement activities

Qualifications

• 10+ years of experience in data analysis, especially in large OLTP applications.
• Expertise in performance optimization and knowledge of Wealth Industry.
• Experience with relational and NoSQL databases.

Responsibilities

• Gather requirements and provide insights to solve business problems.
• Analyze current business processes and oversee integration.
• Create technical documents and implement data ingestion patterns.

Skills

Data analysis

Performance optimization

Analytical thinking

Oral and written communication skills

Interpersonal skills

Attention to detail

Tools

Google Cloud Platform

Hadoop HDFS

Kafka

SQL

PostgreSQL

Job description

Requisition ID

243195

Location

Canada: Ontario: Toronto

Overview

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

Team

The Wealth Data engineering team within the Global Wealth Engineering (GWE) is the key team in meeting the operational data needs of the various stakeholders within Wealth Management. The Lead Data Analyst will play a key role in designing and implementing business solutions using Google cloud, working closely with the enterprise data team, data architects, solution architects, data analysts and data engineers.

Role Statement

Lead Data Analyst – play a key role in designing and implementing business solutions using Google cloud.

Responsibilities

• Gather requirements, conduct research, and provide actionable insights to solve business problems, collaborating with multiple teams to ensure project goals meet business needs and documenting findings through reports and presentations.
• Serve as a data analyst and technical support for information systems, analyzing current business processes and overseeing integration and implementation of effective business practices into the appropriate information systems.
• Promote efficiency through systems used in the company, improving and optimizing current systems and creating new systems to support the company’s strategies.
• Create technical documents inclusive of mapping details and design and implement data ingestion patterns that support batch, streaming and API interfaces on both the Ingress and Egress.
• Guide a team of data analysts and work hands‑on in developing framework and mapping specifications using best practices to meet demanding performance requirements.
• Use advanced technical knowledge to support claims and answer clients’ questions about proposed changes.
• Provide end‑to‑end business/technical guidance and expertise on data and referential integrity across LOBs.
• Define use‑case scenarios and validate the scenarios.

Qualifications

• 10+ years of experience in data analysis, performance optimization for large OLTP applications.
• Knowledge of Wealth Industry – Retail/Wealth, IIROC‑CRM guidelines, CRA guidelines.
• Oral and written communication skills.
• Interpersonal and consultative skills.
• Analytical thinking and problem solving.
• Attention to detail and ability to deliver a high level of accuracy.
• Organizational skills.
• Knowledge of business structure.
• Stakeholder analysis.
• Expertise with Hadoop HDFS, Hive, Pig, Flume, and Sqoop.
• Working experience with Google Cloud Platform databases (SQL, Spanner, PostgreSQL).
• Experience with relational/NoSQL databases.
• Experience with data streaming technologies such as Kafka, Spark‑streaming, etc.

Benefits

• Diversity, Equity, Inclusion & Allyship – inclusive culture with Employee Resource Groups.
• Accessibility and Workplace Accommodations – inclusive and accessible environment.
• Upskilling through online courses, cross‑functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits starting on day one.
• Dynamic Ecosystem – free tea & coffee, universal washrooms, and space for team collaboration.
• Community Engagement – opportunities with hackathons, contests, cooking with friends, Humans of Digital, etc.

Company

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.

Accommodation

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.

Application

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.