Job Description

Technical Lead Data Platform & 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.
• Designs solutions, writes code, performs unit testing, develops appropriate artefacts / documentation, and facilitates final delivery.
• Assesses the costs and benefits for different solutions and recommend/decide on appropriate designs.
• Work closely with product managers and integrations team to monitor and manage the progress of feature deployments to production
• Provide relevant acceptance test criteria, work closely with Developers and QA
• Defines/Supports application SLAs from various data services and solutions perspective
• Provides work estimates using fact/metrics based model with supporting assumptions
• 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 experience in understanding  data services needs and translating them into detailed design specifications
• Expert level knowledge and 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)
• 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
• Expert level knowledge of implementing monitoring and dashboard solutions, preferably leveraging ELK
• Highly proficient with recent experience in query profiling, query optimization, performance monitoring, tuning in-memory DB and relational database.

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.