Rbc

Financial Services

SeniorDataEngineer

Toronto, Ontario, Canada FULL TIME Remote Friendly
Market Sentiment
HIGH DEMAND

Neural analysis suggests this role is
optimal for Senior candidates.

The Brief

“Senior Data Engineer at Rbc. Skills: Snowflake, Informatica Cloud (IICS), data modeling, advanced SQL, cloud data warehouses, data transformation, ETL. Lead data discovery, exploration, investigation, and impact apply best practices across data flows and systems. Conduct data profiling, preparation, and validation against requirements”

What You'll Achieve.

establish frameworks and standards that ensure accurate, efficient, and secure data delivery; achieve organizational objectives

Industry & Context.

Financial Services
Problems you'll solve

Highly developed problem-solving abilities

What They're Looking For.

Must Have

SDLC frameworks, database technologies, advanced SQL, data transformation, ETL tools, cloud data warehouses, data modeling, 10+ years designing, developing, and deploying production-scale data solutions, 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 data lineage documentation, Cloud infrastructure knowledge (AWS, Azure, GCP), Kubernetes, Docker, serverless computing, Data orchestration, version control (Git), CI/CD, Advanced communication and collaboration skills, Highly developed analytical and problem-solving abilities

Nice to Have

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

What You'll Do.

and impact apply best practices across data flows and systems

Conduct data profiling

and validation against requirements

Design and develop conceptual

and physical data models aligned with business requirements

Create Entity Relationship diagrams

dimensional models (star/snowflake schema)

and data flow diagrams

Document inconsistencies

and misclassifications

and optimize Snowflake data warehouse solutions including schema design

and performance tuning

Develop and deploy cloud-based data integration pipelines using Informatica Cloud (IICS)

Execute transformations

and data manipulations using advanced SQL

Guide integration across data sources and maintain enterprise-level view of data landscape

Document workflows (functional/technical specs

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

How You'll Work.

Team & Collaboration

Work with SMEs and business partners to establish standards and achieve organizational objectives; Advanced collaboration skills

Communication Scope

Advanced communication skills

Process & Methodology

SDLC frameworks

Full Job Description

**_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+ year

Free ATS check

Applying for this Senior Data Engineer role?

Most applicants get filtered before a human reads their resume. See if yours makes the cut.

How to Apply on Workday

  • Workday has a multi-step form — save your progress after every section.
  • "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
  • Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
  • Job requisition numbers are useful when following up with HR by email.

ANONYMOUS · UNFILTERED

What do employees actually say about Rbc?

Real rants from real employees. Read before you apply.

Read Company Rants →