Sr Data Engineer

RBC • Mississauga, ON

3d • CA$80,000 - CA$130,000 • Onsite

About The Position

RBC Insurance, through its operating entities, provides a wide range of travel, life, health, home, auto, wealth, and insurance products and solutions. We also offer creditor and business reinsurance services to both individual and group clients. As one of the largest insurance companies within a major 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.

Requirements

• 3+ years of experience in SQL and Python
• Hands-on experience with one or more of the following: Snowflake, Databricks, AWS, Azure, or Google Cloud (GCP)
• Experience transforming enterprise-level data at scale, including datasets with billions of records
• Proficiency in Snowflake for data warehousing is a strong asset
• Experience with Apache Airflow or similar workflow orchestration tools
• Experience with Data Warehouse design and Data Modelling
• Computer Science or Engineering degree, or equivalent experience
• Strong analytical thinking and problem-solving skills
• Excellent collaboration and communication skills

Nice To Haves

• Machine learning and statistical knowledge
• Software engineering project experience
• Hackathon or Kaggle Competition experience
• Experience with DBT, or similar ETL/ELT transformation frameworks
• Familiarity with Spark, Hadoop, or other big data technologies

Responsibilities

• Build data pipelines and reports that transform financial data reporting at RBC Insurance
• 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
• Develop Python programs and perform advanced data analytics
• Contribute to the build-out of enterprise-scale Data & Analytics as a Service (DAaaS) initiatives
• Work on projects that enable LLM self-service capabilities for business users
• Ensure data integrity, quality, and governance throughout the transformation process
• Collaborate with Data Architects and Analysts to define data models and transformations

Benefits

• bonuses
• flexible benefits
• competitive compensation
• commissions
• stock where applicable
• Leaders who support your development through coaching and managing opportunities
• A world-class training program in financial services
• Flexible work/life balance options

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree