Senior IT Risk Analytics & Reporting Specialist

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

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.