Google Business Analyst Interview Questions | Glassdoor

Google Business Analyst Interview Questions

Updated Nov 14, 2017
35 Interview Reviews

Experience

Experience
49%
32%
19%

Getting an Interview

Getting an Interview
43%
27%
10%
7
7
3
3

Difficulty

3.4
Average

Difficulty

Hard
Average
Easy

35 Candidate Interview ReviewsBack to all Interviews

Filter

Sort: PopularDateDifficulty

Filter

Sort: PopularDateDifficulty

Helpful (4)  

Business Analyst Interview

Anonymous Interview Candidate
No Offer
Neutral Experience
Average Interview

Application

I applied through a recruiter. The process took 1+ week. I interviewed at Google in January 2014.

Interview

I was contacted by a recruiter asking I am interested in the position. After a screening interview w/ recruiter (typical resume-checking, followed by a couple probability questions), heard back in 2-3 days and had a one-hour interview w/ hiring manager through a video conference 1 week later. Another 3-4 days later, heard they decided not to move forward.

Interview Questions

  • how would you advise the management in terms of improving current product offerings? on what basis? be specific.   1 Answer

Other Interview Reviews for Google

  1. Helpful (2)  

    Business Analyst Interview

    Anonymous Interview Candidate
    No Offer
    Average Interview

    Application

    I applied through an employee referral. I interviewed at Google.

    Interview

    Hiring process is different for the two positions I interviewed. One started with talking to the team leader on the phone, and then bring me to the onsite. The other one started with phone screening with HR, and then the HM, on the phone still.

    Interview Questions

    • They asked specific operation processes regarding their business   Answer Question

  2.  

    Business Analyst Interview

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

    Application

    I applied online. I interviewed at Google (Mountain View, CA) in January 2013.

    Interview

    Applied online. A week later, sent me a test to check for understanding of SQL and other business processes. Graded my test, invited me to fly into the bay area for an interview. Heard from the hiring manager a week later telling me I was ineligible: too young to be experienced, too old to be a new hire.

    Interview Questions

  3. 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


  4.  

    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

  5. 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

  6. 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

  7. Helpful (4)  

    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
  8. Helpful (11)  

    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

  9. 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


See What Google Employees Are Saying

StarStarStarStarStar     Current Anonymous Employee

Pros: “Fantastic benefits. And at work you're treated like a human being, not a cog”“Fantastic benefits. And at work you're treated like a human being, not a cog” – 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.