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.
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.
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).
37.5 hours/week
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.
BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.