Period
to 21 September 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 September 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 Sep 2017
Same period 2016 Same period 2015
Rank 298 272 172
Rank change year-on-year -26 -100 +56
Contract jobs citing SQL Server Analysis Services 812 1005 1666
As % of all contract IT jobs advertised in the UK 0.82% 0.93% 1.47%
As % of the Database & Business Intelligence category 3.67% 4.20% 6.31%
Number of daily rates quoted 581 735 1285
UK median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - -
10th Percentile £313 £277 £275
90th Percentile £575 £538 £550
UK excluding London median daily rate £375 £375 £343
% change year-on-year - +9.49% +1.11%
Number of hourly rates quoted 10 11 6
UK median hourly rate £22.75 £44.00 £33.00
Median hourly rate % change year-on-year -48.30% +33.33% +22.22%
10th Percentile £20.31 £16.25 £16.48
90th Percentile £62.05 £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 22150 23951 26390
As % of all contract IT jobs advertised in the UK 22.43% 22.26% 23.25%
Number of daily rates quoted 14782 16057 17373
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +3.23%
10th Percentile £305 £281 £263
90th Percentile £625 £599 £575
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.14%
Number of hourly rates quoted 276 389 388
UK median hourly rate £29.50 £29.88 £28.50
Median hourly rate % change year-on-year -1.27% +4.84% +4.59%
10th Percentile £12.19 £11.25 £13.68
90th Percentile £53.75 £48.75 £52.26
UK excluding London median hourly rate £30.00 £28.50 £29.50
% change year-on-year +5.26% -3.39% +18.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 21 September 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 September 2017.

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

SQL Server Analysis Services
Top 15 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 September 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 -38 748 £425 +6.25% 134
UK excluding London -26 412 £375 - 89
London -1 391 £458 +1.67% 51
North of England +18 125 £363 -3.33% 24
South East -24 88 £400 +2.56% 15
North West +29 74 £363 -12.12% 14
Midlands -28 63 £350 - 16
Yorkshire +8 51 £350 -4.11% 8
Scotland +59 41 £425 +23.19% 6
East of England -11 41 £450 +12.50% 13
West Midlands +8 40 £350 -2.78% 7
South West -30 37 £375 +10.29% 13
East Midlands -28 23 £375 +7.14% 9
Northern Ireland -50 10 £365 -23.16% 1
Wales -1 7 £350 -11.11% 1

For the 6 months to 21 September 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 675 (83.13%) SQL Server Integration Services
2 664 (81.77%) SQL Server Reporting Services
3 608 (74.88%) SQL
4 602 (74.14%) SQL Server
5 567 (69.83%) Business Intelligence
6 395 (48.65%) Microsoft
7 362 (44.58%) Data Warehouse
8 319 (39.29%) T-SQL
9 276 (33.99%) ETL
10 215 (26.48%) Finance
11 195 (24.01%) Power BI
12 153 (18.84%) SQL Server 2012
13 144 (17.73%) C#
13 144 (17.73%) MDX
14 142 (17.49%) Agile Software Development
15 132 (16.26%) .NET
16 124 (15.27%) Kimball Methodology
17 121 (14.90%) Microsoft Analysis Services
18 116 (14.29%) Data Modelling
19 107 (13.18%) SQL Server 2008
20 106 (13.05%) SQL Server 2014
21 98 (12.07%) SQL Server 2016
22 97 (11.95%) OLAP
23 95 (11.70%) Microsoft Azure
24 84 (10.34%) Team Foundation Server
25 78 (9.61%) Tableau
26 77 (9.48%) Analytics
27 72 (8.87%) Performance Tuning
28 67 (8.25%) Banking
29 66 (8.13%) Microsoft Excel

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 65 (8.00%) SharePoint
2 15 (1.85%) Umbraco
3 14 (1.72%) SharePoint 2010
4 10 (1.23%) BizTalk Server
5 8 (0.99%) IIS
6 7 (0.86%) Apache Spark
7 6 (0.74%) CMS
7 6 (0.74%) SAS
7 6 (0.74%) SharePoint 2013
7 6 (0.74%) WebSphere
8 2 (0.25%) Apache Pig
8 2 (0.25%) Kentico
8 2 (0.25%) Orchard CMS
8 2 (0.25%) Sitecore CMS
9 1 (0.12%) Adobe Experience Manager
9 1 (0.12%) Elasticsearch
9 1 (0.12%) Exchange Server 2007
9 1 (0.12%) Exchange Server 2013
9 1 (0.12%) Oracle 10gAS
9 1 (0.12%) WordPress
Applications
1 66 (8.13%) Microsoft Excel
2 16 (1.97%) Microsoft Office
3 9 (1.11%) Microsoft PowerPoint
4 8 (0.99%) MS Visio
5 6 (0.74%) Spreadsheet
6 4 (0.49%) Microsoft Project
Business Applications
1 27 (3.33%) Dynamics AX
2 10 (1.23%) Actimize
2 10 (1.23%) Markit EDM
3 8 (0.99%) Dynamics CRM
4 5 (0.62%) Cognos TM1
5 4 (0.49%) Unit4 Business World
6 3 (0.37%) Dynamics NAV
7 2 (0.25%) Cognos Business Intelligence
8 1 (0.12%) Adobe Campaign
8 1 (0.12%) Endur
8 1 (0.12%) iTrent
8 1 (0.12%) Lorenzo
Cloud Services
1 95 (11.70%) Microsoft Azure
2 21 (2.59%) Amazon AWS
3 14 (1.72%) Office 365
4 13 (1.60%) Azure Data Factory
5 5 (0.62%) Azure Active Directory
5 5 (0.62%) Cloud Computing
5 5 (0.62%) Data Lake Analytics
5 5 (0.62%) Dynamics 365
5 5 (0.62%) OneDrive
5 5 (0.62%) Yammer
6 4 (0.49%) IaaS
6 4 (0.49%) PaaS
7 3 (0.37%) Amazon EMR
7 3 (0.37%) Amazon S3
7 3 (0.37%) AWS Lambda
8 1 (0.12%) Adobe Analytics
8 1 (0.12%) Amazon Kinesis
8 1 (0.12%) Azure Machine Learning
8 1 (0.12%) BIME
8 1 (0.12%) SaaS
Communications & Networking
1 9 (1.11%) SAN
2 5 (0.62%) DNS
2 5 (0.62%) TCP/IP
3 4 (0.49%) Intranet
3 4 (0.49%) NAS
4 3 (0.37%) SMS
5 1 (0.12%) Internet
Database & Business Intelligence
1 675 (83.13%) SQL Server Integration Services
2 664 (81.77%) SQL Server Reporting Services
3 602 (74.14%) SQL Server
4 362 (44.58%) Data Warehouse
5 195 (24.01%) Power BI
6 153 (18.84%) SQL Server 2012
7 121 (14.90%) Microsoft Analysis Services
8 107 (13.18%) SQL Server 2008
9 106 (13.05%) SQL Server 2014
10 98 (12.07%) SQL Server 2016
11 97 (11.95%) OLAP
12 56 (6.90%) QlikView
13 44 (5.42%) OLAP Cube
14 39 (4.80%) PowerPivot
15 38 (4.68%) Big Data
16 34 (4.19%) SQL Server 2005
17 33 (4.06%) Relational Database
18 32 (3.94%) BusinessObjects
19 27 (3.33%) Hadoop
20 21 (2.59%) Data Mart
Development Applications
1 84 (10.34%) Team Foundation Server
2 59 (7.27%) Visual Studio
3 16 (1.97%) Git (software)
4 13 (1.60%) TeamCity
5 12 (1.48%) Jenkins
6 11 (1.35%) Octopus Deploy
7 8 (0.99%) SQL Server Management Studio (SSMS)
7 8 (0.99%) Subversion
8 7 (0.86%) JIRA
9 5 (0.62%) Ant
9 5 (0.62%) ClearCase
9 5 (0.62%) Maven
10 4 (0.49%) WiX
11 3 (0.37%) MorphX
11 3 (0.37%) Visual Studio Team System
12 2 (0.25%) Eclipse
12 2 (0.25%) gulp
12 2 (0.25%) Mockito
12 2 (0.25%) MSTest
12 2 (0.25%) SpecFlow
General
1 215 (26.48%) Finance
2 67 (8.25%) Banking
3 38 (4.68%) Retail
4 23 (2.83%) Investment Banking
4 23 (2.83%) Marketing
5 16 (1.97%) Legal
6 15 (1.85%) Law
7 13 (1.60%) Front Office
8 8 (0.99%) Publishing
9 6 (0.74%) Retail Banking
10 5 (0.62%) Advertising
10 5 (0.62%) Back Office
10 5 (0.62%) Telecoms
11 4 (0.49%) Financial Institution
11 4 (0.49%) Manufacturing
11 4 (0.49%) Pharmaceutical
12 3 (0.37%) German Language
13 2 (0.25%) Local Government
13 2 (0.25%) Private Banking
14 1 (0.12%) International Banking
Job Titles
1 559 (68.84%) Developer
2 284 (34.98%) Business Intelligence Developer
3 191 (23.52%) SQL Developer
4 113 (13.92%) SSIS Developer
5 105 (12.93%) SSAS Developer
6 87 (10.71%) SSRS Developer
7 81 (9.98%) SQL BI Developer
8 71 (8.74%) Analyst
9 66 (8.13%) DBA
10 60 (7.39%) Business Developer
10 60 (7.39%) SQL DBA
11 55 (6.77%) Consultant
12 48 (5.91%) SQL Server Developer
13 46 (5.67%) .NET Developer
13 46 (5.67%) Data Warehouse Developer
14 44 (5.42%) Architect
14 44 (5.42%) ETL Developer
15 40 (4.93%) Business Intelligence Analyst
15 40 (4.93%) Power BI Developer
16 39 (4.80%) C# Developer
Libraries, Frameworks & Software Standards
1 144 (17.73%) MDX
2 132 (16.26%) .NET
3 46 (5.67%) ASP.NET
4 41 (5.05%) WCF
5 38 (4.68%) Web Services
5 38 (4.68%) XML
6 32 (3.94%) CSS
6 32 (3.94%) HTML
7 26 (3.20%) .NET Framework
7 26 (3.20%) AngularJS
8 23 (2.83%) jQuery
9 18 (2.22%) ASP.NET MVC
9 18 (2.22%) ASP.NET Web API
10 17 (2.09%) Entity Framework
11 15 (1.85%) HTML5
12 14 (1.72%) REST
13 12 (1.48%) Ajax
14 10 (1.23%) JSON
14 10 (1.23%) Twitter Bootstrap
15 8 (0.99%) COM
Miscellaneous
1 54 (6.65%) Analytical Skills
2 43 (5.30%) Replication
3 30 (3.69%) Clustering
4 26 (3.20%) Greenfield Project
5 19 (2.34%) Data Structures
6 17 (2.09%) Fixed Income
7 14 (1.72%) Market Risk
8 13 (1.60%) Derivative
9 12 (1.48%) Data Centre
9 12 (1.48%) Equities
9 12 (1.48%) Management Information System
10 10 (1.23%) Foreign Exchange (FX)
10 10 (1.23%) NHS
11 9 (1.11%) Reinsurance
12 7 (0.86%) Computer Science
12 7 (0.86%) Credit Derivative
13 6 (0.74%) Algorithms
13 6 (0.74%) Enterprise Software
14 5 (0.62%) Credit Risk
15 4 (0.49%) Grid Computing
Operating Systems
1 62 (7.64%) Windows
2 27 (3.33%) Windows Server
3 19 (2.34%) Linux
4 15 (1.85%) Windows Server 2003
5 14 (1.72%) Windows Server 2008
6 13 (1.60%) Windows Server 2012
7 5 (0.62%) Unix
8 1 (0.12%) HPUX
8 1 (0.12%) Red Hat Enterprise Linux
8 1 (0.12%) Solaris
8 1 (0.12%) Windows 10
8 1 (0.12%) Windows 7
Processes & Methodologies
1 567 (69.83%) Business Intelligence
2 276 (33.99%) ETL
3 142 (17.49%) Agile Software Development
4 124 (15.27%) Kimball Methodology
5 116 (14.29%) Data Modelling
6 77 (9.48%) Analytics
7 72 (8.87%) Performance Tuning
8 59 (7.27%) Migration
9 49 (6.03%) SDLC
10 48 (5.91%) Dimensional Modelling
10 48 (5.91%) Scrum
11 40 (4.93%) Unit Testing
12 38 (4.68%) Data Analysis
13 37 (4.56%) ETL Development
13 37 (4.56%) MVC
14 35 (4.31%) Data Management
15 32 (3.94%) High Availability
16 29 (3.57%) Stakeholder Management
17 27 (3.33%) OO
17 27 (3.33%) Visualisation
Programming Languages
1 608 (74.88%) SQL
2 319 (39.29%) T-SQL
3 144 (17.73%) C#
4 63 (7.76%) Data Analysis Expressions (DAX)
5 56 (6.90%) PowerShell
6 51 (6.28%) JavaScript
7 38 (4.68%) Java
8 21 (2.59%) VB
9 20 (2.46%) Python
10 19 (2.34%) R
11 18 (2.22%) VBA
12 16 (1.97%) PL/SQL
12 16 (1.97%) VB.NET
13 9 (1.11%) C
14 8 (0.99%) C++
15 7 (0.86%) PHP
16 6 (0.74%) VBScript
17 5 (0.62%) Shell Script
18 4 (0.49%) X++
19 3 (0.37%) VC++
Qualifications
1 27 (3.33%) Degree
2 23 (2.83%) Security Cleared
3 22 (2.71%) Microsoft Certification
3 22 (2.71%) SC Cleared
4 15 (1.85%) MCITP
5 9 (1.11%) MCTS
6 8 (0.99%) Computer Science Degree
7 7 (0.86%) ITIL Certification
7 7 (0.86%) MCSE
8 6 (0.74%) ISEB
9 5 (0.62%) MCDBA
10 4 (0.49%) ISTQB
11 3 (0.37%) Numerate Degree
12 1 (0.12%) CFA
12 1 (0.12%) DV Cleared
12 1 (0.12%) Master's Degree
12 1 (0.12%) MCP
Quality Assurance & Compliance
1 39 (4.80%) Data Quality
2 22 (2.71%) QA
3 9 (1.11%) Solvency II
4 8 (0.99%) COBIT
5 6 (0.74%) PMO
6 4 (0.49%) SLA
7 3 (0.37%) GDPR
7 3 (0.37%) MiFID
8 2 (0.25%) ISO/IEC 27001
9 1 (0.12%) Cyber Essentials
9 1 (0.12%) Cyber Essentials PLUS
9 1 (0.12%) Disclosure Scotland
System Software
1 12 (1.48%) Active Directory
2 5 (0.62%) UAG
3 3 (0.37%) Hyper-V
4 2 (0.25%) Virtual Machines
5 1 (0.12%) VMware ESXi
5 1 (0.12%) VMware Infrastructure
Systems Management
1 16 (1.97%) Microsoft Clustering
2 3 (0.37%) HP Quality Center
2 3 (0.37%) Systems Management Server (SMS)
3 2 (0.25%) Failover Clustering
3 2 (0.25%) Oozie
3 2 (0.25%) Oracle RMAN
4 1 (0.12%) Control-M
4 1 (0.12%) Data Guard
4 1 (0.12%) HP Data Protector
4 1 (0.12%) Symantec Enterprise Vault
Vendors
1 395 (48.65%) Microsoft
2 78 (9.61%) Tableau
3 65 (8.00%) Oracle
4 20 (2.46%) Cognos
5 18 (2.22%) Informatica
6 15 (1.85%) RedGate
7 11 (1.35%) JD Edwards
7 11 (1.35%) Sybase
8 10 (1.23%) Bloomberg
9 9 (1.11%) SAP
10 8 (0.99%) FactSet
11 6 (0.74%) Cloudera
12 5 (0.62%) Jaspersoft
13 4 (0.49%) IBM
14 3 (0.37%) Alteryx
14 3 (0.37%) Hortonworks
14 3 (0.37%) VMware
15 2 (0.25%) Remedy
15 2 (0.25%) Salesforce.com
15 2 (0.25%) Sitecore