**Job Summary**

**What is the opportunity?**
At RBC, we are at the forefront of safeguarding our assets across the Public Cloud landscape. Our mandate is clear: to ensure the highest level of security for critical digital infrastructure while navigating the expanding cloud ecosystem. We focus on data-driven security and leverage technological innovation to stay ahead of potential threats. Our sophisticated tech stack includes industry-leading tools like Databricks, Python, PySpark, and Tableau. We analyze data and transform it into strategic assets, going beyond traditional security measures to distill complex datasets into actionable business insights.

**What you will do:**
- Design and maintain robust data models enabling efficient analysis and reporting on Databricks.
- Construct and execute complex SQL queries for data analysis and insight generation.
- Utilize Python and PySpark to manipulate and analyze large datasets in a cloud environment.
- Develop dashboards in Tableau that translate data into business narratives.
- Communicate intricate analytics concepts to stakeholders intuitively.
- Lead projects and collaborate with cross-functional teams, providing data-centric strategies for public cloud security.
- Present findings to executive-level management through effective reporting.
- Mentor junior team members and foster a culture of data literacy and excellence.
- Stay current with advancements in data analytics and visualization practices.

**What do you need to succeed?**
**Must Have:**
- 5+ years of experience in a data analyst or data scientist role, emphasizing SQL and data presentation.
- Solid experience with popular Python libraries such as Pandas and NumPy.
- Advanced SQL abilities and experience querying complex datasets, preferably in a Databricks environment.
- Extensive experience with Databricks solutions, PySpark, and cloud data platforms, preferably Azure Cloud.
- Excellent problem-solving skills and ability to troubleshoot complex data issues.
- Expertise in Tableau for creating engaging data visualizations.
- Exceptional storytelling skills, translating complex data into business insights.
- Bachelor's or Master's degree in Computer Science, Data Science, Statistics, Information Systems, or a related field.
- 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?**
- A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, and commissions.
- Leaders who support your development through coaching and managing opportunities.
- Opportunity to make a lasting impact.
- Work in a dynamic, collaborative, and high-performing team.
- Flexible work/life balance options.
- Opportunities for career advancement into Data Scientist and Data Engineering roles.

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

**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: 2025-01-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. We strive to provide an accessible candidate experience for all applicants. Please let us know if you need accommodations during the recruitment process.

**Join our Talent Community**
Stay informed about great career opportunities at RBC. Sign up for customized information on our latest jobs and recruitment events. Find out how we enhance the well-being of our clients and communities at jobs.rbc.com.