American Express Data Analyst Interview Questions
American Express's data analyst interview runs three rounds over 3-5 weeks: a timed online assessment covering SQL, coding, logical reasoning, and a personality assessment; two interactive technical rounds with senior analysts or managers testing resume details, live coding, and logic puzzles; and a final managerial round focused on case studies and cultural fit. About 64% of candidates rate the process as medium difficulty, and several report the tone shifting from technical to a more situational, work-ethic-focused conversation in later rounds.
Interview Process Overview
| Round | Format | Typical Length | Difficulty |
|---|---|---|---|
| Online Assessment | SQL, coding, logical reasoning, personality test | 60-90 min | Medium |
| Technical Round 1 | Live coding, resume deep-dive | 45-60 min | Medium |
| Technical Round 2 | Logic puzzles, case-based problem solving | 45-60 min | Medium |
| Managerial Round | Case studies, cultural fit | 45-60 min | Medium |
Commonly Reported Interview Questions
Technical / SQL
- Advanced SQL: window functions, joins, CTEs — Practice ranking, running totals, and multi-table joins; Amex's transaction data makes these skills central to the role.
- Python/Pandas data manipulation — Be ready to clean and transform a messy dataset live, explaining each step.
- A/B testing and experimentation design — Understand statistical significance, sample size, and common pitfalls like peeking at results early.
- Machine learning and statistical modeling basics — Know when to use logistic regression vs. tree-based models for a churn or fraud-flagging use case.
Logic & Problem-Solving
- Classic logic puzzles (e.g., hourglasses, defective items, candles) — Practice a handful of common puzzle types so the format doesn't throw you off.
- Business case study / revenue estimation — Structure your answer with clear assumptions and a logical framework (top-down or bottom-up).
- Guesstimation exercises — Show your reasoning process out loud; the interviewer cares more about structure than the exact number.
Behavioral / Managerial Round
- STAR-formatted stakeholder communication scenario — Describe presenting a technical finding to a non-technical audience and adjusting your framing.
- "Tell me about a time your analysis changed a business decision." — Quantify the outcome wherever possible.
- "How do you prioritize when you have multiple analytics requests at once?" — Show a clear framework for triage.
How to Prepare
Get comfortable with advanced SQL (window functions, CTEs) and Python/Pandas, since these are the most consistently tested technical skills across Amex's rounds. Prepare a few STAR stories that demonstrate translating a data finding into a concrete business decision, since the managerial round increasingly leans into situational and work-ethic questions beyond pure technical assessment.
FAQs
What SQL skills does American Express test most? Window functions, joins, and CTEs come up frequently, reflecting the complexity of Amex's transaction and customer datasets.
Does American Express ask machine learning questions for data analyst roles? Yes, at a foundational level — expect questions on when to use specific models and how to evaluate them, even if the role isn't a dedicated data science position.
How difficult is the American Express data analyst interview? About 64% of candidates rate it medium difficulty — technically substantive but not typically as intense as top-tier tech company loops.
What tools should I know for an Amex data analyst interview? SQL, Python (especially Pandas), and BI tools like Tableau or Power BI are the most frequently referenced.
How long does the American Express data analyst hiring process take? Most candidates report 3-5 weeks from the online assessment to a final decision.
Related Interview Guides
- American Express Financial Analyst Interview Questions
- Citi Data Analyst Interview Questions
- JPMorgan Data Analyst Interview Questions
- Senior Data Analyst Interview Questions
- Entry-Level Data Analyst Interview Questions
SQL fluency and clear business storytelling win Amex interviews. InterviewBoost.ai's AI Mock Interviews rehearse window-function SQL and case-study questions, and Live Interview Assist supports you through the real thing. Start prepping free with InterviewBoost.ai.