Zimyo HR Technologies People Analytics Analyst Interview: Rounds, Questions and Preparation

What the job involves

People Analytics Analysts in HR tech and recruitment platforms turn workforce and hiring data into insights that help companies make better talent decisions. Day to day, they pull and clean data from HRIS or ATS systems, build dashboards and reports, track metrics like attrition, time-to-hire, and engagement, and present findings to HR and business teams. At fast-growing employers, they often work closely with product, customer success, and HR teams to improve both internal people decisions and the analytics features offered to clients.

Role and Domain Knowledge

1. 1

   What does a People Analytics Analyst do differently from a general data analyst?

   Focus on people-specific data such as employee lifecycle, attrition, engagement, hiring funnels, and the need to handle sensitive HR data ethically. Mention that insights must lead to HR or business action.

2. 2

   How would you calculate and interpret employee attrition for a fast-growing HR tech company?

   Give the formula (employees who left in a period divided by average headcount), explain voluntary vs involuntary, and discuss slicing by department, tenure, and manager to find patterns.

3. 3

   What is time-to-hire and how can it be improved using recruitment platform data?

   Define it as days from candidate first contact to offer acceptance. Suggest tracking stage-wise drop-off, interviewer availability, and sourcing channel quality to reduce delays.

4. 4

   Why is data privacy important in people analytics, especially for an HR tech company?

   Mention employee consent, anonymisation, access control, and compliance with laws like India's DPDP Act. Explain that HR tech companies must protect both their own employees' and clients' candidate data.

Technical Skills and Tools

1. 5

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

   Use SELECT department, AVG(DATEDIFF(offer_date, application_date)) with GROUP BY department. Explain how you would handle nulls or outliers.

2. 6

   How would you clean a messy employee dataset with missing joining dates and duplicate records?

   Describe steps: remove duplicates, flag or impute missing dates using offer letters or payroll data, standardise formats, and document assumptions. Mention using Excel or Python pandas.

3. 7

   Which HR metrics would you put on a monthly people dashboard for a growing company?

   Pick 5-7 metrics like headcount, attrition, time-to-hire, offer acceptance rate, engagement score, and diversity ratio. Explain why each matters and how often to refresh.

4. 8

   How would you explain a correlation between overtime hours and attrition to a non-technical HR manager?

   Avoid jargon. Say correlation is not causation, show a simple chart, and suggest a small pilot or further analysis before making policy changes.

Practical Scenarios

1. 9

   A client using your HR platform says their best performers are leaving. How would you investigate using product data?

   Outline a plan: define 'best performers', check exit survey data, compare engagement and recognition metrics, analyse manager changes, and look at compensation bands. Recommend a retention pilot.

2. 10

   You are asked to build a hiring funnel report for a recruitment platform. What stages and metrics would you include?

   Include application, screening, interview, offer, and hire stages. Add conversion rates, drop-off reasons, source-wise quality, and time spent per stage.

3. 11

   Your dashboard shows a sudden spike in attrition for one department. What do you do next?

   Validate the data first, then segment by tenure, role, and manager. Check for recent policy changes or market events. Prepare a short brief with possible causes and next steps.

4. 12

   How would you measure the success of a new employee referral program?

   Define baseline metrics like referral share, quality-of-hire, time-to-hire, and retention at 6 and 12 months. Suggest a control group or before-after comparison.

Behavioural and HR Questions

1. 13

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use STAR format. Highlight the data source, your cleaning or analysis step, the insight, and the outcome or recommendation.

2. 14

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

   Connect your interest in both data and human behaviour. Mention the chance to improve hiring and employee experience at scale, and show you understand HR tech products.

3. 15

   Describe a situation where you had to explain a technical finding to someone non-technical.

   Show empathy and clarity. Explain how you simplified the message, used visuals, and checked for understanding. Mention the result.

4. 16

   How do you handle working with sensitive employee data while meeting tight deadlines?

   Talk about following access rules, anonymising where possible, and planning your work in small checkpoints. Show that you balance speed with confidentiality.