Previous Job
Previous
Microsoft SR BI and Data Warehouse Developer
Ref No.: 18-32366
Location: Indianapolis, Indiana
Position Type:Contract
Start Date: 05/08/2018

Position: Microsoft SR BI and Data Warehouse  Developer  
Location: Indianapolis, IN
Duration: 6-12 months contract
Rate: $55-60/hr. C2C
Industry: Insurance
 
Star schemas need to be built for improved reporting and to feed SSAS models. Skills used:
·         Dimensional modeling / building star schemas in SQL Server.
·         Developing database objects (tables, indexes, constraints, etc.).
·         ETL to load the star schema layer using stored procedures and SSIS.
 
SSAS Tabular
building SSAS Tabular CUBES
SSIS
Experience loading the star schema layer mostly to orchestrate stored procedures and process SSAS models. I've also done SSIS work to load 3rd party data from a REST API or flat files.
Knowledge of the SSIS Catalog and the ability to help drive this transition would be helpful.
 
 SSRS / Power BI / Power BI Report Server
Skills needed:
·         Power BI development, including administrative things such as workspace organization, permissions, gateway usage, etc.
SSRS reports (Most based on SSAS data sources), some of which include features such as cascading parameters, drill-through actions, etc. These reports often require hand editing MDX or DAX queries