Aller au contenu
Toutes les missions
Veille marché · Dev-to Nouvelle Publiée il y a 5 heures

Canada's Job Bank postings with NOC codes, wages and hours in Python, from the official open data

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

Entreprise what pay
Mode two provinces paying

Résumé

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_code and noc_title (NOC 2021), noc2016_code, industry (NAICS). city, province, province_code, economic_region, postal_code where published. salary_min, salary_max, salary_per (hour, day, week, biweekly, month or year) and salary_text as 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. Links Job Bank Canada Scraper on the Apify Store