Business Analyst (Data, Loyalty & Insights)

Indigo; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading retail company in Toronto is seeking a results-driven Business Analyst to join its Consumer Insights team. This role involves analyzing complex data sets, using SQL and Power BI to build reporting solutions that drive consumer-centered insights. Candidates should have 3–5 years of relevant experience and strong analytical skills, with a focus on enhancing customer engagement and business decisions.

Benefits

Dynamic and enriching culture

Opportunities for professional growth

Qualifications

• Experience in retail or digital environments considered an asset.
• Understanding of data governance and cataloging.
• Ability to present findings to varied audiences.

Responsibilities

• Analyze datasets and provide insights to stakeholders.
• Develop and maintain Power BI dashboards.
• Collaborate with teams to translate operational needs into analytics.

Skills

SQL proficiency

Hands-on experience with Snowflake

Power BI advanced skills

Data analysis skills

Communication skills

Education

3–5 years in Business Analyst/Data Analyst/BI Analyst role

Tools

Excel

Power Query/M

Python

Job description

Company Description

Dedicated to telling stories and creating experiences, Indigo is always looking for bright, energetic and customer-focused people who can help bring our exciting mission to life in one of our more than 170Indigo, Indigospirit, Chapters and Coles stores across Canada. We offer a variety of exciting opportunities at our retail stores, distribution centres, and home office for people who share our passions and want to be part of a dynamic and enriching culture.

WHO WE ARE

• Welove books and all things beautiful
• We are Canada’s Cultural Department Store
• Books are our heart and our souland GreatBooks are JUST the Beginning…

We playby the following rules :

We exist to add joy to our customers’ lives each and every time they interact with us and our products

Our job is to create joyful moments for our customers

We treat each other the way we’d treat a valued friend

We inspire each other to do our best work

We seek to ignite creativity and innovation every day

We give back to the communities in which we operate

Job Description

MISSION

We are looking for a results-driven Business Analyst (Intermediate) with strong skills in SQL, Snowflake, and Power BI to join our new Consumer Insights team. In this role, you will be responsible for analyzing complex datasets, building scalable reporting solutions, and enabling data-driven decision-making across the business with an emphasis on consumer centric measurement and insights.

KEY PERFORMANCE METRICS

Consumer centric measurement & insights : Who are our best customers?How to we acquire more high value customers?How do we develop current customers into our best customers?How do we retain our best customers?

Use of data to identify insights and recommendations to drive decisions

Timely and accurate delivery of reporting and insights on time, within scope, meeting stakeholder requirements

KEY ACCOUNTABILITIES

Functional

Write complex SQL queries to extract, clean, and transform data from Snowflake and other data sources.

Develop and maintain robust Power BI dashboards and reports for business stakeholders, ensuring high usability and performance.

Collaborate with business partners on our loyalty team and others to translate operational needs into analytical requirements.

Conduct data profiling and validation to ensure data quality and accuracy in reports.

Support ongoing data integration projects by working closely with data engineering and IT teams.

Analyze trends, identify key insights, and present findings to business leaders in a clear and actionable format.

Document logic, data definitions, and report structures for reuse and knowledge sharing.

Act as an advocate for the customer by placing them at the forefront of all decision-making and design processes

Proactively identify and anticipate customer expectations and needs

Embrace and seek out technology that creates high tech and high touch solutions for Indigo’s customers

Challenge the status quo by consistently identifying areas for improvement, diagnosing issues and working to resolve them

People

Collaborate with others to drive flexible and iterative solutions, quickly and easily

Share technical knowledge with others and actively seek to learn from those more knowledgeable than yourself

Help others see the impacts of their efforts and proactively engage other functions to get input

Encourage others to freely share their point of view and be open to feedback

Cultural

Model Indigo’s beliefs and convey a positive image in everything you do

Celebrate diversity of thought and have an open mindset

Take an active role in fostering a culture of continual learning, taking risks without the fear of making mistakes

Embrace, champion and influence change through your team and / or the organization

SCOPE

Reports to : Director, Customer Insights & Analytics

KEY RELATIONSHIPS

Internal :

The Director of Loyalty

Sr. Director of Marketing Strategy

CRM and Business Intelligence teams.

External :

External vendor management with third party data providers and contractors

Qualifications

Work Experience / Education / Certifications

3–5 years of experience in a Business Analyst, Data Analyst, or BI Analyst role.

Strong proficiency in SQL (window functions, CTEs, joins, aggregations).

Hands-on experience with Snowflake or similar cloud data warehouse platforms.

Previous experience in retail, loyalty, digital, or related field considered an asset

Experience with Power Query / M or Python for data preparation as asset

Use of AI-Driven solutions to automate traditional BI tasks considered an asset

Familiarity with other BI tools like Tableau or Looker considered an asset

Knowledge of data governance, data cataloging, and lineage tools.

Competencies / Skills / Attributes

Advanced skills in Power BI, including DAX, data modeling, and visual design best practices.

Hands-on expertise in Excel and PowerPoint with executive grade data visualization

Solid understanding of data warehousing concepts and ETL pipelines.

Experience working with cross-functional teams in an agile or hybrid project environment.

Excellent communication skills and the ability to present insights to both technical and non-technical audiences.

Strong critical thinking, analytical and problem-solving skills, and excellent attention to detail

Excellent interpersonal skills and ability to collaborate / negotiate with various stakeholders

Exceptional organizational and time management skills and a demonstrated ability to prioritize work in a fast-paced environment

Highly customer centric approach to all initiatives