Data Analyst

Why did you leave your last job earlier than you found a new one?

Imagine you are riding in an elevator for a minute with the CEO, who needs to sell himself in terms of expertise and hard skills. What would you say about yourself?

What data models have you worked with (star, snowflake)?

How do you rate yourself in terms of understanding the business on a five-point scale?

What is the most complex metric you have calculated? What problems did you encounter?

In one request, there is a window function and grouping — which executes first?

The last two jobs were short-term — what is the reason for this?

Tell me, what is a Type II statistical error?

What data sources have you integrated? What was it?

If we talk now about priorities — what is important to you when choosing a job, what do you pay attention to?

Tell me a little about yourself, your career path, and the reasons for changing jobs, what are you looking for?

How did you verify data and understand that you can trust it? Was there any algorithm?

When are you ready to start working if all stages are successfully passed? Are there planned vacations?

What algorithms for joining two tables (Join) at the physical level do you know?

Have you had experience working with Agile frameworks (Scrum, Kanban)? What is your opinion on this?

Tell us about the evolution of the BI tools used — starting with Power BI, and what came next?

Are you fully familiar with the ETL process? What are the stages involved?

What do you generally like about the work of a data analyst? If you were to sell this profession, what would you say?

How do you assess your understanding of how to technically implement customer wishes (on a five-point scale)?

Can you give a specific example when you found something and told the business, and they were engaged/reacted?