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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
3 Mar 2021
Same period 2020 Same period 2019
Rank 317 284 262
Rank change year-on-year -33 -22 -31
Permanent jobs citing SQL Server Analysis Services 696 1,371 2,042
As % of all permanent jobs advertised in the UK 0.92% 1.12% 1.37%
As % of the Database & Business Intelligence category 3.43% 4.15% 4.75%
Number of salaries quoted 651 1,278 1,895
Median annual salary £50,000 £55,000 £50,000
Median salary % change year-on-year -9.09% +10.00% +5.26%
10th Percentile £35,000 £36,250 £34,600
90th Percentile £77,500 £86,250 £76,250
UK excluding London median annual salary £45,000 £45,000 £43,750
% change year-on-year - +2.86% -2.78%

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 20,274 33,014 43,026
As % of all permanent IT jobs advertised in the UK 26.79% 27.02% 28.81%
Number of salaries quoted 16,698 27,260 35,775
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +5.00%
10th Percentile £33,750 £32,500 £31,250
90th Percentile £87,500 £88,750 £85,000
UK excluding London median annual salary £48,500 £45,000 £45,000
% change year-on-year +7.78% - +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 3 March 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 3 March 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 -36 631 £50,000 -9.09% 84
UK excluding London +6 406 £45,000 - 69
London -43 258 £62,500 -7.41% 25
North of England +33 168 £45,000 +5.88% 22
Work from Home -42 108 £47,500 +2.70% 16
Yorkshire +62 93 £45,000 +12.50% 8
Midlands +6 75 £42,500 -15.00% 20
North West -12 68 £47,500 +9.20% 12
South East +39 57 £50,000 - 9
West Midlands +10 45 £47,500 -5.00% 14
Scotland +37 39 £48,500 +2.11% 9
South West 0 37 £42,000 -11.58% 2
East Midlands +26 30 £37,563 -24.87% 6
East of England +59 25 £50,000 +5.26% 6
North East +12 7 £37,500 -21.88% 2
Wales +14 6 £37,500 -6.25% 1
Northern Ireland -1 1 £45,000 -

For the 6 months to 3 March 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 605 (86.93%) SQL Server Integration Services
2 583 (83.76%) Business Intelligence
3 572 (82.18%) SQL
4 563 (80.89%) SQL Server Reporting Services
5 485 (69.68%) SQL Server
6 453 (65.09%) Data Warehouse
7 412 (59.20%) Power Platform
8 411 (59.05%) Power BI
9 352 (50.57%) Azure
10 334 (47.99%) Microsoft
11 310 (44.54%) ETL
12 226 (32.47%) T-SQL
13 199 (28.59%) Analytics
14 179 (25.72%) Finance
15 178 (25.57%) Agile Software Development
16 154 (22.13%) Python
17 149 (21.41%) Visualisation
18 144 (20.69%) Azure Data Factory
19 136 (19.54%) Data Modelling
20 131 (18.82%) Microsoft Analysis Services
21 121 (17.39%) Azure SQL Database
22 112 (16.09%) Data Analysis Expressions (DAX)
23 111 (15.95%) Data Lake
24 102 (14.66%) Migration
25 95 (13.65%) Databricks
26 92 (13.22%) AWS
27 90 (12.93%) Data Visualisation
28 86 (12.36%) Analytical Skills
29 82 (11.78%) Data Quality
30 81 (11.64%) Azure SQL Data Warehouse

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 (3.59%) SAS
2 22 (3.16%) Apache Spark
3 19 (2.73%) SharePoint
4 13 (1.87%) Apache
5 12 (1.72%) Apache Synapse
6 10 (1.44%) Elasticsearch
7 8 (1.15%) Apache Airflow
7 8 (1.15%) Drupal
7 8 (1.15%) nginx
8 3 (0.43%) Confluence
8 3 (0.43%) IIS
9 1 (0.14%) Apache Pig
9 1 (0.14%) Jupyter
Applications
1 58 (8.33%) Microsoft Excel
2 9 (1.29%) Microsoft Office
3 2 (0.29%) MS Visio
4 1 (0.14%) Microsoft PowerPoint
4 1 (0.14%) Spreadsheet
Business Applications
1 9 (1.29%) Dynamics AX
1 9 (1.29%) Dynamics CRM
2 5 (0.72%) NetSuite
3 1 (0.14%) Cognos Business Intelligence
3 1 (0.14%) Dynamics NAV
3 1 (0.14%) Elite 3E
3 1 (0.14%) Salesforce.com CRM
Cloud Services
1 412 (59.20%) Power Platform
2 352 (50.57%) Azure
3 144 (20.69%) Azure Data Factory
4 92 (13.22%) AWS
5 31 (4.45%) PaaS
6 20 (2.87%) Dynamics 365
6 20 (2.87%) GCP
7 19 (2.73%) IaaS
8 16 (2.30%) Azure Machine Learning
9 15 (2.16%) SaaS
10 14 (2.01%) Azure Stack
11 11 (1.58%) Amazon Kinesis
11 11 (1.58%) Microsoft 365
12 9 (1.29%) Data Lake Analytics
13 3 (0.43%) Azure Functions
13 3 (0.43%) Cloud Computing
13 3 (0.43%) Serverless
14 2 (0.29%) Amazon S3
14 2 (0.29%) GitHub
14 2 (0.29%) Logic Apps
Communications & Networking
1 3 (0.43%) FTP
2 2 (0.29%) Intranet
2 2 (0.29%) Kerberos
Database & Business Intelligence
1 605 (86.93%) SQL Server Integration Services
2 563 (80.89%) SQL Server Reporting Services
3 485 (69.68%) SQL Server
4 453 (65.09%) Data Warehouse
5 411 (59.05%) Power BI
6 131 (18.82%) Microsoft Analysis Services
7 121 (17.39%) Azure SQL Database
8 111 (15.95%) Data Lake
9 81 (11.64%) Azure SQL Data Warehouse
10 80 (11.49%) Tableau
11 58 (8.33%) Relational Database
12 39 (5.60%) QlikView
13 35 (5.03%) Big Data
14 32 (4.60%) NoSQL
14 32 (4.60%) SQL Server 2012
15 31 (4.45%) Cosmos DB
16 28 (4.02%) Amazon Redshift
16 28 (4.02%) SQL Server 2019
17 27 (3.88%) Amazon Athena
17 27 (3.88%) Enterprise Data Warehouse
Development Applications
1 34 (4.89%) Git (software)
2 26 (3.74%) Team Foundation Server
2 26 (3.74%) Visual Studio
3 9 (1.29%) SQL Server Management Studio (SSMS)
4 8 (1.15%) JIRA
5 5 (0.72%) ERwin
5 5 (0.72%) Jenkins
6 4 (0.57%) Eclipse
6 4 (0.57%) ER Studio
7 3 (0.43%) Octopus Deploy
7 3 (0.43%) Postman
7 3 (0.43%) TeamCity
8 2 (0.29%) Subversion
8 2 (0.29%) Visual Studio Team System
9 1 (0.14%) Atlassian Bamboo
9 1 (0.14%) NUnit
9 1 (0.14%) Toad
9 1 (0.14%) webpack
General
1 179 (25.72%) Finance
2 46 (6.61%) Retail
3 37 (5.32%) Public Sector
4 26 (3.74%) Law
4 26 (3.74%) Marketing
5 13 (1.87%) Banking
6 11 (1.58%) Manufacturing
7 7 (1.01%) Advertising
7 7 (1.01%) Legal
8 3 (0.43%) Electronics
8 3 (0.43%) Housing Association
8 3 (0.43%) Publishing
8 3 (0.43%) Telecoms
9 2 (0.29%) Financial Institution
9 2 (0.29%) Front Office
9 2 (0.29%) Games
10 1 (0.14%) General Ledger
10 1 (0.14%) Italian Language
10 1 (0.14%) Local Government
10 1 (0.14%) Spanish Language
Job Titles
1 324 (46.55%) Developer
2 206 (29.60%) Business Intelligence Developer
3 124 (17.82%) Analyst
4 92 (13.22%) Data Engineer
5 64 (9.20%) SQL Developer
6 63 (9.05%) Data Analyst
7 56 (8.05%) Business Intelligence Analyst
8 53 (7.61%) DBA
9 49 (7.04%) SQL DBA
10 41 (5.89%) Consultant
11 40 (5.75%) Data Warehouse Developer
11 40 (5.75%) Senior Developer
12 39 (5.60%) Power BI Developer
13 38 (5.46%) Business Developer
14 36 (5.17%) Architect
15 34 (4.89%) Data Architect
16 32 (4.60%) Azure Engineer
17 31 (4.45%) Data Consultant
18 30 (4.31%) Senior Business Intelligence Developer
19 27 (3.88%) SSIS Developer
Libraries, Frameworks & Software Standards
1 54 (7.76%) .NET
2 37 (5.32%) MDX
3 23 (3.30%) REST
4 21 (3.02%) XML
5 14 (2.01%) Kafka
6 13 (1.87%) CSS
7 11 (1.58%) HTML
8 10 (1.44%) .NET Framework
8 10 (1.44%) AngularJS
9 9 (1.29%) ASP.NET
10 8 (1.15%) JSON
10 8 (1.15%) Symfony
11 6 (0.86%) .NET Core
11 6 (0.86%) CSS3
11 6 (0.86%) Entity Framework
11 6 (0.86%) HTML5
12 5 (0.72%) ASP.NET Web API
12 5 (0.72%) EDI
12 5 (0.72%) Web Services
13 4 (0.57%) SOAP
Miscellaneous
1 86 (12.36%) Analytical Skills
2 59 (8.48%) Data Structures
3 33 (4.74%) Greenfield Project
4 19 (2.73%) Clustering
4 19 (2.73%) Management Information System
5 14 (2.01%) Reinsurance
5 14 (2.01%) User Experience
6 13 (1.87%) Mobile App
6 13 (1.87%) NHS
7 7 (1.01%) Hedge funds
7 7 (1.01%) Self-Motivation
8 6 (0.86%) Replication
9 4 (0.57%) Client/Server
10 3 (0.43%) Private Cloud
11 2 (0.29%) Enterprise Software
11 2 (0.29%) Podcast
11 2 (0.29%) Renewable Energy
11 2 (0.29%) Wiki
12 1 (0.14%) FMCG
12 1 (0.14%) Tandem
Operating Systems
1 25 (3.59%) Windows
2 9 (1.29%) Windows Server
3 8 (1.15%) Windows Server 2016
4 5 (0.72%) Windows 10
4 5 (0.72%) Windows Server 2019
5 4 (0.57%) Windows 7
5 4 (0.57%) Windows Server 2008
6 3 (0.43%) Unix
7 2 (0.29%) Linux
8 1 (0.14%) Red Hat Enterprise Linux
Processes & Methodologies
1 583 (83.76%) Business Intelligence
2 310 (44.54%) ETL
3 199 (28.59%) Analytics
4 178 (25.57%) Agile Software Development
5 149 (21.41%) Visualisation
6 136 (19.54%) Data Modelling
7 102 (14.66%) Migration
8 90 (12.93%) Data Visualisation
9 80 (11.49%) Data Management
10 73 (10.49%) Problem-Solving
11 70 (10.06%) DevOps
12 64 (9.20%) Data Analytics
13 59 (8.48%) Data Migration
14 57 (8.19%) Data Analysis
15 54 (7.76%) Decision-Making
15 54 (7.76%) Machine Learning
16 51 (7.33%) Kimball Methodology
17 50 (7.18%) Data Integration
18 49 (7.04%) Collaborative Working
19 47 (6.75%) Data Architecture
Programming Languages
1 572 (82.18%) SQL
2 226 (32.47%) T-SQL
3 154 (22.13%) Python
4 112 (16.09%) Data Analysis Expressions (DAX)
5 70 (10.06%) C#
6 45 (6.47%) R
7 25 (3.59%) PowerShell
8 19 (2.73%) PL/SQL
9 13 (1.87%) JavaScript
10 9 (1.29%) Java
10 9 (1.29%) U-SQL
11 8 (1.15%) VB.NET
12 7 (1.01%) VB
12 7 (1.01%) VBA
13 3 (0.43%) C
13 3 (0.43%) Perl
13 3 (0.43%) X++
14 2 (0.29%) Delphi
14 2 (0.29%) PHP
14 2 (0.29%) VBScript
Qualifications
1 40 (5.75%) Degree
2 20 (2.87%) Security Cleared
3 18 (2.59%) SC Cleared
4 7 (1.01%) Microsoft Certification
5 4 (0.57%) Computer Science Degree
5 4 (0.57%) ISEB
6 3 (0.43%) MBCS
6 3 (0.43%) MCP
7 1 (0.14%) HND
7 1 (0.14%) ITIL Certification
7 1 (0.14%) Numerate Degree
Quality Assurance & Compliance
1 82 (11.78%) Data Quality
2 14 (2.01%) GDPR
3 8 (1.15%) QA
4 7 (1.01%) SLA
5 3 (0.43%) PCI DSS
5 3 (0.43%) PMO
6 1 (0.14%) ISO/IEC 27001
System Software
1 9 (1.29%) Active Directory
2 6 (0.86%) VMware Infrastructure
3 2 (0.29%) Docker
3 2 (0.29%) HDFS
4 1 (0.14%) Oracle RAC
Systems Management
1 8 (1.15%) HAProxy
2 5 (0.72%) Microsoft Clustering
3 2 (0.29%) Kibana
3 2 (0.29%) Kubernetes
4 1 (0.14%) Enterprise Manager Cloud Control
4 1 (0.14%) Failover Clustering
4 1 (0.14%) Oracle RMAN
4 1 (0.14%) SCOM
4 1 (0.14%) Simpana
4 1 (0.14%) Terraform
Vendors
1 334 (47.99%) Microsoft
2 95 (13.65%) Databricks
3 39 (5.60%) Google
3 39 (5.60%) Oracle
3 39 (5.60%) Salesforce.com
4 25 (3.59%) Teradata
5 19 (2.73%) SAP
6 16 (2.30%) Informatica
7 15 (2.16%) QAD
8 9 (1.29%) VMware
9 7 (1.01%) RedGate
10 5 (0.72%) JD Edwards
10 5 (0.72%) TIBCO
11 4 (0.57%) Talend
12 3 (0.43%) RapidMiner
13 2 (0.29%) Alteryx
13 2 (0.29%) Cadence
13 2 (0.29%) DataFlux
13 2 (0.29%) Percona
13 2 (0.29%) Xamarin