Manager, Product Analytics & Reporting

BMO•Toronto, ON

30d•$69,000 - $129,000•Hybrid

About The Position

The Manager, Product Analytics & Reporting is responsible for the development, ownership, and evolution of product metrics and reporting. The individual will have an end-to-end project accountability. Beginning with understanding the business KPIs, they will leverage expertise in process design to determine an efficient and optimal process for delivering reporting results. Development will include structuring the data flow and setting up automation. Ownership will continue post-implementation and include investigations, improvements, and partner relations. Builds various reporting dashboards on Power BI using the most appropriate data extraction, data cleaning and data visualisation techniques. Provides value through insights, reporting and data visualization techniques. Selects, configures and implements analytics solutions for consistency and repeatability. Designs and maintains scalable ETL pipeline and data models using tools such as SAS, SQL and Python Researches and applies continuous improvement in data visualization by identifying trends and patterns to transform raw data into actionable business insights. Works with different teams, management and stakeholders to enhance the usability and aesthetic appeal of data analytics solutions deployed in the organization. Translates business needs to technical specifications and evaluates existing data visualization systems in order to improve them. Documents data flow, systems and processes to improve the design, implementation and management of business/group processes. Develops tools and delivers training programs for use of reporting tools and self-serve analytics by non-analytical end users; may include delivery of training to audiences. Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus. Provides specialized consulting, analytical and technical support. Exercises judgment to identify, diagnose, and solve problems within given rules. Works independently and regularly handles non-routine situations. Broader work or accountabilities may be assigned as needed. Take measured risks while protecting the bank by applying our Risk Management Framework in the execution of your role, in line with our Risk Culture and within our approved Risk Appetite, making sound and risk informed decisions that align to business strategy, protect assets, and adhere to applicable policy documents (Frameworks, Policies, Standards, Procedures and Supporting documents), laws and regulations.

Requirements

3-5 years experience coding in SAS or SQL
3-5 years experience in Power BI design and semantic models
Fluent in Unix/Linux and Automation
Foundational level of proficiency: Technical design optimization. Decision Making. Systems Thinking.
Intermediate level of proficiency: Data visualization. Data storytelling. Data mining. Illustration. Creative thinking. Problem Solving. Verbal & written communication skills. Collaboration & team skills. Analytical and problem solving skills. Data driven decision making.
Advanced level of proficiency: Insights design. Insights development and reporting.
Typically between 5 - 7 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
Deep knowledge and technical proficiency gained through extensive education and business experience.

Responsibilities

Analytic Capabilities & Critical Thinking Understand business KPIs, and relevant drivers and factors that can help reach business objectives.
Be a practitioner of data best practices including QA, stable design, code optimization, and automation techniques.
Design and improve production and ad-hoc reporting processes with the goal of optimizing consumption and performance.
Internalize and understand the larger context of product data elements and leverage a strong awareness of how product and customer attributes intersect.
Analyze large, complex datasets (from multiple sources both structured and unstructured) to drive insights and recommendations.
Design and Delivery of Performance Reporting and Dashboards Responsible for performance measurement reporting and visualization that monitors overall and incremental impact of customer growth in quantity and quality.
Lead the definition, creation and maintenance of standardized dashboards and performance reporting for Product Insights and business partners.
Refine design proposals in collaboration with various stakeholders in Personal banking.
Apply thoughtful consideration to the best way to present complex materials in a consumable way.
Create new analyses and/or tools that deliver product insights that enable business users to further their objectives.
Leadership and Relationship Management Work collaboratively with other analytics teams and business subject matter experts to refine personal understanding and ensure consistency in reporting and design.
Establish and communicate standards for accurate business requirement, technical specification and work process documentation associated with our metrics and reporting.
Engage with business partners to ensure needs are met, update on delivery status, and provide transparency and clarity to results.
Leverage consultative skills and knowledge of best-practices to provide guidance and consultative sessions with partners to share insights and recommendations rooted in data.
Use these sessions to flag potential areas for deeper investigation, growth, or prioritization.
Consult with and deliver results to partners within tight time constraints that consistently meet or exceed their expectations.
Risk Management Ensure measurement reports meet governance and risk policies and identifying opportunities and solutions for continuous improvements
Builds various reporting dashboards on Power BI using the most appropriate data extraction, data cleaning and data visualisation techniques.
Provides value through insights, reporting and data visualization techniques.
Selects, configures and implements analytics solutions for consistency and repeatability.
Designs and maintains scalable ETL pipeline and data models using tools such as SAS, SQL and Python
Researches and applies continuous improvement in data visualization by identifying trends and patterns to transform raw data into actionable business insights.
Works with different teams, management and stakeholders to enhance the usability and aesthetic appeal of data analytics solutions deployed in the organization.
Translates business needs to technical specifications and evaluates existing data visualization systems in order to improve them.
Documents data flow, systems and processes to improve the design, implementation and management of business/group processes.
Develops tools and delivers training programs for use of reporting tools and self-serve analytics by non-analytical end users; may include delivery of training to audiences.
Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
Provides specialized consulting, analytical and technical support.
Exercises judgment to identify, diagnose, and solve problems within given rules.
Works independently and regularly handles non-routine situations.
Broader work or accountabilities may be assigned as needed.
Take measured risks while protecting the bank by applying our Risk Management Framework in the execution of your role, in line with our Risk Culture and within our approved Risk Appetite, making sound and risk informed decisions that align to business strategy, protect assets, and adhere to applicable policy documents (Frameworks, Policies, Standards, Procedures and Supporting documents), laws and regulations.