Senior Data Analyst

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

Benefits offered by this job

Diversity & Inclusion

Accessibility

Tuition assistance

Bonus program

Office amenities

Community programs

Job summary

Scotiabank's Wealth Data Engineering team is seeking a Lead Data Analyst to design and implement data solutions across wealth management. You will partner with enterprise data teams, data architects, and engineers to deliver scalable data ingestion, batch and streaming pipelines, and robust data governance.

You will leverage Hadoop/Hive ecosystems, Kafka and Spark Streaming, and GCP databases to create reliable analytical solutions.

Qualifications

• 10+ years of experience in data analysis and performance optimization for large OLTP applications.
• Knowledge of Wealth Industry – Retail/Wealth and CRA guidelines.
• Strong oral and written communication skills.
• Interpersonal and consultative skills.
• Analytical thinking and problem solving.
• Detail-oriented with high accuracy.
• Excellent organizational skills.
• Understanding of business structures and stakeholder analysis.
• Experience with Hadoop/Hive/Pig/Flume/Sqoop.
• Experience with Google Cloud Platform databases (SQL, Spanner, PostgreSQL).
• Experience with relational/NoSQL databases and data streaming (Kafka, Spark Streaming).

Responsibilities

• Gather requirements and deliver actionable insights; document and present findings.
• Improve and optimise existing systems; design new data processes.
• Design and implement data ingestion patterns for batch, streaming, and API interfaces.
• Support questions with technical evidence and client queries.
• Provide end-to-end guidance on data integrity across lines of business.
• Define use case scenarios and validate them.

Skills

Data analysis

Communication skills

Stakeholder analysis

Analytical thinking

Detail orientation

Organizational skills

Wealth industry knowledge

OLTP performance optimization

Tools

Hadoop HDFS

Hive

Pig

Flume

Sqoop

Google Cloud SQL

Spanner

PostgreSQL

Kafka

Spark Streaming

Job description

Requisition ID: 276344

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

The Wealth Data engineering team within the Global Wealth Engineering (GWE) is the key team in meeting the operational data needs of the various stake holders 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 and data architects, solution architects, data analyst and data engineers

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

• Gather requirements, conduct research, and provide actionable insights to solve business problems. They collaborate with multiple teams to ensure project goals meet business needs. A key task is documenting and presenting findings through reports and presentations.
• Data Analyst is topromote efficiency through the systems used in a company. This is broken into two components: Improving and optimising current systems in the business; and creating new systems to support the company's strategies.
• Creating technical documents inclusive of mapping details as well as designing and implementing data ingestion patterns that will support batch, streaming and API interface on both the Ingress and Egress.
• Use their advanced technical knowledge to support their claims and answer clients' questions about the proposed changes.
• Provide end-to-end business/technical guidance and expertise on data integrity and referential integrity across LOBs
• Defining Use Case Scenarios and validate the scenarios

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

• 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.
• Being detail-oriented and capable of delivering a high level of accuracy.
• Organizational skills.
• Knowledge of business structure
• Stakeholder analysis.
• Expertise knowledge of Hadoop HDFS, Hive, Pig, Flume and Sqoop.
• Working Experience with Google Cloud Platform Databases (SQL, Spanner, PostgreSQL)
• Experience working with relational/NoSQL databases
• Experience with data streaming and technologies such as Kafka, Spark-streaming etc.

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
• Community Engagement - We offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

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,