AI People Analytics: People Analytics Specialist on Slack

Leaders make decisions about headcount, hiring, turnover, and engagement every day, but the data that supports these decisions sits in static dashboards or behind a queue of requests to the data team. The cycle is well-known: the manager needs a number, opens a ticket or messages the analyst, waits, and by the time the response arrives, the decision has already been made based on intuition.

For the People Analytics team, the cost is the opposite. The same recurring questions ("how many open positions this month?", "what is the voluntary turnover for the last quarter?") consume the schedules of analysts who should be producing higher-value analyses. There was a need for a controlled and secure self-service path, without giving direct access to the warehouse to those who do not write SQL.

An AI agent that exists where leadership already is: Slack. When a leader sends a question in natural language, the workflow in n8n detects the message, identifies the user, and triggers the orchestrating agent, a GPT-4.1 via Azure OpenAI defined by a system prompt structured as "Strategic Partner for People Analytics." The agent interprets the intent, selects the corresponding data tool, executes the query in the data warehouse asynchronously, and returns the formatted answer in the conversation.

The architecture is multi-agent and tool-oriented: multiple sub-workflows, each mapped to a specific table or view of the warehouse, which the orchestrator selects dynamically based on the question. A reusable integration sub-workflow receives the SQL query, triggers execution via REST API, waits for completion with polling logic, and uses a second LLM chain to summarize the raw result in a readable format for the agent. Conversational memory scoped by Slack ID allows for multi-turn conversations, and each query logs who is accessing the data.

The manager writes in Slack as they would to an analyst: "How many positions are open this month?". The trigger filters bot messages, enriches the context with the sender's profile, and delivers the question to the orchestrator, which covers five domains: Hiring, Team Metrics, eNPS, Payroll, and People Development.

The agent has access to metrics such as headcount, turnover, attrition, salary positioning, time bank, eNPS, climate survey participation rate, time to hire, time to fill, job pipeline, payroll composition, and individual movement history. These are the most recurring questions from leadership, answered without opening any dashboard. Before sending, a code node converts the Markdown of the response to Slack's native syntax. Follow-up questions in the same session maintain context: the agent remembers what was asked before.

All behavior is governed by the system prompt and the Tool Workflows. Pointing the agent to another SQL warehouse requires only updating the HTTP endpoint and the query templates in the integration workflow.

• Self-service data for leaders, with 5 domains and 12+ indicators queryable in natural language
• Zero additional systems for the user: questions and answers happen entirely in Slack
• Embedded governance: bot filtering, requester identification in each query, and access to the warehouse restricted to pre-mapped tools
• Recurring leadership questions no longer become tickets in the data team's queue, allowing them to focus on higher-value analyses

The takeaway: in people analytics, the barrier is rarely a lack of data. It is the distance between where the data resides and where the decision is made. Bringing the warehouse within a Slack message's reach changes who can use it.