Skip to content
CareersAble

Interview questions

Data Engineer interview questions

Data Engineer interview questions for each round: pipelines, data modelling and reliability, with what each round is scoring.

Answer one Data Engineer question out loud today and time yourself.

All data questions

How Data Engineer interviews are scored

Data engineer interviews score how your pipelines fail, not only how they run. Talking about late data, schema changes and how you would know something broke shows you have run pipelines in production.

What hiring managers check in Data Engineer interviews

  • Whether your pipelines can be rerun safely, because every pipeline fails eventually and duplicates break trust.
  • Whether you find out about failures before the analysts do, which shows in how you describe monitoring.
  • Whether your data models make the next query easy, since analysts are the real users of your work.

Pick the check you are weakest on and prepare one Data Engineer story for it tonight.

Questions Data Engineer candidates get

On top of the questions every role in this field is asked, these come up for this title in particular.

Screening interview questions

Usually a recruiter or talent partner, 15 to 30 minutes, often by phone or video.

  1. Which orchestration and warehouse tools have you used in production?
  2. How much data do your current pipelines move each day?
  3. Are you on call for your pipelines, and how often do they page you?
  4. Do you build batch, streaming or both in your current role?
What this round scores

Hiring manager interview questions

The person you would report to, 45 to 60 minutes, sometimes with a team member.

  1. Tell me about a pipeline that broke silently and how you found out.
  2. How do you handle a source system that changes its schema without warning?
  3. How do you rerun a failed day of data without creating duplicates?
  4. Tell me about a time you cut the cost or run time of a pipeline.
What this round scores

Final round questions

Senior leaders, a panel, or a case task, 60 minutes to half a day.

  1. Design a pipeline that loads orders from an API into a warehouse every hour.
  2. Walk me through how you would model sales data for analysts to query.
  3. Here is a slow query on a large table: how would you speed it up?
  4. Late-arriving records are changing yesterday's numbers. How would you handle it?
What this round scores

Plus the data questions every round asks

  • Walk me through your data background in two minutes.
  • Which tools do you use most: SQL, Python, R or a BI tool?
  • What kind of data and business questions do you work on now?
  • Tell me about an analysis that changed a business decision.
  • Tell me about a time the data was messy or wrong and what you did.
  • How do you explain a technical result to someone non-technical?
  • Sign-ups dropped 15 per cent last month: walk us through how you would investigate.
  • How would you design an experiment to test a new pricing page?
  • How would you set up a reporting layer for a team with no data culture?
See all 24 data questions, with scored example answers

Get the data question pack by email

Every question on this page in one email, grouped by round. Plus three things that are not on the page:

  • 12 more questions, 4 per round, that only go out by email
  • What a strong answer covers in each round, to check yourself against
  • A 7-day prep plan that matches where you are in your search
Where are you in your search?

We email you the pack once. We never sell or share your details. Privacy policy

Hiring manager interview

One question, three answers, three scores

The same question answered three ways, scored the way an interviewer would mark it.

“Tell me about a pipeline that broke silently and how you found out.”

Weak30
“An analyst told me the numbers looked off, so I checked the logs and fixed the job. It was a small bug.”
Why: Found out from a user and changed nothing to catch it next time.
OK58
“A source API started returning empty pages and our job loaded zero rows without failing. An analyst spotted it. I added a check that fails the job if row counts are zero.”
Why: Clear cause and a fix, but the check only covers this one failure.
Strong84
“A vendor API started returning empty pages and our hourly job loaded nothing for two days before finance noticed. I backfilled the gap from the vendor's export, then added row-count and freshness checks to every pipeline, alerting to our team channel. Since then we've caught four issues before any analyst saw them.”
Why: Owns the miss, fixes the data and the system, and shows the checks working.

Example scores on the 0 to 100 scale CareersAble uses. Your own answer gets its own score.

Reading the questions is not the same as answering them.

CareersAble writes the questions your actual job ad will ask, records your answers, scores each one three times and tells you plainly what to fix.

Free to start. No card needed.