Senior SQL BI Developer
At a glance
Senior Data Analysis & BI role at Procom Consultants Group. Houston · contract.
Pay not stated Bi Developer salary
dataroles summary, based on the employer's posting.
What you'll do
- Build and deploy end-to-end ETL packages with SSIS, including dimension, fact and script-task work
- Develop and support multidimensional SSAS cubes, using Analysis Services and MDX
- Create BI dashboards for on-premise SharePoint or cloud platforms, integrating Power BI, Power Pivot, PerformancePoint, Excel and data sources
- Use advanced T-SQL to manage SQL objects and tune query performance
- Design SQL Server data marts and develop reports with SSRS
What you bring
- You have implemented ETL packages with SSIS 2012 or 2008, including dimension and fact processing
- You have built multidimensional SSAS cubes and used MDX with SQL Server 2008 or later
- You bring advanced T-SQL and query-tuning skills, plus experience with Power BI, Power Pivot, PerformancePoint and SSRS
Who this fits
This senior contractor role suits someone with hands-on Microsoft SQL Server BI development experience. The position is onsite in Houston, with an assignment lasting twelve months or longer.
From the employer
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
All your information will be kept confidential according to EEO guidelines. Please send your resume in Word format only.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.