BI Developer, Data & Analytics

Giant Tiger • Ottawa, ON

1d • CA$74,500 - CA$111,800 • Remote

About The Position

This is a fully remote role! The incumbent may be asked to come onsite to our Ottawa, Ontario Home Office quarterly for team gatherings. 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

• 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.

Nice To Haves

• 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.

Responsibilities

• 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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree