Sign in

Senior MSBI Developer

Company:
MSys Inc
Location:
Agoura Hills, CA
Posted:
November 08, 2019

Description:

Title: Senior MSBI Developer

Location: Agoura Hills, CA, USA

Length: Long term

Restriction: W2 or C2C

Description:

** Onsite - No remote **

Skills Required

Min 8+ experience in implementing applications built using Microsoft Business Intelligence tools Microsoft SQL Server Database, T-SQL, SSIS,SSAS MDX, SSRS

Strong skills in MS SQL/ T-SQL Development queries, stored procedures, views, triggers, functions and Performance Optimization Experience.

Knowledge on AWS is a plus

Should have Data Warehouse Data Modelling design experience.

Expertise in T-SQL, Stored Procedure development.

Ability to take complete ownership of building MS BI solutions from start to rollouts

Design and develop Extraction, Transformation and Loading ETL processes using SSIS

Design, Configuration and Deployment of Packages

Usage of Scripts Task

Error handling and Error Logging

Scheduling Packages and Security

Performance Tuning

Design and develop cubes using SSAS

Cube Deployment

Cube partitioning

MDX query

Using Cube data in SSRS

Performance Tuning

Good Communication skills

Adaptable to new technologies

Quick learner