Interview with HR, then with two team members. Next, there is a live-coding session of 90 minutes.

I didn't pass further, but as I understood, the next steps are a homework assignment and an interview day at the office. Very professional and respectable approach overall, flexible in scheduling, and they set time aside to answer questions. They politely stated the default in-office presence, despite their overall policy.

The live coding session wasn't hard, but I would have done it better five years ago. It's not easy to refresh SQL/pandas muscle memory in one day of prep if you don't do that daily.

About the preferred way of working, performing under stress in a fast-paced environment.