Really good numbers
@ByeByeBaby A lot less jobs directly related to oil and gas than I thought. My only question would be how much of professional/technical, construction, and transportation/warehousing would be indirectly related to oil and gas? Either way the numbers aren't near as high as one might expect. Clearly the percentage of oil and gas jobs is on the decline.
As a scale thing, in 2021 there's around 37K workers in NAICS 22 - Mining, quarrying and oil and gas extraction and they're almost all working in oil and gas (about 1250 in other forms of mining; ~300 in coal, ~450 in metal ores, ~550 in non-metallic mining e.g. rock quarries and gravel pits, numbers won't add due to rounding).
The obvious oil and gas workers from other fields are ~1300 in wholesale (Petroleum and petroleum products merchant wholesalers), and ~4000 in transportation (2500 in oil pipelines and 1500 in gas pipelines).
Construction, there's perhaps a few workers; there's a subgroup of Utility system construction workers who build various utilities, which includes pipelines (but also electrical, water, cable, etc.), there's 4200 workers total, but I'd guess ~2000 max workers in oil pipelines -- we do build those other utilities. Oil specialty construction (eg well casing or foundation) companies - those who basically only do mining-specific construction - are in with the mining workers already.
Professional/technical, there's a lot of generic services here; legal, accounting, advertising, computers systems, generic 'management consulting' (like McKinsey). We do have a lot of workers (more than other cities) in the Architectural, engineering and related services category - there's ~24,800 total workers in this category; plenty of these are doing other types of work that isn't oil & gas. But this category would include geophysical and other exploration work (including seismic) and an EPC company like Bantrel that does oil & gas facility design/construction. Again, looking at other cities in Canada, I'd guess ~8000 of the workers here; this category includes 1000-1250 each of chemical engineers, petroleum engineers and geoscientists, so the floor is probably ~3000, plus some associated technicians and a share of the mechanical, civil and electrical engineers as well as some support staff.
All that together is ~51K more or less fairly directly employed in the oil and gas sector; more than in first blush, but less than 40% more; putting the oilpatch at roughly 6.3% of total employment.
What I'm not including here are second-order and beyond; there are lawyers who specialize in oil and gas contracts, auditors who specialize in oil company bookeeping, the workers who clean an oil company's office, or cater their holiday party or whatever, or workers in layers further away.