Period
to 18 February 2018

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 18 February 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)
UK
6 months to
18 Feb 2018
Same period 2017 Same period 2016
Rank 300 250 196
Rank change year-on-year -50 -54 +20
Contract jobs citing SQL Server Analysis Services 807 973 1,386
As % of all contract IT jobs advertised in the UK 0.81% 1.02% 1.28%
As % of the Database & Business Intelligence category 3.70% 4.55% 5.60%
Number of daily rates quoted 643 689 1,091
UK median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - +6.67%
10th Percentile £300 £300 £275
90th Percentile £530 £539 £550
UK excluding London median daily rate £375 £375 £375
Number of hourly rates quoted 8 14 1
UK median hourly rate £27.00 £39.38 £45.00
Median hourly rate % change year-on-year -31.43% -12.50% +100.00%
10th Percentile £20.75 £22.03 £42.50
90th Percentile £44.38 £45.10 £47.50
UK excluding London median hourly rate £27.00 £39.38 £45.00
% change year-on-year -31.43% -12.50% +80.00%

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 21,826 21,369 24,751
As % of all contract IT jobs advertised in the UK 21.85% 22.44% 22.92%
Number of daily rates quoted 15,190 14,284 16,565
UK median daily rate £463 £425 £420
Median daily rate % change year-on-year +8.82% +1.19% +5.00%
10th Percentile £313 £290 £275
90th Percentile £625 £613 £588
UK excluding London median daily rate £400 £395 £375
% change year-on-year +1.27% +5.33% +4.17%
Number of hourly rates quoted 254 302 409
UK median hourly rate £34.25 £26.50 £28.00
Median hourly rate % change year-on-year +29.25% -5.36% +1.82%
10th Percentile £15.05 £9.43 £11.95
90th Percentile £56.84 £48.63 £52.50
UK excluding London median hourly rate £39.00 £24.50 £27.50
% change year-on-year +59.18% -10.91% +2.80%

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 18 February 2018.

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 18 February 2018.

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 18 February 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
England -61 741 £425 +6.25% 317
London -51 424 £450 - 113
UK excluding London -52 379 £375 - 220
Midlands -23 88 £375 -3.23% 57
North of England -45 82 £366 +4.64% 65
South East -29 66 £350 -12.50% 41
West Midlands -12 61 £400 - 31
Scotland +6 47 £375 -6.25% 7
South West -17 44 £400 +8.11% 14
Yorkshire -34 42 £363 +3.57% 25
East of England -18 38 £335 -13.55% 25
North West -37 33 £375 +7.14% 38
East Midlands -18 26 £300 -17.24% 24
Isle of Man - 8 £400 -
North East +31 7 £368 -5.47% 2
Wales -2 7 £400 +23.08% 10
Northern Ireland - 3 - - 1

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

1 695 (86.12%) SQL Server Integration Services
2 628 (77.82%) SQL
3 626 (77.57%) SQL Server Reporting Services
4 609 (75.46%) Business Intelligence
5 606 (75.09%) SQL Server
6 366 (45.35%) Data Warehouse
7 357 (44.24%) Microsoft
8 286 (35.44%) ETL
9 278 (34.45%) T-SQL
10 264 (32.71%) Power BI
11 198 (24.54%) Finance
12 149 (18.46%) Data Modelling
13 140 (17.35%) Agile Software Development
14 137 (16.98%) MDX
15 131 (16.23%) SQL Server 2016
16 128 (15.86%) C#
17 122 (15.12%) Microsoft Analysis Services
18 112 (13.88%) SQL Server 2012
19 111 (13.75%) .NET
20 108 (13.38%) Microsoft Azure
21 99 (12.27%) Kimball Methodology
22 98 (12.14%) Analytics
22 98 (12.14%) SQL Server 2014
23 95 (11.77%) Migration
24 89 (11.03%) SQL Server 2008
25 87 (10.78%) Data Analysis Expressions (DAX)
26 83 (10.29%) Analytical Skills
27 79 (9.79%) Visualisation
28 73 (9.05%) OLAP
29 72 (8.92%) Data Analysis

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 60 (7.43%) SharePoint
2 20 (2.48%) SAS
3 16 (1.98%) IIS
4 9 (1.12%) SharePoint Server
5 7 (0.87%) Apache Spark
6 6 (0.74%) Apache
6 6 (0.74%) SharePoint 2013
7 5 (0.62%) SharePoint 2010
8 4 (0.50%) WordPress
9 3 (0.37%) Apache Pig
9 3 (0.37%) BizTalk Server
9 3 (0.37%) Tomcat
9 3 (0.37%) WebSphere
10 1 (0.12%) Confluence
10 1 (0.12%) Elasticsearch
10 1 (0.12%) JBoss
10 1 (0.12%) Mongoose
10 1 (0.12%) Skype for Business
10 1 (0.12%) WebLogic
Applications
1 56 (6.94%) Microsoft Excel
2 38 (4.71%) MS Visio
3 10 (1.24%) Microsoft Office
3 10 (1.24%) Spreadsheet
4 8 (0.99%) Microsoft Project
4 8 (0.99%) SPSS
5 2 (0.25%) Microsoft PowerPoint
6 1 (0.12%) InfoPath
Business Applications
1 18 (2.23%) Dynamics AX
2 14 (1.73%) Dynamics CRM
3 8 (0.99%) NetSuite
4 3 (0.37%) Actimize
4 3 (0.37%) Unit4 Business World
5 2 (0.25%) Dynamics NAV
5 2 (0.25%) Endur
5 2 (0.25%) Infor M3
5 2 (0.25%) Markit EDM
5 2 (0.25%) thinkFolio
6 1 (0.12%) Cognos TM1
6 1 (0.12%) MetaTrader
6 1 (0.12%) Remedy ITSM
6 1 (0.12%) Salesforce.com CRM
6 1 (0.12%) Summit
Cloud Services
1 108 (13.38%) Microsoft Azure
2 21 (2.60%) Azure Data Factory
3 11 (1.36%) Dynamics 365
4 10 (1.24%) Data Lake Analytics
5 6 (0.74%) PaaS
6 5 (0.62%) Azure Machine Learning
6 5 (0.62%) Cortana Intelligence Suite
6 5 (0.62%) IaaS
6 5 (0.62%) Office 365
6 5 (0.62%) SaaS
7 4 (0.50%) Amazon AWS
8 3 (0.37%) Adobe Analytics
8 3 (0.37%) Cloud Computing
8 3 (0.37%) GitHub
9 2 (0.25%) iPaaS
10 1 (0.12%) AWS CloudFormation
10 1 (0.12%) Google Cloud Platform
Communications & Networking
1 6 (0.74%) SAN
2 5 (0.62%) SMS
2 5 (0.62%) WinSCP
3 4 (0.50%) Intranet
4 1 (0.12%) FTP
4 1 (0.12%) Internet
4 1 (0.12%) Skype
4 1 (0.12%) TCP/IP
Database & Business Intelligence
1 695 (86.12%) SQL Server Integration Services
2 626 (77.57%) SQL Server Reporting Services
3 606 (75.09%) SQL Server
4 366 (45.35%) Data Warehouse
5 264 (32.71%) Power BI
6 131 (16.23%) SQL Server 2016
7 122 (15.12%) Microsoft Analysis Services
8 112 (13.88%) SQL Server 2012
9 98 (12.14%) SQL Server 2014
10 89 (11.03%) SQL Server 2008
11 73 (9.05%) OLAP
12 53 (6.57%) QlikView
13 32 (3.97%) BusinessObjects
13 32 (3.97%) Relational Database
14 31 (3.84%) Big Data
14 31 (3.84%) Enterprise Data Warehouse
15 30 (3.72%) Data Lake
16 28 (3.47%) PowerPivot
16 28 (3.47%) SQL Server 2005
16 28 (3.47%) Star Schema
Development Applications
1 67 (8.30%) Team Foundation Server
2 59 (7.31%) Visual Studio
3 13 (1.61%) Git (software)
4 12 (1.49%) SQL Server Management Studio (SSMS)
5 11 (1.36%) Jenkins
6 8 (0.99%) Octopus Deploy
7 6 (0.74%) ERwin
7 6 (0.74%) Toad
8 5 (0.62%) JIRA
9 4 (0.50%) MorphX
9 4 (0.50%) Subversion
10 3 (0.37%) Eclipse
10 3 (0.37%) TeamCity
10 3 (0.37%) Visual Studio Team System
11 2 (0.25%) MSBuild
11 2 (0.25%) NUnit
11 2 (0.25%) SpecFlow
12 1 (0.12%) PowerBuilder
12 1 (0.12%) Vagrant
12 1 (0.12%) YouTrack
General
1 198 (24.54%) Finance
2 34 (4.21%) Banking
3 29 (3.59%) Retail
4 22 (2.73%) Marketing
5 20 (2.48%) Legal
6 15 (1.86%) Law
7 7 (0.87%) Advertising
8 6 (0.74%) Front Office
9 5 (0.62%) Manufacturing
10 3 (0.37%) Financial Institution
10 3 (0.37%) Investment Banking
10 3 (0.37%) Publishing
11 2 (0.25%) Telecoms
12 1 (0.12%) Automotive
12 1 (0.12%) Electronics
12 1 (0.12%) French Language
12 1 (0.12%) Games
12 1 (0.12%) General Ledger
12 1 (0.12%) Retail Banking
Job Titles
1 547 (67.78%) Developer
2 303 (37.55%) Business Intelligence Developer
3 198 (24.54%) SQL Developer
4 124 (15.37%) SSAS Developer
5 123 (15.24%) SSIS Developer
6 94 (11.65%) SQL BI Developer
7 89 (11.03%) Analyst
8 81 (10.04%) SSRS Developer
9 64 (7.93%) DBA
10 56 (6.94%) Business Intelligence Analyst
10 56 (6.94%) Consultant
11 53 (6.57%) SQL DBA
12 52 (6.44%) Business Developer
13 50 (6.20%) Power BI Developer
14 46 (5.70%) Architect
14 46 (5.70%) Data Warehouse Developer
15 39 (4.83%) Microsoft Developer
16 36 (4.46%) Microsoft BI Developer
17 33 (4.09%) SQL Server Developer
18 31 (3.84%) ETL Developer
Libraries, Frameworks & Software Standards
1 137 (16.98%) MDX
2 111 (13.75%) .NET
3 29 (3.59%) CSS
4 28 (3.47%) XML
5 26 (3.22%) HTML
6 25 (3.10%) ASP.NET
7 22 (2.73%) Node.js
7 22 (2.73%) Web Services
8 20 (2.48%) .NET Framework
9 19 (2.35%) jQuery
10 13 (1.61%) AngularJS
11 12 (1.49%) WCF
12 11 (1.36%) Entity Framework
13 10 (1.24%) Ajax
14 9 (1.12%) SOAP
14 9 (1.12%) WPF
15 8 (0.99%) REST
16 7 (0.87%) Classic ASP
16 7 (0.87%) React
17 6 (0.74%) ASP.NET Web API
Miscellaneous
1 83 (10.29%) Analytical Skills
2 39 (4.83%) Greenfield Project
3 20 (2.48%) Data Structures
4 16 (1.98%) NHS
5 15 (1.86%) Management Information System
5 15 (1.86%) Replication
6 14 (1.73%) Clustering
6 14 (1.73%) Computer Science
7 10 (1.24%) Market Risk
8 9 (1.12%) Equities
9 6 (0.74%) Credit Risk
9 6 (0.74%) Reinsurance
10 5 (0.62%) FMCG
10 5 (0.62%) Freedom of Information
10 5 (0.62%) Hybrid Cloud
11 4 (0.50%) Blog
11 4 (0.50%) Fixed Income
11 4 (0.50%) Foreign Exchange (FX)
11 4 (0.50%) Hedge funds
11 4 (0.50%) N-Tier
Operating Systems
1 54 (6.69%) Windows
2 19 (2.35%) Windows Server 2012
3 16 (1.98%) Linux
4 15 (1.86%) Windows Server
5 13 (1.61%) Unix
6 11 (1.36%) Windows Server 2008
7 8 (0.99%) Windows Server 2003
8 2 (0.25%) HPUX
8 2 (0.25%) VMS
9 1 (0.12%) Solaris
9 1 (0.12%) Windows 10
9 1 (0.12%) Windows 7
Processes & Methodologies
1 609 (75.46%) Business Intelligence
2 286 (35.44%) ETL
3 149 (18.46%) Data Modelling
4 140 (17.35%) Agile Software Development
5 99 (12.27%) Kimball Methodology
6 98 (12.14%) Analytics
7 95 (11.77%) Migration
8 79 (9.79%) Visualisation
9 72 (8.92%) Data Analysis
10 66 (8.18%) Dimensional Modelling
11 63 (7.81%) ETL Development
12 61 (7.56%) Performance Tuning
13 56 (6.94%) Scrum
14 47 (5.82%) Data Migration
15 37 (4.58%) Data Management
15 37 (4.58%) Data Visualisation
16 33 (4.09%) Dashboard Development
16 33 (4.09%) High Availability
17 25 (3.10%) Unit Testing
17 25 (3.10%) Web Development
Programming Languages
1 628 (77.82%) SQL
2 278 (34.45%) T-SQL
3 128 (15.86%) C#
4 87 (10.78%) Data Analysis Expressions (DAX)
5 42 (5.20%) PowerShell
6 38 (4.71%) Java
7 36 (4.46%) JavaScript
8 30 (3.72%) Python
9 23 (2.85%) PL/SQL
9 23 (2.85%) VB.NET
10 22 (2.73%) R
11 18 (2.23%) VBA
12 16 (1.98%) VB
13 11 (1.36%) C++
14 10 (1.24%) VBScript
15 7 (0.87%) MUMPS
16 6 (0.74%) Shell Script
16 6 (0.74%) U-SQL
17 5 (0.62%) PHP
17 5 (0.62%) XMLA
Qualifications
1 42 (5.20%) Degree
2 22 (2.73%) Microsoft Certification
3 17 (2.11%) Security Cleared
4 14 (1.73%) SC Cleared
5 10 (1.24%) Computer Science Degree
6 7 (0.87%) MCTS
7 6 (0.74%) MCSD
7 6 (0.74%) MCSE
8 4 (0.50%) MCAD
8 4 (0.50%) MCITP
8 4 (0.50%) MCSA
8 4 (0.50%) Numerate Degree
9 3 (0.37%) MCP
10 2 (0.25%) ISEB
10 2 (0.25%) MCDBA
10 2 (0.25%) MCPD
11 1 (0.12%) CFA
11 1 (0.12%) ITIL Certification
11 1 (0.12%) PhD
11 1 (0.12%) PMP
Quality Assurance & Compliance
1 30 (3.72%) QA
2 24 (2.97%) Data Quality
3 8 (0.99%) Solvency II
4 6 (0.74%) GDPR
4 6 (0.74%) ISO/IEC 27001
5 2 (0.25%) PMO
6 1 (0.12%) IFRS
6 1 (0.12%) IFRS 9
6 1 (0.12%) MiFID
6 1 (0.12%) SLA
System Software
1 8 (0.99%) Active Directory
2 6 (0.74%) Virtual Machines
3 3 (0.37%) Hyper-V
4 2 (0.25%) Apache Flume
4 2 (0.25%) VMware ESXi
4 2 (0.25%) VMware Infrastructure
5 1 (0.12%) Docker
5 1 (0.12%) HDFS
5 1 (0.12%) XenApp
Systems Management
1 7 (0.87%) Microsoft Clustering
2 5 (0.62%) Failover Clustering
3 4 (0.50%) Opscode Chef
3 4 (0.50%) WMI
4 2 (0.25%) HP Data Protector
4 2 (0.25%) Puppet
4 2 (0.25%) SCVMM
5 1 (0.12%) Packer
5 1 (0.12%) Systems Management Server (SMS)
5 1 (0.12%) Terraform
5 1 (0.12%) vCenter Server
5 1 (0.12%) WhatsUp Gold
Vendors
1 357 (44.24%) Microsoft
2 71 (8.80%) Tableau
3 70 (8.67%) Oracle
4 25 (3.10%) IBM
5 21 (2.60%) Cognos
6 18 (2.23%) SAP
7 17 (2.11%) Informatica
7 17 (2.11%) RedGate
8 13 (1.61%) JD Edwards
9 9 (1.12%) Netezza
9 9 (1.12%) Sybase
9 9 (1.12%) VMware
10 7 (0.87%) Adobe
11 6 (0.74%) Capita
12 4 (0.50%) Teradata
12 4 (0.50%) Vertica
13 3 (0.37%) Salesforce.com
14 2 (0.25%) Bloomberg
14 2 (0.25%) OpenLink
14 2 (0.25%) Veritas