Business Analyst (Data, Loyalty & Insights)

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 170 Indigo, 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

• We love books and all things beautiful
• We are Canada’s Cultural Department Store
• Books are our heart and our soul and Great Books are JUST the Beginning…

We play by 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

Additional Information

At Indigo, we are committed to our communities, our customers, and each other; together we can make a positive impact. We know that fostering diversity and inclusion brings out your full potential and creates a joyful and welcoming environment for everyone. We are driven to be an equitable employer, which highly values your diverse backgrounds, experiences, and perspectives. We believe that you, in all your uniqueness, belong at Indigo. We welcome all applicants and encourage applications from individuals who identify as Black, Indigenous, a person of colour, LGBTQ2+ and people with disabilities. Accommodations are available upon request to individuals who self-identify as having a disability or special need. Please contact Human Resources at Support-HR@indigo.ca if you require an accommodation at any time during the recruitment process. 

WELCOME HOME