Google Business Analyst Interview Questions | Glassdoor

Google Business Analyst Interview Questions

31 Interview Reviews

Experience

Experience
44%
33%
22%

Getting an Interview

Getting an Interview
40%
29%
11%
7
3
3
3

Difficulty

3.3
Average

Difficulty

Hard
Average
Easy

31 Candidate Interview Reviews Back to all Interviews

Filter

Sort: Popular Date Difficulty

Filter

Sort: Popular Date Difficulty

Helpful (1)  

Business Analyst Interview

Anonymous Interview Candidate in Mountain View, CA
No Offer
Neutral Experience
Difficult Interview

Application

I applied online. The process took a week. I interviewed at Google (Mountain View, CA) in July 2011.

Interview

Had an initial call with two different recruiters to discuss which groups were interested. Very unorganized as neither knew I had spoken to the other. Then a phone interview with members of the group. Asked some brainteasers and some strategy/consulting-type questions, but pretty brief. Heard back from a recruiter the next day about continued interest and was scheduled to fly to Mountain View the next week.

Interview Questions

Other Interview Reviews for Google

  1.  

    Business Analyst Interview

    Anonymous Interview Candidate in Los Angeles, CA
    No Offer
    Negative Experience
    Difficult Interview

    Application

    I applied through college or university. I interviewed at Google (Los Angeles, CA) in February 2011.

    Interview

    The interview process was through the University on campus recruiting. The school shared a database of possible candidates for different functions based on interests and experience. From that, Google picked the people for interviews.

    At the beginning a thought that the process was weird since the recruiters at Google were very inflexible with the interview hours and dates (considering that I was an student). But in the end I yielded since it is Google right? Probably they have a lot of people who want to work there. Then at the time of the interview (was by phone), the interviewer called me almost 40 minutes late and spent probably 30-35 minutes talking about himself and his projects. I was really expecting an interview where the interviewer was interested somehow in getting to know me more and who would have spend the 45 minutes we had for that call more wisely. But again, they are Google, right? They can do pretty much what they want. The rest of the time we basically spent it talking about my thoughts on a few of his projects and one business case.

    Interview Questions

    • The most difficult questions was regarding my understanding of the education industry and how I could help institutions to attract better people to the system (students) and why would that be better than bringing anyone who could pay the tuition in the long term. This question was more like a regular consulting business case with a very limited amount of time   1 Answer

  2. Helpful (3)  

    Business Analyst Interview

    Anonymous Interview Candidate in Mountain View, CA
    No Offer
    Negative Experience
    Difficult Interview

    Application

    I applied online. The process took 2+ months. I interviewed at Google (Mountain View, CA) in December 2009.

    Interview

    During the first phone interview, mainly he asked about my current work experience. Then he moved on to a business case question that was similar to the job posting. At the onsite interview, I interviewed with 5 people, each individually. They asked about my work experience, what I did after work, and more business case interviews.

    Interview Questions

    • How many websites are on the internet? How would you find out the number?   4 Answers

  3. Helpful (8)  

    Business Analyst Interview

    Anonymous Interview Candidate in Mountain View, CA
    No Offer
    Positive Experience
    Difficult Interview

    Application

    I applied through a staffing agency. The process took 3 weeks. I interviewed at Google (Mountain View, CA) in May 2009.

    Interview

    During all the interviews, the interviewers started with the basic background questions, but then eventually evolved into a series of "test" questions (which mostly seemed prepared in advanced). These were used to get an idea of your overall "thinking skill" - not specific to the job. They were stories that required reasoning and not jumping to the first answer that comes to mind. Overall, they appear to test you general logical reasoning skills/intelligence.
    The interviewers also typed all of my answers as I spoke. I suppose this is to record my responses in a database so that if I ever apply for a job again at Google, the new interviewers can see my prior responses.

    Interview Questions

    • If someone came to you and asked you to rebuild the Golden Gate bridge, how would you go about it?   1 Answer

  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review


  5. Helpful (2)  

    Business Analyst Interview

    Anonymous Interview Candidate in London, England (UK)
    No Offer
    Negative Experience
    Difficult Interview

    Application

    I applied online. The process took 3+ months. I interviewed at Google (London, England (UK)) in September 2016.

    Interview

    Applied online in July, took a few weeks to get a response from Google. The processes started with Google asking me to fill out some questions in relation to a project that i'd worked on. After submitting this i was quickly pushed on to the next stage. About a couple of weeks later, I had a virtual meeting with the hiring manager who asked me some product related questions as well as a few sql questions. E.g. how would you know when to send a push-up notification to a consumer, what metrics would you look at / measure / optimize upon. I also passed a sql test at this point. The product-related questions were pretty open ended.

    It took about 2 weeks to find out that I'd be accepted to the next and final stage of the process (it was strange that they would take so long in making that decision. At this point, i had accepted a job elsewhere, however after relentlessly applying over a number of years i wanted to push through this to the end.)

    The next and final stage of the process was in the London HQ , 4-in a row + (?business lunch?) interview process. I thought my first interview went really well as i felt i answered questions okay, and they were open ended. I got a "hope to see you soon" kind of ending - but the questions were so relentless that there was barely enough time for me to ask a lot of questions at the end and understand the role i was applying for in better detail. The second interview was similar, ending with a quick sheet of paper where i was told to demonstrate / define linear regression and then quickly told to write some sql code based on some columns , the question had make me nervous as I didn't fully understand what the output / business case of the problem was trying to solve and it was a twister using counts/subqueries where i didn't stay calm. Before i could finish, the interviewer had to end the session for lunch and took my paper.

    After this there were 2 video calls remaining - these interviewers were pretty friendly and asked me to go through more product based questions (e.g. how would you decide what to show someone on netflix, what programming skills do you know, types of joins, etls etc.) The last one ended with a sql test which i thought went better than the second one but i think there was something that they didnt like in the way i was writing or i didnt make myself 'sound confident' . I think this was partly the basis of my application getting rejected or not being strong enough, they did not give proper feedback following the process and it really left a bitter taste for me. I've applied so many times and not to get strong feedback / weighing up negatives/positives after reaching the final stage really left me pissed off to be frank.
    If they are looking for programmers / statisticians rather than industry business analysts then it should be more clear. I can also write queries with all joins, various functions, subqueries as well as picking up new functions off the table but if I'm given 30 sec to look at dataset and crunch and then get harsh criticism for my code (where i'm not a full programmer) then so be it. I'm honestly not sure if i feel like even trying to apply again. I also felt a bit of a arrogance from a couple of the people in the recruitment process as well as some robotic-ness from HR (you don't have to explicitly tell me the timezone of our call when you know i'm based in the UK already and we just spoke 20min prior to arranging the call. Also got a couple of memes from their HR... felt odd more than anything.)

    Interview Questions

    • what type of sql joins do you know   1 Answer

  6. Helpful (7)  

    Business Analyst Interview

    Anonymous Interview Candidate in Dublin, Co. Dublin (Ireland)
    No Offer
    Positive Experience
    Average Interview

    Application

    I applied through a recruiter. The process took a week. I interviewed at Google (Dublin, Co. Dublin (Ireland)).

    Interview

    Technical Recruiter contacted me through Linkedin. He explained me about the role and the interview process. He wanted me to fill a questionnaire, which contained questions about my technical and BA experience. He sent the filled questionnaire and my CV to the hiring manager.

    After a week, I had a phone interview with the hiring manager/team member. It was a standard interview with usual questions. The interviewer told me that he didn't read my questionnaire that I sent earlier, which I didn't expect from Google.

    After 3-4days I was told that I won't be going to next stages and NO feedback was given. Strange!

    Interview Questions

    • 1. Why Google?
      2. Explain your current role. Describe your favourite project.
      3. What's your ETL and OLAP experience?
      4. What DB and visualization tools have you used?
      5. Have you got any Big Data & Hadoop experience?
      6. SQL join types?
      7. List few SQL Analytical functions?
      8. Which programming language are you strong at?
      9. How will set recommendations for Netflix?
      10. How will you check if your above mentioned algorithm work?

      PS: I didn't sign any consent form for phone interview.  
      Answer Question

  7. Helpful (1)  

    Business Analyst Interview

    Anonymous Interview Candidate in Mexico, Distrito Federal (Mexico)
    No Offer
    Neutral Experience
    Average Interview

    Application

    I applied through other source. The process took 3 weeks. I interviewed at Google (Mexico, Distrito Federal (Mexico)) in August 2016.

    Interview

    In site interview with the manager in which he asked three cases with questions about the impact of social media on marketing for CPG. Asked about about the three principal challenges for the industry in Mexico.

    Interview Questions


  8.  

    Business Analyst Interview

    Anonymous Interview Candidate in London, England (UK)
    No Offer
    Neutral Experience
    Average Interview

    Application

    I applied in-person. The process took 5 weeks. I interviewed at Google (London, England (UK)) in January 2016.

    Interview

    Full process took more than a month.
    I came a first time within UK office for a video call interview. Average questions about my profile and my main tasks during former experience.
    My second and third interviews were more technical.
    After 4 interviews, no feedback. Kind of weird coming from such a big house.
    For these 4 interviews, a room was reserved but I was requested to leave each time after approx 30 min because not reserved for enough time. Maybe that was part of the process to destabilize. It made me feel like they were not very organized in fact.

    Interview Questions

    • You are requested to sell vacuum cleaner. How would you proceed?   1 Answer
    • Give me an example of a project you lead. What was the result? Which difficulties did you meet?   Answer Question

  9. Helpful (3)  

    Business Analyst Interview

    Anonymous Interview Candidate in Dublin, Co. Dublin (Ireland)
    No Offer
    Negative Experience
    Average Interview

    Application

    I applied through an employee referral. The process took 6 weeks. I interviewed at Google (Dublin, Co. Dublin (Ireland)) in November 2015.

    Interview

    The interview process is long and sometimes boring. In the whole process it felt like I was chosen to make a number or to keep the recruiter busy in his job. Also, despite the fact that all their emails sounded very friendly (smiley faces, kind words, etc.), it felt like I was dealing with a robot. Even when i received my feedback (positive and moving me to the next stage), I was given a completely wrong feedback, as I know where I did well and where I could have done better. The email sounded like a generic one that was sent to another tens of candidates.
    Well, after the first stage of the interview process I asked myself if I would like to work in a company where I am simply a number and if I want to proceed into the next stage myself.

    Interview Questions

    • Expect to be asked case based question in regards to forecasting, for example how would you predict the number of staff required in support team for next year.
      basic SQL question are asked too, but for the BI Analyst you should be a PRO in SQL anyway, so you might get more advanced sql questions.  
      Answer Question

  10.  

    Business Analyst Interview

    Anonymous Interview Candidate in Buenos Aires (Argentina)
    Declined Offer
    Positive Experience
    Average Interview

    Application

    I applied online. The process took 3+ months. I interviewed at Google (Buenos Aires (Argentina)) in June 2015.

    Interview

    The interview process started by submitting an online resume, then a call with HR, after that 3 rounds with the team members that asked personality questions, fit questions and questions about google products and how they can be used day to day.

    Interview Questions


See What Google Employees Are Saying

Star Star Star Star Star   Current Staff Research Scientist in New York, NY

Pros: “Great colleagues. Good to work with smart people. Good employee perks like free good quality food.”“Great colleagues. Good to work with smart people. Good employee perks like free good quality food.” – Full Review

Don't Miss Out On a Job You Love
Upload a resume to easily apply to jobs from anywhere. It's simple to set up.