Candidates describe a Forter Data Analyst process that starts with a timed home assignment: a logic puzzle plus a spreadsheet analysis. Some report a follow-up interview with SQL or scenario questions.
$113K
Avg. Base Comp
$130K
Avg. Total Comp
Not reported
Typical Rounds
Not reported
Process Length
Five candidates describe a timed home assignment with two parts. The sixth describes a proctored online test mixing Excel and logic puzzles. None of the six reports an offer. The first part is a logic game, usually called "Find the Robber" or "The Robber Test". You get a table of suspects and clues and must work out who did it. Candidates say it tests how you reason as new information arrives, and one candidate found the logic section genuinely tricky.
The second part is a timed spreadsheet analysis. Candidates report roughly 12 to 15 questions in Excel or Google Sheets, with windows of about 75 minutes. Some questions go beyond formulas. One candidate was asked which metrics best serve a business goal, what extra data would help explain fraud patterns, and what a given column represents. Another reported pivot tables and filtering on large datasets. One candidate also reports the work could not be paused. Practice explaining why a metric matters before you calculate it, and get comfortable in Google Sheets first.
Two candidates report a live stage after the assignment. One described scenario questions: estimating a city's electric scooter riders, deciding what data to collect, and reading point density on a map. That candidate also faced a behavioral question on why Forter and this role. The other described an in-person SQL test covering completing code, fixing errors, and writing queries. Review SQL you didn't write.
Three candidates report long silences or vague feedback after submitting, so don't expect quick updates.
Synthesized from 6 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Forter process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Forter
How would we build a model to detect fraud and text customers to approve or deny fraudulent transactions
| Question | |
|---|---|
| Credit Card Fraud Model | |
| Empty Neighborhoods | |
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Customer Orders | |
| Top Three Salaries | |
| Comments Histogram | |
| Closest SAT Scores | |
| Experiment Validity | |
| First to Six | |
| Monthly Customer Report | |
| Download Facts | |
| First Touch Attribution | |
| Compute Deviation | |
| Last Transaction | |
| Random SQL Sample | |
| Top 3 Users | |
| Employee Salaries (ETL Error) | |
| Button AB Test | |
| Lowest Paid | |
| 500 Cards | |
| Minimum Change | |
| Raining in Seattle | |
| Bagging vs Boosting | |
| Subscription Overlap | |
| Month Over Month | |
| Prime to N | |
| Paired Products | |
| Upsell Transactions |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report receiving the assignment by email with no earlier conversation. Reports mention a window of about a week to complete it. The sections are timed, and one candidate reports they could not be paused, so you should block out about two uninterrupted hours.
Every candidate describes a deduction puzzle. You get a table of suspects and a story, and some report new details being revealed in stages. It rewards explaining your reasoning and adjusting as information changes. One candidate called it a warm-up, while another found it genuinely tricky.
Candidates report Google Sheets or Excel work: pivot tables, filtering, trends, and business questions about metric choice, missing data, and what a column means. One candidate called the time tight, and another had to learn Google Sheets during the window.
Two candidates report a live stage. One described scooter-rider estimation, data-collection and map-density questions, plus a why-Forter question. The other described an in-person SQL test on completing code, fixing errors, and writing queries. It may not happen for everyone, since several candidates report ending after the assignment.
All six candidates report no offer. Several describe waiting weeks, with one reporting about two weeks of silence, and receiving little or no feedback. Plan on not hearing back quickly.
