Previous Job
Previous
MSBI Architect
Ref No.: 16-10860
Location: Columbus, Indiana
MSBI Architect
  • Should possess leadership skills
  • Well versed in the phases of Requirements Gathering, Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).
  • Experience with MS SQL Server 2000/2005/2008/R2/2012 RDBMS including T-SQL programming.
  • Sound knowledge of T-SQL, SSIS, SSAS, SSRS, Power Bi
  • Good understanding of SSAS, OLAP Cube and Architecture and Experience in creating MDX cubes and dimensions (SSAS).
  • Proficient in writing complex MDX scripts to calculate exact figure from Cubes for management reports.
  • Good Knowledge in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Expertise in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
  • Experience working on Data modeling, creating star and snowflake schemas in SSAS
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
  • Solid analytical and troubleshooting expertise.