There is a chance honestly, that data analysis jobs and core analytics as a space, can be heavily automated. There are already multiple sql generation related tools available in the market.
But still, not gonna be obsolete in anytime within 5 years for now. Because the solutions are still nascent and generic and to be able to provide custom solutions to all the businesses, is gonna take a lot of time. But surely, a lot of work can be automated in the future in data, pipelines, queries, insights fields.
This will not impact ML engg or AI scientists yet as of now.