lanej/staffing
claude/skills/staffing/SKILL.md
Query and analyze Josh Lane's org headcount from the staffing DuckDB at ~/workspace/areas/staffing/staffing.duckdb. Use when asked about headcount counts, org structure, direct reports, team breakdown, hiring/attrition trends, international employees, salary/pay grade distribution, offboarding lag, or any question about people in Josh's org. Triggers on questions about how many people, who reports to whom, headcount by team/country/level, who joined or left, org size, staffing, headcount trend.
$ install --global
skillsauthnpx skillsauth add lanej/dotfiles staffingInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 24, 2026, 6:37 AM90.4s3 files scanned
SKILL.md
- name:
- staffing
- description:
- Query and analyze Josh Lane's org headcount from the staffing DuckDB at ~/workspace/areas/staffing/staffing.duckdb. Use when asked about headcount counts, org structure, direct reports, team breakdown, hiring/attrition trends, international employees, salary/pay grade distribution, offboarding lag, or any question about people in Josh's org. Triggers on questions about how many people, who reports to whom, headcount by team/country/level, who joined or left, org size, staffing, headcount trend.
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.
Views
current_headcount— active employees only from the latest snapshotcurrent_all— active + terminated from the latest snapshotheadcount_history— all snapshots; useWHERE snapshot_date = 'YYYY-MM-DD'to pin to a specific date
Key Gotchas
Supervisor lookup for Josh: supervisor = 'Lane, Joshua' (not "Lane, Josh" — the just reports recipe is broken for this case). Use WHERE supervisor LIKE 'Lane%'.
Customer Support is fragmented: Four separate CC1 values — aggregate with WHERE cc1_description LIKE 'Customer Support%'.
Engineering is fragmented: Multiple CC1 values — aggregate with WHERE cc1_description LIKE 'Engineering%'.
work_country = 'HOME' means domestic/US remote (85% of headcount). International employees: IND=24, ROU=7 (WeSupply Romania), CAN=2, BRA/IRL/PHL=1 each.
annual_salary: ~15% NULL for active employees. Always filter WHERE annual_salary IS NOT NULL before averaging.
Full Schema
See references/schema.md for the complete column catalog, CC1 values, and work_country reference table.
Related Skills
lanej/dora
devops
VerifiedTrustedCommunity
DORA engineering metrics project at ~/src/dora. Load when: querying DORA BigQuery views (deployment frequency, lead time, change failure rate, alerts, review time) from any project; joining against DORA.unified_identity or DORA_clean.* views from any project; running the data pipeline (just refresh, just download-*, just upload-*); making OpenTofu infrastructure changes to DORA tables or views; working with team attribution, team identity, or engineer roster data.
39SKILL.mdUpdated Jun 12, 2026
lanej/data-pipeline
development
VerifiedTrustedCommunity
Data pipeline architecture patterns and best practices, including medallion/three-layer architecture (Raw/Staging/Enriched or Bronze/Silver/Gold), YAML-based schema management, and ETL workflow patterns. Use when designing or implementing data pipelines, working with data warehouse layers, or managing table schemas in YAML.
39SKILL.mdUpdated Jun 12, 2026
lanej/research
data-ai
VerifiedTrustedCommunity
Delegate research and context-gathering tasks to a sub-agent to protect the primary context window. Use when the user asks to "research X", "look into X", "find out about X", "gather context on X", or any investigative framing where answering requires 2+ searches or multiple sources. Also use proactively before starting substantive work when prior context is unknown. Never run research inline — always delegate.
39SKILL.mdUpdated May 31, 2026
lanej/claude/skills/qmd-math
documentation
VerifiedTrustedCommunity
--- name: qmd-math description: Math notation conventions for Quarto/EPQ documents rendered via lualatex. Use when: writing or adding a formula, equation, or mathematical expression to a .qmd file; asked about display math, inline math, or LaTeX notation in a QMD/Quarto context; defining a where-clause or variable definitions for an equation; converting prose variable descriptions into structured math notation; fixing math that renders badly in a PDF; using \lvert, \begin{aligned}, \tfrac, \text
39SKILL.mdUpdated May 26, 2026