Lead Data Engineer

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

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGAMississaugaCanada37.5Full timeINSURANCERegularSalaried2025-11-172025-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.