The consultant should be extremely good at SSAS cube design/optimization/tuning and also should be able to develop SSIS packages including delta load..etc. If you have Ex-Microsoft Professional services guys it would be still good. Appreciate your help.
Location : North San Francisco
Duration : 4 - 6 months
Advanced SSAS (SQL Analysis Services),
Advanced MS SQL Server
Advanced Data Modeling
Intermediate MS Excel,
Intermediate SSRS (SQL Reporting Services), Intermediate SSIS
9+ Years of experience in Enterprise Data Warehouse Implementation
experience and 5+ years of implementing Microsoft Business Intelligence solutions leveraging SQL Server 2005/2008, SSIS, SSAS. The consultant has to have strong technical skills in BI Architecture, Data Modeling, ETL design, Data Quality, SSAS cube design and overall reports deployment strategies.
Experience with health care domain is a plus. Has to be a great communicator and ability to create technical design/architecture documentation and ability to interact with IT Directors, business VPs.
1.Business analysis: This person will meet with users to understand and document business requirements. The person must be able to lead the meeting and direct the conversations towards identifying requirements. The person must then organize and document the requirements in a format that could be understood by both business and IT.
2.Requirements Gathering: The consultant should be able to trace what was identified in the requirement back to the source systems. He/she needs to be able to communicate to IT SMEs and construct the necessary data model and column mappings from source and destination systems.
3.ETL Development: This person then needs to create the SSIS packages necessary to extract, format and load the data from the various source systems into the new data model. This person will verify the data accuracy and compatibility with the source system.
4.Cube Development: The consultant should also be able to build the
cube(s) using SSAS. The cubes will be tuned to allow users to easily access the data using front end tools, including Excel.
5.Reports Development: Optional this person should have experience of integrating reports, SSRS & Excel services, into SharePoint.
6.Analytics and Dashboards: Optional also is the knowledge and the ability to work with of 3rd party software that integrates with SSAS and be able to provide training and mentoring to IT and business users on the use of these tool.
--You received this message because you are subscribed to the Google Groups "IT JOBS IN THE US" group.
To post to this group, send email to itjobs-usa@googlegroups.com.
To unsubscribe from this group, send email to itjobs-usa+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/itjobs-usa?hl=en.
No comments:
Post a Comment