Skip to main content
Full-Time
On-Site

Sr. Data Engineer

View on Map

Description

The Senior Data Engineer at RBC Insurance will be instrumental in migrating data from on-premise and legacy systems to a cloud environment. This role involves designing and implementing migration strategies, building and maintaining ETL/ELT pipelines, optimizing SQL queries, and ensuring data integrity and governance. The engineer will also collaborate with data architects and analysts to define data models, enable self-service analytics, and implement data observability and monitoring.

What We're Looking For

Design and implement data migration strategies for transitioning on-premise 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.

Ideal Candidate

2+ years of professional experience as a Data Engineer.,Strong experience in SQL, Python, and cloud-based ETL frameworks.,Hands-on experience with AWS, Azure, or Google Cloud (GCP).,Proficiency in Snowflake, BigQuery, Redshift, or similar data warehousing platforms.,Experience in structuring data for Tableau or similar BI tools.,Experience with Apache Airflow, Talend, DBT, or similar ETL frameworks.,Familiarity with Spark, Hadoop, or other big data technologies (plus).,Actuarial Knowledge and Insurance industry knowledge (nice to have).,Knowledge of factors affecting Claims and Insurance Policies (nice to have).,Other programming skills considered an asset (nice to have).

Hard Skills

Big Data Management
Cloud Computing
Database Development
Data Mining
Data Warehousing (DW)
ETL Processing
Quality Management
Requirements Analysis
SQL
Python
AWS
Azure
Google Cloud (GCP)
Snowflake
BigQuery
Redshift
Tableau
Apache Airflow
Talend
DBT
Spark
Hadoop

Soft Skills

Excellent organizational
Multi-tasking
Time management
Strong Teamwork
Collaboration Skills
Analytical Thinking
Group Problem Solving

Work Hours

37.5 hours/week

Benefits

Flexible benefits
Work/life balance programs
Career development programs
Investment and retirement savings plans
Competitive pay
High-earning potential
Tools, training, and team support
Flexible work/life balance options
Sophisticated RBCI software tools

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.