Senior Business System Analyst

Analyzes information technology (IT) requirements in business processes, through requirements elicitation, solutions identification, risk analysis and collaboration across (IT) teams. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.

What is the opportunity?

Business Systems Analyst

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

• Eliciting the requirements needed to carry out business processes including interviews, intelligence analysis and survey assessments.

• 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

• Ability to run small to medium enhancement projects independently by creating work breakdown structures, estimating efforts and executing the project within the prescribed timelines.

• Translating business needs, processes and procedures into a workable system, and articulating on specific software requirements by communicating about these requirements with technology experts and business stakeholders.

• Provide third line production support.

What do you need to succeed?

Must-have

• 7+ years of experience as a Business Systems Analyst.

• Data mapping experience using various file formats including but not limited to excel, csv, xml, txt flat file etc.

• Excel macros and pivot tables, Confluence, strong 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.

  • Strong communication and interpersonal skills with the ability to collaborate effectively across teams.

  • Ability to manage multiple priorities and thrive in a fast-paced, dynamic environment.

  • Excellent analytical and problem-solving skills with a keen attention to detail

Nice-to-have

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

• Experience with Unix, Windows user groups provisioning and access control.

• Automated testing experience

• Experience with Agile methodologies and practices.

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

696733460

#LI-Hybrid

#LI-POST

#TechPJ

Job Skills

Agile Methodology, Business, Business Data Analysis, Business Needs, Business Process Modeling, Business Systems, Communication, Critical Analysis, Critical Thinking, Critical Thinking Problem Solving (Inactive), Decision Making, Functional Requirements, Group Problem Solving, Information Technology (IT), Information Technology Applications, Interpersonal Relationship Management, Oral Communications, Requirements Analysis, Software Requirements, System Specifications, System Testing, Written Communication

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTORONTOCanada37.5Full timeCAPITAL MARKETSRegularSalaried2024-07-252024-12-31

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above