Top Benefits
About the role
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
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.
Top Benefits
About the role
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
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.