Senior Data Engineer at Royal Bank of… · Toronto

Senior Data Engineer Location: TORONTO, Ontario, Canada 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: TECHNOLOGY AND OPERATIONS Job Type: Regular Pay Type: Salaried Posted Date: 2026-05-11 Application Deadline: 2026-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. 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.