Several rounds of conceptual video interviews and data related challenges followed by a 3 hour long hands on data analysis challenge. I was only allowed to use an uncommon querying environment that even their own head data engineer was not familiar with.