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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
23 Nov 2020
Same period 2019 Same period 2018
Rank 332 267 234
Rank change year-on-year -65 -33 +13
Permanent jobs citing SQL Server Analysis Services 497 1,697 2,398
As % of all permanent jobs advertised in the UK 0.92% 1.26% 1.47%
As % of the Database & Business Intelligence category 3.26% 4.63% 5.04%
Number of salaries quoted 445 1,566 2,245
Median annual salary £50,000 £52,500 £50,000
Median salary % change year-on-year -4.76% +5.00% +5.26%
10th Percentile £32,500 £36,250 £32,500
90th Percentile £78,750 £80,000 £72,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +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 15,250 36,672 47,559
As % of all permanent IT jobs advertised in the UK 28.15% 27.12% 29.20%
Number of salaries quoted 12,977 30,232 39,088
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,500 £31,250
90th Percentile £87,500 £86,250 £83,750
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +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 23 November 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 23 November 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 -62 446 £50,000 -9.09% 76
UK excluding London +28 300 £45,000 - 68
London -99 185 £67,500 +8.00% 16
North of England +67 120 £46,000 +14.93% 27
Midlands +11 62 £45,375 -3.46% 15
Yorkshire +75 58 £52,500 +31.25% 7
North West +47 53 £45,000 +7.64% 18
Work from Home -34 46 £47,500 +5.56% 14
West Midlands +10 42 £50,000 +5.26% 11
South East +90 36 £47,500 - 5
Scotland +76 32 £47,500 +5.56% 7
South West +77 26 £42,500 -5.56% 7
East Midlands +43 20 £33,000 -26.67% 4
East of England +98 18 £50,000 +5.26% 6
North East +23 9 £37,500 - 2
Wales +41 8 £34,000 -10.53% 1

For the 6 months to 23 November 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 431 (86.72%) SQL Server Integration Services
2 406 (81.69%) SQL
3 384 (77.26%) Business Intelligence
4 380 (76.46%) SQL Server Reporting Services
5 343 (69.01%) SQL Server
6 304 (61.17%) Data Warehouse
7 281 (56.54%) Power Platform
8 280 (56.34%) Power BI
9 270 (54.33%) Microsoft
10 222 (44.67%) Azure
11 190 (38.23%) ETL
12 176 (35.41%) T-SQL
13 137 (27.57%) Analytics
14 133 (26.76%) Finance
15 127 (25.55%) Agile Software Development
16 118 (23.74%) Visualisation
17 113 (22.74%) Data Modelling
18 87 (17.51%) Python
19 83 (16.70%) Azure SQL Database
20 80 (16.10%) Data Visualisation
21 79 (15.90%) Azure Data Factory
22 78 (15.69%) Microsoft Analysis Services
23 67 (13.48%) Data Lake
24 66 (13.28%) Azure SQL Data Warehouse
25 62 (12.47%) Analytical Skills
26 58 (11.67%) Performance Tuning
27 56 (11.27%) Data Analysis Expressions (DAX)
28 55 (11.07%) Microsoft Excel
29 54 (10.87%) Problem-Solving
30 53 (10.66%) C#

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 18 (3.62%) SAS
2 13 (2.62%) SharePoint
3 9 (1.81%) Apache
3 9 (1.81%) Apache Spark
4 7 (1.41%) Apache Airflow
4 7 (1.41%) Apache Synapse
5 5 (1.01%) CMS
5 5 (1.01%) Drupal
5 5 (1.01%) Elasticsearch
5 5 (1.01%) EPiServer
5 5 (1.01%) IIS
5 5 (1.01%) nginx
6 2 (0.40%) Confluence
7 1 (0.20%) Apache Pig
7 1 (0.20%) BizTalk Server
7 1 (0.20%) Jupyter
7 1 (0.20%) WebSphere
Applications
1 55 (11.07%) Microsoft Excel
2 10 (2.01%) Microsoft Office
3 8 (1.61%) MS Visio
4 2 (0.40%) Microsoft PowerPoint
4 2 (0.40%) Spreadsheet
Business Applications
1 3 (0.60%) Dynamics AX
1 3 (0.60%) Dynamics NAV
2 2 (0.40%) Dynamics CRM
2 2 (0.40%) Line 500
3 1 (0.20%) NetSuite
3 1 (0.20%) Salesforce.com CRM
Cloud Services
1 281 (56.54%) Power Platform
2 222 (44.67%) Azure
3 79 (15.90%) Azure Data Factory
4 46 (9.26%) AWS
5 21 (4.23%) PaaS
6 15 (3.02%) SaaS
7 13 (2.62%) GCP
8 12 (2.41%) IaaS
9 11 (2.21%) Dynamics 365
10 10 (2.01%) Azure Machine Learning
11 7 (1.41%) Data Lake Analytics
12 6 (1.21%) Amazon Kinesis
12 6 (1.21%) PowerApps
13 5 (1.01%) Azure Stack
14 3 (0.60%) Azure Functions
14 3 (0.60%) Google Analytics
14 3 (0.60%) Logic Apps
14 3 (0.60%) Serverless
15 2 (0.40%) Google Tag Manager
15 2 (0.40%) Office 365
Communications & Networking
1 1 (0.20%) AMQP
1 1 (0.20%) Kerberos
1 1 (0.20%) SAN
1 1 (0.20%) TCP/IP
1 1 (0.20%) WAN
Database & Business Intelligence
1 431 (86.72%) SQL Server Integration Services
2 380 (76.46%) SQL Server Reporting Services
3 343 (69.01%) SQL Server
4 304 (61.17%) Data Warehouse
5 280 (56.34%) Power BI
6 83 (16.70%) Azure SQL Database
7 78 (15.69%) Microsoft Analysis Services
8 67 (13.48%) Data Lake
9 66 (13.28%) Azure SQL Data Warehouse
10 51 (10.26%) Tableau
11 40 (8.05%) OLAP
12 31 (6.24%) OLTP
12 31 (6.24%) QlikView
13 24 (4.83%) Relational Database
14 21 (4.23%) OLAP Cube
15 20 (4.02%) Big Data
16 18 (3.62%) SQL Server 2008
17 17 (3.42%) BusinessObjects
18 16 (3.22%) SQL Server 2016
19 15 (3.02%) Qlik Sense
Development Applications
1 29 (5.84%) Visual Studio
2 20 (4.02%) Git (software)
3 8 (1.61%) JIRA
4 7 (1.41%) Team Foundation Server
5 6 (1.21%) TeamCity
6 5 (1.01%) SQL Server Management Studio (SSMS)
7 4 (0.80%) Eclipse
7 4 (0.80%) Oracle Forms
8 3 (0.60%) Cucumber
8 3 (0.60%) Jenkins
8 3 (0.60%) Selenium
8 3 (0.60%) SpecFlow
9 2 (0.40%) ER Studio
9 2 (0.40%) ERwin
9 2 (0.40%) Octopus Deploy
9 2 (0.40%) PowerDesigner
9 2 (0.40%) PyCharm
9 2 (0.40%) Subversion
10 1 (0.20%) GitLab
10 1 (0.20%) webpack
General
1 133 (26.76%) Finance
2 28 (5.63%) Law
3 26 (5.23%) Retail
4 20 (4.02%) Public Sector
5 10 (2.01%) Back Office
5 10 (2.01%) Banking
5 10 (2.01%) Manufacturing
6 8 (1.61%) Marketing
7 7 (1.41%) Advertising
8 4 (0.80%) Front Office
8 4 (0.80%) Pharmaceutical
9 3 (0.60%) Housing Association
9 3 (0.60%) Local Government
10 2 (0.40%) Financial Institution
10 2 (0.40%) Legal
10 2 (0.40%) Publishing
11 1 (0.20%) General Ledger
11 1 (0.20%) iGaming
11 1 (0.20%) Online Betting
11 1 (0.20%) Police
Job Titles
1 268 (53.92%) Developer
2 181 (36.42%) Business Intelligence Developer
3 69 (13.88%) Analyst
4 68 (13.68%) SQL Developer
5 46 (9.26%) Data Engineer
5 46 (9.26%) Senior Developer
6 40 (8.05%) Senior Business Intelligence Developer
7 39 (7.85%) Business Developer
7 39 (7.85%) DBA
7 39 (7.85%) SQL BI Developer
7 39 (7.85%) SQL DBA
8 36 (7.24%) Data Warehouse Developer
9 35 (7.04%) SQL Server Developer
10 33 (6.64%) Azure Developer
11 32 (6.44%) SSIS Developer
12 30 (6.04%) Microsoft BI Developer
13 27 (5.43%) Architect
13 27 (5.43%) Power BI Developer
14 26 (5.23%) Data Analyst
15 24 (4.83%) Consultant
Libraries, Frameworks & Software Standards
1 37 (7.44%) .NET
1 37 (7.44%) MDX
2 29 (5.84%) REST
3 24 (4.83%) SOAP
4 23 (4.63%) XML
5 22 (4.43%) CSS
5 22 (4.43%) HTML
6 17 (3.42%) ASP.NET
7 15 (3.02%) JSON
8 13 (2.62%) AngularJS
9 11 (2.21%) HTML5
9 11 (2.21%) Web Services
10 10 (2.01%) .NET Framework
10 10 (2.01%) Kafka
11 9 (1.81%) .NET Core
11 9 (1.81%) ASP.NET Web API
11 9 (1.81%) CSS3
11 9 (1.81%) Entity Framework
12 7 (1.41%) Twitter Bootstrap
13 6 (1.21%) React
Miscellaneous
1 62 (12.47%) Analytical Skills
2 38 (7.65%) Data Structures
3 24 (4.83%) Management Information System
4 21 (4.23%) Greenfield Project
5 19 (3.82%) Clustering
6 17 (3.42%) Replication
7 12 (2.41%) Hedge funds
8 10 (2.01%) User Experience
9 9 (1.81%) Mobile App
9 9 (1.81%) Reinsurance
10 8 (1.61%) Self-Motivation
11 6 (1.21%) Algorithms
12 5 (1.01%) Equities
13 4 (0.80%) Client/Server
13 4 (0.80%) Cloud Native
14 3 (0.60%) Derivative
14 3 (0.60%) Fixed Income
14 3 (0.60%) Foreign Exchange (FX)
14 3 (0.60%) Interest Rate Derivative
14 3 (0.60%) NHS
Operating Systems
1 17 (3.42%) Windows
2 6 (1.21%) Windows Server
3 5 (1.01%) Linux
4 4 (0.80%) Unix
4 4 (0.80%) Windows Server 2016
4 4 (0.80%) Windows Server 2019
5 1 (0.20%) Red Hat Enterprise Linux
5 1 (0.20%) Windows Server 2008
Processes & Methodologies
1 384 (77.26%) Business Intelligence
2 190 (38.23%) ETL
3 137 (27.57%) Analytics
4 127 (25.55%) Agile Software Development
5 118 (23.74%) Visualisation
6 113 (22.74%) Data Modelling
7 80 (16.10%) Data Visualisation
8 58 (11.67%) Performance Tuning
9 54 (10.87%) Problem-Solving
10 51 (10.26%) Migration
11 50 (10.06%) Data Analytics
12 46 (9.26%) DevOps
13 42 (8.45%) Data Management
14 41 (8.25%) Kimball Methodology
15 39 (7.85%) Data Analysis
16 38 (7.65%) Dimensional Modelling
17 35 (7.04%) Stakeholder Management
18 34 (6.84%) Scrum
19 33 (6.64%) Mentoring
20 32 (6.44%) Data Migration
Programming Languages
1 406 (81.69%) SQL
2 176 (35.41%) T-SQL
3 87 (17.51%) Python
4 56 (11.27%) Data Analysis Expressions (DAX)
5 53 (10.66%) C#
6 27 (5.43%) JavaScript
6 27 (5.43%) PL/SQL
6 27 (5.43%) R
7 21 (4.23%) PowerShell
8 17 (3.42%) Java
9 8 (1.61%) U-SQL
10 4 (0.80%) VB.NET
11 3 (0.60%) C++
11 3 (0.60%) VBA
12 1 (0.20%) C
12 1 (0.20%) Formula Language
12 1 (0.20%) Perl
12 1 (0.20%) SOQL
12 1 (0.20%) TypeScript
12 1 (0.20%) X++
Qualifications
1 19 (3.82%) Degree
2 14 (2.82%) Microsoft Certification
3 7 (1.41%) Computer Science Degree
4 4 (0.80%) MCITP
5 2 (0.40%) MCDBA
5 2 (0.40%) MCSA
5 2 (0.40%) MCTS
5 2 (0.40%) SC Cleared
5 2 (0.40%) Security Cleared
6 1 (0.20%) ITIL Certification
Quality Assurance & Compliance
1 49 (9.86%) Data Quality
2 11 (2.21%) QA
3 8 (1.61%) SLA
4 3 (0.60%) EMIR
4 3 (0.60%) GDPR
4 3 (0.60%) MiFID
5 2 (0.40%) PMO
5 2 (0.40%) UCITS
System Software
1 5 (1.01%) Active Directory
2 3 (0.60%) VMware Infrastructure
3 2 (0.40%) Docker
4 1 (0.20%) Hyper-V
4 1 (0.20%) KVM
4 1 (0.20%) Oracle RAC
4 1 (0.20%) Virtual Servers
Systems Management
1 5 (1.01%) HAProxy
1 5 (1.01%) Microsoft Clustering
2 1 (0.20%) Ansible
2 1 (0.20%) Control-M
2 1 (0.20%) Enterprise Manager Cloud Control
2 1 (0.20%) Kubernetes
2 1 (0.20%) Opscode Chef
2 1 (0.20%) Oracle RMAN
2 1 (0.20%) Puppet
2 1 (0.20%) SCOM
2 1 (0.20%) Simpana
2 1 (0.20%) Terraform
Vendors
1 270 (54.33%) Microsoft
2 47 (9.46%) Databricks
3 40 (8.05%) Oracle
4 21 (4.23%) Google
5 15 (3.02%) SAP
5 15 (3.02%) Teradata
6 13 (2.62%) IBM
7 9 (1.81%) Cognos
8 8 (1.61%) Informatica
9 7 (1.41%) VMware
10 5 (1.01%) RedGate
10 5 (1.01%) Salesforce.com
10 5 (1.01%) Sun
11 4 (0.80%) TIBCO
12 3 (0.60%) Alteryx
12 3 (0.60%) Facebook
12 3 (0.60%) SolarWinds
13 2 (0.40%) Hortonworks
13 2 (0.40%) QAD
13 2 (0.40%) Sage