Data · Interview questions

Data Analyst interview questions

These questions test whether a candidate can answer real business questions from existing data and get people to act on the answers. Each links to a first-year outcome: agreed metrics, a used dashboard, fast and repeatable requests, analyses that change decisions and reliable data.

The questions

Ask every candidate the same questions in the same order, and score each answer against the notes before you talk it over with the panel.

  1. Tell me about a time two teams reported different numbers for the same metric. How did you resolve it?

    What it tests
    One agreed definition per metric
    A strong answer
    They traced each number back to its source and logic, found the difference, such as date range or filters, and got both teams to agree one written definition.
    Watch for
    They picked the number they preferred without agreement.
  2. Show me or describe a dashboard you built that people used every week. How do you know they used it?

    What it tests
    Self-serve dashboard
    A strong answer
    They describe a focused dashboard built around a few questions, with feedback from users and usage they can point to. They removed charts nobody used.
    Watch for
    They are proud of how many charts it had, not who used it.
  3. Using this sample database of orders and customers, write a query for monthly revenue by customer region, and another for the share of customers who ordered again within 90 days.

    What it tests
    SQL and repeatable requests (work sample)
    A strong answer
    The queries are correct, handle edge cases like refunds or missing regions and are easy to read. They explain their assumptions.
    Watch for
    Joins that double-count rows without them noticing.
  4. You receive five data requests on Monday morning and can only finish two this week. How do you decide, and what do you tell the others?

    What it tests
    Handling requests within 3 days (scenario)
    A strong answer
    They ask about the decision each request supports and its deadline, agree priorities with a manager if needed and give the others a clear date. Some requests may be pointed to an existing dashboard.
    Watch for
    They work in order of arrival or try to do everything badly.
  5. Tell me about an analysis you did that changed a business decision. What was the question, what did you find and what happened next?

    What it tests
    Analyses that lead to decisions
    A strong answer
    They describe a clear question, a sound method and a specific decision that followed, such as stopping a channel. They mention how they measured the result afterwards.
    Watch for
    The analysis was interesting but nothing changed.
  6. Sign-ups dropped 30 percent last week. Walk me through how you would find out why.

    What it tests
    Investigating with existing data (scenario)
    A strong answer
    They first check whether the data or tracking broke, then break the drop down by channel, device, region and page. They test likely causes, such as a release or ad change, before drawing conclusions.
    Watch for
    They jump to a cause without checking the data first.
  7. Tell me about a time a report you produced showed wrong numbers. How did you find out and what did you change?

    What it tests
    Data quality checks
    A strong answer
    They explain how the error was found, owned it and traced the cause. They added an automated check or test so the same problem would be caught before reaching a report.
    Watch for
    They fixed the number once and added no check.
  8. Explain a finding from your past work to me as if I were a sales manager with no data background. Include how confident you were.

    What it tests
    Plain-language communication (essential requirement)
    A strong answer
    They lead with the answer and what it means for the listener, use one clear example and state limits honestly, such as sample size.
    Watch for
    They talk mainly about methods and tools.

New to structured interviews? Read how to run structured interviews and how to build an interview scorecard.

Start from the job description

These questions follow the first-year outcomes in the matching template.

Data Analyst job description template

Similar roles

Your next hire, start to finish, in one place.

Free workspace. No card. Full scoring free for 7 days.