A data warehouse (DW) is not more than a very large database so the tasks are basically the same as the tasks you'll perform on a generic database. Big difference is being a very large database it will need more resources so keep a special attention on RAM and storage.
Also a DW have other components (BI and Cubes) so you can't forget about checking them as well. And the processes that are used to feed the DW.

In this article, WatchGuard's Director of Security Strategy and Research Teri Radichel, takes a look at insider threats, the risk they can pose to your organization, and the best ways to defend against them.