American Express Global Business Travel Operations Analyst Interview Questions

The questions to prepare for a American Express Global Business Travel Operations Analyst interview. Questions from real interview reports rank first. Updated daily.

2questions

~1htotal time

Track your progressSign up free to work through all 2 questions and resume where you left off.

Start practicing free →

StrategyStart here. 1 question · ~8 min

Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive Analysis

American Express Global Business Travel

SQL & Data Manipulation1 question + 3 drills · ~38 min

Favorite Excel FormulaEasy

Assesses practical familiarity with Excel for data analysis tasks.

Excel

American Express Global Business Travel

Merge Client Revenue with Lookup DefaultsEasy

Practice

Practice drill

Merge client lists with historical revenue using lookup-style joins and null handling.

JoinsData WranglingAggregations

American Express Global Business Travel

Monthly Spend by Region and CategoryEasy

Practice

Practice drill

Aggregate March 2024 Egencia booking spend by region and travel category using GROUP BY and TO_CHAR in PostgreSQL.

PivotData WranglingAggregations

American Express Global Business Travel

Rank Clients by SpendEasy

Practice

Practice drill

Rank American Express GBT clients within each region using aggregation, a LEFT JOIN, and the RANK window function.

Window FunctionsRankingAggregations

American Express Global Business Travel

Sign up to see every question

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

Get my prep plan

The finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.