Period
to 21 October 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 21 October 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
21 Oct 2017
Same period 2016 Same period 2015
Rank 313 262 174
Rank change year-on-year -51 -88 +50
Contract jobs citing SQL Server Analysis Services 792 1040 1659
As % of all contract IT jobs advertised in the UK 0.80% 0.98% 1.45%
As % of the Database & Business Intelligence category 3.59% 4.35% 6.24%
Number of daily rates quoted 574 746 1297
UK median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - -
10th Percentile £313 £275 £275
90th Percentile £575 £532 £550
UK excluding London median daily rate £375 £375 £350
% change year-on-year - +7.14% +0.72%
Number of hourly rates quoted 11 11 6
UK median hourly rate £24.00 £44.00 £33.00
Median hourly rate % change year-on-year -45.45% +33.33% +22.22%
10th Percentile £20.75 £16.25 £16.48
90th Percentile £48.75 £51.00 £41.25
UK excluding London median hourly rate £27.00 £44.00 £33.00
% change year-on-year -38.64% +33.33% +22.22%

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 22054 23892 26575
As % of all contract IT jobs advertised in the UK 22.20% 22.50% 23.29%
Number of daily rates quoted 14915 15901 17443
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +3.23%
10th Percentile £308 £281 £263
90th Percentile £625 £588 £575
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.14%
Number of hourly rates quoted 275 393 392
UK median hourly rate £30.00 £29.50 £28.06
Median hourly rate % change year-on-year +1.69% +5.12% +12.25%
10th Percentile £13.69 £11.05 £12.53
90th Percentile £54.50 £49.75 £52.50
UK excluding London median hourly rate £32.50 £28.50 £28.69
% change year-on-year +14.04% -0.66% +27.51%

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 21 October 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 21 October 2017.

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

SQL Server Analysis Services
Top 16 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 21 October 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 -45 732 £425 +6.25% 127
UK excluding London -48 398 £375 - 79
London -18 385 £450 - 49
North of England +2 116 £363 -3.33% 32
South East -22 83 £400 +2.56% 18
North West -6 68 £363 -9.38% 14
Midlands -25 58 £375 +10.29% 18
Yorkshire -10 46 £366 +1.03% 17
East of England -26 44 £450 +12.50% 5
Scotland +46 43 £425 +21.43%
South West -11 42 £375 +15.38% 5
West Midlands 0 41 £375 +13.21% 11
East Midlands -32 17 £388 +10.71% 7
Northern Ireland -44 8 £365 -
Wales +1 4 £350 -9.68%
North East +48 2 £290 -25.64% 1

For the 6 months to 21 October 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 656 (82.83%) SQL Server Integration Services
2 627 (79.17%) SQL Server Reporting Services
3 600 (75.76%) SQL
4 591 (74.62%) SQL Server
5 568 (71.72%) Business Intelligence
6 386 (48.74%) Microsoft
7 365 (46.09%) Data Warehouse
8 308 (38.89%) T-SQL
9 275 (34.72%) ETL
10 227 (28.66%) Finance
11 200 (25.25%) Power BI
12 143 (18.06%) Agile Software Development
13 139 (17.55%) SQL Server 2012
14 136 (17.17%) MDX
15 133 (16.79%) Data Modelling
16 131 (16.54%) C#
17 123 (15.53%) Kimball Methodology
18 119 (15.03%) .NET
19 112 (14.14%) Microsoft Analysis Services
20 106 (13.38%) SQL Server 2008
21 102 (12.88%) SQL Server 2014
22 100 (12.63%) OLAP
23 99 (12.50%) Microsoft Azure
24 98 (12.37%) SQL Server 2016
25 81 (10.23%) Team Foundation Server
26 77 (9.72%) Tableau
27 72 (9.09%) Analytics
28 68 (8.59%) Analytical Skills
29 63 (7.95%) Data Analysis Expressions (DAX)
29 63 (7.95%) Oracle

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 63 (7.95%) SharePoint
2 14 (1.77%) IIS
2 14 (1.77%) SharePoint 2010
3 11 (1.39%) Umbraco
4 10 (1.26%) BizTalk Server
5 9 (1.14%) SAS
6 7 (0.88%) Apache Spark
7 6 (0.76%) CMS
7 6 (0.76%) SharePoint 2013
8 5 (0.63%) WebSphere
9 2 (0.25%) Apache Pig
9 2 (0.25%) Kentico
9 2 (0.25%) Orchard CMS
9 2 (0.25%) Sitecore CMS
9 2 (0.25%) Tomcat
10 1 (0.13%) Apache
10 1 (0.13%) Elasticsearch
10 1 (0.13%) Exchange Server 2013
10 1 (0.13%) MS Exchange
10 1 (0.13%) WordPress
Applications
1 59 (7.45%) Microsoft Excel
2 16 (2.02%) Microsoft Office
3 10 (1.26%) Microsoft PowerPoint
4 8 (1.01%) MS Visio
5 4 (0.51%) Microsoft Project
6 2 (0.25%) Spreadsheet
6 2 (0.25%) SPSS
Business Applications
1 29 (3.66%) Dynamics AX
2 11 (1.39%) Dynamics CRM
3 9 (1.14%) Markit EDM
4 8 (1.01%) Actimize
5 6 (0.76%) Cognos TM1
5 6 (0.76%) Unit4 Business World
6 3 (0.38%) Dynamics NAV
7 2 (0.25%) Cognos Business Intelligence
7 2 (0.25%) Endur
7 2 (0.25%) NetSuite
7 2 (0.25%) thinkFolio
8 1 (0.13%) iTrent
8 1 (0.13%) Lorenzo
8 1 (0.13%) Remedy ITSM
8 1 (0.13%) Salesforce.com CRM
Cloud Services
1 99 (12.50%) Microsoft Azure
2 22 (2.78%) Amazon AWS
3 14 (1.77%) Azure Data Factory
4 13 (1.64%) Office 365
5 7 (0.88%) Dynamics 365
6 5 (0.63%) Azure Active Directory
6 5 (0.63%) Data Lake Analytics
6 5 (0.63%) IaaS
6 5 (0.63%) OneDrive
6 5 (0.63%) Yammer
7 4 (0.51%) PaaS
8 3 (0.38%) Amazon EMR
8 3 (0.38%) Amazon S3
8 3 (0.38%) AWS Lambda
8 3 (0.38%) Cloud Computing
8 3 (0.38%) Serverless
9 2 (0.25%) Azure Machine Learning
9 2 (0.25%) SaaS
10 1 (0.13%) Google Analytics
10 1 (0.13%) Google Cloud Platform
Communications & Networking
1 6 (0.76%) TCP/IP
2 5 (0.63%) DNS
3 4 (0.51%) Intranet
3 4 (0.51%) SAN
3 4 (0.51%) SMS
4 2 (0.25%) NAS
Database & Business Intelligence
1 656 (82.83%) SQL Server Integration Services
2 627 (79.17%) SQL Server Reporting Services
3 591 (74.62%) SQL Server
4 365 (46.09%) Data Warehouse
5 200 (25.25%) Power BI
6 139 (17.55%) SQL Server 2012
7 112 (14.14%) Microsoft Analysis Services
8 106 (13.38%) SQL Server 2008
9 102 (12.88%) SQL Server 2014
10 100 (12.63%) OLAP
11 98 (12.37%) SQL Server 2016
12 56 (7.07%) QlikView
13 45 (5.68%) OLAP Cube
14 40 (5.05%) PowerPivot
15 34 (4.29%) Big Data
15 34 (4.29%) SQL Server 2005
16 31 (3.91%) BusinessObjects
17 30 (3.79%) Relational Database
18 27 (3.41%) Hadoop
19 21 (2.65%) Azure SQL Database
Development Applications
1 81 (10.23%) Team Foundation Server
2 63 (7.95%) Visual Studio
3 16 (2.02%) Git (software)
4 12 (1.52%) TeamCity
5 11 (1.39%) Octopus Deploy
6 10 (1.26%) Jenkins
7 9 (1.14%) Subversion
8 7 (0.88%) JIRA
8 7 (0.88%) SQL Server Management Studio (SSMS)
9 5 (0.63%) Ant
9 5 (0.63%) ClearCase
9 5 (0.63%) Maven
10 3 (0.38%) Eclipse
10 3 (0.38%) MorphX
10 3 (0.38%) MSTest
10 3 (0.38%) Toad
10 3 (0.38%) Visual Studio Team System
10 3 (0.38%) WiX
11 2 (0.25%) gulp
11 2 (0.25%) SpecFlow
General
1 227 (28.66%) Finance
2 62 (7.83%) Banking
3 33 (4.17%) Retail
4 17 (2.15%) Investment Banking
4 17 (2.15%) Marketing
5 13 (1.64%) Front Office
5 13 (1.64%) Legal
6 12 (1.52%) Law
7 7 (0.88%) Publishing
8 6 (0.76%) Retail Banking
9 5 (0.63%) Back Office
9 5 (0.63%) Manufacturing
9 5 (0.63%) Telecoms
10 4 (0.51%) Advertising
10 4 (0.51%) Pharmaceutical
11 3 (0.38%) Financial Institution
11 3 (0.38%) German Language
12 2 (0.25%) Private Banking
13 1 (0.13%) French Language
13 1 (0.13%) International Banking
Job Titles
1 539 (68.06%) Developer
2 276 (34.85%) Business Intelligence Developer
3 183 (23.11%) SQL Developer
4 114 (14.39%) SSIS Developer
5 107 (13.51%) SSAS Developer
6 85 (10.73%) Analyst
7 76 (9.60%) SQL BI Developer
7 76 (9.60%) SSRS Developer
8 63 (7.95%) DBA
9 58 (7.32%) Business Developer
10 54 (6.82%) SQL DBA
11 49 (6.19%) Business Intelligence Analyst
11 49 (6.19%) Consultant
12 45 (5.68%) Data Warehouse Developer
13 41 (5.18%) Architect
13 41 (5.18%) ETL Developer
14 40 (5.05%) SQL Server Developer
15 38 (4.80%) Microsoft Developer
15 38 (4.80%) Power BI Developer
16 36 (4.55%) .NET Developer
Libraries, Frameworks & Software Standards
1 136 (17.17%) MDX
2 119 (15.03%) .NET
3 39 (4.92%) XML
4 34 (4.29%) ASP.NET
4 34 (4.29%) CSS
4 34 (4.29%) HTML
4 34 (4.29%) Web Services
5 33 (4.17%) WCF
6 28 (3.54%) .NET Framework
7 24 (3.03%) AngularJS
8 21 (2.65%) jQuery
9 15 (1.89%) ASP.NET Web API
9 15 (1.89%) HTML5
10 14 (1.77%) Entity Framework
11 13 (1.64%) Ajax
11 13 (1.64%) ASP.NET MVC
12 10 (1.26%) ODBC
13 8 (1.01%) COM
13 8 (1.01%) JSON
13 8 (1.01%) WPF
Miscellaneous
1 68 (8.59%) Analytical Skills
2 35 (4.42%) Replication
3 29 (3.66%) Greenfield Project
4 24 (3.03%) Clustering
5 19 (2.40%) Data Structures
6 18 (2.27%) Fixed Income
7 14 (1.77%) Market Risk
8 13 (1.64%) Equities
8 13 (1.64%) Management Information System
9 12 (1.52%) Data Centre
10 11 (1.39%) Foreign Exchange (FX)
10 11 (1.39%) NHS
11 10 (1.26%) Reinsurance
12 9 (1.14%) Derivative
13 6 (0.76%) FMCG
14 5 (0.63%) Algorithms
14 5 (0.63%) Computer Science
15 4 (0.51%) Enterprise Software
15 4 (0.51%) N-Tier
16 3 (0.38%) Equity Derivative
Operating Systems
1 62 (7.83%) Windows
2 24 (3.03%) Windows Server
3 19 (2.40%) Linux
4 15 (1.89%) Windows Server 2003
5 11 (1.39%) Windows Server 2008
5 11 (1.39%) Windows Server 2012
6 8 (1.01%) Unix
7 1 (0.13%) HPUX
7 1 (0.13%) Red Hat Enterprise Linux
7 1 (0.13%) Windows 10
7 1 (0.13%) Windows 7
Processes & Methodologies
1 568 (71.72%) Business Intelligence
2 275 (34.72%) ETL
3 143 (18.06%) Agile Software Development
4 133 (16.79%) Data Modelling
5 123 (15.53%) Kimball Methodology
6 72 (9.09%) Analytics
7 61 (7.70%) Migration
8 59 (7.45%) Performance Tuning
9 54 (6.82%) Scrum
10 51 (6.44%) Dimensional Modelling
11 48 (6.06%) Data Analysis
12 46 (5.81%) SDLC
13 38 (4.80%) Visualisation
14 37 (4.67%) Data Management
14 37 (4.67%) ETL Development
15 32 (4.04%) Stakeholder Management
16 31 (3.91%) CRM
16 31 (3.91%) Dashboard Development
16 31 (3.91%) High Availability
17 30 (3.79%) Data Migration
Programming Languages
1 600 (75.76%) SQL
2 308 (38.89%) T-SQL
3 131 (16.54%) C#
4 63 (7.95%) Data Analysis Expressions (DAX)
5 58 (7.32%) PowerShell
6 50 (6.31%) JavaScript
7 39 (4.92%) Java
8 22 (2.78%) Python
9 20 (2.53%) R
10 19 (2.40%) VB
11 17 (2.15%) VBA
12 16 (2.02%) PL/SQL
12 16 (2.02%) VB.NET
13 10 (1.26%) C++
14 8 (1.01%) C
14 8 (1.01%) PHP
14 8 (1.01%) VBScript
15 7 (0.88%) Shell Script
16 4 (0.51%) Bash Shell
17 3 (0.38%) X++
Qualifications
1 26 (3.28%) Degree
2 20 (2.53%) Microsoft Certification
3 16 (2.02%) Security Cleared
4 15 (1.89%) SC Cleared
5 14 (1.77%) MCITP
6 8 (1.01%) MCTS
7 7 (0.88%) ISEB
7 7 (0.88%) MCSE
8 6 (0.76%) ITIL Certification
9 5 (0.63%) Computer Science Degree
10 4 (0.51%) ISTQB
10 4 (0.51%) MCDBA
11 2 (0.25%) Numerate Degree
12 1 (0.13%) CFA
12 1 (0.13%) ISTQB Foundation Certification
12 1 (0.13%) MCP
12 1 (0.13%) PhD
12 1 (0.13%) PMP
Quality Assurance & Compliance
1 44 (5.56%) Data Quality
2 21 (2.65%) QA
3 13 (1.64%) Solvency II
4 8 (1.01%) COBIT
5 4 (0.51%) PMO
6 3 (0.38%) GDPR
6 3 (0.38%) MiFID
7 2 (0.25%) SLA
8 1 (0.13%) Cyber Essentials
8 1 (0.13%) Cyber Essentials PLUS
8 1 (0.13%) Disclosure Scotland
System Software
1 12 (1.52%) Active Directory
2 5 (0.63%) UAG
3 3 (0.38%) Hyper-V
3 3 (0.38%) Virtual Machines
4 2 (0.25%) VMware ESXi
5 1 (0.13%) Docker
5 1 (0.13%) VMware Infrastructure
Systems Management
1 12 (1.52%) Microsoft Clustering
2 3 (0.38%) HP Quality Center
2 3 (0.38%) Systems Management Server (SMS)
3 2 (0.25%) Failover Clustering
3 2 (0.25%) HP Data Protector
3 2 (0.25%) Oozie
3 2 (0.25%) Oracle RMAN
3 2 (0.25%) Puppet
3 2 (0.25%) WMI
4 1 (0.13%) Data Guard
4 1 (0.13%) Opscode Chef
4 1 (0.13%) Packer
4 1 (0.13%) Symantec Enterprise Vault
4 1 (0.13%) Terraform
Vendors
1 386 (48.74%) Microsoft
2 77 (9.72%) Tableau
3 63 (7.95%) Oracle
4 22 (2.78%) Informatica
5 19 (2.40%) Cognos
5 19 (2.40%) RedGate
6 12 (1.52%) JD Edwards
7 10 (1.26%) Sybase
8 9 (1.14%) Bloomberg
8 9 (1.14%) IBM
8 9 (1.14%) SAP
9 8 (1.01%) VMware
10 7 (0.88%) FactSet
11 6 (0.76%) Cloudera
12 4 (0.51%) Jaspersoft
12 4 (0.51%) Netezza
13 3 (0.38%) Alteryx
13 3 (0.38%) Hortonworks
13 3 (0.38%) Remedy
13 3 (0.38%) Salesforce.com