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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
11 Dec 2019
Same period 2018 Same period 2017
Rank 264 238 248
Rank change year-on-year -26 +10 0
Permanent jobs citing SQL Server Analysis Services 1,616 2,314 2,595
As % of all permanent IT jobs advertised in the UK 1.21% 1.45% 1.44%
As % of the Database & Business Intelligence category 4.51% 5.03% 4.77%
Number of salaries quoted 1,434 2,056 2,280
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 £32,500
90th Percentile £80,000 £73,750 £70,000
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - -5.56%

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 35,827 46,020 54,445
As % of all permanent IT jobs advertised in the UK 26.85% 28.81% 30.30%
Number of salaries quoted 29,600 37,812 44,893
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £32,000 £31,250 £30,000
90th Percentile £87,500 £85,000 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

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 11 December 2019.

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 11 December 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 -29 1,529 £55,000 +10.00% 241
London -18 831 £65,000 +13.04% 89
UK excluding London -18 761 £45,000 +5.88% 164
North of England -21 219 £40,500 -3.57% 56
Midlands -8 183 £47,500 +11.76% 32
South East -34 169 £47,500 - 42
North West +36 140 £42,000 - 36
West Midlands +21 129 £47,500 +11.76% 22
Yorkshire -42 73 £40,000 -9.86% 19
East of England +2 65 £47,500 +5.56% 13
South West +2 61 £45,000 +12.50% 8
East Midlands -46 52 £47,500 +9.20% 10
Scotland +1 35 £45,000 +12.50% 6
Wales +1 21 £38,000 +1.33% 6
Northern Ireland +9 8 £45,000 +28.57% 1
North East -3 6 £37,500 - 1
Isle of Man - 1 £37,500 -

For the 6 months to 11 December 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,367 (84.59%) SQL Server Integration Services
2 1,236 (76.49%) SQL
3 1,217 (75.31%) SQL Server Reporting Services
4 1,199 (74.20%) Business Intelligence
5 1,187 (73.45%) SQL Server
6 900 (55.69%) Data Warehouse
7 895 (55.38%) Power Platform
8 888 (54.95%) Power BI
9 786 (48.64%) Microsoft
10 616 (38.12%) T-SQL
11 550 (34.03%) ETL
12 546 (33.79%) Finance
13 521 (32.24%) Azure
14 338 (20.92%) Agile Software Development
15 329 (20.36%) Analytics
16 302 (18.69%) Visualisation
17 301 (18.63%) C#
18 296 (18.32%) Data Analysis Expressions (DAX)
19 292 (18.07%) Microsoft Analysis Services
20 288 (17.82%) Data Modelling
21 277 (17.14%) Analytical Skills
22 259 (16.03%) .NET
23 231 (14.29%) Problem-Solving
24 215 (13.30%) Tableau
25 212 (13.12%) Python
26 181 (11.20%) Migration
27 169 (10.46%) Data Visualisation
28 165 (10.21%) SQL Server 2012
28 165 (10.21%) Microsoft Excel
29 161 (9.96%) MDX

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 123 (7.61%) SharePoint
2 42 (2.60%) SAS
3 29 (1.79%) IIS
4 19 (1.18%) SharePoint 2013
5 15 (0.93%) Apache
5 15 (0.93%) BizTalk Server
6 14 (0.87%) Apache Airflow
7 13 (0.80%) Apache Spark
8 12 (0.74%) Confluence
9 8 (0.50%) Oracle SOA Suite
10 7 (0.43%) Tomcat
11 6 (0.37%) SharePoint 2010
12 4 (0.25%) OpenEdge
13 3 (0.19%) Drupal
13 3 (0.19%) Oracle Service Bus
14 2 (0.12%) IBM Domino
14 2 (0.12%) SugarCRM
15 1 (0.062%) Apache Pig
15 1 (0.062%) Elasticsearch
15 1 (0.062%) MS Exchange
Applications
1 165 (10.21%) Microsoft Excel
2 20 (1.24%) Microsoft Office
3 12 (0.74%) Spreadsheet
4 10 (0.62%) MS Visio
5 5 (0.31%) InfoPath
6 3 (0.19%) Microsoft Project
7 2 (0.12%) SPSS
8 1 (0.062%) Microsoft PowerPoint
8 1 (0.062%) SPSS Modeler
Business Applications
1 32 (1.98%) Dynamics AX
2 23 (1.42%) NetSuite
3 13 (0.80%) Dynamics NAV
4 8 (0.50%) Payment Gateway
5 7 (0.43%) Dynamics CRM
6 6 (0.37%) OPENHousing
7 4 (0.25%) Remedy ITSM
8 3 (0.19%) Cognos Business Intelligence
9 2 (0.12%) Cognos Planning
9 2 (0.12%) Cognos TM1
9 2 (0.12%) HFM
9 2 (0.12%) RiskWrite
10 1 (0.062%) Endur
10 1 (0.062%) FastStats
10 1 (0.062%) Raiser's Edge
10 1 (0.062%) Sage 200
10 1 (0.062%) Softmar
Cloud Services
1 895 (55.38%) Power Platform
2 521 (32.24%) Azure
3 134 (8.29%) AWS
4 113 (6.99%) Azure Data Factory
5 47 (2.91%) Dynamics 365
6 39 (2.41%) PaaS
7 34 (2.10%) GCP
8 26 (1.61%) Data Lake Analytics
8 26 (1.61%) PowerApps
9 20 (1.24%) Azure Machine Learning
10 18 (1.11%) Azure Functions
10 18 (1.11%) Serverless
11 17 (1.05%) SaaS
12 15 (0.93%) Amazon S3
12 15 (0.93%) Azure Active Directory
12 15 (0.93%) IaaS
12 15 (0.93%) Office 365
13 14 (0.87%) GitHub
14 8 (0.50%) Cloud Computing
14 8 (0.50%) Microsoft Flow
Communications & Networking
1 14 (0.87%) Internet
2 8 (0.50%) FTP
2 8 (0.50%) SAN
3 6 (0.37%) Network Security
4 2 (0.12%) DHCP
4 2 (0.12%) DNS
5 1 (0.062%) DOCSIS
5 1 (0.062%) Firewall
5 1 (0.062%) HTTP
5 1 (0.062%) HTTPS
5 1 (0.062%) LAN
5 1 (0.062%) VLAN
5 1 (0.062%) VPN
5 1 (0.062%) WAN
Database & Business Intelligence
1 1,367 (84.59%) SQL Server Integration Services
2 1,217 (75.31%) SQL Server Reporting Services
3 1,187 (73.45%) SQL Server
4 900 (55.69%) Data Warehouse
5 888 (54.95%) Power BI
6 292 (18.07%) Microsoft Analysis Services
7 165 (10.21%) SQL Server 2012
8 159 (9.84%) SQL Server 2016
9 138 (8.54%) Azure SQL Database
10 134 (8.29%) Data Lake
11 126 (7.80%) QlikView
12 118 (7.30%) OLAP
13 111 (6.87%) SQL Server 2008
14 101 (6.25%) Big Data
15 93 (5.75%) SQL Server 2014
16 91 (5.63%) Relational Database
17 69 (4.27%) Azure SQL Data Warehouse
18 64 (3.96%) Qlik Sense
19 53 (3.28%) PowerPivot
20 50 (3.09%) Hadoop
Development Applications
1 100 (6.19%) Visual Studio
2 84 (5.20%) Team Foundation Server
3 51 (3.16%) JIRA
4 48 (2.97%) Git (software)
4 48 (2.97%) SQL Server Management Studio (SSMS)
5 34 (2.10%) Visual Studio Team System
6 14 (0.87%) ProC
7 9 (0.56%) Zephyr
8 8 (0.50%) Atlassian Bamboo
8 8 (0.50%) Bitbucket
8 8 (0.50%) Jenkins
8 8 (0.50%) Subversion
9 6 (0.37%) Chocolatey
9 6 (0.37%) MorphX
10 3 (0.19%) ERwin
10 3 (0.19%) Octopus Deploy
10 3 (0.19%) Oracle APEX
10 3 (0.19%) VSS/SourceSafe
11 2 (0.12%) Eclipse
11 2 (0.12%) JMeter
General
1 546 (33.79%) Finance
2 86 (5.32%) Retail
3 55 (3.40%) Marketing
4 37 (2.29%) Banking
5 34 (2.10%) Telecoms
6 31 (1.92%) Law
6 31 (1.92%) Legal
7 26 (1.61%) Public Sector
8 19 (1.18%) Advertising
9 16 (0.99%) Manufacturing
10 15 (0.93%) Games
11 12 (0.74%) Front Office
12 10 (0.62%) Back Office
12 10 (0.62%) General Ledger
12 10 (0.62%) Investment Banking
13 8 (0.50%) Automotive
13 8 (0.50%) Social Housing
14 7 (0.43%) German Language
15 5 (0.31%) Financial Institution
15 5 (0.31%) French Language
Job Titles
1 903 (55.88%) Developer
2 516 (31.93%) Business Intelligence Developer
3 282 (17.45%) SQL Developer
4 245 (15.16%) Analyst
5 145 (8.97%) DBA
6 127 (7.86%) SQL DBA
7 115 (7.12%) Business Intelligence Analyst
8 104 (6.44%) Senior Developer
9 100 (6.19%) Business Developer
10 91 (5.63%) SQL BI Developer
10 91 (5.63%) SSRS Developer
11 82 (5.07%) SSIS Developer
12 80 (4.95%) Database Developer
12 80 (4.95%) Power BI Developer
13 79 (4.89%) Architect
14 78 (4.83%) Administrator
15 70 (4.33%) Data Analyst
16 69 (4.27%) Consultant
17 63 (3.90%) SQL Analyst
17 63 (3.90%) SSAS Developer
Libraries, Frameworks & Software Standards
1 259 (16.03%) .NET
2 161 (9.96%) MDX
3 73 (4.52%) XML
4 70 (4.33%) ASP.NET
5 39 (2.41%) HTML
6 34 (2.10%) Web Services
7 33 (2.04%) .NET Framework
8 32 (1.98%) AngularJS
9 31 (1.92%) JSON
10 24 (1.49%) jQuery
11 23 (1.42%) CSS
12 22 (1.36%) Vue.js
13 19 (1.18%) D3.js
13 19 (1.18%) HTML5
14 18 (1.11%) ASP.NET MVC
15 17 (1.05%) RESTful
16 15 (0.93%) ASP.NET Web API
17 14 (0.87%) Entity Framework
17 14 (0.87%) REST
17 14 (0.87%) WCF
Miscellaneous
1 277 (17.14%) Analytical Skills
2 83 (5.14%) Management Information System
3 59 (3.65%) Reinsurance
4 45 (2.78%) Data Centre
4 45 (2.78%) Self-Motivation
5 42 (2.60%) Replication
6 38 (2.35%) AS400
6 38 (2.35%) iSeries
7 36 (2.23%) Data Structures
8 31 (1.92%) Public Cloud
9 29 (1.79%) Clustering
10 25 (1.55%) Private Cloud
11 22 (1.36%) Greenfield Project
12 15 (0.93%) Algorithms
12 15 (0.93%) User Experience
13 13 (0.80%) Linux Command Line
14 12 (0.74%) Hedge funds
15 10 (0.62%) Client/Server
16 8 (0.50%) FMCG
16 8 (0.50%) Tandem
Operating Systems
1 94 (5.82%) Windows
2 69 (4.27%) Windows Server
3 40 (2.48%) Linux
4 17 (1.05%) Windows Server 2008
5 14 (0.87%) Windows 7
6 13 (0.80%) Windows 10
6 13 (0.80%) Windows 8
7 4 (0.25%) Unix
7 4 (0.25%) Windows Server 2003
8 3 (0.19%) Windows Server 2012
Processes & Methodologies
1 1,199 (74.20%) Business Intelligence
2 550 (34.03%) ETL
3 338 (20.92%) Agile Software Development
4 329 (20.36%) Analytics
5 302 (18.69%) Visualisation
6 288 (17.82%) Data Modelling
7 231 (14.29%) Problem-Solving
8 181 (11.20%) Migration
9 169 (10.46%) Data Visualisation
10 129 (7.98%) DevOps
10 129 (7.98%) Kimball Methodology
11 127 (7.86%) ITIL
12 117 (7.24%) Data Management
13 103 (6.37%) Data Analytics
14 98 (6.06%) Data Analysis
15 97 (6.00%) Performance Tuning
16 88 (5.45%) SDLC
17 84 (5.20%) Stakeholder Management
17 84 (5.20%) User Acceptance Testing
18 83 (5.14%) Computer Science
Programming Languages
1 1,236 (76.49%) SQL
2 616 (38.12%) T-SQL
3 301 (18.63%) C#
4 296 (18.32%) Data Analysis Expressions (DAX)
5 212 (13.12%) Python
6 134 (8.29%) R
7 107 (6.62%) PowerShell
8 79 (4.89%) VBA
9 54 (3.34%) Java
10 43 (2.66%) JavaScript
11 42 (2.60%) PL/SQL
12 38 (2.35%) RPG
13 32 (1.98%) VB
14 24 (1.49%) C
14 24 (1.49%) VB.NET
15 14 (0.87%) Shell Script
16 13 (0.80%) Bash Shell
17 12 (0.74%) U-SQL
18 8 (0.50%) VBScript
18 8 (0.50%) X++
Qualifications
1 156 (9.65%) Degree
2 72 (4.46%) Computer Science Degree
3 44 (2.72%) Microsoft Certification
4 15 (0.93%) MCSE
5 14 (0.87%) ITIL Foundation Certificate
6 12 (0.74%) Numerate Degree
7 11 (0.68%) ISEB
8 10 (0.62%) MCSA
9 9 (0.56%) Master's Degree
10 8 (0.50%) MBCS
11 6 (0.37%) ISTQB
11 6 (0.37%) MCITP
12 5 (0.31%) Security Cleared
13 3 (0.19%) ISTQB Foundation Certification
13 3 (0.19%) MCP
13 3 (0.19%) MCSD
13 3 (0.19%) SC Cleared
14 2 (0.12%) HND
14 2 (0.12%) ITIL Certification
14 2 (0.12%) MCTS
Quality Assurance & Compliance
1 122 (7.55%) Data Quality
2 72 (4.46%) QA
3 23 (1.42%) GDPR
4 17 (1.05%) SLA
5 9 (0.56%) PCI DSS
6 8 (0.50%) ISO/IEC 27001
7 3 (0.19%) COBIT
7 3 (0.19%) GAAP
System Software
1 34 (2.10%) VMware Infrastructure
2 29 (1.79%) Active Directory
3 28 (1.73%) Hyper-V
4 16 (0.99%) HDFS
5 13 (0.80%) Docker
5 13 (0.80%) LXC
6 8 (0.50%) XenApp
7 6 (0.37%) Virtual Machines
7 6 (0.37%) VMware Workstation
Systems Management
1 14 (0.87%) Failover Clustering
2 12 (0.74%) Control-M
3 9 (0.56%) HP ALM
4 8 (0.50%) Ansible
4 8 (0.50%) Kubernetes
4 8 (0.50%) Puppet
4 8 (0.50%) SQL Sentry
5 7 (0.43%) Perfmon
6 6 (0.37%) Opscode Chef
6 6 (0.37%) Terraform
7 4 (0.25%) NetBackup
7 4 (0.25%) Tivoli
7 4 (0.25%) Tivoli Storage Manager
8 3 (0.19%) Oracle Enterprise Manager
9 2 (0.12%) Dollar Universe
9 2 (0.12%) Grafana
9 2 (0.12%) Prometheus
10 1 (0.062%) Ambari
10 1 (0.062%) Hadoop YARN
10 1 (0.062%) Microsoft Clustering
Vendors
1 786 (48.64%) Microsoft
2 215 (13.30%) Tableau
3 107 (6.62%) Oracle
4 66 (4.08%) Databricks
5 63 (3.90%) Cognos
6 47 (2.91%) VMware
7 44 (2.72%) Teradata
8 36 (2.23%) Google
8 36 (2.23%) IBM
9 35 (2.17%) SAP
10 32 (1.98%) Informatica
11 25 (1.55%) JD Edwards
12 24 (1.49%) Alteryx
13 17 (1.05%) Veeam
14 12 (0.74%) RedGate
15 10 (0.62%) Talend
16 9 (0.56%) Atlassian
16 9 (0.56%) Citrix
16 9 (0.56%) HP
17 8 (0.50%) Sybase