American Express Strategy & Data Analyst Interview Questions

Calculate each candidate's SQL self-rating on a five-point scale from completed assessment scores.

null handlingJoinsAggregationsAmerican Express

Solve three intermediate SQL tasks involving customer totals, monthly revenue, and customer spending ranks.

JoinsData Manipulationtechnical skillsAmerican Express

Estimate American Express revenue using a transparent, driver-based model and identify the assumptions that matter most.

KPIkpi hierarchyfinancial metricsAmerican Express

Structure a root-cause investigation for an 8% quarter-over-quarter decline in regional merchant transaction volume.

root causeKPIsKPIAmerican Express

Solve a constraint grid puzzle to match customers with their preferred American Express cards.

Estimationanalytical thinkingdata-drivenAmerican Express

Estimate the number of tea servings consumed across India in one day using transparent assumptions and a reasonableness check.

Estimationguesstimationanalytical thinkingAmerican Express