Senior Data Engineer

Job Description WHAT IS THE OPPORTUNITY? The Senior Data Engineer bridges analytical expertise and engineering capabilities within the US Mortgage Technology group. This role leads end-to-end data solutions—from requirements gathering through deployment—establishing frameworks and standards that ensure accurate, efficient, and secure data delivery. The professional innovates at the forefront of financial data solutions, leveraging cutting-edge technologies to solve real-world problems in global financial markets.

WHAT WILL YOU DO? Lead data discovery, exploration, investigation, and impact assessments; apply best practices across data flows and systems

Conduct data profiling, preparation, and validation against requirements

Design and develop conceptual, logical, and physical data models aligned with business requirements

Create Entity Relationship diagrams, dimensional models (star/snowflake schema), and data flow diagrams

Document inconsistencies, data gaps, and misclassifications

Design, develop, and optimize Snowflake data warehouse solutions including schema design, architecture, and performance tuning

Develop and deploy cloud-based data integration pipelines using Informatica Cloud (IICS)

Execute transformations, aggregations, and data manipulations using advanced SQL

Guide integration across data sources and targets; maintain enterprise-level view of data landscape

Document workflows (functional/technical specs, mapping diagrams, testing plans, run books)

Ensure audit controls (ABC Framework) and security standards across all designs

Work with SMEs and business partners to establish standards and achieve organizational objectives

Leverage generative AI and LLMs to enhance data insights and develop innovative solutions

WHAT DO YOU NEED TO SUCCEED? Must have: 6-8 years with SDLC frameworks, database technologies, advanced SQL and data transformation, ETL tools, cloud data warehouses, and data modeling

10+ years designing, developing, and deploying production-scale data solutions

Experience with Snowflake for: Architecture design, warehouse development, schema optimization, security, and performance tuning

5+ years with Informatica Cloud or similar cloud-based ETL platforms. IICS development, mapping design, workflow orchestration, connector configuration, and pipeline optimization

Expertise in dimensional, relational, and semantic modeling; data lineage documentation

Cloud infrastructure knowledge (AWS, Azure, GCP), including Kubernetes, Docker, and serverless computing

Data orchestration, version control (Git), CI/CD practices; Python a nice-to-have

Advanced communication and collaboration skills

Highly developed analytical and problem-solving abilities

Nice to Have: Experience with US Mortgage, lending, or financial services data (e.g., loan lifecycle, servicing, origination)

Banking/financial services industry experience strongly preferred

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

Opportunities to do challenging work

Opportunities to take on progressively greater accountabilities

#LI-POST #TechPJ

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: 180 WELLINGTON ST W:TORONTO City: Toronto Country: Canada Work hours/week: 37.5 Employment Type: Full time Platform: Job Type: Regular Pay Type: Salaried Posted Date: 2026-05-11 Application Deadline: 2026-08-17 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.