Period
to 23 August 2017

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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
23 Aug 2017
Same period 2016 Same period 2015
Rank 222 236 170
Rank change year-on-year +14 -66 +4
Permanent jobs citing SQL Server Analysis Services 2819 2801 4201
As % of all permanent IT jobs advertised in the UK 1.60% 1.42% 1.94%
As % of the Database & Business Intelligence category 5.21% 4.75% 6.11%
Number of salaries quoted 2512 2447 3737
UK median annual salary £47,500 £47,500 £47,500
10th Percentile £33,000 £32,500 £32,000
90th Percentile £71,250 £70,000 £73,500
UK excluding London median annual salary £42,500 £42,500 £42,500

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 54094 58998 68754
As % of all permanent IT jobs advertised in the UK 30.74% 29.99% 31.74%
Number of salaries quoted 44880 50389 57983
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £28,750 £27,500
90th Percentile £77,500 £75,000 £72,500
UK excluding London median annual salary £42,500 £41,000 £40,000
% change year-on-year +3.66% +2.50% -

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 23 August 2017.

Salary histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 15 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 23 August 2017. 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 +34 2728 £47,500 -4.04% 121
UK excluding London +53 1630 £42,500 - 87
London -8 1144 £57,500 +4.55% 38
North of England +55 695 £42,500 - 40
North West +30 357 £40,000 -5.88% 16
Yorkshire +62 332 £45,000 +5.88% 23
Midlands +97 319 £42,500 +3.66% 9
South East +21 303 £45,000 -1.10% 15
West Midlands +80 195 £42,000 +5.00% 7
East of England +17 149 £42,500 -5.03% 9
East Midlands +45 122 £45,000 +2.27% 2
South West -47 109 £41,750 +4.38% 9
Scotland -1 43 £35,000 -17.65% 5
Wales -30 12 £40,000 - 1
North East -8 6 £38,000 -6.17% 1

For the 6 months to 23 August 2017, IT jobs citing SQL Server Analysis Services also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for SQL Server Analysis Services.

1 2565 (90.99%) SQL Server Integration Services
2 2424 (85.99%) SQL Server Reporting Services
3 2379 (84.39%) SQL Server
4 2361 (83.75%) SQL
5 2146 (76.13%) Business Intelligence
6 1578 (55.98%) Microsoft
7 1467 (52.04%) Data Warehouse
8 1445 (51.26%) T-SQL
9 1050 (37.25%) ETL
10 733 (26.00%) Power BI
11 716 (25.40%) Finance
12 655 (23.24%) Agile Software Development
13 559 (19.83%) .NET
14 515 (18.27%) SQL Server 2008
15 502 (17.81%) Microsoft Azure
16 478 (16.96%) C#
17 469 (16.64%) SQL Server 2012
18 454 (16.11%) SQL Server 2014
19 439 (15.57%) SQL Server 2016
20 404 (14.33%) Performance Tuning
21 398 (14.12%) Microsoft Analysis Services
22 382 (13.55%) Data Modelling
23 368 (13.05%) MDX
24 348 (12.34%) OLAP
25 347 (12.31%) Tableau
26 315 (11.17%) QlikView
27 313 (11.10%) Kimball Methodology
28 301 (10.68%) Analytics
29 280 (9.93%) Oracle
30 273 (9.68%) Relational Database

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 188 (6.67%) SharePoint
2 84 (2.98%) IIS
3 41 (1.45%) SAS
4 30 (1.06%) BizTalk Server
5 26 (0.92%) Confluence
6 23 (0.82%) Apache
7 18 (0.64%) SharePoint 2010
7 18 (0.64%) SharePoint 2013
8 16 (0.57%) MS Exchange
9 14 (0.50%) Apache Spark
10 13 (0.46%) Oracle SOA Suite
11 11 (0.39%) WebSphere
12 10 (0.35%) JBoss
13 9 (0.32%) Anypoint
14 7 (0.25%) WordPress
15 6 (0.21%) Exchange Server 2010
15 6 (0.21%) Exchange Server 2013
15 6 (0.21%) SharePoint Server
16 4 (0.14%) CMS
17 3 (0.11%) Gentran
Applications
1 223 (7.91%) Microsoft Excel
2 67 (2.38%) MS Visio
3 65 (2.31%) Microsoft Office
4 17 (0.60%) SPSS
5 10 (0.35%) Microsoft Project
6 8 (0.28%) Spreadsheet
6 8 (0.28%) Stata
7 6 (0.21%) Microsoft PowerPoint
Business Applications
1 65 (2.31%) Dynamics AX
2 43 (1.53%) Dynamics CRM
3 33 (1.17%) Dynamics NAV
4 20 (0.71%) Cognos Business Intelligence
5 16 (0.57%) Cognos TM1
6 14 (0.50%) Markit EDM
7 11 (0.39%) Infor SunSystems
8 9 (0.32%) thinkFolio
9 5 (0.18%) Sage 200
10 4 (0.14%) Maximo
11 3 (0.11%) Oracle Applications
12 2 (0.071%) Dynamics GP
12 2 (0.071%) HFM
12 2 (0.071%) Misys Opics
12 2 (0.071%) Softmar
12 2 (0.071%) Workday HCM
13 1 (0.035%) Cognos Planning
13 1 (0.035%) Eagle PACE
13 1 (0.035%) Payment Gateway
13 1 (0.035%) Sage 50
Cloud Services
1 502 (17.81%) Microsoft Azure
2 91 (3.23%) Amazon AWS
3 61 (2.16%) Azure Machine Learning
4 47 (1.67%) Dynamics 365
5 41 (1.45%) SaaS
6 39 (1.38%) Azure Data Factory
7 32 (1.14%) IaaS
8 26 (0.92%) Office 365
9 17 (0.60%) Google Play
10 16 (0.57%) PaaS
11 15 (0.53%) Cortana Intelligence Suite
11 15 (0.53%) Firebase
12 13 (0.46%) Google Analytics
13 7 (0.25%) GitHub
14 6 (0.21%) Google Cloud Platform
15 4 (0.14%) Data Lake Analytics
16 3 (0.11%) Amazon EMR
16 3 (0.11%) Amazon S3
16 3 (0.11%) Boomi
16 3 (0.11%) Cloud Computing
Communications & Networking
1 54 (1.92%) Internet
2 18 (0.64%) Firewall
3 14 (0.50%) SAN
4 9 (0.32%) DNS
4 9 (0.32%) Skype
5 8 (0.28%) DHCP
5 8 (0.28%) Intranet
5 8 (0.28%) NAS
6 7 (0.25%) DMZ
6 7 (0.25%) FTP
7 6 (0.21%) Network Security
7 6 (0.21%) SMTP
7 6 (0.21%) SNMP
7 6 (0.21%) VoIP
8 5 (0.18%) AMQP
8 5 (0.18%) Broadband
9 4 (0.14%) GoToMeeting
9 4 (0.14%) WebEx
10 3 (0.11%) SSL
10 3 (0.11%) TCP/IP
Database & Business Intelligence
1 2565 (90.99%) SQL Server Integration Services
2 2424 (85.99%) SQL Server Reporting Services
3 2379 (84.39%) SQL Server
4 1467 (52.04%) Data Warehouse
5 733 (26.00%) Power BI
6 515 (18.27%) SQL Server 2008
7 469 (16.64%) SQL Server 2012
8 454 (16.11%) SQL Server 2014
9 439 (15.57%) SQL Server 2016
10 398 (14.12%) Microsoft Analysis Services
11 348 (12.34%) OLAP
12 315 (11.17%) QlikView
13 273 (9.68%) Relational Database
14 270 (9.58%) Big Data
15 187 (6.63%) OLAP Cube
16 151 (5.36%) NoSQL
17 141 (5.00%) RDBMS
18 132 (4.68%) MySQL
19 123 (4.36%) SQL Server 2005
20 119 (4.22%) Hadoop
Development Applications
1 205 (7.27%) Visual Studio
2 161 (5.71%) Team Foundation Server
3 116 (4.11%) SQL Server Management Studio (SSMS)
4 60 (2.13%) Octopus Deploy
5 56 (1.99%) JIRA
6 51 (1.81%) TeamCity
7 43 (1.53%) Git (software)
8 39 (1.38%) Jenkins
9 38 (1.35%) Subversion
10 21 (0.74%) PowerDesigner
10 21 (0.74%) Selenium
11 20 (0.71%) Jasmine
12 16 (0.57%) webpack
13 15 (0.53%) ERwin
13 15 (0.53%) Karma Test Runner
13 15 (0.53%) PhantomJS
14 14 (0.50%) SpecFlow
15 13 (0.46%) MSTest
16 8 (0.28%) TortoiseSVN
17 7 (0.25%) Visual Studio Tools for Office
General
1 716 (25.40%) Finance
2 238 (8.44%) Retail
3 164 (5.82%) Legal
4 163 (5.78%) Advertising
5 130 (4.61%) Banking
6 123 (4.36%) Marketing
7 64 (2.27%) Games
8 56 (1.99%) Law
9 46 (1.63%) Electronics
10 44 (1.56%) Manufacturing
11 41 (1.45%) Investment Banking
12 38 (1.35%) Front Office
12 38 (1.35%) Telecoms
13 26 (0.92%) Publishing
14 16 (0.57%) Back Office
15 14 (0.50%) Automotive
16 8 (0.28%) Pharmaceutical
16 8 (0.28%) Retail Banking
17 5 (0.18%) Billing
17 5 (0.18%) Music Industry
Job Titles
1 1607 (57.01%) Developer
2 898 (31.86%) Business Intelligence Developer
3 784 (27.81%) SQL Developer
4 417 (14.79%) DBA
5 374 (13.27%) SQL BI Developer
6 363 (12.88%) SQL DBA
7 347 (12.31%) SQL Server Developer
8 340 (12.06%) Analyst
9 287 (10.18%) SSIS Developer
10 240 (8.51%) SSRS Developer
11 236 (8.37%) Senior Developer
12 231 (8.19%) SSAS Developer
13 185 (6.56%) Data Warehouse Developer
14 184 (6.53%) Business Developer
15 169 (6.00%) Administrator
16 166 (5.89%) Consultant
17 155 (5.50%) SQL Server BI Developer
18 153 (5.43%) SQL Server DBA
19 152 (5.39%) Business Intelligence Analyst
20 142 (5.04%) Architect
Libraries, Frameworks & Software Standards
1 559 (19.83%) .NET
2 368 (13.05%) MDX
3 190 (6.74%) ASP.NET
4 161 (5.71%) HTML
5 116 (4.11%) CSS
6 97 (3.44%) Web Services
7 96 (3.41%) XML
8 85 (3.02%) HTML5
9 78 (2.77%) .NET Framework
10 64 (2.27%) AngularJS
10 64 (2.27%) Entity Framework
11 59 (2.09%) SOAP
12 54 (1.92%) ASP.NET MVC
13 50 (1.77%) ASP.NET Web API
14 46 (1.63%) jQuery
15 44 (1.56%) Node.js
16 42 (1.49%) WPF
17 39 (1.38%) REST
17 39 (1.38%) RESTful
18 33 (1.17%) WCF
Miscellaneous
1 267 (9.47%) Analytical Skills
2 170 (6.03%) Replication
3 143 (5.07%) Clustering
4 121 (4.29%) Management Information System
5 114 (4.04%) Computer Science
6 86 (3.05%) Greenfield Project
7 40 (1.42%) Data Structures
8 36 (1.28%) Client/Server
9 32 (1.14%) NHS
10 29 (1.03%) Enterprise Software
10 29 (1.03%) Fintech
11 26 (0.92%) Data Protection Act
11 26 (0.92%) Mobile App
12 25 (0.89%) BBC
13 24 (0.85%) Social Media
13 24 (0.85%) User Experience
14 23 (0.82%) iPad
15 19 (0.67%) Credit Risk
16 18 (0.64%) Blog
17 17 (0.60%) iPhone
Operating Systems
1 265 (9.40%) Windows
2 131 (4.65%) Windows Server
3 77 (2.73%) Linux
4 40 (1.42%) Android
5 25 (0.89%) Unix
6 24 (0.85%) Windows Server 2012
7 23 (0.82%) Apple iOS
8 20 (0.71%) Windows Server 2008
9 5 (0.18%) Windows 7
10 4 (0.14%) Solaris
11 3 (0.11%) Windows 10
12 2 (0.071%) AIX
12 2 (0.071%) VMS
13 1 (0.035%) CentOS
13 1 (0.035%) Mac OS X
13 1 (0.035%) Windows Server 2003
Processes & Methodologies
1 2146 (76.13%) Business Intelligence
2 1050 (37.25%) ETL
3 655 (23.24%) Agile Software Development
4 404 (14.33%) Performance Tuning
5 382 (13.55%) Data Modelling
6 313 (11.10%) Kimball Methodology
7 301 (10.68%) Analytics
8 264 (9.37%) Visualisation
9 219 (7.77%) Data Visualisation
10 202 (7.17%) Mentoring
11 196 (6.95%) Scrum
12 192 (6.81%) Migration
13 177 (6.28%) High Availability
14 153 (5.43%) Data Management
15 148 (5.25%) Disaster Recovery
16 143 (5.07%) E-Commerce
17 136 (4.82%) CRM
18 127 (4.51%) ERP
19 120 (4.26%) Dimensional Modelling
20 115 (4.08%) SDLC
Programming Languages
1 2361 (83.75%) SQL
2 1445 (51.26%) T-SQL
3 478 (16.96%) C#
4 216 (7.66%) PowerShell
5 147 (5.21%) Data Analysis Expressions (DAX)
6 127 (4.51%) Java
7 118 (4.19%) JavaScript
8 107 (3.80%) VB.NET
9 94 (3.33%) R
10 85 (3.02%) VBA
11 81 (2.87%) VB
12 60 (2.13%) Python
13 40 (1.42%) C
13 40 (1.42%) PL/SQL
14 32 (1.14%) VBScript
15 31 (1.10%) Perl
16 28 (0.99%) Ruby
16 28 (0.99%) X++
17 27 (0.96%) VB6
18 18 (0.64%) PHP
Qualifications
1 261 (9.26%) Degree
2 158 (5.60%) Microsoft Certification
3 41 (1.45%) Numerate Degree
4 37 (1.31%) Computer Science Degree
5 36 (1.28%) MCSE
6 30 (1.06%) MCITP
7 24 (0.85%) MCTS
8 23 (0.82%) MCSA
9 16 (0.57%) Master's Degree
10 14 (0.50%) Security Cleared
11 13 (0.46%) PhD
11 13 (0.46%) SC Cleared
12 11 (0.39%) ITIL Certification
13 6 (0.21%) CCNP
13 6 (0.21%) CCVP
13 6 (0.21%) Cisco Certification
13 6 (0.21%) MCP
14 5 (0.18%) CCSP
15 4 (0.14%) PRINCE2 Practitioner
16 3 (0.11%) MCSD
Quality Assurance & Compliance
1 119 (4.22%) Data Quality
2 69 (2.45%) QA
3 31 (1.10%) PCI DSS
4 27 (0.96%) GDPR
4 27 (0.96%) SLA
5 16 (0.57%) ISO/IEC 27001
6 6 (0.21%) Cyber Essentials
7 4 (0.14%) MiFID
8 3 (0.11%) COBIT
8 3 (0.11%) ISO 9001
9 2 (0.071%) HL7
9 2 (0.071%) PMO
10 1 (0.035%) DICOM
System Software
1 79 (2.80%) Active Directory
2 14 (0.50%) Docker
2 14 (0.50%) VMware Infrastructure
3 10 (0.35%) Virtual Machines
4 7 (0.25%) Oracle RAC
5 6 (0.21%) HDFS
5 6 (0.21%) ISA Server
6 3 (0.11%) Hyper-V
6 3 (0.11%) Microsoft App-V
6 3 (0.11%) Microsoft Virtual Server
6 3 (0.11%) Virtual Servers
7 1 (0.035%) Apache Flume
Systems Management
1 44 (1.56%) Failover Clustering
2 19 (0.67%) Puppet
3 18 (0.64%) Perfmon
4 11 (0.39%) Control-M
5 10 (0.35%) Grafana
6 6 (0.21%) Ansible
6 6 (0.21%) CA Single Sign-On
6 6 (0.21%) SQL Sentry
7 5 (0.18%) Systems Management Server (SMS)
8 4 (0.14%) Microsoft Clustering
9 3 (0.11%) Nagios
9 3 (0.11%) Netcool
9 3 (0.11%) Oozie
9 3 (0.11%) Opscode Chef
10 2 (0.071%) Data Guard
10 2 (0.071%) Kibana
10 2 (0.071%) Oracle RMAN
11 1 (0.035%) Cisco Prime
11 1 (0.035%) HP Quality Center
11 1 (0.035%) Oracle Enterprise Manager
Vendors
1 1578 (55.98%) Microsoft
2 347 (12.31%) Tableau
3 280 (9.93%) Oracle
4 123 (4.36%) Cognos
5 92 (3.26%) SAP
6 61 (2.16%) Sybase
7 57 (2.02%) Google
8 51 (1.81%) IBM
9 45 (1.60%) Facebook
10 29 (1.03%) MicroStrategy
10 29 (1.03%) VMware
11 25 (0.89%) JD Edwards
12 24 (0.85%) Apple
12 24 (0.85%) Informatica
12 24 (0.85%) Sony
12 24 (0.85%) Yahoo!
13 23 (0.82%) Salesforce.com
14 17 (0.60%) MuleSoft
14 17 (0.60%) RedGate
15 15 (0.53%) Sun