Period
to 31 May 2020

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 31 May 2020 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
31 May 2020
Same period 2019 Same period 2018
Rank 292 334 343
Rank change year-on-year +42 +9 -59
Contract jobs citing SQL Server Analysis Services 375 698 748
As % of all contract jobs advertised in the UK 0.81% 0.76% 0.74%
As % of the Database & Business Intelligence category 3.81% 3.41% 3.29%
Number of daily rates quoted 270 516 599
Median daily rate £450 £430 £438
Median daily rate % change year-on-year +4.65% -1.71% +9.38%
10th Percentile £317 £313 £313
90th Percentile £614 £591 £575
UK excluding London median daily rate £416 £400 £388
% change year-on-year +4.06% +3.23% +6.16%
Number of hourly rates quoted 2 3 5
Median hourly rate £42.50 £22.36 £22.50
Median hourly rate % change year-on-year +90.07% -0.62% -40.00%
10th Percentile £36.50 £19.07 £21.00
90th Percentile £48.50 £32.47 £39.50
UK excluding London median hourly rate £42.50 £22.36 £31.25
% change year-on-year +90.07% -28.45% -16.67%

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 9,844 20,458 22,770
As % of all contract IT jobs advertised in the UK 21.19% 22.38% 22.50%
Number of daily rates quoted 6,433 13,988 15,855
Median daily rate £490 £475 £475
Median daily rate % change year-on-year +3.16% - +8.57%
10th Percentile £325 £325 £313
90th Percentile £675 £650 £625
UK excluding London median daily rate £450 £430 £415
% change year-on-year +4.65% +3.65% +5.03%
Number of hourly rates quoted 198 251 238
Median hourly rate £35.00 £35.00 £34.25
Median hourly rate % change year-on-year - +2.19% +14.52%
10th Percentile £15.98 £14.08 £14.00
90th Percentile £53.00 £57.50 £53.58
Median hourly rate £35.00 £32.50 £35.00
% change year-on-year +7.69% -7.14% +20.69%

SQL Server Analysis Services
Job Vacancy Trend

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

Job vacancy trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Daily Rate Trend

3-month moving average daily rate quoted in jobs citing SQL Server Analysis Services.

Daily rate trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Daily Rate Histogram

Daily rate distribution for jobs citing SQL Server Analysis Services over the 6 months to 31 May 2020.

Daily rate histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Hourly Rate Trend

3-month moving average hourly rates quoted in jobs citing SQL Server Analysis Services.

Hourly rate trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Hourly Rate Histogram

Hourly rate distribution of jobs citing SQL Server Analysis Services over the 6 months to 31 May 2020.

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 31 May 2020. 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 +47 357 £450 +1.81% 61
London +70 214 £488 +2.63% 11
UK excluding London +32 160 £416 +4.06% 54
North of England +31 46 £358 -7.74% 8
Midlands +69 39 £425 +13.33% 20
West Midlands +71 35 £435 +10.48% 17
South East +111 33 £425 +3.03% 5
North West +27 26 £400 +5.26% 7
Yorkshire +32 17 £365 -8.75%
East of England +52 13 £431 +1.47% 10
South West +41 12 £438 -2.78% 7
Scotland +39 12 £488 +21.88% 1
Work from Home +12 7 £325 -31.58% 5
Wales +25 5 £425 +11.48% 3
East Midlands +18 4 £325 -3.70% 3
North East +22 3 £325 +1.96% 1

For the 6 months to 31 May 2020, 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 289 (77.07%) SQL Server
2 285 (76.00%) SQL Server Integration Services
3 264 (70.40%) Business Intelligence
4 256 (68.27%) SQL
5 222 (59.20%) SQL Server Reporting Services
6 170 (45.33%) Data Warehouse
7 168 (44.80%) Power Platform
8 166 (44.27%) Azure
9 165 (44.00%) Power BI
10 156 (41.60%) Microsoft
11 139 (37.07%) T-SQL
12 126 (33.60%) ETL
13 121 (32.27%) Agile Software Development
14 109 (29.07%) Finance
15 104 (27.73%) Microsoft Analysis Services
16 94 (25.07%) C#
17 79 (21.07%) .NET
18 56 (14.93%) Data Modelling
19 54 (14.40%) DevOps
20 52 (13.87%) JavaScript
21 50 (13.33%) Scrum
21 50 (13.33%) Kimball Methodology
21 50 (13.33%) Data Analysis Expressions (DAX)
21 50 (13.33%) Azure Data Factory
22 48 (12.80%) ASP.NET
23 47 (12.53%) Analytical Skills
24 46 (12.27%) Analytics
24 46 (12.27%) AWS
24 46 (12.27%) MongoDB
25 45 (12.00%) Azure SQL Database

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 10 (2.67%) IIS
1 10 (2.67%) SharePoint
2 8 (2.13%) Apache Spark
3 5 (1.33%) DataSynapse
4 3 (0.80%) Apache
4 3 (0.80%) Apache Airflow
4 3 (0.80%) SharePoint 2010
5 1 (0.27%) ArcGIS
5 1 (0.27%) Oracle SOA Suite
5 1 (0.27%) SAS
5 1 (0.27%) Skype for Business
Applications
1 35 (9.33%) Microsoft Excel
2 2 (0.53%) Microsoft Office
3 1 (0.27%) InfoPath
3 1 (0.27%) MS Visio
Business Applications
1 7 (1.87%) Dynamics AX
2 5 (1.33%) Dynamics CRM
3 4 (1.07%) thinkFolio
4 2 (0.53%) NetSuite
5 1 (0.27%) Dynamics NAV
Cloud Services
1 168 (44.80%) Power Platform
2 166 (44.27%) Azure
3 50 (13.33%) Azure Data Factory
4 46 (12.27%) AWS
5 12 (3.20%) Dynamics 365
5 12 (3.20%) PowerApps
6 9 (2.40%) Serverless
7 8 (2.13%) Azure Functions
7 8 (2.13%) Logic Apps
7 8 (2.13%) PaaS
8 7 (1.87%) GitHub
9 3 (0.80%) GCP
9 3 (0.80%) Office 365
9 3 (0.80%) SaaS
10 2 (0.53%) IaaS
11 1 (0.27%) Amazon EC2
11 1 (0.27%) Amazon EMR
11 1 (0.27%) AWS Lambda
11 1 (0.27%) NuGet
11 1 (0.27%) OpenShift
Communications & Networking
1 4 (1.07%) SMS
2 3 (0.80%) Internet
3 2 (0.53%) SAN
4 1 (0.27%) FTP
Database & Business Intelligence
1 289 (77.07%) SQL Server
2 285 (76.00%) SQL Server Integration Services
3 222 (59.20%) SQL Server Reporting Services
4 170 (45.33%) Data Warehouse
5 165 (44.00%) Power BI
6 104 (27.73%) Microsoft Analysis Services
7 46 (12.27%) MongoDB
8 45 (12.00%) Azure SQL Database
9 41 (10.93%) Data Lake
10 38 (10.13%) MySQL
11 32 (8.53%) Azure SQL Data Warehouse
11 32 (8.53%) SQL Server 2016
12 29 (7.73%) Redis
13 26 (6.93%) SQL Server 2014
14 24 (6.40%) OLAP
15 19 (5.07%) SQL Server 2008
16 18 (4.80%) NoSQL
16 18 (4.80%) Relational Database
16 18 (4.80%) SQL Server 2017
17 17 (4.53%) SQL Server 2012
Development Applications
1 32 (8.53%) TeamCity
2 26 (6.93%) MSBuild
2 26 (6.93%) Octopus Deploy
2 26 (6.93%) Team Foundation Server
2 26 (6.93%) Visual Studio
3 18 (4.80%) Git (software)
4 14 (3.73%) Visual Studio Team System
5 13 (3.47%) SQL Server Management Studio (SSMS)
6 7 (1.87%) Subversion
7 4 (1.07%) Eclipse
7 4 (1.07%) tSQLt
8 3 (0.80%) JIRA
9 2 (0.53%) Redmine
10 1 (0.27%) GitLab
10 1 (0.27%) Jenkins
10 1 (0.27%) Maven
10 1 (0.27%) Selenium
10 1 (0.27%) Toad
10 1 (0.27%) webpack
10 1 (0.27%) WiX
General
1 109 (29.07%) Finance
2 30 (8.00%) Front Office
3 25 (6.67%) Retail
4 17 (4.53%) Banking
4 17 (4.53%) Public Sector
5 6 (1.60%) Investment Banking
5 6 (1.60%) Legal
6 3 (0.80%) Law
6 3 (0.80%) Local Government
6 3 (0.80%) Marketing
7 2 (0.53%) Billing
7 2 (0.53%) Housing Association
7 2 (0.53%) Multimedia
7 2 (0.53%) Telecoms
8 1 (0.27%) Electronics
8 1 (0.27%) French Language
8 1 (0.27%) German Language
8 1 (0.27%) Manufacturing
Job Titles
1 232 (61.87%) Developer
2 120 (32.00%) Business Intelligence Developer
3 70 (18.67%) SQL Developer
4 37 (9.87%) .NET Developer
4 37 (9.87%) Power BI Developer
5 31 (8.27%) SQL BI Developer
6 29 (7.73%) Data Engineer
7 26 (6.93%) Analyst
8 24 (6.40%) Data Warehouse Developer
9 23 (6.13%) Architect
9 23 (6.13%) Azure Engineer
9 23 (6.13%) DBA
10 22 (5.87%) SQL Server Developer
11 21 (5.60%) Senior Developer
12 19 (5.07%) ETL Developer
12 19 (5.07%) SSIS Developer
13 17 (4.53%) Consultant
14 15 (4.00%) Business Intelligence Architect
15 14 (3.73%) SQL DBA
16 13 (3.47%) Angular Developer
Libraries, Frameworks & Software Standards
1 79 (21.07%) .NET
2 48 (12.80%) ASP.NET
3 43 (11.47%) Web Services
4 39 (10.40%) AngularJS
5 33 (8.80%) .NET Core
6 31 (8.27%) React
7 26 (6.93%) MDX
8 22 (5.87%) XML
9 12 (3.20%) HTML
10 11 (2.93%) CSS
11 10 (2.67%) .NET Framework
11 10 (2.67%) JSON
12 9 (2.40%) jQuery
13 7 (1.87%) HTML5
13 7 (1.87%) Node.js
14 5 (1.33%) ADO.NET
14 5 (1.33%) Entity Framework
14 5 (1.33%) SOAP
14 5 (1.33%) WPF
15 4 (1.07%) D3.js
Miscellaneous
1 47 (12.53%) Analytical Skills
2 11 (2.93%) Greenfield Project
2 11 (2.93%) NHS
3 8 (2.13%) Grid Computing
4 7 (1.87%) Replication
5 6 (1.60%) FMCG
5 6 (1.60%) Hedge funds
6 5 (1.33%) Clustering
6 5 (1.33%) Credit Risk
7 4 (1.07%) Analytical Mindset
7 4 (1.07%) Fixed Income
8 3 (0.80%) Fat Client
8 3 (0.80%) Management Information System
8 3 (0.80%) Self-Motivation
8 3 (0.80%) Thin Client
9 2 (0.53%) Data Structures
9 2 (0.53%) Foreign Exchange (FX)
9 2 (0.53%) Reference Data
9 2 (0.53%) User Experience
10 1 (0.27%) Algorithms
Operating Systems
1 26 (6.93%) Windows
2 14 (3.73%) Linux
3 12 (3.20%) Unix
4 10 (2.67%) Windows Server
5 3 (0.80%) Red Hat Enterprise Linux
5 3 (0.80%) Windows Server 2008
5 3 (0.80%) Windows Server 2016
6 2 (0.53%) HPUX
7 1 (0.27%) AIX
7 1 (0.27%) Android
7 1 (0.27%) CentOS
7 1 (0.27%) Solaris
7 1 (0.27%) Windows Mobile
Processes & Methodologies
1 264 (70.40%) Business Intelligence
2 126 (33.60%) ETL
3 121 (32.27%) Agile Software Development
4 56 (14.93%) Data Modelling
5 54 (14.40%) DevOps
6 50 (13.33%) Kimball Methodology
6 50 (13.33%) Scrum
7 46 (12.27%) Analytics
8 42 (11.20%) Microservices
9 40 (10.67%) Machine Learning
10 39 (10.40%) Visualisation
11 35 (9.33%) Migration
12 31 (8.27%) Artificial Intelligence
12 31 (8.27%) Software Engineering
13 30 (8.00%) Data Visualisation
13 30 (8.00%) Fund Management
14 29 (7.73%) CQRS
14 29 (7.73%) Data Management
14 29 (7.73%) Deep Learning
15 27 (7.20%) Performance Tuning
Programming Languages
1 256 (68.27%) SQL
2 139 (37.07%) T-SQL
3 94 (25.07%) C#
4 52 (13.87%) JavaScript
5 50 (13.33%) Data Analysis Expressions (DAX)
6 43 (11.47%) Python
7 34 (9.07%) PowerShell
8 29 (7.73%) F#
9 21 (5.60%) Java
10 15 (4.00%) R
11 11 (2.93%) VB.NET
12 10 (2.67%) PL/SQL
12 10 (2.67%) VB
13 9 (2.40%) Scala
14 6 (1.60%) Bash Shell
14 6 (1.60%) Shell Script
15 5 (1.33%) Korn
15 5 (1.33%) Perl
15 5 (1.33%) VBA
15 5 (1.33%) XAML
Qualifications
1 11 (2.93%) Degree
1 11 (2.93%) Security Cleared
2 6 (1.60%) SC Cleared
3 3 (0.80%) Computer Science Degree
3 3 (0.80%) Master's Degree
3 3 (0.80%) MCITP
3 3 (0.80%) Microsoft Certification
4 1 (0.27%) CITP
4 1 (0.27%) ISEB
4 1 (0.27%) ITIL Certification
4 1 (0.27%) TOGAF Certification
Quality Assurance & Compliance
1 10 (2.67%) Data Quality
2 9 (2.40%) QA
3 8 (2.13%) SLA
4 2 (0.53%) GDPR
5 1 (0.27%) ISO/IEC 20000
5 1 (0.27%) PMO
System Software
1 11 (2.93%) Virtual Machines
2 8 (2.13%) Active Directory
3 6 (1.60%) VMware Infrastructure
4 3 (0.80%) vSphere
5 2 (0.53%) Hyper-V
6 1 (0.27%) Citrix Hypervisor
6 1 (0.27%) Docker
Systems Management
1 6 (1.60%) Puppet
2 4 (1.07%) Microsoft Clustering
3 3 (0.80%) Tivoli
3 3 (0.80%) Tivoli Storage Manager
3 3 (0.80%) vRealize
4 1 (0.27%) Ansible
4 1 (0.27%) Data Guard
4 1 (0.27%) Kubernetes
4 1 (0.27%) Microsoft Data Protection Manager
4 1 (0.27%) Opscode Chef
4 1 (0.27%) Oracle RMAN
4 1 (0.27%) SCOM
4 1 (0.27%) SCOrch
4 1 (0.27%) Terraform
Vendors
1 156 (41.60%) Microsoft
2 37 (9.87%) Oracle
3 28 (7.47%) Databricks
4 27 (7.20%) Tableau
5 12 (3.20%) Sybase
6 8 (2.13%) SAP
6 8 (2.13%) VMware
7 6 (1.60%) Teradata
8 5 (1.33%) AppDynamics
8 5 (1.33%) Red Hat
8 5 (1.33%) Splunk
8 5 (1.33%) TIBCO
9 4 (1.07%) EMC
9 4 (1.07%) jBASE
9 4 (1.07%) Marketo
9 4 (1.07%) Salesforce.com
9 4 (1.07%) ServiceNow
10 3 (0.80%) Google
10 3 (0.80%) IBM
10 3 (0.80%) Telerik