Scope in Data Analyst

At first when I searched for various fields in IT I liked data analyst but now everyone says that AI is able to do all the core work of their, what's your opinion?

Considering the automation threat from AI analytics roles might get fewer and salaries are not that much high in analytics. What are your views on this? Do you think analytics will be the most impacted field because of AI? If anyone had changed from analytics to de/ds, how difficult to change?

Which is a better field, data analyst or data engineer in terms of growth and salary.

Hey guys can u please share your opinion on these topics which one is better which will be in demand in future etc etc Cs Ai Data science

I've been an Oracle Database Administrator handling databases and exadata, data guard, performance tuning (not so great at it), little bit of Oracle Cloud Infrastructure as well and typical DBA tasks including tablespace reorganization, migrations, etc. for the last 3 years. Now I'm thinking about transitioning into a Data Engineer/Data Analyst roles as it seems it is having a more lucrative future ahead. I'm good at doing DBA things but I'm doubtful about this considering the future scope of this as there isn't much a DBA has to do in databases as most of the work is handled by Database itself but I have an interest in it and getting calls from other companies as well for the same role. Is DBA a really good career option considering the future and the compensation? Or exploring or gaining skills in data engineering/analyst has more benefit? Also, what would be the best among Data Engineer/Data Analyst/AI,ML Engineer?

Both pro-cons i'm seeing currently is: Data science: ~ future technology ~ more interesting & diverse work Downside: so much competition as every college now opening new AI ML dept & Because of low entry criteria anyone can jump to this field little interest or few online courses Data Engineer: ~ Entry point is bit tough as Specific technology knowledge req which is generally not being taught in colleges, Hence less competition Downside: Identical & boring tasks mostly Which seems to win in near future in terms of pay or job security? Any suggestions as welcome!