You still need to know SQL, and algorithms are helpful unless you expect to be spoon-fed pristine datasets that are ready for analysis.

The applicant pool seems to be full of those who took an online course and whose "personal" projects consist entirely of projects ripped from fast.ai or similar. Anymore, I get seem to get more spam on LinkedIn from people looking to be hired as a data scientist at my company than I do from recruiters looking to hire me. And looking over their resumes, I can see why they need to hustle so much. Successful candidates need to know how to do more than classify pet images from the Oxford dataset.

So to answer your question...Maybe? I mean, these candidates are certainly trying much harder than I ever needed to for a job. But presumably they eventually get hired into roles with less discerning companies.