Data Warehouse analytics and Big Data

we need a big data architect to integrate multiple data sources in structured and unstructured data including SQL database of a CRM and social media analytics. We need the solution to process all the data to data warehouse
for analytics purpose. Experience with data analytics, reporting dashboard and Cloud will be a plus.