Period
to 25 July 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 25 July 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
25 Jul 2021
Same period 2020 Same period 2019
Rank 405 337 332
Rank change year-on-year -68 -5 +30
Contract jobs citing SQL Server Analysis Services 385 251 726
As % of all contract jobs advertised in the UK 0.54% 0.67% 0.79%
As % of the Database & Business Intelligence category 2.55% 3.03% 3.49%
Number of daily rates quoted 237 197 529
10th Percentile £313 £350 £313
25th Percentile £410 £400 £363
Median daily rate (50th Percentile) £500 £450 £450
Median % change year-on-year +11.11% - +2.86%
75th Percentile £590 £550 £525
90th Percentile £680 £600 £628
UK excluding London median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% -
Number of hourly rates quoted 4 1 5
10th Percentile £26.23 " £19.89
25th Percentile £32.99 " £22.36
Median hourly rate £46.43 £50.00 £24.08
Median % change year-on-year -7.15% +107.64% +9.45%
75th Percentile £58.63 " £24.66
90th Percentile £70.12 " £25.14
UK excluding London median hourly rate - £50.00 £20.93
% change year-on-year - +138.89% -6.98%

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 15,072 8,278 20,804
As % of all contract IT jobs advertised in the UK 21.30% 22.06% 22.65%
Number of daily rates quoted 10,344 5,730 14,380
10th Percentile £338 £325 £325
25th Percentile £413 £406 £400
Median daily rate (50th Percentile) £500 £500 £475
Median % change year-on-year - +5.26% +2.70%
75th Percentile £611 £600 £575
90th Percentile £700 £688 £650
UK excluding London median daily rate £450 £450 £433
% change year-on-year - +3.93% +4.40%
Number of hourly rates quoted 217 114 257
10th Percentile £11.71 £12.63 £13.45
25th Percentile £19.00 £17.77 £17.63
Median hourly rate £27.00 £22.50 £30.00
Median % change year-on-year +20.00% -25.00% -
75th Percentile £45.18 £43.12 £50.00
90th Percentile £62.00 £63.79 £60.00
UK excluding London median hourly rate £26.00 £21.57 £30.00
% change year-on-year +20.54% -28.10% +4.35%

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 25 July 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 25 July 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 25 July 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 -79 295 £500 +11.11% 142
Work from Home -127 152 £500 +12.36% 26
London -130 146 £511 +4.34% 51
UK excluding London -58 117 £450 +5.88% 97
South East -20 36 £525 +17.65% 17
North of England -30 29 £445 +6.27% 31
Midlands -39 24 £430 +1.18% 23
North West -27 19 £463 +8.82% 20
West Midlands -37 18 £460 +8.24% 15
East of England -11 13 £406 -7.14% 12
Yorkshire -22 10 £423 +10.46% 7
Scotland -56 8 £360 -28.05% 7
East Midlands -9 6 £325 - 8
South West -10 5 £388 -11.43% 7
Wales -9 2 - -

For the 6 months to 25 July 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 297 (77.14%) SQL
2 278 (72.21%) Business Intelligence
3 256 (66.49%) SQL Server Integration Services
4 251 (65.19%) SQL Server
5 241 (62.60%) SQL Server Reporting Services
6 228 (59.22%) Power BI
6 228 (59.22%) Power Platform
7 222 (57.66%) Azure
8 202 (52.47%) Data Warehouse
9 175 (45.45%) Microsoft
10 138 (35.84%) ETL
11 126 (32.73%) Azure Data Factory
12 122 (31.69%) Data Modelling
13 121 (31.43%) Agile Software Development
14 118 (30.65%) Analytics
15 110 (28.57%) Microsoft Analysis Services
16 102 (26.49%) T-SQL
17 95 (24.68%) Databricks
18 88 (22.86%) Data Lake
19 81 (21.04%) DevOps
20 74 (19.22%) Finance
21 67 (17.40%) Data Analysis Expressions (DAX)
22 65 (16.88%) Social Skills
23 57 (14.81%) Azure Synapse Analytics
24 56 (14.55%) Python
25 54 (14.03%) Azure SQL Database
26 51 (13.25%) Tableau
26 51 (13.25%) Analytical Skills
27 49 (12.73%) Visualisation
28 44 (11.43%) C#

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 26 (6.75%) SharePoint
2 14 (3.64%) Apache Spark
3 5 (1.30%) Confluence
4 4 (1.04%) IIS
4 4 (1.04%) SAS
5 2 (0.52%) Apache Airflow
6 1 (0.26%) Elasticsearch
6 1 (0.26%) SharePoint Server
Applications
1 29 (7.53%) Microsoft Excel
2 4 (1.04%) Microsoft Office
3 2 (0.52%) Microsoft PowerPoint
3 2 (0.52%) MS Visio
4 1 (0.26%) Microsoft Project
4 1 (0.26%) Mingle
Business Applications
1 3 (0.78%) NetSuite
2 2 (0.52%) Dynamics AX
3 1 (0.26%) Endur
Cloud Services
1 228 (59.22%) Power Platform
2 222 (57.66%) Azure
3 126 (32.73%) Azure Data Factory
4 57 (14.81%) Azure Synapse Analytics
5 26 (6.75%) AWS
6 25 (6.49%) Azure Key Vault
6 25 (6.49%) Azure Stack
7 19 (4.94%) PaaS
8 16 (4.16%) GCP
8 16 (4.16%) PowerApps
9 12 (3.12%) Azure Cosmos DB
10 11 (2.86%) Azure Storage
11 10 (2.60%) Serverless
12 9 (2.34%) Azure Active Directory
12 9 (2.34%) Azure Functions
12 9 (2.34%) GitHub
13 8 (2.08%) Azure Data Lake Analytics
13 8 (2.08%) Snowflake
14 7 (1.82%) Azure Logic Apps
14 7 (1.82%) Boomi
Communications & Networking
1 1 (0.26%) Cisco ASA
1 1 (0.26%) Firewall
1 1 (0.26%) Kerberos
Database & Business Intelligence
1 256 (66.49%) SQL Server Integration Services
2 251 (65.19%) SQL Server
3 241 (62.60%) SQL Server Reporting Services
4 228 (59.22%) Power BI
5 202 (52.47%) Data Warehouse
6 110 (28.57%) Microsoft Analysis Services
7 88 (22.86%) Data Lake
8 54 (14.03%) Azure SQL Database
9 51 (13.25%) Tableau
10 35 (9.09%) OLAP
11 28 (7.27%) Azure SQL Data Warehouse
12 26 (6.75%) OLTP
13 25 (6.49%) Relational Database
14 23 (5.97%) Big Data
15 20 (5.19%) Metadata
16 16 (4.16%) BusinessObjects
16 16 (4.16%) Enterprise Data Warehouse
17 15 (3.90%) NoSQL
17 15 (3.90%) QlikView
18 14 (3.64%) Snowflake Schema
Development Applications
1 38 (9.87%) Visual Studio
2 23 (5.97%) SQL Server Management Studio (SSMS)
3 18 (4.68%) Git (software)
4 12 (3.12%) JIRA
5 11 (2.86%) Team Foundation Server
6 7 (1.82%) Visual Studio Team System
7 5 (1.30%) Eclipse
8 2 (0.52%) ERwin
8 2 (0.52%) git-flow
9 1 (0.26%) Bitbucket
9 1 (0.26%) Cucumber
9 1 (0.26%) Fiddler
9 1 (0.26%) FitNesse
9 1 (0.26%) Jenkins
9 1 (0.26%) LINQPad
9 1 (0.26%) Octopus Deploy
9 1 (0.26%) Selenium
9 1 (0.26%) SpecFlow
9 1 (0.26%) Subversion
9 1 (0.26%) TeamCity
General
1 74 (19.22%) Finance
2 65 (16.88%) Social Skills
3 51 (13.25%) Analytical Skills
4 23 (5.97%) Banking
5 12 (3.12%) Public Sector
6 9 (2.34%) Documentation Skills
7 8 (2.08%) Retail
8 7 (1.82%) Investment Banking
9 5 (1.30%) Front Office
9 5 (1.30%) Presentation Skills
10 4 (1.04%) Back Office
11 3 (0.78%) French Language
11 3 (0.78%) Organisational Skills
12 2 (0.52%) Law
12 2 (0.52%) Retail Banking
13 1 (0.26%) Automotive
13 1 (0.26%) International Banking
13 1 (0.26%) Legal
13 1 (0.26%) Marketing
13 1 (0.26%) Private Banking
Job Titles
1 200 (51.95%) Developer
2 116 (30.13%) Business Intelligence Developer
3 51 (13.25%) Data Engineer
4 50 (12.99%) Architect
5 47 (12.21%) SQL Developer
6 41 (10.65%) Power BI Developer
7 27 (7.01%) Data Architect
8 25 (6.49%) Analyst
8 25 (6.49%) SSAS Developer
9 24 (6.23%) Azure Architect
9 24 (6.23%) Azure Engineer
10 21 (5.45%) SQL BI Developer
11 20 (5.19%) Data Warehouse Developer
12 17 (4.42%) Azure Developer
13 16 (4.16%) Consultant
13 16 (4.16%) SSIS Developer
14 15 (3.90%) SSRS Developer
15 14 (3.64%) Business Intelligence Analyst
15 14 (3.64%) Business Intelligence Consultant
16 13 (3.38%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 33 (8.57%) MDX
2 31 (8.05%) .NET
3 15 (3.90%) AngularJS
4 14 (3.64%) ASP.NET
4 14 (3.64%) HTML
5 13 (3.38%) HTML5
6 10 (2.60%) .NET Framework
7 9 (2.34%) Entity Framework
7 9 (2.34%) PySpark
8 8 (2.08%) ASP.NET Core
8 8 (2.08%) Blazor
8 8 (2.08%) JSON
8 8 (2.08%) OpenFin
8 8 (2.08%) Razor View Engine
8 8 (2.08%) XML
9 6 (1.56%) CSS
9 6 (1.56%) CSS3
9 6 (1.56%) React
9 6 (1.56%) Web Services
10 5 (1.30%) RESTful
Miscellaneous
1 29 (7.53%) Data Structures
2 12 (3.12%) NHS
3 10 (2.60%) Reinsurance
4 9 (2.34%) Algorithms
4 9 (2.34%) Greenfield Project
5 5 (1.30%) Credit Derivative
5 5 (1.30%) Fixed Income
5 5 (1.30%) Management Information System
5 5 (1.30%) Replication
5 5 (1.30%) Self-Motivation
5 5 (1.30%) User Experience
6 4 (1.04%) Taxonomies
7 3 (0.78%) Clustering
7 3 (0.78%) Derivative
7 3 (0.78%) Grid Computing
8 2 (0.52%) Credit Risk
8 2 (0.52%) Data Protection Act
9 1 (0.26%) Blog
9 1 (0.26%) Data Centre
9 1 (0.26%) Enterprise Software
Operating Systems
1 14 (3.64%) Linux
2 13 (3.38%) Unix
3 12 (3.12%) Windows
4 5 (1.30%) Windows Server
5 1 (0.26%) Windows Mobile
Processes & Methodologies
1 278 (72.21%) Business Intelligence
2 138 (35.84%) ETL
3 122 (31.69%) Data Modelling
4 121 (31.43%) Agile Software Development
5 118 (30.65%) Analytics
6 81 (21.04%) DevOps
7 49 (12.73%) Visualisation
8 43 (11.17%) Kimball Methodology
9 39 (10.13%) Migration
10 36 (9.35%) Performance Tuning
11 35 (9.09%) Scrum
12 28 (7.27%) Data Analysis
13 26 (6.75%) Use Case
14 25 (6.49%) Data Migration
14 25 (6.49%) Problem-Solving
15 24 (6.23%) Data Engineering
16 23 (5.97%) Data Pipeline
16 23 (5.97%) Data Visualisation
16 23 (5.97%) Decision-Making
16 23 (5.97%) SDLC
Programming Languages
1 297 (77.14%) SQL
2 102 (26.49%) T-SQL
3 67 (17.40%) Data Analysis Expressions (DAX)
4 56 (14.55%) Python
5 44 (11.43%) C#
6 31 (8.05%) PowerShell
7 19 (4.94%) Java
8 13 (3.38%) R
9 11 (2.86%) Scala
10 8 (2.08%) TypeScript
11 7 (1.82%) JavaScript
12 4 (1.04%) Shell Script
12 4 (1.04%) VB
13 3 (0.78%) VBA
14 2 (0.52%) PL/SQL
15 1 (0.26%) Bash Shell
15 1 (0.26%) C
15 1 (0.26%) Perl
15 1 (0.26%) Ruby
15 1 (0.26%) VB.NET
Qualifications
1 31 (8.05%) Security Cleared
2 18 (4.68%) SC Cleared
3 5 (1.30%) DV Cleared
4 3 (0.78%) BPSS Clearance
4 3 (0.78%) Microsoft Certification
5 2 (0.52%) ISTQB
6 1 (0.26%) Degree
Quality Assurance & Compliance
1 20 (5.19%) Data Quality
2 8 (2.08%) QA
3 2 (0.52%) Accessibility
3 2 (0.52%) PCI DSS
4 1 (0.26%) Sarbanes-Oxley
4 1 (0.26%) Solvency II
System Software
1 11 (2.86%) Active Directory
2 4 (1.04%) ISA Server
3 1 (0.26%) Docker
3 1 (0.26%) Oracle RAC
3 1 (0.26%) VMware ESXi
3 1 (0.26%) VMware Infrastructure
Systems Management
1 3 (0.78%) Kubernetes
2 2 (0.52%) Terraform
3 1 (0.26%) Active Directory Federation Services
3 1 (0.26%) Ansible
3 1 (0.26%) Control-M
3 1 (0.26%) Data Guard
3 1 (0.26%) EMC NetWorker
3 1 (0.26%) Enterprise Manager Cloud Control
3 1 (0.26%) FortiGate
3 1 (0.26%) LiteSpeed
3 1 (0.26%) NetVault Backup
3 1 (0.26%) Opscode Chef
3 1 (0.26%) Puppet
3 1 (0.26%) QRadar
3 1 (0.26%) Salt
3 1 (0.26%) Tivoli
3 1 (0.26%) Tivoli Storage Manager
Vendors
1 175 (45.45%) Microsoft
2 95 (24.68%) Databricks
3 19 (4.94%) Oracle
4 15 (3.90%) Alteryx
5 10 (2.60%) Informatica
6 7 (1.82%) Dell
7 4 (1.04%) IBM
7 4 (1.04%) VMware
8 3 (0.78%) Ab Initio
8 3 (0.78%) Cognos
8 3 (0.78%) NetApp
9 2 (0.52%) Google
9 2 (0.52%) JD Edwards
9 2 (0.52%) Netezza
9 2 (0.52%) SAP
10 1 (0.26%) BMC
10 1 (0.26%) Cerner
10 1 (0.26%) CheckPoint
10 1 (0.26%) Serena
10 1 (0.26%) Sybase