What should go in the handover when your only data engineer leaves?

A handover from your only data engineer should capture everything that lives only in their head, then prove it by running a week without them. Cover credentials and their owners, job schedules, dependencies, business definitions, tests, past incidents, and how to recover a failed load. Profile the data before they leave, so you can separate inherited problems from new ones.

Key points

  • A data engineer's handover has seven parts: credentials, schedules, dependencies, business definitions, tests, incident history, and recovery steps. The ones that break first are the ones nobody wrote down, such as an API token that expires every 90 days.
  • Profile the data before the engineer's last day. A dated baseline separates the problems you inherited from the problems that start after the handover.
  • Hero dependency is when one person holds the knowledge the team needs to resolve incidents. It looks like resilience until that person is gone.
  • Business logic is the hardest part to hand over, because the same rule often lives in three places and nobody knows which copy is authoritative.
  • Recovery steps need a rehearsal, not a paragraph. A load that isn't idempotent turns 1,000 rows into 2,000 when someone reruns it.

On a one-engineer team, the handover document is the data team. Whatever isn’t in it leaves with them.

DataKitchen calls this hero dependency: one person holds the knowledge the team needs to resolve incidents. It looks like resilience until the hero is gone. Our 2021 survey of 600 data engineers found 97% reporting burnout, and burned-out engineers change jobs and take the tribal knowledge with them.

You have weeks, not months. Spend them on the list below.

The seven-part handover

PartWhat to captureHow to check it’s real
CredentialsEvery account, key, and token, who owns it, and when it expiresLog in with each one yourself before their last day
SchedulesEvery job, when it runs, and what triggers itCompare the list with the orchestrator, not with memory
DependenciesWhich sources feed each pipeline, and which reports read itPick one report and trace it back to its sources together
Business definitionsThe one authoritative copy of each key metricAsk the report’s owner to confirm each definition
TestsWhat runs, what each failure means, and who acts on itBreak a test on purpose and watch who gets told
Incident historyWhat broke in the last year, why, and how it was fixedRead the list together and mark causes that still exist
RecoveryHow to rerun a failed load safely and roll back a bad oneDo a rerun with the leaver watching

The right-hand column is the handover. The middle column is just notes.

The items on a timer

The things that break first are the ones with a clock on them. You Built the Thing. Now You’re Stuck Running It. lists the usual suspects: an API token that expires every 90 days, a database password in plain text in a script, a job that runs when someone remembers to run it. Each one works fine until the week after the person who knew about it is gone. Put every expiry date on a shared calendar now.

Business logic is the hard part

Credentials take an afternoon. Definitions take the rest of the notice period. Process guardianship describes the usual state: the same rule implemented three ways in three places, with nobody sure which is authoritative. Ask the leaving engineer to point at the one true copy of each key definition. Then turn each one into a test, because a written rule stops being checked the day its author leaves and a test doesn’t.

The best rules live in someone else’s head anyway, usually an analyst’s. Bring the analyst into this part.

Profile the data before the last day

The First Move When You Inherit Someone Else’s Data gives the order: profile first, take the keys second. A dated profile records null rates that break reports, schema violations, odd distributions, and broken joins as they stood before the handover. When a bad report turns up in six months, you can show whether it predates you. Without that record, every problem becomes yours.

Rehearse recovery

A recovery paragraph nobody has followed is a guess. Have the person staying rerun a failed load while the leaver watches. This is also when you find out whether the loads are idempotent. Where to Actually Start with DataOps in 2026 describes the failure: rerun a load that isn’t idempotent and 1,000 rows become 2,000, with nobody watching the row count.

If nobody is staying, that’s a different problem. Then the handover goes to whoever runs the pipelines next, and the same seven parts apply.

Frequently asked questions

Short answers to the follow-up questions people ask next.

What should a data engineer document before leaving?

Seven things: every credential and who owns it, every job schedule, the upstream sources and downstream reports each pipeline touches, the business definitions behind key metrics, the tests and what each failure means, the incident history, and the steps to recover a failed load. Then have the person staying run a normal week while the leaver watches and corrects.

Why profile the data before a data engineer leaves?

Because every problem in the warehouse becomes the new owner's to explain the day the handover ends, including the ones that predate them. A dated profile records null rates, schema violations, odd distributions, and broken joins as they stood before day one. When someone finds a bad report six months later, you can show whether it was inherited or new.

Which handover items get forgotten most often?

The ones on a timer. API tokens that expire on a schedule nobody wrote down, a password sitting in a script, a job that only runs when someone remembers to run it, and the month-end steps done once a month by memory. Write each one down with its date and owner, then add a calendar reminder before it expires.

How do you hand over business logic in a data pipeline?

Consolidate it first, then test it. Business logic tends to live in several places at once, so the same rule exists three ways and nobody knows which copy is authoritative. Have the leaving engineer point to the one true copy of each key definition, delete or flag the others, and turn each rule into a test so it keeps checking after they go.

What is hero dependency on a data team?

Hero dependency is when one person holds the knowledge a team needs to resolve incidents. It looks like resilience until that person is on vacation or leaves, and it discourages documentation, because the hero is rewarded for being the only one who knows. On a one-engineer team it is the default, which is why the handover has to be written, tested, and rehearsed.

Try it on your own data

DataOps TestGen is free and open source. Profile a table and generate its tests this afternoon.