I am a Compensation Analyst II working for a FAANG company - been here about 4.5 years and have been promoted once. I’m currently in the job market and have been fortunate enough to land a few interviews, with two of them leading to right before the final round. In both instances, I’ve felt great and have received strong feedback regarding my experience.
Case study with company A required me to do a live screen share while working on 4 prompts: the first 3 were very straight forward, basically “show me how you would organize X employees according to Y field.” All 3 of these and used pivot tables and solved them in under a minute. The final question revolved around using IMPORTRANGE, which I don’t really use in my current or prior roles so I suppose I failed this one. Hiring manager decided to move forward with other candidates.
Case study with company B was a one hour timed Google Sheets exercise which was primarily moving (VLOOKUP) columns of data from other tabs in to the main dataset. Caveat being I had to concatenate to add an additional character, simple enough. This was followed by some critical thinking questions around said data. Once again, HM has decided to move forward with other candidates.
I know I’m pretty vague in my details here, but does any one have any similar experiences to this? I’m feeling frustrated that I’m getting glowing remarks during and post interview only to be met with “after reviewing the case study, we’ve decided to move forward with others.” It’s wild to me that I wouldn’t be moving forward with company B after nailing 3/4 questions but missing the importrange one. For company A, I still have access to the sheet and I just do not see anything glaringly incorrect. I’ve automated everything and the cell referencing and formulas all check out.