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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
22 Feb 2018
Same period 2017 Same period 2016
Rank 228 215 175
Rank change year-on-year -13 -40 +8
Permanent jobs citing SQL Server Analysis Services 2,660 2,788 4,134
As % of all permanent IT jobs advertised in the UK 1.51% 1.59% 1.97%
As % of the Database & Business Intelligence category 4.94% 5.29% 6.21%
Number of salaries quoted 2,347 2,588 3,626
UK median annual salary £48,000 £50,000 £50,000
Median salary % change year-on-year -4.00% - +11.11%
10th Percentile £32,500 £33,000 £32,500
90th Percentile £67,500 £71,250 £72,500
UK excluding London median annual salary £43,750 £45,000 £45,000
% change year-on-year -2.78% - +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 53,866 52,722 66,612
As % of all permanent IT jobs advertised in the UK 30.59% 30.02% 31.74%
Number of salaries quoted 44,925 44,997 56,278
UK median annual salary £49,000 £47,500 £45,500
Median salary % change year-on-year +3.16% +4.40% +1.11%
10th Percentile £30,000 £29,750 £28,750
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £41,375
% change year-on-year - +2.72% +3.44%

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 22 February 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 22 February 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 -19 2,537 £48,500 -3.00% 313
UK excluding London +1 1,561 £43,750 -2.78% 220
London -28 1,037 £55,000 -4.35% 110
North of England -6 525 £42,500 - 65
South East -40 334 £45,000 -10.00% 35
Midlands +24 300 £44,000 +3.53% 58
Yorkshire +13 278 £45,000 - 20
North West -29 211 £40,000 -5.88% 42
West Midlands +38 202 £44,000 +9.32% 31
East of England +61 199 £50,000 - 25
South West +39 128 £40,000 -5.88% 19
East Midlands +16 98 £45,000 +5.88% 26
Scotland -3 54 £42,500 +13.33% 7
North East -2 36 £35,000 -12.50% 3
Wales +1 23 £47,500 +5.56% 10
Channel Islands - 5 £60,000 -
Northern Ireland -16 2 £33,750 -6.90% 1

For the 6 months to 22 February 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,454 (92.26%) SQL Server Integration Services
2 2,326 (87.44%) SQL Server Reporting Services
3 2,233 (83.95%) SQL
4 2,164 (81.35%) SQL Server
5 2,028 (76.24%) Business Intelligence
6 1,425 (53.57%) Microsoft
7 1,396 (52.48%) T-SQL
8 1,355 (50.94%) Data Warehouse
9 961 (36.13%) ETL
10 845 (31.77%) Power BI
11 633 (23.80%) Finance
12 507 (19.06%) Microsoft Azure
13 465 (17.48%) .NET
14 441 (16.58%) Agile Software Development
15 426 (16.02%) SQL Server 2016
16 410 (15.41%) C#
17 404 (15.19%) Tableau
18 398 (14.96%) Analytics
19 394 (14.81%) Data Modelling
20 392 (14.74%) Microsoft Analysis Services
21 377 (14.17%) SQL Server 2014
22 376 (14.14%) Performance Tuning
23 373 (14.02%) SQL Server 2012
24 313 (11.77%) Visualisation
25 310 (11.65%) Analytical Skills
26 305 (11.47%) Kimball Methodology
27 288 (10.83%) Advertising
28 277 (10.41%) OLAP
29 249 (9.36%) PowerShell
30 247 (9.29%) 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 156 (5.86%) SharePoint
2 35 (1.32%) IIS
3 24 (0.90%) SAS
4 21 (0.79%) Apache Spark
5 20 (0.75%) Apache
6 17 (0.64%) BizTalk Server
7 15 (0.56%) JBoss
8 10 (0.38%) Umbraco
9 9 (0.34%) Anypoint
9 9 (0.34%) SharePoint 2010
9 9 (0.34%) SharePoint 2013
9 9 (0.34%) SharePoint Server
10 7 (0.26%) Drupal
11 6 (0.23%) Oracle SOA Suite
12 4 (0.15%) Apache Pig
12 4 (0.15%) WordPress
13 2 (0.075%) Blackberry Enterprise Server
14 1 (0.038%) CMS
14 1 (0.038%) OpenEdge
14 1 (0.038%) WebSphere
Applications
1 194 (7.29%) Microsoft Excel
2 57 (2.14%) Microsoft Office
3 13 (0.49%) Spreadsheet
4 10 (0.38%) MS Visio
4 10 (0.38%) SPSS
5 8 (0.30%) Microsoft PowerPoint
6 6 (0.23%) InfoPath
6 6 (0.23%) Microsoft Project
7 3 (0.11%) Stata
Business Applications
1 70 (2.63%) Dynamics AX
2 34 (1.28%) Dynamics CRM
3 23 (0.86%) Elite 3E
4 14 (0.53%) NetSuite
5 10 (0.38%) MetaTrader
6 8 (0.30%) Cognos Business Intelligence
7 7 (0.26%) Cognos TM1
8 6 (0.23%) Cognos Planning
8 6 (0.23%) HFM
8 6 (0.23%) Postilion
8 6 (0.23%) Unit4 Business World
9 5 (0.19%) Dynamics SL
9 5 (0.19%) Sage 200
9 5 (0.19%) Workday HCM
10 4 (0.15%) Adobe Campaign
10 4 (0.15%) BusinessWorks
10 4 (0.15%) Dynamics NAV
10 4 (0.15%) Oracle ERP
11 2 (0.075%) Raiser's Edge
12 1 (0.038%) Carpe Diem
Cloud Services
1 507 (19.06%) Microsoft Azure
2 136 (5.11%) Azure Data Factory
3 102 (3.83%) Amazon AWS
4 42 (1.58%) SaaS
5 36 (1.35%) Dynamics 365
5 36 (1.35%) PaaS
6 33 (1.24%) Cortana Intelligence Suite
7 27 (1.02%) Azure Machine Learning
8 22 (0.83%) Office 365
9 15 (0.56%) GitHub
9 15 (0.56%) Google Analytics
10 13 (0.49%) IaaS
11 6 (0.23%) Data Lake Analytics
12 5 (0.19%) Amazon EMR
13 4 (0.15%) Cloud Computing
13 4 (0.15%) Google Cloud Platform
14 3 (0.11%) Azure Active Directory
14 3 (0.11%) Mimecast
14 3 (0.11%) OneDrive
15 2 (0.075%) Google Tag Manager
Communications & Networking
1 53 (1.99%) Internet
2 26 (0.98%) SMS
3 17 (0.64%) DNS
3 17 (0.64%) Firewall
4 7 (0.26%) FTP
5 6 (0.23%) SAN
6 4 (0.15%) Intranet
6 4 (0.15%) TCP/IP
7 2 (0.075%) Kerberos
7 2 (0.075%) Network Security
8 1 (0.038%) Cisco ASA
8 1 (0.038%) HTTP
8 1 (0.038%) SSL
8 1 (0.038%) Wireless
Database & Business Intelligence
1 2,454 (92.26%) SQL Server Integration Services
2 2,326 (87.44%) SQL Server Reporting Services
3 2,164 (81.35%) SQL Server
4 1,355 (50.94%) Data Warehouse
5 845 (31.77%) Power BI
6 426 (16.02%) SQL Server 2016
7 392 (14.74%) Microsoft Analysis Services
8 377 (14.17%) SQL Server 2014
9 373 (14.02%) SQL Server 2012
10 277 (10.41%) OLAP
11 244 (9.17%) SQL Server 2008
12 224 (8.42%) QlikView
13 169 (6.35%) Big Data
14 142 (5.34%) Data Lake
15 136 (5.11%) Relational Database
16 120 (4.51%) Azure SQL Database
17 98 (3.68%) NoSQL
18 94 (3.53%) Hadoop
19 92 (3.46%) Azure SQL Data Warehouse
20 84 (3.16%) OLTP
Development Applications
1 187 (7.03%) Visual Studio
2 171 (6.43%) Team Foundation Server
3 156 (5.86%) SQL Server Management Studio (SSMS)
4 70 (2.63%) JIRA
5 26 (0.98%) Git (software)
6 23 (0.86%) Octopus Deploy
7 20 (0.75%) TeamCity
8 19 (0.71%) Jenkins
8 19 (0.71%) Visual Studio Team System
9 18 (0.68%) Subversion
10 12 (0.45%) webpack
11 11 (0.41%) Eclipse
11 11 (0.41%) MorphX
12 10 (0.38%) Jasmine
12 10 (0.38%) Karma Test Runner
12 10 (0.38%) PhantomJS
13 7 (0.26%) RStudio
14 5 (0.19%) Bitbucket
14 5 (0.19%) ERwin
15 3 (0.11%) VSS/SourceSafe
General
1 633 (23.80%) Finance
2 288 (10.83%) Advertising
3 142 (5.34%) Retail
4 131 (4.92%) Marketing
5 79 (2.97%) Banking
6 52 (1.95%) Legal
7 32 (1.20%) Manufacturing
8 31 (1.17%) Law
9 23 (0.86%) Games
10 16 (0.60%) Electronics
11 15 (0.56%) Telecoms
12 14 (0.53%) Publishing
13 13 (0.49%) Billing
14 11 (0.41%) Front Office
15 10 (0.38%) Financial Institution
16 9 (0.34%) Investment Banking
17 6 (0.23%) Retail Banking
18 5 (0.19%) Back Office
19 3 (0.11%) Private Banking
20 2 (0.075%) French Language
Job Titles
1 1,534 (57.67%) Developer
2 930 (34.96%) Business Intelligence Developer
3 665 (25.00%) SQL Developer
4 411 (15.45%) DBA
5 366 (13.76%) SQL DBA
6 351 (13.20%) SQL BI Developer
7 283 (10.64%) Analyst
8 274 (10.30%) SQL Server Developer
9 248 (9.32%) SSIS Developer
10 226 (8.50%) Business Developer
11 208 (7.82%) SSRS Developer
12 182 (6.84%) Consultant
13 179 (6.73%) Data Warehouse Developer
14 175 (6.58%) SSAS Developer
15 155 (5.83%) SQL Server DBA
16 154 (5.79%) Administrator
17 152 (5.71%) SQL Server BI Developer
18 144 (5.41%) Senior Developer
19 140 (5.26%) Business Intelligence Consultant
20 113 (4.25%) ETL Developer
Libraries, Frameworks & Software Standards
1 465 (17.48%) .NET
2 247 (9.29%) MDX
3 148 (5.56%) ASP.NET
4 114 (4.29%) Web Services
5 113 (4.25%) HTML
6 72 (2.71%) CSS
7 71 (2.67%) HTML5
8 64 (2.41%) REST
9 54 (2.03%) XML
10 46 (1.73%) ASP.NET MVC
11 45 (1.69%) .NET Framework
12 43 (1.62%) JSON
13 41 (1.54%) Entity Framework
13 41 (1.54%) SOAP
13 41 (1.54%) WPF
14 32 (1.20%) jQuery
15 30 (1.13%) AngularJS
16 26 (0.98%) ASP.NET Web API
17 23 (0.86%) CSS3
17 23 (0.86%) LINQ
Miscellaneous
1 310 (11.65%) Analytical Skills
2 124 (4.66%) Replication
3 114 (4.29%) Clustering
4 84 (3.16%) Greenfield Project
5 80 (3.01%) Management Information System
6 71 (2.67%) Computer Science
7 67 (2.52%) Fintech
8 51 (1.92%) Data Structures
9 34 (1.28%) Enterprise Software
10 25 (0.94%) Driving Licence
11 18 (0.68%) Client/Server
12 16 (0.60%) User Experience
13 14 (0.53%) NHS
13 14 (0.53%) Reinsurance
14 13 (0.49%) Hedge funds
15 12 (0.45%) Hybrid Cloud
16 10 (0.38%) Data Centre
16 10 (0.38%) Virtual Team
17 9 (0.34%) Foreign Exchange (FX)
18 8 (0.30%) Equities
Operating Systems
1 159 (5.98%) Windows
2 82 (3.08%) Windows Server
3 54 (2.03%) Linux
4 23 (0.86%) Windows Server 2012
5 20 (0.75%) Windows Server 2008
6 18 (0.68%) VMS
7 16 (0.60%) Unix
8 9 (0.34%) Android
8 9 (0.34%) Apple iOS
9 6 (0.23%) Windows 10
9 6 (0.23%) Windows 7
10 4 (0.15%) Ubuntu
11 3 (0.11%) Red Hat Enterprise Linux
11 3 (0.11%) Solaris
12 2 (0.075%) Windows Server 2003
13 1 (0.038%) HPUX
13 1 (0.038%) Windows Mobile
Processes & Methodologies
1 2,028 (76.24%) Business Intelligence
2 961 (36.13%) ETL
3 441 (16.58%) Agile Software Development
4 398 (14.96%) Analytics
5 394 (14.81%) Data Modelling
6 376 (14.14%) Performance Tuning
7 313 (11.77%) Visualisation
8 305 (11.47%) Kimball Methodology
9 231 (8.68%) Migration
10 195 (7.33%) Data Visualisation
11 147 (5.53%) Data Analysis
12 135 (5.08%) CRM
13 130 (4.89%) SDLC
14 126 (4.74%) Dimensional Modelling
15 120 (4.51%) Data Management
16 117 (4.40%) Scrum
17 114 (4.29%) ERP
18 112 (4.21%) Stakeholder Management
19 109 (4.10%) Mentoring
20 105 (3.95%) Data Analytics
Programming Languages
1 2,233 (83.95%) SQL
2 1,396 (52.48%) T-SQL
3 410 (15.41%) C#
4 249 (9.36%) PowerShell
5 112 (4.21%) JavaScript
6 104 (3.91%) Data Analysis Expressions (DAX)
7 90 (3.38%) Python
8 79 (2.97%) VBA
9 74 (2.78%) VB.NET
10 68 (2.56%) R
11 62 (2.33%) Java
12 53 (1.99%) VB
13 39 (1.47%) X++
14 35 (1.32%) PL/SQL
15 20 (0.75%) C
16 16 (0.60%) C++
17 14 (0.53%) PHP
18 12 (0.45%) VB6
19 11 (0.41%) VBScript
20 10 (0.38%) Ruby
Qualifications
1 247 (9.29%) Degree
2 115 (4.32%) Microsoft Certification
3 31 (1.17%) Computer Science Degree
3 31 (1.17%) MCSA
4 28 (1.05%) MCSE
5 26 (0.98%) Security Cleared
6 20 (0.75%) MBA
7 16 (0.60%) MCP
8 13 (0.49%) SC Cleared
9 11 (0.41%) MCTS
10 10 (0.38%) MCITP
11 9 (0.34%) DV Cleared
11 9 (0.34%) MCSD
11 9 (0.34%) Numerate Degree
12 6 (0.23%) Oracle Certification
13 5 (0.19%) ITIL Certification
13 5 (0.19%) Master's Degree
14 4 (0.15%) ISEB
14 4 (0.15%) MCDBA
14 4 (0.15%) PhD
Quality Assurance & Compliance
1 106 (3.98%) Data Quality
2 84 (3.16%) QA
3 20 (0.75%) GDPR
4 13 (0.49%) PCI DSS
5 8 (0.30%) PMO
6 7 (0.26%) SLA
7 6 (0.23%) SEPA
8 5 (0.19%) ISO/IEC 27001
9 2 (0.075%) TickIT
10 1 (0.038%) MiFID
System Software
1 33 (1.24%) Active Directory
2 30 (1.13%) HDFS
3 10 (0.38%) Virtual Machines
4 8 (0.30%) VMware Infrastructure
5 6 (0.23%) Virtual Servers
6 5 (0.19%) Docker
6 5 (0.19%) Microsoft App-V
7 4 (0.15%) Apache Flume
7 4 (0.15%) XenDesktop
8 2 (0.075%) Oracle RAC
8 2 (0.075%) Veritas Cluster Server
9 1 (0.038%) Hyper-V
9 1 (0.038%) Microsoft Virtual Server
9 1 (0.038%) XenApp
Systems Management
1 24 (0.90%) Systems Management Server (SMS)
2 19 (0.71%) Failover Clustering
3 17 (0.64%) Opscode Chef
4 13 (0.49%) Puppet
5 10 (0.38%) Data Guard
6 8 (0.30%) Oracle RMAN
6 8 (0.30%) SCOM
7 7 (0.26%) Ansible
8 5 (0.19%) Oozie
8 5 (0.19%) SCCM
9 4 (0.15%) Galera Cluster
9 4 (0.15%) Nagios
10 3 (0.11%) Ambari
10 3 (0.11%) HP Data Protector
10 3 (0.11%) Microsoft Clustering
11 2 (0.075%) CloudHub
11 2 (0.075%) Oracle Enterprise Manager
11 2 (0.075%) Packer
11 2 (0.075%) Terraform
12 1 (0.038%) Control-M
Vendors
1 1,425 (53.57%) Microsoft
2 404 (15.19%) Tableau
3 171 (6.43%) Oracle
4 134 (5.04%) Cognos
5 71 (2.67%) SAP
6 42 (1.58%) Google
7 36 (1.35%) RedGate
8 34 (1.28%) IBM
9 30 (1.13%) Facebook
10 27 (1.02%) VMware
11 22 (0.83%) Alteryx
12 21 (0.79%) Aderant
13 20 (0.75%) Informatica
13 20 (0.75%) SolarWinds
14 19 (0.71%) Talend
15 17 (0.64%) Twitter
16 14 (0.53%) Infragistics
16 14 (0.53%) JD Edwards
16 14 (0.53%) MicroStrategy
17 13 (0.49%) TIBCO