Jobs in Canada

Email me new jobs Save this search

Added 9 mins ago
Data Scientist
Scotiabank
Toronto, ON
Write and maintain high-quality Python and SQL code to source, prepare, and analyze large volumes of structured and unstructured data, building robust analytical datasets and pipelines.
Added 9 mins ago
T
Applied Machine Learning Scientist I
TD
Toronto, ON · Montreal, QC
- Full-time
Proficiency in Python and modern machine learning frameworks and tools.
Added 10 mins ago
TG
Full Stack Developer
TMX Group
Toronto, ON
- Full-time
As a Full Stack Developer, you will design, implement, and maintain high-performing web applications and resilient digital interfaces. Working collaboratively within a cross-functional…
Added 25 mins ago
B
Manager, Reporting & Analytics
BMO
Toronto, ON · FCP
- Full-time
Knowledge and experience in data preparation, data analysis, and statistical tool sets including but not limited to SQL, Python, PowerApps and/or UIPath.
Added 25 mins ago
B
Senior Analyst Data Analytics
BMO
Toronto, ON · FCP
- Full-time
In this role, you'll leverage Python, SQL, data visualization and automation to transform large and complex datasets into actionable intelligence. You'll develop analytics solutions,…
Added 25 mins ago
C
Senior Data Analytics Developer
Coveo
Montreal, QC
- Full-time
Are you passionate about building the data foundations that power innovative products? As a Senior Data Developer, you’ll help build and scale the data platform behind Coveo’s product.…
Added 25 mins ago
TG
Application Security Engineer
TMX Group
Toronto, ON
- $105,000 to $115,000 CAD / year
- Full-time
Advanced knowledge of key application layer protocols and data formats (HTTP, WebSockets, SQL, JSON, Protobufs).
Added 40 mins ago
C
Senior AWS Data Engineer (Strong Databricks)
Ccube
Mississauga, ON
- Full-time
Advanced SQL skills and proficiency in Python or equivalent programming languages.
Added 40 mins ago
IG
Python Developer
IMCS Group
Quebec, QC
- Contract
We are seeking a skilled Python Developer with strong database development and optimization experience. The ideal candidate will be responsible for designing, developing, and maintaining…
Added 40 mins ago
E
Senior Data Engineer
E-IT
Toronto, ON
- Contract
This position is for a Senior Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable…
Added 40 mins ago
HB
Trading Application Support Engineer: $180,000cad + Bonus (Quant Fund)
Hunter Bond
Montreal, QC
- Full-time
SQL for data analysis and problem investigation
Added 40 mins ago
SI
Business Intelligence Analyst
Spait Infotech
Canada
- Full-time
Write and optimize complex SQL queries to extract, transform, and validate data from relational databases.
Added 40 mins ago
M
Senior Java Full Stack Developer
Miratech
Ottawa, ON
- Full-time
We are looking for a Senior Full Stack Developer to design, build and maintain both front-end interfaces and back-end systems, including APIs, microservices, databases and cloud…

Spait Infotech

Business Intelligence Analyst

Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Posting language: English
Posted: Nov 6, 2026

Original job description

Key Responsibilities

Gather, analyze, and interpret business data from multiple sources to identify trends, patterns, and business opportunities.
Design, develop, and maintain interactive dashboards and reports using Microsoft Power BI.
Write and optimize complex SQL queries to extract, transform, and validate data from relational databases.
Develop data models, relationships, calculated columns, and measures using DAX.
Perform data extraction, transformation, and loading (ETL) activities using Power Query and other relevant tools.
Create and maintain business reports, KPI dashboards, and performance monitoring solutions.
Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
Perform data validation, reconciliation, and quality checks to ensure accuracy and consistency.
Identify business trends, performance gaps, and improvement opportunities through data analysis.
Automate recurring reports and streamline reporting processes.
Present analytical findings and actionable insights to management and stakeholders.
Maintain proper documentation of dashboards, reports, data models, and business logic.

Required Technical Skills

SQL: Strong knowledge of SQL queries, Joins, Subqueries, CTEs, Views, Stored Procedures, and Window Functions.
Power BI: Expertise in dashboard development, DAX, Power Query, data modeling, and report publishing.
Microsoft Excel: Advanced Excel skills, including Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, and data analysis.
Data Visualization: Ability to present complex data through meaningful charts, reports, and dashboards.
Data Warehousing: Understanding of data warehouses, relational databases, and ETL processes.
Statistics: Basic knowledge of statistical concepts, data interpretation, and analytical methods.
Python: Knowledge of Python libraries such as Pandas and NumPy is an added advantage.
Database Knowledge: Familiarity with SQL Server, MySQL, PostgreSQL, or other relational databases.

Required Qualifications

Hands-on experience in developing business dashboards and analytical reports.
Strong problem-solving, analytical, and critical-thinking abilities.
Excellent communication and stakeholder management skills.
Ability to manage multiple reporting requirements and deliver results within deadlines.

Preferred Qualifications

Microsoft Power BI certification (PL-300) is an advantage.
Experience working with large datasets and complex reporting environments.
Knowledge of cloud data platforms such as Azure, AWS, or Google Cloud.
Understanding of business processes and performance measurement frameworks.

Key Competencies

Analytical and logical thinking.
Attention to detail and data accuracy.
Business acumen and decision-making skills.
Effective communication and presentation.
Collaboration and teamwork.
Time management and prioritization.
Continuous learning and problem-solving.

Key Deliverables

Interactive Power BI dashboards and management reports.
Accurate and timely business performance reports.
KPI tracking and performance analysis.
Optimized SQL queries and reporting solutions.
Data quality and validation reports.
Actionable business insights and recommendations.

Apply About employer

More about this job

Responsibilities

Analyze data from multiple sources to identify trends, performance gaps, and business opportunities, and develop interactive Power BI dashboards, reports, and KPI tracking solutions. Optimize SQL and reporting processes, validate data quality, collaborate with stakeholders, and present actionable insights to management.

Requirements

Requires hands-on experience developing business dashboards and analytical reports, strong analytical and problem-solving abilities, and effective communication and stakeholder management skills. Advanced SQL, Power BI, Excel, data visualization, and data warehousing knowledge are required; Power BI certification, cloud platform experience, and Python are advantages.

Skills

SQL
Power BI
DAX
Power Query
Microsoft Excel
Data Visualization
Data Modeling
ETL
Data Warehousing
Data Validation
Statistical Analysis
Python
Stakeholder Communication
Dashboard Development
KPI Analysis

Visa sponsorship

Not detected in the job text

Keywords

SQL
Power BI
DAX
Power Query
Microsoft Excel
Pivot Tables
VLOOKUP
XLOOKUP
INDEX-MATCH
Python
Pandas
NumPy
SQL Server
MySQL
PostgreSQL
ETL
Data Warehousing
Relational Databases
Data Modeling
Dashboard Development
Data Visualization
KPI Tracking
Data Validation
Statistical Analysis
Azure
AWS
Google Cloud
Business Intelligence
Performance Measurement

Report this job