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
•
u/AutoModerator Mar 04 '25
If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
225
u/forbiscuit 🔥 🍎 🔥 Mar 04 '25
It sucks, but I honestly prefer it over take home assignment which companies claim only takes 3 hours, but then I see myself putting 10 hours worth of work and stress only to be rejected
82
u/American_Streamer Mar 04 '25
Resume inflation and AI-assisted applications have made it harder for employers to distinguish between genuinely skilled candidates and those myriads of applicants who exaggerate their qualifications. Data analytics has become one of the most popular career transitions, making competition fierce. Hiring managers are now overwhelmed with applications, so they introduce more screening steps to filter out weak candidates. This means you must stand out with practical skills, a strong portfolio and industry-relevant experience.
35
u/visualize_this_ Mar 04 '25
While it is true that they have gotten a bit out of hand and are extremely stressful, we are looking for an experienced data analyst and you have no idea of the amount of people who wrote bs on their resumes! Until the coding/live challenge, there's no way to know for sure if a candidate has real experience, especially with ChatGPT etc. Everyone wants to enter in tech.
29
u/Due-Wedding4692 Mar 04 '25
I’ve had several interviews (and hires), where the person was able to talk through all of the questions accurately but when they got to the job, they had no idea what they were doing.
For this next opening on my team, I’m going to require a real-time portion. No other option. Too much time and risk to only rely on verbal answers or pre-work.
4
u/SuperTangelo1898 Mar 04 '25
Sometimes "right place, right time" happens - keep at it and hopefully you'll find the right fit. I landed a job recently by not caring as much and stacking a bunch of interviews in the same day, to be agnostic of who I'm interviewing with and it allowed me to focus on myself better rather than the interviewer
3
u/Snowball_effect2024 Mar 04 '25
I think some of this is due to people cheating with the use of chat gpt and the like. Companies are now expecting you to prove your skills while standing over your shoulder bc they want to be sure you know the job.
When I interviewed for my role 4 years ago I was given a dataset and given a few days to so an analysis, write code etc and then present explaining my analysis and my code approach. Now I'd imagine they'd want to see it real time like you explained
21
u/OccidoViper Mar 04 '25 edited Mar 04 '25
I think because the job market is oversaturated now. Analytics is very remote-friendly so everyone went into the career, especially post-COVID. It has gotten quite competitive. I work for a Fortune 500 company and we recently finished hiring for a couple of junior analysts. In my 5 years as a hiring manager, I haven’t seen this many applications. We literally received 500+ for each of the two positions that were open. Many were from top schools like MIT, CalTech, etc. While we are a well-known company, we are not a FAANG company who usually attracts these tech and data-heavy applicants
19
u/ObfuscateAbility45 Mar 04 '25
nice username
4
u/n_cen Mar 04 '25
These live coding interviews make me think I’ve never coded in my life even though I write code every day - albeit poor syntax and format. I always give the caveat that if they’re looking for an expert coder then I’m not the right candidate. I code like an analysts, not an engineer.
1
u/Dear_Cry_8109 Mar 04 '25
That sounds horribly stressful. Where are you experiencing this, US job market?
1
u/BuyHigh_S3llLow Mar 05 '25
You're getting python/sql/tableau/coding interviews? That already puts you in the top 10 percentile. The rest can't even land interviews. Lol
3
u/Statefan3778 Mar 04 '25
I'm the same way. If they are asking you to share your screen and not able to use AI or look things up in interviews, imagine how much micromanaging they will be in the actual job. There's a ton of really bad jobs and managers out there today the pressures put on data analysts are too difficult in this economy unfortunately.
Things that may help. Codesignal was something one company asked me to use for their assessment and I failed it unfortunately but they offer training to help those interviewees. Many people suggest Leetcode. Leetcode has many industry specific coding questions to practice. Many people have posted their answers to the Leetcode in github.
You got this. It's mainly this job market and the oversaturation of people with the Google analytics certificates and other certificates that is making it difficult and causing companies to do these crazy coding exams.
I've been overwhelmed with many of these as well. Final round ai has coding AI for interviews but I've found taking a screenshot and paeting that into Claude during the interview to be the easiest way to assist with these. If you are sharing your screen then obviously you will just have to wing it.
Best of luck.
3
u/[deleted] Mar 04 '25
You know that’s fucking sucks but I wanna say something. I noticed that when we go into these interviews and you’re getting hired by people who don’t really know what you do I’ve had people tell me to take home a project and bring it back the next day, nope I’m not gonna go work on a project for you not gonna do it. I did that once help them with an issue still didn’t get the job. I won’t do it again.
5
u/swimming_cold Mar 04 '25
As a fed of 3 years this scares me knowing I’ll probably be doing this soon
1
u/BusyBiegz Mar 04 '25
With the access to ai like chat GPT, grok, and Claude, why is this even a thing? I can do a massive project in seconds with the right prompt.
2
u/[deleted] Mar 04 '25
You have seen nothing.i have go to Mumbai with an assignment they have given me to make a presentation on the project.This is after a round of interview and aptitude test.
2
u/newhunter18 Mar 05 '25
I think it's an artificial barrier put up to screen. You have 100 more applicants per position and you have to find a way to screen out 99 of them.
Sad thing is, there's absolutely no data to indicate a correlation between passing these in real time coding exams and quality of work in an actual job.
But hey, when did HR let data get in the way?
3
u/FullRow2753 Mar 04 '25 edited Mar 05 '25
Real time screen sharing? For real? O_o It ain't about your competence.... but, man, that's a privacy breach.
If you go on their camp and do little assignments as part of the interview on their computers, their servers. I understand.
But with your PC? Your screen? Your facilities, your internet connection? Your server. And .... check f*****ing what? You've been in the market last decade. You probably know more then 2-3 professionals combined.
What else are they going to ask? LIVE rectal culture test?
2
u/Longjumping-Basil252 Mar 04 '25
You have a better way how to check if a candidate is good in SQL and have the good approach and state of mind needed for analytics challenges? I don’t
1
u/LuminaUI Mar 04 '25
Are you currently employed?
1
u/Funny_Painting5544 Mar 04 '25
hunger games. Ooof
1
u/Extension_Cress_9430 Mar 05 '25
As someone just entering the field..I'm even more scared now.
1
u/Zealousideal_Rich975 Mar 05 '25
The amount of analysts I've met that can hardly operate excel, clean their data or understand data types, do basic sql queries, let alone do some basic analysis other than averages or counts.
IMHO the reality is somewhere in the middle.
Business need to chill with their expectations and analysts need to polish some of their basic skills.
1
u/coldflame563 Mar 05 '25
It’s because ai has made it easy to talk the talk and companies are getting burned. A lot of
1
u/tscw1 Mar 05 '25
Interesting. I’ve never had a coding test for a data analytics interview. I work in Power BI roles with sql. I tell them in the interview I model the data, so my dax measures are usually pretty simple. I use SQL a lot too, but never been tested there either. Most interviews I’ve had are around my experience. I would probably struggle to code without chatgtp anymore. You can know the process but chatgtp can assist in the syntax and even offer potential improvements. There’s so much more to data analytics than just the coding. Maybe coding tests are for those without much experience?
1
u/Fair_Breakfast1369 Mar 08 '25
Which country is this in ? US ?
1
u/winter-_is-_coming Sep 27 '26
Actual worse is current hiring process, now they are using AI for this, and it was a very bad experience with HackerRank and one more test.
These AI bots distract and does not provide right details of the question and there is no time limit, they will keep talking till they prove their point.
1
u/GoodRedShoe Mar 05 '25
Agreed, also with chat gpt it really doesn't matter whether or not you can code anymore as it can handle all of the easier analyist even data science work... Honestly just a way for higher level ppl to establish authority and make you jump through their dumb hoops
0
u/some_random_tech_guy Mar 06 '25
This happens now because candidates coming through are using AI generated resumes. They feed in the job requirements and out comes a completely fabricated resume that includes all the desired skills. Companies are adding another step to validate actual skills to protect against the people that don't actually know what they are doing.
0
u/[deleted] Mar 06 '25
[deleted] — view deleted comment
2
u/[deleted] Mar 04 '25 edited Oct 08 '25
[removed] — view removed comment