First proper Senior Manager analytics interview after 9 months of grinding - and it was a complete curveball. Role was omnichannel/commercial analytics. Prepped heavily on the usual suspects:
- Stakeholder scenarios
- Ambiguity handling
- Campaign analytics and operational thinking
- SQL/Python basics
Expected questions like 'How would you handle conflicting stakeholder priorities?' or 'Walk me through a campaign drop analysis.' What I actually got:
Interviewer: 'So what are the classifications of diabetic drugs?'
Me: '...what?'
Turns out they saw my B.Pharm background and assumed deep pharma domain expertise. But my actual focus is business/operations analytics, not therapeutic knowledge. The whole interview pivoted into pharma and KPI math.
Then the universe decided to throw in cinematic chaos: power cut, unstable internet, laptop glitching before joining, family interrupting my prep. Managed to keep it together, but the finishing move was a dead-simple percentage/open-rate Excel question. Brain just went blank. Interviewer gave hints - still couldn't retrieve the formula. SQL part went fine (GROUP BY, HAVING, execution flow, campaign funnel), but by then the damage was done.
Never even got to play my strongest cards: stakeholder handling, ambiguity reasoning, operational discussions. The entire thing became 'Pharma domain + KPI maths boss fight.'
Hard lesson: short interviews are path-dependent. One clarification question can reroute the whole evaluation.
Positive side: first time handling a manager-level interview without collapsing mentally. Struggled but stayed in the conversation. Now I know where my strengths and gaps are, and how these rounds actually feel. Looking back, the absurdity of it all - just have to laugh at God's script.
