Senior Data Engineer

RBC • Toronto, ON

4d • 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

Benefits

• A comprehensive Total Rewards Program including bonuses and flexible benefits
• competitive compensation
• commissions
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed