What is the opportunity?

This role is responsible for creating data-based detective controls to mitigate regulatory compliance and financial reporting risks. As a PB & CB Data Subject Matter Expert (SME), it contributes to defining detailed requirements for automated preventative controls in regulatory projects across multiple lines of business. The role also establishes data parameters for data visualization monitoring tools, enabling lines of business to track the effectiveness of their regulatory controls.

As the P&BCB Data SME, this position collaborates closely with the Chief Data Office, PB &CB Data Management Office, and Risk Data Management Office to ensure the accuracy of data lineage.

What will you?

• Develop incisive, meaningful and effective data monitoring controls to enable lines of business to assess regulatory risk and make informed portfolio decisions.

• Create data control queries to validate financial data accuracy for downstream reporting (e.g., IFRS9, Regulatory Capital, disclosures).

• Coordinate tool development for data calculation/replication, back-test data accuracy, and validate accuracy of rules.

• Ensure proper data fields are being mapped, review profiles of distribution against expectations, and resolve discrepancies.

• Identify and investigate data-related issues stemming from policy, procedure, or system gaps.

• Establish a governance framework to maintain regulatory findings, reporting, and data access for file reviews.

• Enhance reporting quality, consistency, and accuracy for management and regulatory stakeholders.

• Implement a quality assurance framework for all controls to uphold data integrity and accuracy, while driving continuous improvement through analytics and stakeholder presentations.

What do you need to succeed?

Must have:

• Exposure to control testing frameworks/processes with understanding of control design and documentation

• 2+  years relevant work experience; working knowledge of retail/business banking products and understanding of banking industry policies/procedures

• Strong expertise in data querying tools ( SQL, Python) and knowledge of Teradata/DB2; technologically adept with Microsoft Suite (Excel, Word, PowerPoint), WebEx, and emerging technologies

• Proven analytical/problem-solving skills; ability to summarize data into meaningful results (Tableau knowledge an asset)

• University degree in quantitative field (Statistics, Mathematics, Computer Science, etc.)

• Strong communication skills (written/verbal); collaborative mindset with ability to operate effectively in both business and technical environments

Nice to have:

•  Knowledge of SAS

• Experience in Operational Risk, Audit, or Compliance role, with proven ability to identify, assess, and mitigate risks associated with internal controls

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.

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

Job Skills

Additional Job Details

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

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.