I almost took a "big data" data scientist job about a year ago with a local company.

After talking to a number of their engineers, it became quite clear to me that instead of a data scientist, they just badly needed a DBA / someone with ownership and a complete vision of the data structure.

They had no foreign keys, poorly 'designed' indexes, and tons of redundant tables with no rhyme or reason to them.

They'd organically grown their database with hardly any review. They did not have big data, they just had a big mess. And wanted someone else to clean it up.