SQL Data Warehouse Design Expert Needed

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources.

Key requirements:
- Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential.
- Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial.
- Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles.
- Medium-sized project: The data needing integration and consolidation is between 1GB and 10GB, so experience handling medium-sized data sets is ideal.

Your main aim will be to ensure that the data warehouse is efficient and can handle the needs of our data integration and consolidation. Experience in similar projects is essential. You will be working with roughly 5 databases, some direct access, some via API (including basic XML feed in 1 instance). We do not have expectations on the total timeframes (may be up to 3 weeks for 2-3 days per week) as this is firstly dependent on capabilities and secondly on design / good hourly rates. If you complete the original intended work quickly this may lead to longer projects.