Manager, Portfolio Reporting and Analysis

RBC; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Total rewards program

Flexible benefits

Career development

Job summary

RBC in Toronto is seeking an analytical and detail-oriented Manager to join the COO Group in a newly created Reporting and Analysis role. You will develop comprehensive management reports and interactive dashboards to support decision-making across the organization.

Lead data extraction, ETL, and visualization initiatives, collaborating with business units and IT to deliver actionable insights and improve data-driven decision making.

Qualifications

• Bachelor’s degree in Business Administration, Finance, Data Analytics, Computer Science, or related field.
• Minimum 3 years of experience in business intelligence, data analysis, or management reporting.

Responsibilities

• Design, develop, and maintain management reports and interactive dashboards to support COO Group initiatives.
• Lead data collection strategies, governance, and automated reporting processes.
• Execute complex ETL from multiple source systems ensuring data integrity across platforms.
• Create data visualizations and insights for senior leadership and stakeholders.
• Collaborate with business units and IT to translate requirements into technical specifications.

Skills

Advanced Excel

SQL

Database management

Tableau

Power BI

QlikSense

Data visualization

Python

R

SAS

Education

Bachelor’s degree in Business Administration, Finance, Data Analytics, Computer Science, or related field

Tools

Tableau

Power BI

QlikSense

Python

R

SAS

Job description

Job Description

What is the opportunity?

We are seeking an analytical and detail-oriented Manager to join our COO Group in a newly created Reporting and Analysis role.

This position is essential for developing comprehensive management reports and interactive dashboards that support strategic decision-making across the organization. The incumbent will lead data gathering, extraction, transformation, and visualization initiatives, partnering closely with various business units to deliver actionable insights and enhance data-driven decision making capabilities.

What will you do?

• Management Reporting & Dashboard Development: Design, develop, and maintain comprehensive management reports and interactive dashboards to support COO Group strategic initiatives, operational performance monitoring, and executive decision-making processes
• Data Strategy & Architecture Planning: Lead the development of data collection strategies and reporting frameworks, establishing data governance standards, quality controls, and automated reporting processes to ensure accuracy and timeliness of management information
• Data Extraction & ETL Process Management: Execute complex data extraction, transformation, and loading (ETL) processes from multiple source systems, ensuring data integrity, consistency, and accessibility across various reporting platforms and business intelligence tools
• Analytics & Data Visualization: Create compelling data visualizations and analytical insights using advanced analytics tools, translating complex datasets into clear, actionable business intelligence for senior leadership and stakeholder consumption
• Cross-Functional Partnership & Requirements Gathering: Collaborate with business units, IT teams, and stakeholders to identify reporting requirements, gather business intelligence needs, and translate functional requirements into technical specifications and reporting solutions
• Process Improvement & Automation: Drive continuous improvement initiatives to streamline reporting processes, implement automation solutions, and enhance operational efficiency while reducing manual effort and improving data accuracy
• Quality Assurance & Data Validation: Establish and maintain robust quality assurance frameworks for all reporting deliverables, including data validation procedures, error detection protocols, and remediation processes to ensure report accuracy and reliability
• Technology Innovation & Tool Optimization: Evaluate, implement, and optimize business intelligence tools and reporting technologies, staying current with industry best practices and recommending system enhancements to support evolving business needs

What do you need to succeed?

Must-have:

Education & Certifications

• Bachelor’s degree in Business Administration, Finance, Data Analytics, Computer Science, or related field
• Minimum 3 years of experience in business intelligence, data analysis, or management reporting

Technical Skills

• Proficiency in advanced Excel, SQL, and database management systems
• Experience with business intelligence tools (Tableau, Power BI, QlikSense, or similar platforms)
• Strong knowledge of data visualization principles and dashboard design best practices
• Familiarity with programming languages (Python, R, SAS) and statistical analysis tools

Leadership & Communication

• Proven project management experience with ability to manage multiple reporting initiatives simultaneously
• Strong analytical and problem-solving skills with attention to detail and accuracy
• Excellent written and verbal communication skills with ability to present complex data insights to senior audiences
• Experience working in cross-functional teams and managing stakeholder relationships

Nice-to-have:

• Experience in financial services or banking industry reporting requirements
• Knowledge of regulatory reporting frameworks and compliance requirements
• Certification in data analytics (Certified Analytics Professional) or project management (PMP)
• Experience with cloud-based analytics platforms and data warehousing solutions

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, commissions, and stock where applicable.
• Leaders who support your development through coaching and managing opportunities.
• Work in a dynamic, collaborative, progressive, and high-performing team.
• Flexible work/life balance options.
• Opportunities to building close relationships with clients.
• Access to a variety of job opportunities across business and geographies.

Job Skills

Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Quantitative Research, Research Documents

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-08-12

Application Deadline:

2026-08-26

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.