Senior Analyst, Control Testing Reporting – Global Security

RBC

Senior Analyst for Control Testing Reporting and Operations at RBC. Responsible for translating testing data into actionable insights and ensuring effective communication across teams.

Posted 7/4/2026full-timeToronto • 🇨🇦 CanadaSeniorWebsite

Tech Stack

Tools & technologies

PythonServiceNow

About the role

Key responsibilities & impact

Maintain and update the team's testing schedule, tracking completion status, due dates, and resource assignments across all active engagements
Build and maintain Excel-based dashboards and reporting tools to track testing completion, deficiency counts, aging issues, and remediation progress
Perform data analysis on control testing results to identify trends, recurring failures, and areas requiring deeper investigation
Identify repetitive manual tasks within the testing cycle that are candidates for automation or AI-assisted processing
Support the build-out of automated reporting templates and testing workflows using available tools (Excel macros, Power Query, Python)
Collaborate cross-functionally across risk, compliance, and business functions to gather context and ensure testing priorities are aligned with enterprise risk appetite
Escalate issues, blockers, and opportunities to the Senior Manager and senior leadership

Requirements

What you’ll need

4+ years of experience in IT Risk, IT Audit, technology controls, or a related function within financial services
Bachelor’s degree in information systems, Computer Science, Business, or a related discipline
Advanced Excel proficiency including pivot tables, Power Query, VLOOKUP/XLOOKUP, conditional formatting, and dashboard construction; expertise in designing advanced reporting models
Familiarity with GRC platforms (ServiceNow GRC, RSA Archer, or equivalent) and document management systems
Ability to build and automate recurring management reports, data analytical mindset to identify patterns, and recurring failures
Exceptional communication skills with ability to present findings clearly to business stakeholders and management; strong interpersonal skills
Comfortable translating between technical and business language
Experience producing clear, visually effective reports and management presentations using PowerPoint
Knowledgeable of industry frameworks: COBIT, NIST CSF, ISO 27001, and ITIL
Nice to have: Experience with Python
Advanced knowledge of process automation tools and emerging AI-assisted analytics capabilities
Experience supporting digital transformation initiatives within risk and compliance functions

Benefits

Comp & perks

A comprehensive Total Rewards Program including bonuses and flexible benefits
Competitive compensation
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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data AnalysisExcel MacrosPower QueryPythonDashboard ConstructionVLOOKUP/XLOOKUPConditional FormattingReporting Model DesignProcess Automation ToolsAI-Assisted Analytics

Soft Skills

Exceptional Communication SkillsInterpersonal SkillsAbility to Present FindingsTranslating Technical Language