Senior Manager, Control Testing Reporting and Operations (Global Security)

Royal Bank of Canada•Calgary, AB

16h•Onsite

About The Position

The Senior Manager, Control Testing Reporting and Operations is a strategic role that bridges testing execution with data-driven insights and process. You'll play a key part in the control testing function, responsible for orchestrating the team's testing activities while transforming raw testing data into actionable intelligence.

Requirements

7+ years of experience in IT Risk, IT Audit, or technology controls within the financial services industry, with at least 2 years in a team lead or supervisory capacity
Bachelor’s degree in information systems, Computer Science, Finance, or a related field
Strong understanding of data analytics and governance frameworks; ability to investigate and articulate the "story" behind control testing data—not just what the numbers show, but why patterns emerge; demonstrated capability to translate technical data insights into business-relevant narratives. Note: Control testing execution is not required for this role; expertise in understanding and analyzing the data generated by control testing activities is essential.
Advanced Excel proficiency including pivot tables, Power Query, VLOOKUP/XLOOKUP, conditional formatting, and dashboard construction; expertise in designing advanced reporting models (dashboards, KRI trackers, issue aging reports, testing coverage summaries); ability to build and automate recurring management reports (weekly, monthly, quarterly); data analytical mindset to identify patterns, systemic weaknesses, and recurring failures
Experience with scheduling, resource planning, and team capacity management in a structured program environment
Familiarity with GRC platforms (ServiceNow GRC, RSA Archer, or equivalent) and document management systems
Exceptional reporting and communication skills

Nice To Haves

Advanced knowledge of process automation tools and emerging AI-assisted analytics capabilities
Experience leading or supporting digital transformation initiatives within risk and compliance functions
Professional certifications strongly preferred (CISA, CRISC, CISSP, CIA, or CPA)
Familiarity with one or more industry frameworks (COBIT, NIST CSF, ISO 27001, ITIL)

Responsibilities

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, or RPA)
Prepare and maintain testing trackers, issue logs, and status reports to support team-wide visibility and accountability
Ensure all workpapers, evidence files, and supporting documentation are stored and organized per quality standards
Develop team capability in translating data into compelling narratives; coach team members on how to articulate findings in both technical and business terms for different audiences
Model cross-functional collaboration, represent and escalate issues and opportunities to senior leadership