• Save Job
  • 5 - 7 Years
  • Posted : above 1 month

Job Description:

Role Designation Microsoft Business Intelligence Developer

Candidate Must Have

- 5+ Years in Business Intelligence along with expertise in Microsoft database design and integration experience with SQL Server databases on-prem and Azure

- Experience in implementing an end to end Data Warehouse Solution

- Strong experience of SQL Server 2016/Azure databases/data warehouse

- Dimensional Modeling (Kimball Methodology)

- Data Marts & Data Warehouse Solution Design

- Analytics/ OLAP Cube Development (Microsoft SSAS, DAX - Tabular Model, MDX - Multi Dimensional Model,)

- Report and Dashboard Development (Microsoft SSRS and Microsoft Power BI)

Technical Skills

- Experience on Microsoft BI Stack On-Prem and Azure (SQL Server 2016 and higher versions)

1 T-SQL / PolyBase

2 SSIS / Azure Data Factory

3 SSAS / Azure Analysis Services with DAX

4 SSRS / PowerBI

Responsibilities

- Demonstrate advanced knowledge and skills in designing and implementing Data Marts, Data Warehouse, BI and Dashboard solutions

- Exhibit Expertise / hands-on skills in data modelling

- Understanding of database architecture, security and deployment strategies

- Data components development using SQL Server T-SQL/Polybase, SQL stored procedures triggers and views, SQL Agent Jobs

- ETL Design & Development using Microsoft SSIS / Azure Data Factory

- Developing Cubes using SSAS Tabular Model and querying data using Excel and Power view

- Expertise in the development and deployment of reports using SQL Server Reporting Services and PowerBI that represent different findings and insights from the data using interactive charts and maps etc

- Connect to multiple datasets to bring all of the relevant data together in one place and create reports that provide a consolidated view of the different sources

- Creation of advanced visualization like heat maps and many other Using Microsoft Power BI publisher for Excel, to take snapshots from insights in Excel, like PivotTables, Charts, and ranges and pin them to dashboards in Power BI

- Uploading of Power BI reports to Power BI online service, implement security and audit

- Scheduling of Power BI Data Sets in online version and knowledge of viewing dashboards in Power BI mobile version

- Helping business with Self-service BI and Analytics

- Designing, developing and testing data transformations for reporting and interfaces between systems

- Ability to develop systematic testing plans for unit testing

Role Details Responsibility and Authority description - BS(I)PL/QD/03/R1/26082019

Soft Skills

- Ability to read, analyze, and interpret general business documentation, technical specifications and project management documentation

- Data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs

- Good analytical, logical reasoning and problem-solving skills

- Good interpersonal, written, and oral communication skills

- Self-motivated and directed, with keen attention to detail

- Able to prioritize and execute tasks in a high-pressure environment # Experience working in a team-oriented, collaborative environment

Education BE/BTECH in Information Technology, Computer Science, or related field or equivalent work experience

Profile Summary:

Employment Type : Full Time
Salary : Not Mentioned
Deadline : 18th Mar 2020

Key Skills:

Company Profile:

Not Mentioned

Taking these free online tutorials can help you get your next job

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status