Dataford
Dataford
Top 18
Prep plan
Updated weekly · Last refresh Oct 17

Affirm Risk Analyst Interview Questions

The questions to prepare for a Affirm Risk Analyst interview. Questions from real interview reports rank first. Updated daily.

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 1 drill · ~47 min
Top Failed Payments in Rolling WindowHard
Practice

Identify Affirm accounts with the most failed payment attempts in any rolling 10-minute interval.

Window Functionsabuse trackingRankingAffirm
Chargeback Spike Merchant QueryMedium
Practice

Identify Affirm merchants with at least a 50% week-over-week increase in chargebacks using weekly aggregation and date comparisons.

Date Functionssqldata anomalyAffirm
Join Choice in Risk MonitoringEasy

Tests SQL fundamentals and ability to reason about join semantics in fraud monitoring pipelines.

JoinssqlAffirm
Deduplicate Merchant AccountsMedium

Tests SQL/data modeling judgment for deduplicating entities with fuzzy name variations.

deduplicationData Wranglingdata integrityAffirm
Build Monthly Retention Cohort TableHard
Practice
Practice drill

Build a monthly customer retention cohort table using CTEs, date math, and conditional aggregation.

Window FunctionsDate FunctionsAggregationsBoltDaveAffirm
2
Strategy4 questions · ~37 min
Decide Keep Modify RollbackHard

Assess whether Affirm should keep, modify, or roll back a feature that doubles fraud and conversion.

business strategyAffirm
Investigate Defaults vs Fraud RingHard

Investigate whether a regional loan default spike at Affirm is due to credit deterioration or organized fraud.

root causeanalytical thinkingcredit riskAffirm
Risk Scoring for New MerchantsHard

Design a merchant risk score to automate Affirm onboarding while reducing fraud exposure.

analytical thinkingBusiness Acumendata-drivenAffirm
More Strategy questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership10 questions · ~93 min
High-Stakes Decision With Incomplete DataMedium

Tests decision-making under ambiguity, risk assessment, and stakeholder alignment when product data is incomplete or contradictory.

Decision MakingOwnershipDealing With AmbiguityAffirm
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 18 questions plus 1 hands-on drill to finish this plan.