Risk Analytics Lead — IT Metrics & Reporting

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

Benefits offered by this job

Total rewards program including bonus

Bonuses and flexible benefits

Career development opportunities

Job summary

RBC in Toronto is seeking a Senior Analyst, IT Risk Analytics & Reporting to transform risk data into actionable insights and scalable reporting solutions across technology risk metrics.

You will bridge stakeholders, design data models, write optimized SQL, validate data, and govern metric lifecycles. This role blends risk management, data analytics, and business strategy within a collaborative team.

Qualifications

• 3+ years working with SQL, data modeling, or data analytics.
• 3+ years translating business requirements into technical solutions.
• Proficiency querying relational databases; MongoDB experience preferred.
• Experience troubleshooting data quality issues and reconciling data across systems.
• Advanced SQL: data extraction, transformation, and validation.
• Data modeling: relational and non-relational schemas.

Responsibilities

• Risk Metrics & Reporting- Support development, enhancement, and governance of enterprise technology risk metrics, KPIs, and KRIs.
• Data Modeling & SQL- Design and validate data models; write and optimize SQL queries for large datasets.
• Investigate data, reporting, and metric issues through structured SQL analysis.
• Validate data accuracy against business requirements.
• Build relationships across business, technology, data, and risk teams.
• Present data-driven findings and recommendations in business language.
• Create Confluence-based visualizations and leadership reporting assets.
• Enhance and maintain reporting infrastructure.

Skills

SQL

Data modeling

Data analytics

translating requirements

Analytical reasoning

Communication skills

Tools

MongoDB

Tableau

Job description

RBC in Toronto is seeking a Senior Analyst, IT Risk Analytics & Reporting to transform risk data into actionable insights and scalable reporting solutions across technology risk metrics.

You will bridge stakeholders, design data models, write optimized SQL, validate data, and govern metric lifecycles. This role blends risk management, data analytics, and business strategy within a collaborative team.