Remote BI & Analytics Engineer

Giant Tiger; Ottawa; On-site; CAD 75,000 - 112,000; Full time

Benefits offered by this job

Store Discount

Parental leave salary top-up

Recognition program

Safety first environment

Job summary

Giant Tiger is seeking a BI Developer, Data & Analytics to design, develop, and support enterprise BI solutions. You will translate business requirements into scalable analytics deliverables, optimizing SQL and BigQuery queries to ensure accurate reporting and data quality.

The role involves building dashboards, semantic layers, and visualizations across cloud analytics platforms. This remote role allows occasional onsite collaboration in Ottawa, Ontario.

Qualifications

• Bachelor’s degree 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.
• 2+ years experience with SDLC, change management, testing, documentation, deployment, and Waterfall and/or Agile methodologies.
• Experience with Google Cloud Platform, especially BigQuery, is strongly preferred.

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.

Skills

SQL

Data Visualization

Data analytics

ETL & data processing

SDLC / Agile

Cloud data platforms

Education

Bachelor's degree in IT/CS/Data Analytics

Tools

BigQuery

Google Cloud Platform

Looker

MicroStrategy

Python

JavaScript

SQL tooling

Job description

Giant Tiger is seeking a BI Developer, Data & Analytics to design, develop, and support enterprise BI solutions. You will translate business requirements into scalable analytics deliverables, optimizing SQL and BigQuery queries to ensure accurate reporting and data quality.

The role involves building dashboards, semantic layers, and visualizations across cloud analytics platforms. This remote role allows occasional onsite collaboration in Ottawa, Ontario.