Sr. Data Engineer

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-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...