Securing data in a warehouse is an often overlooked topic. Rather than granting wholesale access of tables to an entire IT department, group level permissions should be based on functional role. For example, application and business intelligence developers may need access to the Employee table, but only HR and executive management should have access to employee salary. This can be implemented using views as well as column and row level security. This is so elementary, it should be a standard part of IT job interviews.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho