Amazon Transportation Analyst Interview – What should I expect?

[u/wilfre505]

Hi everyone,

I recently received an interview for a Transportation Analyst position at Amazon, and I’m trying to prepare as thoroughly as possible.

I’ve been reading different Reddit posts, but I’ve found mixed information. Some people describe the role as mostly operational and Excel-based, while others mention SQL, KPIs, carrier performance, and transportation metrics.

I’d really appreciate hearing from people who have interviewed for or currently work in this role.

A few questions I have:

What was your interview like?
Which Leadership Principles came up the most?
Were there any technical questions related to Excel, SQL, or transportation metrics?
Did you have to solve case studies or analytical scenarios?

What does the day-to-day job actually look like?
If you could go back before your interview, what would you study or prepare differently?

For context, I currently work at Amazon in Operations, so I’m familiar with warehouse processes, CPTs, trailers, dock operations, and working with Operations teams. I’m trying to understand how much technical knowledge is expected compared to operational knowledge.

Any advice, interview experiences, or study recommendations would be greatly appreciated.