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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 239 242 177
Rank change year-on-year +3 -65 +3
Permanent jobs citing SQL Server Analysis Services 2618 2695 4213
As % of all permanent IT jobs advertised in the UK 1.45% 1.43% 1.94%
As % of the Database & Business Intelligence category 4.78% 4.81% 6.15%
Number of salaries quoted 2320 2427 3724
UK median annual salary £47,500 £50,000 £47,500
Median salary % change year-on-year -5.00% +5.26% +5.56%
10th Percentile £32,500 £32,500 £32,500
90th Percentile £70,000 £71,250 £73,500
UK excluding London median annual salary £42,500 £45,000 £43,527
% change year-on-year -5.56% +3.39% +6.16%

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 54745 56049 68490
As % of all permanent IT jobs advertised in the UK 30.26% 29.67% 31.51%
Number of salaries quoted 45083 47949 57675
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

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 21 November 2017.

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 21 November 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 +1 2520 £47,500 -5.00% 150
UK excluding London +31 1548 £42,500 -5.56% 94
London -21 1019 £57,500 - 59
North of England +24 603 £41,500 -2.35% 50
Yorkshire +44 299 £45,000 +5.88% 19
Midlands +84 291 £42,500 - 8
South East -37 285 £45,000 -5.26% 17
North West -3 284 £40,000 -5.88% 23
West Midlands +52 180 £42,500 - 5
East of England +29 157 £42,500 -15.00% 11
South West +27 148 £42,500 +3.66% 5
East Midlands +81 109 £43,250 +1.76% 3
Scotland -12 47 £39,500 -4.64% 3
North East +3 20 £35,000 -12.50% 8
Wales -4 12 £53,750 +30.30%
Channel Islands +3 4 £60,000 -
Northern Ireland -28 1 £35,000 -12.50%

For the 6 months to 21 November 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 2391 (91.33%) SQL Server Integration Services
2 2255 (86.13%) SQL Server Reporting Services
3 2234 (85.33%) SQL
4 2173 (83.00%) SQL Server
5 1972 (75.32%) Business Intelligence
6 1407 (53.74%) Microsoft
7 1382 (52.79%) T-SQL
8 1323 (50.53%) Data Warehouse
9 1020 (38.96%) ETL
10 707 (27.01%) Power BI
11 667 (25.48%) Finance
12 534 (20.40%) Agile Software Development
13 518 (19.79%) .NET
14 472 (18.03%) Microsoft Azure
15 434 (16.58%) SQL Server 2014
16 433 (16.54%) SQL Server 2012
17 428 (16.35%) C#
18 406 (15.51%) SQL Server 2016
19 396 (15.13%) SQL Server 2008
20 394 (15.05%) Microsoft Analysis Services
21 375 (14.32%) Performance Tuning
22 374 (14.29%) Data Modelling
23 333 (12.72%) Tableau
24 329 (12.57%) Kimball Methodology
25 328 (12.53%) OLAP
26 307 (11.73%) MDX
27 294 (11.23%) Degree
28 291 (11.12%) Analytics
29 286 (10.92%) Analytical Skills
30 282 (10.77%) Visualisation

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 194 (7.41%) SharePoint
2 73 (2.79%) IIS
3 35 (1.34%) SAS
4 30 (1.15%) Apache
4 30 (1.15%) BizTalk Server
5 23 (0.88%) Apache Spark
6 16 (0.61%) JBoss
6 16 (0.61%) SharePoint 2010
7 15 (0.57%) SharePoint 2013
8 14 (0.53%) Anypoint
9 9 (0.34%) Drupal
10 8 (0.31%) Confluence
10 8 (0.31%) SharePoint Server
11 7 (0.27%) Oracle SOA Suite
11 7 (0.27%) WordPress
12 4 (0.15%) Apache Pig
12 4 (0.15%) Gentran
12 4 (0.15%) WebSphere
13 3 (0.11%) CMS
14 2 (0.076%) IBM Domino
Applications
1 176 (6.72%) Microsoft Excel
2 64 (2.44%) Microsoft Office
3 18 (0.69%) MS Visio
4 17 (0.65%) SPSS
5 7 (0.27%) Microsoft PowerPoint
6 6 (0.23%) Microsoft Project
6 6 (0.23%) Spreadsheet
7 5 (0.19%) Stata
8 1 (0.038%) InfoPath
Business Applications
1 77 (2.94%) Dynamics AX
2 45 (1.72%) Dynamics CRM
3 22 (0.84%) Cognos Business Intelligence
4 21 (0.80%) Dynamics NAV
5 9 (0.34%) Cognos TM1
6 7 (0.27%) Workday HCM
7 5 (0.19%) Cognos Planning
7 5 (0.19%) HFM
8 4 (0.15%) BusinessWorks
8 4 (0.15%) Markit EDM
8 4 (0.15%) NetSuite
8 4 (0.15%) Unit4 Business World
9 3 (0.11%) Oracle ERP
9 3 (0.11%) Sage 200
9 3 (0.11%) thinkFolio
10 2 (0.076%) Dynamics SL
10 2 (0.076%) Misys Opics
10 2 (0.076%) Raiser's Edge
10 2 (0.076%) Softmar
11 1 (0.038%) Postilion
Cloud Services
1 472 (18.03%) Microsoft Azure
2 115 (4.39%) Amazon AWS
3 65 (2.48%) Azure Data Factory
4 55 (2.10%) Dynamics 365
5 42 (1.60%) SaaS
6 40 (1.53%) Azure Machine Learning
7 28 (1.07%) Cortana Intelligence Suite
7 28 (1.07%) PaaS
8 26 (0.99%) IaaS
9 21 (0.80%) GitHub
10 17 (0.65%) Office 365
11 8 (0.31%) Firebase
11 8 (0.31%) Google Analytics
12 7 (0.27%) Amazon EMR
13 6 (0.23%) Cloud Computing
14 3 (0.11%) Amazon S3
14 3 (0.11%) Mimecast
15 2 (0.076%) Google Cloud Platform
16 1 (0.038%) Data Lake Analytics
Communications & Networking
1 62 (2.37%) Internet
2 21 (0.80%) Firewall
3 15 (0.57%) DNS
4 14 (0.53%) SMS
5 12 (0.46%) FTP
6 10 (0.38%) Intranet
7 6 (0.23%) Skype
8 5 (0.19%) TCP/IP
9 2 (0.076%) AMQP
9 2 (0.076%) Cisco ASA
9 2 (0.076%) Kerberos
9 2 (0.076%) SAN
10 1 (0.038%) Extranet
10 1 (0.038%) HTTP
10 1 (0.038%) LDAP
10 1 (0.038%) SSL
10 1 (0.038%) VPN
Database & Business Intelligence
1 2391 (91.33%) SQL Server Integration Services
2 2255 (86.13%) SQL Server Reporting Services
3 2173 (83.00%) SQL Server
4 1323 (50.53%) Data Warehouse
5 707 (27.01%) Power BI
6 434 (16.58%) SQL Server 2014
7 433 (16.54%) SQL Server 2012
8 406 (15.51%) SQL Server 2016
9 396 (15.13%) SQL Server 2008
10 394 (15.05%) Microsoft Analysis Services
11 328 (12.53%) OLAP
12 274 (10.47%) QlikView
13 204 (7.79%) Relational Database
14 197 (7.52%) Big Data
15 134 (5.12%) OLAP Cube
16 125 (4.77%) NoSQL
17 105 (4.01%) Azure SQL Database
18 102 (3.90%) BusinessObjects
19 94 (3.59%) MySQL
20 91 (3.48%) Hadoop
Development Applications
1 226 (8.63%) Visual Studio
2 189 (7.22%) Team Foundation Server
3 129 (4.93%) SQL Server Management Studio (SSMS)
4 66 (2.52%) JIRA
5 50 (1.91%) Octopus Deploy
6 42 (1.60%) TeamCity
7 40 (1.53%) Git (software)
8 36 (1.38%) Jenkins
9 30 (1.15%) Subversion
10 14 (0.53%) Talend Open Studio
11 11 (0.42%) RStudio
11 11 (0.42%) webpack
12 10 (0.38%) Jasmine
12 10 (0.38%) Selenium
13 9 (0.34%) SpecFlow
14 8 (0.31%) Karma Test Runner
14 8 (0.31%) PhantomJS
15 7 (0.27%) Maven
15 7 (0.27%) Visual Studio Team System
16 6 (0.23%) VSS/SourceSafe
General
1 667 (25.48%) Finance
2 203 (7.75%) Retail
3 195 (7.45%) Advertising
4 123 (4.70%) Banking
5 113 (4.32%) Marketing
6 76 (2.90%) Legal
7 41 (1.57%) Electronics
8 40 (1.53%) Manufacturing
9 38 (1.45%) Telecoms
10 34 (1.30%) Games
11 33 (1.26%) Investment Banking
12 32 (1.22%) Law
12 32 (1.22%) Publishing
13 26 (0.99%) Front Office
14 14 (0.53%) Retail Banking
15 13 (0.50%) Automotive
16 10 (0.38%) Back Office
17 9 (0.34%) Financial Institution
18 4 (0.15%) Billing
19 3 (0.11%) Private Banking
Job Titles
1 1523 (58.17%) Developer
2 882 (33.69%) Business Intelligence Developer
3 743 (28.38%) SQL Developer
4 397 (15.16%) DBA
5 372 (14.21%) SQL BI Developer
6 350 (13.37%) SQL DBA
7 301 (11.50%) SQL Server Developer
8 277 (10.58%) Analyst
9 254 (9.70%) SSIS Developer
10 228 (8.71%) Business Developer
11 208 (7.94%) SSRS Developer
12 169 (6.46%) SSAS Developer
13 163 (6.23%) Consultant
13 163 (6.23%) Data Warehouse Developer
14 157 (6.00%) Administrator
15 152 (5.81%) Senior Developer
16 150 (5.73%) SQL Server BI Developer
17 131 (5.00%) Architect
18 128 (4.89%) SQL Server DBA
19 126 (4.81%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 518 (19.79%) .NET
2 307 (11.73%) MDX
3 165 (6.30%) ASP.NET
4 134 (5.12%) HTML
5 88 (3.36%) CSS
6 82 (3.13%) Web Services
7 69 (2.64%) XML
8 57 (2.18%) HTML5
9 50 (1.91%) .NET Framework
9 50 (1.91%) REST
9 50 (1.91%) SOAP
10 47 (1.80%) AngularJS
11 44 (1.68%) Entity Framework
12 37 (1.41%) ASP.NET Web API
13 36 (1.38%) ASP.NET MVC
13 36 (1.38%) jQuery
13 36 (1.38%) JSON
13 36 (1.38%) WPF
14 27 (1.03%) WCF
15 26 (0.99%) Middleware
Miscellaneous
1 286 (10.92%) Analytical Skills
2 146 (5.58%) Replication
3 129 (4.93%) Clustering
4 93 (3.55%) Computer Science
5 89 (3.40%) Management Information System
6 65 (2.48%) Greenfield Project
7 49 (1.87%) Enterprise Software
8 47 (1.80%) Data Structures
8 47 (1.80%) Fintech
9 24 (0.92%) Client/Server
10 23 (0.88%) NHS
11 19 (0.73%) User Experience
12 17 (0.65%) Reinsurance
13 16 (0.61%) Blog
14 15 (0.57%) Credit Risk
14 15 (0.57%) Social Media
15 13 (0.50%) Algorithms
15 13 (0.50%) BBC
15 13 (0.50%) Mobile App
16 12 (0.46%) iPad
Operating Systems
1 212 (8.10%) Windows
2 126 (4.81%) Windows Server
3 69 (2.64%) Linux
4 26 (0.99%) Unix
5 17 (0.65%) Windows Server 2012
6 16 (0.61%) Android
6 16 (0.61%) Apple iOS
7 12 (0.46%) Windows Server 2008
8 11 (0.42%) Windows 7
9 10 (0.38%) VMS
10 9 (0.34%) Windows 10
11 5 (0.19%) Solaris
12 4 (0.15%) Ubuntu
13 2 (0.076%) Red Hat Enterprise Linux
13 2 (0.076%) Windows Server 2003
14 1 (0.038%) HPUX
Processes & Methodologies
1 1972 (75.32%) Business Intelligence
2 1020 (38.96%) ETL
3 534 (20.40%) Agile Software Development
4 375 (14.32%) Performance Tuning
5 374 (14.29%) Data Modelling
6 329 (12.57%) Kimball Methodology
7 291 (11.12%) Analytics
8 282 (10.77%) Visualisation
9 218 (8.33%) Migration
10 203 (7.75%) Data Visualisation
11 159 (6.07%) Scrum
12 153 (5.84%) Data Management
13 150 (5.73%) Disaster Recovery
14 149 (5.69%) Mentoring
15 141 (5.39%) High Availability
16 138 (5.27%) CRM
17 134 (5.12%) Dimensional Modelling
18 120 (4.58%) SDLC
19 119 (4.55%) Stakeholder Management
20 113 (4.32%) Data Analysis
Programming Languages
1 2234 (85.33%) SQL
2 1382 (52.79%) T-SQL
3 428 (16.35%) C#
4 196 (7.49%) PowerShell
5 105 (4.01%) JavaScript
6 104 (3.97%) Java
7 95 (3.63%) Data Analysis Expressions (DAX)
8 88 (3.36%) VB.NET
9 87 (3.32%) Python
10 81 (3.09%) VBA
11 77 (2.94%) R
12 61 (2.33%) VB
13 42 (1.60%) X++
14 33 (1.26%) C
15 32 (1.22%) PL/SQL
16 27 (1.03%) PHP
17 25 (0.95%) VBScript
18 19 (0.73%) Perl
19 18 (0.69%) C++
20 17 (0.65%) Ruby
Qualifications
1 294 (11.23%) Degree
2 124 (4.74%) Microsoft Certification
3 38 (1.45%) MCSE
4 36 (1.38%) Computer Science Degree
4 36 (1.38%) MCSA
5 27 (1.03%) Numerate Degree
6 25 (0.95%) MCITP
7 22 (0.84%) Security Cleared
8 19 (0.73%) MCTS
9 18 (0.69%) Master's Degree
10 12 (0.46%) MBA
10 12 (0.46%) SC Cleared
11 11 (0.42%) MCP
12 10 (0.38%) PhD
13 8 (0.31%) DV Cleared
14 6 (0.23%) MCSD
14 6 (0.23%) Oracle Certification
15 4 (0.15%) ITIL Certification
16 2 (0.076%) HND
16 2 (0.076%) MCDBA
Quality Assurance & Compliance
1 114 (4.35%) Data Quality
2 75 (2.86%) QA
3 25 (0.95%) PCI DSS
4 20 (0.76%) SLA
5 15 (0.57%) GDPR
6 9 (0.34%) ISO/IEC 27001
7 6 (0.23%) SEPA
8 3 (0.11%) Cyber Essentials
8 3 (0.11%) MiFID
8 3 (0.11%) PMO
9 2 (0.076%) COBIT
10 1 (0.038%) HL7
10 1 (0.038%) ISO 9001
System Software
1 45 (1.72%) Active Directory
2 18 (0.69%) VMware Infrastructure
3 17 (0.65%) HDFS
4 14 (0.53%) Docker
5 9 (0.34%) Virtual Machines
6 8 (0.31%) Oracle RAC
6 8 (0.31%) Virtual Servers
7 7 (0.27%) Microsoft App-V
8 4 (0.15%) Apache Flume
8 4 (0.15%) Microsoft Virtual Server
8 4 (0.15%) XenDesktop
9 2 (0.076%) Hyper-V
9 2 (0.076%) Veritas Cluster Server
10 1 (0.038%) XenApp
Systems Management
1 24 (0.92%) Puppet
2 23 (0.88%) Failover Clustering
3 19 (0.73%) Systems Management Server (SMS)
4 16 (0.61%) Perfmon
5 13 (0.50%) Ansible
6 9 (0.34%) Data Guard
6 9 (0.34%) Opscode Chef
7 8 (0.31%) Oracle RMAN
7 8 (0.31%) SCOM
8 7 (0.27%) Grafana
8 7 (0.27%) Microsoft Clustering
8 7 (0.27%) Nagios
9 5 (0.19%) Oozie
10 4 (0.15%) SCCM
11 3 (0.11%) Oracle Enterprise Manager
11 3 (0.11%) SQL Sentry
12 2 (0.076%) HP Data Protector
12 2 (0.076%) HP Quality Center
12 2 (0.076%) Packer
12 2 (0.076%) Terraform
Vendors
1 1407 (53.74%) Microsoft
2 333 (12.72%) Tableau
3 236 (9.01%) Oracle
4 155 (5.92%) Cognos
5 84 (3.21%) SAP
6 48 (1.83%) IBM
7 46 (1.76%) Sybase
8 43 (1.64%) VMware
9 38 (1.45%) Facebook
10 37 (1.41%) Google
11 32 (1.22%) RedGate
12 28 (1.07%) Informatica
13 26 (0.99%) MicroStrategy
14 20 (0.76%) MuleSoft
15 17 (0.65%) Alteryx
15 17 (0.65%) SolarWinds
16 16 (0.61%) Atlassian
16 16 (0.61%) Siebel
17 14 (0.53%) JD Edwards
17 14 (0.53%) TIBCO