Lead Data Engineer - Mississauga, Ontario

Job Description · What is the opportunity? · Lead Data Engineer on the Insurance Data Lake team in Technology & Operations at the Royal Bank of Canada. The · Lead Data Engineer · role is an exciting opportunity for a talented and motivated individual to lead a high-performing tea ...

Job description

Job Description
What is the opportunity?
Lead Data Engineer on the Insurance Data Lake team in Technology & Operations at the Royal Bank of Canada. The
Lead Data Engineer
role is an exciting opportunity for a talented and motivated individual to lead a high-performing team, drive innovation, and make a meaningful impact within RBC's Insurance Data Lake team. If you are passionate about data engineering, thrive in a collaborative environment, and are ready to take on new challenges, this role is the perfect fit for you.

What will you do?

• The role of a Lead Data Engineer is multifaceted, requiring a blend of technical expertise, leadership skills, and strategic thinking.
• Responsible for driving the success of data engineering initiatives, mentoring their team, and ensuring that data systems meet the organization's needs.
• Fostering collaboration, innovation, and continuous improvement, a Lead Data Engineer plays a critical role in enabling data-driven decision-making and delivering value to the organization.
• 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.
• Performing 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.
• Identifying, sourcing, 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
• Provides consulting services on new initiatives of small to medium complexity.
• Supports 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. Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies.

**What do you need to succeed?

Must-haves:**

• 7+ years working experience with bigdata 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.

Nice-to-have:

• Working knowledge of JCL/Zeke/OMS.
• Working knowledge of ServiceNow Incident and Change Management.
• Working knowledge of Helios/GitHub for Source Code Management.
• Insurance industry knowledge

What's In It For You
We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• 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
• A 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

Job Skills
Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

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:
TECHNOLOGY AND OPERATIONS

Job Type:
Regular

Pay Type:
Salaried

Posted Date:

Application Deadline:

Note
:
Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
I
*nclusion*
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

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.