Senior Data Engineer

Royal Bank of Canada•Toronto, ON

24d•Onsite

About The Position

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.

Requirements

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
Advanced communication and collaboration skills
Highly developed analytical and problem-solving abilities

Nice To Haves

Python
Experience with US Mortgage, lending, or financial services data (e.g., loan lifecycle, servicing, origination)
Banking/financial services industry experience strongly preferred

Responsibilities

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