Senior Data Analyst (GCS)

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

330 FRONT ST W:TORONTOTORONTOCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2024-10-282024-11-15