went through the CrowdStrike data engineer interview process earlier this year for their Threat Intelligence data platform team out of Austin. posting because i couldn't find anything specific when i was prepping and ended up winging more of it than i'd like.
the loop was 5 rounds total.
phone screen was pretty light. recruiter call, then a 30-min technical with a DE on the team. they asked me to walk through a pipeline i owned end-to-end: ingestion, transformations, how i handled late-arriving data. nothing algorithmic.
onsite (virtual) was 4 back-to-back sessions: SQL deep dive. not easy. window functions, CTEs, a question about deduplicating event logs across a 7-day window. they care that you know how to write efficient queries, not just correct ones. one of the panelists mentioned they work with Snowflake and some internal tooling, so if you can speak to query optimization there it helps. pipeline design round. given a scenario: ingest 50M security event records per day from endpoint sensors, normalize them, make them queryable with p99 latency under 200ms. they weren't looking for one right answer. they wanted to see you think through tradeoffs between batch and streaming, how you'd handle schema drift, what you'd monitor. data modeling. they asked me to model a schema for tracking file hash reputation changes over time. CDC-style, slowly changing dimensions. if you've worked with time-series or audit tables, lean in. behavioral. standard stuff but with a security tilt. one question i remember: describe a time you built a pipeline where correctness mattered as much as speed. (the answer they want involves how you validated outputs, not just how fast it ran.)
what they weight heavily: you need to talk about data quality and reliability as first-class concerns. this is a security company, bad data has real consequences. i mentioned anomaly detection on pipeline outputs and that landed well.
comp for the offer i got: senior DE, Austin, base around $155k, RSU grant about $160k over 4 years. total first-year TC around $195k including a sign-on.
overall process took about 4 weeks from first recruiter call to offer. panel was sharp, asked good follow-ups. worth the prep.