Hybrid Data Insight & Reporting Analyst

BMO; Toronto; Hybrid; CAD 56,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Retirement savings plans

Accident and life insurance

Job summary

BMO Financial Group in Toronto is seeking a data analytics professional for a hybrid role tasked with delivering insights and building repeatable analytics solutions. You will develop SQL queries, create dashboards with Power BI and SSRS, and translate business needs into technical specs while collaborating with cross-functional teams.

The position emphasizes data visualization, data storytelling, and training end users, with a focus on scalable analytics and risk-aware decision support.

Qualifications

• 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

Responsibilities

• 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.
• 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.

Skills

SQL Queries

SAS/SQL/Python

Excel

SSRS/Power BI

Education

Post-secondary degree in related field

Tools

Visual Studio

Power BI

Job description

BMO Financial Group in Toronto is seeking a data analytics professional for a hybrid role tasked with delivering insights and building repeatable analytics solutions. You will develop SQL queries, create dashboards with Power BI and SSRS, and translate business needs into technical specs while collaborating with cross-functional teams.

The position emphasizes data visualization, data storytelling, and training end users, with a focus on scalable analytics and risk-aware decision support.