Bi Developers for Microsoft Consulting Division

Company :Microsoft ( Consulting Division)

Location  :Hyderabad  ( >50%  onsite travel  required ) 

Job Title :BI – Associate Consultant/Consultant

Location:  Hyderabad

Experience : 3 –  7 yrs only

Education  : Any engineering /MCA/MSC Comp Science /BSC Comp Science

Job Title  - BI Associate Consultant/ Consultant

ROLE :

To engage in delivery of solutions that involve providing a realization of Microsoft’s SQL Server technology stack and to provide technology depth and experience in the conceptualization, design, and implementation of BI solutions based on MS technologies

Responsibilities  :

KRA:

                                     Maintain a high standard of delivery quality to ensure high level of Customer Partner Experience

                    Build on existing breadth of Microsoft products to provide significant contribution

                    Across      technologies

                            Provide technical thought leadership and architectural vision

                            Mentor other consultants (associates and juniors)

                            SME and help with pre-sales, POCs and deal acquisition and management.

Skills :

Expertise / indepth knwoledge on BI related  solution architecture

Expert Skill level  in  SQL Server Analysis Services  as Follows:

·         Experience in building data warehouse with at least one of the popular approach

·         Experience in dimension modeling with at least more than 40-50 dimensions. Experience implementing Slowly changing dimensions.

·         Experience Designing Cubes with each cube size > 100gb

·         Experience Writing KPIs, Implement Drill-through

·         Automated Deployment of a Data warehouse, Automated processing of Partitions/Cubes

·         Experience designing Real-Time cubes with superior performance

Desired skill level  in SQL Server Integration Services –

·         Experience Implementing Highly scalable SSIS package

·         Experience Implementing Checkpoint, Transactions, logging etc.

·         Experience implementing all/most of the Data flow/Control flow Tasks in SSIS

·         Experience in building Package deployment and package Configuration

·         Experience implementing Analysis Services tasks

 Optional /Nice to have:

·         Experience in writing MDX scripts

·         Experience working on SQL Server reporting services/ProClarity/Performance Point Server