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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
22 Sep 2020
Same period 2019 Same period 2018
Rank 298 236 221
Rank change year-on-year -62 -15 +11
Permanent jobs citing SQL Server Analysis Services 507 2,002 2,625
As % of all permanent jobs advertised in the UK 1.02% 1.44% 1.58%
As % of the Database & Business Intelligence category 3.59% 5.32% 5.30%
Number of salaries quoted 449 1,885 2,480
Median annual salary £52,500 £55,000 £50,000
Median salary % change year-on-year -4.55% +10.00% +5.26%
10th Percentile £35,000 £36,250 £32,500
90th Percentile £85,000 £80,000 £72,500
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 14,104 37,647 49,488
As % of all permanent IT jobs advertised in the UK 28.32% 27.06% 29.72%
Number of salaries quoted 11,748 30,738 40,369
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £33,750 £31,250 £31,250
90th Percentile £90,000 £85,000 £82,500
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 22 September 2020.

Salary histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 16 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 22 September 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 -53 470 £55,000 - 61
UK excluding London +33 283 £47,500 +5.56% 49
London -107 217 £70,000 +16.67% 19
Midlands +49 82 £50,000 +11.11% 13
North of England +26 71 £45,000 +5.88% 15
West Midlands +45 66 £52,500 +16.67% 7
South East +108 52 £45,000 -10.00% 7
North West +22 38 £45,000 +7.14% 8
Work from Home -2 33 £42,500 -10.53% 8
Yorkshire +53 26 £52,500 +23.53% 7
South West +95 24 £45,000 - 3
Scotland +78 22 £47,500 +4.40% 5
East of England +92 21 £55,000 +15.79% 4
East Midlands +47 16 £35,750 -19.66% 6
Wales +41 10 £34,000 -11.69% 2
North East +25 7 £37,250 -8.59%

For the 6 months to 22 September 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 413 (81.46%) SQL Server Integration Services
2 395 (77.91%) Business Intelligence
3 388 (76.53%) SQL
4 357 (70.41%) SQL Server
5 356 (70.22%) SQL Server Reporting Services
6 311 (61.34%) Power Platform
7 310 (61.14%) Power BI
8 293 (57.79%) Microsoft
9 276 (54.44%) Data Warehouse
10 245 (48.32%) Azure
11 171 (33.73%) ETL
12 169 (33.33%) Finance
13 165 (32.54%) T-SQL
14 164 (32.35%) Agile Software Development
15 154 (30.37%) Data Modelling
16 123 (24.26%) Analytics
17 103 (20.32%) Visualisation
18 98 (19.33%) Microsoft Analysis Services
19 90 (17.75%) .NET
20 86 (16.96%) Data Lake
21 85 (16.77%) Data Analysis Expressions (DAX)
22 78 (15.38%) Azure SQL Database
23 76 (14.99%) C#
24 70 (13.81%) Data Visualisation
25 69 (13.61%) Python
26 67 (13.21%) DevOps
27 63 (12.43%) Analytical Skills
28 62 (12.23%) Tableau
29 57 (11.24%) OLAP
29 57 (11.24%) Data Quality

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 16 (3.16%) SharePoint
2 13 (2.56%) SAS
3 6 (1.18%) Apache
4 5 (0.99%) CMS
4 5 (0.99%) EPiServer
5 4 (0.79%) Apache Synapse
5 4 (0.79%) Confluence
6 3 (0.59%) Apache Airflow
6 3 (0.59%) Drupal
6 3 (0.59%) Elasticsearch
6 3 (0.59%) nginx
7 2 (0.39%) Apache Spark
7 2 (0.39%) BizTalk Server
7 2 (0.39%) IIS
7 2 (0.39%) Oracle SOA Suite
8 1 (0.20%) Apache Pig
8 1 (0.20%) Jupyter
8 1 (0.20%) WebSphere
Applications
1 54 (10.65%) Microsoft Excel
2 10 (1.97%) Microsoft Office
3 8 (1.58%) MS Visio
4 4 (0.79%) Spreadsheet
5 3 (0.59%) Microsoft PowerPoint
Business Applications
1 5 (0.99%) Dynamics CRM
2 3 (0.59%) Dynamics AX
2 3 (0.59%) Dynamics NAV
3 2 (0.39%) Line 500
3 2 (0.39%) Markit EDM
3 2 (0.39%) NetSuite
3 2 (0.39%) thinkFolio
4 1 (0.20%) Exchequer
4 1 (0.20%) Oracle Financials
4 1 (0.20%) Oracle General Ledger
Cloud Services
1 311 (61.34%) Power Platform
2 245 (48.32%) Azure
3 56 (11.05%) Azure Data Factory
4 34 (6.71%) AWS
5 25 (4.93%) SaaS
6 16 (3.16%) PaaS
7 15 (2.96%) Azure Machine Learning
8 14 (2.76%) Dynamics 365
8 14 (2.76%) PowerApps
9 11 (2.17%) Data Lake Analytics
10 10 (1.97%) GCP
10 10 (1.97%) Serverless
11 5 (0.99%) Power Automate
12 4 (0.79%) IaaS
12 4 (0.79%) Logic Apps
13 3 (0.59%) Azure Functions
14 2 (0.39%) Google Analytics
14 2 (0.39%) Google Tag Manager
15 1 (0.20%) Cloud Computing
15 1 (0.20%) GitHub
Communications & Networking
1 1 (0.20%) AMQP
1 1 (0.20%) Broadband
1 1 (0.20%) SAN
1 1 (0.20%) Skype
1 1 (0.20%) TCP/IP
1 1 (0.20%) WAN
Database & Business Intelligence
1 413 (81.46%) SQL Server Integration Services
2 357 (70.41%) SQL Server
3 356 (70.22%) SQL Server Reporting Services
4 310 (61.14%) Power BI
5 276 (54.44%) Data Warehouse
6 98 (19.33%) Microsoft Analysis Services
7 86 (16.96%) Data Lake
8 78 (15.38%) Azure SQL Database
9 57 (11.24%) OLAP
10 51 (10.06%) Azure SQL Data Warehouse
11 49 (9.66%) Big Data
12 30 (5.92%) OLTP
13 29 (5.72%) Relational Database
13 29 (5.72%) Snowflake Schema
14 28 (5.52%) SQL Server 2016
15 27 (5.33%) QlikView
16 25 (4.93%) OLAP Cube
17 19 (3.75%) SQL Server 2012
18 18 (3.55%) Enterprise Data Warehouse
19 17 (3.35%) SSDT
Development Applications
1 42 (8.28%) Git (software)
2 39 (7.69%) Visual Studio
3 15 (2.96%) TeamCity
4 12 (2.37%) MSBuild
5 11 (2.17%) JIRA
5 11 (2.17%) SQL Server Management Studio (SSMS)
6 10 (1.97%) Octopus Deploy
7 9 (1.78%) Team Foundation Server
8 8 (1.58%) NUnit
8 8 (1.58%) Selenium
9 6 (1.18%) Visual Studio Code
10 5 (0.99%) Subversion
11 4 (0.79%) GitLab
11 4 (0.79%) Oracle Forms
12 3 (0.59%) Eclipse
12 3 (0.59%) ER Studio
12 3 (0.59%) ERwin
12 3 (0.59%) MSTest
12 3 (0.59%) PyCharm
12 3 (0.59%) SpecFlow
General
1 169 (33.33%) Finance
2 24 (4.73%) Law
3 12 (2.37%) Front Office
3 12 (2.37%) Retail
4 11 (2.17%) Back Office
5 8 (1.58%) Advertising
5 8 (1.58%) Banking
6 7 (1.38%) Public Sector
7 5 (0.99%) Legal
7 5 (0.99%) Manufacturing
8 4 (0.79%) Local Government
8 4 (0.79%) Pharmaceutical
9 3 (0.59%) Marketing
10 2 (0.39%) Police
11 1 (0.20%) Financial Institution
11 1 (0.20%) Housing Association
11 1 (0.20%) iGaming
11 1 (0.20%) Online Betting
Job Titles
1 311 (61.34%) Developer
2 201 (39.64%) Business Intelligence Developer
3 87 (17.16%) SQL Developer
4 60 (11.83%) Analyst
5 55 (10.85%) Senior Developer
6 54 (10.65%) Business Developer
7 50 (9.86%) Data Engineer
8 49 (9.66%) SQL BI Developer
9 48 (9.47%) Senior Business Intelligence Developer
10 47 (9.27%) Data Warehouse Developer
11 40 (7.89%) SQL Server Developer
12 36 (7.10%) Azure Developer
13 31 (6.11%) SSIS Developer
14 30 (5.92%) Power BI Developer
15 29 (5.72%) .NET Developer
15 29 (5.72%) DBA
16 27 (5.33%) Microsoft BI Developer
17 26 (5.13%) SQL Server Data Warehouse Developer
17 26 (5.13%) SSAS Developer
18 25 (4.93%) ETL Developer
Libraries, Frameworks & Software Standards
1 90 (17.75%) .NET
2 54 (10.65%) ASP.NET
3 52 (10.26%) MDX
4 47 (9.27%) HTML
5 41 (8.09%) CSS
6 33 (6.51%) AngularJS
7 29 (5.72%) ASP.NET Web API
7 29 (5.72%) HTML5
7 29 (5.72%) REST
8 24 (4.73%) XML
9 23 (4.54%) .NET Core
10 21 (4.14%) SOAP
11 20 (3.94%) JSON
12 19 (3.75%) .NET Framework
12 19 (3.75%) Web Services
13 18 (3.55%) ASP.NET MVC
14 16 (3.16%) React
15 10 (1.97%) Entity Framework
15 10 (1.97%) RESTful
16 8 (1.58%) WPF
Miscellaneous
1 63 (12.43%) Analytical Skills
2 34 (6.71%) Data Structures
3 26 (5.13%) Greenfield Project
4 22 (4.34%) Management Information System
5 13 (2.56%) Replication
6 12 (2.37%) Reinsurance
7 11 (2.17%) Clustering
8 9 (1.78%) Hedge funds
9 6 (1.18%) Algorithms
9 6 (1.18%) Mobile App
10 5 (0.99%) Augmented Reality
10 5 (0.99%) Enterprise Software
10 5 (0.99%) Equities
10 5 (0.99%) Fixed Income
10 5 (0.99%) Self-Motivation
11 4 (0.79%) Cloud Native
11 4 (0.79%) Derivative
11 4 (0.79%) Foreign Exchange (FX)
11 4 (0.79%) Interest Rate Derivative
11 4 (0.79%) User Experience
Operating Systems
1 17 (3.35%) Windows
2 9 (1.78%) Linux
3 6 (1.18%) Unix
3 6 (1.18%) Windows Server
4 5 (0.99%) Android
4 5 (0.99%) Apple iOS
5 1 (0.20%) MVS
5 1 (0.20%) Red Hat Enterprise Linux
5 1 (0.20%) Windows Server 2008
Processes & Methodologies
1 395 (77.91%) Business Intelligence
2 171 (33.73%) ETL
3 164 (32.35%) Agile Software Development
4 154 (30.37%) Data Modelling
5 123 (24.26%) Analytics
6 103 (20.32%) Visualisation
7 70 (13.81%) Data Visualisation
8 67 (13.21%) DevOps
9 56 (11.05%) Performance Tuning
10 50 (9.86%) Data Analytics
11 47 (9.27%) Data Management
12 46 (9.07%) Problem-Solving
13 45 (8.88%) Dimensional Modelling
14 44 (8.68%) Dashboard Development
15 41 (8.09%) Scrum
16 40 (7.89%) Kimball Methodology
16 40 (7.89%) Stakeholder Management
17 38 (7.50%) Requirements Gathering
18 37 (7.30%) Data Engineering
18 37 (7.30%) Machine Learning
Programming Languages
1 388 (76.53%) SQL
2 165 (32.54%) T-SQL
3 85 (16.77%) Data Analysis Expressions (DAX)
4 76 (14.99%) C#
5 69 (13.61%) Python
6 38 (7.50%) JavaScript
7 34 (6.71%) PowerShell
8 31 (6.11%) R
9 21 (4.14%) PL/SQL
10 16 (3.16%) VB.NET
11 14 (2.76%) Java
12 9 (1.78%) F#
12 9 (1.78%) U-SQL
13 5 (0.99%) VBA
14 4 (0.79%) C++
15 3 (0.59%) RPG
16 2 (0.39%) Scala
17 1 (0.20%) C
17 1 (0.20%) VB
17 1 (0.20%) X++
Qualifications
1 26 (5.13%) Degree
2 11 (2.17%) Microsoft Certification
3 9 (1.78%) Computer Science Degree
4 4 (0.79%) MCITP
5 3 (0.59%) Master's Degree
6 2 (0.39%) MCDBA
6 2 (0.39%) MCSA
6 2 (0.39%) MCTS
6 2 (0.39%) PMI Certification
7 1 (0.20%) ISEB
7 1 (0.20%) MBCS
7 1 (0.20%) Numerate Degree
7 1 (0.20%) SC Cleared
7 1 (0.20%) Security Cleared
Quality Assurance & Compliance
1 57 (11.24%) Data Quality
2 14 (2.76%) QA
3 7 (1.38%) SLA
4 4 (0.79%) GDPR
5 3 (0.59%) EMIR
5 3 (0.59%) MiFID
5 3 (0.59%) UCITS
6 1 (0.20%) PCI DSS
6 1 (0.20%) PMO
6 1 (0.20%) Solvency II
System Software
1 5 (0.99%) Active Directory
2 2 (0.39%) Docker
2 2 (0.39%) VMware Infrastructure
3 1 (0.20%) Hyper-V
3 1 (0.20%) KVM
3 1 (0.20%) Oracle RAC
3 1 (0.20%) Virtual Servers
Systems Management
1 3 (0.59%) HAProxy
2 2 (0.39%) Microsoft Clustering
3 1 (0.20%) Ansible
3 1 (0.20%) Control-M
3 1 (0.20%) Enterprise Manager Cloud Control
3 1 (0.20%) Kubernetes
3 1 (0.20%) Opscode Chef
3 1 (0.20%) Oracle RMAN
3 1 (0.20%) Puppet
3 1 (0.20%) SCOM
3 1 (0.20%) Simpana
3 1 (0.20%) Terraform
Vendors
1 293 (57.79%) Microsoft
2 62 (12.23%) Tableau
3 44 (8.68%) Oracle
4 38 (7.50%) Databricks
5 17 (3.35%) IBM
6 14 (2.76%) Cognos
7 12 (2.37%) SAP
8 11 (2.17%) Google
8 11 (2.17%) Teradata
9 10 (1.97%) Hortonworks
9 10 (1.97%) Informatica
10 6 (1.18%) Xamarin
11 5 (0.99%) Talend
12 4 (0.79%) Aderant
12 4 (0.79%) Sun
12 4 (0.79%) VMware
13 3 (0.59%) Alteryx
13 3 (0.59%) Facebook
13 3 (0.59%) ServiceNow
13 3 (0.59%) SolarWinds