Senior SQL BI Developer

Senior SQL BI Developer

• On behalf of our client in the Oil and Gas sector Procom Services is looking for one SQL BI Developer. The Successful candidate will have rich experience developing Business Intelligence Solutions using SQL including SSIS, SSAS and SRSS.

• Candidate must have implementation experience in designing, developing and deploying end-to-end complex ETL (Extract, Transform, Load) packages using Microsoft SSIS v. 2012 / 2008.
• Experienced in developing and supporting multi-dimensional Microsoft SSAS Cubes using Analysis Services and MDX.
• Experienced in developing and deploying Business Intelligence (BI) Dashboard Solution to on-premise Share Point and/or Cloud platforms. Integrating BI solution components such as Power BI, Power Pivot, Performance Point views with Excel spreadsheets, On-premise data sources, and Cloud services / Office 360.
• Strong T-SQL skills managing DDL, Views, Triggers, Stored Procs, Query Performance Tuning and other SQL objects. Implementation understanding in designing and deploying Data Mart (Data Warehouse) schema on SQL Server Platform (v. 2008 or later).
• Experience in designing and developing Microsoft SQL Server Reporting Services (SSRS) using Sql Server 2012/2008.

• SSIS Developer implementing end-to-end ETL packages (SSIS 2012/2008).
• Dimension ETL, Fact ETL and Script Tasks.
• Multidimensional Microsoft SSAS Analysis Services Cubes, MDX (v. SQL Server 2008 or later)
• Microsoft Business Intelligence (BI) Solution Stack
• Power BI, Power Pivot and Performance Point Server – deployed On-premise and/or Cloud.
• Data warehouse, Advanced T-SQL and Query Performance Tuning.
• Microsoft SSRS Reports (Sql Server Reporting Service) (v. SQL Server 2008 or later).

August, 2016

12 Month + Contract

All your information will be kept confidential according to EEO guidelines. Please send your resume in Word format only.