Senior Manager, Commercial Data Architecture & Governance

Job Description

What is the opportunity?

Supporting CDMARS (Commercial Delivery Model and Advisor Strategy) Data Governance & Data Strategy, we are seeking an experienced Data Engineer to join our team and lead the implementation, migration and optimization of our Commercial Data Analytics Cloud Data Lakehouse built on Snowflake. You'll be instrumental in architecting a modern data platform that unifies structured and semi-structured data storage with advanced analytics capabilities. This role offers the opportunity to work with cutting-edge Lakehouse technologies and establish the foundation for enterprise-wide data initiatives, enabling self-service analytics and supporting business intelligence across the organization.

What will you do?

Cloud Data Lakehouse Infrastructure

• Design and Build Snowflake Data Lakehouse Architecture - Architect and implement scalable data lakehouse solutions using Snowflake, establishing data zones (raw, curated, analytics) and optimizing storage and compute performance while developing ELT/ETL Pipelines that will build a robust environment with Snowflake native features (Snowpipe, Tasks, Streams) and external orchestration tools to process batch and streaming data from various sources

• Data Modeling and Schema Design - Design and implement dimensional models, data vault architectures, and modern data modeling patterns optimized for Snowflake's unique architecture and performance characteristics

Data Strategy & Governance

• Data Integration and Migration & DRY Approach - Lead data migration efforts from legacy systems to Snowflake; integrate data from various sources including databases, cloud storage, SaaS applications, and real-time streams; be a reference on Don’t Repeat Yourself methodology, using scalable strategy to build lean processes that can be re-used

• Performance Optimization, Data Governance and Security - Implement data governance frameworks, access controls, data lineage tracking, and ensure compliance with data privacy regulations within the Snowflake environment; monitor and optimize Snowflake warehouse performance by implementing clustering strategies, managing data lifecycle policies, and optimizing costs through efficient resource utilization

Contribute to Overall effectiveness of Commercial Banking Data Insights & Analytics

• Collaboration and Enablement - Work closely with data analysts, business intelligence developers, and data scientists to enable self-service analytics and provide technical guidance on best practices; Liaise with partner groups, help in the coordination of partnership with DA (Distribution Analytics), Borealis, PMR (Performance Management Reporting) and other analytics groups.

• Technology / Processes / Tools - Facilitate the turn-over of data to analytics and insights;

Leadership & Transformational Value

• Strategic leadership - Lead efforts on identifying new technology, execution on opportunities to improve productivity, and development of data & governance roadmaps ;

• Team leadership - Works as an integral part of the DI&A team, leading and mentoring team members on new value-added approaches and fostering a culture of innovation and collaboration;

What do you need to succeed?

Must-have:

• 4+ years of experience in data engineering with at least 2 years of hands-on Snowflake experience (including architecture, performance tuning, security features, and cost optimization strategies)

• Advanced SQL skills with experience in complex query optimization and Snowflake-specific SQL features

• Cloud data integration experience using tools like Fivetran, Matillion, Talend, or custom solutions for data ingestion and Cloud platform knowledge particularly Azure Blob Storage, AWS S3, or GCP Cloud Storage for external data staging

• Data modeling expertise with dimensional modeling, data vault, or other modern data architecture patterns

• Scripting and automation proficiency in Python, JavaScript (for Snowflake stored procedures), and shell scripting

• Version control and deployment experience with Git, CI/CD pipelines, and infrastructure as code practices

Nice to have:

• Data orchestration tools experience with Airflow, Prefect, or dbt for workflow management and data transformation and Data lake technologies experience with Delta Lake, Databricks, or other lakehouse platforms

• Streaming data integration using Snowflake Streams, Kafka connectors, or real-time data ingestion patterns

• Modern data stack experience with tools like dbt, Looker, Tableau, or other analytics platforms integrated with Snowflake and Multi-cloud experience with data integration across AWS, Azure, and GCP environments

• Snowflake certifications (SnowPro Core, Advanced Data Engineer, or Architecture)

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.

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

Job Skills

AI Governance, Architecture Governance, Data Architecture Development

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

PERSONAL & COMMERCIAL BANKING

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-05-07

Application Deadline:

2026-05-22

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

Our Employment Opportunities

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.

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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.