Senior Data Engineer

About

Join RBC Insurance as a Senior Data Engineer where you'll utilize SQL and cloud technologies to enhance data processes. Take lead in building data pipelines and ensure high-quality governance.

In this role with RBC Insurance, you will contribute your expertise as a Senior Data Engineer, focusing on transitioning legacy systems to cloud environments. You will construct robust ETL/ELT pipelines, develop efficient SQL queries, and collaborate on data models with team members. Your role directly influences the quality and usability of data for analytics.

Utilize your analytical skills at RBC Insurance to create impactful data solutions and foster innovation.

Responsibilities

• Design data migration strategies to transition to cloud systems
• Develop and maintain ETL/ELT pipelines for data processing
• Optimize SQL queries and data processing scripts
• Ensure governance and data integrity throughout transformations
• Support self-service analytics through effective data structuring

Requirements

• Minimum 2 years of experience as a Data Engineer
• Proficiency in SQL, Python, and cloud ETL technologies
• Experience with AWS, Azure, or Google Cloud platforms
• Familiarity with data warehousing solutions like Snowflake
• Knowledge of BI tools including Tableau for data structuring