Manager, Business Risk Data Solutions

RBC; Toronto; On-site; CAD 110,000 - 145,000; Full time

Job summary

RBC in Toronto is seeking an experienced professional to design, develop, and implement automated, data-driven QA and control testing solutions within Personal and Commercial Banking Operations. You will architect scalable data infrastructure and automation capabilities, translating manual control activities into auditable automated workflows.

The role emphasizes end-to-end automation, data quality, and documentation, with collaboration across risk, control, and technology teams to enhance

Qualifications

• 4–7 years of experience with data automation or quality assurance in banking or financial services operations.
• ETL and big data modeling capabilities with SQL, Python, SAS, or similar languages.
• Experience with R, Hadoop (HIVE), Datameer, Teradata, Snowflake, or similar big data tools.
• Proven ability to design and implement automated validation logic, data pipelines, and continuous monitoring frameworks.
• Strong technical documentation skills; ability to articulate complex automation architecture and control logic to non-technical stakeholders.
• Familiarity with RBC systems, applications, and enterprise data warehouses; proficiency with MS Office suite.

Responsibilities

• End-to-end design and development of automated QA and control testing solutions, including requirements gathering with operational and risk partners, technical architecture, data source integration, and implementation of automated validation logic.
• Translate manual QA procedures, control testing checklists, and compliance verification activities into automated data pipelines and continuous monitoring logic; scope and prioritize high-impact manual processes for automation.
• Design and maintain scalable data infrastructure supporting automated controls; ensure data quality, accuracy, and auditability of automated control results.
• Develop comprehensive technical documentation including solution specifications, data lineage, automated test logic, exception handling frameworks, and control validation rules.
• Conduct testing and validation of new automated solutions and enhancements; establish regression testing protocols to ensure sustained control effectiveness.
• Account for project scope, timeline estimates, and resource requirements; manage stakeholder communication on solution delivery and issue escalation.
• Build ETL pipelines and data automation workflows using advanced programming capabilities (SQL, Python, SAS, Snowflake, RBC Assist, or equivalent); leverage big data modeling techniques and tools where appropriate.
• Monitor automation effectiveness and control design; recommend enhancements to increase control sensitivity or reduce false positives.
• Build partnerships across operational risk, control, and technology teams to gather best practices and address barriers to automation adoption.

Skills

Data automation

Quality assurance

ETL

SQL

Python

SAS

Snowflake

Datameer

Hadoop

Teradata

Data pipelines

Documentation

Tools

MS Office

RBC Assist

Job description

Job Description

What is the opportunity?

You will design, develop and implement automated, data-driven solutions that minimize manual quality assurance and control performance testing activities in Personal and Commercial Banking Operations. You will also architect scalable data infrastructure and automation capabilities that translate procedural control activities into continuous, data-driven validation frameworks. This role focuses on control effectiveness through technology converting labor-intensive manual processes into robust, auditable automated solutions that reduce human error, improve control coverage, and free operational teams to focus on exception management and risk mitigation.

What will you do?

• End-to-end design and development of automated QA and control testing solutions, including requirements gathering with operational and risk partners, technical architecture, data source integration, and implementation of automated validation logic
• Translate manual QA procedures, control testing checklists, and compliance verification activities into automated data pipelines and continuous monitoring logic; scope and prioritize high-impact manual processes for automation
• Design and maintain scalable data infrastructure supporting automated controls; ensure data quality, accuracy, and auditability of automated control results
• Develop comprehensive technical documentation including solution specifications, data lineage, automated test logic, exception handling frameworks, and control validation rules
• Conduct testing and validation of new automated solutions and enhancements; establish regression testing protocols to ensure sustained control effectiveness
• Account for project scope, timeline estimates, and resource requirements; manage stakeholder communication on solution delivery and issue escalation
• Build ETL pipelines and data automation workflows using advanced programming capabilities (SQL, Python, SAS, Snowflake, RBC Assist, or equivalent); leverage big data modeling techniques and tools where appropriate
• Monitor automation effectiveness and control design; recommend enhancements to increase control sensitivity or reduce false positives
• Build partnerships across operational risk, control, and technology teams to gather best practices and address barriers to automation adoption

What will you need to succeed?

Must-have:

• 4–7years experience with data automation, or quality assurance within banking or financial services operations
• Demonstrated ETL and big data modeling capabilities with advanced programming experience using SQL, Python, SAS, or similar languages
• Experience with R, Hadoop (HIVE), Datameer, Teradata, Snowflake, or similar big data tools
• Proven ability to design and implement automated validation logic, data pipelines, and continuous monitoring frameworks
• Strong technical documentation skills; ability to articulate complex automation architecture and control logic to non-technical stakeholders
• Familiarity with RBC systems, applications, and enterprise data warehouses; proficiency with MS Office suite

Nice-to-have:

• Experience in operational risk, control management with a solid understanding of control design principles, manual control testing methodologies, and audit/compliance requirements
• Experience with ORMS or similar control management systems
• Background in internal audit or risk management functions
• Knowledge of ICMP/ICMS frameworks
• Project management experience

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.

• Make a meaningful impact on RBC’s risk management and control environment
• Leaders who support your development through coaching and managing opportunities
• Develop expertise in enterprise risk governance and internal controls
• Work with cross-functional teams across the organization
• Contribute to maintaining RBC’s reputation for strong governance and risk management
• Opportunity to grow in a dynamic, evolving risk landscape
• Work in a dynamic, collaborative, progressive, and high-performing team

Job Skills

Business Case Design, Communication, Critical Thinking, Effectiveness Measurement, Financial Regulation, Interpersonal Relationship Management, Product Development Lifecycle, Product Development Methodology, Product Services, Results-Oriented

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

PERSONAL & COMMERCIAL BANKING

Job Type:

Regular

Pay Type:

Salaried

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.