BI Lead/ Architect - Microsoft Corp hyd

Company : Microsoft Corp

Location :Hyderabad

Job Role: Senior BI Application Engineer/BI Architect (Microsoft BI)




Introduction

The Partner Integrated Reporting (PIR) Team at BI Engineering Group - MSIT (India) is looking for a well-qualified person who has prior experiencing in design and implementation of 2-3 end-to-end BI Solutions on Microsoft Technology Stack. This is an IC role. The BIE Team at MSIT India deliver BI solutions for key Microsoft Businesses e.g. Consumer, Partner, Sales and Marketing etc. The PIR Team at BIE is responsible for delivering BI capabilities to Microsoft Partner Teams for enabling key reporting capabilities around the Partner Business of Microsoft. The PIR Team is engaging in a new effort for the upcoming year to deliver enhanced BI capabilities to Microsoft Partner Teams (Next Generation PIR Effort). The PIR Team is looking for a Senior Technical Lead who can help drive the Technical and Architectural direction of the Next Generation PIR across the entire BI SDLC.



Job Position

• Should have excellent communication skills. Able to talk efficiently and effectively with the global development team and have the talent of challenging technically.

• Should have 7+ Years of IT Experience with at-least 4 years in the Design and Development of end-to-end BI Projects

• Should have exposure to complete SDLC for building a BI Application (Requirement Analysis, Design, Development, Deployment and Support)

• Displays high degree of Confidence and ability to work in ambiguous situations

• Should be able to Lead the Technical Architecture / Design for the BI Application

• Should be effective at Cross Group collaboration

• Should have capability to influence Architecture / Design for Medium to Complex components for the BI Application (within and across the Organization)

• Evangelizes Technology Patterns and Best Practices

• Must able to lead a project with less dependency and control the project with respect to schedule and quality.

• Displays great negotiation skills and displays ability to influence others

• Excellent Team Player

• Be an active participant on design, development and support of the project.

• Bring technical expertise based on development experience, and make sound technical decisions to deliver high quality projects



Responsibilities:

• Ability to drive Application Development Plans for Medium to Complex deliverables or for entire Release

• Dimensional Modelling (Physical and Logical)

• Design and develop ETL and relational Staging and Data Mart Databases.

• Design and develop multi-dimensional Schemas.

• Design and develop reporting systems for internal and external partners.

• Contribute to development methodologies and best practices in the BI space

• Active participation in technical investigations and prototyping

• Evangelize on Microsoft BI Platforms and build tools to enhance Team Productivity

• Define, Optimize and Manage the Version Control Strategy for the Project



Technical Skills:

• Strong Breadth in Microsoft BI Technology Platform (with Strong Depth in 2 Technology Areas)

• Essential: Strong SQL Server Fundamentals and T-SQL Skills (SQL Server 2005+)

• Experienced in Design and Development of Microsoft OLAP Cubes (SQL Server 2005+)

• Experienced in Design and Development of Application ETL based on the Best Practices leveraging Microsoft ETL Tools

• Experienced in Design and Development of Microsoft Reporting Technologies (SQL Server Reporting Services, ProClarity or Performance Point)

• Experience on Microsoft Tools for Project Planning – Microsoft Project

• Experience on Modelling Tools like ERWIN and Microsoft Visio

• Experienced in Performance Tuning specific areas of a BI Application (Database Code, ETL, Reporting, OLAP)

• Experienced in Version Control Tools and Collaboration like Visual Source Safe, VS DB Pro and VSTF

• Exposure to Microsoft Collaboration platform like Microsoft SharePoint Portal