Period
to 4 July 2020

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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
4 Jul 2020
Same period 2019 Same period 2018
Rank 262 227 207
Rank change year-on-year -35 -20 +4
Permanent jobs citing SQL Server Analysis Services 944 2,222 3,005
As % of all permanent jobs advertised in the UK 1.20% 1.51% 1.69%
As % of the Database & Business Intelligence category 4.44% 5.46% 5.54%
Number of salaries quoted 869 2,104 2,831
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £36,250 £36,750 £32,500
90th Percentile £87,500 £80,000 £71,250
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +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 21,264 40,681 54,273
As % of all permanent IT jobs advertised in the UK 26.95% 27.71% 30.56%
Number of salaries quoted 17,325 33,322 44,432
Median annual salary £55,000 £52,000 £50,000
Median salary % change year-on-year +5.77% +4.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £90,000 £85,000 £80,250
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

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 4 July 2020.

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 4 July 2020. 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 -32 892 £55,000 +4.76% 40
UK excluding London +30 480 £47,500 +5.56% 26
London -78 451 £70,000 +16.67% 15
North of England +2 121 £45,000 - 4
Midlands +71 120 £50,000 +11.11% 8
South East +48 97 £50,000 - 6
West Midlands +83 87 £52,000 +4.00% 7
North West +28 74 £48,000 +12.94% 2
South West +81 53 £47,500 +5.56% 4
East of England +57 48 £46,250 -2.63% 3
Work from Home -12 46 £45,000 -10.00% 2
East Midlands +28 33 £45,000 +1.12% 1
Yorkshire +2 28 £42,500 -5.56% 2
Scotland +49 27 £50,000 +9.89%
North East +24 19 £40,000 +1.27%
Wales +13 11 £40,000 +8.84% 1
Northern Ireland +24 2 £40,000 -

For the 6 months to 4 July 2020, 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 770 (81.57%) SQL Server Integration Services
2 721 (76.38%) SQL
3 714 (75.64%) SQL Server
4 697 (73.83%) Business Intelligence
5 648 (68.64%) SQL Server Reporting Services
6 532 (56.36%) Power BI
6 532 (56.36%) Power Platform
7 500 (52.97%) Microsoft
8 478 (50.64%) Data Warehouse
9 466 (49.36%) Azure
10 326 (34.53%) Finance
11 321 (34.00%) Agile Software Development
12 295 (31.25%) T-SQL
13 288 (30.51%) ETL
14 229 (24.26%) Microsoft Analysis Services
15 218 (23.09%) Data Modelling
16 207 (21.93%) .NET
17 206 (21.82%) Analytics
18 185 (19.60%) C#
19 169 (17.90%) Data Analysis Expressions (DAX)
20 145 (15.36%) Visualisation
21 143 (15.15%) Analytical Skills
22 140 (14.83%) Data Lake
23 137 (14.51%) Azure SQL Database
24 136 (14.41%) Tableau
25 120 (12.71%) ASP.NET
25 120 (12.71%) DevOps
26 119 (12.61%) Python
27 116 (12.29%) Azure Data Factory
28 111 (11.76%) 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 25 (2.65%) SharePoint
2 16 (1.69%) SAS
3 9 (0.95%) Apache Spark
4 6 (0.64%) Apache
4 6 (0.64%) Confluence
5 5 (0.53%) BizTalk Server
5 5 (0.53%) CMS
5 5 (0.53%) EPiServer
6 3 (0.32%) Apache Synapse
6 3 (0.32%) Oracle SOA Suite
6 3 (0.32%) Tomcat
7 2 (0.21%) SharePoint Server
7 2 (0.21%) WebLogic
8 1 (0.11%) Apache Pig
8 1 (0.11%) Elasticsearch
8 1 (0.11%) IIS
8 1 (0.11%) WebSphere
Applications
1 78 (8.26%) Microsoft Excel
2 26 (2.75%) Microsoft Office
3 9 (0.95%) Microsoft PowerPoint
4 4 (0.42%) Spreadsheet
5 3 (0.32%) MS Visio
6 2 (0.21%) Chatbot
Business Applications
1 8 (0.85%) Dynamics AX
2 6 (0.64%) Dynamics CRM
2 6 (0.64%) NetSuite
3 5 (0.53%) Infor SunSystems
3 5 (0.53%) iTrent
4 4 (0.42%) Exchequer
5 2 (0.21%) Line 500
5 2 (0.21%) Markit EDM
5 2 (0.21%) Raiser's Edge
5 2 (0.21%) thinkFolio
6 1 (0.11%) Dynamics NAV
6 1 (0.11%) Elite 3E
6 1 (0.11%) Oracle Financials
6 1 (0.11%) Oracle General Ledger
6 1 (0.11%) RiskWrite
6 1 (0.11%) Sage 200
Cloud Services
1 532 (56.36%) Power Platform
2 466 (49.36%) Azure
3 116 (12.29%) Azure Data Factory
4 107 (11.33%) AWS
5 53 (5.61%) PaaS
6 43 (4.56%) SaaS
7 28 (2.97%) Dynamics 365
8 23 (2.44%) Data Lake Analytics
9 21 (2.22%) IaaS
10 17 (1.80%) PowerApps
11 15 (1.59%) Azure Machine Learning
11 15 (1.59%) GCP
12 12 (1.27%) Azure Stack
13 11 (1.17%) Serverless
14 7 (0.74%) Logic Apps
14 7 (0.74%) Office 365
15 4 (0.42%) Azure Active Directory
15 4 (0.42%) Power Automate
16 2 (0.21%) IBM Cloud
16 2 (0.21%) NuGet
Communications & Networking
1 2 (0.21%) Internet
1 2 (0.21%) Intranet
1 2 (0.21%) Kerberos
2 1 (0.11%) Broadband
2 1 (0.11%) DHCP
2 1 (0.11%) DNS
2 1 (0.11%) SAN
2 1 (0.11%) Skype
2 1 (0.11%) TCP/IP
2 1 (0.11%) VPN
2 1 (0.11%) WAN
Database & Business Intelligence
1 770 (81.57%) SQL Server Integration Services
2 714 (75.64%) SQL Server
3 648 (68.64%) SQL Server Reporting Services
4 532 (56.36%) Power BI
5 478 (50.64%) Data Warehouse
6 229 (24.26%) Microsoft Analysis Services
7 140 (14.83%) Data Lake
8 137 (14.51%) Azure SQL Database
9 101 (10.70%) OLAP
10 83 (8.79%) Big Data
11 72 (7.63%) Azure SQL Data Warehouse
12 70 (7.42%) MySQL
13 68 (7.20%) QlikView
14 66 (6.99%) SQL Server 2016
15 60 (6.36%) MongoDB
16 53 (5.61%) Relational Database
17 50 (5.30%) Redis
18 45 (4.77%) SQL Server 2012
19 44 (4.66%) Snowflake Schema
20 41 (4.34%) NoSQL
Development Applications
1 64 (6.78%) TeamCity
2 59 (6.25%) Git (software)
3 58 (6.14%) Octopus Deploy
4 53 (5.61%) Visual Studio
5 45 (4.77%) MSBuild
6 33 (3.50%) SQL Server Management Studio (SSMS)
7 27 (2.86%) Team Foundation Server
8 18 (1.91%) JIRA
9 13 (1.38%) Visual Studio Team System
10 10 (1.06%) NUnit
10 10 (1.06%) Visual Studio Code
11 8 (0.85%) Eclipse
12 6 (0.64%) ERwin
12 6 (0.64%) Selenium
13 5 (0.53%) ER Studio
13 5 (0.53%) GDB
13 5 (0.53%) PyCharm
13 5 (0.53%) Sourcetree
13 5 (0.53%) Subversion
14 4 (0.42%) GitLab
General
1 326 (34.53%) Finance
2 52 (5.51%) Front Office
3 28 (2.97%) Retail
4 26 (2.75%) Law
5 23 (2.44%) Marketing
6 13 (1.38%) Back Office
7 10 (1.06%) Legal
8 8 (0.85%) Banking
9 7 (0.74%) Games
10 5 (0.53%) Public Sector
11 4 (0.42%) Financial Institution
11 4 (0.42%) Local Government
11 4 (0.42%) Manufacturing
12 3 (0.32%) Pharmaceutical
13 2 (0.21%) Advertising
13 2 (0.21%) Automotive
13 2 (0.21%) Police
14 1 (0.11%) Electronics
14 1 (0.11%) Housing Association
14 1 (0.11%) Telecoms
Job Titles
1 553 (58.58%) Developer
2 334 (35.38%) Business Intelligence Developer
3 137 (14.51%) SQL Developer
4 107 (11.33%) Analyst
5 93 (9.85%) DBA
6 80 (8.47%) .NET Developer
7 75 (7.94%) Data Engineer
8 71 (7.52%) SQL DBA
9 69 (7.31%) Data Warehouse Developer
10 68 (7.20%) Business Developer
11 65 (6.89%) SQL BI Developer
12 64 (6.78%) Senior Developer
13 56 (5.93%) Administrator
13 56 (5.93%) SSIS Developer
14 51 (5.40%) Senior Business Intelligence Developer
15 49 (5.19%) Business Intelligence Analyst
15 49 (5.19%) Consultant
15 49 (5.19%) SQL Server Developer
16 48 (5.08%) Power BI Developer
17 47 (4.98%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 207 (21.93%) .NET
2 120 (12.71%) ASP.NET
3 106 (11.23%) MDX
4 92 (9.75%) AngularJS
5 71 (7.52%) Web Services
6 65 (6.89%) React
7 61 (6.46%) .NET Core
8 55 (5.83%) HTML
9 53 (5.61%) CSS
10 43 (4.56%) XML
11 30 (3.18%) ASP.NET Web API
12 28 (2.97%) HTML5
13 24 (2.54%) REST
14 23 (2.44%) .NET Framework
15 21 (2.22%) ASP.NET MVC
16 19 (2.01%) SOAP
17 16 (1.69%) JSON
18 14 (1.48%) ASP.NET Web Forms
19 13 (1.38%) Entity Framework
19 13 (1.38%) RESTful
Miscellaneous
1 143 (15.15%) Analytical Skills
2 53 (5.61%) Greenfield Project
3 50 (5.30%) Data Structures
3 50 (5.30%) Reinsurance
4 37 (3.92%) Management Information System
5 24 (2.54%) AS400
5 24 (2.54%) iSeries
6 18 (1.91%) Clustering
7 13 (1.38%) Enterprise Software
7 13 (1.38%) Hedge funds
7 13 (1.38%) Tandem
8 9 (0.95%) Foreign Exchange (FX)
8 9 (0.95%) Replication
9 8 (0.85%) Fixed Income
10 7 (0.74%) Data Centre
10 7 (0.74%) Self-Motivation
11 6 (0.64%) Augmented Reality
11 6 (0.64%) Derivative
11 6 (0.64%) Interest Rate Derivative
12 5 (0.53%) N-Tier
Operating Systems
1 32 (3.39%) Windows
2 20 (2.12%) Windows Server
3 15 (1.59%) Linux
4 8 (0.85%) Unix
5 6 (0.64%) Android
5 6 (0.64%) Apple iOS
6 3 (0.32%) Solaris
7 1 (0.11%) AIX
7 1 (0.11%) HPUX
7 1 (0.11%) MVS
7 1 (0.11%) Windows Server 2012
Processes & Methodologies
1 697 (73.83%) Business Intelligence
2 321 (34.00%) Agile Software Development
3 288 (30.51%) ETL
4 218 (23.09%) Data Modelling
5 206 (21.82%) Analytics
6 145 (15.36%) Visualisation
7 120 (12.71%) DevOps
8 111 (11.76%) Data Visualisation
9 99 (10.49%) Machine Learning
10 91 (9.64%) Data Management
11 86 (9.11%) Scrum
12 81 (8.58%) Artificial Intelligence
12 81 (8.58%) Problem-Solving
13 76 (8.05%) Data Analysis
13 76 (8.05%) Data Analytics
14 74 (7.84%) Performance Tuning
15 73 (7.73%) Data Engineering
15 73 (7.73%) Migration
15 73 (7.73%) Stakeholder Management
16 69 (7.31%) Software Engineering
Programming Languages
1 721 (76.38%) SQL
2 295 (31.25%) T-SQL
3 185 (19.60%) C#
4 169 (17.90%) Data Analysis Expressions (DAX)
5 119 (12.61%) Python
6 92 (9.75%) JavaScript
7 69 (7.31%) PowerShell
8 61 (6.46%) R
9 50 (5.30%) F#
10 44 (4.66%) VB.NET
11 26 (2.75%) Java
12 24 (2.54%) RPG
13 22 (2.33%) VBA
14 20 (2.12%) U-SQL
15 17 (1.80%) PL/SQL
16 8 (0.85%) VB
17 7 (0.74%) TypeScript
18 6 (0.64%) Scala
19 4 (0.42%) C++
20 2 (0.21%) C
Qualifications
1 79 (8.37%) Degree
2 35 (3.71%) Computer Science Degree
3 17 (1.80%) Microsoft Certification
4 7 (0.74%) Numerate Degree
5 6 (0.64%) ISEB
6 5 (0.53%) Master's Degree
6 5 (0.53%) MCSA
6 5 (0.53%) Security Cleared
7 4 (0.42%) MBCS
8 2 (0.21%) MCDBA
8 2 (0.21%) MCSE
8 2 (0.21%) Oracle Certification
8 2 (0.21%) PMI Certification
8 2 (0.21%) SC Cleared
9 1 (0.11%) MCITP
9 1 (0.11%) MCTS
9 1 (0.11%) PRINCE2 Certification
Quality Assurance & Compliance
1 66 (6.99%) Data Quality
2 20 (2.12%) QA
3 12 (1.27%) GDPR
3 12 (1.27%) SLA
4 8 (0.85%) PCI DSS
5 5 (0.53%) UCITS
6 3 (0.32%) Solvency II
7 2 (0.21%) ISO/IEC 27001
8 1 (0.11%) ISO/IEC 20000
8 1 (0.11%) PMO
System Software
1 24 (2.54%) Active Directory
2 4 (0.42%) Virtual Machines
3 3 (0.32%) Docker
4 2 (0.21%) Hyper-V
4 2 (0.21%) VMware Infrastructure
5 1 (0.11%) Citrix Hypervisor
5 1 (0.11%) Firmware
5 1 (0.11%) KVM
5 1 (0.11%) Virtual Servers
Systems Management
1 4 (0.42%) Kubernetes
2 2 (0.21%) Ansible
2 2 (0.21%) Data Guard
2 2 (0.21%) Oracle RMAN
3 1 (0.11%) Kibana
3 1 (0.11%) Microsoft Clustering
Vendors
1 500 (52.97%) Microsoft
2 136 (14.41%) Tableau
3 81 (8.58%) Databricks
4 72 (7.63%) Oracle
5 33 (3.50%) Cognos
6 26 (2.75%) IBM
7 23 (2.44%) Google
7 23 (2.44%) ServiceNow
8 18 (1.91%) Hortonworks
9 15 (1.59%) SAP
10 14 (1.48%) Informatica
10 14 (1.48%) MicroStrategy
11 13 (1.38%) Teradata
12 12 (1.27%) Talend
13 11 (1.17%) Sage
14 9 (0.95%) Sun
15 8 (0.85%) VMware
16 7 (0.74%) JD Edwards
16 7 (0.74%) Netezza
17 6 (0.64%) RedGate