Manager, Business Intelligence & Information Management

Job Description

RBC Regional Banking Support’s Commercial Reporting is hiring a Manager, Business Intelligence & Information Management role that will support strategic reporting and visual insights for Regional Banking’s Commercial. The position will transform data into useful, relevant information and deliver insights to business partners and senior leaders in a Commercial banking environment.

• Utilize cutting edge business intelligence capabilities to optimize business results and deliver insights.
• Design and develop innovative reporting solutions to monitor performance management and present key analytical insights.
• Take end-to-end responsibility for 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.
• Apply standard design principles and data visualization techniques to provide proactive actionable insights.
• Identify appropriate data sources and perform ETL for data modeling and data quality assessments.
• Participate in conversations with internal partners to understand business strategies and recommend reporting solutions.
• Participate in design and solution review demonstrations with senior managers and internal partners at critical tollgates.
• Test and validate 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 plans/test cases.
• Be a thought partner within the Commercial Reporting team, supporting the development of insights, processes, data approaches, methodologies, and information valued by partners across Regional Banking and Commercial.
• Demonstrate a commitment to continuous learning and professional growth, adapting to evolving business needs and new analytical methodologies or tools.

• Degree in Computer Science, Mathematics/Statistics, Engineering, or related field.
• Working experience in both SAS and Tableau.
• Demonstrated ETL and big data modeling capabilities, with programming experience in large databases/datasets using SAS, SQL Server, and Teradata SQL Assistant.
• Experience in statistical methods, strong data profiling, cleaning, and mining.
• Proficient in SQL extracts to investigate data from a data warehouse and other sources.
• Ability to perform complex data analysis on large volumes of data and present findings to senior leaders to inform strategic decisions.
• Proven quantitative analytical skills (data discovery, aggregation, summarization) and problem-solving skills.
• UNIX knowledge (submit process, create logs, store data).
• Advanced proficiency in report development using Tableau.
• Experience with cloud computing technologies (Snowflake/Snowsight & Trino).
• Data knowledge of RBC’s EDW.
• Skilled in Microsoft Office applications (Excel, PowerPoint, Outlook).
• Expert technical documentation skills and the ability to effectively communicate 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 Tableau Security, Tableau Server Administration.
• Fundamentals of Red Hat Enterprise Linux.

• 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.
• Ability to make a difference and lasting impact.
• Work in a dynamic, collaborative, progressive, and high-performing team.
• Opportunities to do challenging work and take on progressively greater accountabilities.

• Critical Thinking
• Data Administration
• Data Mining
• Data Modeling
• Data Movement
• Detail-Oriented
• Group Problem Solving
• Quantitative Research
• Research Documents