Senior Data Engineer (ETL/Datastage Production Support experience)

Job Summary

Job Description

What is the opportunity?

As a support Senior Data Engineer in Insurance Data Engineering Services team within Insurance Technology, you will provide technical application and functional support to the Insurance business. Your focus will be on providing incident management support and ensuring production issues are dealt with and resolved in a timely and efficient manner with minimal impact to business. We are looking for a passionate data management enthusiast with strong data architecture and data engineering skills and leadership, effective written and verbal communication skills, a strong work ethic and a demonstrated capability to multi-task effectively. This role requires a positive attitude and a willingness to take accountability for results achieved.

What will you do?

• You will create, support and maintain ETL application processes and systems within RBC Insurance. It will encompass the data extraction from source application systems via Real-Time/Batch functions, transformation of data to specified formats and load to interfacing application databases/network folders.
• Lead triaging, troubleshooting and resolving of ETL P1/P2 production incidents raised by Application users and overnight job failures to ensure closure within SLA.
• Provide on-call afterhours pager support on rotational basis.
• Work closely with agile teams and other stakeholders to support ETL testing requirements and assist in building data solutions that cater to their needs. Coordinate and perform ETL DR Exercise and application software/hardware migrations.
• Remediate software/hardware vulnerability and compliancy issues, reset Service/Application ID passwords according to RBC standards.
• Create and maintain support artifacts and documentation in Confluence/Jira.
• Lead small projects within maintenance from start to end.

Must Have:

• 3+ years ETL tool experience utilizing IBM Datastage. Experience with Datastage Designer, Datastage Director and Datastage Console.
• 3+ years experience in a Production Support focused function or role.
• Strong Knowledge of IBM DB2 and Microsoft SQL Server, including data modeling, stored procedures and optimization.
• Experience with JCL, Zeke and shell scripting and database backup tools such as Networker.
• Experience with tools such as GitHub, UrbanCode Deploy, ServiceNow and OnDemand.
• Experience working on mainframe, Windows and Unix/Linux environments.
• Technical expertise in the design, development, coding, unit testing and debugging of software.
• Quick learner on areas you never worked on.

Nice to have:

• Bachelor’s degree in Computer Science, Engineering or equivalent.
• Knowledge/experience developing with Java, JavaScript, C#, .NET, Python, Cloud.
• Knowledge/experience on Kafka, mQueue, OpenShift, Dynatrace, SoapUI, PagerDuty and Apigee.
• Insurance and/or Financial Industry experience.

What’s In 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.
• Opportunities to take on progressively greater accountabilities.
• Access to a variety of job opportunities across business and geographies.

#LI-Hybrid

#LI-Post

#LI-PK

Job Skills

Agile Methodology, Big Data Management, Cloud Computing, Database Development, Data Engineering, Data Management, Data Mining, Data Modeling, Data Warehouse ETL, Data Warehousing (DW), ETL Development, ETL Tools, GitHub, Group Problem Solving, Microsoft SQL Server, Requirements Analysis, Unix

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: 2025-04-15

Application Deadline: 2025-04-30

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.

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.