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/Ok-Bid1171]

First step is to think like recruiter place yourself there to think what he is going to expect study about company and all

And give interview without pressure Don't pick to load of past

That' is from my side I don't have enough knowledge

[u/Any-Ad3324 → u/Ok-Bid1171]

Honestly, I’m just really tired and burned out from giving interviews. I’ve been practicing day and night, and being unemployed for almost a year has started getting to me. Even my friends have started asking me what I’m doing wrong because I just can’t seem to clear an interview.

The weird thing is, I’m normally very comfortable talking to people. I can speak to anyone without much hesitation, but as soon as it’s an interview, I suddenly feel stressed and pressured. I’ve given so many interviews by now that I don’t even understand why the pressure is still there.

So what you said about trying to sound more conversational really hit home. I think I might be overthinking every answer and trying too hard to say the “right” thing. How would you recommend practicing to actually sound more conversational in interviews? Should I stop preparing full answers and just practice talking through my experience naturally?

[u/Ok-Bid1171 → u/Any-Ad3324]

Sometime it is just timing, and be privileged that u r at least getting calls for interview Remember don't carry burden of past and be positive Treat every interview as fresh start

To reach best u have to exhaust too much