Workforce (APS Gazette) / recruitment pipeline · FY26

Workforce plan

Every position advertised in the APS Gazette, consolidated into a single recruitment picture — by classification, agency and salary band. Advertised positions, not filled headcount.

Last refreshedMon 06:00 AEST · weekly scrape

Active vacancies

of 84 gazetted notices

Median midpoint

$74,400

salary_min ⟷ salary_max

Closing this week

within 7 days

Agencies hiring

distinct entity_name_raw

EL1+ leadership

EL1 · EL2 · SES roles

Unresolved entity

entity_id IS NULL · DQ

Vacancies by classification / classification

Where the openings sit

Workforce (APS Gazette)count(vacancy_number) by classification

Engagement / job_type

How roles are offered

Parked — not in APS Gazette gold

Ongoing vs non-ongoing engagement and office arrangement are not columns in gold.fct_vacancy. Ongoing/non-ongoing headcount lives in the APSC mart (gold.fct_workforce_snapshot) — a distinct source we deliberately don't conflate with gazette vacancies. Parked for a product decision.

Demand / entity_name_raw

Top agencies hiring

Department of Foreign Affairs and Trade10 · 12%

Department of Industry, Science and Resources10 · 12%

Nat. Indigenous Australians Agency8 · 10%

Australian Bureau of Statistics7 · 8%

Department of Social Services7 · 8%

Department of Veterans' Affairs6 · 7%

Other (10 agencies)36 · 43%

Salary / salary_min · salary_max

Advertised salary bands

< $70k34 · 43%

$70k–$90k16 · 20%

$90k–$110k4 · 5%

$110k–$140k7 · 9%

$140k–$200k10 · 13%

$200k +8 · 10%

Geography / location

Where the work is based

Parked — not in APS Gazette gold

Duty location isn't carried in gold.fct_vacancy. If the gazette spoke surfaces a location field into gold, this becomes a real breakdown — until then it's parked rather than faked.

Current vacancies / gold.fct_vacancy

Soonest-closing open notices · 1 active · 16 agencies

Role	Agency	Level	Salary (AUD)	Closes	Status
Project Support Officer VN-1205453	Attorney-General's Department	APS4	$71,200–$76,300	—	No close date

Data dictionary / gold.fct_vacancy

What this plan is built on

bronze.gazette_link → silver.vacancy_notice → gold.fct_vacancy

Column	Type	Description
vacancy_numberKEY	text	Business key — gazetted vacancy notice id (e.g. VN-1234567).
gazette_labelKEY	text	APS Gazette issue (e.g. PS46). Part of the natural grain.
gazette_date	date	Publication date of the gazette issue.
entity_id	text	Canonical entity resolved by the Neo4j core graph; NULL when unresolved (DQ).
entity_name_raw	text	Agency name exactly as printed in the gazette.
job_title	text	Advertised position title.
classification	text	APS classification (APS1–6 / EL1–2 / SES1–3 / GRADUATE / CADET).
salary_min	integer	Advertised salary floor (AUD).
salary_max	integer	Advertised salary ceiling (AUD).
closing_date	date	Date applications close.
source_pdf_url	text	Provenance URL of the source gazette PDF.

Grain: one row per vacancy notice per gazette issue. Rebuilt weekly from the APS Gazette (apsjobs.gov.au) — figures are advertised positions, not filled headcount. Data path: Fixtures · gold.fct_vacancy sample · 84 rows.