interviewing for a Senior Financial Analyst role at Capital One in about 3 weeks. would love to hear from anyone who's done their loop recently, especially on the analytics or finance side.
specifically curious about: how many rounds and what format (case? sql? excel modeling?) whether they do a presentation round how behavioral-heavy it is vs technical timeline from final round to offer
anything from the last 6 months would be super useful. data engineering and data science loops welcome too since there's probably overlap. drop what you know.
5 replies
ds_dmitri
did a data science loop about 4 months ago. three rounds: sql assessment (timed, HackerRank-style), a case study where you get a dataset and present back insights, then a behavioral round. the sql was harder than i expected, window functions and some tricky joins. the case study had a 3-day take-home component.
finance_faye
3-day take-home is more than i expected. was it open-ended or did they give you a specific question to answer with the data?
ds_dmitri
open-ended with guardrails. they gave me a fake capital one dataset (customer transactions) and said "tell us something interesting." the point was to see what you chose to look at, not just whether you could run a regression.
analyst_ana
did a BI analyst role there last year, not sure how much has changed. had a panel round with a SQL live-coding question and then a presentation of a past project. behavioral questions were basically capital one leadership principles in disguise. know those going in.
de_derek
data engineering at capital one is a different animal than most places. they have a massive internal platform and they actually care if you understand distributed systems, not just Spark syntax. expect design questions alongside the coding.