
Are data scientist jobs going down in volume? Or is it just the general industry trend
Or in the era of the new LLMs, do you think it will just increase after this recession dies down?

Yea I have seen many recovering data scientists on LinkedIn. Most pivoted to data engineering or MLops.
After some years at work I feel it's true that one shall expand his skill set aligning domains ( not be there to just build models).

That 'recovering data scientist trend' is purely sham & they have no idea what they are talking about. Mostly none of them were DS. What do they even mean recovering? Do they even know DE was always part of Data Scientist job? I have worked on main aspects, Spark-scaling strategies, Hadoop, orchestration with oozie, airflow, gcp tools, & plenty of SQL. Cracking a DE job is not a big deal. We have to get a paycut though.
& MLOps is part & parcel of a DS job now. It's not as important as you are claiming it to be. It's important sure. Anyway, NLP and CV jobs are still as good as before. Infact more. Just the only area where DS is growing (maybe not CV)

I haven't designed data warehouses, yes but that's fine. But even the fanciest thing to it is star/snowflake schema, not much beyond that!

So is it better to become a data engineer than a ds?

DS is a sham in india. Also the certifications are outdated. Creating models is just 10% of the work. Deploying it is the main key.
Not all data is suitable for DS and not all companies are using their data properly.

Not even deployment, the main key is solution framing and data prep. & For straightforward NLP/CV cases it's error analysis and getting the data right.
Deployment is significant but not something you would call key.

Maybe it’s hyped because of training institutes makeing data scientists in 6 months program

For every 20 sdes you only need like 1-2 DS unless analytics is your core business

Indeed!

you can not become data scientist by doing certification FULLSTOP

What is the reason behind DS jobs are shrinking?