Period
to 18 November 2017

The following table provides summary statistics for contract job vacancies advertised in 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 18 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)
England > Yorkshire
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 138 114 132
Rank change year-on-year -24 +18 -8
Contract jobs citing SQL Server Analysis Services 48 97 84
As % of all contract IT jobs advertised in Yorkshire 1.10% 1.77% 1.35%
As % of the Database & Business Intelligence category 4.93% 7.15% 5.14%
Number of daily rates quoted 34 77 76
Yorkshire median daily rate £356 £350 £330
Median daily rate % change year-on-year +1.79% +6.06% +3.13%
10th Percentile £329 £263 £265
90th Percentile £450 £438 £388
England median daily rate £425 £400 £400
% change year-on-year +6.25% - +3.23%
Number of hourly rates quoted 0 0 0
Yorkshire median hourly rate - - -
England median hourly rate £21.50 £44.00 £33.00
% change year-on-year -51.14% +33.33% +43.48%

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 Yorkshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Yorkshire
Contract vacancies with a requirement for database or business intelligence skills 973 1356 1634
As % of all contract IT jobs advertised in Yorkshire 22.28% 24.76% 26.30%
Number of daily rates quoted 657 926 1110
Yorkshire median daily rate £400 £380 £365
Median daily rate % change year-on-year +5.26% +4.11% +8.15%
10th Percentile £305 £281 £270
90th Percentile £538 £538 £512
England median daily rate £455 £425 £413
% change year-on-year +7.06% +3.03% +3.13%
Number of hourly rates quoted 8 22 23
Yorkshire median hourly rate £21.75 £14.25 £17.50
Median hourly rate % change year-on-year +52.63% -18.57% +9.38%
10th Percentile £11.75 £12.30 £9.20
90th Percentile £37.85 £31.50 £37.04
England median hourly rate £31.50 £28.00 £28.00
% change year-on-year +12.50% - +16.67%

SQL Server Analysis Services
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for SQL Server Analysis Services in Yorkshire

SQL Server Analysis Services
Contractor Daily Rate Trend in Yorkshire

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

Contractor daily rate trend for SQL Server Analysis Services in Yorkshire

SQL Server Analysis Services
Contractor Daily Rate Histogram in Yorkshire

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

Contractor daily rate histogram for SQL Server Analysis Services in Yorkshire

SQL Server Analysis Services
Contractor Hourly Rate Trend in Yorkshire

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

Contractor hourly rate trend for SQL Server Analysis Services in Yorkshire

SQL Server Analysis Services
Contract Job Locations in 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 Yorkshire region over the 6 months to 18 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
West Yorkshire -6 34 £350 - 9
South Yorkshire -11 6 £400 +9.59% 1
North Yorkshire - 2 £350 - 1
East Yorkshire -7 1 £368 -
SQL Server Analysis Services
England

For the 6 months to 18 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 Yorkshire region with a requirement for SQL Server Analysis Services.

1 45 (93.75%) SQL Server Integration Services
2 39 (81.25%) SQL Server Reporting Services
3 37 (77.08%) SQL
4 35 (72.92%) SQL Server
4 35 (72.92%) Business Intelligence
5 32 (66.67%) Data Warehouse
6 30 (62.50%) Microsoft
7 19 (39.58%) T-SQL
8 18 (37.50%) ETL
8 18 (37.50%) Power BI
9 14 (29.17%) Kimball Methodology
10 13 (27.08%) Data Modelling
10 13 (27.08%) Migration
11 12 (25.00%) MDX
11 12 (25.00%) OLAP
12 10 (20.83%) SQL Server 2016
13 9 (18.75%) SQL Server 2014
14 7 (14.58%) ETL Development
14 7 (14.58%) Performance Tuning
14 7 (14.58%) Finance
14 7 (14.58%) Microsoft Analysis Services
15 6 (12.50%) Data Migration
15 6 (12.50%) MOLAP
15 6 (12.50%) ROLAP
15 6 (12.50%) Star Schema
15 6 (12.50%) Dashboard Development
15 6 (12.50%) Microsoft Azure
16 5 (10.42%) Data Governance
16 5 (10.42%) SQL Server 2012
16 5 (10.42%) Performance Monitoring

SQL Server Analysis Services
Co-occurring IT Skills in 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 2 (4.17%) SAS
Applications
1 2 (4.17%) Microsoft Excel
Business Applications
1 1 (2.08%) iTrent
Cloud Services
1 6 (12.50%) Microsoft Azure
2 1 (2.08%) Amazon AWS
Database & Business Intelligence
1 45 (93.75%) SQL Server Integration Services
2 39 (81.25%) SQL Server Reporting Services
3 35 (72.92%) SQL Server
4 32 (66.67%) Data Warehouse
5 18 (37.50%) Power BI
6 12 (25.00%) OLAP
7 10 (20.83%) SQL Server 2016
8 9 (18.75%) SQL Server 2014
9 7 (14.58%) Microsoft Analysis Services
10 6 (12.50%) MOLAP
10 6 (12.50%) ROLAP
10 6 (12.50%) Star Schema
11 5 (10.42%) SQL Server 2012
12 4 (8.33%) OLAP Cube
13 3 (6.25%) QlikView
13 3 (6.25%) SQL Server 2008
14 2 (4.17%) Azure SQL Database
14 2 (4.17%) Data Mining
14 2 (4.17%) SQL Server 2005
15 1 (2.08%) PowerPivot
Development Applications
1 1 (2.08%) JIRA
1 1 (2.08%) Octopus Deploy
1 1 (2.08%) SQL Server Management Studio (SSMS)
1 1 (2.08%) Subversion
1 1 (2.08%) Visual Studio
General
1 7 (14.58%) Finance
2 3 (6.25%) Retail
Job Titles
1 36 (75.00%) Developer
2 23 (47.92%) Business Intelligence Developer
3 9 (18.75%) SSAS Developer
4 8 (16.67%) SSIS Developer
5 7 (14.58%) Microsoft BI Developer
5 7 (14.58%) Microsoft Developer
5 7 (14.58%) SQL Developer
5 7 (14.58%) SSRS Developer
6 6 (12.50%) DBA
6 6 (12.50%) ETL Developer
6 6 (12.50%) Power BI Developer
6 6 (12.50%) SQL DBA
7 5 (10.42%) Architect
7 5 (10.42%) Data Architect
8 4 (8.33%) SQL BI Developer
9 3 (6.25%) Data Warehouse Architect
9 3 (6.25%) SQL Server Architect
9 3 (6.25%) SQL Server Data Warehouse Architect
10 2 (4.17%) Data Warehouse Analyst
10 2 (4.17%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 12 (25.00%) MDX
2 2 (4.17%) .NET
2 2 (4.17%) Middleware
3 1 (2.08%) AngularJS
3 1 (2.08%) ASP.NET
3 1 (2.08%) XML
Miscellaneous
1 4 (8.33%) Analytical Skills
2 3 (6.25%) Management Information System
3 2 (4.17%) Greenfield Project
4 1 (2.08%) Data Structures
4 1 (2.08%) Replication
Processes & Methodologies
1 35 (72.92%) Business Intelligence
2 18 (37.50%) ETL
3 14 (29.17%) Kimball Methodology
4 13 (27.08%) Data Modelling
4 13 (27.08%) Migration
5 7 (14.58%) ETL Development
5 7 (14.58%) Performance Tuning
6 6 (12.50%) Dashboard Development
6 6 (12.50%) Data Migration
7 5 (10.42%) Data Governance
7 5 (10.42%) Performance Monitoring
8 4 (8.33%) Analytics
9 3 (6.25%) Agile Software Development
9 3 (6.25%) Data Architecture
9 3 (6.25%) Data Integration
9 3 (6.25%) Data Management
9 3 (6.25%) Visualisation
10 2 (4.17%) Data Virtualisation
10 2 (4.17%) Dimensional Modelling
10 2 (4.17%) Unit Testing
Programming Languages
1 37 (77.08%) SQL
2 19 (39.58%) T-SQL
3 4 (8.33%) Data Analysis Expressions (DAX)
4 1 (2.08%) C#
4 1 (2.08%) PowerShell
Quality Assurance & Compliance
1 2 (4.17%) QA
2 1 (2.08%) Data Quality
Systems Management
1 1 (2.08%) Puppet
Vendors
1 30 (62.50%) Microsoft
2 4 (8.33%) Tableau
3 1 (2.08%) MicroStrategy
3 1 (2.08%) SAP