Manager, Analytics & Reporting

What is the opportunity?

Manages all aspects of organizational data; establishes and maintains policies and procedures for planning, designing and maintaining an information bank to ensure that data services are delivered in a high-quality and profitable manner. Manager with HR responsibility. Typically manages and oversees supervisors and/or hourly/professional jobs and responsible for setting the overall direction for employees.

What will you do?

• Providing senior leadership, direction and methodology for analysis, structure and storage of critical organizational data.
• Monitoring and reviewing major organizational activities and goals to ensure important data needs are anticipated, and met.
• Overseeing the integrity and maintenance of organizational data.
• Reviewing and recommending policies and procedures for collecting and managing organization data.

What you need to succeed?

Education &/or Experience Required

• Completion of an applicable university degree and/or relevant professional designation with a minimum of two years of experience in Python, R and or other programming languages
• Solid understanding of data management practices
• Advanced Excel Skills
• Analyze large data sets using pivot tables and pivot reporting
• Ability to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and audit
• Build macros using VBA (Visual Basic for Applications)
• Ability to structure and present data for reporting using conditional formatting, tables and charting
• Intermediate SQL skills
• Understanding and usage of SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions
• Understanding and usage of update and insertion statements and syntax for altering and creating structures
• Can generate complex data reports using GROUP BY and aggregate functions
• Understands SQL concepts of foreign keys, transactions, triggers, and stored procedures
• Excellent communication skills – written and oral
• Strong troubleshooting and problem solving skills

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
• Leaders who support your development through coaching and managing opportunities 
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work

#LI-KA2

Job Skills

Big Data Management, Critical Thinking, Data Administration, Data Governance, Data Movement, Data Warehousing (DW), Information Capture, Knowledge Organization, Long Term Planning, Repository Tools

Additional Job Details

90 WESTERN PKY:BEDFORDBedfordCanada37.5Full timeCAPITAL MARKETSRegularSalaried2026-03-262026-04-09

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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.