Period
to 24 November 2017

The following table provides summary statistics for contract job vacancies advertised in West Yorkshire with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 24 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Microsoft SQL Server Analysis Services (SSAS)
Yorkshire > West Yorkshire
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 122 119 111
Rank change year-on-year -3 -8 +5
Contract jobs citing SQL Server Analysis Services 38 60 75
As % of all contract IT jobs advertised in West Yorkshire 1.25% 1.68% 1.68%
As % of the Database & Business Intelligence category 5.21% 6.70% 6.11%
Number of daily rates quoted 26 47 72
West Yorkshire median daily rate £355 £350 £325
Median daily rate % change year-on-year +1.43% +7.69% +3.17%
10th Percentile £338 £242 £263
90th Percentile £463 £458 £387
Yorkshire median daily rate £363 £350 £330
% change year-on-year +3.57% +6.06% +3.13%
Number of hourly rates quoted 0 0 0
West Yorkshire median hourly rate - - -
Yorkshire median hourly rate - - -

SQL Server Analysis Services is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in West Yorkshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
West Yorkshire
Contract vacancies with a requirement for database or business intelligence skills 730 896 1228
As % of all contract IT jobs advertised in West Yorkshire 24.06% 25.04% 27.53%
Number of daily rates quoted 515 609 818
West Yorkshire median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - +7.14%
10th Percentile £305 £281 £275
90th Percentile £538 £525 £510
Yorkshire median daily rate £400 £380 £370
% change year-on-year +5.26% +2.70% +7.25%
Number of hourly rates quoted 2 14 16
West Yorkshire median hourly rate £16.59 £21.19 £18.50
Median hourly rate % change year-on-year -21.70% +14.53% +15.63%
10th Percentile £12.21 £13.50 £8.75
90th Percentile £21.37 £31.50 £42.27
Yorkshire median hourly rate £21.50 £14.25 £17.50
% change year-on-year +50.88% -18.57% +9.38%

SQL Server Analysis Services
Job Vacancy Trend in West Yorkshire

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised in West Yorkshire.

Job vacancy trend for SQL Server Analysis Services in West Yorkshire

SQL Server Analysis Services
Contractor Daily Rate Trend in West Yorkshire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL Server Analysis Services in West Yorkshire.

Contractor daily rate trend for SQL Server Analysis Services in West Yorkshire

SQL Server Analysis Services
Contractor Daily Rate Histogram in West Yorkshire

The daily rate distribution of IT jobs citing SQL Server Analysis Services in West Yorkshire over the 6 months to 24 November 2017.

Contractor daily rate histogram for SQL Server Analysis Services in West Yorkshire

SQL Server Analysis Services
Contractor Hourly Rate Trend in West Yorkshire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL Server Analysis Services in West Yorkshire.

Contractor hourly rate trend for SQL Server Analysis Services in West Yorkshire

SQL Server Analysis Services
Contract Job Locations in West Yorkshire

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing SQL Server Analysis Services within the West Yorkshire region over the 6 months to 24 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Leeds -9 26 £350 - 9
Huddersfield +1 2 - - 1
Wakefield -9 2 £375 +87.50%
Bradford +14 1 £575 +70.37% 1
Pontefract - 1 £290 -
SQL Server Analysis Services
Yorkshire

For the 6 months to 24 November 2017, IT contractor jobs citing SQL Server Analysis Services also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the West Yorkshire region with a requirement for SQL Server Analysis Services.

1 36 (94.74%) SQL Server Integration Services
2 31 (81.58%) SQL
3 29 (76.32%) SQL Server Reporting Services
4 28 (73.68%) SQL Server
5 26 (68.42%) Microsoft
6 25 (65.79%) Business Intelligence
7 24 (63.16%) Data Warehouse
8 17 (44.74%) T-SQL
9 14 (36.84%) Power BI
10 12 (31.58%) ETL
11 11 (28.95%) Data Modelling
12 10 (26.32%) Microsoft Analysis Services
12 10 (26.32%) Performance Tuning
13 9 (23.68%) Kimball Methodology
13 9 (23.68%) MDX
13 9 (23.68%) Migration
13 9 (23.68%) OLAP
14 8 (21.05%) Agile Software Development
15 7 (18.42%) Analytics
16 6 (15.79%) ETL Development
16 6 (15.79%) SQL Server 2016
16 6 (15.79%) Data Management
16 6 (15.79%) MOLAP
16 6 (15.79%) ROLAP
16 6 (15.79%) Star Schema
17 5 (13.16%) Finance
17 5 (13.16%) SharePoint
17 5 (13.16%) Data Migration
17 5 (13.16%) Dashboard Development
17 5 (13.16%) SQL Server 2014

SQL Server Analysis Services
Co-occurring IT Skills in West Yorkshire by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 5 (13.16%) SharePoint
2 4 (10.53%) SharePoint 2013
3 2 (5.26%) SAS
Applications
1 4 (10.53%) Spreadsheet
2 1 (2.63%) Microsoft Excel
Cloud Services
1 4 (10.53%) Microsoft Azure
2 1 (2.63%) Office 365
Database & Business Intelligence
1 36 (94.74%) SQL Server Integration Services
2 29 (76.32%) SQL Server Reporting Services
3 28 (73.68%) SQL Server
4 24 (63.16%) Data Warehouse
5 14 (36.84%) Power BI
6 10 (26.32%) Microsoft Analysis Services
7 9 (23.68%) OLAP
8 6 (15.79%) MOLAP
8 6 (15.79%) ROLAP
8 6 (15.79%) SQL Server 2016
8 6 (15.79%) Star Schema
9 5 (13.16%) SQL Server 2012
9 5 (13.16%) SQL Server 2014
10 4 (10.53%) Enterprise Data Warehouse
10 4 (10.53%) SSDT
11 3 (7.89%) OLAP Cube
12 2 (5.26%) Azure SQL Database
12 2 (5.26%) Data Mining
12 2 (5.26%) QlikView
13 1 (2.63%) SQL Server 2008
Development Applications
1 4 (10.53%) SQL Server Management Studio (SSMS)
1 4 (10.53%) Visual Studio
2 2 (5.26%) JIRA
3 1 (2.63%) Octopus Deploy
3 1 (2.63%) Subversion
3 1 (2.63%) Team Foundation Server
General
1 5 (13.16%) Finance
2 1 (2.63%) Marketing
Job Titles
1 28 (73.68%) Developer
2 17 (44.74%) Business Intelligence Developer
3 8 (21.05%) SSAS Developer
4 6 (15.79%) DBA
4 6 (15.79%) ETL Developer
4 6 (15.79%) SQL DBA
5 5 (13.16%) Architect
5 5 (13.16%) Data Architect
5 5 (13.16%) Microsoft BI Developer
5 5 (13.16%) Microsoft Developer
5 5 (13.16%) SQL Developer
5 5 (13.16%) SSIS Developer
6 4 (10.53%) SSRS Developer
7 3 (7.89%) Data Warehouse Architect
7 3 (7.89%) Power BI Developer
7 3 (7.89%) SQL Server Architect
7 3 (7.89%) SQL Server Data Warehouse Architect
8 2 (5.26%) Data Analyst
8 2 (5.26%) Data Warehouse Analyst
8 2 (5.26%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 9 (23.68%) MDX
2 2 (5.26%) .NET
2 2 (5.26%) AngularJS
2 2 (5.26%) Middleware
3 1 (2.63%) ASP.NET
3 1 (2.63%) CSS
3 1 (2.63%) HTML
Miscellaneous
1 4 (10.53%) Analytical Skills
2 3 (7.89%) Management Information System
3 1 (2.63%) Data Structures
3 1 (2.63%) Greenfield Project
3 1 (2.63%) Replication
Processes & Methodologies
1 25 (65.79%) Business Intelligence
2 12 (31.58%) ETL
3 11 (28.95%) Data Modelling
4 10 (26.32%) Performance Tuning
5 9 (23.68%) Kimball Methodology
5 9 (23.68%) Migration
6 8 (21.05%) Agile Software Development
7 7 (18.42%) Analytics
8 6 (15.79%) Data Management
8 6 (15.79%) ETL Development
9 5 (13.16%) Dashboard Development
9 5 (13.16%) Data Governance
9 5 (13.16%) Data Migration
9 5 (13.16%) Performance Monitoring
10 4 (10.53%) Database Optimisation
11 3 (7.89%) Data Architecture
12 2 (5.26%) Conceptual Models
12 2 (5.26%) Data Integration
12 2 (5.26%) Dimensional Modelling
12 2 (5.26%) Unit Testing
Programming Languages
1 31 (81.58%) SQL
2 17 (44.74%) T-SQL
3 3 (7.89%) Data Analysis Expressions (DAX)
4 1 (2.63%) C#
4 1 (2.63%) JavaScript
Qualifications
1 3 (7.89%) MCSE
1 3 (7.89%) Microsoft Certification
2 1 (2.63%) Security Cleared
Quality Assurance & Compliance
1 1 (2.63%) QA
Systems Management
1 1 (2.63%) Puppet
Vendors
1 26 (68.42%) Microsoft
2 5 (13.16%) Tableau
3 1 (2.63%) MicroStrategy
3 1 (2.63%) SAP