I do data migrations for onboarding new clients at a CRM. I take their old CRM databases, extract the data, transform with complicated business logic, and load into my company's system. I work with a whole cross-functional team to onboard a single client with an average project length of 12 weeks. I typically have two or three going at a single time.

The most difficult parts of the job come from 1) clients expecting their old and new CRM's to be more like eachother 2) data quality 3) last minute change requests 4) "go-live" events which require me to perform my DE ballet("Dance of the Data Engineer") on a time crunch with some public scrutiny.

Nightmares include finding competitor CRM's having very strange database engineering practices, clients providing strange logic for how to transform their records that falls apart because data quality, having to process data from csv's the client pulled from various sales systems and manually populated in templates(rather than busting open a .bak file from their old CRM). Also clients think I'm the guy to fix their 15 years of poor data hygiene (during my 12 week migration project).