Lovely interview team. You get to meet analysts at different levels which is great for asking questions. SQL test is reasonably difficult, but at the very least you should comment your approach to each problem (pseudocode).
Interview questions [1]
Question 1
The questions are trying to find out if you think like an analyst. Specific knowledge about the sector is not necessarily required.
I applied online. The process took 4 weeks. I interviewed at More2 (London, England) in Jan 2022
Interview
Applied through a recruiter and once passing some competency based questions over the phone, I was asked to complete 2 tests. One for maths and one where we were asked to notice patterns and trends. When I passed those, I was asked to create a presentation on a chosen brand, which was presented in my first interview. Then I had a follow up interview.
Interview questions [1]
Question 1
Are you familiar with a variety of business terms?
I applied online. The process took 2 weeks. I interviewed at More2 (London, England) in Jan 2020
Interview
After passing first round of technical tests: 2-on-1 chat followed by 30 min case analysis and presentation to 2 senior analysts.
From the interview and feedback, what I’m getting is, this role is much more sales & marketing than analysis. GCSE-level math plus one week of marketing experience will let you pass this interview, a degree in statistics but with no marketing experience will not.
Interview questions [1]
Question 1
What recommendation will you give the client to increase their sales.