Data & Reporting Analyst

BMO•Toronto, ON

1d•CA$61,600 - CA$113,900

About The Position

Investigates and identifies strategies to optimize business operations and services, and inform business decisions. Defines business requirements to inform technology build and operations by sourcing and analyzing relevant data, reviewing and documenting business processes and collaborating with business stakeholders. Sources business and market data to evaluate the effect of projects on business results. Also assesses the efficiency and the performance of technology (software, hardware and the wider IT system) to deliver expected business results. Identifies and analyzes malfunctions, system workflow, and troubleshoots issues raised by business. The focus for this opportunity will be on the following: Power BI Reporting & Dashboard Support Experience creating and maintaining Power BI reports and dashboards, including data preparation, visualization development, DAX calculations, report publishing, and troubleshooting reporting issues. Microsoft Power Automate Experience with Power Automate to create and support workflows, notifications, approvals, automated reporting processes, and integration with SharePoint, Outlook, Excel, Power BI, and Power Apps. Microsoft Power Apps Experience developing and maintaining Power Apps solutions, including forms, data entry applications, and integrations with SharePoint, Excel, and Power Automate. Python & SQL Data Analysis Experience with SQL and Python for data extraction, cleansing, analysis, reporting, and automation of recurring reporting and data management tasks. Elicits requirements and analyzes feasibility to ensure solutions/initiatives achieve the expected business outcomes. Supports various project teams across the project lifecycle to ensure development is aligned with the business requirements. Develops informative, coherent, and usable project documents (project artifacts) for multiple stakeholders covering functional and non-functional business requirements. Applies depth of domain & functional expertise for the assigned portfolio to drive the expected business value. Breaks down strategic problems, and analyses data and information to provide insights and recommendations. Builds tests cases to validate business requirements and End-User Testing results. 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 creating and maintaining Power BI reports and dashboards, including data preparation, visualization development, DAX calculations, report publishing, and troubleshooting reporting issues.
Experience with Power Automate to create and support workflows, notifications, approvals, automated reporting processes, and integration with SharePoint, Outlook, Excel, Power BI, and Power Apps.
Experience developing and maintaining Power Apps solutions, including forms, data entry applications, and integrations with SharePoint, Excel, and Power Automate.
Experience with SQL and Python for data extraction, cleansing, analysis, reporting, and automation of recurring reporting and data management tasks.
Agile Delivery and Development.
Data analysis.
Learning Agility.
Process improvement and optimization.
Organization process optimization.
Business architecture frameworks.
Stakeholder Analysis and Management.
Digital Fluency.
Systems Thinking.
Business requirements definition and analysis.
Insights development and reporting.
Application functional design.
Functional Analysis.
Verbal & written communication skills.
Collaboration & team skills.
Analytical and problem solving skills.
Data driven decision making.
Typically between 3-5 years of relevant experience and 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.
Problem-Solving – Ability to investigate data discrepancies, troubleshoot reporting issues, and develop effective solutions.
Time Management & Prioritization – Ability to manage multiple projects, deadlines, and ad hoc reporting requests in a fast-paced environment.
Business Acumen – Understanding of business processes, KPIs, and organizational objectives to align reporting with strategic goals.
Adaptability & Continuous Learning – Willingness to learn new tools, technologies, and reporting methodologies in a rapidly evolving analytics environment.
Collaboration & Teamwork – Ability to work effectively with cross-functional teams including business users, IT, data engineers, and leadership.
Presentation & Storytelling – Skill in transforming complex data into compelling visualizations and narratives that support decision-making.

Responsibilities

Elicits requirements and analyzes feasibility to ensure solutions/initiatives achieve the expected business outcomes.
Supports various project teams across the project lifecycle to ensure development is aligned with the business requirements.
Develops informative, coherent, and usable project documents (project artifacts) for multiple stakeholders covering functional and non-functional business requirements.
Applies depth of domain & functional expertise for the assigned portfolio to drive the expected business value.
Breaks down strategic problems, and analyses data and information to provide insights and recommendations.
Builds tests cases to validate business requirements and End-User Testing results.
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.