Wood Mackenzie Data Analyst Interview Questions & Reviews

Interview Details – Fairly straightforward initial process. Received a call from HR to set up a phone interview later within the next few days. The phone interview consisted of basic behaviorial questions (tell me your strengths, why do you want to work here, walk me through your resume, etc). I was told I would be notified if I would make it to a 1:1 interview which would have a skills test. They made it clear that I would be tested on Acess, Excel, and VBA (these programs were highlighted in the job posting).

I got a call back to interview in person, and it began with the skills test. I was given an hour to complete the tests, the Access test had 3 things to do (build databases and organize data), the excel test had 5 or 7 tests (vblookup, sumif, countif, pivot tables, etc), and then the VBA was one test (dont really remember the deatils on this one.

Then came the group interview. Two people came in and were mostly interested in my technical experience using the 3 aforementioned programs. This was most of the interview, along with some general interview questions like were asked on the phone. Afterwards, three of the Wood Mack's employees come in for about 20 min so you can ask them any questions about work culture or anything else.

I was told they would get back to me, but sadly I didn't get the job. Everyone is super nice and it seems a great company to work for.