BambooHR
Query BambooHR for org structure, workforce data, and aggregated compensation bands
BambooHR is the system of record for your people data. Delphi connects via API key stored in GCP Secret Manager, polls for changes on a configurable interval, and makes headcount, hiring, and basic employee lifecycle data queryable from chat. HR-adjacent data is classified confidential by default and locked to analyst-and-above scope.
What you can ask Delphi
- “What's our current headcount by department and location?”
- “Show me hiring velocity for the engineering org over the last 6 months”
- “Which teams have the highest attrition risk based on tenure distribution?”
- “List all open reqs with more than 30 days in the pipeline”
Use cases
Headcount planning
Delphi pulls live headcount and hiring data from BambooHR so financial models and workforce plans stay in sync with reality.
Technical details
Authentication ▾
Ingestion ▾
Tools exposed (1) ▾
Query BambooHR for org structure, workforce data, and aggregated compensation bands. Use for: org charts, department headcount, role distribution, tenure analysis, and pay band summaries. Requires a bamboohr connector doc on the dashboard with a secretRef API key. NEVER returns individual compensation — compensation data is always aggregated to bands.
Inputs ▾
enterprise/query_bamboohr
| Name | Type | Required | Description |
|---|---|---|---|
| dashboardId | string | no | Target dashboard ID. Omit to use the current dashboard context. |
| query | string | yes | What to query from BambooHR. "employees" → full employee list with key fields. "org_chart" → hierarchical reporting structure. "departments" → department list with headcount. "job_titles" → role distribution across the org. "tenure_analysis" → tenure distribution in bands (< 1yr, 1–2yr, 2–5yr, 5–10yr, 10+). "compensation_bands" → aggregated pay ranges by department — NEVER individual values. employees org_chart departments job_titles tenure_analysis compensation_bands |
| department | string | no | Filter results to a specific department name (case-insensitive). Applies to: employees, org_chart, job_titles, tenure_analysis, compensation_bands. |
| fields | string[] | no | Override which BambooHR fields to fetch. Defaults are chosen automatically per query type. Example: ["id", "firstName", "lastName", "department", "hireDate"] |