That is the goal, however, deep learning models still have a long way until feature engineering goes away im afraid.
Once we get to that point, the "black box machine learning as a service" that many startups seem to be selling nowadays will be replacing data scientists.