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.
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.
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).
Bachelor's Degree
37.5 hours/week
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.
BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.