Assist in Transaction Testing cycles; request and review source document based on the scope of the test working with first, second and third line of defense.
Assist in collaborating with Business Stakeholders to ensure the SDDT Directory is understood and maintained.
Ensure Service Level Agreements (SLAs) with our stakeholders are adhered too during transaction testing and report on SLA metrics.
Develop knowledge of the Regulatory Reports and RBC Product Classes become a valuable team resource.
Assist with project work as required (e.g. regulatory deliverables).
Review and Maintain the effectiveness of Business Processes.
Maintain the SDDT Directory by leveraging CDE Memo updates/refreshes.
Assist in the maintenance of documented processes and procedures to support SDDT Directory and its processes.
Identify and communicate options to optimize SDDT processes.
Collaborate with source document providers and consumers to stay current on source document requirements.
Collaborate with other Data Management Offices, Data Custodians and Data Stewards to understand regulatory reporting standards and best practices.
Promote the Source Data and Document Traceability Directory as required.
Requirements
3+ years of relevant professional experience in an analyst or data-focused role
Experience handling and deriving information from large data sets
Strong written and verbal communication skills coupled with the ability to communicate effectively with both business and technology staff at different levels of seniority
Understanding of retail and commercial banking products, policies, processes, and procedures
Ability to work independently with general supervision/oversight to achieve short-term (daily/weekly/monthly) performance expectations
Strong ability to utilize the Microsoft Suite of tools (PowerPoint, Word, Excel)
Bilingualism (English and French) required, as you will regularly do business with RBC partners and/or employees across Canada with English and French speaking needs.
Familiarity with data manipulation and analysis tools such as Excel, Visio, SQL, Python, etc.
Familiarity with data governance and metadata management tools such as Collibra.
Familiarity with agile methodology and agility tools such as Jira.
Tech Stack
Python
SQL
Benefits
A comprehensive Total Rewards Program including bonuses and flexible benefits
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in an agile, collaborative, progressive, and high-performing team
The opportunity to interface with executives from many different parts of the organization