Design an ETL process (whiteboard) from source transactional system to the data warehouse to fill a report.
Sigiloso
It's essential to demonstrate that you can really go deep... there are plenty of followup questions and (sometimes tangential) angles to explore. There's a lot of Senior Data Engineer experts who've worked at SquareSpace, who provide this sort of practice through mock interviews. There's a whole list of them curated on Prepfully. prepfully.com/practice-interviews