Peerspace interview questions

I had an interview for what can be described as a mid-tier marketing role a few months ago. There were lots of stages, interviews with my national team lead, global head of marketing, etc, plus the usual putting together a task and presenting it, no small amount of work! This all went well until the final stage which was a 30 minute grilling from the CEO. I was admittedly forewarned about this, that he would ask me irrelevant questions, I guess to see how I think under pressure? I wasn't asked a single question relevant to my experience or the role I was applying for, nor would my role have been one which reported directly to him. The whole thing felt like a power play for its own sake and I question why someone with such an impressive career and I'm sure so many important things to do feels the need to flex in such a way? Does he not trust the opinion of senior management? You might think this review is me being bitter and I suppose that is true - I could have done the role easily. I question the purpose of this interview stage with the CEO.

Interview Length & Format Initial Recruiter/HR Screen: ~30 minutes Focuses on your background, why you’re interested, and logistics (salary expectations, timeline, etc.). Hiring Manager / Analytics Team Interview: ~45–60 minutes Mix of behavioral questions (“Tell me about a time you…”) and technical deep dives (SQL, Tableau, marketplace metrics). Technical Assessment / SQL Exercise: 45–90 minutes (sometimes take-home, sometimes live). You’ll likely be asked to write SQL queries and then explain the business meaning. Cross-functional Panel (Product, Marketing, Ops, Finance): ~1 hour total (either split across 2–3 shorter conversations or one larger panel). They’ll test how you communicate insights to non-technical stakeholders. Final Round / Culture Fit / Exec Chat: ~30 minutes. This tends to be lighter, focused on collaboration, communication, and career growth.