Period
to 17 January 2022

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 17 January 2022 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
17 Jan 2022
Same period 2021 Same period 2020
Rank 416 330 291
Rank change year-on-year -86 -39 -31
Permanent jobs citing SQL Server Analysis Services 948 558 1,426
As % of all permanent jobs advertised in the UK 0.75% 0.91% 1.13%
As % of the Database & Business Intelligence category 2.82% 3.30% 4.17%
Number of salaries quoted 776 471 1,267
10th Percentile £37,500 £35,000 £36,830
25th Percentile £42,500 £41,125 £42,500
Median annual salary (50th Percentile) £55,000 £50,000 £55,000
Median % change year-on-year +10.00% -9.09% +10.00%
75th Percentile £67,625 £65,000 £72,500
90th Percentile £80,000 £80,000 £82,500
UK excluding London median annual salary £47,500 £47,000 £45,000
% change year-on-year +1.06% +4.44% +5.88%

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 33,660 16,902 34,209
As % of all permanent IT jobs advertised in the UK 26.79% 27.56% 27.11%
Number of salaries quoted 21,455 14,303 28,301
10th Percentile £36,250 £33,750 £32,000
25th Percentile £43,750 £41,250 £38,750
Median annual salary (50th Percentile) £60,000 £55,000 £52,500
Median % change year-on-year +9.09% +4.76% -
75th Percentile £77,500 £72,500 £71,250
90th Percentile £95,000 £87,500 £88,750
UK excluding London median annual salary £50,000 £49,000 £45,000
% change year-on-year +2.04% +8.89% -

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 17 January 2022.

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 17 January 2022. 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 -68 853 £55,000 +4.76% 152
UK excluding London -81 503 £47,500 +1.06% 87
London -72 380 £65,000 - 76
Midlands -16 155 £47,500 +5.56% 21
Work from Home -130 152 £55,000 +15.79% 56
North of England -112 144 £47,500 +1.06% 15
West Midlands -7 117 £47,500 -5.00% 16
South East -88 71 £55,000 +12.82% 18
Yorkshire -68 70 £45,000 -5.26% 7
North West -82 64 £47,500 - 6
South West -36 53 £42,000 -2.33% 9
East Midlands -48 37 £47,500 +26.45% 5
East of England -70 35 £50,000 - 13
Scotland -53 33 £48,000 +1.05% 10
North East -20 10 £38,000 +1.33% 2
Wales -38 10 £40,500 +19.12% 1
Northern Ireland - 2 - -

For the 6 months to 17 January 2022, 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 787 (83.02%) SQL
2 777 (81.96%) SQL Server Integration Services
3 743 (78.38%) Business Intelligence
4 730 (77.00%) SQL Server Reporting Services
5 645 (68.04%) SQL Server
6 530 (55.91%) Power Platform
7 529 (55.80%) Power BI
8 513 (54.11%) Microsoft
9 482 (50.84%) Data Warehouse
9 482 (50.84%) Azure
10 431 (45.46%) ETL
11 345 (36.39%) Analytics
12 315 (33.23%) T-SQL
13 289 (30.49%) Finance
14 255 (26.90%) Data Modelling
15 246 (25.95%) Agile Software Development
16 229 (24.16%) Social Skills
17 180 (18.99%) Azure Data Factory
18 179 (18.88%) Visualisation
19 168 (17.72%) Data Lake
20 163 (17.19%) PowerShell
21 159 (16.77%) Azure SQL Database
22 153 (16.14%) Python
23 150 (15.82%) Data Analysis Expressions (DAX)
24 146 (15.40%) Microsoft Analysis Services
25 138 (14.56%) Migration
25 138 (14.56%) Microsoft Excel
26 135 (14.24%) DevOps
27 131 (13.82%) C#
28 127 (13.40%) Tableau

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 46 (4.85%) SharePoint
2 21 (2.22%) Apache
3 20 (2.11%) Apache Spark
4 9 (0.95%) SAS
5 8 (0.84%) Confluence
6 5 (0.53%) Elasticsearch
6 5 (0.53%) IIS
7 4 (0.42%) FileNet
7 4 (0.42%) Papyrus
8 3 (0.32%) CMS
9 2 (0.21%) SharePoint 2010
9 2 (0.21%) SharePoint 2013
10 1 (0.11%) Apache Airflow
10 1 (0.11%) WordPress
Applications
1 138 (14.56%) Microsoft Excel
2 35 (3.69%) Microsoft Office
3 8 (0.84%) MS Visio
4 3 (0.32%) Microsoft PowerPoint
5 2 (0.21%) FileZilla
6 1 (0.11%) SPSS
Business Applications
1 30 (3.16%) Dynamics CRM
2 29 (3.06%) Alphatax
2 29 (3.06%) Dynamics GP
3 21 (2.22%) Dynamics NAV
4 10 (1.05%) NetSuite
5 7 (0.74%) Dynamics AX
6 6 (0.63%) Unica
7 5 (0.53%) IBM Planning Analytics
8 2 (0.21%) Sage X3
9 1 (0.11%) Sage 200
9 1 (0.11%) SnowdropKCS
Cloud Services
1 530 (55.91%) Power Platform
2 482 (50.84%) Azure
3 180 (18.99%) Azure Data Factory
4 109 (11.50%) AWS
5 101 (10.65%) Azure Synapse Analytics
6 47 (4.96%) Dynamics 365
7 46 (4.85%) SaaS
8 40 (4.22%) PaaS
9 29 (3.06%) Azure Cosmos DB
10 28 (2.95%) GCP
11 23 (2.43%) IaaS
12 22 (2.32%) Microsoft 365
12 22 (2.32%) Snowflake
13 19 (2.00%) GitHub
14 12 (1.27%) Azure Stack
14 12 (1.27%) PowerApps
15 8 (0.84%) Serverless
16 7 (0.74%) Azure Sentinel
17 6 (0.63%) Amazon EC2
17 6 (0.63%) Azure Storage
Communications & Networking
1 4 (0.42%) SAN
2 2 (0.21%) DNS
2 2 (0.21%) FTP
3 1 (0.11%) Firewall
Database & Business Intelligence
1 777 (81.96%) SQL Server Integration Services
2 730 (77.00%) SQL Server Reporting Services
3 645 (68.04%) SQL Server
4 529 (55.80%) Power BI
5 482 (50.84%) Data Warehouse
6 168 (17.72%) Data Lake
7 159 (16.77%) Azure SQL Database
8 146 (15.40%) Microsoft Analysis Services
9 127 (13.40%) Tableau
10 88 (9.28%) OLAP
11 67 (7.07%) Relational Database
12 59 (6.22%) SQL Server 2016
13 49 (5.17%) Crystal Reports
14 47 (4.96%) MySQL
15 46 (4.85%) Enterprise Data Warehouse
16 43 (4.54%) Big Data
16 43 (4.54%) SQL Server 2008
17 40 (4.22%) Azure SQL Data Warehouse
17 40 (4.22%) SQL Server 2012
18 39 (4.11%) OLTP
Development Applications
1 102 (10.76%) SQL Server Management Studio (SSMS)
2 47 (4.96%) JIRA
3 39 (4.11%) Visual Studio
4 31 (3.27%) Git (software)
5 18 (1.90%) Jenkins
6 17 (1.79%) Team Foundation Server
7 13 (1.37%) Octopus Deploy
8 9 (0.95%) Subversion
9 7 (0.74%) TeamCity
10 6 (0.63%) ERwin
11 4 (0.42%) git-flow
11 4 (0.42%) Maven
11 4 (0.42%) tSQLt
12 3 (0.32%) Atlassian Bamboo
13 2 (0.21%) Selenium
13 2 (0.21%) SpecFlow
13 2 (0.21%) Visual Studio Team System
13 2 (0.21%) WebDriver
14 1 (0.11%) Axure RP
14 1 (0.11%) Gradle
General
1 289 (30.49%) Finance
2 229 (24.16%) Social Skills
3 123 (12.97%) Analytical Skills
4 67 (7.07%) Banking
5 46 (4.85%) Retail
6 43 (4.54%) Inclusion and Diversity
7 34 (3.59%) Marketing
8 27 (2.85%) Back Office
9 26 (2.74%) Manufacturing
10 18 (1.90%) Investment Banking
11 17 (1.79%) Law
11 17 (1.79%) Legal
12 14 (1.48%) Organisational Skills
13 11 (1.16%) Public Sector
14 8 (0.84%) Influencing Skills
15 6 (0.63%) Advertising
15 6 (0.63%) Presentation Skills
16 5 (0.53%) Aerospace
17 4 (0.42%) Publishing
18 3 (0.32%) Front Office
Job Titles
1 437 (46.10%) Developer
2 281 (29.64%) Business Intelligence Developer
3 170 (17.93%) SQL Developer
4 133 (14.03%) Data Engineer
5 125 (13.19%) Analyst
6 102 (10.76%) DBA
7 88 (9.28%) SQL DBA
8 85 (8.97%) SQL BI Developer
9 61 (6.43%) Administrator
10 54 (5.70%) Power BI Developer
11 50 (5.27%) SSIS Developer
12 45 (4.75%) SQL Server DBA
13 44 (4.64%) Business Intelligence Analyst
14 43 (4.54%) Data Warehouse Developer
15 42 (4.43%) SSRS Developer
16 39 (4.11%) Azure Developer
16 39 (4.11%) Business Developer
17 37 (3.90%) Consultant
17 37 (3.90%) Data Analyst
18 32 (3.38%) Support Analyst
Libraries, Frameworks & Software Standards
1 86 (9.07%) MDX
2 76 (8.02%) .NET
3 21 (2.22%) ARM Templates
4 20 (2.11%) HTML
5 19 (2.00%) PySpark
6 16 (1.69%) ASP.NET
6 16 (1.69%) Web Services
7 15 (1.58%) CSS
8 14 (1.48%) AngularJS
8 14 (1.48%) XML
9 13 (1.37%) React
10 10 (1.05%) JSON
10 10 (1.05%) LINQ
10 10 (1.05%) Middleware
10 10 (1.05%) RESTful
11 9 (0.95%) .NET Framework
11 9 (0.95%) REST
11 9 (0.95%) WPF
12 8 (0.84%) Vue.js
13 7 (0.74%) ASP.NET Web API
Miscellaneous
1 85 (8.97%) Management Information System
2 31 (3.27%) Clustering
3 21 (2.22%) Replication
4 20 (2.11%) User Experience
5 18 (1.90%) Data Structures
6 15 (1.58%) Greenfield Project
7 13 (1.37%) Data Protection Act
7 13 (1.37%) Self-Motivation
8 12 (1.27%) Reinsurance
9 10 (1.05%) Public Cloud
10 8 (0.84%) Algorithms
11 7 (0.74%) Taxonomies
12 5 (0.53%) Housing Association
13 4 (0.42%) Analytical Mindset
13 4 (0.42%) Credit Risk
13 4 (0.42%) Foreign Exchange (FX)
14 3 (0.32%) CMDB
14 3 (0.32%) Derivative
15 2 (0.21%) Mobile App
15 2 (0.21%) Reference Data
Operating Systems
1 58 (6.12%) Windows
2 35 (3.69%) Windows Server
3 27 (2.85%) Linux
4 22 (2.32%) Unix
5 2 (0.21%) Windows Mobile
6 1 (0.11%) CentOS
6 1 (0.11%) Red Hat Enterprise Linux
6 1 (0.11%) Solaris
Processes & Methodologies
1 743 (78.38%) Business Intelligence
2 431 (45.46%) ETL
3 345 (36.39%) Analytics
4 255 (26.90%) Data Modelling
5 246 (25.95%) Agile Software Development
6 179 (18.88%) Visualisation
7 138 (14.56%) Migration
8 135 (14.24%) DevOps
9 122 (12.87%) Problem-Solving
10 108 (11.39%) Data Engineering
11 106 (11.18%) Data Management
12 103 (10.86%) Data Analytics
13 91 (9.60%) ERP
14 89 (9.39%) Kimball Methodology
15 75 (7.91%) Performance Tuning
16 72 (7.59%) Data Analysis
17 69 (7.28%) Requirements Gathering
18 64 (6.75%) Data Visualisation
19 58 (6.12%) Stakeholder Management
20 55 (5.80%) Scrum
Programming Languages
1 787 (83.02%) SQL
2 315 (33.23%) T-SQL
3 163 (17.19%) PowerShell
4 153 (16.14%) Python
5 150 (15.82%) Data Analysis Expressions (DAX)
6 131 (13.82%) C#
7 63 (6.65%) VBA
8 48 (5.06%) R
9 37 (3.90%) Java
10 25 (2.64%) JavaScript
11 23 (2.43%) Bash
11 23 (2.43%) Shell Script
12 18 (1.90%) C
12 18 (1.90%) VB.NET
13 15 (1.58%) C++
14 11 (1.16%) PL/SQL
15 10 (1.05%) Scala
16 5 (0.53%) VBScript
17 4 (0.42%) Fortran
17 4 (0.42%) VB
Qualifications
1 100 (10.55%) Degree
2 44 (4.64%) Microsoft Certification
3 24 (2.53%) Security Cleared
4 19 (2.00%) Numerate Degree
5 18 (1.90%) MCSA
6 17 (1.79%) Computer Science Degree
7 13 (1.37%) MCITP
8 11 (1.16%) MCSE
9 8 (0.84%) HNC
9 8 (0.84%) HND
10 7 (0.74%) SC Cleared
11 4 (0.42%) ISEB
11 4 (0.42%) Master's Degree
12 3 (0.32%) ITIL Certification
13 2 (0.21%) ISTQB
13 2 (0.21%) MBCS
13 2 (0.21%) MOS
14 1 (0.11%) PMI Certification
14 1 (0.11%) PMP
14 1 (0.11%) TOGAF Certification
Quality Assurance & Compliance
1 105 (11.08%) Data Quality
2 32 (3.38%) GDPR
3 19 (2.00%) QA
4 7 (0.74%) PCI DSS
5 6 (0.63%) ISO/IEC 27001
6 4 (0.42%) Cyber Essentials
6 4 (0.42%) Cyber Essentials PLUS
7 2 (0.21%) SLA
8 1 (0.11%) Accessibility
8 1 (0.11%) HL7
System Software
1 22 (2.32%) VMware Infrastructure
2 13 (1.37%) Active Directory
3 6 (0.63%) Docker
4 4 (0.42%) VMware Server
5 1 (0.11%) Virtual Machines
Systems Management
1 12 (1.27%) Terraform
2 7 (0.74%) Microsoft Clustering
3 6 (0.63%) Kubernetes
4 5 (0.53%) Ansible
5 4 (0.42%) Control-M
5 4 (0.42%) Nagios
6 2 (0.21%) Opscode Chef
6 2 (0.21%) Perfmon
6 2 (0.21%) Puppet
7 1 (0.11%) Active Directory Federation Services
7 1 (0.11%) Automic
7 1 (0.11%) Microsoft Data Protection Manager
7 1 (0.11%) Microsoft Intune
7 1 (0.11%) SCOrch
Vendors
1 513 (54.11%) Microsoft
2 112 (11.81%) Databricks
3 90 (9.49%) Oracle
4 32 (3.38%) VMware
5 30 (3.16%) Alteryx
5 30 (3.16%) Google
6 25 (2.64%) SAP
7 18 (1.90%) Citrix
8 15 (1.58%) Salesforce.com
9 10 (1.05%) Birst
9 10 (1.05%) Civica
9 10 (1.05%) JD Edwards
10 9 (0.95%) Cognos
10 9 (0.95%) IFS
10 9 (0.95%) Infor
10 9 (0.95%) RedGate
11 8 (0.84%) Adobe
12 7 (0.74%) IBM
12 7 (0.74%) ServiceNow
12 7 (0.74%) Sybase