Upstart Data Scientist Interview Experience — SQL Screen Then a Four-Round Onsite Full of Case Studies

Three SQL questions, no need to actually run the query. There's a marketing table (by marketing_touch), and another one is a conversion table.
The first question is to calculate avg count by month. The second is to find the last touch before conversion, by company (or by month, I don't quite remember). The third is: conversion and last touch both happened in some particular month, and how many companies match that; bonus question: what if last touch to conversion is <= 45 days.

Onsite: 4 rounds.
The first one was a case study, for partnership marketing. They showed me a NerdWallet page with various loan providers on it, like SoFi, Upstart, etc. There were a lot of questions — basic ones like what insights you can get from this page, what's different about the various competitors' info. The deeper questions were about the user application flow — there are two scenarios, one where you apply directly on NerdWallet, and one where you get linked over to the Upstart flow. My interviewer told me this was a new question and he himself wasn't that familiar with it either, so it took him a while to organize his words to ask it — kind of funny.
Second round was with a BP (business partner). This one was entirely about my work background — first they had me walk through my career in chronological order and the reason for each job change. The other part was asking about my current company, and talking about what its competitive advantages are — they went pretty deep on that.
Third round, the most annoying one — a presentation. They gave me an experiment on a user signup flow, with some data, and asked whether to ship it or not, plus what other insights there were besides the experiment itself. During the Q&A, the HM asked me how much time I'd spent on it, and it seemed like he wasn't satisfied that two hours was enough — like I hadn't dug deep enough. There were a lot of different interviewers in this round — an HM from another team, plus a BP, plus an analyst — everyone asked some questions.
The last round was another case, mainly about marketing by channel. There was data like visits, spend, form starts, form completions, and loans funded, and the question was which channel was effective, and where to put money going forward.

Overall the interview content felt pretty standard, but you have to spend quite a bit of time on the presentation to dig up more content.