Search jobs > Toronto, ON > Senior data analyst

Senior Data Analyst (GCS)

Royal Bank of Canada>
TORONTO, Canada
Full-time

Job Summary

Job Description

What is the opportunity?

At RBC we stand at the forefront of safeguarding RBC assets across the Public Cloud landscape. Our mandate is crystal clear : to ensure the epitome of security for critical digital infrastructure while navigating the ever-expanding cloud ecosystem.

We are not just about defense; we are trailblazers in data-driven security, harnessing the immense power of technological innovation to stay ahead of potential threats.

With our sophisticated tech stack comprising of industry-leading tools like Databricks, Python, PySpark, and Tableau we don't just analyze data;

we transform it into a strategic asset. Our commitment goes beyond traditional security measures as we scrutinize complex datasets and distill them into actionable business insights, thereby fortifying our cyber resilience.

Collaboration is the cornerstone of our success. We empower our team members to bring their narrative prowess and technical skills to the table, creating an environment where innovation thrives and the next breakthrough in cloud security is always on the horizon.

What you will do?

  • Design and maintain robust data models enabling efficient analysis and reporting on Databricks.
  • Expertly construct and execute complex SQL queries for data analysis and insight generation.
  • Utilize Python and PySpark to manipulate and analyse large datasets in a cloud environment.
  • Develop rich storytelling visuals and dashboards in Tableau, translating data into business narratives.
  • Communicate intricate analytics concepts to stakeholders in an intuitive and meaningful way.
  • Lead projects and collaborations with cross-functional teams, providing data-centric strategies for public cloud security.
  • Synthesise and present detailed findings to executive-level management through effective story-driven reporting.
  • Mentor junior team members and help foster a culture of data literacy and excellence within the company.
  • Stay abreast of advancements in data analytics, data modeling, and visualisation to innovate on our data practices.

What do you need succeed?

Must Have :

  • 5+ years of experience in a data analyst, data scientist, or similar role, with an emphasis on SQL, data modeling, and narrative-driven data presentation.
  • Solid experience working with popular Python libraries such as Pandas, NumPy, and notebook environments
  • Advanced SQL abilities and experience querying complex datasets, preferably in a Databricks environment.
  • Extensive experience with Databricks solutions PySpark Spark SQL and cloud data platforms preferably Azure Cloud
  • Excellent problem-solving skills and ability to troubleshoot complex data issues
  • Expertise in Tableau for crafting insightful and engaging data visualizations.
  • Exceptional storytelling skills, with a track record of translating complex data into compelling business insights.
  • Bachelor's or Master's degree in Computer Science, Data Science, Statistics, Information Systems, or a related field. A higher degree or certifications related to data analysis is a plus.
  • Outstanding interpersonal and leadership skills, with the ability to mentor and lead teams.
  • A portfolio showcasing your analytical, modeling, and storytelling expertise (links or attachments required with application).

Nice to Have :

  • Experience working on an Agile team
  • Familiarity with Cyber Security Concepts
  • Certification in Tableau and / or relational databases

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper.

We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

  • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
  • Leaders who support your development through coaching and managing opportunities
  • Ability to make a difference and lasting impact
  • Work in a dynamic, collaborative, progressive, and high-performing team
  • Flexible work / life balance options
  • Opportunities to do challenging work
  • Opportunity to move into Data Scientist and Data Engineering roles.

LI-Post

LI Hybrid

LI PK

Job Skills

Analytical Thinking, Business Insights, Communication, Critical Thinking, Data Administration, Data Analysis, Databricks Platform, Data Mining, Data Modeling, Data Movement, Data Reporting, Data Science, Data Visualization, Detail-Oriented, Group Problem Solving, Quantitative Research, Research Documents

Additional Job Details

Address :

330 FRONT ST W : TORONTO

City : TORONTO

TORONTO

Country : Canada

Canada

Work hours / week : 37.5

37.5

Employment Type : Full time

Full time

Platform :

TECHNOLOGY AND OPERATIONS

Job Type : Regular

Regular

Pay Type : Salaried

Salaried

Posted Date : 2024-10-28

2024-10-28

Application Deadline :

2024-11-15

I nclusion and Equal Opportunity Employment

At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work.

We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.

We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com .

2 days ago
Related jobs
Royal Bank of Canada>
Toronto, Ontario

The Senior Technical Analyst, Cyber Technology Operations will provide operational support for a wide range of network security, endpoint security and threat surface products/tools within RBC’s global Cyber Security environment. The Senior Technical Analyst will provide production support and perfor...

Aviva
Toronto, Ontario

The Senior Data Analyst will be providing data to support the Claims business which includes data mining, automated reporting and modelling. Data Analyst to join our Claims Data and Analytics team!. Transformation of complex data sets into conclusions & recommendations, delivering proactive analysis...

RBC - Royal Bank
Toronto, Ontario

As a Senior Cyber Security Analyst in the Identity Access Management (IAM) Team, you will work with the IAM Application Onboarding Team to integrate RBC applications onto IAM solutions (CyberArk, EntraID (Azure), SailPoint IIQ, ServiceNow, GDS, etc. Work with business partners and application teams ...

Aritzia
Canada, Canada

As a Senior Data Analyst, Digital at Aritzia, you will combine your deep understanding of digital customer experiences with your passion for data and masterful analytics skills to drive decisions that will create long lasting relationships with our customers and enhance outcomes for our eCommerce bu...

The Toronto-Dominion Bank (Canada)
Toronto, Ontario

Provide technical leadership across a broad range of data analysis functions including data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data...

CB Canada
Toronto, Ontario

Senior Business Analyst - Capital Markets - Data Mapping. On behalf of our client in the Banking Sector, PROCOM is looking for a Senior Business Analyst - Capital Markets - Data Mapping. Senior Business Analyst - Capital Markets - Data Mapping – Job Description. Senior Business Analyst - Capital Mar...

0000050007 Royal Bank of Canada
Toronto, Ontario

As a Senior Analyst, Data Sourcing, you will be accountable for ensuring that Systems of Records (SORs) and Authorized Provisioning Points (APPs) are identified, declared, promoted, and utilized, in order to be in compliance with the RBC Enterprise Data Management and Reporting Policy/Standards. Wor...

00002 Citibank, N.A.
Mississauga, Ontario

The Data Analytics Lead Analyst AVP will perform complex and critical audits and assessments of Citi’s risk and control environments of the Chief Operating Office (COO), including the Chief Data Office, Data Management, and Program Management leveraging analytical tools, data science, and innovation...

Great Canadian Gaming Corp.
Canada, Canada

Senior Data Analyst / Engineer Consultant - Edmonton, AB. Experience with real-time data ingestion and processing using tools like Azure Stream Analytics, especially for pushing data into the data lake in near-real-time. Knowledge of using Azure Databricks or Synapse for data processing, transformat...

Royal Bank of Canada>
Toronto, Ontario

Agile Methodology, Communications Writing, Confidentiality, Controls Management, Critical Thinking, Cyber Security Management, Data Governance, Decision Making, Detail-Oriented, Encryption Software, Group Problem Solving, High Impact Communication, Information Security Management, Information Techno...