Senior SQL BI Developer

Company Description

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 is now 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.

Senior SQL BI Developer Job Details

• 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

Senior SQL BI Developer Assignment Length

 12 Month + Contract

Additional Information

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