Rbc

Insurance

SrDataEngineer

$80–130k Mississauga, Ontario, Canada FULL TIME
Market Sentiment
HIGH DEMAND

Neural analysis suggests this role is
optimal for Senior candidates.

The Brief

“Sr Data Engineer at Rbc. Skills: SQL, Python, cloud-based ETL frameworks, AWS, Azure, Google Cloud (GCP), Snowflake, BigQuery, Redshift, Apache Airflow, DBT. Design and implement data migration strategies for transitioning on-premises or legacy systems to a cloud environment. Build and maintain robust ETL/ELT pipelines to process structured and unstructured data”

What You'll Achieve.

Enable self-service analytics by structuring data effectively for end-users; Ensure data integrity, quality, and governance throughout the transformation process

Industry & Context.

Insurance
Problems you'll solve

Analytical Thinking; Group Problem Solving

What They're Looking For.

Must Have

experience in SQL, experience in Python, experience in cloud-based ETL frameworks, Hands-on experience with AWS, Azure, or Google Cloud (GCP), Proficiency in Snowflake, BigQuery, Redshift, or similar platforms, Experience in structuring data for Tableau or similar BI tools, Experience with Apache Airflow, Talend, DBT, or similar ETL frameworks, Excellent organizational, multi-tasking and time management skills, Teamwork and Collaboration Skills, Analytical Thinking

Nice to Have

Familiarity with Spark, Hadoop, or other big data technologies, Actuarial Knowledge and Insurance industry knowledge, Knowledge of factors affecting Claims and Insurance Policies, Other programming skills

What You'll Do.

Design and implement data migration strategies for transitioning on-premises or legacy systems to a cloud environment

Build and maintain robust ETL/ELT pipelines to process structured and unstructured data

Develop and optimize complex SQL queries

and scripts for data processing

Ensure data integrity

and governance throughout the transformation process

Enable self-service analytics by structuring data effectively for end-users

Implement data observability

and logging mechanisms

How You'll Work.

Team & Collaboration

Collaborate with Data Architects and Analysts to define data models and transformations; Teamwork and Collaboration Skills

Process & Methodology

organizational, multi-tasking, time management skills

Full Job Description

**_Job Description_** **What is the opportunity?** RBC Insurance, through its operating entities, provides a wide range of travel, life, health, home, auto, wealth and insurance products and solutions. Also, it offers creditor and business reinsurance services to both individual and group clients. We are one of the largest insurance companies within a Canadian bank and among the fastest growing insurance organizations in the country. RBC Insurance employs more than 3,200 employees around the globe and is the brand name for the insurance operating entities of Royal Bank of Canada. **What will you do?** * Design and implement data migration strategies for transitioning on-premises or legacy systems to a cloud environment. * Build and maintain robust ETL/ELT pipelines to process structured and unstructured data. * Develop and optimize complex SQL queries, stored procedures, and scripts for data processing. * Ensure data integrity, quality, and governance throughout the transformation process. * Collaborate with Data Architects and Analysts to define data models and transformations. * Enable self-service analytics by structuring data effectively for end-users. * Implement data observability, monitoring, and logging mechanisms. **What do you need to succeed?** **Must-have** * **Technical Expertise** : Strong experience in SQL, Python, and cloud-based ETL frameworks. * **Cloud Technologies** : Hands-on experience with AWS, Azure, or Google Cloud (GCP). * **Data Warehousing** : Proficiency in Snowflake, BigQuery, Redshift, or similar platforms. * **BI & Visualization**: Experience in structuring data for Tableau or similar BI tools. * **ETL Tools** : Experience with Apache Airflow, Talend, DBT, or similar ETL frameworks. * **Big Data Processing** : Familiarity with Spark, Hadoop, or other big data technologies is a plus. * Excellent organizational, multi-tasking and time management skills * Strong Teamwork and Collaboration Skills * Analytical Thinking **Nice to Have** * A

Free ATS check

Applying for this Sr 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 →