Period
to 18 April 2021

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 April 2021 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 Apr 2021
Same period 2020 Same period 2019
Rank 395 294 352
Rank change year-on-year -101 +58 -32
Contract jobs citing SQL Server Analysis Services 279 465 709
As % of all contract jobs advertised in the UK 0.53% 0.81% 0.74%
As % of the Database & Business Intelligence category 2.48% 3.83% 3.30%
Number of daily rates quoted 182 350 527
10th Percentile £300 £318 £313
25th Percentile £350 £375 £363
Median daily rate (50th Percentile) £425 £450 £425
Median % change year-on-year -5.56% +5.88% -
75th Percentile £519 £550 £506
90th Percentile £593 £663 £575
UK excluding London median daily rate £400 £400 £400
Number of hourly rates quoted 4 1 7
10th Percentile £26.23 " £20.72
25th Percentile £32.99 " £23.31
Median hourly rate £43.50 £50.00 £41.00
Median % change year-on-year -13.00% +21.95% +86.36%
75th Percentile £50.12 " £42.00
90th Percentile £51.40 " £44.20
UK excluding London median hourly rate - £50.00 £41.50
% change year-on-year - +20.48% +18.57%

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 11,263 12,135 21,510
As % of all contract IT jobs advertised in the UK 21.20% 21.12% 22.43%
Number of daily rates quoted 7,758 8,286 14,948
10th Percentile £320 £321 £320
25th Percentile £405 £400 £391
Median daily rate (50th Percentile) £500 £475 £475
Median % change year-on-year +5.26% - +2.15%
75th Percentile £588 £575 £575
90th Percentile £675 £675 £650
UK excluding London median daily rate £438 £450 £430
% change year-on-year -2.78% +4.65% +4.24%
Number of hourly rates quoted 192 182 238
10th Percentile £13.50 £14.37 £13.91
25th Percentile £19.19 £18.25 £18.03
Median hourly rate £26.00 £24.70 £30.00
Median % change year-on-year +5.26% -17.67% -
75th Percentile £45.00 £44.85 £47.42
90th Percentile £58.68 £57.95 £57.50
UK excluding London median hourly rate £23.47 £22.50 £30.00
% change year-on-year +4.31% -25.00% -14.29%

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 18 April 2021.

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 18 April 2021.

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 18 April 2021. 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 -82 226 £425 -5.56% 136
UK excluding London -8 107 £400 - 100
Work from Home -155 103 £425 - 40
London -118 99 £488 -2.50% 41
North of England +35 34 £400 +3.23% 32
North West +31 26 £400 - 15
Midlands -3 22 £400 +3.23% 24
South East +36 20 £450 +4.35% 22
West Midlands -15 15 £430 +7.50% 19
South West +54 9 £325 -26.76% 4
Scotland -3 9 £375 -21.11% 5
Yorkshire +15 8 £420 +15.86% 16
East of England +24 7 £400 -3.03% 13
East Midlands +16 7 £375 - 5
Wales +18 6 £494 +16.18%

For the 6 months to 18 April 2021, 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 220 (78.85%) SQL Server Integration Services
2 215 (77.06%) SQL
3 188 (67.38%) SQL Server
4 184 (65.95%) Business Intelligence
5 177 (63.44%) SQL Server Reporting Services
6 155 (55.56%) Power BI
6 155 (55.56%) Power Platform
7 147 (52.69%) Data Warehouse
8 144 (51.61%) Azure
9 118 (42.29%) Microsoft
10 99 (35.48%) ETL
11 92 (32.97%) T-SQL
12 79 (28.32%) Azure Data Factory
13 69 (24.73%) Data Modelling
14 67 (24.01%) Microsoft Analysis Services
15 66 (23.66%) Agile Software Development
15 66 (23.66%) Finance
16 51 (18.28%) Data Lake
17 50 (17.92%) Azure SQL Database
18 48 (17.20%) Analytics
19 44 (15.77%) Data Analysis Expressions (DAX)
20 36 (12.90%) Migration
20 36 (12.90%) Databricks
21 32 (11.47%) Visualisation
22 31 (11.11%) PowerShell
23 29 (10.39%) DevOps
24 28 (10.04%) Kimball Methodology
25 26 (9.32%) C#
25 26 (9.32%) Security Cleared
26 25 (8.96%) 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 19 (6.81%) SharePoint
2 4 (1.43%) Apache Spark
3 2 (0.72%) Apache Airflow
3 2 (0.72%) Confluence
3 2 (0.72%) SharePoint Server
4 1 (0.36%) Apache
4 1 (0.36%) Apache Synapse
4 1 (0.36%) IIS
4 1 (0.36%) SharePoint 2010
Applications
1 25 (8.96%) Microsoft Excel
2 10 (3.58%) Microsoft Office
3 1 (0.36%) InfoPath
3 1 (0.36%) Microsoft Project
3 1 (0.36%) MS Visio
3 1 (0.36%) Spreadsheet
Business Applications
1 7 (2.51%) Dynamics CRM
2 2 (0.72%) Dynamics AX
3 1 (0.36%) NetSuite
Cloud Services
1 155 (55.56%) Power Platform
2 144 (51.61%) Azure
3 79 (28.32%) Azure Data Factory
4 14 (5.02%) AWS
5 12 (4.30%) PaaS
6 8 (2.87%) PowerApps
7 6 (2.15%) Dynamics 365
7 6 (2.15%) IaaS
8 5 (1.79%) Boomi
8 5 (1.79%) Logic Apps
9 3 (1.08%) Amazon S3
9 3 (1.08%) Azure Active Directory
9 3 (1.08%) Azure Machine Learning
9 3 (1.08%) Azure Stack
9 3 (1.08%) Data Lake Analytics
9 3 (1.08%) GCP
10 2 (0.72%) Power Automate
10 2 (0.72%) SaaS
11 1 (0.36%) Azure Functions
11 1 (0.36%) ShareGate
Communications & Networking
1 3 (1.08%) SAN
2 2 (0.72%) Kerberos
3 1 (0.36%) Internet
3 1 (0.36%) Intranet
Database & Business Intelligence
1 220 (78.85%) SQL Server Integration Services
2 188 (67.38%) SQL Server
3 177 (63.44%) SQL Server Reporting Services
4 155 (55.56%) Power BI
5 147 (52.69%) Data Warehouse
6 67 (24.01%) Microsoft Analysis Services
7 51 (18.28%) Data Lake
8 50 (17.92%) Azure SQL Database
9 23 (8.24%) Azure SQL Data Warehouse
9 23 (8.24%) Tableau
10 22 (7.89%) Relational Database
11 14 (5.02%) SQL Server 2012
12 13 (4.66%) SQL Server 2016
13 11 (3.94%) Enterprise Data Warehouse
13 11 (3.94%) SQL Server 2017
14 10 (3.58%) SQL Server 2008
14 10 (3.58%) SQL Server 2014
15 9 (3.23%) Biml
15 9 (3.23%) OLAP
16 7 (2.51%) PostgreSQL
Development Applications
1 16 (5.73%) Visual Studio
2 13 (4.66%) SQL Server Management Studio (SSMS)
3 6 (2.15%) JIRA
4 5 (1.79%) Team Foundation Server
5 4 (1.43%) Eclipse
6 2 (0.72%) ER Studio
6 2 (0.72%) ERwin
6 2 (0.72%) Git (software)
6 2 (0.72%) Hudson
6 2 (0.72%) Visual Studio Team System
7 1 (0.36%) Bitbucket
7 1 (0.36%) Serena SBM
7 1 (0.36%) Subversion
7 1 (0.36%) TeamCity
General
1 66 (23.66%) Finance
2 24 (8.60%) Banking
3 10 (3.58%) Public Sector
4 6 (2.15%) Retail
5 5 (1.79%) Front Office
5 5 (1.79%) Investment Banking
6 3 (1.08%) Law
7 2 (0.72%) Digital Economy
8 1 (0.36%) Housing Association
8 1 (0.36%) International Banking
8 1 (0.36%) Local Government
8 1 (0.36%) Pharmaceutical
Job Titles
1 158 (56.63%) Developer
2 92 (32.97%) Business Intelligence Developer
3 45 (16.13%) Data Engineer
4 43 (15.41%) SQL Developer
5 29 (10.39%) Power BI Developer
6 28 (10.04%) Architect
7 20 (7.17%) Azure Engineer
8 16 (5.73%) SQL BI Developer
8 16 (5.73%) SSAS Developer
9 14 (5.02%) Consultant
10 13 (4.66%) Analyst
11 11 (3.94%) Data Architect
11 11 (3.94%) Data Warehouse Developer
11 11 (3.94%) DBA
12 10 (3.58%) Azure Architect
12 10 (3.58%) SQL DBA
12 10 (3.58%) SSIS Developer
13 9 (3.23%) Business Intelligence Consultant
13 9 (3.23%) C# Developer
14 7 (2.51%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 20 (7.17%) MDX
2 16 (5.73%) .NET
3 5 (1.79%) PySpark
4 4 (1.43%) AngularJS
4 4 (1.43%) JSON
4 4 (1.43%) XML
5 3 (1.08%) .NET Framework
5 3 (1.08%) Entity Framework
5 3 (1.08%) HTML
5 3 (1.08%) Lambda Expressions
6 2 (0.72%) ASP.NET
6 2 (0.72%) CSS
6 2 (0.72%) HTML5
6 2 (0.72%) jQuery
6 2 (0.72%) React
6 2 (0.72%) RESTful
6 2 (0.72%) Sass
6 2 (0.72%) Web Services
7 1 (0.36%) Ajax
7 1 (0.36%) YAML
Miscellaneous
1 21 (7.53%) Analytical Skills
2 12 (4.30%) NHS
3 11 (3.94%) Data Structures
4 8 (2.87%) Replication
5 7 (2.51%) User Experience
6 6 (2.15%) Reinsurance
7 5 (1.79%) Credit Derivative
7 5 (1.79%) Greenfield Project
8 4 (1.43%) Clustering
8 4 (1.43%) Credit Risk
8 4 (1.43%) Derivative
8 4 (1.43%) Self-Motivation
8 4 (1.43%) Taxonomies
9 3 (1.08%) Grid Computing
10 2 (0.72%) Enterprise Software
10 2 (0.72%) Management Information System
10 2 (0.72%) Market Risk
10 2 (0.72%) Over-the-Top Content
11 1 (0.36%) Linked Data
11 1 (0.36%) Linux Command Line
Operating Systems
1 19 (6.81%) Windows
2 11 (3.94%) Linux
3 8 (2.87%) Windows Server
4 4 (1.43%) Windows Server 2012
5 3 (1.08%) Windows Server 2008
6 2 (0.72%) Unix
7 1 (0.36%) Windows 10
7 1 (0.36%) Windows 7
7 1 (0.36%) Windows 8
7 1 (0.36%) Windows Mobile
Processes & Methodologies
1 184 (65.95%) Business Intelligence
2 99 (35.48%) ETL
3 69 (24.73%) Data Modelling
4 66 (23.66%) Agile Software Development
5 48 (17.20%) Analytics
6 36 (12.90%) Migration
7 32 (11.47%) Visualisation
8 29 (10.39%) DevOps
9 28 (10.04%) Kimball Methodology
10 24 (8.60%) Performance Tuning
11 22 (7.89%) Data Migration
12 17 (6.09%) Scrum
13 16 (5.73%) Data Analysis
14 15 (5.38%) Data Development
15 14 (5.02%) Continuous Deployment
15 14 (5.02%) Continuous Integration
15 14 (5.02%) Data Engineering
16 13 (4.66%) Requirements Gathering
16 13 (4.66%) SDLC
16 13 (4.66%) Test Automation
Programming Languages
1 215 (77.06%) SQL
2 92 (32.97%) T-SQL
3 44 (15.77%) Data Analysis Expressions (DAX)
4 31 (11.11%) PowerShell
5 26 (9.32%) C#
6 17 (6.09%) Python
7 6 (2.15%) JavaScript
8 5 (1.79%) Java
9 3 (1.08%) R
10 2 (0.72%) C
10 2 (0.72%) VB
10 2 (0.72%) XPath
10 2 (0.72%) XQuery
11 1 (0.36%) Bash Shell
11 1 (0.36%) Go
11 1 (0.36%) Perl
11 1 (0.36%) PL/SQL
11 1 (0.36%) Ruby
11 1 (0.36%) Shell Script
11 1 (0.36%) VB.NET
Qualifications
1 26 (9.32%) Security Cleared
2 11 (3.94%) SC Cleared
3 10 (3.58%) Degree
4 4 (1.43%) Computer Science Degree
4 4 (1.43%) DV Cleared
5 3 (1.08%) Microsoft Certification
6 1 (0.36%) ISEB
6 1 (0.36%) MBCS
Quality Assurance & Compliance
1 15 (5.38%) Data Quality
2 9 (3.23%) QA
3 2 (0.72%) Dodd-Frank
3 2 (0.72%) GDPR
3 2 (0.72%) SLA
System Software
1 4 (1.43%) Active Directory
1 4 (1.43%) ISA Server
2 2 (0.72%) Virtual Machines
3 1 (0.36%) Docker
3 1 (0.36%) LXC
3 1 (0.36%) Oracle RAC
3 1 (0.36%) VMware ESXi
3 1 (0.36%) VMware Infrastructure
Systems Management
1 4 (1.43%) Microsoft Clustering
2 2 (0.72%) Control-M
2 2 (0.72%) Failover Clustering
2 2 (0.72%) Puppet
3 1 (0.36%) Ansible
3 1 (0.36%) Data Guard
3 1 (0.36%) EMC NetWorker
3 1 (0.36%) Enterprise Manager Cloud Control
3 1 (0.36%) Kubernetes
3 1 (0.36%) Opscode Chef
3 1 (0.36%) QRadar
3 1 (0.36%) Tivoli
3 1 (0.36%) Tivoli Storage Manager
Vendors
1 118 (42.29%) Microsoft
2 36 (12.90%) Databricks
3 6 (2.15%) Oracle
4 5 (1.79%) Dell
5 4 (1.43%) Informatica
5 4 (1.43%) Teradata
6 3 (1.08%) NetApp
7 2 (0.72%) Alteryx
7 2 (0.72%) Mapinfo
7 2 (0.72%) SAP
7 2 (0.72%) Twitter
8 1 (0.36%) ABBYY
8 1 (0.36%) CyberArk
8 1 (0.36%) IBM
8 1 (0.36%) JD Edwards
8 1 (0.36%) Serena
8 1 (0.36%) ServiceNow
8 1 (0.36%) Splunk
8 1 (0.36%) Sybase
8 1 (0.36%) VMware