I find this question (How can I keep myself valuable to deliver in my work if more and more stuffs are automated in data science?) quite interesting, despite currently having a very strong advice aspect, which makes it off-topic. I think we may be able to salvage it.
Instead of focussing on "what should I do", I think we may be able to turn it into something like:
Coming from the technical world, what are the aspects that make me valuable to my company? Currently my work is being automated and I definitely think I'm losing value to my company.
The first part "Coming from the technical world" may not be necessary but I think it may be useful to keep the question properly scoped and not getting too wide.
Any thoughts about this?
A part of the answer would be obviously the visibility, but I don't want the question to focus on this, as it has already been well covered on the workplace.