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

180 WELLINGTON ST W:TORONTOTorontoCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2026-05-112026-06-18

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.

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.