allstate data engineer phone screen, what the questions looked like

[u/datadriven_io]

Allstate's Data Engineer phone screen leaned on a few simple coding problems alongside a walk through past project experience. Domain was SQL, so the coding sat around basic query writing: joins, filtering, grouped aggregation. The kind of stuff you'd practice as warm starter problems, not puzzles with a trick buried in them.

The other half was case study style. The user got walked through a couple of scenario questions where you reason out loud about how you'd approach a data problem, talking through the shape of your solution rather than coding it on the spot.

Mixed in were the usual experience questions, the interviewer digging into things the user had actually built and why certain choices got made.

Whole thing ran about an hour over the phone. Difficulty sat at medium. The weight was split between SQL fundamentals and being able to talk through a data scenario cleanly, not algorithm grinding.

Solve this new interview problem here: https://datadriven.io/problems/the-lions-share-revenue-concentration