Databases · Learning guide

BigQuery

Asked for in 6 job posts at 3 companies across Canada.

No job posts in Columbus yet, so we're showing all of Canada.

Demand over time

Job posts asking for BigQuery, by week, last 16 weeks

in the last 4 weeks · 0 the 4 before

Job posts asking for this skill, by week
Week of	Job posts
Jul 20	0
Jul 27	0
Aug 3	0
Aug 10	0
Aug 17	0
Aug 24	0
Aug 31	0
Sep 7	0
Sep 14	0
Sep 21	0
Sep 28	0
Oct 5	0
Oct 12	2
Oct 19	1
Oct 26	0
Nov 2	3

Who's hiring

Companies with posts that ask for it

LLightspeed3
HHopper2
CCohere1

Newest job posts

Learn next

Asked for in the same posts

Looker Python SQL R Tableau A/B testing dbt Google Analytics

Impact projects

Real problems in Canada, from public data. Build something that helps, and prove BigQuery while you do it.

AI-suggestedUN SDG 11
In Calgary, emergency shelter beds shifted from 1959 in 2016 to 1736 in 2025. This capacity constraint directly affects unhoused residents seeking safe overnight shelter.
Emergency shelter beds, Calgary (yearly)
Emergency shelter beds, Calgary (yearly)
Period Value
2016 1,959 beds
2017 1,949 beds
2018 2,052 beds
2019 1,916 beds
2020 1,861 beds
2021 1,232 beds
2022 1,615 beds
2023 1,769 beds
2024 1,746 beds
2025 1,736 beds
What to build
Build a centralized SQL reporting database for shelter coordinators to track bed inventory across local facilities.
How it practises BigQuery
Write BigQuery SQL queries with window functions and table partitions to analyze bed distribution patterns efficiently.
Proof to submit
Submit a public repository with BigQuery SQL scripts and a short video demonstration of the query results.
Data: Statistics Canada table 14-10-0353-01
AI-suggestedUN SDG 2
The share of people living in food-insecure households in Alberta moved from 19.4 in 2018 to 28.4 in 2024. This trend affects low-income families and children struggling to access daily nutritious meals.
Share of people living in food-insecure households, Alberta (yearly)
Share of people living in food-insecure households, Alberta (yearly)
Period Value
2018 19.4%
2019 18.6%
2020 19.8%
2021 22%
2022 28.2%
2023 31.3%
2024 28.4%
What to build
Build a data warehouse model for provincial food banks to evaluate pantry inventory and client demand patterns.
How it practises BigQuery
Write BigQuery analytical queries using aggregations and common table expressions to inspect simulated food distribution logs.
Proof to submit
Submit a repository containing SQL schema definitions, queries, and execution run logs.
Data: Statistics Canada table 13-10-0834-01

Emergency shelter beds, Calgary (yearly)
Period	Value
2016	1,959 beds
2017	1,949 beds
2018	2,052 beds
2019	1,916 beds
2020	1,861 beds
2021	1,232 beds
2022	1,615 beds
2023	1,769 beds
2024	1,746 beds
2025	1,736 beds

Share of people living in food-insecure households, Alberta (yearly)
Period	Value
2018	19.4%
2019	18.6%
2020	19.8%
2021	22%
2022	28.2%
2023	31.3%
2024	28.4%

Best resources

Free, and hand-picked. Start with the first one.