Peoplebox People Analytics Analyst Interview: Rounds, Questions and Preparation

What the job involves

A People Analytics Analyst in HR tech and recruitment platforms turns people data into insights that improve hiring, engagement, and retention. Day to day, you build dashboards, run analyses on funnel and attrition data, and partner with product, HR, and customer success teams to answer workforce questions. At fast-growing companies like Peoplebox, you may also help shape analytics features for customers.

Role and Technical Knowledge

1. 1

   What are the key metrics you would track to measure hiring efficiency for a fast-growing company?

   Cover time-to-hire, cost-per-hire, offer acceptance rate, source effectiveness, and quality-of-hire. Explain how each helps a recruiter or hiring manager.

2. 2

   How would you calculate and interpret employee attrition rate? What are its limitations?

   Show the formula (number of exits divided by average headcount) and mention that it does not capture why people leave. Suggest slicing by department, tenure, and manager.

3. 3

   Explain the difference between correlation and causation with an example from HR data.

   Use a people example like engagement survey scores and attrition. Stress that a third factor, such as manager quality, could drive both.

4. 4

   What steps would you take to clean a messy employee dataset before analysis?

   Mention checking duplicates, missing values, inconsistent formats, outliers, and validating against source systems. Explain how you would document changes.

SQL and Data Handling

1. 5

   Write a SQL query to find the average time-to-hire per department from a table of job requisitions.

   Use GROUP BY department and AVG on the difference between requisition open and close dates. Mention filtering out incomplete records.

2. 6

   How would you use SQL to identify employees who are at high risk of leaving based on tenure and last promotion date?

   Describe joining employee and promotion tables, calculating months since last promotion, and filtering for tenure bands. Discuss how you would validate the risk logic.

3. 7

   What is the difference between WHERE and HAVING in SQL? Give an HR data example.

   WHERE filters rows before aggregation, HAVING filters after. Example: find departments with average engagement score above 4 using HAVING.

4. 8

   How would you handle duplicate employee records in a SQL query?

   Use ROW_NUMBER or DISTINCT based on employee ID. Explain choosing the most recent record when duplicates have different update dates.

Practical Scenarios and Case

1. 9

   You are given a dataset of employee engagement survey scores and attrition. How would you identify which factors most strongly predict attrition?

   Start with exploratory analysis, compare averages between leavers and stayers, and check correlations. Suggest simple regression or decision tree if comfortable.

2. 10

   A hiring manager says their team has a long time-to-hire. How would you investigate and present findings?

   Break the funnel into stages, compare against benchmarks, and look for bottlenecks like interview scheduling. Present a clear chart and one recommendation.

3. 11

   Design a dashboard for a recruiter to track their pipeline health. What metrics and filters would you include?

   Include stage-wise counts, conversion rates, time-in-stage, and source. Filters for role, location, and recruiter. Keep it simple and actionable.

4. 12

   How would you measure the impact of a new onboarding program on early attrition?

   Compare early attrition before and after the program, ideally with a control group. Mention controlling for seasonality and role type.

Behavioural and HR Questions

1. 13

   Why do you want to work in people analytics at an HR tech company rather than a general analytics role?

   Show interest in the intersection of data and people. Mention how analytics can improve employee experience and business outcomes.

2. 14

   Tell me about a time you explained a data insight to someone non-technical. How did you make it clear?

   Use a college project or internship example. Focus on simplifying the message, using visuals, and checking understanding.

3. 15

   Describe a situation where you had to work with incomplete or messy data. What did you do?

   Highlight your process: identify gaps, ask questions, document assumptions, and validate with stakeholders. Show persistence and attention to detail.

4. 16

   How would you handle a situation where a stakeholder disagrees with your analysis?

   Show openness to feedback, re-check your work, and discuss assumptions transparently. Emphasize finding a shared decision, not winning an argument.