Skip to main content
Full-Time
On-Site

Senior Business Systems Analyst

View on Map

Description

RBC is seeking a Senior Business Systems Analyst for the Global Operations, Credit & Supervisory Controls Technology team, specifically within Supervisory Control Technology. This role involves working with the Capital Markets Access Control (CMACS platform) to manage application access requests, authorizations, provisioning, and reconciliation. The ideal candidate will apply technical and functional skills in an an agile environment to build innovative technical solutions.

What We're Looking For

Key responsibilities include requirements analysis, elicitation, management, and documentation. This involves conducting interviews and surveys, running small to medium enhancement projects, and translating business needs into system requirements. Must-have skills include 5-7+ years of experience as a Business Systems Analyst with advanced knowledge of application test planning and execution, data warehousing, reporting concepts, business processes, and relational/dimensional data modeling. Strong understanding of RDBMS concepts, SQL, data mapping using various file formats, Excel macros, pivot tables, and Confluence is required. The ability to perform dual roles of Business Systems Analyst and QA, coupled with strong documentation, communication, interpersonal, analytical, and problem-solving skills, is essential.

Ideal Candidate

Must-have: 5-7+ years of experience as a Business Systems Analyst, advanced knowledge of Application test planning and execution, knowledge of Data warehousing and reporting concepts, understanding of business process and relational/dimensional data modeling concepts, understanding of RDBMS concepts and SQL knowledge, data mapping experience, Excel macros and pivot tables, Confluence. Nice-to-have: Previous industry experience specific to Access Control, Requisitioning and Provisioning of access, experience with Unix, Windows user groups provisioning and access control, automated testing experience, experience with Agile methodologies and practices.

Hard Skills

Application test planning and execution
Data warehousing
Reporting concepts
Business process modeling
Relational data modeling
Dimensional data modeling
RDBMS
SQL
Data mapping
Excel macros
Pivot tables
Confluence
QA tools
Technical Design Document
Extract Agreements
Data Mapping
Detailed Requirement Specifications
Visio diagrams
Use cases
Unix
Windows user groups provisioning
Automated testing
Agile methodologies

Soft Skills

Communication
Interpersonal skills
Collaboration
Managing multiple priorities
Analytical skills
Problem-solving skills
Attention to detail
Critical Analysis
Critical Thinking
Decision Making
Group Problem Solving
Written Communication
Oral Communications

Work Hours

37.5 hours/week

Benefits

Opportunity to work on technically challenging and intellectually stimulating projects
learn and develop technical skills
join a high-achieving team
good work/life balance
contributions are recognized

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.