Job DescriptionWhat is the opportunity?As a 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 development along with production support 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 DataStage 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 DataStage P1/P2 production incidents raised by Application users and overnight job failures to ensure closure within SLA.
- Provide on need basis on-call afterhours pager support on rotational basis
- Work closely with agile teams and other stakeholders to support DataStage testing requirements and assist in building data solutions that cater to their needs. Coordinate and perform DataStage 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 projects from start to end
Must Have:- 8+ years 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, StoneBranch and shell scripting
- Experience with tools such as GitHub, Urban Code 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.
- Adaptable and quick to grasp new concepts, even in areas outside of your previous experience
- Understanding of prompt engineering and Gen-AI Development tools(GitHub Copilot, Windsurf)
Nice to have:- Bachelor's degree in Computer Science, Engineering or equivalent
- Knowledge/experience developing with Java, JavaScript, C#, .NET, Python and Cloud technologies(Azure, AWS etc.)
- Knowledge/experience on Kafka, mQueue, Dynatrace, PagerDuty and Apigee
- Insurance and/or Financial Industry experience
- Understanding Automated testing tools, Elastic Search
What's In For You?- 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-POST
#TECHPJ
Job SkillsAgile Methodology, Big Data Management, Cloud Computing, Database Development, Data Engineering, Data Management, Data Mining, Data Modeling, Data Warehousing (DW), ETL Development, ETL Processing, ETL Tools, GitHub, Group Problem Solving, IBM InfoSphere DataStage, Microsoft SQL Server, Python (Programming Language), Requirements Analysis, Unix
Additional Job DetailsAddress: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:2026-05-07
Application Deadline:2026-05-31
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
