Data warehousing, Modeling

SSIS,SSAS, MDX, SSRS, SharePonit...You don't have to be a master of everything. Knowing a couple of above will land you a good job. It's hard to get in the door since most of companies will look for experienced developers. It's better to start as a SQL developer and gain some experience first.