Senior SQL BI Developer

Procom Consultants Group; Houston (TX); On-site; USD 90,000 - 110,000; Full time

Job summary

A leading IT services provider is seeking a Senior SQL BI Developer for a contract position in the Oil and Gas sector. The role requires expertise in SQL, SSIS, and SSAS, as well as experience in developing Business Intelligence solutions. The ideal candidate will manage ETL processes, create multidimensional cubes, and integrate BI solutions across platforms. A strong understanding of T-SQL and reporting services is essential for this position.

Qualifications

• Experience with SQL Server (2012 or later) for Business Intelligence Solutions.
• Strong understanding of ETL processes using SSIS.
• Experience in developing dashboards and reports with Power BI and SSRS.

Responsibilities

• Develop and deploy end-to-end complex ETL packages using SSIS.
• Create and maintain multi-dimensional Microsoft SSAS Cubes.
• Integrate BI solutions with on-premise and Cloud platforms.

Skills

SQL

SSIS

SSAS

MDX

T-SQL

Power BI

Data Warehousing

SSRS

Job description

Overview

Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada. With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and the largest “Canadian-Owned” IT staffing/consulting company.

Procom’s areas of staffing expertise include:

• Application Development
• Project Management
• Quality Assurance
• Business/Systems Analysis
• Datawarehouse & Business Intelligence
• Infrastructure & Network Services
• Risk Management & Compliance
• Business Continuity & Disaster Recovery
• Security & Privacy

Specialties

• Contract Staffing (Staff Augmentation)
• Permanent Placement (Staff Augmentation)
• ICAP (Contractor Payroll)
• Flextrack (Vendor Management System)

Job Description

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.

Senior SQL BI Developer – Mandatory Skills

• 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).

Senior SQL BI Developer – Start Date

August, 2016

12 Month + Contract

Additional Information

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