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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
17 Oct 2021
Same period 2020 Same period 2019
Rank 391 313 243
Rank change year-on-year -78 -70 -7
Permanent jobs citing SQL Server Analysis Services 1,003 470 1,920
As % of all permanent jobs advertised in the UK 0.81% 0.98% 1.40%
As % of the Database & Business Intelligence category 2.88% 3.42% 5.11%
Number of salaries quoted 871 390 1,718
10th Percentile £37,500 £35,000 £36,250
25th Percentile £42,500 £41,250 £42,500
Median annual salary (50th Percentile) £52,500 £52,500 £55,000
Median % change year-on-year - -4.55% +10.00%
75th Percentile £67,500 £67,500 £70,000
90th Percentile £80,000 £85,000 £80,000
UK excluding London median annual salary £46,250 £45,000 £45,000
% change year-on-year +2.78% - +0.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 34,780 13,761 37,563
As % of all permanent IT jobs advertised in the UK 27.93% 28.73% 27.36%
Number of salaries quoted 22,267 11,676 31,078
10th Percentile £35,000 £33,750 £31,250
25th Percentile £42,500 £42,000 £38,250
Median annual salary (50th Percentile) £57,500 £55,000 £52,500
Median % change year-on-year +4.55% +4.76% +5.00%
75th Percentile £77,500 £72,500 £70,000
90th Percentile £95,000 £88,750 £86,250
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

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 October 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 17 October 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 -67 897 £55,000 - 143
UK excluding London -84 504 £46,250 +2.78% 94
London -79 435 £62,500 -7.41% 56
Work from Home -133 190 £55,000 +22.22% 34
North of England -54 174 £47,500 +5.56% 28
Midlands -62 123 £45,000 -5.26% 23
West Midlands -60 104 £45,000 -10.00% 14
North West -49 83 £47,500 +6.74% 16
Yorkshire -59 77 £47,500 -9.52% 6
South East -127 72 £52,500 +10.53% 22
Scotland -63 58 £48,000 +1.05% 4
South West -66 39 £42,000 -1.18% 10
East of England -98 30 £53,750 +11.40% 3
East Midlands -77 18 £42,750 +13.81% 9
North East -25 14 £37,500 - 6
Wales -53 6 £45,000 +32.35% 2
Northern Ireland - 2 £30,000 - 2

For the 6 months to 17 October 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 844 (84.15%) Business Intelligence
2 838 (83.55%) SQL
3 829 (82.65%) SQL Server Integration Services
4 761 (75.87%) SQL Server Reporting Services
5 705 (70.29%) SQL Server
6 626 (62.41%) Power Platform
7 624 (62.21%) Power BI
8 579 (57.73%) Data Warehouse
9 567 (56.53%) Microsoft
10 521 (51.94%) Azure
11 475 (47.36%) ETL
12 348 (34.70%) T-SQL
13 342 (34.10%) Analytics
14 286 (28.51%) Data Modelling
15 243 (24.23%) Finance
15 243 (24.23%) Visualisation
16 233 (23.23%) Agile Software Development
17 218 (21.73%) Azure Data Factory
18 185 (18.44%) Social Skills
19 178 (17.75%) Data Analysis Expressions (DAX)
20 176 (17.55%) Microsoft Analysis Services
21 174 (17.35%) PowerShell
22 168 (16.75%) Python
23 160 (15.95%) Tableau
24 156 (15.55%) Azure SQL Database
25 152 (15.15%) Data Lake
26 148 (14.76%) DevOps
27 143 (14.26%) Databricks
28 135 (13.46%) Microsoft Excel
29 126 (12.56%) Analytical Skills

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 56 (5.58%) SharePoint
2 16 (1.60%) Apache Spark
3 12 (1.20%) Apache
3 12 (1.20%) IIS
4 10 (1.00%) SAS
5 7 (0.70%) Apache Airflow
6 6 (0.60%) Confluence
7 3 (0.30%) CMS
7 3 (0.30%) FileNet
7 3 (0.30%) Papyrus
8 2 (0.20%) Elasticsearch
9 1 (0.100%) Apache Synapse
9 1 (0.100%) Oracle SOA Suite
9 1 (0.100%) SharePoint 2010
9 1 (0.100%) WordPress
Applications
1 135 (13.46%) Microsoft Excel
2 42 (4.19%) Microsoft Office
3 6 (0.60%) MS Visio
4 1 (0.100%) Microsoft PowerPoint
4 1 (0.100%) Spreadsheet
Business Applications
1 16 (1.60%) Dynamics AX
1 16 (1.60%) IBM Planning Analytics
2 15 (1.50%) Dynamics CRM
3 11 (1.10%) Dynamics NAV
4 10 (1.00%) NetSuite
5 8 (0.80%) Unica
6 4 (0.40%) Elite 3E
7 1 (0.100%) Alphatax
7 1 (0.100%) Dynamics GP
7 1 (0.100%) Sage 200
7 1 (0.100%) Sage X3
7 1 (0.100%) SAP Business One
7 1 (0.100%) SnowdropKCS
Cloud Services
1 626 (62.41%) Power Platform
2 521 (51.94%) Azure
3 218 (21.73%) Azure Data Factory
4 120 (11.96%) Azure Synapse Analytics
5 114 (11.37%) AWS
6 76 (7.58%) SaaS
7 53 (5.28%) PaaS
8 47 (4.69%) GCP
9 43 (4.29%) Azure Cosmos DB
10 39 (3.89%) Dynamics 365
11 37 (3.69%) Microsoft 365
12 30 (2.99%) IaaS
12 30 (2.99%) PowerApps
13 22 (2.19%) Snowflake
14 20 (1.99%) Azure Stack
15 16 (1.60%) GitHub
16 13 (1.30%) Serverless
17 11 (1.10%) Azure Storage
17 11 (1.10%) Power Automate
18 10 (1.00%) Azure Sentinel
Communications & Networking
1 6 (0.60%) Internet
2 5 (0.50%) Firewall
3 4 (0.40%) GoToMeeting
3 4 (0.40%) Modbus
3 4 (0.40%) Skype
3 4 (0.40%) SNMP
3 4 (0.40%) SSL
3 4 (0.40%) WebEx
4 3 (0.30%) FTP
4 3 (0.30%) PuTTY
4 3 (0.30%) WinSCP
5 1 (0.100%) DNS
5 1 (0.100%) IP Telephony
5 1 (0.100%) LAN
5 1 (0.100%) VoIP
5 1 (0.100%) WAN
Database & Business Intelligence
1 829 (82.65%) SQL Server Integration Services
2 761 (75.87%) SQL Server Reporting Services
3 705 (70.29%) SQL Server
4 624 (62.21%) Power BI
5 579 (57.73%) Data Warehouse
6 176 (17.55%) Microsoft Analysis Services
7 160 (15.95%) Tableau
8 156 (15.55%) Azure SQL Database
9 152 (15.15%) Data Lake
10 79 (7.88%) Relational Database
11 72 (7.18%) OLAP
12 60 (5.98%) Azure SQL Data Warehouse
13 55 (5.48%) Enterprise Data Warehouse
14 53 (5.28%) RDBMS
15 52 (5.18%) Big Data
16 47 (4.69%) MySQL
17 44 (4.39%) BusinessObjects
18 41 (4.09%) SQL Server 2012
19 40 (3.99%) SQL Server 2008
20 38 (3.79%) Star Schema
Development Applications
1 64 (6.38%) Visual Studio
2 61 (6.08%) Git (software)
3 47 (4.69%) SQL Server Management Studio (SSMS)
4 36 (3.59%) Team Foundation Server
5 24 (2.39%) JIRA
6 22 (2.19%) Jenkins
7 16 (1.60%) Octopus Deploy
8 12 (1.20%) ERwin
9 9 (0.90%) TeamCity
10 6 (0.60%) Subversion
11 5 (0.50%) NUnit
11 5 (0.50%) Postman
11 5 (0.50%) Visual Studio Code
12 4 (0.40%) Atlassian Bamboo
12 4 (0.40%) ER Studio
12 4 (0.40%) GDB
12 4 (0.40%) tSQLt
13 3 (0.30%) Visual Studio Team System
14 1 (0.100%) Axure RP
14 1 (0.100%) WebDriver
General
1 243 (24.23%) Finance
2 185 (18.44%) Social Skills
3 126 (12.56%) Analytical Skills
4 53 (5.28%) Retail
5 35 (3.49%) Banking
6 32 (3.19%) Manufacturing
7 26 (2.59%) Law
8 17 (1.69%) Legal
9 16 (1.60%) Presentation Skills
10 15 (1.50%) Organisational Skills
11 13 (1.30%) Advertising
12 12 (1.20%) Back Office
13 11 (1.10%) Front Office
13 11 (1.10%) Public Sector
14 9 (0.90%) Investment Banking
15 7 (0.70%) Inclusion and Diversity
16 6 (0.60%) Games
16 6 (0.60%) Influencing Skills
16 6 (0.60%) Publishing
17 5 (0.50%) Marketing
Job Titles
1 451 (44.97%) Developer
2 299 (29.81%) Business Intelligence Developer
3 169 (16.85%) Data Engineer
4 141 (14.06%) SQL Developer
5 121 (12.06%) Analyst
6 100 (9.97%) DBA
7 83 (8.28%) SQL DBA
8 70 (6.98%) SQL BI Developer
9 64 (6.38%) Administrator
10 60 (5.98%) Azure Engineer
11 59 (5.88%) Business Developer
11 59 (5.88%) Power BI Developer
12 52 (5.18%) Business Intelligence Analyst
13 51 (5.08%) Data Analyst
14 46 (4.59%) Architect
15 44 (4.39%) SSIS Developer
16 43 (4.29%) Consultant
17 37 (3.69%) Azure Developer
17 37 (3.69%) Data Warehouse Developer
18 34 (3.39%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 109 (10.87%) MDX
2 96 (9.57%) .NET
3 41 (4.09%) XML
4 32 (3.19%) Web Services
5 31 (3.09%) HTML
6 28 (2.79%) JSON
7 24 (2.39%) ASP.NET
7 24 (2.39%) CSS
8 18 (1.79%) Kafka
9 17 (1.69%) REST
10 16 (1.60%) .NET Framework
10 16 (1.60%) AngularJS
10 16 (1.60%) PySpark
11 15 (1.50%) RESTful
12 11 (1.10%) jQuery
13 10 (1.00%) Middleware
13 10 (1.00%) React
14 9 (0.90%) ARM Templates
14 9 (0.90%) Entity Framework
14 9 (0.90%) WinForms
Miscellaneous
1 64 (6.38%) Management Information System
2 37 (3.69%) Clustering
3 27 (2.69%) Replication
4 24 (2.39%) Greenfield Project
5 22 (2.19%) User Experience
6 21 (2.09%) Data Structures
7 16 (1.60%) Public Cloud
8 11 (1.10%) Self-Motivation
9 8 (0.80%) Mobile App
10 7 (0.70%) Data Protection Act
11 6 (0.60%) Analytical Mindset
11 6 (0.60%) Enterprise Software
11 6 (0.60%) NHS
11 6 (0.60%) Reference Data
12 5 (0.50%) Data Centre
12 5 (0.50%) Legacy Systems
12 5 (0.50%) Online Games
12 5 (0.50%) Taxonomies
13 4 (0.40%) Reinsurance
14 3 (0.30%) Virtual Team
Operating Systems
1 50 (4.99%) Windows
2 25 (2.49%) Windows Server
3 22 (2.19%) Linux
4 15 (1.50%) Unix
5 8 (0.80%) Windows 10
6 3 (0.30%) Windows 7
7 1 (0.100%) CentOS
7 1 (0.100%) Red Hat Enterprise Linux
7 1 (0.100%) Solaris
7 1 (0.100%) Windows Mobile
7 1 (0.100%) Windows Server 2012
Processes & Methodologies
1 844 (84.15%) Business Intelligence
2 475 (47.36%) ETL
3 342 (34.10%) Analytics
4 286 (28.51%) Data Modelling
5 243 (24.23%) Visualisation
6 233 (23.23%) Agile Software Development
7 148 (14.76%) DevOps
8 124 (12.36%) Data Visualisation
9 122 (12.16%) Problem-Solving
10 116 (11.57%) Data Management
11 115 (11.47%) Kimball Methodology
12 113 (11.27%) Migration
13 109 (10.87%) Data Engineering
14 77 (7.68%) Performance Tuning
15 67 (6.68%) Stakeholder Management
16 66 (6.58%) Data Analytics
17 65 (6.48%) Requirements Gathering
18 56 (5.58%) Data Strategy
18 56 (5.58%) Dimensional Modelling
19 54 (5.38%) Data Analysis
Programming Languages
1 838 (83.55%) SQL
2 348 (34.70%) T-SQL
3 178 (17.75%) Data Analysis Expressions (DAX)
4 174 (17.35%) PowerShell
5 168 (16.75%) Python
6 124 (12.36%) C#
7 47 (4.69%) R
7 47 (4.69%) VBA
8 25 (2.49%) VB.NET
9 20 (1.99%) Scala
10 14 (1.40%) U-SQL
11 13 (1.30%) JavaScript
12 11 (1.10%) Java
13 10 (1.00%) Shell Script
13 10 (1.00%) X++
14 5 (0.50%) Bash Shell
14 5 (0.50%) Perl
14 5 (0.50%) VB
15 4 (0.40%) C
15 4 (0.40%) PL/SQL
Qualifications
1 87 (8.67%) Degree
2 57 (5.68%) Microsoft Certification
3 25 (2.49%) Security Cleared
4 16 (1.60%) MCSA
5 13 (1.30%) MCSE
5 13 (1.30%) Numerate Degree
6 11 (1.10%) SC Cleared
7 8 (0.80%) Computer Science Degree
8 7 (0.70%) MCITP
9 5 (0.50%) HNC
9 5 (0.50%) HND
10 4 (0.40%) ISEB
10 4 (0.40%) ITIL Certification
11 3 (0.30%) MBCS
12 1 (0.100%) ISTQB
12 1 (0.100%) Master's Degree
12 1 (0.100%) MCP
12 1 (0.100%) PMI Certification
12 1 (0.100%) PMP
12 1 (0.100%) TOGAF Certification
Quality Assurance & Compliance
1 104 (10.37%) Data Quality
2 36 (3.59%) GDPR
3 24 (2.39%) QA
4 5 (0.50%) Accessibility
4 5 (0.50%) GRC
4 5 (0.50%) SLA
5 3 (0.30%) HL7
6 2 (0.20%) PCI DSS
7 1 (0.100%) GxP
7 1 (0.100%) ISO/IEC 27001
System Software
1 29 (2.89%) VMware Infrastructure
2 16 (1.60%) Active Directory
3 5 (0.50%) Docker
3 5 (0.50%) Hyper-V
4 4 (0.40%) VMware Server
5 1 (0.100%) Virtual Machines
5 1 (0.100%) VirtualBox
Systems Management
1 18 (1.79%) Terraform
2 6 (0.60%) Ansible
3 5 (0.50%) Kubernetes
4 4 (0.40%) Nagios
5 3 (0.30%) Control-M
5 3 (0.30%) Microsoft Clustering
6 2 (0.20%) Grafana
6 2 (0.20%) Opscode Chef
6 2 (0.20%) Perfmon
6 2 (0.20%) Puppet
7 1 (0.100%) Active Directory Federation Services
7 1 (0.100%) Automic
7 1 (0.100%) Docker Swarm
7 1 (0.100%) Microsoft Data Protection Manager
7 1 (0.100%) Microsoft Intune
7 1 (0.100%) SCOrch
Vendors
1 567 (56.53%) Microsoft
2 143 (14.26%) Databricks
3 72 (7.18%) Oracle
4 47 (4.69%) Alteryx
5 43 (4.29%) VMware
6 38 (3.79%) Google
7 30 (2.99%) IBM
8 29 (2.89%) SAP
9 18 (1.79%) Citrix
9 18 (1.79%) Salesforce.com
10 13 (1.30%) GoldenSource
11 12 (1.20%) Cognos
11 12 (1.20%) RedGate
12 11 (1.10%) Teradata
13 10 (1.00%) Adobe
13 10 (1.00%) JD Edwards
14 8 (0.80%) IFS
14 8 (0.80%) Talend
15 6 (0.60%) Birst
16 5 (0.50%) ServiceNow