Job Bank is the Government of Canada's job board, and it publishes its postings every month as open data: about 50,000 jobs a month with the occupation code, wage, hours and location of each one. For labour-market analysts, researchers, workforce boards and job sites it is the best free view of who is hiring for what, and at what pay, across the country. The catch is that it ships as large monthly files with codes instead of names.
This post loads Job Bank postings into Python already filtered and decoded, builds a wage benchmark for one occupation, compares months, and sets up a feed that returns each new month once.
Disclosure: I'm Aurelix, and I built Job Bank Canada Scraper, the tool used here. It's a paid tool (prices below).
Where the data comes from
The tool reads the Job Bank monthly open dataset on open.canada.ca, published under the Open Government Licence - Canada, which allows commercial use. It does not scrape job pages, so there is nothing to block, and each record links back to the file it came from.
What each row holds
42 fields per job:
-
title,noc_codeandnoc_title(NOC 2021),noc2016_code,industry(NAICS). -
city,province,province_code,economic_region,postal_codewhere published. -
salary_min,salary_max,salary_per(hour, day, week, biweekly, month or year) andsalary_textas published. -
hours_min,hours_max,hours_per,work_hours_from,work_hours_to,work_schedule(day, evening, night, weekend...). -
employment_type,employment_term,telework,vacancies. -
education,experience,language,posted_date,dataset_month,posted_via(Job Bank or a partner board).
Trades jobs in two provinces paying $25 an hour or more
pip install apify-client
import csv
import os
from apify_client import ApifyClient
client = ApifyClient(os.environ["APIFY_TOKEN"])
run = client.actor("aurelix/job-bank-canada-scraper").call(
run_input={"month": "latest", "provinces": ["ON", "BC"], "nocCodes": ["72"], "minHourlyWage": 25, "maxResults": 500}
)
jobs = list(client.dataset(run["defaultDatasetId"]).iterate_items())
fields = ["title", "noc_code", "location", "salary_min", "salary_max", "salary_per", "employment_type", "posted_date"]
with open("jobbank_trades.csv", "w", newline="", encoding="utf-8") as f:
w = csv.DictWriter(f, fieldnames=fields, extrasaction="ignore")
w.writeheader()
w.writerows(jobs)
nocCodes matches by prefix: 63200 is cooks, 72 is the technical trades (electricians, plumbers, carpenters and more), 7 is all trades and transport. Other filters are cities, titleKeywords, employmentTypes, postedAfter and jobBankOnly.
A wage benchmark for one occupation
from collections import defaultdict
from statistics import median
hourly = defaultdict(list)
for j in jobs:
if j["salary_per"] == "hour" and j["salary_min"]:
hourly[(j["noc_title"], j["province_code"])].append(j["salary_min"])
for (occupation, prov), wages in sorted(hourly.items(), key=lambda x: -len(x[1]))[:10]:
print(f"{occupation[:45]:45} {prov} n={len(wages):3} median ${median(wages):.2f}/h")
Compare months
run_input = {"month": "latest", "months": 3, "nocCodes": ["63200"], "maxResults": 0}
With month on latest, months reads that many of the newest published files; any single month back to January 2023 works as "2025-06". maxResults: 0 returns everything that matches, up to a whole month (about 50,000 jobs).
Each new month, once
run_input = {
"month": "latest",
"provinces": ["ON"],
"nocCodes": ["72"],
"incremental": True,
"stateKey": "ontario-trades-monthly",
"slackWebhookUrl": "https://hooks.slack.com/services/...",
}
With incremental on, a run returns only jobs no earlier run with the same filters returned. Save it as a task in the Apify Console and schedule it weekly or monthly: when the government publishes a new month, the next run returns it and Slack gets a short digest; otherwise nothing is sent. webhookUrl posts the same digest as JSON to Zapier, Make or n8n.
Why this tool
- Official Government of Canada data, licensed for commercial use.
- History back to January 2023.
- NOC, NAICS, wages and hours already decoded into columns.
- Filters for province, city, occupation, title, wage and date.
- Cheaper than the leading tools.
Limits
- Monthly, not live: each month is published about one to five weeks after it ends.
- No employer name, job description or posting link: they are not in the open dataset.
- Partner-board postings carry fewer fields (no education, experience or NAICS industry).
- City is missing on about 1% of postings and the postal code on about half.
- Benefit flags come back empty: every one was No or blank in each month we checked.
Cost
$0.50 per 1,000 jobs on Apify's free plan, from $0.28 per 1,000 on paid plans, plus a start fee per run that covers downloading the monthly file even when your filters match nothing. The current prices are on the Store page; Apify's free plan includes $5 of credit a month, about 9,900 jobs.
Use it from an AI assistant
The tool also works through Apify's hosted MCP server, so Claude, ChatGPT or Cursor can run it from a request like "median hourly wage for cooks in Ontario in the latest Job Bank data". Server URL: https://mcp.apify.com/?tools=aurelix/job-bank-canada-scraper.
Top comments (0)