Strategies for backing up Windows Azure SQL Azure, Blobs & Table data
Either way will work. I would probably go for the CI Server initially as it will be much quicker to set up and maintain. But it may not scale as well or be as reliable as having an Azure Worker role in charge of it.