Skip to main content
Full-Time
On-Site

Sr. Manager, Reporting & Analytics

View on Map

Description

The Senior Manager, Reporting & Analytics will join the Wealth Management Canada Business Intelligence Team to modernize analytics infrastructure. This involves migrating legacy reporting systems to cloud-based platforms, developing impactful dashboards and reports, and implementing data governance best practices. The role supports strategic transformation and business users across investment advisory, branch management, and head office functions.

What We're Looking For

Lead the migration of reports from legacy SAS systems to Snowflake/Tableau, ensuring seamless transitions.,Conduct discovery sessions with business stakeholders to gather, document, and prioritize reporting and analytics requirements.,Design and build intuitive dashboards and reports for various Wealth Management Canada stakeholders.,Develop deep knowledge of the data landscape, identify authoritative data sources, and provide expertise on data location and accessibility.,Collaborate with business stakeholders, technology teams, and other departments to ensure project deliverables meet requirements and timelines.,Support the timely and accurate delivery of regulatory reports (e.g., CRM3, CIRO).,Create comprehensive documentation, data dictionaries, and knowledge base articles.,Support cloud-first migration from SAS/SQL Server to Snowflake for near real-time analytics.,Support data governance initiatives, including automated validation, data lineage tracking, and metadata management.,Drive adoption of modernized reporting frameworks and monitor end-user engagement.,Identify opportunities to automate reporting and eliminate redundant processes.

Ideal Candidate

7+ years of experience in business intelligence, data analytics, reporting or related field.,Proficiency with BI tools (Tableau, Power BI, or equivalent) and MS Excel.,Experience with SQL and relational databases.,Knowledge of data warehousing concepts and ETL processes.,Strong communication skills and ability to work cross-functionally.,Ability to translate business requirements into technical solutions.,Bachelor's degree in computer science, Data Science, Business, Mathematics, Statistics, or related field.,Experience with Snowflake or cloud data platforms (Nice to Have).,Familiarity with SAS (Nice to Have).,Knowledge of financial services or wealth management industry (Nice to Have).,Understanding of regulatory reporting requirements (e.g., CRM3, CIRO) (Nice to Have).

Minimum Education

Bachelor's Degree

Hard Skills

Business Intelligence tools (Tableau, Power BI)
MS Excel
SQL
Relational databases
Data warehousing concepts
ETL processes
Snowflake (Nice to Have)
Cloud data platforms (Nice to Have)
SAS (Nice to Have)
Business Case Design
Effectiveness Measurement
Financial Regulation
Product Development Lifecycle
Product Development Methodology
Product Services
Waterfall Model

Soft Skills

Communication
Cross-functional collaboration
Critical Thinking
Interpersonal Relationship Management
Results-Oriented

Work Hours

37.5 hours/week

Benefits

Comprehensive Total Rewards Program (bonuses, flexible benefits, competitive compensation, commissions, stock where applicable)
Leaders who support development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
Flexible work/life balance options
Opportunities to do challenging work
Opportunities to take on progressively greater accountabilities
Access to a variety of job opportunities across business and geographies

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.