MSBI Architect - Ssis/ssrs/ssas

Soft tech Career Info system Pvt. Ltd
  • Hyderabad, Secunderabad
  • Confidential
  • 5-10 years
  • Views
  • 14 Dec 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Consultant Business Intelligence - SSIS (Mandatory) - SSRS - SQL Server Reporting Services (Mandatory) - SSAS Position Summary - Gather and analyze business requirements and translate business needs into long-term business intelligence solutions - Architect the Microsoft Business Intelligence solutions utilizing MS SQL Server 2012/2014 SSAS, SSRS, SSIS, Power Pivot, Power View, Performance Point, integration with Excel and Sharepoint, tailoring solutions for Management dashboards, Financial Reporting and Operational Business Intelligence - Configure and optimize BI environment, which includes relational, and OLAP layers, and data migration components; work in collaboration with the data warehouse environment and team. - Define Business Intelligence framework and data model, semantic layers and BI Metadata repositories to support reporting and administration. - Collaborate with application developers, business owners, and operation engineers to ensure the creation of production Business Intelligence designs and implementations. - Define and enforce coding standards, design styles and best practices. - Experience in participating in analysis sessions with the user community to capture, define data requirements clearly, completely and correctly - 6-8+ years of experience architecting, developing and/or managing the implementation of Business Intelligence solutions using Microsoft SQL Server, Microsoft SharePoint and Microsoft Excel - Experience in identifying, analyzing and translating business requirements and rules into intuitive analytical solutions, business scorecards and management dashboards - Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures - Expertise in the Microsoft BI solution offerings including SQL Server 2012/2014 (SSRS, SSAS, SSIS), PowerView, PowerPivot, Decomposition Tree, SharePoint, Excel, PerformancePoint Server - Understanding of multidimensional database design and architecture - Experience and/or understanding of SQL Server Tabular Model - Excellent data analysis skills using SQL. - Strong analytical skills and an ability to present and communicate data, trends, insights and recommendations - Ability to conduct quality control/auditing to ensure accurate and appropriate use of data during the project system, integration test and UAT - Experience in delivering quality work on time with multiple, competing priorities

Job Posted By

O.P. Chawla