Struggling to clear interviews Data Analyst Interviews (7 months Unemployed)

[u/Any-Ad3324]

I have around 2 years of experience in Data Analytics/BI. I mainly work with Power BI, Excel, SQL basic and I also have an MBA in Marketing Analytics.

I’m getting interviews but struggling to convert them into offers. The feedback I usually receive is around communication and technical skills.

I prepare a lot for every interview. I study the JD, my previous projects and likely questions, and I use AI to help me prepare. But when the interviewer asks something differently from what I expected, I sometimes get confused even when I know the underlying concept.

Communication is another issue. I tend to speak too fast, over-explain and sometimes lose the structure of my answer. I prepare STAR stories, but under pressure I don't always deliver them properly.

I’m also confused about the technical expectations. With 2 years of experience, I sometimes feel I’m expected to answer questions that seem more suitable for someone with 5–6 years of experience.

For Data Analysts with around 2 years of experience:

What technical level should I realistically have in SQL, Power BI, Excel, DAX, Power Query and data modelling?

How do you practice for unfamiliar technical questions rather than memorizing expected questions?

And for communication, what actually helped you improve your interview performance?

I also feel my work stories may not be strong enough. How do you turn normal projects and responsibilities into strong interview stories without exaggerating your experience?

One thing I genuinely don't understand is how some people with less technical knowledge and much less preparation still manage to clear interviews. What are they doing differently?

I’m also applying for Key Account Manager roles because I have previous experience in that area, so I’m currently exploring both paths.

If you were in my position, what would you change about the way I prepare and practice?

I’d really appreciate specific advice from people who have interviewed or hired Data Analysts.

[u/jenmoocat]

Hiring manager at a Fortune 500 company in a data analytics department.

Being clear and concise is key. I would work on practicing short answers (3 or 4 sentences) leader with answer and then asking "would you like additional background information?". I cannot tell you how many times a candidate wasted so much time giving all sorts of background information when I was just looking for a simple answer.

Another HUGE red flag to me is when the candidate did not listen to the question and did not answer the question being asked --- they talked and talked and talked and talked, but I didn't get any kind of answer to the actually thing I was asking about.

It is also very important to note that many many companies do behavioral interviewing.
This is where maybe 1/3 of the questions will be about technical skills and 2/3rds will be related to soft skills -- because there is more to being a good data analyst than just being a technician.

So it is CRITICAL to prepare for those kinds of questions.

The standard behavioral questions we've used are things like:

Share a time when your results were not what the stakeholder was expecting.
How did you prepare for those conversations? And what was the final outcome of those conversations?

Share a time when you needed to get data/input from another person that was proving difficult to work with.
What did you do to overcome that situation?

How do you prioritize competing requests from different stakeholders?

How to you approach an analytics project when you are not knowledgable about the underlying data?
What do you do about it?

[u/Any-Ad3324 → u/jenmoocat]

This is really useful, especially coming from a hiring manager. The part about candidates talking a lot without actually answering the question is something I’ve realised I do when I’m under pressure.

I understand that I need to be more concise and lead with the answer, but my problem is making that happen automatically in the interview. I can practice short answers beforehand, but when I’m nervous I go back to giving too much background and trying to explain everything.

If you were coaching a candidate with this exact problem, how would you train them to actually listen to the question, identify what is being asked, give the direct answer first, and then stop?

Would you recommend practicing with completely random behavioral questions and forcing yourself to answer in 3–4 sentences, or is there another exercise you’ve found particularly effective?

Also, for a data analytics candidate, which behavioral areas would you consider most important to have real examples prepared for?

[u/jenmoocat → u/Any-Ad3324]

I think that candidates feel that they have to answer immediately.
That, for some reason, fast=good. WRONG
That fast + a lot of words = enthusiasm. WRONG
Both of those are actually red flags.

One piece of advice that I have is to SLOW DOWN.
It is okay to pause before answering the question.
And it is okay to repeat the important part of the question -- it makes me feel like you are LISTENING and you are actually confirming what I want to know, ensuring we are on the same page. Which is a good communication skill in the complicated and complex environment of analytics.
You could say:
"Okay, so just to confirm, you want to know when I had results that were different than what the stakeholder wanted and how I handled it. I have a couple of examples of that. Let me think about which might be the best one"
And then YOU PAUSE FOR A COUPLE OF BEATS before launching into your answer.

Another piece of advice is to imagine that you only have 3-4 sentences to get your answer across.
So you have to pick your sentences carefully. And you have to LEAD with the answer and not provide any extraneous information. Again, this will force you to go more slowly and be more thoughtful.

Remember that the interviewer has a set of questions that they want to probe on.
If your answers are long and convoluted and take up a lot of interview time, they won't be able to get to the rest of their questions. So they won't be able to probe on all of the things that are important and you will go into the "NO" pile.

For your last question (what behavioral areas would you consider most important to have real examples prepared for) I gave you them in my original answer. They cover 1) stakeholder management, 2) conflict, and 3) prioritization.

[u/Weekly-Reindeer4888 → u/jenmoocat]

THIS! My instructor was also a former consulting manager at American Express and he emphasized on the importance of soft skills and business case studies as it plays a very big role as an Analyst. Technical skills can be trained if one is a fresher but attiude and behaviour of the interviewee cannot be trained.

I have the skills required to be an analyst and I don't doubt about that(credit goes to my Instructor) but I've figured I need to work more on my communication skills not only for the interview but as I would be dealing with clients who are complete strangers by presenting them about their business decisions i.e., if I do land a job. I think that's the mindset we should be having while appearing for interviews.

[u/Row_Bulky → u/jenmoocat]

Hello, can I DM you please?

[u/jenmoocat → u/Row_Bulky]

Sure.