Senior Data Analyst (GCS)

Posted 14 Days Ago
Be an Early Applicant
West Toronto, ON
5-7 Years Experience
Fintech • Insurance
The Role
The Senior Data Analyst will design and maintain data models, execute SQL queries, manipulate large datasets using Python and PySpark, and develop data visualizations in Tableau. This role involves communicating analytics concepts to stakeholders, leading projects, mentoring team members, and keeping up with advancements in data practices.
Summary Generated by Built In

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

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2024-10-28

Application Deadline:

2024-11-15

Inclusion 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.

Top Skills

Python
SQL
The Company
Minneapolis, MN
88,000 Employees
On-site Workplace

What We Do

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 88,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com.‎

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities.

Jobs at Similar Companies

Hybrid
Kraków, Małopolskie, POL
665 Employees

Cedar Logo Cedar

Solutions Architect (Client Integrations)

Fintech • Healthtech • Software
Easy Apply
Remote
United States
340 Employees

TravelPerk Logo TravelPerk

Senior Executive Assistant

HR Tech • Software • Travel
Easy Apply
Hybrid
London, Greater London, England, GBR
1300 Employees

TravelPerk Logo TravelPerk

Global Benefits Manager

HR Tech • Software • Travel
Easy Apply
Barcelona, Cataluña, ESP
1300 Employees

Similar Companies Hiring

Capco Thumbnail
Professional Services • Generative AI • Fintech • Financial Services • Energy • Cybersecurity • Consulting
London, GB
6000 Employees
iCapital Thumbnail
Fintech • Financial Services
New York, NY
1500 Employees
Applied Systems Thumbnail
Software • Payments • Insurance • Cloud • Big Data Analytics • App development
Chicago, IL
2780 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account