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)
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 InformationAll your information will be kept confidential according to EEO guidelines. Please send your resume in Word format only.
Skills Required
- Implementation experience designing, developing and deploying end-to-end ETL packages using Microsoft SSIS 2012/2008
- Experience with Dimension ETL, Fact ETL and SSIS Script Tasks
- Experience developing and supporting multidimensional Microsoft SSAS cubes and MDX
- Experience deploying BI dashboard solutions to on-premise SharePoint and/or cloud platforms
- Experience integrating Power BI, Power Pivot, PerformancePoint and Excel with on-premise and cloud data sources
- Strong T-SQL skills including DDL, views, triggers, stored procedures and query performance tuning
- Experience designing and deploying Data Mart/Data Warehouse schemas on SQL Server (2008 or later)
- Experience designing and developing Microsoft SQL Server Reporting Services (SSRS) reports (SQL Server 2008/2012)
What We Do
Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada, and one of North America's leading staffing and contract workforce services providers. The company specializes in connecting IT talent with opportunity, delivering flexible IT staffing solutions and professional services to help organizations overcome technology gaps and drive transformation.
.png){kind=logo}
