Job Description

Come Work with Us!

At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose.

Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work that matters in the world, in an environment built on teamwork, service, responsibility, diversity, and integrity.


















Job Title Data Engineer - Insurance Data Services


















What will you do?

• Insurance Data Lake
• Provides consulting services on new initiatives of small to medium complexity.
• Monitor and act on ServiceNow incident tickets and service requests.
• Supports DataStage and IDP ETL (data ingestion) jobs.
• Supports WebFocus/Tableau reports and extracts.
• Develops and supports Spark, Trino in support of Tableau reporting.
• Create IBM JCL and job scheduling documents as needed.
• Create production change records to deploy code for project or on behalf of other teams.
• Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies.
• A senior team member, providing direction, expertise, feedback, coaching and development to build the capability of more junior staff.
• Continually enhances skills and builds knowledge on Cloudrea platform data technologies.
• Some evening/weekend work required for deployments and DR testing.
• May require off hour support, pager rotation.

What do you need to succeed? Must-haves:

• 3+ years working experience with Databases and SQL language.
• 3+ years working experience with ETL Data Stage and reporting tools.
• Working knowledge of Cloudrea/Trino/Kafka.
• Working knowledge of Python/Spark.
• IT Standards, Methodologies, SDLC, Information Security & audit requirements.
• 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 Appache Zeppelin.
• Working knowledge of ServiceNow Incident and Change Management.
• Working knowledge of Endevor/Github for Source Code Management.
• Working knowledge of WebFocus.
• 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 and competitive compensation
• Leaders who support your development through coaching and managing opportunities
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work

Job Summary This individual partners across various IT groups to assess, research, and resolve system issues and develop new technology solutions that meet sponsor/stakeholder needs. Context is application support plus several concurrent enhancements and small to medium size development projects. The technology portfolio consists of Cloudrea/Spark/Scala/Kafka/Jethro/Tableau, ETL Data Stage Tools and WebFocus.


















Address: MISSISSAUGA, Ontario, Canada


















City: CAN-ON-MISSISSAUGA


















Country: Canada


















Work hours/week: 37.5


















Employment Type: Full time


















Platform: Technology and Operations


















Job Type: Regular


















Pay Type: Salaried


















Posted Date: 2022-08-09-07:00


















Application Deadline: 2022-08-31-07:00



































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 rbc.com/careers.