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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
9 Apr 2020
Same period 2019 Same period 2018
Rank 273 252 209
Rank change year-on-year -21 -43 +10
Permanent jobs citing SQL Server Analysis Services 1,334 2,037 2,929
As % of all permanent jobs advertised in the UK 1.16% 1.37% 1.65%
As % of the Database & Business Intelligence category 4.34% 4.83% 5.39%
Number of salaries quoted 1,249 1,853 2,747
Median annual salary £55,000 £50,000 £49,000
Median salary % change year-on-year +10.00% +2.04% -2.00%
10th Percentile £37,500 £35,000 £32,500
90th Percentile £87,500 £77,500 £69,250
UK excluding London median annual salary £46,799 £45,000 £45,000
% change year-on-year +4.00% - -

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 30,703 42,187 54,314
As % of all permanent IT jobs advertised in the UK 26.66% 28.31% 30.65%
Number of salaries quoted 25,095 34,584 45,285
Median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,500
90th Percentile £87,500 £85,000 £80,000
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +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 9 April 2020.

Salary histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 18 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 9 April 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 -25 1,247 £55,000 +10.00% 173
UK excluding London +10 673 £46,799 +4.00% 146
London -38 641 £70,000 +16.67% 32
North of England -21 186 £45,000 +5.88% 36
South East +29 157 £48,000 -4.00% 23
North West +37 124 £47,750 +13.69% 13
Midlands +3 113 £50,000 +11.73% 52
South West +76 83 £45,000 +7.14% 15
West Midlands +63 74 £50,500 +1.00% 46
East of England -11 62 £47,000 -1.05% 15
Work from Home -32 46 £46,250 -11.90% 7
Yorkshire -33 44 £42,500 -10.53% 18
East Midlands -21 39 £46,799 +10.12% 6
Scotland +10 33 £50,000 +10.50% 1
Wales -4 26 £39,250 +21.85% 3
North East +4 18 £40,000 +1.27% 5
Northern Ireland +30 12 £45,000 - 1
Isle of Man - 1 £37,500 -

For the 6 months to 9 April 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 1,076 (80.66%) SQL Server Integration Services
2 1,036 (77.66%) SQL
3 1,006 (75.41%) SQL Server
4 944 (70.76%) SQL Server Reporting Services
5 915 (68.59%) Business Intelligence
6 693 (51.95%) Data Warehouse
7 688 (51.57%) Power BI
7 688 (51.57%) Power Platform
8 651 (48.80%) Microsoft
9 562 (42.13%) Azure
10 464 (34.78%) Finance
11 452 (33.88%) T-SQL
12 399 (29.91%) ETL
13 385 (28.86%) Agile Software Development
14 334 (25.04%) Microsoft Analysis Services
15 284 (21.29%) C#
16 275 (20.61%) .NET
17 263 (19.72%) Analytics
18 228 (17.09%) Data Modelling
19 211 (15.82%) Analytical Skills
20 206 (15.44%) Data Analysis Expressions (DAX)
21 181 (13.57%) Visualisation
22 161 (12.07%) Tableau
23 157 (11.77%) DevOps
24 152 (11.39%) AWS
25 151 (11.32%) Azure SQL Database
26 149 (11.17%) Migration
27 147 (11.02%) Python
28 136 (10.19%) Data Visualisation
29 131 (9.82%) Machine Learning

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 52 (3.90%) SharePoint
2 36 (2.70%) SAS
3 18 (1.35%) Apache Spark
4 11 (0.82%) BizTalk Server
4 11 (0.82%) IIS
5 10 (0.75%) Tomcat
6 9 (0.67%) Confluence
7 6 (0.45%) Apache
8 4 (0.30%) Oracle SOA Suite
9 3 (0.22%) Apache Synapse
9 3 (0.22%) Oracle Service Bus
10 2 (0.15%) Apache Pig
10 2 (0.15%) SharePoint 2013
10 2 (0.15%) SharePoint Server
10 2 (0.15%) WebLogic
11 1 (0.075%) Elasticsearch
Applications
1 105 (7.87%) Microsoft Excel
2 33 (2.47%) Microsoft Office
3 10 (0.75%) Microsoft PowerPoint
4 4 (0.30%) MS Visio
5 2 (0.15%) Chatbot
5 2 (0.15%) Spreadsheet
6 1 (0.075%) SPSS
Business Applications
1 20 (1.50%) Dynamics AX
2 13 (0.97%) Dynamics NAV
3 11 (0.82%) NetSuite
4 8 (0.60%) Dynamics CRM
5 5 (0.37%) Infor SunSystems
5 5 (0.37%) iTrent
5 5 (0.37%) RiskWrite
6 4 (0.30%) Exchequer
7 2 (0.15%) Markit EDM
7 2 (0.15%) Raiser's Edge
7 2 (0.15%) Sage 200
7 2 (0.15%) Softmar
7 2 (0.15%) thinkFolio
8 1 (0.075%) Cognos Business Intelligence
8 1 (0.075%) Elite 3E
Cloud Services
1 688 (51.57%) Power Platform
2 562 (42.13%) Azure
3 152 (11.39%) AWS
4 131 (9.82%) Azure Data Factory
5 61 (4.57%) PaaS
6 39 (2.92%) SaaS
7 36 (2.70%) Dynamics 365
8 28 (2.10%) IaaS
9 24 (1.80%) Data Lake Analytics
10 18 (1.35%) Azure Stack
11 16 (1.20%) GCP
12 14 (1.05%) PowerApps
13 13 (0.97%) Serverless
14 12 (0.90%) Office 365
15 9 (0.67%) Azure Machine Learning
16 6 (0.45%) Azure Active Directory
16 6 (0.45%) Azure Functions
16 6 (0.45%) GitHub
17 3 (0.22%) Amazon EC2
17 3 (0.22%) Amazon S3
Communications & Networking
1 6 (0.45%) Internet
2 2 (0.15%) DHCP
2 2 (0.15%) DNS
2 2 (0.15%) Intranet
2 2 (0.15%) Kerberos
2 2 (0.15%) SAN
2 2 (0.15%) VPN
3 1 (0.075%) DOCSIS
3 1 (0.075%) FTP
3 1 (0.075%) Skype
Database & Business Intelligence
1 1,076 (80.66%) SQL Server Integration Services
2 1,006 (75.41%) SQL Server
3 944 (70.76%) SQL Server Reporting Services
4 693 (51.95%) Data Warehouse
5 688 (51.57%) Power BI
6 334 (25.04%) Microsoft Analysis Services
7 151 (11.32%) Azure SQL Database
8 130 (9.75%) Data Lake
9 104 (7.80%) MySQL
10 101 (7.57%) QlikView
11 100 (7.50%) SQL Server 2016
12 99 (7.42%) OLAP
13 93 (6.97%) MongoDB
14 80 (6.00%) Redis
15 78 (5.85%) Big Data
16 77 (5.77%) Relational Database
17 73 (5.47%) Azure SQL Data Warehouse
18 71 (5.32%) SQL Server 2012
19 55 (4.12%) NoSQL
19 55 (4.12%) SQL Server 2017
Development Applications
1 75 (5.62%) TeamCity
2 74 (5.55%) Octopus Deploy
3 65 (4.87%) Team Foundation Server
4 61 (4.57%) MSBuild
5 60 (4.50%) Visual Studio
6 58 (4.35%) SQL Server Management Studio (SSMS)
7 43 (3.22%) Git (software)
8 40 (3.00%) Visual Studio Team System
9 25 (1.87%) JIRA
10 11 (0.82%) Eclipse
11 8 (0.60%) NUnit
11 8 (0.60%) Subversion
12 7 (0.52%) Visual Studio Code
13 6 (0.45%) ERwin
14 4 (0.30%) Jenkins
14 4 (0.30%) MSTest
14 4 (0.30%) Selenium
15 3 (0.22%) GDB
15 3 (0.22%) Moq
15 3 (0.22%) PyCharm
General
1 464 (34.78%) Finance
2 78 (5.85%) Front Office
3 50 (3.75%) Retail
4 42 (3.15%) Marketing
5 31 (2.32%) Legal
6 26 (1.95%) Law
7 18 (1.35%) Banking
8 15 (1.12%) Telecoms
9 12 (0.90%) Public Sector
10 9 (0.67%) Back Office
11 8 (0.60%) Advertising
11 8 (0.60%) Games
12 7 (0.52%) Manufacturing
13 4 (0.30%) Automotive
13 4 (0.30%) Electronics
13 4 (0.30%) Financial Institution
13 4 (0.30%) Investment Banking
14 3 (0.22%) Local Government
15 2 (0.15%) Police
16 1 (0.075%) Housing Association
Job Titles
1 708 (53.07%) Developer
2 392 (29.39%) Business Intelligence Developer
3 183 (13.72%) Analyst
4 165 (12.37%) DBA
5 160 (11.99%) SQL Developer
6 131 (9.82%) SQL DBA
7 118 (8.85%) .NET Developer
8 92 (6.90%) Administrator
9 78 (5.85%) Senior Developer
10 77 (5.77%) Business Developer
10 77 (5.77%) Business Intelligence Analyst
10 77 (5.77%) SQL Analyst
11 71 (5.32%) Consultant
12 61 (4.57%) Data Engineer
13 60 (4.50%) Data Analyst
14 56 (4.20%) Business Intelligence Lead
15 53 (3.97%) Architect
16 52 (3.90%) SQL BI Developer
17 49 (3.67%) SSIS Developer
18 48 (3.60%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 275 (20.61%) .NET
2 131 (9.82%) ASP.NET
3 122 (9.15%) AngularJS
4 120 (9.00%) MDX
5 93 (6.97%) React
6 92 (6.90%) Web Services
7 89 (6.67%) .NET Core
8 64 (4.80%) XML
9 44 (3.30%) HTML
10 37 (2.77%) CSS
11 22 (1.65%) .NET Framework
11 22 (1.65%) ASP.NET MVC
12 18 (1.35%) Kafka
13 16 (1.20%) ASP.NET Web API
13 16 (1.20%) HTML5
13 16 (1.20%) REST
13 16 (1.20%) RESTful
14 13 (0.97%) JSON
15 12 (0.90%) jQuery
15 12 (0.90%) SOAP
Miscellaneous
1 211 (15.82%) Analytical Skills
2 76 (5.70%) Reinsurance
3 62 (4.65%) Data Structures
4 54 (4.05%) Management Information System
5 41 (3.07%) Greenfield Project
6 40 (3.00%) AS400
6 40 (3.00%) iSeries
7 30 (2.25%) Clustering
8 27 (2.02%) Tandem
9 22 (1.65%) Data Centre
10 21 (1.57%) Replication
11 20 (1.50%) Self-Motivation
12 11 (0.82%) Enterprise Software
12 11 (0.82%) Hedge funds
13 10 (0.75%) Private Cloud
14 8 (0.60%) Client/Server
14 8 (0.60%) Fixed Income
14 8 (0.60%) Public Cloud
15 6 (0.45%) Foreign Exchange (FX)
15 6 (0.45%) User Experience
Operating Systems
1 60 (4.50%) Windows
2 33 (2.47%) Windows Server
3 12 (0.90%) Linux
4 6 (0.45%) Windows Server 2008
5 4 (0.30%) Android
5 4 (0.30%) Apple iOS
5 4 (0.30%) Windows 7
6 3 (0.22%) Solaris
6 3 (0.22%) Windows Server 2016
7 2 (0.15%) Unix
7 2 (0.15%) Windows 10
7 2 (0.15%) Windows 8
7 2 (0.15%) Windows Server 2012
8 1 (0.075%) AIX
8 1 (0.075%) HPUX
8 1 (0.075%) MVS
8 1 (0.075%) Windows Server 2003
Processes & Methodologies
1 915 (68.59%) Business Intelligence
2 399 (29.91%) ETL
3 385 (28.86%) Agile Software Development
4 263 (19.72%) Analytics
5 228 (17.09%) Data Modelling
6 181 (13.57%) Visualisation
7 157 (11.77%) DevOps
8 149 (11.17%) Migration
9 136 (10.19%) Data Visualisation
10 131 (9.82%) Machine Learning
11 129 (9.67%) Data Management
12 124 (9.30%) Problem-Solving
13 115 (8.62%) Scrum
14 112 (8.40%) Data Analysis
15 107 (8.02%) Artificial Intelligence
16 93 (6.97%) Microservices
17 92 (6.90%) Software Engineering
18 91 (6.82%) Kimball Methodology
19 90 (6.75%) ITIL
20 88 (6.60%) Stakeholder Management
Programming Languages
1 1,036 (77.66%) SQL
2 452 (33.88%) T-SQL
3 284 (21.29%) C#
4 206 (15.44%) Data Analysis Expressions (DAX)
5 147 (11.02%) Python
6 117 (8.77%) JavaScript
7 100 (7.50%) R
8 87 (6.52%) PowerShell
9 80 (6.00%) F#
10 43 (3.22%) Java
11 42 (3.15%) VBA
12 41 (3.07%) VB.NET
13 40 (3.00%) RPG
14 28 (2.10%) PL/SQL
15 19 (1.42%) U-SQL
16 16 (1.20%) VB
17 10 (0.75%) C
18 9 (0.67%) TypeScript
19 8 (0.60%) VBScript
20 7 (0.52%) Scala
Qualifications
1 125 (9.37%) Degree
2 60 (4.50%) Computer Science Degree
3 28 (2.10%) Microsoft Certification
4 21 (1.57%) Numerate Degree
5 11 (0.82%) MCSA
6 8 (0.60%) Security Cleared
7 6 (0.45%) ISEB
8 4 (0.30%) Master's Degree
8 4 (0.30%) MBCS
8 4 (0.30%) MCITP
9 3 (0.22%) ISTQB
9 3 (0.22%) MCP
9 3 (0.22%) MCSD
9 3 (0.22%) MCSE
9 3 (0.22%) Oracle Certification
9 3 (0.22%) SC Cleared
10 2 (0.15%) ITIL Foundation Certificate
11 1 (0.075%) HND
11 1 (0.075%) MCDBA
11 1 (0.075%) PRINCE2 Certification
Quality Assurance & Compliance
1 85 (6.37%) Data Quality
2 56 (4.20%) QA
3 21 (1.57%) PCI DSS
4 20 (1.50%) GDPR
5 18 (1.35%) SLA
6 4 (0.30%) ISO/IEC 27001
7 3 (0.22%) Solvency II
7 3 (0.22%) UCITS
8 2 (0.15%) COBIT
9 1 (0.075%) ISO/IEC 20000
System Software
1 26 (1.95%) Active Directory
2 13 (0.97%) VMware Infrastructure
3 6 (0.45%) Hyper-V
3 6 (0.45%) Virtual Machines
4 3 (0.22%) Docker
5 2 (0.15%) LXC
6 1 (0.075%) Citrix Hypervisor
6 1 (0.075%) Firmware
Systems Management
1 4 (0.30%) Failover Clustering
1 4 (0.30%) Kubernetes
2 3 (0.22%) Data Guard
2 3 (0.22%) Oracle RMAN
2 3 (0.22%) Perfmon
3 2 (0.15%) Ansible
3 2 (0.15%) Puppet
4 1 (0.075%) Ambari
4 1 (0.075%) Hadoop YARN
4 1 (0.075%) HP ALM
4 1 (0.075%) Kibana
4 1 (0.075%) Microsoft Clustering
4 1 (0.075%) Tivoli
4 1 (0.075%) Tivoli Storage Manager
Vendors
1 651 (48.80%) Microsoft
2 161 (12.07%) Tableau
3 100 (7.50%) Oracle
4 87 (6.52%) Databricks
5 44 (3.30%) Cognos
6 34 (2.55%) IBM
7 32 (2.40%) ServiceNow
8 28 (2.10%) Google
9 27 (2.02%) Informatica
10 25 (1.87%) Teradata
11 21 (1.57%) VMware
12 20 (1.50%) RedGate
12 20 (1.50%) SAP
13 13 (0.97%) JD Edwards
13 13 (0.97%) MicroStrategy
14 12 (0.90%) Sage
14 12 (0.90%) Salesforce.com
14 12 (0.90%) Talend
15 10 (0.75%) Sybase
16 9 (0.67%) Infragistics