Codility India People Analytics Analyst Interview: Rounds, Questions and Preparation

What the job involves

People Analytics Analysts turn HR and recruitment data into insights that drive hiring, retention, and performance decisions. In HR tech and recruitment platforms, they build dashboards, run experiments, and analyse candidate pipelines and assessment data to help product and talent teams make evidence-based choices. Day to day involves SQL, Python or R, BI tools, and close collaboration with recruiters, product managers, and data engineers.

Role and Technical Knowledge

1. 1

   What are the key stages of a recruitment funnel, and which metrics would you track at each stage?

   Cover sourcing, application, screening, assessment, interview, offer, and hire. Mention conversion rates, time-to-hire, cost-per-hire, and offer acceptance rate.

2. 2

   How would you calculate and interpret time-to-hire versus time-to-fill for a recruitment platform?

   Define both clearly: time-to-hire ends at offer acceptance, time-to-fill ends at the start date. Explain how each reveals different bottlenecks in the pipeline.

3. 3

   What is the difference between a leading and a lagging indicator in people analytics? Give a recruitment example.

   Leading indicators predict future outcomes, like interview scheduling rate or assessment completion rate. Lagging indicators confirm results, like quality-of-hire or 90-day retention.

4. 4

   How would you measure the effectiveness of a coding assessment used in hiring?

   Discuss completion rate, score distribution, correlation with on-the-job performance, and fairness across demographic groups. Mention avoiding adverse impact.

Practical Scenarios and Data Handling

1. 5

   You have a dataset of candidate applications with missing values in the 'source' column. How would you handle this before analysis?

   Explain options: imputation, creating an 'unknown' category, or excluding rows. Discuss how missingness could bias funnel conversion rates and how to document the choice.

2. 6

   A recruiter claims that a new job board improved candidate quality. How would you test this?

   Suggest an A/B test or a quasi-experimental design. Define quality metrics like interview pass rate or hiring manager rating. Mention statistical significance and sample size.

3. 7

   Write a SQL query to find the top 5 job roles by number of applications in the last 30 days.

   Use GROUP BY on role, COUNT applications, filter with a date condition, ORDER BY count DESC, and LIMIT 5. Mention handling duplicates and time zones.

4. 8

   How would you build a dashboard to monitor diversity in the hiring pipeline?

   Cover data privacy, aggregation to avoid identifying individuals, and key metrics like representation at each stage. Suggest visualisations that highlight drop-off points.

Behavioural and Situational Questions

1. 9

   Tell me about a time you used data to influence a decision. What was the outcome?

   Use STAR format. Focus on the problem, your analysis, how you communicated it, and the measurable impact. Show you can translate data into action.

2. 10

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

   Highlight your process: assess data quality, document assumptions, clean or impute, and validate. Mention communicating limitations to stakeholders.

3. 11

   How would you explain a complex analytical finding to a non-technical HR stakeholder?

   Show you can simplify without losing accuracy. Use analogies, focus on the 'so what', and suggest next steps. Avoid jargon.

4. 12

   Give an example of when you received critical feedback on your work. How did you respond?

   Demonstrate openness, willingness to learn, and a concrete change you made. Avoid being defensive or blaming others.

HR and Company Fit

1. 13

   Why do you want to work in people analytics, and why in HR tech or recruitment platforms?

   Connect your interest in data to improving hiring and employee experience. Mention the scale and impact of platform data. Show you understand the sector.

2. 14

   What do you know about the ethical concerns in people analytics, such as bias in hiring algorithms?

   Discuss fairness, transparency, and privacy. Mention auditing models for disparate impact, using diverse training data, and involving humans in decisions.

3. 15

   Where do you see yourself in three years in this role?

   Show ambition aligned with the role: deeper technical skills, ownership of analytics projects, or specialisation in talent intelligence. Avoid vague answers.

4. 16

   How do you prioritise multiple data requests from different stakeholders?

   Explain a framework: impact, urgency, effort, and alignment with business goals. Mention communicating timelines and negotiating scope when needed.