Job Summary
Job Description
What is the opportunity?
Data Engineer on the Insurance Development team in Technology & Operations at the Royal Bank of Canada.
We are looking for energetic, dynamic, collaborative, progressive and high performing team member who are highly talented and willing to share and work together.
Our team is looking for a data engineer who is constantly thinking outside the box, ready to dive deep into the smallest details, is passionate about contributing to the successful delivery of his responsibilities.
What will you do?
-
Performing analysis on structured, unstructured, and semi-structured raw data, utilizing programming skills to standardize and organize data.
-
Preparing data using computer languages such as Python and shell scripting
-
Performing data transformations using SQL on SQL server environment. Knowledge of SSIS packages is a plus.
-
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.
-
Developing technologies and data pipelines to enhance the dependability and quality of data.Provides consulting services on new initiatives of small to medium complexity.
-
Supports Development of Python and SQL code 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. Create production change records to deploy code for project.
-
Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies.
What do you need to succeed?
Must-haves:
-
3+ years working experience with Databases and SQL language.
-
3+ years working experience with Scripting languages like Python, C sharp and Shell scripting.
-
IT Standards, Methodologies, SDLC, Information Security & audit requirements.
-
Familiarity with working in Agile environment
-
Familiarity with working 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
Job Skills
Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Python (Programming Language), Quality Management, Requirements Analysis, Software Development Life Cycle (SDLC), Structured Query Language (SQL)
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:
2024-09-05
Application Deadline:
2024-09-20
Inclusion and Equal Opportunity Employment
At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.
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.
Top Skills
What We Do
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 88,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 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.
