Vista previa generada por IA
Senior Data Engineer at RBC in Toronto – lead end‑to‑end data solutions.
Drive innovation with Snowflake, AI, and cloud platforms.
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
Job Skills
Almacenamiento de datos (DW), Análisis de requisitos, Computación de la nube, Desarrollo de bases de datos, Gestión de Big Data, Gestión de calidad, Minería de datos, Procesamiento ETL, Resolución de problemas en grupo
Additional Job Details
Address: 180 WELLINGTON ST W:TORONTO
City: Toronto
Country: Canadá
Work hours/week: 37.5
Employment Type: Full time
Platform: Job Type: Regular
Pay Type: Salaried
Posted Date: 2026-05-11
Application Deadline: 2026-07-15
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 .
#LI-POST
#TechPJ