BI Developer, Data & Analytics

Who We Are At Giant Tiger, our mission is simple: help Canadians save more every day. We’re a Canadian institution rooted in our communities and built on 60+ years of success. As part of our store support team, your work directly impacts stores across the country and drives the value that our customers see on the shelves.

We’re looking for people who are passionate about retail and motivated by meaningful work that makes a real impact. This posting represents a current opportunity at Giant Tiger.

Job Title BI Developer, Data & Analytics

About This Role Workplace Arrangements :

This is a fully remote role! The incumbent may be asked to come onsite to our Ottawa, Ontario Home Office quarterly for team gatherings.

What You’ll Be Doing

• Design, develop, test, deploy, and support BI, reporting, dashboard, semantic layer, and analytics solutions using approved BI, data warehouse, and cloud analytics platforms.
• Gather and translate business requirements into scalable BI, data, and analytics deliverables that support business goals and a single version of the truth.
• Write, validate, troubleshoot, and optimize complex SQL and BigQuery/GCP solutions to support reporting, analysis, reconciliation, data quality, and governed reporting.
• Develop and support BI platform objects, datasets, dashboards, visualizations, metrics, filters, prompts, semantic models, and other analytics components.
• Complete development tasks according to defined performance, cost, security, governance, data quality, and tool standards.
• Deliver assigned work within agreed timelines, ensuring solutions meet business requirements and technical quality expectations.
• Follow SDLC, Change Management, deployment, documentation, and DevOps procedures as defined by the team and organization.
• Create and execute technical testing, data validation, reconciliation, and production readiness activities.
• Monitor, tune, support, troubleshoot, and improve BI and data environments, including reports, dashboards, data refreshes, SQL performance, BigQuery cost/performance, data quality, standards, procedures, and operational reliability.
• Escalate delays, risks, blockers, and business-impacting issues to the appropriate project lead, manager, or support team.
• Apply automation, Python, JavaScript, AI, conversational analytics, and agent-based technologies where appropriate to improve analytics delivery, operational support, and business user experience.
• Collaborate with business, BI, data, integration, infrastructure, security, and vendor teams to support reliable, scalable, and governed analytics solutions.

What You’ll Bring

• Bachelor’s degree or college diploma in Information Technology, Computer Science, Computer Engineering, Data Analytics, Business Intelligence, or an equivalent combination of education and experience.
• 5+ years of experience developing, maintaining, and supporting BI, reporting, analytics, or data warehouse solutions.
• 5+ years of experience writing, validating, troubleshooting, and optimizing SQL queries, views, joins, aggregations, and data transformations.
• 3+ years of experience developing dashboards, reports, datasets, semantic layers, metrics, filters, prompts, and visualizations using enterprise BI tools.
• 3+ years of experience with data warehouse concepts, dimensional modelling, data quality, reconciliation, governance, and production BI support.
• 2+ years experience translating business requirements into scalable BI, data, and analytics solutions.
• 2+ years experience with SDLC, change management, testing, documentation, deployment, and Waterfall and/or Agile methodologies.
• Experience recommending data-related standards, procedures, models, and solutions used to collect, organize, store, retrieve, and deliver information.
• Experience monitoring, tuning, and improving BI and data environments, including performance, usage, data refreshes, query efficiency, reliability, and operational support.
• Experience with Google Cloud Platform, especially BigQuery, is strongly preferred.
• Experience with MicroStrategy / Strategy, Looker, Python, JavaScript, AI, conversational analytics, or agent-based solutions is considered an asset.
• Experience with Customer Data Platforms, customer analytics, loyalty data, personalization, customer segmentation, or related customer data capabilities is considered an asset.
• Retail, merchandising, ecommerce, supply chain, invento…