Job Title

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 Canadas 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 wed 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 Indigos 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 Indigos 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 35 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