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
Collaborate with Business Stakeholders to ensure the SDDT Directory is understood and maintained
Ensure Service Level Agreements (SLAs) with our stakeholders are adhered to 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)
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
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