An SEO consultant assists you and your employees in the process of search engine optimization.
Who needs an SEO consultant? Any company that has its own programmers, copy writers and/or webmasters.
In case you already pay someone for taking care of your website you do not need a search engine optimizer that does everything by himself.
You need an SEO consultant to tell you or your employees how to implement optimization techniques on your own.