If using cement board do you still need water proofing membrain.

According to industry standards this is optional. However, if using in a wet area, applying waterproof membrane prior to setting the tile with a polymer modified mortar, additional protection would be beneficial.