Evaluate the scope of big and small projects, communicate it to the rest of the team and business stake holders
Create the ETL routines (Custom routines/jobs/work flows as well as using ETL tools) in development and devise the roll out plan
Verify the data load and ensure data quality
Migration of Reports and data from one BI technology stack to another
Take ownership of the data warehouse schema
The resource should be willing to work on open source environments