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?

1. Production-Ready Data Pipeline Development

Design, build, and deploy enterprise-grade data pipelines that operate reliably in production environments
Implement comprehensive testing, monitoring, and alerting systems to ensure 24/7 data availability
Take end-to-end ownership of data solutions from conception through production deployment and ongoing maintenance
Establish robust CI/CD practices for data engineering workflows

2. Cloud Data Architecture & Migration

Lead cloud data migration initiatives, transitioning legacy systems to modern cloud platforms
Architect scalable, secure, and cost-effective cloud-based data infrastructure
Optimize data storage, processing, and retrieval performance across distributed systems
Implement disaster recovery and business continuity plans for critical data assets

3. Advanced Data Engineering & Transformation

Build and maintain sophisticated ETL/ELT pipelines processing high-volume structured and unstructured data
Develop optimized SQL queries, stored procedures, and automation scripts for complex data transformations
Ensure data quality, lineage, and governance standards throughout all data processes
Collaborate with cross-functional teams to implement scalable data models and architectures

4. API Development & Integration

Design and develop high-performance RESTful APIs and GraphQL endpoints for data access and integration
Build secure, scalable API gateways that enable seamless data consumption across enterprise applications
Implement API versioning, documentation, and monitoring strategies for production environments
Integrate with third-party APIs and microservices to create comprehensive data ecosystems

5. Analytics Enablement & BI Integration

Engineer data solutions that power real-time and batch analytics across the organization
Optimize data structures and pipelines for seamless integration with Tableau and other BI platforms
Enable self-service analytics capabilities through well-designed data marts and APIs
Support advanced analytics and machine learning initiatives through feature engineering

6. Performance Engineering & Innovation

Proactively identify and resolve performance bottlenecks in production data systems
Implement comprehensive observability solutions including logging, monitoring, and alerting
Drive continuous improvement initiatives to enhance system reliability and efficiency
Research and implement emerging technologies to maintain competitive advantage

7. Technical Leadership & Collaboration

Provide technical mentorship and establish data engineering best practices across teams
Partner with Data Scientists, Analysts, and Business stakeholders to translate requirements into technical solutions
Ensure compliance with enterprise security, privacy, and regulatory frameworks
Drive innovation through proof-of-concepts and technical experimentation

What do you need to succeed?

Must-have

5+ years of Professional Experience with the following:

Production Experience: Proven track record of delivering and maintaining data solutions in enterprise production environments
Self-Driven Mindset: Demonstrated ability to work independently, take ownership, and drive projects to completion with minimal supervision
Technical Expertise: Advanced proficiency in SQL, Python, and modern cloud-based data engineering frameworks
Cloud Mastery: Hands-on experience with AWS, Azure, or Google Cloud Platform including native data services
Data Platform Experience: Deep knowledge of Snowflake, BigQuery, Redshift, or similar enterprise data warehouses
ETL/ELT Proficiency: Extensive experience with Apache Airflow, DBT, Talend, or comparable orchestration and transformation tools
BI Integration: Proven experience structuring data for Tableau, Power BI, or similar visualization platforms
DevOps Skills: Experience with version control, CI/CD pipelines, containerization, and infrastructure as code
Problem-Solving Abilities: Strong analytical thinking and troubleshooting skills with complex distributed systems
Communication Skills: Excellent ability to translate technical concepts for diverse stakeholders

Nice to Have

Actuarial Knowledge and Insurance industry knowledge
Knowledge of factors affecting Claims and Insurance Policies
Other programming skills considered an asset

What’s in it for you?

A Total Rewards program that includes flexible benefits, work/life balance and career development programs and investment and retirement savings plans
Competitive pay and high-earning potential
All the tools, training, and team support you need to grow your business and career
Flexible work/life balance options
Sophisticated RBCI software tools to boost your productivity and grow your business

RBC Insurance is an organization that succeeds by bringing out the best in its people. You’ll be part of a supportive, inclusive team that shares common values – including a fundamental respect for each other. At the heart of this is a commitment to diversity. RBC respects and responds to the many competing and evolving priorities in our lives – so you can focus on what you can do best – putting clients first.

#LI-POST

#TECHPJ

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Quality Management, Requirements Analysis, Waterfall Model

Additional Job Details

Address

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA

City

Mississauga

Country

Canada

Work hours/week

37.5

Employment Type

Full time

Platform

INSURANCE

Job Type

Regular

Pay Type

Salaried

Posted Date

2025-11-17

Application Deadline

2025-12-31

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

Lead Data Engineer

Job Type