Staffing Skill

Queries Josh Lane's org headcount from a DuckDB at ~/workspace/areas/staffing/staffing.duckdb.

Source: HRIS "Opex TD" export, company code 80405 (Engineering, CS, CX, Professional Services, Product, UX, WeSupply, post-sales). Does NOT include G&A, Finance, Sales, Marketing, Legal — use BigQuery dim.users for company-wide data.

Current snapshot: 2026-05-18 — 245 active, 233 inactive/past

Execution

For predefined queries, use just from within ~/workspace/areas/staffing/. For custom queries, use the DuckDB CLI directly:

duckdb ~/workspace/areas/staffing/staffing.duckdb "SELECT ..."

See references/query-patterns.md for copy-paste SQL for all common scenarios.