Period
to 23 January 2018

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 23 January 2018 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
23 Jan 2018
Same period 2017 Same period 2016
Rank 139 108 158
Rank change year-on-year -31 +50 -46
Contract jobs citing SQL Server Analysis Services 43 86 62
As % of all contract IT jobs advertised in Yorkshire 0.96% 1.77% 1.04%
As % of the Database & Business Intelligence category 4.56% 7.24% 4.34%
Number of daily rates quoted 28 72 59
Yorkshire median daily rate £364 £350 £340
Median daily rate % change year-on-year +3.93% +2.94% +8.37%
10th Percentile £334 £263 £272
90th Percentile £450 £438 £394
England median daily rate £425 £400 £400
% change year-on-year +6.25% - +6.67%
Number of hourly rates quoted 0 0 0
Yorkshire median hourly rate - - -
England median hourly rate £25.50 £41.50 £45.00
% change year-on-year -38.55% -7.78% +47.54%

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 942 1,188 1,428
As % of all contract IT jobs advertised in Yorkshire 21.03% 24.45% 23.95%
Number of daily rates quoted 626 798 982
Yorkshire median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - +7.14%
10th Percentile £283 £281 £275
90th Percentile £550 £538 £530
England median daily rate £475 £430 £425
% change year-on-year +10.47% +1.18% +6.25%
Number of hourly rates quoted 2 13 22
Yorkshire median hourly rate £32.75 £24.00 £18.50
Median hourly rate % change year-on-year +36.46% +29.73% +0.68%
10th Percentile £23.03 £13.50 £10.10
90th Percentile £42.28 £31.50 £28.53
England median hourly rate £31.15 £27.50 £30.00
% change year-on-year +13.27% -8.33% +9.09%

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 23 January 2018.

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 23 January 2018. 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 -11 37 £360 +5.88% 26
South Yorkshire -5 4 £400 +10.34% 4
SQL Server Analysis Services
England

For the 6 months to 23 January 2018, IT contractor jobs citing SQL Server Analysis Services also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Yorkshire region with a requirement for SQL Server Analysis Services.

1 39 (90.70%) SQL Server Integration Services
2 35 (81.40%) SQL Server Reporting Services
3 30 (69.77%) SQL
3 30 (69.77%) SQL Server
3 30 (69.77%) Business Intelligence
4 29 (67.44%) Data Warehouse
5 28 (65.12%) Microsoft
6 20 (46.51%) Power BI
7 18 (41.86%) T-SQL
8 15 (34.88%) ETL
9 13 (30.23%) Migration
10 12 (27.91%) Data Modelling
11 9 (20.93%) Agile Software Development
11 9 (20.93%) SQL Server 2014
12 8 (18.60%) SQL Server 2016
12 8 (18.60%) Finance
12 8 (18.60%) SQL Server 2012
12 8 (18.60%) Analytics
12 8 (18.60%) Performance Tuning
13 7 (16.28%) Tableau
13 7 (16.28%) Microsoft Analysis Services
13 7 (16.28%) Data Management
14 6 (13.95%) Dashboard Development
14 6 (13.95%) ETL Development
14 6 (13.95%) SharePoint
14 6 (13.95%) Data Migration
14 6 (13.95%) MDX
14 6 (13.95%) Microsoft Azure
14 6 (13.95%) Data Governance
14 6 (13.95%) Kimball Methodology

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 6 (13.95%) SharePoint
2 4 (9.30%) SharePoint 2013
3 3 (6.98%) SAS
Applications
1 4 (9.30%) Spreadsheet
2 1 (2.33%) Microsoft Excel
2 1 (2.33%) Microsoft Project
Business Applications
1 1 (2.33%) iTrent
Cloud Services
1 6 (13.95%) Microsoft Azure
2 1 (2.33%) Office 365
Database & Business Intelligence
1 39 (90.70%) SQL Server Integration Services
2 35 (81.40%) SQL Server Reporting Services
3 30 (69.77%) SQL Server
4 29 (67.44%) Data Warehouse
5 20 (46.51%) Power BI
6 9 (20.93%) SQL Server 2014
7 8 (18.60%) SQL Server 2012
7 8 (18.60%) SQL Server 2016
8 7 (16.28%) Microsoft Analysis Services
9 5 (11.63%) OLAP
10 4 (9.30%) Enterprise Data Warehouse
10 4 (9.30%) SSDT
11 3 (6.98%) MOLAP
11 3 (6.98%) QlikView
11 3 (6.98%) ROLAP
11 3 (6.98%) SQL Server 2008
11 3 (6.98%) Star Schema
12 2 (4.65%) Data Mining
12 2 (4.65%) OLAP Cube
12 2 (4.65%) SQL Server 2005
Development Applications
1 4 (9.30%) SQL Server Management Studio (SSMS)
1 4 (9.30%) Visual Studio
2 2 (4.65%) JIRA
2 2 (4.65%) Team Foundation Server
3 1 (2.33%) Octopus Deploy
3 1 (2.33%) Subversion
General
1 8 (18.60%) Finance
2 1 (2.33%) Marketing
2 1 (2.33%) Retail
Job Titles
1 32 (74.42%) Developer
2 20 (46.51%) Business Intelligence Developer
3 7 (16.28%) Microsoft BI Developer
3 7 (16.28%) Microsoft Developer
4 6 (13.95%) DBA
4 6 (13.95%) SQL DBA
5 5 (11.63%) Power BI Developer
5 5 (11.63%) SQL Developer
5 5 (11.63%) SSAS Developer
5 5 (11.63%) SSIS Developer
5 5 (11.63%) SSRS Developer
6 4 (9.30%) Architect
6 4 (9.30%) Data Architect
7 3 (6.98%) Analyst
7 3 (6.98%) Data Analyst
7 3 (6.98%) ETL Developer
8 2 (4.65%) Data Warehouse Analyst
8 2 (4.65%) Data Warehouse Architect
8 2 (4.65%) Data Warehouse Developer
8 2 (4.65%) Senior Developer
Libraries, Frameworks & Software Standards
1 6 (13.95%) MDX
2 3 (6.98%) .NET
3 2 (4.65%) AngularJS
3 2 (4.65%) CSS
3 2 (4.65%) HTML
3 2 (4.65%) Middleware
4 1 (2.33%) .NET Framework
4 1 (2.33%) ASP.NET
4 1 (2.33%) jQuery
4 1 (2.33%) JSON
4 1 (2.33%) Razor View Engine
4 1 (2.33%) XML
Miscellaneous
1 5 (11.63%) Analytical Skills
2 4 (9.30%) Management Information System
3 2 (4.65%) Greenfield Project
4 1 (2.33%) Data Structures
4 1 (2.33%) Market Risk
4 1 (2.33%) N-Tier
Processes & Methodologies
1 30 (69.77%) Business Intelligence
2 15 (34.88%) ETL
3 13 (30.23%) Migration
4 12 (27.91%) Data Modelling
5 9 (20.93%) Agile Software Development
6 8 (18.60%) Analytics
6 8 (18.60%) Performance Tuning
7 7 (16.28%) Data Management
8 6 (13.95%) Dashboard Development
8 6 (13.95%) Data Governance
8 6 (13.95%) Data Migration
8 6 (13.95%) ETL Development
8 6 (13.95%) Kimball Methodology
9 5 (11.63%) Performance Monitoring
10 4 (9.30%) Database Optimisation
11 3 (6.98%) Unit Testing
11 3 (6.98%) Visualisation
12 2 (4.65%) Data Architecture
12 2 (4.65%) Data Integration
12 2 (4.65%) Dimensional Modelling
Programming Languages
1 30 (69.77%) SQL
2 18 (41.86%) T-SQL
3 3 (6.98%) Data Analysis Expressions (DAX)
4 2 (4.65%) C#
4 2 (4.65%) JavaScript
Qualifications
1 3 (6.98%) MCSE
1 3 (6.98%) Microsoft Certification
2 1 (2.33%) Security Cleared
Quality Assurance & Compliance
1 1 (2.33%) Data Quality
1 1 (2.33%) QA
Systems Management
1 1 (2.33%) Puppet
Vendors
1 28 (65.12%) Microsoft
2 7 (16.28%) Tableau
3 1 (2.33%) Logi
3 1 (2.33%) Logi Analytics
3 1 (2.33%) MicroStrategy
3 1 (2.33%) Oracle
3 1 (2.33%) SAP