Portfolio Insights & Analytics Manager

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

Benefits offered by this job

Total Rewards Program

Flexible benefits

Stock where applicable

Job summary

RBC in Toronto seeks a data-driven Manager to join the COO Group in a Reporting and Analysis role. You will build management reports and interactive dashboards, lead data extraction, transformation, and loading, and partner with business units to translate requirements into actionable insights.

The role emphasizes data governance, automation, and advanced visualization to support executive decision-making and strategic initiatives within a complex organization.

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

• 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

Job description

RBC in Toronto seeks a data-driven Manager to join the COO Group in a Reporting and Analysis role. You will build management reports and interactive dashboards, lead data extraction, transformation, and loading, and partner with business units to translate requirements into actionable insights.

The role emphasizes data governance, automation, and advanced visualization to support executive decision-making and strategic initiatives within a complex organization.