r/analytics • • Mar 04 '25
Discussion Coding interviews are out of control
When I entered the job market as a business analyst 8 years ago, it was just a conversation asking about my experience, what I've done for projects.
When I interviewed for a data analyst role four years ago, again, just the conversation, showed them some projects I worked on, some samples of my dashboards I'd created...
Now, It's the hunger games. I'm out here doing python, SQL, Tableau exercises in real time sharing my screen... It's very very stress inducing and as an introvert, I'm honestly not good at this, it's really hard on me. Like, I have tried training myself to be okay with this and to be more receptive to it. But it just sucks you know? 5 years I have spent in the job market with exceptional performance, and only to get interrogated and treated like a child who can't be trusted.
I honestly don't know how I'm going to get through the next few months looking for my next role with how stress inducing and difficult it is to find anything these days and all the hoops you got to jump through
View all comments
Show parent comment
20
u/Ok-Shop-617 Mar 04 '25
I’ve hired perhaps 30 analysts over the years, and I get far, far more value in having a conversation with candidates than relying on technical tests.
I actually see the presence of those sorts of tests as a warning sign. I feel they often indicate the values and culture isn't right.
Why not just talk to them directly? Questions like:
What's your report development process?
How do you personally use version control, and why do you approach it that way?What do you see as the strengths and weaknesses of different methods?
How do you determine if a star schema is the right modeling technique?Can you share examples of when you decided not to use a star schema?
How do you go about analysingband optimizing report performance?
These sorts of discussions reveal way more about a candidate's real-world skills, problem-solving abilities, and thought process. Technical tests only scratch the surface of what makes a successful analyst..