Period
to 12 December 2017

The following table provides summary statistics for contract job vacancies 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 12 December 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)
UK
6 months to
12 Dec 2017
Same period 2016 Same period 2015
Rank 311 252 189
Rank change year-on-year -59 -63 +35
Contract jobs citing SQL Server Analysis Services 853 1057 1551
As % of all contract IT jobs advertised in the UK 0.83% 1.02% 1.38%
As % of the Database & Business Intelligence category 3.76% 4.53% 5.97%
Number of daily rates quoted 659 759 1242
UK median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - +6.67%
10th Percentile £313 £285 £275
90th Percentile £550 £538 £550
UK excluding London median daily rate £388 £375 £350
% change year-on-year +3.33% +7.14% -
Number of hourly rates quoted 11 14 4
UK median hourly rate £24.00 £42.25 £25.25
Median hourly rate % change year-on-year -43.20% +67.33% -18.55%
10th Percentile £20.75 £17.53 £16.39
90th Percentile £48.75 £48.00 £43.15
UK excluding London median hourly rate £27.00 £42.25 £25.25
% change year-on-year -36.09% +67.33% -20.47%

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

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 22703 23341 26000
As % of all contract IT jobs advertised in the UK 21.97% 22.59% 23.10%
Number of daily rates quoted 15605 15435 17237
UK median daily rate £450 £425 £413
Median daily rate % change year-on-year +5.88% +3.03% +3.13%
10th Percentile £310 £288 £275
90th Percentile £625 £600 £588
UK excluding London median daily rate £400 £380 £375
% change year-on-year +5.26% +1.33% +7.14%
Number of hourly rates quoted 268 355 407
UK median hourly rate £30.63 £28.00 £28.13
Median hourly rate % change year-on-year +9.38% -0.44% +8.17%
10th Percentile £14.25 £10.00 £11.90
90th Percentile £58.75 £51.84 £50.87
UK excluding London median hourly rate £35.00 £28.00 £29.00
% change year-on-year +25.00% -3.45% +16.00%

SQL Server Analysis Services
Job Vacancy Trend

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

Job vacancy trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Daily Rate Trend

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

Contractor daily rate trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing SQL Server Analysis Services over the 6 months to 12 December 2017.

Contractor daily rate histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Hourly Rate Histogram

The hourly rate distribution of IT jobs citing SQL Server Analysis Services over the 6 months to 12 December 2017.

Contractor hourly rate histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 17 Contract Locations

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 UK over the 6 months to 12 December 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
England -62 792 £425 +6.25% 126
London 0 445 £450 - 43
UK excluding London -61 399 £388 +3.33% 88
North of England -42 96 £375 +4.17% 40
South East -34 84 £363 -9.38% 13
Midlands -30 71 £381 +1.67% 11
West Midlands -18 52 £400 +4.23% 8
Yorkshire -24 50 £365 +4.29% 20
South West -23 49 £394 +8.25% 6
East of England -14 47 £335 -16.25% 12
North West -28 43 £388 +10.71% 18
Scotland +13 37 £400 +6.67% 3
East Midlands -30 19 £375 +10.29% 3
Northern Ireland -27 9 £365 -
Wales +6 8 £400 +23.08% 2
North East +43 3 £300 -25.09% 2
Isle of Man - 2 £438 - 1

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

1 704 (82.53%) SQL Server Integration Services
2 653 (76.55%) SQL Server Reporting Services
3 644 (75.50%) SQL
4 639 (74.91%) SQL Server
5 630 (73.86%) Business Intelligence
6 405 (47.48%) Data Warehouse
7 393 (46.07%) Microsoft
8 323 (37.87%) ETL
9 317 (37.16%) T-SQL
10 257 (30.13%) Power BI
11 246 (28.84%) Finance
12 162 (18.99%) MDX
13 155 (18.17%) Data Modelling
14 154 (18.05%) Agile Software Development
15 140 (16.41%) SQL Server 2012
16 136 (15.94%) Kimball Methodology
16 136 (15.94%) C#
17 126 (14.77%) Microsoft Analysis Services
18 125 (14.65%) .NET
18 125 (14.65%) SQL Server 2016
19 116 (13.60%) OLAP
20 107 (12.54%) Microsoft Azure
21 105 (12.31%) SQL Server 2008
22 102 (11.96%) SQL Server 2014
23 93 (10.90%) Tableau
24 92 (10.79%) Analytics
25 90 (10.55%) Data Analysis Expressions (DAX)
26 89 (10.43%) Migration
27 87 (10.20%) Oracle
28 78 (9.14%) Analytical Skills

SQL Server Analysis Services
Co-occurring IT Skills 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 67 (7.85%) SharePoint
2 17 (1.99%) SAS
3 12 (1.41%) IIS
3 12 (1.41%) SharePoint 2010
4 9 (1.06%) Umbraco
5 7 (0.82%) Apache Spark
5 7 (0.82%) BizTalk Server
6 6 (0.70%) WebSphere
7 5 (0.59%) SharePoint 2013
8 3 (0.35%) Apache
8 3 (0.35%) SharePoint Server
9 2 (0.23%) Apache Pig
9 2 (0.23%) CMS
9 2 (0.23%) Kentico
9 2 (0.23%) Orchard CMS
9 2 (0.23%) Sitecore CMS
9 2 (0.23%) Tomcat
9 2 (0.23%) WordPress
10 1 (0.12%) Elasticsearch
10 1 (0.12%) Skype for Business
Applications
1 61 (7.15%) Microsoft Excel
2 15 (1.76%) MS Visio
3 14 (1.64%) Microsoft Office
4 9 (1.06%) Spreadsheet
5 8 (0.94%) Microsoft PowerPoint
6 6 (0.70%) Microsoft Project
7 4 (0.47%) SPSS
Business Applications
1 30 (3.52%) Dynamics AX
2 16 (1.88%) Dynamics CRM
3 9 (1.06%) Actimize
4 7 (0.82%) Unit4 Business World
5 5 (0.59%) NetSuite
6 4 (0.47%) Cognos TM1
7 3 (0.35%) Markit EDM
8 2 (0.23%) Cognos Business Intelligence
8 2 (0.23%) Dynamics NAV
8 2 (0.23%) Endur
8 2 (0.23%) thinkFolio
9 1 (0.12%) Infor M3
9 1 (0.12%) iTrent
9 1 (0.12%) Remedy ITSM
9 1 (0.12%) Salesforce.com CRM
Cloud Services
1 107 (12.54%) Microsoft Azure
2 18 (2.11%) Amazon AWS
3 16 (1.88%) Azure Data Factory
4 11 (1.29%) Dynamics 365
5 9 (1.06%) Data Lake Analytics
5 9 (1.06%) Office 365
6 6 (0.70%) Azure Machine Learning
7 5 (0.59%) IaaS
8 4 (0.47%) PaaS
9 3 (0.35%) Cloud Computing
10 2 (0.23%) Adobe Analytics
10 2 (0.23%) GitHub
10 2 (0.23%) SaaS
11 1 (0.12%) Amazon Kinesis
11 1 (0.12%) AWS CloudFormation
11 1 (0.12%) Azure Active Directory
11 1 (0.12%) Cortana Intelligence Suite
11 1 (0.12%) Google Cloud Platform
11 1 (0.12%) OneDrive
11 1 (0.12%) Yammer
Communications & Networking
1 5 (0.59%) Intranet
1 5 (0.59%) SMS
2 3 (0.35%) SAN
3 2 (0.23%) TCP/IP
4 1 (0.12%) DNS
4 1 (0.12%) Internet
4 1 (0.12%) Skype
Database & Business Intelligence
1 704 (82.53%) SQL Server Integration Services
2 653 (76.55%) SQL Server Reporting Services
3 639 (74.91%) SQL Server
4 405 (47.48%) Data Warehouse
5 257 (30.13%) Power BI
6 140 (16.41%) SQL Server 2012
7 126 (14.77%) Microsoft Analysis Services
8 125 (14.65%) SQL Server 2016
9 116 (13.60%) OLAP
10 105 (12.31%) SQL Server 2008
11 102 (11.96%) SQL Server 2014
12 65 (7.62%) QlikView
13 53 (6.21%) OLAP Cube
14 44 (5.16%) BusinessObjects
15 39 (4.57%) Big Data
16 38 (4.45%) PowerPivot
17 35 (4.10%) Relational Database
18 32 (3.75%) Hadoop
19 30 (3.52%) SQL Server 2005
20 26 (3.05%) Data Lake
Development Applications
1 77 (9.03%) Visual Studio
2 73 (8.56%) Team Foundation Server
3 15 (1.76%) Git (software)
4 14 (1.64%) SQL Server Management Studio (SSMS)
5 10 (1.17%) Subversion
6 9 (1.06%) Jenkins
6 9 (1.06%) Octopus Deploy
7 8 (0.94%) JIRA
7 8 (0.94%) TeamCity
8 6 (0.70%) ERwin
8 6 (0.70%) Toad
9 5 (0.59%) MorphX
10 4 (0.47%) Ant
10 4 (0.47%) ClearCase
10 4 (0.47%) Eclipse
10 4 (0.47%) Maven
11 3 (0.35%) MSTest
11 3 (0.35%) WiX
12 2 (0.23%) Mercurial
12 2 (0.23%) SpecFlow
General
1 246 (28.84%) Finance
2 62 (7.27%) Banking
3 27 (3.17%) Retail
4 20 (2.34%) Marketing
5 17 (1.99%) Law
6 13 (1.52%) Investment Banking
7 12 (1.41%) Legal
8 9 (1.06%) Front Office
9 7 (0.82%) Manufacturing
10 6 (0.70%) Advertising
10 6 (0.70%) Publishing
11 5 (0.59%) Retail Banking
12 4 (0.47%) Back Office
12 4 (0.47%) Pharmaceutical
13 3 (0.35%) Financial Institution
13 3 (0.35%) Telecoms
14 1 (0.12%) Automotive
14 1 (0.12%) Electronics
14 1 (0.12%) Games
14 1 (0.12%) International Banking
Job Titles
1 600 (70.34%) Developer
2 320 (37.51%) Business Intelligence Developer
3 203 (23.80%) SQL Developer
4 141 (16.53%) SSAS Developer
5 134 (15.71%) SSIS Developer
6 97 (11.37%) Analyst
7 94 (11.02%) SQL BI Developer
8 81 (9.50%) SSRS Developer
9 67 (7.85%) Business Developer
10 62 (7.27%) Business Intelligence Analyst
11 60 (7.03%) DBA
12 55 (6.45%) Data Warehouse Developer
13 53 (6.21%) SQL DBA
14 51 (5.98%) Consultant
15 48 (5.63%) Power BI Developer
16 45 (5.28%) SQL Server Developer
17 42 (4.92%) Architect
18 41 (4.81%) ETL Developer
19 40 (4.69%) Microsoft Developer
20 37 (4.34%) .NET Developer
Libraries, Frameworks & Software Standards
1 162 (18.99%) MDX
2 125 (14.65%) .NET
3 39 (4.57%) XML
4 34 (3.99%) CSS
4 34 (3.99%) HTML
5 30 (3.52%) ASP.NET
6 29 (3.40%) Web Services
7 27 (3.17%) WCF
8 25 (2.93%) .NET Framework
9 24 (2.81%) AngularJS
10 19 (2.23%) jQuery
11 14 (1.64%) ASP.NET Web API
12 12 (1.41%) ASP.NET MVC
12 12 (1.41%) Entity Framework
12 12 (1.41%) HTML5
12 12 (1.41%) WPF
13 10 (1.17%) Ajax
13 10 (1.17%) ODBC
14 9 (1.06%) COM
14 9 (1.06%) REST
Miscellaneous
1 78 (9.14%) Analytical Skills
2 45 (5.28%) Greenfield Project
3 21 (2.46%) Replication
4 20 (2.34%) Data Structures
5 16 (1.88%) Equities
5 16 (1.88%) Management Information System
6 15 (1.76%) Clustering
7 14 (1.64%) Fixed Income
7 14 (1.64%) Market Risk
8 11 (1.29%) NHS
9 9 (1.06%) Foreign Exchange (FX)
10 8 (0.94%) Data Centre
11 6 (0.70%) Computer Science
11 6 (0.70%) Credit Risk
11 6 (0.70%) N-Tier
11 6 (0.70%) Reinsurance
12 5 (0.59%) FMCG
13 4 (0.47%) Blog
13 4 (0.47%) Derivative
14 3 (0.35%) Equity Derivative
Operating Systems
1 52 (6.10%) Windows
2 20 (2.34%) Linux
3 13 (1.52%) Windows Server
4 11 (1.29%) Windows Server 2003
5 10 (1.17%) Unix
5 10 (1.17%) Windows Server 2012
6 5 (0.59%) Windows Server 2008
7 1 (0.12%) HPUX
7 1 (0.12%) Red Hat Enterprise Linux
Processes & Methodologies
1 630 (73.86%) Business Intelligence
2 323 (37.87%) ETL
3 155 (18.17%) Data Modelling
4 154 (18.05%) Agile Software Development
5 136 (15.94%) Kimball Methodology
6 92 (10.79%) Analytics
7 89 (10.43%) Migration
8 71 (8.32%) Dimensional Modelling
9 69 (8.09%) Performance Tuning
10 67 (7.85%) Visualisation
11 63 (7.39%) ETL Development
12 59 (6.92%) Scrum
13 55 (6.45%) Data Analysis
14 45 (5.28%) SDLC
15 43 (5.04%) Data Migration
16 40 (4.69%) Data Management
17 34 (3.99%) Unit Testing
18 33 (3.87%) CRM
18 33 (3.87%) Data Visualisation
19 31 (3.63%) Stakeholder Management
Programming Languages
1 644 (75.50%) SQL
2 317 (37.16%) T-SQL
3 136 (15.94%) C#
4 90 (10.55%) Data Analysis Expressions (DAX)
5 50 (5.86%) JavaScript
6 49 (5.74%) PowerShell
7 41 (4.81%) Java
8 28 (3.28%) R
9 27 (3.17%) Python
10 22 (2.58%) PL/SQL
11 21 (2.46%) VB.NET
12 19 (2.23%) VBA
13 13 (1.52%) VB
14 11 (1.29%) C++
15 8 (0.94%) PHP
15 8 (0.94%) VBScript
16 7 (0.82%) C
16 7 (0.82%) Shell Script
17 5 (0.59%) SAS Macro
17 5 (0.59%) X++
Qualifications
1 34 (3.99%) Degree
2 26 (3.05%) Microsoft Certification
3 22 (2.58%) Security Cleared
4 20 (2.34%) SC Cleared
5 13 (1.52%) MCITP
6 11 (1.29%) MCSE
7 7 (0.82%) MCTS
8 5 (0.59%) Computer Science Degree
9 3 (0.35%) ISEB
9 3 (0.35%) MCP
10 2 (0.23%) MCDBA
10 2 (0.23%) MCSD
11 1 (0.12%) CFA
11 1 (0.12%) ISTQB Foundation Certification
11 1 (0.12%) ITIL Certification
11 1 (0.12%) MCSA
11 1 (0.12%) PhD
11 1 (0.12%) PMP
Quality Assurance & Compliance
1 41 (4.81%) Data Quality
2 23 (2.70%) QA
3 13 (1.52%) Solvency II
4 4 (0.47%) COBIT
5 3 (0.35%) ISO/IEC 27001
5 3 (0.35%) MiFID
6 2 (0.23%) PMO
7 1 (0.12%) GDPR
7 1 (0.12%) SLA
System Software
1 8 (0.94%) Active Directory
2 3 (0.35%) Hyper-V
2 3 (0.35%) Virtual Machines
2 3 (0.35%) VMware ESXi
3 2 (0.23%) VMware Infrastructure
4 1 (0.12%) Docker
4 1 (0.12%) HDFS
4 1 (0.12%) UAG
Systems Management
1 5 (0.59%) Microsoft Clustering
2 3 (0.35%) HP Data Protector
2 3 (0.35%) Systems Management Server (SMS)
3 2 (0.23%) Failover Clustering
3 2 (0.23%) Oozie
3 2 (0.23%) Oracle RMAN
3 2 (0.23%) Puppet
3 2 (0.23%) WMI
4 1 (0.12%) Data Guard
4 1 (0.12%) Opscode Chef
4 1 (0.12%) Packer
4 1 (0.12%) Terraform
4 1 (0.12%) vCenter Server
Vendors
1 393 (46.07%) Microsoft
2 93 (10.90%) Tableau
3 87 (10.20%) Oracle
4 26 (3.05%) Informatica
5 24 (2.81%) IBM
6 21 (2.46%) Cognos
7 20 (2.34%) RedGate
8 14 (1.64%) JD Edwards
9 13 (1.52%) SAP
10 12 (1.41%) Sybase
11 10 (1.17%) VMware
12 8 (0.94%) Netezza
13 4 (0.47%) Capita
13 4 (0.47%) Jaspersoft
14 3 (0.35%) Bloomberg
14 3 (0.35%) Cloudera
14 3 (0.35%) Hortonworks
14 3 (0.35%) Remedy
14 3 (0.35%) Salesforce.com
14 3 (0.35%) Teradata