Senior Analyst, IT Risk Analytics & Reporting (Global Security)

RBC; Toronto; On-site; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Total rewards program

Job summary

RBC is seeking a Senior Analyst, IT Risk Analytics & Reporting in Toronto to transform complex business requirements into risk metrics and scalable reporting solutions. You will bridge business stakeholders with technology partners, exploring data to uncover root causes and deliver actionable insights.

The role focuses on risk metrics governance, data modeling, SQL development, and creating leadership reporting assets to support enterprise technology risk decisions.

Qualifications

• 3+ years working with SQL, data modeling, or data analytics.
• 3+ years translating business requirements into technical solutions.
• Proficiency querying relational databases and understanding database architecture - MongoDB experience is preferred.
• Experience troubleshooting data quality issues and reconciling data across systems.
• Demonstrated ability to analyze complex data and develop actionable recommendations.
• Advanced SQL: query optimization, data extraction, transformation, and validation.
• Data modeling: conceptual and logical design; understanding of relational/non-relational schemas.
• Strong analytical reasoning and problem-solving mindset.
• Strong communication skills.

Responsibilities

• Develop, enhance, and govern enterprise technology risk metrics, KPIs, and KRIs.
• Design and validate data models; write and optimize SQL queries for large datasets.
• Explore data to identify structures, anomalies, and reconcile across systems.
• Troubleshoot data quality issues and document findings for resolution.
• Translate complex requirements into functional specifications; define data outputs and rules.
• Manage metric lifecycle with data owners: intake, development, enhancement, retirement.
• Build data-driven visuals and leadership reporting assets; present findings in business terms.

Skills

SQL

Data modeling

Data analytics

translating requirements

Relational databases

Advanced SQL

Analytical reasoning

Communication skills

Tools

MongoDB

Tableau

Python

Job description

Job Description

As the Senior Analyst, IT Risk Analytics & Reporting, you work with data enhancement, and governance of enterprise technology risk metrics. This role serves as a critical bridge between business stakeholders, technology partners—transforming complex business requirements into meaningful risk metrics, actionable insights, and scalable reporting solutions.

This is not a documentation role. The ideal candidate explores data, challenges assumptions, and navigates ambiguity to uncover root causes and deliver practical solutions. This position offers a unique opportunity to work at the intersection of risk management, data analytics, reporting, and business strategy while influencing stakeholders.

What will you do?

• Risk Metrics & Reporting- Support the development, enhancement, and governance of enterprise technology risk metrics, KPIs, and KRIs
• Data Modeling & SQL- Design and validate data models to support risk metrics and reporting objectives. Write and optimize SQL queries to extract, transform, and validate large datasets
• Perform data exploration to understand data structures, relationships, and anomalies, identify and reconcile data discrepancies across multiple systems
• Troubleshoot data quality issues and document findings for resolution
• Risk Metrics & Governance- Analyze metric methodologies, business rules, and reporting requirements, assess metric changes, impacts, and reporting implications
• Manage metric lifecycle (intake, development, documentation, enhancement, retirement) in partnership with data owners
• Translate complex business requirements into clear functional specifications and development-ready requirements
• Define business rules, calculation logic, data requirements, and expected outputs
• Investigate data, reporting, and metric issues through structured SQL analysis
• Validate data accuracy against business requirements
• Identify root causes of discrepancies and develop practical solutions
• Build relationships across business, technology, data, and risk teams
• Clarify requirements, assumptions, and expected outcomes with stakeholders
• Present data-driven findings and recommendations in clear business language
• Create Confluence-based visualizations and leadership reporting assets
• Enhance and maintain reporting infrastructure

What do you need to succeed?

Must have

• 3+ years working with SQL, data modeling, or data analytics
• 3+ years translating business requirements into technical solutions
• Proficiency querying relational databases and understanding database architecture- Mongo DB experience is preferred
• Experience troubleshooting data quality issues and reconciling data across systems
• Demonstrated ability to analyze complex data and develop actionable recommendations
• Advanced SQL: query optimization, data extraction, transformation, and validation
• Data modeling: conceptual and logical design; understanding of relational/ non relational schemas
• Strong Analytical reasoning and problem-solving mindset
• Strong communication skills

Nice to have

• Experience in risk management or governance
• Python or basic automation scripting
• Experience with Machine Learning/AI
• Data visualization tool experience (Tableau)

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.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work
• Opportunities to take on progressively greater accountabilities
• Access to a variety of job opportunities across business

Job Skills

• Confidentiality, Cyber Security Management, Decision Making, Detail-Oriented, Encryption Software, Group Problem Solving, High Impact Communication, Information Security Management, Information Technology Security

Additional Job Details

Address

16 YORK ST:TORONTO

City

Toronto

Country

Canada

Work hours/week

37.5

Employment Type

Full time

Platform

TECHNOLOGY AND OPERATIONS

Job Type

Regular

Pay Type

Salaried

Posted Date

2026-07-17

Application Deadline

2026-10-28

Note

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

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.