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.
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.
- Which orchestration and warehouse tools have you used in production?
- How much data do your current pipelines move each day?
- Are you on call for your pipelines, and how often do they page you?
- Do you build batch, streaming or both in your current role?
Hiring manager interview questions
The person you would report to, 45 to 60 minutes, sometimes with a team member.
- Tell me about a pipeline that broke silently and how you found out.
- How do you handle a source system that changes its schema without warning?
- How do you rerun a failed day of data without creating duplicates?
- Tell me about a time you cut the cost or run time of a pipeline.
Final round questions
Senior leaders, a panel, or a case task, 60 minutes to half a day.
- Design a pipeline that loads orders from an API into a warehouse every hour.
- Walk me through how you would model sales data for analysts to query.
- Here is a slow query on a large table: how would you speed it up?
- Late-arriving records are changing yesterday's numbers. How would you handle it?
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?
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
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.”
“An analyst told me the numbers looked off, so I checked the logs and fixed the job. It was a small bug.”
“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.”
“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.”
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.