Period
to 22 September 2019

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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
22 Sep 2019
Same period 2018 Same period 2017
Rank 234 220 230
Rank change year-on-year -14 +10 +21
Permanent jobs citing SQL Server Analysis Services 2,002 2,625 2,761
As % of all permanent IT jobs advertised in the UK 1.44% 1.58% 1.56%
As % of the Database & Business Intelligence category 5.32% 5.30% 5.11%
Number of salaries quoted 1,795 2,345 2,444
UK median annual salary £55,000 £50,000 £47,500
Median salary % change year-on-year +10.00% +5.26% -5.00%
10th Percentile £36,250 £32,500 £33,000
90th Percentile £80,000 £72,500 £71,250
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -2.30%

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 37,647 49,485 54,024
As % of all permanent IT jobs advertised in the UK 27.06% 29.72% 30.57%
Number of salaries quoted 30,738 40,368 44,486
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £31,250 £30,000
90th Percentile £85,000 £82,500 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +2.41%

SQL Server Analysis Services
Job Vacancy Trend

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised.

Job vacancy trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Salary Trend

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

Salary trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Salary Histogram

The salary distribution of IT jobs citing SQL Server Analysis Services over the 6 months to 22 September 2019.

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 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
England -14 1,910 £55,000 +10.00% 253
London +35 1,134 £60,000 +9.09% 83
UK excluding London -66 839 £45,000 - 182
North of England -27 279 £42,250 -5.06% 58
Midlands -28 204 £45,000 +5.88% 39
North West +29 157 £41,500 -2.35% 36
South East -107 156 £50,000 +5.26% 35
West Midlands -11 134 £47,000 +16.40% 25
Yorkshire -34 112 £42,500 -5.56% 20
South West -13 69 £45,000 +12.50% 13
East of England -16 65 £47,500 - 25
East Midlands -25 65 £44,500 +2.30% 14
Scotland -7 50 £45,500 +13.75% 9
Wales -1 15 £38,500 -9.41% 3
North East -15 10 £40,750 +1.88% 2
Northern Ireland -5 1 - -

For the 6 months to 22 September 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 with a requirement for SQL Server Analysis Services.

1 1,769 (88.36%) SQL Server Integration Services
2 1,546 (77.22%) SQL Server Reporting Services
3 1,530 (76.42%) Business Intelligence
4 1,501 (74.98%) SQL
5 1,486 (74.23%) SQL Server
6 1,186 (59.24%) Data Warehouse
7 1,094 (54.65%) Power Platform
8 1,087 (54.30%) Power BI
9 941 (47.00%) Microsoft
10 750 (37.46%) T-SQL
11 736 (36.76%) ETL
12 727 (36.31%) Azure
13 644 (32.17%) Finance
14 515 (25.72%) Agile Software Development
15 456 (22.78%) Analytics
16 429 (21.43%) Data Analysis Expressions (DAX)
17 396 (19.78%) Data Modelling
17 396 (19.78%) C#
18 330 (16.48%) Visualisation
19 321 (16.03%) .NET
20 312 (15.58%) Microsoft Analysis Services
21 296 (14.79%) Python
22 295 (14.74%) SQL Server 2012
23 280 (13.99%) Analytical Skills
24 261 (13.04%) Tableau
25 258 (12.89%) Problem-Solving
26 242 (12.09%) Kimball Methodology
27 239 (11.94%) MDX
28 228 (11.39%) Azure SQL Database
29 209 (10.44%) Data Lake

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 130 (6.49%) SharePoint
2 37 (1.85%) SAS
3 29 (1.45%) IIS
4 22 (1.10%) SharePoint 2013
5 20 (1.00%) Confluence
6 15 (0.75%) Apache Spark
7 10 (0.50%) Apache
8 9 (0.45%) Apache Pig
9 8 (0.40%) Apache Airflow
10 7 (0.35%) SharePoint 2010
11 6 (0.30%) BizTalk Server
12 5 (0.25%) Oracle SOA Suite
13 4 (0.20%) OpenEdge
14 3 (0.15%) Drupal
15 2 (0.100%) CMS
15 2 (0.100%) Elasticsearch
15 2 (0.100%) IBM Domino
15 2 (0.100%) Jetty
16 1 (0.050%) MS Exchange
16 1 (0.050%) Oracle Workflow
Applications
1 174 (8.69%) Microsoft Excel
2 30 (1.50%) Microsoft Office
3 14 (0.70%) Spreadsheet
4 7 (0.35%) MS Visio
5 5 (0.25%) InfoPath
6 3 (0.15%) Microsoft Project
7 2 (0.100%) Microsoft PowerPoint
8 1 (0.050%) SPSS
8 1 (0.050%) SPSS Modeler
Business Applications
1 23 (1.15%) NetSuite
2 20 (1.00%) Dynamics AX
3 11 (0.55%) Payment Gateway
4 10 (0.50%) Dynamics CRM
5 7 (0.35%) Cognos Business Intelligence
6 6 (0.30%) OPENHousing
7 5 (0.25%) Dynamics NAV
7 5 (0.25%) SAP FI-GL
8 4 (0.20%) Remedy ITSM
9 2 (0.100%) Cognos Planning
9 2 (0.100%) Cognos TM1
9 2 (0.100%) HFM
9 2 (0.100%) Sage 50
10 1 (0.050%) FastStats
10 1 (0.050%) Oracle Assets
10 1 (0.050%) Oracle Financials
10 1 (0.050%) Oracle General Ledger
10 1 (0.050%) Oracle Payables
10 1 (0.050%) Oracle Procure-to-Pay
10 1 (0.050%) Oracle Receivables
Cloud Services
1 1,094 (54.65%) Power Platform
2 727 (36.31%) Azure
3 172 (8.59%) Azure Data Factory
4 159 (7.94%) AWS
5 47 (2.35%) PowerApps
6 34 (1.70%) Dynamics 365
6 34 (1.70%) PaaS
7 32 (1.60%) Azure Machine Learning
7 32 (1.60%) GCP
8 31 (1.55%) Data Lake Analytics
9 17 (0.85%) Azure Active Directory
10 16 (0.80%) Office 365
10 16 (0.80%) Serverless
11 15 (0.75%) Azure Functions
12 14 (0.70%) SaaS
13 13 (0.65%) IaaS
14 12 (0.60%) Cloud Computing
15 10 (0.50%) Azure Stack
16 8 (0.40%) Amazon S3
17 7 (0.35%) GitHub
Communications & Networking
1 18 (0.90%) Internet
2 12 (0.60%) Broadband
3 9 (0.45%) SAN
4 6 (0.30%) FTP
4 6 (0.30%) Network Security
5 3 (0.15%) WAN
6 1 (0.050%) CTI
6 1 (0.050%) DHCP
6 1 (0.050%) DNS
6 1 (0.050%) Firewall
6 1 (0.050%) HTTP
6 1 (0.050%) HTTPS
6 1 (0.050%) Intranet
6 1 (0.050%) LAN
6 1 (0.050%) VLAN
Database & Business Intelligence
1 1,769 (88.36%) SQL Server Integration Services
2 1,546 (77.22%) SQL Server Reporting Services
3 1,486 (74.23%) SQL Server
4 1,186 (59.24%) Data Warehouse
5 1,087 (54.30%) Power BI
6 312 (15.58%) Microsoft Analysis Services
7 295 (14.74%) SQL Server 2012
8 228 (11.39%) Azure SQL Database
9 209 (10.44%) Data Lake
10 204 (10.19%) OLAP
11 192 (9.59%) SQL Server 2016
12 143 (7.14%) SQL Server 2008
13 142 (7.09%) QlikView
14 132 (6.59%) Relational Database
15 111 (5.54%) Big Data
16 102 (5.09%) SQL Server 2014
17 78 (3.90%) Azure SQL Data Warehouse
18 60 (3.00%) Hadoop
19 58 (2.90%) BusinessObjects
20 56 (2.80%) OLAP Cube
Development Applications
1 117 (5.84%) Visual Studio
2 83 (4.15%) Team Foundation Server
3 71 (3.55%) JIRA
4 66 (3.30%) Git (software)
5 42 (2.10%) SQL Server Management Studio (SSMS)
6 25 (1.25%) Jenkins
7 22 (1.10%) Bitbucket
8 21 (1.05%) Subversion
8 21 (1.05%) Visual Studio Team System
9 13 (0.65%) Atlassian Bamboo
10 10 (0.50%) Octopus Deploy
10 10 (0.50%) Zephyr
11 9 (0.45%) TeamCity
12 8 (0.40%) ProC
12 8 (0.40%) VSS/SourceSafe
13 6 (0.30%) MorphX
13 6 (0.30%) Oracle Forms
14 4 (0.20%) Chocolatey
15 3 (0.15%) Maven
15 3 (0.15%) Oracle APEX
General
1 644 (32.17%) Finance
2 100 (5.00%) Retail
3 45 (2.25%) Public Sector
4 44 (2.20%) Marketing
5 43 (2.15%) Banking
6 42 (2.10%) Legal
7 27 (1.35%) Telecoms
8 26 (1.30%) Law
9 21 (1.05%) Advertising
10 19 (0.95%) Financial Institution
10 19 (0.95%) Manufacturing
11 14 (0.70%) Games
12 13 (0.65%) Front Office
12 13 (0.65%) Investment Banking
13 12 (0.60%) Back Office
14 10 (0.50%) General Ledger
15 9 (0.45%) Social Housing
16 8 (0.40%) Automotive
17 7 (0.35%) Pharmaceutical
18 6 (0.30%) German Language
Job Titles
1 1,217 (60.79%) Developer
2 793 (39.61%) Business Intelligence Developer
3 433 (21.63%) SQL Developer
4 269 (13.44%) Analyst
5 221 (11.04%) SQL BI Developer
6 168 (8.39%) Senior Developer
7 154 (7.69%) DBA
8 145 (7.24%) SSRS Developer
9 142 (7.09%) SQL DBA
9 142 (7.09%) SSIS Developer
10 141 (7.04%) Business Intelligence Analyst
11 128 (6.39%) Business Developer
12 109 (5.44%) Data Warehouse Developer
12 109 (5.44%) Power BI Developer
13 104 (5.19%) Database Developer
13 104 (5.19%) Senior Business Intelligence Developer
13 104 (5.19%) SQL Server Developer
14 95 (4.75%) SSAS Developer
15 81 (4.05%) Consultant
16 79 (3.95%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 321 (16.03%) .NET
2 239 (11.94%) MDX
3 79 (3.95%) ASP.NET
4 76 (3.80%) XML
5 52 (2.60%) .NET Framework
6 45 (2.25%) HTML
6 45 (2.25%) Web Services
7 30 (1.50%) CSS
7 30 (1.50%) JSON
8 28 (1.40%) jQuery
9 25 (1.25%) WCF
10 24 (1.20%) AngularJS
11 23 (1.15%) Entity Framework
12 21 (1.05%) HTML5
13 16 (0.80%) ASP.NET Web API
14 15 (0.75%) LINQ
14 15 (0.75%) X-Windows
15 13 (0.65%) ASP.NET Web Forms
15 13 (0.65%) REST
16 12 (0.60%) Aurelia
Miscellaneous
1 280 (13.99%) Analytical Skills
2 76 (3.80%) Management Information System
3 66 (3.30%) Data Centre
4 61 (3.05%) Replication
5 60 (3.00%) Greenfield Project
6 55 (2.75%) Reinsurance
7 52 (2.60%) Clustering
8 51 (2.55%) Self-Motivation
9 41 (2.05%) iSeries
10 40 (2.00%) AS400
10 40 (2.00%) Hedge funds
11 37 (1.85%) Data Structures
12 24 (1.20%) Public Cloud
13 22 (1.10%) Algorithms
14 19 (0.95%) Enterprise Software
15 16 (0.80%) Market Risk
16 15 (0.75%) Analytical Mindset
16 15 (0.75%) Linux Command Line
16 15 (0.75%) Private Cloud
17 14 (0.70%) Credit Risk
Operating Systems
1 108 (5.39%) Windows
2 67 (3.35%) Windows Server
3 56 (2.80%) Linux
4 21 (1.05%) Windows Server 2008
5 15 (0.75%) Windows 10
5 15 (0.75%) Windows 7
5 15 (0.75%) Windows 8
6 9 (0.45%) Windows Server 2003
7 7 (0.35%) Windows Server 2012
8 4 (0.20%) Red Hat Enterprise Linux
8 4 (0.20%) Unix
9 1 (0.050%) Android
9 1 (0.050%) Apple iOS
Processes & Methodologies
1 1,530 (76.42%) Business Intelligence
2 736 (36.76%) ETL
3 515 (25.72%) Agile Software Development
4 456 (22.78%) Analytics
5 396 (19.78%) Data Modelling
6 330 (16.48%) Visualisation
7 258 (12.89%) Problem-Solving
8 242 (12.09%) Kimball Methodology
9 187 (9.34%) Migration
10 179 (8.94%) DevOps
11 156 (7.79%) Data Visualisation
11 156 (7.79%) Scrum
12 146 (7.29%) Data Analytics
13 130 (6.49%) Data Management
14 125 (6.24%) Performance Tuning
15 123 (6.14%) Data Architecture
16 110 (5.49%) Computer Science
17 108 (5.39%) SDLC
18 102 (5.09%) ITIL
19 100 (5.00%) Data Analysis
Programming Languages
1 1,501 (74.98%) SQL
2 750 (37.46%) T-SQL
3 429 (21.43%) Data Analysis Expressions (DAX)
4 396 (19.78%) C#
5 296 (14.79%) Python
6 153 (7.64%) R
7 151 (7.54%) PowerShell
8 96 (4.80%) VBA
9 55 (2.75%) JavaScript
10 45 (2.25%) VB.NET
11 40 (2.00%) RPG
12 38 (1.90%) Java
13 35 (1.75%) PL/SQL
14 33 (1.65%) VB
15 25 (1.25%) Bash Shell
16 12 (0.60%) C
16 12 (0.60%) U-SQL
17 8 (0.40%) Shell Script
18 7 (0.35%) PHP
18 7 (0.35%) X++
Qualifications
1 167 (8.34%) Degree
2 78 (3.90%) Computer Science Degree
3 47 (2.35%) Microsoft Certification
4 16 (0.80%) Master's Degree
5 15 (0.75%) ISEB
6 13 (0.65%) MCSE
7 10 (0.50%) ISTQB
8 9 (0.45%) ITIL Foundation Certificate
9 8 (0.40%) DBS Check
10 7 (0.35%) MCSA
11 6 (0.30%) MBCS
12 4 (0.20%) MCITP
12 4 (0.20%) MCTS
12 4 (0.20%) Security Cleared
13 3 (0.15%) ISTQB Foundation Certification
13 3 (0.15%) Numerate Degree
13 3 (0.15%) SC Cleared
14 2 (0.100%) MCDBA
14 2 (0.100%) PMI Certification
14 2 (0.100%) PMP
Quality Assurance & Compliance
1 121 (6.04%) Data Quality
2 63 (3.15%) QA
3 22 (1.10%) SLA
4 19 (0.95%) GDPR
5 10 (0.50%) ISO/IEC 27001
6 3 (0.15%) GAAP
7 2 (0.100%) PCI DSS
8 1 (0.050%) PMO
System Software
1 37 (1.85%) VMware Infrastructure
2 30 (1.50%) Hyper-V
3 29 (1.45%) Active Directory
4 27 (1.35%) Docker
5 15 (0.75%) LXC
6 9 (0.45%) HDFS
7 8 (0.40%) XenApp
8 6 (0.30%) Virtual Machines
8 6 (0.30%) VMware Workstation
Systems Management
1 24 (1.20%) Ansible
2 18 (0.90%) Grafana
3 16 (0.80%) SQL Sentry
4 10 (0.50%) Failover Clustering
4 10 (0.50%) HP ALM
4 10 (0.50%) Kubernetes
4 10 (0.50%) Prometheus
5 9 (0.45%) Control-M
6 8 (0.40%) Hadoop YARN
7 7 (0.35%) Dollar Universe
8 6 (0.30%) Microsoft Clustering
8 6 (0.30%) Opscode Chef
8 6 (0.30%) Puppet
8 6 (0.30%) Terraform
9 4 (0.20%) NetBackup
10 3 (0.15%) Perfmon
10 3 (0.15%) Tivoli
10 3 (0.15%) Tivoli Storage Manager
11 1 (0.050%) WMI
Vendors
1 941 (47.00%) Microsoft
2 261 (13.04%) Tableau
3 117 (5.84%) Databricks
4 110 (5.49%) Oracle
5 71 (3.55%) Cognos
6 50 (2.50%) SAP
7 48 (2.40%) IBM
7 48 (2.40%) VMware
8 35 (1.75%) Google
9 32 (1.60%) Teradata
10 31 (1.55%) Informatica
11 28 (1.40%) Alteryx
12 24 (1.20%) JD Edwards
13 19 (0.95%) Netezza
14 17 (0.85%) Veeam
15 16 (0.80%) Atlassian
16 10 (0.50%) HP
16 10 (0.50%) Talend
17 8 (0.40%) Citrix
17 8 (0.40%) Guidewire