Business Intelligence Analyst

Exchange Solutions; Canada; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading analytics provider in Canada is looking for a Business Intelligence Analyst to manage reporting and analytics solutions. This role involves end-to-end reporting projects, designing advanced dashboards, and collaborating with teams to enhance loyalty programs. The ideal candidate has over 6 years of experience with Tableau and SQL, and is skilled in data architecture and reporting. This position offers an opportunity to make a strong impact in the analytics field.

Qualifications

• 6+ years of expert-level experience with Tableau and other BI tools.
• Expert understanding of relational data and hands-on experience writing custom queries.
• Excellent troubleshooting skills in high-pressure situations.

Responsibilities

• Work on BI initiatives from planning to deployment.
• Conduct analysis and planning for product reporting requirements.
• Develop advanced dashboards and self-serve tools using Tableau.

Skills

Proficiency in SQL

Tableau

Data manipulation and modeling tools

Analytics

Data architecture

Data modeling

Tools

SQL

Oracle

PostgreSQL

Snowflake

Python

Job description

The Business Intelligence Analyst is a role within the Analytics and Optimization team reporting to the Manager, BI Analytics.

The individual will be responsible for managing and delivering reporting and analytics solutions, working closely with other teams to support all areas of business, including continuous enhancement and performance of loyalty programs and non-loyalty/operations analytics for clients using our loyalty products.

The analyst will work end-to-end on all stages of reporting projects — from solution and data design, data preparation and investigation, to designing, building, and maintaining advanced dashboards.

This role provides an opportunity to collaborate with Business and Technology partners to design innovative, value‑adding customer engagement solutions. It is ideal for motivated professionals aiming to deepen expertise in retail, complex customer behavior, and analytics.

What you bring:

• Strong technical skills with proficiency in SQL, Tableau, or other data manipulation and modeling tools.
• Technical experience in data architecture, data modeling, data quality, and data analytics.
• Hands‑on experience in campaign analytics and customer analysis, preferably in fast‑moving retail environments such as pharmacy, fuel retail, or grocery.
• Strong understanding of data visualization best practices and design principles.

Responsibilities:

• Work on BI initiatives from planning to deployment and provide support throughout the product lifecycle.
• Conduct analysis and planning for product reporting requirements and user needs; design, architect, and develop data models, table relationships, queries, KPIs, and measures.
• Based on design requirements, develop advanced dashboards and self‑serve tools using Tableau.
• Troubleshoot BI and reporting issues, conduct data integrity, and data quality assessments.
• Generate analytical insights that drive performance of loyalty programs.
• Communicate analytical findings to peers within the Analytics team and, on occasions, to partners from business and technology.
• Lead development of processes for standardization and creation of scalable solutions.
• Contribute to the overall operations and culture of the company, fostering our values and policies.

Qualifications – Education, Skills & Experience

• 6+ years of expert‑level experience with Tableau and other BI tools.
• 6+ years of expert‑level hands‑on technical skills.
• Expert understanding of relational data (SQL/Oracle/PostgreSQL) and hands‑on experience writing custom queries; experience with Snowflake preferred.
• Strong skills in reporting data model design, data extraction, and data manipulation.
• Expert SQL query writing, debugging, and tuning skills.
• Practical knowledge in data investigation and checking data quality of large datasets.
• Experience with production‑level data volumes.
• Excellent troubleshooting skills in high‑pressure situations.
• Ability to translate complex data into business stories.
• Creativity in solving analytical and data problems.
• Capacity to develop analytical frameworks and generate/communicate business insights.
• Attention to detail, strong problem‑solving aptitude, and a natural interest in consumer behavior/business.
• Proficiency with Python is an asset.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Research, Analyst, and Information Technology

Industries

Marketing Services