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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
20 May 2018
Same period 2017 Same period 2016
Rank 204 200 200
Rank change year-on-year -4 0 -16
Permanent jobs citing SQL Server Analysis Services 2,874 2,890 3,535
As % of all permanent IT jobs advertised in the UK 1.67% 1.69% 1.76%
As % of the Database & Business Intelligence category 5.45% 5.48% 5.67%
Number of salaries quoted 2,548 2,639 3,065
UK median annual salary £50,000 £48,500 £47,500
Median salary % change year-on-year +3.09% +2.11% +5.56%
10th Percentile £32,500 £33,000 £32,500
90th Percentile £70,000 £71,250 £72,500
UK excluding London median annual salary £45,000 £42,500 £45,000
% change year-on-year +5.88% -5.56% +8.43%

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 52,722 52,713 62,384
As % of all permanent IT jobs advertised in the UK 30.67% 30.90% 31.04%
Number of salaries quoted 43,361 44,758 53,074
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,750 £28,750
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £44,000 £42,000 £41,500
% change year-on-year +4.76% +1.20% +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 20 May 2018.

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 20 May 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,732 £50,000 - 258
UK excluding London +12 1,630 £45,000 +5.88% 161
London -23 1,176 £55,000 -4.35% 110
North of England -22 494 £42,500 - 50
South East -1 379 £45,000 -10.00% 32
Midlands +9 343 £45,000 +5.88% 35
Yorkshire -6 241 £45,000 - 22
West Midlands +14 230 £42,500 +6.25% 16
East of England +68 213 £50,000 +11.11% 13
North West -47 201 £42,500 +6.25% 21
South West +31 118 £40,000 -5.33% 17
East Midlands -9 113 £45,000 - 18
Scotland +14 76 £43,000 +22.86% 11
North East +27 52 £36,500 +4.29% 7
Wales +10 26 £42,500 -5.56% 3
Northern Ireland +2 1 £32,500 -10.34%
Channel Islands - 1 £60,000 -

For the 6 months to 20 May 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,650 (92.21%) SQL Server Integration Services
2 2,527 (87.93%) SQL Server Reporting Services
3 2,364 (82.25%) SQL
4 2,328 (81.00%) SQL Server
5 2,165 (75.33%) Business Intelligence
6 1,575 (54.80%) Microsoft
7 1,475 (51.32%) Data Warehouse
8 1,468 (51.08%) T-SQL
9 1,009 (35.11%) Power BI
10 999 (34.76%) ETL
11 645 (22.44%) Finance
12 626 (21.78%) Microsoft Azure
13 544 (18.93%) .NET
14 524 (18.23%) Agile Software Development
15 498 (17.33%) Analytics
16 482 (16.77%) C#
17 432 (15.03%) Tableau
18 405 (14.09%) SQL Server 2016
19 396 (13.78%) Data Modelling
20 395 (13.74%) Performance Tuning
21 375 (13.05%) Advertising
22 373 (12.98%) Microsoft Analysis Services
23 370 (12.87%) Visualisation
24 356 (12.39%) SQL Server 2012
25 328 (11.41%) SQL Server 2014
26 286 (9.95%) Analytical Skills
26 286 (9.95%) Kimball Methodology
27 280 (9.74%) PowerShell
28 259 (9.01%) OLAP
29 258 (8.98%) Migration

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 151 (5.25%) SharePoint
2 36 (1.25%) BizTalk Server
3 35 (1.22%) Apache Spark
3 35 (1.22%) IIS
4 34 (1.18%) SAS
5 15 (0.52%) JBoss
6 14 (0.49%) Oracle SOA Suite
7 12 (0.42%) SharePoint 2010
8 10 (0.35%) Anypoint
8 10 (0.35%) SharePoint Server
8 10 (0.35%) Umbraco
9 7 (0.24%) Confluence
10 6 (0.21%) Apache
10 6 (0.21%) NServiceBus
10 6 (0.21%) SharePoint 2013
11 4 (0.14%) Gentran
11 4 (0.14%) WordPress
12 3 (0.10%) IBM Notes
13 2 (0.070%) Blackberry Enterprise Server
13 2 (0.070%) OpenEdge
Applications
1 248 (8.63%) Microsoft Excel
2 48 (1.67%) Microsoft Office
3 29 (1.01%) MS Visio
4 20 (0.70%) Spreadsheet
5 8 (0.28%) SPSS
6 7 (0.24%) InfoPath
7 6 (0.21%) Microsoft Project
8 5 (0.17%) Microsoft PowerPoint
9 3 (0.10%) Stata
10 1 (0.035%) Weka
Business Applications
1 70 (2.44%) Dynamics AX
2 27 (0.94%) Dynamics CRM
3 21 (0.73%) NetSuite
4 15 (0.52%) Cognos TM1
5 14 (0.49%) MetaTrader
6 12 (0.42%) Cognos Business Intelligence
7 10 (0.35%) Elite 3E
8 9 (0.31%) Dynamics NAV
9 8 (0.28%) Markit EDM
10 6 (0.21%) Postilion
11 5 (0.17%) Dynamics SL
11 5 (0.17%) Salesforce.com CRM
12 4 (0.14%) Oracle Receivables
12 4 (0.14%) Sage 200
12 4 (0.14%) thinkFolio
13 3 (0.10%) Adobe Campaign
13 3 (0.10%) Cognos Planning
13 3 (0.10%) HFM
14 2 (0.070%) Unit4 Business World
15 1 (0.035%) Oracle ERP
Cloud Services
1 626 (21.78%) Microsoft Azure
2 200 (6.96%) Azure Data Factory
3 86 (2.99%) Amazon AWS
4 48 (1.67%) PaaS
5 37 (1.29%) SaaS
6 34 (1.18%) Office 365
7 32 (1.11%) Dynamics 365
8 29 (1.01%) Cortana Intelligence Suite
9 28 (0.97%) Google Analytics
10 25 (0.87%) Azure Machine Learning
11 15 (0.52%) IaaS
12 11 (0.38%) Data Lake Analytics
13 6 (0.21%) Google Cloud Platform
14 5 (0.17%) Cloud Computing
14 5 (0.17%) Serverless
15 4 (0.14%) Amazon EC2
15 4 (0.14%) Amazon S3
15 4 (0.14%) Azure Active Directory
15 4 (0.14%) Google Tag Manager
16 3 (0.10%) OneDrive
Communications & Networking
1 38 (1.32%) Internet
2 25 (0.87%) SMS
3 7 (0.24%) Firewall
4 6 (0.21%) FTP
4 6 (0.21%) SAN
5 5 (0.17%) DNS
6 4 (0.14%) Network Security
7 3 (0.10%) Wireless
8 2 (0.070%) NAS
9 1 (0.035%) GoToMeeting
9 1 (0.035%) Intranet
9 1 (0.035%) LTE
9 1 (0.035%) SSL
9 1 (0.035%) TCP/IP
9 1 (0.035%) WebEx
Database & Business Intelligence
1 2,650 (92.21%) SQL Server Integration Services
2 2,527 (87.93%) SQL Server Reporting Services
3 2,328 (81.00%) SQL Server
4 1,475 (51.32%) Data Warehouse
5 1,009 (35.11%) Power BI
6 405 (14.09%) SQL Server 2016
7 373 (12.98%) Microsoft Analysis Services
8 356 (12.39%) SQL Server 2012
9 328 (11.41%) SQL Server 2014
10 259 (9.01%) OLAP
11 227 (7.90%) SQL Server 2008
12 213 (7.41%) Data Lake
13 206 (7.17%) QlikView
14 186 (6.47%) Big Data
15 170 (5.92%) Relational Database
16 143 (4.98%) Azure SQL Database
17 132 (4.59%) Azure SQL Data Warehouse
18 116 (4.04%) Hadoop
19 104 (3.62%) OLTP
20 99 (3.44%) HDInsight
Development Applications
1 183 (6.37%) Team Foundation Server
2 164 (5.71%) Visual Studio
3 160 (5.57%) SQL Server Management Studio (SSMS)
4 50 (1.74%) JIRA
5 28 (0.97%) Jenkins
6 27 (0.94%) Git (software)
7 26 (0.90%) Visual Studio Team System
8 24 (0.84%) Octopus Deploy
9 22 (0.77%) Jasmine
9 22 (0.77%) Karma Test Runner
9 22 (0.77%) PhantomJS
9 22 (0.77%) webpack
10 18 (0.63%) Eclipse
11 13 (0.45%) TeamCity
12 12 (0.42%) RStudio
12 12 (0.42%) Subversion
13 10 (0.35%) MorphX
14 9 (0.31%) MSTest
15 7 (0.24%) ERwin
16 6 (0.21%) Selenium
General
1 645 (22.44%) Finance
2 375 (13.05%) Advertising
3 132 (4.59%) Marketing
3 132 (4.59%) Retail
4 86 (2.99%) Banking
5 40 (1.39%) Legal
6 38 (1.32%) Law
7 35 (1.22%) Manufacturing
8 21 (0.73%) Games
9 13 (0.45%) Billing
10 11 (0.38%) Investment Banking
11 9 (0.31%) Telecoms
12 6 (0.21%) Electronics
12 6 (0.21%) Front Office
13 5 (0.17%) Back Office
13 5 (0.17%) Publishing
14 3 (0.10%) Aerospace
15 2 (0.070%) Financial Institution
15 2 (0.070%) Retail Finance
16 1 (0.035%) Pharmaceutical
Job Titles
1 1,643 (57.17%) Developer
2 999 (34.76%) Business Intelligence Developer
3 647 (22.51%) SQL Developer
4 411 (14.30%) DBA
5 348 (12.11%) SQL DBA
6 341 (11.86%) SQL BI Developer
7 318 (11.06%) Analyst
8 301 (10.47%) SSIS Developer
9 274 (9.53%) SSRS Developer
10 272 (9.46%) SQL Server Developer
11 226 (7.86%) Consultant
12 218 (7.59%) SSAS Developer
13 206 (7.17%) Business Developer
14 189 (6.58%) Data Warehouse Developer
15 178 (6.19%) Senior Developer
16 156 (5.43%) SQL Server DBA
17 153 (5.32%) Business Intelligence Consultant
18 144 (5.01%) Administrator
19 139 (4.84%) SQL Server BI Developer
20 137 (4.77%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 544 (18.93%) .NET
2 204 (7.10%) MDX
3 137 (4.77%) ASP.NET
4 133 (4.63%) Web Services
5 123 (4.28%) HTML
6 109 (3.79%) .NET Framework
7 97 (3.38%) Entity Framework
8 92 (3.20%) CSS
9 78 (2.71%) REST
10 76 (2.64%) HTML5
11 65 (2.26%) XML
12 61 (2.12%) WPF
13 58 (2.02%) SOAP
14 54 (1.88%) jQuery
15 51 (1.77%) AngularJS
16 50 (1.74%) JSON
17 45 (1.57%) ASP.NET MVC
18 37 (1.29%) RESTful
19 32 (1.11%) LINQ
20 29 (1.01%) ASP.NET Web API
Miscellaneous
1 286 (9.95%) Analytical Skills
2 144 (5.01%) Replication
3 108 (3.76%) Clustering
4 85 (2.96%) Greenfield Project
5 82 (2.85%) Management Information System
6 77 (2.68%) Self-Motivation
7 65 (2.26%) Computer Science
8 64 (2.23%) Fintech
9 63 (2.19%) Data Structures
10 36 (1.25%) User Experience
11 30 (1.04%) Driving Licence
12 27 (0.94%) Algorithms
13 26 (0.90%) Enterprise Software
14 21 (0.73%) Virtual Team
15 18 (0.63%) Client/Server
16 17 (0.59%) Reinsurance
17 16 (0.56%) Foreign Exchange (FX)
18 14 (0.49%) Data Centre
18 14 (0.49%) Hedge funds
18 14 (0.49%) NHS
Operating Systems
1 140 (4.87%) Windows
2 50 (1.74%) Windows Server
3 44 (1.53%) Linux
4 23 (0.80%) VMS
5 15 (0.52%) Windows Server 2012
6 13 (0.45%) Windows Server 2008
7 9 (0.31%) Unix
8 4 (0.14%) Red Hat Enterprise Linux
9 3 (0.10%) Apple iOS
10 2 (0.070%) Android
11 1 (0.035%) Windows 10
11 1 (0.035%) Windows 7
11 1 (0.035%) Windows 8
11 1 (0.035%) Windows Mobile
Processes & Methodologies
1 2,165 (75.33%) Business Intelligence
2 999 (34.76%) ETL
3 524 (18.23%) Agile Software Development
4 498 (17.33%) Analytics
5 396 (13.78%) Data Modelling
6 395 (13.74%) Performance Tuning
7 370 (12.87%) Visualisation
8 286 (9.95%) Kimball Methodology
9 258 (8.98%) Migration
10 254 (8.84%) Problem-Solving
11 214 (7.45%) Data Visualisation
12 169 (5.88%) Data Analysis
13 155 (5.39%) Data Analytics
14 144 (5.01%) Scrum
15 134 (4.66%) SDLC
16 128 (4.45%) Dimensional Modelling
17 125 (4.35%) Mentoring
18 117 (4.07%) Data Integration
19 114 (3.97%) Business Analysis
20 113 (3.93%) CRM
Programming Languages
1 2,364 (82.25%) SQL
2 1,468 (51.08%) T-SQL
3 482 (16.77%) C#
4 280 (9.74%) PowerShell
5 198 (6.89%) Data Analysis Expressions (DAX)
6 142 (4.94%) JavaScript
7 103 (3.58%) Python
8 94 (3.27%) VBA
9 90 (3.13%) R
10 77 (2.68%) VB.NET
11 61 (2.12%) VB
12 45 (1.57%) Java
13 40 (1.39%) PL/SQL
14 27 (0.94%) X++
15 14 (0.49%) U-SQL
16 10 (0.35%) VBScript
17 9 (0.31%) MATLAB
17 9 (0.31%) TypeScript
18 8 (0.28%) PHP
18 8 (0.28%) Shell Script
Qualifications
1 200 (6.96%) Degree
2 109 (3.79%) Microsoft Certification
3 31 (1.08%) MCSE
4 28 (0.97%) Computer Science Degree
5 26 (0.90%) MCSA
5 26 (0.90%) Security Cleared
6 14 (0.49%) MCITP
7 12 (0.42%) SC Cleared
8 11 (0.38%) MCP
9 9 (0.31%) MBA
10 8 (0.28%) ITIL Certification
10 8 (0.28%) Microsoft Certified Architect
10 8 (0.28%) Numerate Degree
11 7 (0.24%) MCTS
11 7 (0.24%) Postgraduate
12 5 (0.17%) Master's Degree
12 5 (0.17%) MCSD
12 5 (0.17%) PhD
13 4 (0.14%) ISEB
13 4 (0.14%) PMP
Quality Assurance & Compliance
1 111 (3.86%) Data Quality
2 90 (3.13%) QA
3 35 (1.22%) GDPR
4 19 (0.66%) SLA
5 10 (0.35%) PMO
6 3 (0.10%) ISO/IEC 27001
6 3 (0.10%) PCI DSS
7 2 (0.070%) TickIT
8 1 (0.035%) Basel III
8 1 (0.035%) CRD IV
8 1 (0.035%) MiFID
System Software
1 39 (1.36%) HDFS
2 32 (1.11%) Active Directory
3 6 (0.21%) Virtual Machines
4 4 (0.14%) Oracle RAC
5 3 (0.10%) Docker
5 3 (0.10%) VMware Infrastructure
6 1 (0.035%) Virtual Servers
Systems Management
1 25 (0.87%) Failover Clustering
2 24 (0.84%) Systems Management Server (SMS)
3 16 (0.56%) Opscode Chef
4 14 (0.49%) Ambari
5 11 (0.38%) Puppet
6 7 (0.24%) Galera Cluster
7 6 (0.21%) Microsoft Clustering
8 5 (0.17%) Data Guard
8 5 (0.17%) SQL Sentry
9 4 (0.14%) CloudHub
9 4 (0.14%) Control-M
10 3 (0.10%) HP Quality Center
11 2 (0.070%) Hadoop YARN
11 2 (0.070%) HP ALM
11 2 (0.070%) Oracle RMAN
11 2 (0.070%) SCOM
12 1 (0.035%) HP Data Protector
12 1 (0.035%) Oracle Enterprise Manager
12 1 (0.035%) SCCM
12 1 (0.035%) Single Sign-On
Vendors
1 1,575 (54.80%) Microsoft
2 432 (15.03%) Tableau
3 193 (6.72%) Oracle
4 114 (3.97%) Cognos
5 60 (2.09%) SAP
6 48 (1.67%) Google
7 26 (0.90%) Facebook
8 24 (0.84%) Alteryx
8 24 (0.84%) RedGate
9 21 (0.73%) JD Edwards
10 19 (0.66%) Salesforce.com
11 18 (0.63%) Talend
11 18 (0.63%) VMware
12 17 (0.59%) Informatica
13 15 (0.52%) IBM
13 15 (0.52%) Siebel
14 14 (0.49%) MicroStrategy
14 14 (0.49%) WorldPay
15 12 (0.42%) Aderant
15 12 (0.42%) Twitter