Staff Data Engineer

RBC; Toronto; On-site; CAD 125,000 - 150,000; Full time

Job summary

A leading financial services organization in Toronto is looking for a Senior Data & Analytics Engineer to enhance its risk oversight strategies. The role involves developing an open-source analytics stack and building robust data pipelines for analytics initiatives. Candidates should have over 5 years of experience in data engineering, proficiency with Python, SQL, and tools like Apache Airflow, and a strong understanding of data governance. Join a dynamic team committed to delivering high-quality risk data assets.

Benefits

Comprehensive Total Rewards Program

Flexible benefits

Competitive compensation

Stock options where applicable

Access to a world-class training program

Collaborative and dynamic work environment

Qualifications

• 5+ years' experience in data engineering using Python and Bash.
• Proven experience in data/analytics engineering, including designing and optimizing data pipelines.
• Strong advanced SQL skills to write complex queries.

Responsibilities

• Develop and maintain the open-source Analytics stack infrastructure.
• Design, deploy, and automate data pipelines while enhancing the architecture.
• Create and implement data quality frameworks ensuring completeness and accuracy.

Skills

Big Data Management

Cloud Computing

Data Mining

Data Warehousing (DW)

ETL Processing

Quality Management

Requirements Analysis

Education

Bachelor’s degree in computer science, Information Systems, Statistics, or related field

Tools

Python

SQL

Apache Airflow

JupyterHub

Docker

Trino

CDP (Hadoop)

Spark

GitHub Actions

Red Hat Enterprise Linux (RHEL)

Job description

Job Description

What is the opportunity?

You'll join the GRM Portfolio Risk Oversight team, which provides independent, effective monitoring, control, and communication on material risks for Business Financial Services (BFS). As a Senior Data & Analytics Engineer, you'll contribute to BFS risk oversight strategies by delivering high quality risk data assets and supporting our open‑source data infrastructure. Success in this role means developing strong relationships with business leaders and supporting decision‑making through custom analytics and continuous evolution of our Analytics models. Our best‑in‑class analytics stack requires ongoing refinement to provide business users with relevant, timely self‑serve analytics capabilities.

As a hands‑on practitioner, you will ensure data is accurately tracked, maintained, and analyzed to optimize processes and support business objectives. You will design, build, and maintain our open‑source analytics stack, creating reliable data pipelines and workflows that drive analytics initiatives across the team. The Senior Data & Analytics Engineer will be instrumental in supporting data‑driven decisions, risk evaluation, and automation efforts. You will work with technologies such as Python, SQL, Apache Airflow, JupyterHub, Docker, Trino, CDP (Hadoop), Spark, OCP, GitHub Actions, and Red Hat Enterprise Linux (RHEL), ensuring data pipelines are robust, well‑documented, and validated for accuracy and completeness.

What will you do?

• Develop and maintain our open-source Analytics stack infrastructure
• Assist in maintaining enterprise data solutions across platforms, including RBC’s data lake and databases.
• Design, deploy, and automate data pipelines while enhancing our data engineering architecture
• Create software for retrieving, parsing, and processing structured and unstructured data
• Define and build scalable ETL/ELT workflows for reporting and analytics
• Support the project team to scale, monitor, and operate data platforms for very high availability and performance
• Create and implement data quality frameworks ensuring completeness, accuracy, and integrity
• Establish systematic data validation processes to ensure reporting and analytics accuracy

What do you need to succeed?

Must have:

• Bachelor’s degree in computer science, Information Systems, Statistics, or related field
• Proven experience in data/analytics engineering, including designing and optimizing data pipelines, DB schemas, ETL processes, and data warehousing.
• 5+ years' experience in data engineering using Python and Bash, including data ingestion from various formats, API data acquisition, and data processing with libraries like NumPy and Pandas
• Strong understanding of Git‑based workflows and GitHub, with the ability to establish repository standards, branching strategies and automation pipelines
• Experience implementing and supporting modern data stack technologies
• Advanced SQL skills with ability to write complex queries for extracting and integrating data from multiple sources
• Strong background in data processing and transformation technologies
• Development experience with open‑source frameworks and tools
• Experience building data pipelines with Apache Airflow
• Experience working with RHEL (Red Hat Enterprise Linux)

Nice-to-have:

• Experience in Financial Services, especially Business Financial Services
• Knowledge of data governance, data quality, and data security
• Strong understanding of Credit Risk Management

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
• Opportunities to take on progressively greater accountabilities
• Opportunities to building close relationships with clients
• Access to a variety of job opportunities across business and geographies

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

Address: ROYAL BANK PLAZA, 200 BAY ST:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: GROUP RISK MANAGEMENT

Job Type: Regular

Pay Type: Salaried

Posted Date: 2025-11-25

Application Deadline: 2025-12-23

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.