Data engineering consultants are responsible for developing and maintaining databases, designing architectures for storing big data, and optimizing query performance. They also develop ETL (Extract Transform Load) pipelines to move data between various sources. On the other hand, a data scientist's job is to collect, cleanse and analyze datasets using machine learning techniques such as neural networks or support vector machines in order to uncover patterns or trends that can be used to make more informed decisions.