First, an OA including Python and SQL questions. Then an interview of only SQL, where we could use AI to help us. Then a life story interview, which was fully behavioural.

1) An OA where AI use is allowed: one SQL and one Python question. With AI, only took about 15 minutes. 2) A take-home assessment with several datasets, specific querying questions, and open-ended questions. I used pandas for this portion. AI is allowed. A small report required to summarize and share your insights. 3) Technical interview: Very similar to the take home, but done in SQL. Be prepared to use AI to your fullest extent. I essentially copy pasted the question into ChatGPT and got the answer. Make sure you understand the code being outputted and are able to show creativity and logic. 4) Behavioral interview: A resume walk-through with questions focused on your passions and what led you to this role, and some STAR questions. Nothing out of the ordinary here.