Lead Data Engineer

Job Summary

Job Description

Job Description

What is the opportunity?

RBC, one of Canada’s largest and most respected employers, is looking for a Data Professional to join our growing team of Talent Data and Analytics experts.

You are a technical expert who will help expand and optimize our data architecture and pipelines, but also an experienced data wrangler who enjoys optimizing data systems to support not only software developers, database architects, data analysts, and data scientists but also business partners, data governance professionals and subject matter experts within HR and RBC’s businesses and functional groups. The right candidate will be excited by the prospect of optimizing our company’s HR data architectures to support our next generation of applications including both cloud-based HRIS systems (Workday) as well as on-premise streaming data and reporting warehouses and platforms to help drive better talent insights from our data. 

You are a multi-talented data professional who can embrace architecture, analytics, modeling, and development, are comfortable collaborating with HR and business subject matter experts have a keen ability to translate business needs into requirements documents, technical solutions and storytelling insights.

What will you do?

• Research, develop, deploy and maintain end-to-end talent data and analytics solutions maximizing data pipelines and architectures to provide actionable talent metrics and insights (datasets, visualizations, dashboards) to serve business, HR and team needs
• Identify, design, and implement internal process improvements: automating manual processes, orchestrating and optimizing data delivery across various cloud-based and on-premise data platforms, re-designing data models for greater scalability, etc.
• Build on and optimize the existing foundation of data pipeline architectures required for optimal extraction, transformation, and loading of data from a wide variety of data sources using various methods, programming languages, and software technologies, adjusting as needed to optimize effectiveness.
• Support the construction of a common repository of HR data knowledge including data dictionaries, dimension and measure definitions, platform cross walks and basic governance and lineage.
• Manage project risks, issues, and decisions related to data requirements, ensuring proper steps are taken to mitigate, escalate, and communicate detailed updates to leadership
• Contribute to and review project documents, ensuring alignment between Business, Strategic, and HR data requirements, and contribute to successful data solution delivery by managing priorities, timelines, dependencies, critical paths, and solution design

What do you need to succeed?

Must have:

• Exceptional collaboration skills are essential — the ideal candidate thrives in team environments, communicates effectively across functions, and actively contributes to shared goals
• 7+ years of advanced working experience with relational databases (including Teradata, SQL Server, MySQL or similar)
• 7+ years of advanced experience with Microsoft Excel
• Expertise with object-oriented language for use with data access, data manipulation, ETL, APIs, text mining, and light analytics (including Python, VBA)
• Expertise with cloud computing-based data platforms like Snowflake
• Proficient in Snowflake SQL and Snowflake UI 
• Experience with Snowflake architecture and components (e.g., virtual warehouses, stages, databases, schemas)
• Experience with enterprise job scheduling and orchestration tools such as Rundeck, Stonebranch, or equivalent to automate and manage data workflows and operational tasks.
• Strong management, organizational, critical thinking, analytical, communication and negotiation skills

Nice-to-have

• Experience with data visualization tools such as Tableau or Power BI
• Graduate degree in Computer Science, Statistics, Information Systems, Physics or related quantitative field.
• 5+ years of experience in a Data Engineering or equivalent role

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
• A world-class training program in financial services
• Opportunities to do challenging work.

#LI-Post

#LI-PK

#TECHPJ

Job Skills

Analytical Thinking, Application Requirements Analysis, Big Data Management, Cloud Computing, Cloud Computing Management, Data Analysis, Database Application Development, Database Development, Data Mining, Data Warehouse ETL, Data Warehousing (DW), Data Warehousing Systems, ETL Processing, Group Problem Solving, Python (Programming Language), Quality Management, Quality Management Standards, Requirements Analysis, SQL Databases, SQL Data Mining, Structured Query Language (SQL), System Requirements Analysis, Team Problem Solving, Visualization Tools

Additional Job Details

Address:

20 KING ST W:TORONTO

City:

TORONTO

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

HUMAN RESOURCES & BMCC

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2025-07-14

Application Deadline:

2025-07-31

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

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.