Technical Lead - Data Platforms

Job Description

What is the opportunity? A key leadership role in application development within Wealth Management Technology, Data Services Canada.

The role will be responsible for proving expertise and oversight in building and maintaining highly efficient next generation Data Management solutions portfolio.

What will you do? You will be required to collaborate with multiple project / program stakeholders, including the Business Units, Project Managers, Architects, Business Systems Analysts, Development, Quality Assurance, IT infrastructure teams and third party vendors.

Provide thought leadership and be responsible for the highly efficient Database design & solutions supporting container application to ensure alignment with programs needs of reusability and simplified integration in to Wealth Management systems and alignment with reference architecture direction.

Design application and Database solutions and provide technical direction while building scalable, high performing reusable solutions

Provide technical direction, anticipate / obtain resolution of issues & implement solutions for the integration of Data projects into Wealth Management’s & RBC’s infrastructure environment

Defines / Supports application SLAs from Database solutions perspective

Provides work estimates using fact / metrics based model with supporting assumptions

Resolves complex issues and conflicts (including architectural direction vs project constraints); escalates to executive level where required

Provide leadership and oversight to small technical team

What do you need to succeed? Must-have :

10+ years of proven working expertise with enterprise grade Database systems such as SQL Server, Sybase, Oracle. Hands on working experience with distributed in-memory DB (MemSQL(SingleStore), Mongo DB, Casandra etc.

or other massive parallel processing (MPP) DB.

Highly proficient with recent experience in query profiling, query optimization, performance monitoring, tuning in-memory DB and relational database.

Strong technical knowledge of database architecture, distributed data storage and management principles, with experience using related technologies.

Strong knowledge of ETL solutions IBM DataStage and custom ETL solutions

Proven project participation and delivery experience in designing and delivering scalable, high performing reusable solutions leveraging databases, setting standards and it’s adoption.

Nice to have :

Highly proficient hands-on recent experience of 5+ years in delivering API based solutions deployed on OpenShift / Azzure, streaming solutions using Kafka and Java based solutions utilizing distributed in-memory DB (MemSQL, Mogo DB, Casandra etc), enterprise grade Database systems (SQL Server, Sybase, Oracle)

Working knowledge of Snowflake

Working knowledge of Clustering for sharing storage and replication / availability / monitoring solutions for databases.

Familiarity with any Cloud Technologies is an added advantage

Working knowledge of implementing monitoring and dashboard solutions leveraging ELK

Prior experience participating in Generative AI engagements.

Proven experience of managing / guiding technical team(s), including vendor teams

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

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

LI-Hybrid#LI-Post#LI-KAS#TechPJ 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 :

347 58 AVE SE : CALGARY

City : CALGARY

CALGARY

Country : Canada

Canada

Work hours / week : 37.5

37.5

Employment Type : Full time

Full time

Platform :

Technology and Operations

Job Type : Regular

Regular

Pay Type : Salaried

Salaried

Posted Date : 2024-05-17

2024-05-17

Application Deadline :

2024-06-07

I nclusion 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.