Manager, Business Intelligence & Information Management

Manager, Business Intelligence & Information Management

RBC Regional Banking Support’s Commercial Reporting is hiring a Manager, Business Intelligence & Information Management to support strategic reporting and visual insights for Regional Banking’s Commercial. The role transforms data into actionable information and delivers insights to business partners and senior leaders.

• Utilize cutting edge business intelligence capabilities to optimize business results, define, measure, and deliver insights and mitigate risk.
• Design and develop/enhance innovative reporting solutions to monitor performance management and present key analytical and business insights to support Commercial advisors and leaders.
• Take end‑to‑end responsibility in the development and enhancement of performance metrics and reporting in Tableau.
• Respond to ad‑hoc investigations, inquiries, data, and report requests as assigned.
• Run production jobs as assigned.
• Demonstrate subject matter expertise in data and reporting infrastructure design, configuration and optimization, providing recommendations on approach and execution.
• Apply standard design principles and data visualization techniques to measure key indicators, disclose trends, provide proactive actionable insights, and address business questions.
• Identify appropriate data sources and perform ETL for data modelling, data quality assessments, understand patterns and provide the basis to inform the reporting solution which provides meaningful performance management insights.
• Participate in conversations with internal partners to understand their business strategies and objectives to define/recommend reporting solutions, communicate project status and develop relationships to ensure satisfaction.
• Participate in design and solution review demonstrations with the Senior Manager and/or internal partners at critical tollgates to ensure adherence to requirements, resolve obstacles, while mitigating deployment risk and the need for post‑deployment modifications.
• Test and validate (QA) new and existing reports and analytics for adherence to business and technical requirements.
• Enhance and optimize existing production processes.
• Create and maintain accurate documentation related to reporting solutions, including specifications, data lineage, technical and business definitions for metrics, and test plan/test cases.
• Be a thought partner within the Commercial Reporting team, supporting the developments of insights, processes, data approaches/methodologies and information that is valued by partners across Regional Banking and Commercial.
• Demonstrate a commitment to continuous learning and professional growth, with the ability to adapt to evolving business needs and new analytical methodologies or tools.

• Degree in Computer Science, Mathematics/Statistics, Engineering, related field or equivalent related experience.
• Working experience in both SAS and Tableau.
• Demonstrated ETL and big data modelling capabilities, with programming experience in large databases/datasets and using SAS, SQL Server and Teradata SQL Assistant.
• Experience in statistical methods, strong data profiling, cleaning, and mining.
• Proficient in SQL extracts in order to investigate data from data warehouse and other sources (flat files) for investigation/analysis purposes.
• Ability to perform complex data analysis on large volumes of data and present findings to senior leaders to inform strategic decisions.
• Proven quantitative analytical and problem‑solving skills.
• UNIX knowledge (i.e. submit process, create logs, store data).
• Advanced proficiency in report development using Tableau.
• Experience with cloud computing technologies (Snowflake/Snow Sight & Trino).
• Data knowledge on RBC’s EDW.
• Skilled in Microsoft Office applications (Excel, PowerPoint, Outlook).
• Expert technical documentation skills and the ability to effectively communicate, verbally and in writing, technical concepts to a non‑technical audience.

• Financial Services Industry/Business Financial Services knowledge.
• Experience in developing performance metrics/reports.
• Programming/coding skills in Python and Hadoop (HIVE).
• Experience with…