Data warehousing

I am interested in the concept of Data warehousing in MS SQL server but I am not too sure if it’s a very good career choice.
Is there any demand or is it just another hyped up thing?
Thanks.