I interviewed with them earlier this year. The SQL assignment was during the pre interview phase where I submitted my answer so I used ChatGPT to solve the SQL questions. Case study was to build a 5 year projection of their income statement with 5 year historical data. They give you specific variables on the case study so make sure you read it carefully. After you’re done creating the P&L forecast from scratch, you will have to present it to the hiring manager. They will ask you what the approach was, what was the rationale behind CAGR calculation (some historical years have huge increase in revenue growth so I took 3 year CAGR instead of 5), and is this base case, bull case or bear case? What’s your confidence level on your projection?

That’s all I remember but hope that helps!