Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Design, develop, and enhance scalable ETL/ELT pipelines to migrate, transform, and load large datasets. Leverage advanced tools and techniques to create reusable, secure, and efficient technical solutions. Guide users on effective Snowflake utilization and implement best practices for data governance and security. Collaborate with stakeholders to translate data requirements into robust solutions and automate workflows using Python and orchestration tools.

Responsibilities

Build and optimize data pipelines, designing, developing, and enhancing scalable ETL/ELT pipelines to migrate, transform, and load large datasets.
Drive technical innovation by leveraging advanced tools and techniques to create reusable, secure, and efficient technical solutions.
Champion Snowflake best practices by guiding users on effective utilization and establishing standards for data consumption, storage, and workflow integration.
Collaborate across teams by partnering with cross-functional stakeholders to translate data requirements into robust solutions.
Strengthen data governance by implementing and maintaining best practices for metadata management, access controls, and compliance.
Ensure performance and scalability by monitoring system performance, troubleshooting issues, and optimizing queries/processes.
Automate and streamline workflows using Python scripting and orchestration tools.
Document and share knowledge by creating clear technical documentation for processes, architectures, and data models.

Requirements

Hands-on experience with Snowflake (e.g., designing stored procedures, optimizing queries, data storage/consumption best practices).
Proficiency in building, optimizing, and maintaining ETL/ELT pipelines for large-scale data migration and transformation.
Strong scripting skills in Python for automation and tool development.
Experience with workflow orchestration tools (e.g., Airflow).
Knowledge of implementing data governance practices (metadata management, access controls, compliance).
Skills in monitoring, troubleshooting, and optimizing database/query performance for scalability.
Ability to guide users/teams on platform best practices and present technical solutions in cross-functional meetings.
Knowledge of version control (Git), containerization (Docker), or CI/CD pipelines for data engineering workflows.
Experience documenting technical processes, architectures, and data models for team use.
Experience designing dimensional models (e.g., star/snowflake schemas) or optimizing data warehouses for analytics.

Skills

Analytics
Big Data
Big Data Management
Cloud Computing
Collaboration
Critical Thinking
Database Development
Data Engineering
Data Mining
Data Modeling
Data Pipelines
Datasets
Data Warehousing (DW)
ETL Processing
ETL Tools
Extract Transform Load (ETL)
Git
Group Problem Solving
Quality Management
Requirements Analysis
Python
Snowflake
Airflow
ETL/ELT
Data Governance
Metadata Management
Access Controls
Compliance
Performance Optimization
Version Control
Docker
CI/CD

Location

Toronto, Canada

Work Type

Full time

Benefits

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.

About the Company

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.