Business Intelligence Analyst (Ref 20241029)

Exchange Solutions; Greater Toronto Area; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in the advertising services sector is seeking a Business Intelligence Analyst to join their Analytics and Optimization team. The role involves managing reporting and analytics needs, collaborating with various teams, and providing insights to enhance customer engagement solutions. Ideal candidates will have extensive experience in data architecture and analytics, particularly in fast-moving retail sectors. This position offers the chance to work on innovative BI initiatives and contribute to the company's success.

Qualifications

• 6+ years of expert-level experience with Tableau and BI tools.
• 6+ years of hands-on technical skills in SQL/Oracle/PostgreSQL.

Responsibilities

• Conduct analysis and planning for reporting requirements.
• Design and develop advanced dashboards using Tableau.
• Generate insights that drive the performance of loyalty programs.

Skills

SQL

Tableau

Data Visualization

Analytical Mindset

Problem Solving

Tools

Snowflake

Python

Job description

Business Intelligence Analyst (Ref 20241029)

Direct message the job poster from Exchange Solutions

The Senior BI Analyst role is part of the Analytics and Optimization team, reporting to the Manager of BI Analytics. This position involves managing and delivering reporting and analytics needs. The analyst will collaborate with various teams to provide insights that support all business areas, including enhancing loyalty programs and operational analytics for clients using our loyalty products. Responsibilities include handling all stages of reporting projects, from solution and data design to data preparation, investigation, and creating advanced dashboards.

This role offers a unique opportunity to join a dynamic team of analytical professionals who work with Business and Technology to create innovative, value-adding customer engagement solutions. It’s ideal for motivated individuals looking to deepen their expertise in retail, customer behavior, and analytics.

What you bring:

Advanced technical skills with expertise in SQL, Tableau, and other data manipulation and modeling tools.

Extensive experience in data architecture, data modeling, data quality, and data analytics.

Analytical mindset and hands-on experience in campaign analytics and customer analysis, preferably in fast-moving retail sectors like 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 support throughout the product lifecycle.

• Conduct analysis and planning for reporting requirements and user needs. Design, architect, and develop data models, table relationships, queries, KPIs, and measures.
• Design and develop advanced dashboards and self-serve tools using Tableau based on design requirements.
• Troubleshoot BI and reporting issues, and assess data integrity and quality.
• Generate insights that drive the performance of loyalty programs.
• Communicate analytical findings to peers within the Analytics team and, occasionally, to business and technology partners.
• Lead the development of processes for standardization and scalable solutions.
• Contribute to the company's operations and culture, fostering values and policies.

Qualifications – education, skills & experience

• 6+ years of expert-level experience with Tableau and other BI tools.
• 6+ years of hands-on technical skills in SQL/Oracle/PostgreSQL, with experience in Snowflake preferred.
• Strong skills in designing reporting data models, data extraction, and manipulation.
• Expert SQL query writing, debugging, and tuning skills.
• Practical experience in data investigation and quality checks on large datasets.
• Experience handling production-level data volumes.
• Excellent troubleshooting skills under pressure.
• Ability to visualize complex data into compelling business stories.
• Creative problem-solving skills for analytical and data challenges.
• Ability to develop frameworks and communicate insights effectively.
• Attention to detail, problem-solving aptitude, and interest in consumer behavior/business analysis.
• Proficiency with Python is an asset.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Analyst and Information Technology

Industries

• Advertising Services