Skip to main content

Description

This is an opportunity for a Lead Data Engineer on the Insurance Data Lake team at Royal Bank of Canada. The role involves leading a high-performing team, driving innovation, and making a significant impact within the Insurance Data Lake team. The Lead Data Engineer will be responsible for technical expertise, leadership, and strategic thinking, ensuring data systems meet organizational needs, fostering collaboration, and enabling data-driven decision-making.

What We're Looking For

Lead, mentor, and guide a team of data engineers, fostering a culture of collaboration, innovation, and continuous learning.,Provide technical guidance and support to team members, helping them solve complex problems and grow their skills.,Perform analysis on structured, unstructured, and semi-structured raw data, utilizing programming skills to standardize and organize data.,Design and implement scalable, reliable, and efficient data pipelines and workflows.,Stay updated on emerging technologies and tools in data engineering, such as cloud platforms (AWS, Azure, GCP), big data frameworks (Hadoop, Spark), and modern data platforms (Snowflake, Databricks).,Evaluate and recommend tools, frameworks, and technologies to improve data engineering processes.,Ensure data systems are optimized for performance, scalability, and security.,Identify, source, staging, and modeling internal process improvements to automate manual processes and optimize data delivery for greater scalability, as part of the end-to-end data lifecycle.,Oversee the integration of data from multiple sources, ensuring data consistency, quality, and accessibility.,Develop ETL/ELT processes to transform raw data into usable formats for analytics and reporting.,Provide consulting services on new initiatives of small to medium complexity.,Support Development for data ingestion and transformation jobs.,Develops and supports Python and SQL code for data ingestion and transformation jobs.,Create IBM JCL and job scheduling documents as needed.,Contribute to successful project completion by identifying risks and developing/recommending mitigation strategies.

Ideal Candidate

7+ years working experience with big data platforms like Cloudera/Snowflake/Hadoop, Databases and SQL language.,5+ years working experience with Scripting languages like Spark, PySpark, Shell, Python, IT Standards, Methodologies, Agile, SDLC, Information Security & audit requirements.,Prior experience leading complex projects and technical team.,Working Knowledge with change control tools like GitHub, Helios etc.,Knowledge on creating formal written deliverables and other documentation and ensure design, code and documents are aligned with enterprise direction, principles and standards.,Working knowledge of JCL/Zeke/OMS (Nice-to-have).,Working knowledge of ServiceNow Incident and Change Management (Nice-to-have).,Working knowledge of Helios/GitHub for Source Code Management (Nice-to-have).,Insurance industry knowledge (Nice-to-have).

Hard Skills

Big Data Management
Cloud Computing
Database Development
Data Mining
Data Warehousing (DW)
ETL Processing
Requirements Analysis
Spark
PySpark
Shell
Python
SQL
Cloudera
Snowflake
Hadoop
GitHub
Helios
JCL/Zeke/OMS
ServiceNow Incident and Change Management

Soft Skills

Leadership
Mentoring
Collaboration
Innovation
Continuous Learning
Problem Solving
Strategic Thinking
Group Problem Solving
Quality Management

Work Hours

37.5 hours/week

Benefits

Comprehensive Total Rewards Program (bonuses
flexible benefits
competitive compensation
commissions
stock)
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in a dynamic
collaborative
progressive
and high-performing team
World-class training program in financial services
Opportunities to do challenging work
Opportunities to take on progressively greater accountabilities
Opportunities to building close relationships with clients
Access to a variety of job opportunities across business and geographies.

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.