Period
to 17 January 2019

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 17 January 2019 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
17 Jan 2019
Same period 2018 Same period 2017
Rank 250 242 230
Rank change year-on-year -8 -12 -51
Permanent jobs citing SQL Server Analysis Services 2,098 2,505 2,642
As % of all permanent IT jobs advertised in the UK 1.39% 1.45% 1.49%
As % of the Database & Business Intelligence category 4.84% 4.74% 4.98%
Number of salaries quoted 1,842 2,186 2,435
UK median annual salary £50,000 £47,500 £50,000
Median salary % change year-on-year +5.26% -5.00% -
10th Percentile £33,500 £32,500 £33,500
90th Percentile £73,750 £68,750 £71,250
UK excluding London median annual salary £42,500 £42,500 £45,000
% change year-on-year - -5.56% -

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 43,307 52,840 53,100
As % of all permanent IT jobs advertised in the UK 28.65% 30.51% 29.86%
Number of salaries quoted 35,590 43,763 45,440
UK median annual salary £52,500 £48,000 £47,500
Median salary % change year-on-year +9.38% +1.05% +5.56%
10th Percentile £31,250 £30,000 £29,250
90th Percentile £85,000 £77,500 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +4.94%

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 17 January 2019.

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 17 January 2019. 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 +2 2,000 £50,000 +5.26% 307
London +41 1,044 £58,500 +6.36% 107
UK excluding London -46 1,032 £42,500 - 220
North of England -67 298 £42,000 -1.18% 81
South East +13 244 £47,500 +5.56% 43
Midlands +10 223 £42,500 -1.16% 39
North West -31 144 £42,000 +5.00% 36
East of England +1 137 £45,000 -5.26% 23
Yorkshire -63 131 £45,000 - 42
East Midlands +48 120 £42,500 -1.73% 18
West Midlands -25 102 £42,500 - 21
Scotland +13 55 £42,000 +5.00% 14
South West -70 54 £40,000 -5.33% 14
Wales +19 23 £35,000 -30.00% 3
North East +5 23 £37,500 +7.14% 3
Northern Ireland -6 3 £35,000 - 3

For the 6 months to 17 January 2019, 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 1,894 (90.28%) SQL Server Integration Services
2 1,785 (85.08%) SQL Server Reporting Services
3 1,689 (80.51%) SQL
4 1,624 (77.41%) Business Intelligence
5 1,607 (76.60%) SQL Server
6 1,106 (52.72%) Microsoft
7 1,099 (52.38%) Data Warehouse
8 1,031 (49.14%) T-SQL
9 874 (41.66%) Power BI
10 783 (37.32%) ETL
11 573 (27.31%) Microsoft Azure
12 509 (24.26%) Finance
13 437 (20.83%) C#
14 435 (20.73%) Agile Software Development
15 407 (19.40%) .NET
16 390 (18.59%) Analytics
17 377 (17.97%) Visualisation
18 362 (17.25%) Tableau
19 323 (15.40%) Data Modelling
20 317 (15.11%) Microsoft Analysis Services
21 311 (14.82%) Microsoft Excel
22 287 (13.68%) Analytical Skills
23 242 (11.53%) SQL Server 2012
24 234 (11.15%) SQL Server 2008
25 227 (10.82%) SQL Server 2016
26 214 (10.20%) MDX
27 208 (9.91%) Data Analysis Expressions (DAX)
28 196 (9.34%) OLAP
29 194 (9.25%) Dimensional Modelling
30 185 (8.82%) Azure SQL 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 164 (7.82%) SharePoint
2 69 (3.29%) SAS
3 39 (1.86%) IIS
4 27 (1.29%) Confluence
5 20 (0.95%) Apache Spark
5 20 (0.95%) SharePoint 2013
6 18 (0.86%) CMS
7 15 (0.71%) DNN
8 11 (0.52%) Anypoint
8 11 (0.52%) Mule
8 11 (0.52%) Mule ESB
9 10 (0.48%) Apache
9 10 (0.48%) Sitecore CMS
10 9 (0.43%) Elasticsearch
11 8 (0.38%) SharePoint 2010
12 6 (0.29%) Apache Pig
13 5 (0.24%) SharePoint Server
14 4 (0.19%) Plone
14 4 (0.19%) WebSphere
14 4 (0.19%) Zope
Applications
1 311 (14.82%) Microsoft Excel
2 54 (2.57%) Microsoft Office
3 40 (1.91%) MS Visio
4 9 (0.43%) Microsoft Project
5 7 (0.33%) SPSS
6 5 (0.24%) Microsoft PowerPoint
7 4 (0.19%) InfoPath
8 2 (0.095%) Spreadsheet
9 1 (0.048%) Stata
Business Applications
1 33 (1.57%) Dynamics AX
2 20 (0.95%) Cognos TM1
3 18 (0.86%) Dynamics CRM
4 11 (0.52%) FastStats
5 10 (0.48%) Dynamics NAV
6 9 (0.43%) NetSuite
7 8 (0.38%) Cognos Business Intelligence
8 7 (0.33%) Visualfiles
9 5 (0.24%) Elite 3E
9 5 (0.24%) Markit EDM
9 5 (0.24%) SAP MDG
10 3 (0.14%) Carpe Diem
10 3 (0.14%) Cognos Planning
10 3 (0.14%) HFM
10 3 (0.14%) Maximo
11 2 (0.095%) SAP Business One
Cloud Services
1 573 (27.31%) Microsoft Azure
2 146 (6.96%) Azure Data Factory
3 133 (6.34%) Amazon AWS
4 74 (3.53%) PaaS
5 55 (2.62%) Data Lake Analytics
6 48 (2.29%) Office 365
7 42 (2.00%) SaaS
8 24 (1.14%) Azure Machine Learning
9 23 (1.10%) Dynamics 365
10 18 (0.86%) Azure Active Directory
10 18 (0.86%) IaaS
11 15 (0.71%) Cloud Computing
12 11 (0.52%) Google Cloud Platform
13 9 (0.43%) GitHub
14 6 (0.29%) Amazon EC2
15 5 (0.24%) Amazon EMR
15 5 (0.24%) Boomi
16 4 (0.19%) Google Analytics
17 3 (0.14%) Cortana Intelligence Suite
18 2 (0.095%) iPaaS
Communications & Networking
1 24 (1.14%) Internet
2 16 (0.76%) SAN
3 8 (0.38%) Intranet
4 7 (0.33%) HTTP
5 6 (0.29%) NAS
6 5 (0.24%) LAN
6 5 (0.24%) WAN
7 4 (0.19%) Firewall
7 4 (0.19%) IP Telephony
7 4 (0.19%) PBX
7 4 (0.19%) TCP/IP
7 4 (0.19%) VoIP
8 3 (0.14%) DNS
8 3 (0.14%) Wireshark
9 2 (0.095%) Fibre Channel
9 2 (0.095%) FTP
9 2 (0.095%) iSCSI
9 2 (0.095%) SMS
10 1 (0.048%) DHCP
10 1 (0.048%) SMTP
Database & Business Intelligence
1 1,894 (90.28%) SQL Server Integration Services
2 1,785 (85.08%) SQL Server Reporting Services
3 1,607 (76.60%) SQL Server
4 1,099 (52.38%) Data Warehouse
5 874 (41.66%) Power BI
6 317 (15.11%) Microsoft Analysis Services
7 242 (11.53%) SQL Server 2012
8 234 (11.15%) SQL Server 2008
9 227 (10.82%) SQL Server 2016
10 196 (9.34%) OLAP
11 185 (8.82%) Azure SQL Database
12 179 (8.53%) Relational Database
13 158 (7.53%) Data Lake
14 143 (6.82%) QlikView
15 137 (6.53%) Big Data
16 125 (5.96%) SQL Server 2014
17 115 (5.48%) Azure SQL Data Warehouse
18 88 (4.19%) OLAP Cube
19 80 (3.81%) NoSQL
20 79 (3.77%) RDBMS
Development Applications
1 163 (7.77%) Team Foundation Server
2 155 (7.39%) Visual Studio
3 69 (3.29%) Git (software)
4 61 (2.91%) SQL Server Management Studio (SSMS)
5 45 (2.14%) JIRA
6 33 (1.57%) Subversion
7 31 (1.48%) Eclipse
7 31 (1.48%) ER Studio
7 31 (1.48%) ERwin
7 31 (1.48%) Visual Studio Team System
8 27 (1.29%) Jenkins
9 16 (0.76%) Maven
10 14 (0.67%) Chocolatey
11 11 (0.52%) IntelliJ
11 11 (0.52%) JUnit
11 11 (0.52%) Mockito
11 11 (0.52%) Sonatype Nexus
12 10 (0.48%) Karma Test Runner
12 10 (0.48%) PhantomJS
12 10 (0.48%) webpack
General
1 509 (24.26%) Finance
2 140 (6.67%) Retail
3 96 (4.58%) Advertising
4 94 (4.48%) Marketing
5 90 (4.29%) Banking
6 33 (1.57%) Law
7 26 (1.24%) Legal
8 22 (1.05%) Investment Banking
8 22 (1.05%) Manufacturing
9 17 (0.81%) Telecoms
10 13 (0.62%) Financial Institution
11 9 (0.43%) Back Office
12 8 (0.38%) Billing
12 8 (0.38%) Pharmaceutical
13 5 (0.24%) Games
13 5 (0.24%) Publishing
14 4 (0.19%) Automotive
14 4 (0.19%) General Ledger
15 2 (0.095%) German Language
15 2 (0.095%) Local Government
Job Titles
1 1,246 (59.39%) Developer
2 743 (35.41%) Business Intelligence Developer
3 504 (24.02%) SQL Developer
4 270 (12.87%) Analyst
5 252 (12.01%) SQL BI Developer
6 228 (10.87%) DBA
7 222 (10.58%) Senior Developer
8 221 (10.53%) SSIS Developer
9 200 (9.53%) SSRS Developer
10 199 (9.49%) SQL DBA
11 142 (6.77%) Consultant
12 141 (6.72%) SQL Server Developer
13 140 (6.67%) Senior Business Intelligence Developer
13 140 (6.67%) SSAS Developer
14 128 (6.10%) Business Intelligence Analyst
15 122 (5.82%) Business Developer
16 114 (5.43%) Data Warehouse Developer
17 106 (5.05%) C# Developer
18 89 (4.24%) Business Intelligence Consultant
19 88 (4.19%) Architect
Libraries, Frameworks & Software Standards
1 407 (19.40%) .NET
2 214 (10.20%) MDX
3 125 (5.96%) ASP.NET
4 111 (5.29%) HTML
5 87 (4.15%) Web Services
6 82 (3.91%) XML
7 80 (3.81%) CSS
8 79 (3.77%) .NET Framework
9 60 (2.86%) Entity Framework
10 59 (2.81%) AngularJS
10 59 (2.81%) JSON
11 52 (2.48%) jQuery
12 51 (2.43%) HTML5
13 37 (1.76%) REST
14 36 (1.72%) ASP.NET MVC
14 36 (1.72%) SOAP
15 28 (1.33%) ASP.NET Web API
16 27 (1.29%) RESTful
17 26 (1.24%) ASP.NET Web Forms
17 26 (1.24%) LINQ
Miscellaneous
1 287 (13.68%) Analytical Skills
2 90 (4.29%) Clustering
3 88 (4.19%) Greenfield Project
3 88 (4.19%) Replication
4 60 (2.86%) Data Structures
4 60 (2.86%) Management Information System
5 26 (1.24%) Data Centre
5 26 (1.24%) Reinsurance
6 24 (1.14%) Fintech
7 19 (0.91%) Self-Motivation
7 19 (0.91%) User Experience
8 17 (0.81%) NHS
9 16 (0.76%) Client/Server
9 16 (0.76%) Linux Command Line
9 16 (0.76%) Public Cloud
10 13 (0.62%) Driving Licence
11 11 (0.52%) Mobile App
12 10 (0.48%) Enterprise Software
12 10 (0.48%) Hedge funds
13 6 (0.29%) PMI
Operating Systems
1 129 (6.15%) Windows
2 62 (2.96%) Windows Server
3 38 (1.81%) Linux
4 29 (1.38%) Windows Server 2008
5 23 (1.10%) Windows Server 2012
6 16 (0.76%) Windows 10
6 16 (0.76%) Windows 7
6 16 (0.76%) Windows 8
7 7 (0.33%) Apple iOS
8 6 (0.29%) Windows 2000
9 5 (0.24%) Unix
10 3 (0.14%) CentOS
10 3 (0.14%) Red Hat Enterprise Linux
10 3 (0.14%) Solaris
10 3 (0.14%) Ubuntu
11 1 (0.048%) Android
11 1 (0.048%) VMS
Processes & Methodologies
1 1,624 (77.41%) Business Intelligence
2 783 (37.32%) ETL
3 435 (20.73%) Agile Software Development
4 390 (18.59%) Analytics
5 377 (17.97%) Visualisation
6 323 (15.40%) Data Modelling
7 194 (9.25%) Dimensional Modelling
8 181 (8.63%) Problem-Solving
9 175 (8.34%) Data Management
10 170 (8.10%) Kimball Methodology
11 161 (7.67%) Performance Tuning
12 154 (7.34%) Data Analysis
13 151 (7.20%) Data Visualisation
14 128 (6.10%) Migration
15 123 (5.86%) Scrum
16 115 (5.48%) SDLC
17 93 (4.43%) High Availability
18 88 (4.19%) Data Science
19 84 (4.00%) Data Integration
20 82 (3.91%) Business Analysis
Programming Languages
1 1,689 (80.51%) SQL
2 1,031 (49.14%) T-SQL
3 437 (20.83%) C#
4 208 (9.91%) Data Analysis Expressions (DAX)
5 165 (7.86%) PowerShell
6 125 (5.96%) JavaScript
7 118 (5.62%) Python
8 113 (5.39%) VBA
9 99 (4.72%) R
10 97 (4.62%) VB.NET
11 76 (3.62%) VB
12 51 (2.43%) PL/SQL
13 50 (2.38%) Java
14 36 (1.72%) PHP
15 32 (1.53%) U-SQL
16 24 (1.14%) C++
17 22 (1.05%) VB6
18 12 (0.57%) Shell Script
19 11 (0.52%) Java 8
20 10 (0.48%) Tcl
Qualifications
1 171 (8.15%) Degree
2 81 (3.86%) Microsoft Certification
3 34 (1.62%) Computer Science Degree
4 29 (1.38%) Security Cleared
5 19 (0.91%) MCSE
6 17 (0.81%) SC Cleared
7 14 (0.67%) MCSA
8 12 (0.57%) MCT
9 10 (0.48%) MCITP
10 7 (0.33%) ITIL Foundation Certificate
10 7 (0.33%) Master's Degree
10 7 (0.33%) MCP
11 6 (0.29%) MCDBA
12 5 (0.24%) ISEB
13 3 (0.14%) CBAP
13 3 (0.14%) CCNA
13 3 (0.14%) Cisco Certification
13 3 (0.14%) DBS Check
13 3 (0.14%) Numerate Degree
14 2 (0.095%) MBCS
Quality Assurance & Compliance
1 125 (5.96%) Data Quality
2 80 (3.81%) QA
3 61 (2.91%) GDPR
4 36 (1.72%) SLA
5 24 (1.14%) ISO/IEC 27001
6 17 (0.81%) Solvency II
7 7 (0.33%) PCI DSS
8 6 (0.29%) PMO
9 4 (0.19%) PMBOK
10 3 (0.14%) HL7
10 3 (0.14%) IFRS
11 2 (0.095%) IFRS 9
12 1 (0.048%) Cyber Essentials
12 1 (0.048%) Sarbanes-Oxley
System Software
1 36 (1.72%) VMware Infrastructure
2 25 (1.19%) Active Directory
3 18 (0.86%) Hyper-V
4 17 (0.81%) Virtual Machines
5 16 (0.76%) LXC
6 7 (0.33%) Docker
7 6 (0.29%) HDFS
8 5 (0.24%) Apache Flume
9 2 (0.095%) vSphere
9 2 (0.095%) XenApp
10 1 (0.048%) Terminal Services
10 1 (0.048%) VMware ESXi
Systems Management
1 13 (0.62%) Failover Clustering
2 11 (0.52%) CloudHub
2 11 (0.52%) Microsoft Clustering
2 11 (0.52%) Systems Management Server (SMS)
3 9 (0.43%) Kubernetes
3 9 (0.43%) Perfmon
3 9 (0.43%) Puppet
4 8 (0.38%) Ansible
5 7 (0.33%) Opscode Chef
6 4 (0.19%) Kibana
6 4 (0.19%) Oozie
6 4 (0.19%) Rundeck
7 3 (0.14%) Control-M
7 3 (0.14%) Oracle RMAN
8 2 (0.095%) Ambari
8 2 (0.095%) Grafana
8 2 (0.095%) SCOM
8 2 (0.095%) SCOrch
8 2 (0.095%) Symantec Enterprise Vault
8 2 (0.095%) Terraform
Vendors
1 1,106 (52.72%) Microsoft
2 362 (17.25%) Tableau
3 158 (7.53%) Oracle
4 72 (3.43%) Cognos
5 51 (2.43%) SAP
6 37 (1.76%) VMware
7 29 (1.38%) Salesforce.com
8 25 (1.19%) Databricks
9 23 (1.10%) Informatica
10 22 (1.05%) MicroStrategy
10 22 (1.05%) MuleSoft
11 20 (0.95%) IBM
12 19 (0.91%) Google
12 19 (0.91%) Infragistics
12 19 (0.91%) Teradata
13 13 (0.62%) SolarWinds
14 12 (0.57%) Alteryx
14 12 (0.57%) RedGate
14 12 (0.57%) Talend
15 10 (0.48%) Sitecore