Do you need Xbox Live to get the Skyrim DLC?

Yes, I do believe since it's on the Marketplace, it would require someone to download it off Xbox Live whether it be through silver or gold membership.