Microsoft shop seeking a senior consultant to assist with requirement gathering, documentation, interpreting data, establishing best practices and implementation. Experience architecting and implementing data warehouse and business intelligence solutions.
Must have Data Warehouse implementation experience!
The right candidate will have experience and be able to:
- SQL Server, with Analytics, multiple implementations under their belt
- Perform End to End implementation, a subset of dimensions including documentation, reports, etc
- Train the team how to expand
- Analysis, Design, Modeling, Implementation, Training, Documentation
- Identifying schema / model
- Microsoft business intelligence platform – analysis services, v2005 or better
- Experience with ETL process, Microsoft SSIS
- Preferred DBA experience – especially creating and optimizing databases and queries as it relates to the data warehouse
- Preferred experience with SharePoint and Performance Point
- SQL Server Analytics
- Data Modeling
- Dimension Validation
Tasks to accomplish
- Analysis Server Setup
- Data Dictionary
- Process documentation
- Data Mart/Dimension Validation/Implementation
Currently in the process of identifying requirements, facts (supporting formulae) and dimensions.
