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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
24 Jul 2021
Same period 2020 Same period 2019
Rank 356 266 231
Rank change year-on-year -90 -35 -18
Permanent jobs citing SQL Server Analysis Services 945 850 2,175
As % of all permanent jobs advertised in the UK 0.84% 1.20% 1.50%
As % of the Database & Business Intelligence category 2.97% 4.36% 5.39%
Number of salaries quoted 809 738 1,959
10th Percentile £36,750 £36,250 £36,750
25th Percentile £41,750 £42,500 £42,500
Median annual salary (50th Percentile) £52,500 £55,000 £52,500
Median % change year-on-year -4.55% +4.76% +5.00%
75th Percentile £65,000 £73,750 £67,500
90th Percentile £77,500 £87,500 £80,000
UK excluding London median annual salary £46,500 £47,500 £45,000
% change year-on-year -2.11% +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 31,770 19,506 40,323
As % of all permanent IT jobs advertised in the UK 28.08% 27.56% 27.88%
Number of salaries quoted 21,360 16,015 33,375
10th Percentile £34,000 £32,500 £31,250
25th Percentile £42,500 £41,250 £37,500
Median annual salary (50th Percentile) £55,000 £55,000 £52,000
Median % change year-on-year - +5.77% +4.00%
75th Percentile £75,000 £72,500 £70,000
90th Percentile £92,500 £88,750 £85,000
UK excluding London median annual salary £48,000 £47,500 £45,000
% change year-on-year +1.05% +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 24 July 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 24 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -106 840 £52,500 -4.55% 143
UK excluding London -76 486 £46,500 -2.11% 98
London -96 407 £61,032 -12.81% 51
Work from Home -101 215 £51,500 +14.44% 26
North of England +1 177 £47,500 - 31
Midlands -78 102 £45,000 -10.00% 24
Yorkshire +8 89 £45,000 - 7
West Midlands -60 81 £45,000 -11.76% 16
North West -20 77 £50,000 - 20
South East -99 66 £50,000 - 17
Scotland -24 62 £45,000 -7.69% 7
South West -67 39 £42,000 -6.67% 7
East of England -58 26 £55,000 +15.79% 12
East Midlands -53 21 £40,250 -5.29% 8
North East -28 11 £36,500 -8.75% 4
Wales -15 10 £45,000 +14.65%
Northern Ireland - 5 £37,500 -

For the 6 months to 24 July 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 818 (86.56%) Business Intelligence
2 796 (84.23%) SQL
3 785 (83.07%) SQL Server Integration Services
4 701 (74.18%) SQL Server Reporting Services
5 665 (70.37%) SQL Server
6 628 (66.46%) Power Platform
7 627 (66.35%) Power BI
8 574 (60.74%) Data Warehouse
9 522 (55.24%) Microsoft
10 497 (52.59%) Azure
11 433 (45.82%) ETL
12 323 (34.18%) Analytics
13 316 (33.44%) T-SQL
14 269 (28.47%) Data Modelling
15 245 (25.93%) Visualisation
16 215 (22.75%) Microsoft Analysis Services
17 206 (21.80%) Azure Data Factory
18 204 (21.59%) Finance
19 197 (20.85%) Agile Software Development
20 188 (19.89%) Python
21 175 (18.52%) Tableau
22 165 (17.46%) Social Skills
23 154 (16.30%) Data Visualisation
24 153 (16.19%) Data Analysis Expressions (DAX)
25 144 (15.24%) Azure SQL Database
26 142 (15.03%) Databricks
27 138 (14.60%) Data Lake
28 135 (14.29%) Data Management
29 132 (13.97%) Analytical Skills
30 128 (13.54%) Azure Synapse Analytics

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 44 (4.66%) SharePoint
2 29 (3.07%) Apache Spark
3 21 (2.22%) Apache
4 16 (1.69%) IIS
5 15 (1.59%) SAS
6 9 (0.95%) Apache Airflow
7 6 (0.63%) Apache Synapse
8 2 (0.21%) Confluence
8 2 (0.21%) OnBase
9 1 (0.11%) Elasticsearch
9 1 (0.11%) Oracle SOA Suite
9 1 (0.11%) SharePoint 2010
Applications
1 120 (12.70%) Microsoft Excel
2 32 (3.39%) Microsoft Office
3 5 (0.53%) MS Visio
4 2 (0.21%) Spreadsheet
Business Applications
1 20 (2.12%) Dynamics AX
2 11 (1.16%) NetSuite
3 7 (0.74%) Dynamics CRM
4 4 (0.42%) Elite 3E
5 3 (0.32%) Dynamics NAV
5 3 (0.32%) Unica
6 1 (0.11%) Cognos Business Intelligence
6 1 (0.11%) SAP Business One
Cloud Services
1 628 (66.46%) Power Platform
2 497 (52.59%) Azure
3 206 (21.80%) Azure Data Factory
4 128 (13.54%) Azure Synapse Analytics
5 108 (11.43%) AWS
6 63 (6.67%) PaaS
7 51 (5.40%) SaaS
8 42 (4.44%) GCP
9 41 (4.34%) Azure Stack
10 36 (3.81%) Microsoft 365
11 34 (3.60%) IaaS
12 32 (3.39%) Dynamics 365
13 31 (3.28%) Azure Cosmos DB
14 22 (2.33%) PowerApps
15 17 (1.80%) Azure Storage
15 17 (1.80%) Serverless
16 16 (1.69%) Snowflake
17 15 (1.59%) Azure Functions
17 15 (1.59%) GitHub
18 9 (0.95%) Azure Machine Learning
Communications & Networking
1 9 (0.95%) FTP
2 6 (0.63%) Internet
3 4 (0.42%) Firewall
3 4 (0.42%) GoToMeeting
3 4 (0.42%) Modbus
3 4 (0.42%) Skype
3 4 (0.42%) SNMP
3 4 (0.42%) SSL
3 4 (0.42%) WebEx
4 3 (0.32%) PuTTY
4 3 (0.32%) WinSCP
5 1 (0.11%) Intranet
5 1 (0.11%) IP Telephony
5 1 (0.11%) LAN
5 1 (0.11%) VoIP
5 1 (0.11%) WAN
Database & Business Intelligence
1 785 (83.07%) SQL Server Integration Services
2 701 (74.18%) SQL Server Reporting Services
3 665 (70.37%) SQL Server
4 627 (66.35%) Power BI
5 574 (60.74%) Data Warehouse
6 215 (22.75%) Microsoft Analysis Services
7 175 (18.52%) Tableau
8 144 (15.24%) Azure SQL Database
9 138 (14.60%) Data Lake
10 97 (10.26%) Relational Database
11 85 (8.99%) Azure SQL Data Warehouse
12 67 (7.09%) OLAP
13 61 (6.46%) Big Data
14 56 (5.93%) SQL Server 2012
15 45 (4.76%) RDBMS
16 43 (4.55%) QlikView
17 39 (4.13%) BusinessObjects
18 38 (4.02%) SQL Server 2008
19 37 (3.92%) Data Mining
19 37 (3.92%) Star Schema
Development Applications
1 80 (8.47%) Git (software)
2 61 (6.46%) Visual Studio
3 55 (5.82%) Team Foundation Server
4 35 (3.70%) SQL Server Management Studio (SSMS)
5 16 (1.69%) Jenkins
6 13 (1.38%) Subversion
7 12 (1.27%) ERwin
7 12 (1.27%) JIRA
8 10 (1.06%) Octopus Deploy
9 8 (0.85%) ER Studio
10 6 (0.63%) NUnit
10 6 (0.63%) Postman
11 4 (0.42%) Atlassian Bamboo
11 4 (0.42%) GDB
11 4 (0.42%) TeamCity
11 4 (0.42%) Visual Studio Code
12 3 (0.32%) Vagrant
13 2 (0.21%) Visual Studio Team System
14 1 (0.11%) Bitbucket
14 1 (0.11%) Eclipse
General
1 204 (21.59%) Finance
2 165 (17.46%) Social Skills
3 132 (13.97%) Analytical Skills
4 51 (5.40%) Law
5 42 (4.44%) Retail
6 24 (2.54%) Manufacturing
7 21 (2.22%) Marketing
8 19 (2.01%) Presentation Skills
9 17 (1.80%) Advertising
10 15 (1.59%) Banking
11 13 (1.38%) Organisational Skills
12 12 (1.27%) Public Sector
13 11 (1.16%) Legal
14 10 (1.06%) Front Office
15 9 (0.95%) Publishing
16 7 (0.74%) Influencing Skills
17 5 (0.53%) Billing
17 5 (0.53%) Documentation Skills
17 5 (0.53%) Games
17 5 (0.53%) Pharmaceutical
Job Titles
1 402 (42.54%) Developer
2 253 (26.77%) Business Intelligence Developer
3 152 (16.08%) Data Engineer
4 151 (15.98%) Analyst
5 117 (12.38%) SQL Developer
6 84 (8.89%) Azure Engineer
7 79 (8.36%) Data Analyst
8 73 (7.72%) DBA
9 60 (6.35%) Business Intelligence Analyst
10 59 (6.24%) Architect
10 59 (6.24%) Business Developer
11 54 (5.71%) SQL BI Developer
11 54 (5.71%) SQL DBA
12 51 (5.40%) Consultant
12 51 (5.40%) Power BI Developer
13 44 (4.66%) Data Warehouse Developer
14 43 (4.55%) Data Architect
15 42 (4.44%) SSIS Developer
16 39 (4.13%) Administrator
17 34 (3.60%) Lead Developer
Libraries, Frameworks & Software Standards
1 95 (10.05%) .NET
2 86 (9.10%) MDX
3 48 (5.08%) XML
4 29 (3.07%) Web Services
5 25 (2.65%) HTML
5 25 (2.65%) JSON
6 23 (2.43%) ASP.NET
7 22 (2.33%) REST
8 21 (2.22%) CSS
9 19 (2.01%) .NET Framework
10 17 (1.80%) Kafka
11 16 (1.69%) RESTful
12 15 (1.59%) PySpark
13 12 (1.27%) AngularJS
14 10 (1.06%) Entity Framework
14 10 (1.06%) jQuery
15 9 (0.95%) Spark Streaming
15 9 (0.95%) WinForms
16 8 (0.85%) CSS3
16 8 (0.85%) HTML5
Miscellaneous
1 52 (5.50%) Management Information System
2 42 (4.44%) Data Structures
3 31 (3.28%) Greenfield Project
4 25 (2.65%) Clustering
5 22 (2.33%) Replication
6 16 (1.69%) NHS
6 16 (1.69%) User Experience
7 10 (1.06%) Self-Motivation
8 9 (0.95%) Mobile App
9 7 (0.74%) Legacy Systems
9 7 (0.74%) Public Cloud
9 7 (0.74%) Reinsurance
10 6 (0.63%) Analytical Mindset
10 6 (0.63%) Enterprise Software
11 5 (0.53%) Data Centre
11 5 (0.53%) FMCG
11 5 (0.53%) Taxonomies
12 4 (0.42%) Online Games
12 4 (0.42%) Reference Data
13 3 (0.32%) Wiki
Operating Systems
1 45 (4.76%) Windows
2 18 (1.90%) Linux
3 16 (1.69%) Windows 10
4 14 (1.48%) Windows Server
5 9 (0.95%) Unix
6 8 (0.85%) Windows 7
7 3 (0.32%) Windows Server 2016
8 2 (0.21%) Windows Server 2008
8 2 (0.21%) Windows Server 2012
Processes & Methodologies
1 818 (86.56%) Business Intelligence
2 433 (45.82%) ETL
3 323 (34.18%) Analytics
4 269 (28.47%) Data Modelling
5 245 (25.93%) Visualisation
6 197 (20.85%) Agile Software Development
7 154 (16.30%) Data Visualisation
8 135 (14.29%) Data Management
9 126 (13.33%) DevOps
10 108 (11.43%) Problem-Solving
11 105 (11.11%) Migration
12 89 (9.42%) Kimball Methodology
13 84 (8.89%) Data Analytics
14 83 (8.78%) Data Architecture
15 76 (8.04%) Data Engineering
16 72 (7.62%) Performance Tuning
17 69 (7.30%) Data Analysis
18 61 (6.46%) Data Strategy
19 58 (6.14%) Continuous Improvement
20 57 (6.03%) Data Integration
Programming Languages
1 796 (84.23%) SQL
2 316 (33.44%) T-SQL
3 188 (19.89%) Python
4 153 (16.19%) Data Analysis Expressions (DAX)
5 114 (12.06%) C#
6 107 (11.32%) PowerShell
7 50 (5.29%) R
8 35 (3.70%) VBA
9 26 (2.75%) Scala
10 19 (2.01%) U-SQL
10 19 (2.01%) VB.NET
11 13 (1.38%) VB
12 12 (1.27%) Java
13 10 (1.06%) JavaScript
13 10 (1.06%) PL/SQL
13 10 (1.06%) X++
14 5 (0.53%) Perl
15 4 (0.42%) ANSI SQL
16 3 (0.32%) Shell Script
17 2 (0.21%) XQuery
Qualifications
1 75 (7.94%) Degree
2 36 (3.81%) Microsoft Certification
3 15 (1.59%) Numerate Degree
4 12 (1.27%) SC Cleared
4 12 (1.27%) Security Cleared
5 7 (0.74%) MCSA
5 7 (0.74%) MCSE
6 5 (0.53%) Computer Science Degree
7 3 (0.32%) MCP
8 2 (0.21%) ITIL Certification
9 1 (0.11%) HND
9 1 (0.11%) ISEB
9 1 (0.11%) MBCS
9 1 (0.11%) MCITP
Quality Assurance & Compliance
1 89 (9.42%) Data Quality
2 36 (3.81%) GDPR
3 27 (2.86%) QA
4 10 (1.06%) SLA
5 5 (0.53%) Accessibility
5 5 (0.53%) GRC
6 4 (0.42%) HL7
7 2 (0.21%) PCI DSS
8 1 (0.11%) GxP
8 1 (0.11%) ISO/IEC 27001
System Software
1 17 (1.80%) Docker
1 17 (1.80%) VMware Infrastructure
2 7 (0.74%) Active Directory
3 5 (0.53%) Hyper-V
4 4 (0.42%) HDFS
5 3 (0.32%) VirtualBox
Systems Management
1 15 (1.59%) Terraform
2 11 (1.16%) Ansible
3 9 (0.95%) Kubernetes
4 8 (0.85%) Grafana
5 3 (0.32%) Docker Swarm
5 3 (0.32%) Perfmon
6 1 (0.11%) Failover Clustering
6 1 (0.11%) Kibana
6 1 (0.11%) Nagios
Vendors
1 522 (55.24%) Microsoft
2 142 (15.03%) Databricks
3 46 (4.87%) Salesforce.com
4 44 (4.66%) Alteryx
4 44 (4.66%) Oracle
5 40 (4.23%) Google
6 30 (3.17%) IBM
6 30 (3.17%) SAP
7 23 (2.43%) VMware
8 21 (2.22%) Teradata
9 11 (1.16%) GoldenSource
9 11 (1.16%) Informatica
9 11 (1.16%) JD Edwards
9 11 (1.16%) Talend
10 8 (0.85%) Cognos
11 7 (0.74%) DataFlux
11 7 (0.74%) RedGate
12 5 (0.53%) IFS
12 5 (0.53%) RapidMiner
13 4 (0.42%) Intapp