Job Description

What is the opportunity? 

The Supervisory Control Technology sits within the Global Operations, Credit & Supervisory Controls Technology team that has complex interactions with technical teams throughout the Capital Markets division and wider RBC organization. The group is organized globally with a reporting line into the group head in Toronto.

Within Supervisory Control Technology the Capital Markets Access Control (CMACS platform) supports the Application Access Requests, Authorizations, Provisioning and Reconciliation as part of the regulatory requirement of managing the access control mechanism

If you have technical business system analysis background, and want to apply your technical and functional skills in the aforementioned area then this is a great opportunity to join our high performance and agile team to realize your potential and gain valuable experience through the exciting and innovative technical solutions the team builds.

What will you do?

Requirements Analysis, Requirements Elicitation/Management/ Documentation skills
Advanced level of facilitation and interviewing skills for running business requirements workshops
Advanced knowledge of Application test planning and execution
Knowledge of Data warehousing  and reporting concepts
Understanding  of business process as well as  relational/dimensional data modeling concepts
Understanding of RDBMS concepts and SQL knowledge
Knowledge of SDLC methodologies
Ability to run small to medium enhancement projects independently by creating work breakdown structures, estimating efforts and executing the project within the prescribed timelines.
Provide third line production support

What do you need to succeed?

Must-have

Data mapping experience using various file formats including but not limited to excel, csv, xml, txt flat file etc.
Experience with Unix, Windows user groups provisioning and access control
Excel macros and pivot tables, Confluence, SQL experience and be able to write medium complexity queries
Be able to perform dual role of Business Systems Analyst and QA using available BA/QA tools
Very good documentation skills including but not limited to Technical Design Document, Extract Agreements between source and target data owners, Data Mapping, Detailed Requirement Specifications, visio diagrams, use cases etc.

 Nice-to-have

- Previous industry experience specific to Access Control, Requisitioning and Provisioning of the access.

- Automated testing experience

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.

- Work on technically challenging and intellectually stimulating projects, where you can stretch your technical skills and apply cutting edge technologies to provide solutions to interesting business requirements

- Opportunity to learn and develop your technical skills by joining a team of high achievers which is friendly and always willing to help each other and share knowledge

- Join team with very good track record of successful delivery of challenging projects, with leadership that strives to ensure everyone contributes to team success and get recognized for their effort and contribution

- Good work/life balance
 

RBC requires as a condition of employment that all successful candidates in the United States and Canada be fully vaccinated against COVID-19 prior to their start date, and may require proof of the same.  Reasonable accommodation is available where required by law