Manager, Portfolio Reporting and Analysis

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

Additional Job Details

Address:

City:

Country:

Work hours/week:

Employment Type:

Platform:

Job Type:

Pay Type:

Posted Date:

Application Deadline:

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.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

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.