Period
to 24 September 2018

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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
24 Sep 2018
Same period 2017 Same period 2016
Rank 222 232 250
Rank change year-on-year +10 +18 -77
Permanent jobs citing SQL Server Analysis Services 2,616 2,713 2,724
As % of all permanent IT jobs advertised in the UK 1.57% 1.55% 1.41%
As % of the Database & Business Intelligence category 5.29% 5.08% 4.75%
Number of salaries quoted 2,338 2,402 2,384
UK median annual salary £50,000 £47,500 £50,000
Median salary % change year-on-year +5.26% -5.00% +5.26%
10th Percentile £32,500 £33,000 £32,500
90th Percentile £72,500 £71,125 £70,000
UK excluding London median annual salary £44,750 £42,500 £44,000
% change year-on-year +5.29% -3.41% +3.53%

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 49,454 53,396 57,346
As % of all permanent IT jobs advertised in the UK 29.70% 30.58% 29.75%
Number of salaries quoted 40,332 43,970 48,852
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £82,500 £77,500 £75,738
UK excluding London median annual salary £45,000 £42,500 £41,500
% change year-on-year +5.88% +2.41% +3.75%

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 24 September 2018.

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 24 September 2018. 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 +5 2,480 £50,000 +5.26% 319
UK excluding London -18 1,350 £44,750 +5.29% 201
London +35 1,213 £55,000 -4.35% 128
North of England -78 358 £44,500 +4.71% 61
South East +37 350 £47,500 +5.56% 51
Midlands +9 308 £42,500 - 50
West Midlands +20 192 £40,439 -4.85% 23
East of England +13 159 £47,500 +11.76% 16
Yorkshire -64 159 £45,000 - 22
North West -87 152 £42,500 +6.25% 32
East Midlands +5 115 £43,500 -3.33% 27
South West -39 86 £40,000 -5.88% 13
Scotland +14 71 £40,000 +14.29% 9
North East +26 47 £40,000 - 7
Wales +22 24 £42,500 +6.25%
Northern Ireland +2 1 £35,000 - 1

For the 6 months to 24 September 2018, 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 2,396 (91.59%) SQL Server Integration Services
2 2,296 (87.77%) SQL Server Reporting Services
3 2,096 (80.12%) SQL
4 2,074 (79.28%) SQL Server
5 1,987 (75.96%) Business Intelligence
6 1,468 (56.12%) Microsoft
7 1,385 (52.94%) Data Warehouse
8 1,294 (49.46%) T-SQL
9 1,005 (38.42%) Power BI
10 947 (36.20%) ETL
11 639 (24.43%) Finance
12 602 (23.01%) Microsoft Azure
13 538 (20.57%) Agile Software Development
14 531 (20.30%) .NET
15 509 (19.46%) C#
16 503 (19.23%) Analytics
17 397 (15.18%) Visualisation
18 381 (14.56%) Tableau
19 354 (13.53%) SQL Server 2012
20 337 (12.88%) Data Modelling
21 322 (12.31%) Microsoft Excel
22 320 (12.23%) Microsoft Analysis Services
23 310 (11.85%) Analytical Skills
24 291 (11.12%) Performance Tuning
25 287 (10.97%) SQL Server 2016
26 275 (10.51%) Advertising
27 260 (9.94%) SQL Server 2014
28 254 (9.71%) Data Analysis Expressions (DAX)
28 254 (9.71%) SQL Server 2008
29 238 (9.10%) Degree

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 158 (6.04%) SharePoint
2 46 (1.76%) IIS
3 44 (1.68%) SAS
4 28 (1.07%) Apache Spark
5 22 (0.84%) BizTalk Server
6 14 (0.54%) CMS
6 14 (0.54%) Confluence
6 14 (0.54%) SharePoint 2013
7 12 (0.46%) NServiceBus
8 10 (0.38%) Oracle SOA Suite
9 9 (0.34%) SharePoint 2010
9 9 (0.34%) Sitecore CMS
10 7 (0.27%) Apache
10 7 (0.27%) IBM Notes
11 6 (0.23%) Plone
11 6 (0.23%) Zope
12 5 (0.19%) SharePoint Server
12 5 (0.19%) WebSphere
13 4 (0.15%) Anypoint
13 4 (0.15%) Gentran
Applications
1 322 (12.31%) Microsoft Excel
2 42 (1.61%) Microsoft Office
3 31 (1.19%) MS Visio
4 11 (0.42%) SPSS
5 9 (0.34%) Microsoft Project
6 8 (0.31%) InfoPath
7 6 (0.23%) Microsoft PowerPoint
7 6 (0.23%) Spreadsheet
8 1 (0.038%) Stata
Business Applications
1 51 (1.95%) Dynamics AX
2 49 (1.87%) Cognos TM1
3 38 (1.45%) Cognos Business Intelligence
4 33 (1.26%) Dynamics CRM
5 21 (0.80%) Dynamics NAV
6 15 (0.57%) FastStats
7 12 (0.46%) NetSuite
8 7 (0.27%) Salesforce.com CRM
9 5 (0.19%) Cognos Planning
9 5 (0.19%) HFM
9 5 (0.19%) MetaTrader
10 4 (0.15%) Oracle Receivables
11 3 (0.11%) Maximo
12 2 (0.076%) Elite 3E
12 2 (0.076%) SAP Business One
13 1 (0.038%) Markit EDM
13 1 (0.038%) Oracle BPM
13 1 (0.038%) Sage 200
Cloud Services
1 602 (23.01%) Microsoft Azure
2 188 (7.19%) Azure Data Factory
3 113 (4.32%) Amazon AWS
4 69 (2.64%) PaaS
5 40 (1.53%) Office 365
6 38 (1.45%) Data Lake Analytics
7 31 (1.19%) SaaS
8 25 (0.96%) Azure Machine Learning
8 25 (0.96%) IaaS
9 23 (0.88%) Google Analytics
10 18 (0.69%) Dynamics 365
11 12 (0.46%) Azure Active Directory
11 12 (0.46%) Cortana Intelligence Suite
12 9 (0.34%) Cloud Computing
13 6 (0.23%) GitHub
14 3 (0.11%) Amazon EC2
14 3 (0.11%) Azure Functions
14 3 (0.11%) Boomi
14 3 (0.11%) Google Cloud Platform
14 3 (0.11%) Serverless
Communications & Networking
1 20 (0.76%) Internet
2 14 (0.54%) SMS
3 12 (0.46%) SAN
4 7 (0.27%) Firewall
5 5 (0.19%) DNS
6 4 (0.15%) FTP
6 4 (0.15%) Intranet
7 2 (0.076%) Fibre Channel
7 2 (0.076%) iSCSI
7 2 (0.076%) NAS
8 1 (0.038%) DHCP
8 1 (0.038%) GoToMeeting
8 1 (0.038%) HTTP
8 1 (0.038%) LAN
8 1 (0.038%) LTE
8 1 (0.038%) SMTP
8 1 (0.038%) SSL
8 1 (0.038%) WAN
8 1 (0.038%) WebEx
Database & Business Intelligence
1 2,396 (91.59%) SQL Server Integration Services
2 2,296 (87.77%) SQL Server Reporting Services
3 2,074 (79.28%) SQL Server
4 1,385 (52.94%) Data Warehouse
5 1,005 (38.42%) Power BI
6 354 (13.53%) SQL Server 2012
7 320 (12.23%) Microsoft Analysis Services
8 287 (10.97%) SQL Server 2016
9 260 (9.94%) SQL Server 2014
10 254 (9.71%) SQL Server 2008
11 237 (9.06%) OLAP
12 206 (7.87%) Data Lake
13 196 (7.49%) Relational Database
14 183 (7.00%) Azure SQL Database
15 155 (5.93%) QlikView
16 148 (5.66%) Azure SQL Data Warehouse
17 147 (5.62%) Big Data
18 112 (4.28%) OLAP Cube
19 101 (3.86%) Hadoop
20 96 (3.67%) NoSQL
Development Applications
1 234 (8.94%) Team Foundation Server
2 149 (5.70%) Visual Studio
3 102 (3.90%) SQL Server Management Studio (SSMS)
4 46 (1.76%) JIRA
5 45 (1.72%) Git (software)
6 32 (1.22%) Visual Studio Team System
7 22 (0.84%) Eclipse
8 21 (0.80%) Jasmine
8 21 (0.80%) Karma Test Runner
8 21 (0.80%) PhantomJS
8 21 (0.80%) Subversion
8 21 (0.80%) webpack
9 15 (0.57%) Jenkins
10 14 (0.54%) RStudio
11 11 (0.42%) Chocolatey
12 8 (0.31%) ER Studio
12 8 (0.31%) Octopus Deploy
13 7 (0.27%) ERwin
13 7 (0.27%) SonarQube
14 6 (0.23%) TeamCity
General
1 639 (24.43%) Finance
2 275 (10.51%) Advertising
3 135 (5.16%) Retail
4 123 (4.70%) Banking
5 87 (3.33%) Marketing
6 35 (1.34%) Law
7 27 (1.03%) Legal
8 23 (0.88%) Investment Banking
9 20 (0.76%) Manufacturing
10 13 (0.50%) Games
11 12 (0.46%) Pharmaceutical
12 11 (0.42%) Back Office
12 11 (0.42%) Telecoms
13 8 (0.31%) General Ledger
14 4 (0.15%) Automotive
14 4 (0.15%) Electronics
15 3 (0.11%) Billing
15 3 (0.11%) Financial Institution
15 3 (0.11%) Local Government
16 2 (0.076%) Retail Banking
Job Titles
1 1,564 (59.79%) Developer
2 944 (36.09%) Business Intelligence Developer
3 642 (24.54%) SQL Developer
4 347 (13.26%) SSIS Developer
5 318 (12.16%) SQL BI Developer
6 304 (11.62%) Analyst
7 294 (11.24%) SSRS Developer
8 290 (11.09%) DBA
9 271 (10.36%) SSAS Developer
10 253 (9.67%) SQL DBA
11 236 (9.02%) SQL Server Developer
12 223 (8.52%) Consultant
13 219 (8.37%) Senior Developer
14 209 (7.99%) Business Developer
15 157 (6.00%) Data Warehouse Developer
16 156 (5.96%) Business Intelligence Analyst
17 152 (5.81%) C# Developer
18 147 (5.62%) Senior Business Intelligence Developer
19 141 (5.39%) Business Intelligence Consultant
20 131 (5.01%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 531 (20.30%) .NET
2 221 (8.45%) MDX
3 158 (6.04%) .NET Framework
4 135 (5.16%) HTML
5 131 (5.01%) Entity Framework
6 122 (4.66%) Web Services
7 107 (4.09%) CSS
8 84 (3.21%) ASP.NET
8 84 (3.21%) XML
9 83 (3.17%) AngularJS
10 77 (2.94%) jQuery
11 52 (1.99%) JSON
12 51 (1.95%) HTML5
13 48 (1.83%) REST
14 42 (1.61%) ASP.NET Web Forms
14 42 (1.61%) SOAP
15 35 (1.34%) RESTful
16 34 (1.30%) ASP.NET Web API
16 34 (1.30%) LINQ
17 28 (1.07%) WPF
Miscellaneous
1 310 (11.85%) Analytical Skills
2 124 (4.74%) Replication
3 101 (3.86%) Greenfield Project
4 86 (3.29%) Clustering
5 75 (2.87%) Computer Science
6 65 (2.48%) Data Structures
6 65 (2.48%) Management Information System
7 49 (1.87%) User Experience
8 48 (1.83%) Algorithms
9 44 (1.68%) Self-Motivation
10 42 (1.61%) Fintech
11 38 (1.45%) Reinsurance
12 29 (1.11%) NHS
13 28 (1.07%) Driving Licence
14 25 (0.96%) Enterprise Software
15 21 (0.80%) Data Centre
16 17 (0.65%) Foreign Exchange (FX)
17 16 (0.61%) Analytical Mindset
18 15 (0.57%) Client/Server
19 14 (0.54%) Public Cloud
Operating Systems
1 111 (4.24%) Windows
2 46 (1.76%) Windows Server
3 39 (1.49%) Linux
4 18 (0.69%) Windows Server 2008
5 13 (0.50%) Apple iOS
5 13 (0.50%) Windows 7
6 12 (0.46%) Windows 10
6 12 (0.46%) Windows 8
7 9 (0.34%) VMS
8 7 (0.27%) Windows Server 2012
9 4 (0.15%) Red Hat Enterprise Linux
10 2 (0.076%) Android
11 1 (0.038%) Unix
Processes & Methodologies
1 1,987 (75.96%) Business Intelligence
2 947 (36.20%) ETL
3 538 (20.57%) Agile Software Development
4 503 (19.23%) Analytics
5 397 (15.18%) Visualisation
6 337 (12.88%) Data Modelling
7 291 (11.12%) Performance Tuning
8 235 (8.98%) Problem-Solving
9 215 (8.22%) Data Analysis
10 203 (7.76%) Kimball Methodology
11 196 (7.49%) Data Visualisation
12 179 (6.84%) Dimensional Modelling
13 177 (6.77%) Migration
14 163 (6.23%) Data Management
15 158 (6.04%) Scrum
16 129 (4.93%) Data Science
16 129 (4.93%) SDLC
17 127 (4.85%) High Availability
18 117 (4.47%) Business Analysis
19 111 (4.24%) Data Analytics
Programming Languages
1 2,096 (80.12%) SQL
2 1,294 (49.46%) T-SQL
3 509 (19.46%) C#
4 254 (9.71%) Data Analysis Expressions (DAX)
5 202 (7.72%) PowerShell
6 153 (5.85%) JavaScript
7 125 (4.78%) VBA
8 118 (4.51%) Python
9 77 (2.94%) R
10 61 (2.33%) VB
11 60 (2.29%) VB.NET
12 54 (2.06%) Java
13 44 (1.68%) PL/SQL
14 28 (1.07%) U-SQL
15 27 (1.03%) PHP
16 17 (0.65%) VBScript
17 12 (0.46%) Go
18 10 (0.38%) Scala
18 10 (0.38%) Shell Script
18 10 (0.38%) Tcl
Qualifications
1 238 (9.10%) Degree
2 106 (4.05%) Microsoft Certification
3 42 (1.61%) Computer Science Degree
4 27 (1.03%) MCSE
5 25 (0.96%) Security Cleared
6 22 (0.84%) MCSA
7 17 (0.65%) MCITP
8 14 (0.54%) SC Cleared
9 12 (0.46%) Master's Degree
10 11 (0.42%) MCP
10 11 (0.42%) Microsoft Certified Architect
11 5 (0.19%) MCT
11 5 (0.19%) Numerate Degree
12 3 (0.11%) MCTS
12 3 (0.11%) PMI Certification
12 3 (0.11%) PMP
12 3 (0.11%) RHCE
12 3 (0.11%) RHCSA
13 2 (0.076%) CIPD
13 2 (0.076%) DV Cleared
Quality Assurance & Compliance
1 119 (4.55%) Data Quality
2 70 (2.68%) QA
3 38 (1.45%) SLA
4 19 (0.73%) GDPR
5 7 (0.27%) Solvency II
6 6 (0.23%) ISO/IEC 27001
7 4 (0.15%) Cyber Essentials
7 4 (0.15%) PMBOK
8 3 (0.11%) MiFID
8 3 (0.11%) PCI DSS
9 2 (0.076%) PMO
9 2 (0.076%) TickIT
10 1 (0.038%) Basel III
10 1 (0.038%) CRD IV
10 1 (0.038%) EMIR
10 1 (0.038%) Sarbanes-Oxley
System Software
1 27 (1.03%) Active Directory
2 23 (0.88%) HDFS
3 17 (0.65%) VMware Infrastructure
4 14 (0.54%) Hyper-V
5 11 (0.42%) LXC
6 6 (0.23%) Docker
7 5 (0.19%) Virtual Machines
8 4 (0.15%) Oracle RAC
9 3 (0.11%) XenApp
10 1 (0.038%) Apache Flume
10 1 (0.038%) Terminal Services
10 1 (0.038%) VMware ESXi
10 1 (0.038%) vSphere
Systems Management
1 32 (1.22%) Systems Management Server (SMS)
2 10 (0.38%) Failover Clustering
2 10 (0.38%) Microsoft Clustering
3 7 (0.27%) Opscode Chef
3 7 (0.27%) Puppet
4 6 (0.23%) Ambari
4 6 (0.23%) Ansible
5 5 (0.19%) Galera Cluster
5 5 (0.19%) SQL Sentry
6 4 (0.15%) SCOM
7 3 (0.11%) CloudHub
7 3 (0.11%) HP Quality Center
7 3 (0.11%) Kubernetes
7 3 (0.11%) Oracle Enterprise Manager
7 3 (0.11%) SCOrch
7 3 (0.11%) Symantec Enterprise Vault
8 2 (0.076%) Consul
8 2 (0.076%) Grafana
8 2 (0.076%) Prometheus
8 2 (0.076%) Terraform
Vendors
1 1,468 (56.12%) Microsoft
2 381 (14.56%) Tableau
3 179 (6.84%) Oracle
4 136 (5.20%) Cognos
5 57 (2.18%) SAP
6 38 (1.45%) Google
7 33 (1.26%) MicroStrategy
8 31 (1.19%) Informatica
9 30 (1.15%) IBM
10 29 (1.11%) Salesforce.com
11 23 (0.88%) VMware
12 20 (0.76%) Databricks
12 20 (0.76%) Talend
13 17 (0.65%) Hyperion
14 16 (0.61%) Alteryx
15 14 (0.54%) ServiceNow
16 13 (0.50%) JD Edwards
17 12 (0.46%) MuleSoft
17 12 (0.46%) Nintex
18 11 (0.42%) RedGate