Manager, Product Analytics & Reporting

BMO•Toronto, ON

1d•CA$69,000 - CA$129,000•Hybrid

About The Position

The Manager, Product Analytics & Reporting is responsible for the development, ownership, and evolution of product metrics and analyses. They will act as the key advisor for product leaders in personal banking. The individual will have an end-to-end project accountability. Beginning with understanding the business KPIs, they will leverage expertise in business and data to drive decisions for product strategy. Analysis will include a solid understand of data fundamentals, tools used and business pain points. Ownership in this role is supporting existing product strategy to drive acquisition/retention and P&L management 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 SQL and Python Researches and applies continuous improvement 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 SQL or python
3-5 years experience in Power BI design and semantic models
3 years + experience in consulting or strategy roles
Technical design optimization.
Decision Making.
Systems Thinking.
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.
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

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.
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.
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.
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 SQL and Python.
Researches and applies continuous improvement 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.
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.