BI Developer, Data & Analytics

Giant Tiger

BI Developer utilizing BI, data warehouse, and cloud analytics to enhance retail operations at Giant Tiger. Responsible for developing reports, dashboards, and optimizing SQL solutions.

Posted 6/26/2026full-timeOttawa • 🇨🇦 CanadaMid-LevelSenior💰 CA$74,500 - CA$111,800 per yearWebsite

Tech Stack

Tools & technologies

BigQueryCloudGoogle Cloud PlatformJavaScriptPythonSDLCSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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, inventory, finance, customer analytics, or Merchandise Management System experience is considered an asset.

Benefits

Comp & perks

Competitive Compensation
Short Term Incentive Plan
Retirement Support
Health Benefits and Paid Time Off
Career Growth
Store Discount
Parental leave salary top-up
Recognition program that celebrates great work with monetary rewards and other perks
Safety first environment

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLBigQueryPythonJavaScriptBI developmentdata warehousedata qualitydimensional modellingdashboard developmentdata transformation

Soft Skills

collaborationproblem-solvingcommunicationtime managementanalytical thinkingattention to detailadaptabilityproject managementcritical thinkingstakeholder engagement

Certifications

Bachelor’s degree in Information TechnologyBachelor’s degree in Computer ScienceBachelor’s degree in Computer EngineeringBachelor’s degree in Data AnalyticsBachelor’s degree in Business Intelligence