What you’ll be doing
Development of new SSIS packages
Overseeing and performance tuning of old SSIS packages
Responsibility over SSAS Cube
Research and implementation of new software, solutions proposal
Stored Procedures performance tuning
Tableau reports performance tuning
Integration of 3rd part data into DWH
Transfer current data structures to cloud/big data
REQUIREMENTS
3+ Years SQL performance tuning, stored procedures, functions – Must
3+ Years SSIS – Must
Deep knowledge of DWH models – Must
Large production system experience – Big Advantage
It will also be nice if you have
experience as applicative DBA – big advantage
Azure Data Factory – big advantage
Big Data( Amazon/Google/Azure) – big advantage
Python( API Calls, json, DB Integration) – big advantage
Tableau/Cognos/BO – Advantage
Azure DWH – Advantage
Ability to work under pressure
Creative approach to solving problems
Must be technical, fast learner, team playered