Period
to 14 May 2021

The following table provides summary statistics for permanent job vacancies with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 14 May 2021 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
14 May 2021
Same period 2020 Same period 2019
Rank 351 271 253
Rank change year-on-year -80 -18 -41
Permanent jobs citing SQL Server Analysis Services 801 1,180 2,030
As % of all permanent jobs advertised in the UK 0.88% 1.21% 1.41%
As % of the Database & Business Intelligence category 3.35% 4.49% 4.97%
Number of salaries quoted 652 1,065 1,773
10th Percentile £36,250 £37,250 £35,750
25th Percentile £41,250 £42,500 £42,500
Median annual salary (50th Percentile) £50,000 £55,000 £50,000
Median % change year-on-year -9.09% +10.00% -
75th Percentile £64,813 £75,000 £65,000
90th Percentile £77,500 £90,750 £80,000
UK excluding London median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% -

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 permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 23,925 26,255 40,810
As % of all permanent IT jobs advertised in the UK 26.43% 26.96% 28.26%
Number of salaries quoted 18,578 21,636 33,558
10th Percentile £33,750 £32,500 £31,250
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £55,000 £52,500 £52,500
Median % change year-on-year +4.76% - +5.00%
75th Percentile £73,750 £72,500 £70,000
90th Percentile £88,750 £90,000 £85,000
UK excluding London median annual salary £47,500 £46,000 £45,000
% change year-on-year +3.26% +2.22% +2.86%

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
Salary Trend

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

Salary trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Salary Histogram

Salary distribution for jobs citing SQL Server Analysis Services over the 6 months to 14 May 2021.

Salary histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 17 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL Server Analysis Services within the UK over the 6 months to 14 May 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -77 723 £52,250 -5.00% 113
UK excluding London -30 455 £47,500 - 72
London -78 305 £62,500 -10.71% 51
North of England +1 179 £46,500 +3.33% 18
Work from Home -64 157 £50,000 +11.11% 31
Yorkshire +41 96 £42,500 - 10
Midlands -22 93 £45,000 -10.00% 22
North West -2 76 £50,000 +4.17% 7
West Midlands -6 69 £45,000 -13.88% 14
South East -29 60 £50,000 - 12
Scotland 0 45 £48,625 -2.75% 7
South West -68 33 £48,500 +4.86% 5
East of England +2 32 £52,500 +10.53% 5
East Midlands -13 24 £41,250 -8.33% 8
Wales +14 11 £45,000 +14.65% 2
North East -11 7 £36,500 -8.75% 1
Northern Ireland 0 3 £45,000 +5.88% 1

For the 6 months to 14 May 2021, IT 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 permanent job ads with a requirement for SQL Server Analysis Services.

1 688 (85.89%) Business Intelligence
2 665 (83.02%) SQL
3 660 (82.40%) SQL Server Integration Services
4 624 (77.90%) SQL Server Reporting Services
5 580 (72.41%) SQL Server
6 523 (65.29%) Power Platform
7 522 (65.17%) Power BI
8 508 (63.42%) Data Warehouse
9 430 (53.68%) Azure
10 409 (51.06%) Microsoft
11 359 (44.82%) ETL
12 268 (33.46%) T-SQL
13 249 (31.09%) Analytics
14 196 (24.47%) Agile Software Development
14 196 (24.47%) Finance
15 194 (24.22%) Data Modelling
16 189 (23.60%) Visualisation
17 185 (23.10%) Azure Data Factory
18 180 (22.47%) Microsoft Analysis Services
19 167 (20.85%) Python
20 142 (17.73%) Social Skills
21 134 (16.73%) Azure SQL Database
22 133 (16.60%) Data Analysis Expressions (DAX)
22 133 (16.60%) Data Lake
23 132 (16.48%) Azure Synapse Analytics
24 119 (14.86%) Tableau
25 117 (14.61%) Databricks
26 112 (13.98%) Data Management
27 108 (13.48%) Migration
28 105 (13.11%) Data Visualisation

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 28 (3.50%) Apache Spark
2 22 (2.75%) SharePoint
3 19 (2.37%) Apache
3 19 (2.37%) SAS
4 8 (1.00%) IIS
5 7 (0.87%) Elasticsearch
6 5 (0.62%) Apache Synapse
6 5 (0.62%) Drupal
6 5 (0.62%) nginx
7 4 (0.50%) Apache Airflow
7 4 (0.50%) Confluence
8 2 (0.25%) OnBase
Applications
1 78 (9.74%) Microsoft Excel
2 14 (1.75%) Microsoft Office
3 4 (0.50%) MS Visio
4 1 (0.12%) Microsoft PowerPoint
4 1 (0.12%) Spreadsheet
Business Applications
1 13 (1.62%) Dynamics AX
1 13 (1.62%) Dynamics CRM
2 8 (1.00%) NetSuite
3 1 (0.12%) Cognos Business Intelligence
3 1 (0.12%) Dynamics NAV
3 1 (0.12%) Elite 3E
Cloud Services
1 523 (65.29%) Power Platform
2 430 (53.68%) Azure
3 185 (23.10%) Azure Data Factory
4 132 (16.48%) Azure Synapse Analytics
5 102 (12.73%) AWS
6 36 (4.49%) PaaS
7 35 (4.37%) Azure Stack
8 27 (3.37%) Dynamics 365
8 27 (3.37%) GCP
9 25 (3.12%) Microsoft 365
9 25 (3.12%) SaaS
10 19 (2.37%) IaaS
11 18 (2.25%) Azure Cosmos DB
12 14 (1.75%) Azure Machine Learning
13 13 (1.62%) Azure Storage
14 11 (1.37%) Serverless
15 10 (1.25%) Azure Functions
16 9 (1.12%) PowerApps
17 7 (0.87%) Amazon Kinesis
18 6 (0.75%) Azure Data Lake Analytics
Communications & Networking
1 6 (0.75%) FTP
2 2 (0.25%) Intranet
2 2 (0.25%) Kerberos
Database & Business Intelligence
1 660 (82.40%) SQL Server Integration Services
2 624 (77.90%) SQL Server Reporting Services
3 580 (72.41%) SQL Server
4 522 (65.17%) Power BI
5 508 (63.42%) Data Warehouse
6 180 (22.47%) Microsoft Analysis Services
7 134 (16.73%) Azure SQL Database
8 133 (16.60%) Data Lake
9 119 (14.86%) Tableau
10 90 (11.24%) Azure SQL Data Warehouse
11 89 (11.11%) Relational Database
12 57 (7.12%) SQL Server 2012
13 49 (6.12%) Big Data
14 40 (4.99%) QlikView
15 38 (4.74%) SQL Server 2016
16 35 (4.37%) SQL Server 2008
17 33 (4.12%) SQL Server 2019
18 32 (4.00%) Enterprise Data Warehouse
19 28 (3.50%) NoSQL
20 25 (3.12%) OLTP
Development Applications
1 56 (6.99%) Git (software)
2 43 (5.37%) Team Foundation Server
3 41 (5.12%) Visual Studio
4 26 (3.25%) SQL Server Management Studio (SSMS)
5 15 (1.87%) Jenkins
6 12 (1.50%) JIRA
7 11 (1.37%) Octopus Deploy
7 11 (1.37%) Subversion
8 7 (0.87%) ERwin
9 6 (0.75%) Postman
10 4 (0.50%) ER Studio
10 4 (0.50%) NUnit
11 3 (0.37%) Atlassian Bamboo
11 3 (0.37%) TeamCity
12 2 (0.25%) Vagrant
13 1 (0.12%) Eclipse
13 1 (0.12%) Toad
13 1 (0.12%) Visual Studio Team System
General
1 196 (24.47%) Finance
2 142 (17.73%) Social Skills
3 89 (11.11%) Analytical Skills
4 50 (6.24%) Law
5 39 (4.87%) Retail
6 30 (3.75%) Public Sector
7 23 (2.87%) Marketing
8 12 (1.50%) Banking
8 12 (1.50%) Presentation Skills
9 11 (1.37%) Legal
9 11 (1.37%) Manufacturing
10 9 (1.12%) Advertising
11 8 (1.00%) Publishing
12 7 (0.87%) Documentation Skills
13 5 (0.62%) Billing
13 5 (0.62%) Pharmaceutical
13 5 (0.62%) Telecoms
14 4 (0.50%) Electronics
14 4 (0.50%) Front Office
14 4 (0.50%) Influencing Skills
Job Titles
1 336 (41.95%) Developer
2 199 (24.84%) Business Intelligence Developer
3 157 (19.60%) Analyst
4 127 (15.86%) Data Engineer
5 86 (10.74%) SQL Developer
6 78 (9.74%) Business Intelligence Analyst
7 71 (8.86%) Data Analyst
8 63 (7.87%) DBA
9 61 (7.62%) Azure Engineer
10 54 (6.74%) Architect
11 52 (6.49%) SQL DBA
12 46 (5.74%) Power BI Developer
13 44 (5.49%) Consultant
13 44 (5.49%) Data Architect
14 42 (5.24%) Data Warehouse Developer
15 38 (4.74%) Senior Developer
16 35 (4.37%) Power BI Analyst
16 35 (4.37%) SQL BI Developer
17 32 (4.00%) Business Developer
18 31 (3.87%) SQL Analyst
Libraries, Frameworks & Software Standards
1 63 (7.87%) .NET
2 45 (5.62%) MDX
3 26 (3.25%) XML
4 23 (2.87%) REST
5 14 (1.75%) JSON
6 13 (1.62%) .NET Framework
6 13 (1.62%) Web Services
7 12 (1.50%) ASP.NET
8 11 (1.37%) Kafka
9 10 (1.25%) HTML
10 9 (1.12%) CSS
10 9 (1.12%) PySpark
11 8 (1.00%) RESTful
12 7 (0.87%) AngularJS
13 6 (0.75%) Entity Framework
14 5 (0.62%) EDI
14 5 (0.62%) HTML5
14 5 (0.62%) Node.js
14 5 (0.62%) Symfony
15 4 (0.50%) XSLT
Miscellaneous
1 49 (6.12%) Data Structures
2 30 (3.75%) Management Information System
3 28 (3.50%) Greenfield Project
4 19 (2.37%) Clustering
4 19 (2.37%) NHS
5 17 (2.12%) Reinsurance
5 17 (2.12%) User Experience
6 7 (0.87%) Mobile App
7 6 (0.75%) Self-Motivation
8 4 (0.50%) Analytical Mindset
8 4 (0.50%) Private Cloud
9 3 (0.37%) Enterprise Software
9 3 (0.37%) FMCG
9 3 (0.37%) Industry 4.0
9 3 (0.37%) Public Cloud
9 3 (0.37%) Replication
10 2 (0.25%) Blog
10 2 (0.25%) Data Protection Act
10 2 (0.25%) Social Media
10 2 (0.25%) Taxonomies
Operating Systems
1 35 (4.37%) Windows
2 12 (1.50%) Windows 10
2 12 (1.50%) Windows Server
3 9 (1.12%) Linux
4 7 (0.87%) Windows Server 2016
5 6 (0.75%) Windows 7
6 4 (0.50%) Unix
6 4 (0.50%) Windows Server 2008
7 2 (0.25%) Windows Server 2019
8 1 (0.12%) Windows Server 2012
Processes & Methodologies
1 688 (85.89%) Business Intelligence
2 359 (44.82%) ETL
3 249 (31.09%) Analytics
4 196 (24.47%) Agile Software Development
5 194 (24.22%) Data Modelling
6 189 (23.60%) Visualisation
7 112 (13.98%) Data Management
8 108 (13.48%) Migration
9 105 (13.11%) Data Visualisation
10 101 (12.61%) DevOps
11 86 (10.74%) Problem-Solving
12 78 (9.74%) Data Architecture
13 76 (9.49%) Data Analytics
14 75 (9.36%) Kimball Methodology
15 62 (7.74%) Data Analysis
16 58 (7.24%) Data Migration
17 57 (7.12%) Decision-Making
18 54 (6.74%) Project Delivery
19 51 (6.37%) Machine Learning
20 47 (5.87%) Continuous Integration
Programming Languages
1 665 (83.02%) SQL
2 268 (33.46%) T-SQL
3 167 (20.85%) Python
4 133 (16.60%) Data Analysis Expressions (DAX)
5 74 (9.24%) C#
6 49 (6.12%) PowerShell
7 44 (5.49%) R
8 16 (2.00%) PL/SQL
9 15 (1.87%) U-SQL
10 11 (1.37%) Scala
11 10 (1.25%) VBA
12 9 (1.12%) VB
13 8 (1.00%) Java
13 8 (1.00%) JavaScript
14 7 (0.87%) VB.NET
14 7 (0.87%) X++
15 6 (0.75%) Perl
16 4 (0.50%) ANSI SQL
16 4 (0.50%) C
17 3 (0.37%) PHP
Qualifications
1 58 (7.24%) Degree
2 23 (2.87%) Security Cleared
3 21 (2.62%) SC Cleared
4 16 (2.00%) Microsoft Certification
5 4 (0.50%) Computer Science Degree
5 4 (0.50%) ISEB
5 4 (0.50%) MCP
5 4 (0.50%) Numerate Degree
6 3 (0.37%) MBCS
7 1 (0.12%) HND
7 1 (0.12%) ITIL Certification
7 1 (0.12%) MCSA
7 1 (0.12%) MCSE
Quality Assurance & Compliance
1 83 (10.36%) Data Quality
2 21 (2.62%) GDPR
3 19 (2.37%) QA
4 6 (0.75%) SLA
5 4 (0.50%) PCI DSS
6 2 (0.25%) PMO
7 1 (0.12%) HL7
7 1 (0.12%) ISO/IEC 27001
System Software
1 15 (1.87%) Docker
2 13 (1.62%) VMware Infrastructure
3 6 (0.75%) Active Directory
4 4 (0.50%) HDFS
5 2 (0.25%) VirtualBox
6 1 (0.12%) Hyper-V
Systems Management
1 12 (1.50%) Terraform
2 10 (1.25%) Ansible
3 8 (1.00%) Grafana
4 7 (0.87%) Kubernetes
5 5 (0.62%) HAProxy
6 2 (0.25%) Docker Swarm
6 2 (0.25%) Kibana
7 1 (0.12%) Failover Clustering
7 1 (0.12%) Perfmon
Vendors
1 409 (51.06%) Microsoft
2 117 (14.61%) Databricks
3 51 (6.37%) Salesforce.com
4 41 (5.12%) Oracle
5 35 (4.37%) Google
6 24 (3.00%) SAP
7 22 (2.75%) Teradata
8 20 (2.50%) Alteryx
9 15 (1.87%) Informatica
9 15 (1.87%) QAD
10 13 (1.62%) VMware
11 10 (1.25%) Talend
12 8 (1.00%) JD Edwards
13 5 (0.62%) DataFlux
13 5 (0.62%) IBM
13 5 (0.62%) RapidMiner
14 4 (0.50%) RedGate
14 4 (0.50%) Sage
15 3 (0.37%) Cadence
15 3 (0.37%) Cognos