City : CALGARY, Alberta, Canada

Category : Technology | Analytics | Research

Industry : Financial/Banking

Employer : RBC

Technical Lead Data Platform & Services (Data Services)

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, act as the prime subject mapper expert and be responsible for delivering highly efficient Data and Services design solutions across multiple projects

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

• Provide centralized support for the overall API Specification, API Book of record, strategy and blueprint, build and maintain the API Specification data library, master data and metadata. Create the API Specification ontology, taxonomy schema, classification methodology to support the domain APIs.

• Conduit to front facing business/other stakeholders to understand their data services needs across all initiatives for planning and prioritization, decomposing business requirements and translates them into detailed design specifications and code.

• Provides work estimates using fact/metrics based model with supporting assumptions; Assesses the costs and benefits for different solutions and recommend/decide on appropriate designs

• Ensures code is reviewed, reusable and testable, meeting architectural-design and customer requirements; accountable for overall code quality.

• Help builds solutions that are supportable, scalable and achieve our aspiration of common assets.

• Stays abreast of industry technical and business trends through participation in professional associations, practice communities & individual learning; Provide leadership and oversight to small technical team

What do you need to succeed?  

Must-have:

• Expert level knowledge and highly proficient hands-on recent experience of 5+ years in delivering API based solutions (SpringBoot) deployed on OpenShift/Azzure, streaming solutions using Kafka and Java based solutions utilizing distributed in-memory DB (MemSQL, MariaDB, MySQL), DBMS(SQL Server, Sybase, Oracle);​Expert knowledge of designing and building solution using GraphQL; Excellent knowledge of designing streaming solutions using Kafka

• Expert level experience in understanding data services needs and translating them into re-usable design patterns for application data. Strong knowledge of schema-first design and development, and creating detailed design specifications.

• Knowledge of API best practices, performance tuning and three-legged OAuth processing, session Management, OpenID/OICD and federation

• Proven project participation and delivery experience while designing and delivering scalable, high performing reusable services and database solutions

• Highly proficient with recent experience in query profiling, query optimization, performance monitoring, tuning in-memory DB and relational database; Expert level knowledge of implementing monitoring and dashboard solutions, preferably leveraging ELK

Nice to have:

• At least 2 years of experience in implementing API Security and Access Control (OAuth/SAML, Web SSO, SSL etc.)

• Knowledge of build and deployment methodologies with Apigee across environments

• Proven working experience in distributed in-memory DB (MemSQL(SingleStore), Mongo DB, Casandra etc.) or other massive parallel processing (MPP) DB. And proven expertise working with enterprise grade Database systems such as SQL Server, Sybase, Oracle 

• Ability to architect and implement end-to-end container management

• Experience in architecting solutions for computing and containerization ( like ASE, Docker, AKS, VMs, Functions etc.), Database and CI/CD.

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