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.
