tideline

live · checked 03:02 UTC

Data engineer and analyst interview preparation

General preparation, not from any one company

Data interviews usually test SQL, how you model and move data, and how you turn numbers into decisions. Engineering roles lean on pipelines; analyst roles lean on questions and clear answers.

  1. SQL

    What they’re checking: Fluent, correct queries, and whether you notice duplicates, missing values and time zones.

    • Find each customer’s first order and how many orders they placed in the next 30 days.
    • Your query’s total doesn’t match the finance report. How do you track down the difference?

    How to prepare: Practise joins, window functions and grouping on a small dataset, and say aloud what each step returns.

  2. Data modelling

    What they’re checking: Whether you design tables people can query correctly without asking you.

    • How would you model orders, refunds and partial shipments for reporting?
    • When would you keep history of a changing value, and how?

    How to prepare: Sketch the model of a dataset you know, and the question it answers badly today.

  3. Pipelines

    What they’re checking: Reliable data movement: retries, late data, and checks that catch problems before people do.

    • A daily job silently loaded half the rows. How would you have caught it?
    • How do you make a pipeline safe to run twice?

    How to prepare: Prepare one pipeline you built or fixed, with how it failed and the check you added.

  4. Analysis and judgement

    What they’re checking: Whether you ask the right question first and say how sure you are.

    • Sign-ups dropped last week. How would you work out why?
    • How would you tell whether a change caused an improvement or just came before it?

    How to prepare: Bring one analysis where the answer surprised you, and how you checked it before sharing it.

  5. Communicating results

    What they’re checking: Clear, honest summaries for people who don’t read SQL, and a sensible chart rather than a busy one.

    • Explain a finding of yours to someone in sales, in two minutes.
    • Tell me about a time your data said something people didn’t want to hear.

    How to prepare: Practise a two-minute summary of one project: the question, the answer, how sure you are, what to do next.

Answering well

For “tell me about a time” questions, the STAR shape keeps an answer clear: the situation, your task, the action you took, and the result, with what you learned. Use your own stories; there is no right script to memorise.

Companies differ: check what each one publishes about its own interviews before you prepare for it.