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:

2026-02-28

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

Compensation for this position (including salary and discretionary/variable payments) will be determined by factors, including but not limited to candidate's experience, skills, registration status, performance, individual goals, market conditions, and business needs.

Pay Range

The expected pay range for this position is:

$105,000.00 - $155,000.00

The pay range provided is for the primary work location referenced in the Additional Job Details section of this job posting. Pay ranges may differ based on location. If the posting lists multiple job locations, a recruiter can confirm availability of the role and the relevant pay rage for the additional locations listed. RBC supports pay transparency and we strive to ensure all pay ranges are competitive, fair, and equitable.

You have the potential to earn RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided that business meets its performance targets and you meet your individual goals.

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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.