Senior/lead Microsoft BI Developer - SQL Server/ssis/ssas/ssrs

Soft tech Career Info system Pvt. Ltd
  • Other India
  • 10-15 lakh
  • 3-8 years
  • Views
  • 08 Nov 2016

  • Project/ Program Management IT

  • IT/ Technology - Software/ Services
Job Description

Must have:

- SSAS(most important)

- Tabular

- MDS (Microsoft Data Services) experience


- Architects will have the ability to build enterprise warehouse solutions from scratch and lead team of BI specialists to complete projects

- Work with clients to determine business requirements for reporting and analysis

- Design conceptual, logical, physical data models

- Develop ETL using SQL stored procedures and/or SSIS Packages

- Create cubes using Analysis Services (SSAS)

- Develop reports using Reporting Services (SSRS) and/or PowerPivot for Excel

- Create technical documentation

- Test solutions and resolve issues .

Key Skills:

- 3-5 years of experience designing and developing BI solutions in a project-oriented environment

- 2-3 years of experience with Microsoft SQL Server BI tools: SQL Server, SSIS, SSAS, SSRS, PowerPivot, PowerView

- Proficiency in SQL including the use of SQL editors, stored procedures, database triggers and optimizing SQL statements.

- Strong knowledge of data warehouse concepts including: data modeling, data quality, ETL, reporting, analytics, and visualization

- Consulting experience is a plus

- Experience with leading BI tools a plus (Oracle, IBM, Informatica, Microstrategy, BusinessObjects)

- Experience with Big Data and related applications such as Hadoop is a plus

- Experience designing and developing Data Visualizations a plus

- Microsoft Excel 2013, Microsoft SQL Server 2012, SharePoint 2013 is a plus.

Competencies/Skill sets for this job

Sql Microsoft Sql Server Powerpivot Microsoft Sql Big Data Ssis Ssrs

Job Posted By

O.P. Chawla