The Talent Funnel

A medium Data Modeling mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
Data Modeling
Difficulty
medium
Seniority
L5

Interview Prompt

A job marketplace tracks candidate activity from the moment a job listing is viewed through to an accepted offer. The analytics team needs to measure funnel drop-off rates at each stage, compare conversion by job type and location, track time-to-hire by company, and attribute sourcing channel credit. Design a schema that supports all of this.

Summary

Thousands applied. One accepted. Where did the rest go?

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Draw your data model on the schema canvas: tables, keys and relationships
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision