When interviewing a candidate for a business analyst role, employers are looking to assess your analytical problem-solving skills as well as your communication and collaboration skills. Be prepared to analyze a business case study and answer behavioral questions that often test your ability to handle challenging stakeholders or tight deadlines. Business analysts must also be creative thinkers, so expect to tackle a few unusual brainteasers that are designed to see how well you can think through a complex problem.
They asked if I knew how to do Excel pivot tables, VBA, and Access querying. After I confirmed I had those skills, they then wanted to know what my salary requirements were.
I did research and responded with the prevailing rate for my geography for that role and my experience. They responded that the position was entry level and my target was too high.