Technical Lead - Data Platforms

Job Summary

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

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

Technology and Operations

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

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.