[Outsource:55480] Sr.SQL Developer with SSAS and SSRS/ North San Francisco, CA/ 4-6 Months++

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.

--
Introduce business in 3800 cities. How?
=====================================================
Thanks for using group.
Moderator
 
1) This group is managed by www.BRCIndex.blogspot.com
2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business.
3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club)
4) Reply to two message before posting new one.
5) Donot post same message in all 3800 business Referral Club.

You received this message because you are subscribed to the Google Groups "Outsource" group.
To post to this group, send email to Outsource@googlegroups.com
To unsubscribe from this group, send email to Outsource-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Outsource