Data and Reporting Analyst

BMO•Toronto, ON

3d•CA$56,000 - CA$103,500•Hybrid

About The Position

This is a Hybrid, Toronto based role, mandated to provide subject matter expertise through analytics, delivering meaningful insights that drive business results in alignment with overall group goals. Works with other data and analytics professionals to optimize, refine, automate and scale analysis into repeatable analytics solutions and decision support tools. Builds various reporting dashboards 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. 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. Develops data visualizations of "large" amounts of data that facilitate the intuitive presentation of data to decision makers. 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. Exercises judgment to identify, diagnose, and solve problems within given rules. Works independently on a range of complex tasks, which may include unique 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

Experience developing SQL Queries to extract data
Demonstrated experience with data mining software/language such as SAS/SQL/Python is a definite asset
Data manipulation/aggregation/analysis in MS Excel
SSRS/Visual studio/Power BI experience for report building.
Foundational level of proficiency: Technical design optimization.
Foundational level of proficiency: Decision Making.
Foundational level of proficiency: Systems Thinking.
Foundational level of proficiency: Data visualization.
Foundational level of proficiency: Data storytelling.
Foundational level of proficiency: Data mining.
Foundational level of proficiency: Illustration.
Foundational level of proficiency: Creative thinking.
Foundational level of proficiency: Problem Solving.
Intermediate level of proficiency: Insights design.
Intermediate level of proficiency: Insights development and reporting.
Intermediate level of proficiency: Verbal & written communication skills.
Intermediate level of proficiency: Collaboration & team skills.
Intermediate level of proficiency: Analytical and problem solving skills.
Intermediate level of proficiency: Data driven decision making.
Post-secondary degree in related field of study or an equivalent combination of education and experience.
Technical proficiency gained through education and/or business experience.

Responsibilities

Provide subject matter expertise through analytics, delivering meaningful insights that drive business results in alignment with overall group goals.
Work with other data and analytics professionals to optimize, refine, automate and scale analysis into repeatable analytics solutions and decision support tools.
Build various reporting dashboards using the most appropriate data extraction, data cleaning and data visualisation techniques.
Provide value through insights, reporting and data visualization techniques.
Select, configure and implement analytics solutions for consistency and repeatability.
Research and apply continuous improvement in data visualization by identifying trends and patterns to transform raw data into actionable business insights.
Work with different teams, management and stakeholders to enhance the usability and aesthetic appeal of data analytics solutions deployed in the organization.
Translate business needs to technical specifications and evaluate existing data visualization systems in order to improve them.
Develop data visualizations of "large" amounts of data that facilitate the intuitive presentation of data to decision makers.
Document data flow, systems and processes to improve the design, implementation and management of business/group processes.
Develop tools and deliver training programs for use of reporting tools and self-serve analytics by non-analytical end users; may include delivery of training to audiences.
Exercise judgment to identify, diagnose, and solve problems within given rules.
Work independently on a range of complex tasks, which may include unique situations.
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.