Period
to 17 October 2019

The following table provides summary statistics for permanent job vacancies advertised in the UK excluding London 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 17 October 2019 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
UK > UK excluding London
6 months to
17 Oct 2019
Same period 2018 Same period 2017
Rank 301 245 225
Rank change year-on-year -56 -20 +28
Permanent jobs citing SQL Server Analysis Services 810 1,281 1,508
As % of all permanent IT jobs advertised in the UK excluding London 1.03% 1.39% 1.56%
As % of the Database & Business Intelligence category 3.95% 4.83% 4.98%
Number of salaries quoted 708 1,139 1,319
UK excluding London median annual salary £45,000 £43,500 £42,500
Median salary % change year-on-year +3.45% +2.35% -5.56%
10th Percentile £32,500 £31,375 £31,250
90th Percentile £66,250 £60,750 £57,500
UK median annual salary £55,000 £50,000 £47,500
% change year-on-year +10.00% +5.26% -5.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 advertised in the UK excluding London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK excluding London
Permanent vacancies with a requirement for database or business intelligence skills 20,482 26,533 30,257
As % of all permanent IT jobs advertised in the UK excluding London 26.07% 28.74% 31.27%
Number of salaries quoted 16,774 22,082 25,426
UK excluding London median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% +2.41%
10th Percentile £29,000 £28,250 £27,500
90th Percentile £67,500 £67,500 £63,750
UK median annual salary £52,500 £50,000 £48,000
% change year-on-year +5.00% +4.17% +1.05%

SQL Server Analysis Services
Job Vacancy Trend in the UK excluding London

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised in the UK excluding London.

Job vacancy trend for SQL Server Analysis Services in the UK excluding London

SQL Server Analysis Services
Salary Trend in the UK excluding London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL Server Analysis Services in the UK excluding London.

Salary trend for SQL Server Analysis Services in the UK excluding London

SQL Server Analysis Services
Salary Histogram in the UK excluding London

The salary distribution of IT jobs citing SQL Server Analysis Services in the UK excluding London over the 6 months to 17 October 2019.

Salary histogram for SQL Server Analysis Services in the UK excluding London

SQL Server Analysis Services
Job Locations in the UK excluding London

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 excluding London region over the 6 months to 17 October 2019. 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
North of England -20 254 £40,000 -5.88% 73
Midlands -5 209 £45,750 +7.65% 38
South East -89 160 £47,500 - 35
North West +36 148 £40,023 -5.83% 46
West Midlands +13 141 £47,500 +18.75% 27
Yorkshire -37 100 £40,000 -11.11% 24
East of England -24 66 £47,500 +5.56% 18
East Midlands -16 63 £44,500 +2.30% 11
South West -13 58 £45,000 +12.50% 8
Scotland -5 47 £45,500 +13.75% 6
Wales +10 15 £40,000 -5.88% 4
North East -26 6 £37,500 - 3
Northern Ireland -10 1 - -
SQL Server Analysis Services
UK

For the 6 months to 17 October 2019, 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 across the UK excluding London region with a requirement for SQL Server Analysis Services.

1 735 (90.74%) SQL Server Integration Services
2 684 (84.44%) SQL Server Reporting Services
3 634 (78.27%) SQL
4 595 (73.46%) Business Intelligence
5 575 (70.99%) SQL Server
6 384 (47.41%) Data Warehouse
6 384 (47.41%) Power Platform
7 378 (46.67%) Power BI
8 369 (45.56%) Microsoft
9 307 (37.90%) ETL
10 280 (34.57%) T-SQL
11 226 (27.90%) Azure
12 198 (24.44%) Agile Software Development
13 164 (20.25%) Finance
14 156 (19.26%) Analytics
15 153 (18.89%) Analytical Skills
16 152 (18.77%) Visualisation
17 119 (14.69%) Problem-Solving
18 116 (14.32%) Tableau
19 114 (14.07%) SQL Server 2012
20 109 (13.46%) Microsoft Analysis Services
21 105 (12.96%) Data Modelling
22 96 (11.85%) Migration
23 94 (11.60%) Microsoft Excel
23 94 (11.60%) Data Analysis Expressions (DAX)
24 93 (11.48%) SQL Server 2008
25 85 (10.49%) .NET
26 81 (10.00%) C#
27 69 (8.52%) Data Visualisation
28 68 (8.40%) Cognos

SQL Server Analysis Services
Co-occurring IT Skills in the UK excluding London 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 66 (8.15%) SharePoint
2 22 (2.72%) IIS
3 17 (2.10%) SAS
4 13 (1.60%) SharePoint 2013
5 9 (1.11%) Apache Spark
6 6 (0.74%) Confluence
7 4 (0.49%) OpenEdge
7 4 (0.49%) SharePoint 2010
8 2 (0.25%) Elasticsearch
8 2 (0.25%) IBM Domino
9 1 (0.12%) Apache
9 1 (0.12%) CMS
9 1 (0.12%) Umbraco
Applications
1 94 (11.60%) Microsoft Excel
2 27 (3.33%) Microsoft Office
3 14 (1.73%) Spreadsheet
4 6 (0.74%) MS Visio
5 4 (0.49%) InfoPath
6 2 (0.25%) Microsoft PowerPoint
Business Applications
1 14 (1.73%) NetSuite
2 9 (1.11%) Payment Gateway
3 7 (0.86%) Cognos Business Intelligence
3 7 (0.86%) Dynamics AX
4 6 (0.74%) OPENHousing
5 4 (0.49%) Dynamics CRM
5 4 (0.49%) Dynamics NAV
6 2 (0.25%) Remedy ITSM
Cloud Services
1 384 (47.41%) Power Platform
2 226 (27.90%) Azure
3 61 (7.53%) AWS
4 39 (4.81%) Azure Data Factory
5 18 (2.22%) PaaS
6 13 (1.60%) GCP
7 12 (1.48%) Dynamics 365
7 12 (1.48%) PowerApps
8 11 (1.36%) Azure Active Directory
9 10 (1.23%) IaaS
10 7 (0.86%) Office 365
11 5 (0.62%) Azure Stack
11 5 (0.62%) Microsoft Flow
11 5 (0.62%) SaaS
12 4 (0.49%) Azure Functions
12 4 (0.49%) Serverless
13 3 (0.37%) Cloud Computing
13 3 (0.37%) Google Analytics
14 1 (0.12%) Amazon S3
14 1 (0.12%) Azure Machine Learning
Communications & Networking
1 13 (1.60%) Internet
2 8 (0.99%) Broadband
3 5 (0.62%) FTP
4 1 (0.12%) HTTP
4 1 (0.12%) HTTPS
4 1 (0.12%) Intranet
4 1 (0.12%) LAN
4 1 (0.12%) WAN
Database & Business Intelligence
1 735 (90.74%) SQL Server Integration Services
2 684 (84.44%) SQL Server Reporting Services
3 575 (70.99%) SQL Server
4 384 (47.41%) Data Warehouse
5 378 (46.67%) Power BI
6 114 (14.07%) SQL Server 2012
7 109 (13.46%) Microsoft Analysis Services
8 93 (11.48%) SQL Server 2008
9 64 (7.90%) SQL Server 2016
10 61 (7.53%) QlikView
11 52 (6.42%) OLAP
12 50 (6.17%) Relational Database
13 48 (5.93%) SQL Server 2014
14 46 (5.68%) Azure SQL Database
15 39 (4.81%) BusinessObjects
16 34 (4.20%) Data Lake
17 30 (3.70%) Big Data
17 30 (3.70%) Crystal Reports
18 29 (3.58%) Qlik Sense
19 25 (3.09%) Azure SQL Data Warehouse
Development Applications
1 41 (5.06%) Team Foundation Server
2 37 (4.57%) Visual Studio
3 33 (4.07%) SQL Server Management Studio (SSMS)
4 30 (3.70%) JIRA
5 15 (1.85%) Git (software)
6 12 (1.48%) Visual Studio Team System
7 11 (1.36%) Zephyr
8 6 (0.74%) VSS/SourceSafe
9 4 (0.49%) Chocolatey
9 4 (0.49%) MorphX
10 3 (0.37%) Oracle Forms
11 1 (0.12%) Octopus Deploy
11 1 (0.12%) Subversion
11 1 (0.12%) WebSpeed
General
1 164 (20.25%) Finance
2 45 (5.56%) Retail
3 31 (3.83%) Marketing
4 22 (2.72%) Public Sector
5 14 (1.73%) Manufacturing
6 12 (1.48%) Legal
7 11 (1.36%) Advertising
8 10 (1.23%) Back Office
8 10 (1.23%) General Ledger
9 9 (1.11%) Social Housing
10 4 (0.49%) Financial Institution
10 4 (0.49%) Local Government
10 4 (0.49%) Pharmaceutical
11 3 (0.37%) Automotive
11 3 (0.37%) Games
12 2 (0.25%) Banking
12 2 (0.25%) French Language
12 2 (0.25%) German Language
12 2 (0.25%) Law
12 2 (0.25%) Telecoms
Job Titles
1 447 (55.19%) Developer
2 300 (37.04%) Business Intelligence Developer
3 151 (18.64%) Analyst
4 121 (14.94%) SQL Developer
5 71 (8.77%) Business Developer
6 66 (8.15%) Business Intelligence Analyst
7 60 (7.41%) DBA
8 53 (6.54%) SQL DBA
9 52 (6.42%) SQL BI Developer
10 50 (6.17%) SSIS Developer
11 49 (6.05%) SSRS Developer
12 48 (5.93%) Data Analyst
13 47 (5.80%) Senior Developer
14 31 (3.83%) SQL Analyst
15 30 (3.70%) Consultant
16 29 (3.58%) Senior Business Intelligence Developer
16 29 (3.58%) SSAS Developer
17 26 (3.21%) Power BI Developer
18 25 (3.09%) Architect
19 22 (2.72%) Business Intelligence Manager
Libraries, Frameworks & Software Standards
1 85 (10.49%) .NET
2 46 (5.68%) MDX
3 41 (5.06%) XML
4 20 (2.47%) JSON
5 19 (2.35%) ASP.NET
6 15 (1.85%) HTML
6 15 (1.85%) Web Services
7 13 (1.60%) CSS
7 13 (1.60%) jQuery
8 12 (1.48%) .NET Framework
9 11 (1.36%) X-Windows
10 9 (1.11%) AngularJS
11 8 (0.99%) ASP.NET Web Forms
12 7 (0.86%) REST
13 6 (0.74%) Ajax
14 5 (0.62%) ASP.NET MVC
14 5 (0.62%) Entity Framework
14 5 (0.62%) SOAP
15 4 (0.49%) COM
15 4 (0.49%) Twitter Bootstrap
Miscellaneous
1 153 (18.89%) Analytical Skills
2 33 (4.07%) Management Information System
3 29 (3.58%) Self-Motivation
4 24 (2.96%) Replication
5 22 (2.72%) Reinsurance
6 17 (2.10%) Data Centre
7 13 (1.60%) AS400
7 13 (1.60%) iSeries
8 11 (1.36%) Linux Command Line
8 11 (1.36%) User Experience
9 10 (1.23%) Data Structures
10 9 (1.11%) Analytical Mindset
10 9 (1.11%) Enterprise Software
11 8 (0.99%) Clustering
11 8 (0.99%) FMCG
11 8 (0.99%) Public Cloud
12 7 (0.86%) Market Risk
13 6 (0.74%) NHS
14 5 (0.62%) Algorithms
14 5 (0.62%) Smart Meter
Operating Systems
1 28 (3.46%) Windows
2 17 (2.10%) Windows Server
3 16 (1.98%) Linux
4 14 (1.73%) Windows Server 2008
5 11 (1.36%) Windows 10
5 11 (1.36%) Windows 7
5 11 (1.36%) Windows 8
6 4 (0.49%) Windows Server 2012
7 3 (0.37%) Windows Server 2003
8 1 (0.12%) Android
8 1 (0.12%) Apple iOS
Processes & Methodologies
1 595 (73.46%) Business Intelligence
2 307 (37.90%) ETL
3 198 (24.44%) Agile Software Development
4 156 (19.26%) Analytics
5 152 (18.77%) Visualisation
6 119 (14.69%) Problem-Solving
7 105 (12.96%) Data Modelling
8 96 (11.85%) Migration
9 69 (8.52%) Data Visualisation
10 59 (7.28%) SDLC
11 54 (6.67%) Scrum
12 50 (6.17%) Kimball Methodology
13 46 (5.68%) Performance Tuning
14 41 (5.06%) ITIL
14 41 (5.06%) Stakeholder Management
15 40 (4.94%) ERP
16 39 (4.81%) Data Analysis
16 39 (4.81%) Data Migration
16 39 (4.81%) Decision-Making
17 37 (4.57%) Dimensional Modelling
Programming Languages
1 634 (78.27%) SQL
2 280 (34.57%) T-SQL
3 94 (11.60%) Data Analysis Expressions (DAX)
4 81 (10.00%) C#
5 55 (6.79%) Python
6 42 (5.19%) PowerShell
7 36 (4.44%) VBA
8 23 (2.84%) R
9 19 (2.35%) JavaScript
10 15 (1.85%) PL/SQL
10 15 (1.85%) VB.NET
11 13 (1.60%) RPG
11 13 (1.60%) VB
12 4 (0.49%) Java
12 4 (0.49%) U-SQL
12 4 (0.49%) X++
13 3 (0.37%) C
13 3 (0.37%) PHP
14 2 (0.25%) Go
15 1 (0.12%) Scala
Qualifications
1 61 (7.53%) Degree
2 18 (2.22%) Computer Science Degree
3 16 (1.98%) Microsoft Certification
4 14 (1.73%) ISEB
5 9 (1.11%) ISTQB
5 9 (1.11%) Master's Degree
6 8 (0.99%) MBCS
7 6 (0.74%) DBS Check
8 5 (0.62%) MCITP
9 4 (0.49%) MCTS
10 3 (0.37%) ISTQB Foundation Certification
10 3 (0.37%) SC Cleared
10 3 (0.37%) Security Cleared
11 2 (0.25%) MCDBA
11 2 (0.25%) MCSA
11 2 (0.25%) MCSE
11 2 (0.25%) Numerate Degree
12 1 (0.12%) HND
Quality Assurance & Compliance
1 67 (8.27%) Data Quality
2 26 (3.21%) QA
3 14 (1.73%) SLA
4 10 (1.23%) GDPR
5 3 (0.37%) ISO/IEC 27001
System Software
1 16 (1.98%) VMware Infrastructure
2 14 (1.73%) Active Directory
3 13 (1.60%) Hyper-V
4 11 (1.36%) LXC
5 2 (0.25%) Docker
6 1 (0.12%) HDFS
6 1 (0.12%) Virtual Machines
Systems Management
1 11 (1.36%) HP ALM
2 2 (0.25%) NetBackup
3 1 (0.12%) Microsoft Clustering
Vendors
1 369 (45.56%) Microsoft
2 116 (14.32%) Tableau
3 68 (8.40%) Cognos
4 42 (5.19%) Oracle
5 38 (4.69%) IBM
6 30 (3.70%) SAP
7 21 (2.59%) Informatica
8 18 (2.22%) Databricks
8 18 (2.22%) Google
9 16 (1.98%) VMware
10 14 (1.73%) JD Edwards
11 11 (1.36%) HP
11 11 (1.36%) Teradata
12 10 (1.23%) Netezza
13 9 (1.11%) Alteryx
14 6 (0.74%) Ab Initio
14 6 (0.74%) Capita
14 6 (0.74%) Telerik
15 5 (0.62%) Nintex
15 5 (0.62%) SnapLogic