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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
24 May 2019
Same period 2018 Same period 2017
Rank 239 204 204
Rank change year-on-year -35 0 -3
Permanent jobs citing SQL Server Analysis Services 2,096 2,894 2,867
As % of all permanent IT jobs advertised in the UK 1.44% 1.68% 1.69%
As % of the Database & Business Intelligence category 5.14% 5.47% 5.48%
Number of salaries quoted 1,844 2,570 2,617
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £35,699 £32,500 £33,000
90th Percentile £80,000 £70,025 £71,250
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -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 40,801 52,909 52,353
As % of all permanent IT jobs advertised in the UK 28.09% 30.68% 30.92%
Number of salaries quoted 33,282 43,485 44,452
UK median annual salary £52,095 £50,000 £47,500
Median salary % change year-on-year +4.19% +5.26% -
10th Percentile £31,250 £31,250 £29,750
90th Percentile £85,000 £80,000 £77,500
UK excluding London median annual salary £45,000 £44,471 £42,000
% change year-on-year +1.19% +5.88% +1.20%

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 24 May 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 24 May 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 -36 1,995 £52,500 +5.00% 138
London +39 1,135 £60,000 +9.09% 49
UK excluding London -83 943 £45,000 - 94
North of England -36 328 £45,000 +2.27% 41
South East -96 192 £50,000 +11.11% 19
North West -8 158 £42,500 -5.56% 24
Midlands -86 153 £45,000 - 20
Yorkshire -57 151 £47,500 +5.56% 17
East of England -3 111 £47,500 -5.00% 5
East Midlands +8 87 £43,500 -3.33% 11
South West -16 70 £43,750 +9.38% 4
Scotland +4 68 £45,500 +5.81% 3
West Midlands -108 64 £48,750 +12.72% 9
Wales +6 20 £35,000 -17.65% 2
North East -11 19 £39,500 +5.33%
Northern Ireland -27 1 - -

For the 6 months to 24 May 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,866 (89.03%) SQL Server Integration Services
2 1,767 (84.30%) SQL Server Reporting Services
3 1,631 (77.81%) Business Intelligence
4 1,609 (76.77%) SQL Server
5 1,601 (76.38%) SQL
6 1,187 (56.63%) Data Warehouse
7 992 (47.33%) Power BI
7 992 (47.33%) Power Platform
8 983 (46.90%) Microsoft
9 893 (42.60%) T-SQL
10 800 (38.17%) ETL
11 735 (35.07%) Microsoft Azure
12 546 (26.05%) Agile Software Development
13 517 (24.67%) Finance
14 493 (23.52%) Analytics
15 422 (20.13%) C#
16 378 (18.03%) Data Modelling
17 359 (17.13%) Visualisation
18 328 (15.65%) .NET
19 315 (15.03%) Tableau
20 307 (14.65%) SQL Server 2012
20 307 (14.65%) Microsoft Analysis Services
21 304 (14.50%) Data Analysis Expressions (DAX)
22 299 (14.27%) Kimball Methodology
23 267 (12.74%) Analytical Skills
24 258 (12.31%) MDX
25 226 (10.78%) Azure SQL Database
26 219 (10.45%) SQL Server 2016
27 205 (9.78%) Microsoft Excel
28 201 (9.59%) 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 121 (5.77%) SharePoint
2 57 (2.72%) SAS
3 32 (1.53%) IIS
4 25 (1.19%) Apache Spark
5 18 (0.86%) Confluence
5 18 (0.86%) SharePoint 2013
6 10 (0.48%) Apache Pig
7 7 (0.33%) CMS
8 6 (0.29%) Apache
9 5 (0.24%) DNN
10 4 (0.19%) Anypoint
10 4 (0.19%) Mule
10 4 (0.19%) Mule ESB
10 4 (0.19%) SharePoint 2010
10 4 (0.19%) SharePoint Server
11 3 (0.14%) Elasticsearch
12 2 (0.095%) Apache Solr
12 2 (0.095%) Jetty
12 2 (0.095%) Jupyter
12 2 (0.095%) Oracle Workflow
Applications
1 205 (9.78%) Microsoft Excel
2 48 (2.29%) Microsoft Office
3 10 (0.48%) Microsoft PowerPoint
3 10 (0.48%) MS Visio
4 3 (0.14%) Microsoft Project
5 2 (0.095%) Spreadsheet
5 2 (0.095%) SPSS
Business Applications
1 12 (0.57%) Dynamics AX
2 10 (0.48%) NetSuite
3 8 (0.38%) Cognos Business Intelligence
3 8 (0.38%) Dynamics CRM
4 5 (0.24%) SAP FI-GL
4 5 (0.24%) SAP S/4HANA
5 4 (0.19%) Markit EDM
6 3 (0.14%) Dynamics NAV
6 3 (0.14%) Payment Gateway
7 2 (0.095%) Oracle Assets
7 2 (0.095%) Oracle Financials
7 2 (0.095%) Oracle General Ledger
7 2 (0.095%) Oracle Payables
7 2 (0.095%) Oracle Procure-to-Pay
7 2 (0.095%) Oracle Receivables
7 2 (0.095%) Sage 50
7 2 (0.095%) SAP MDG
8 1 (0.048%) Oracle EBS R12
8 1 (0.048%) Oracle Internet Expenses
8 1 (0.048%) Oracle iProcurement
Cloud Services
1 992 (47.33%) Power Platform
2 735 (35.07%) Microsoft Azure
3 177 (8.44%) Azure Data Factory
4 143 (6.82%) Amazon AWS
5 42 (2.00%) PaaS
6 38 (1.81%) Data Lake Analytics
7 30 (1.43%) Azure Machine Learning
7 30 (1.43%) SaaS
8 27 (1.29%) Azure Stack
9 23 (1.10%) Google Cloud Platform
10 22 (1.05%) PowerApps
11 21 (1.00%) Office 365
12 18 (0.86%) Azure Active Directory
13 14 (0.67%) Cloud Computing
14 12 (0.57%) Dynamics 365
15 7 (0.33%) GitHub
15 7 (0.33%) Serverless
16 6 (0.29%) Azure Functions
16 6 (0.29%) IaaS
17 4 (0.19%) AWS Data Pipeline
Communications & Networking
1 22 (1.05%) Internet
2 18 (0.86%) Broadband
3 5 (0.24%) SAN
4 2 (0.095%) Firewall
4 2 (0.095%) FTP
4 2 (0.095%) Intranet
4 2 (0.095%) NAS
4 2 (0.095%) WAN
5 1 (0.048%) CTI
Database & Business Intelligence
1 1,866 (89.03%) SQL Server Integration Services
2 1,767 (84.30%) SQL Server Reporting Services
3 1,609 (76.77%) SQL Server
4 1,187 (56.63%) Data Warehouse
5 992 (47.33%) Power BI
6 307 (14.65%) Microsoft Analysis Services
6 307 (14.65%) SQL Server 2012
7 226 (10.78%) Azure SQL Database
8 219 (10.45%) SQL Server 2016
9 201 (9.59%) Relational Database
10 196 (9.35%) OLAP
11 193 (9.21%) SQL Server 2008
12 191 (9.11%) Data Lake
13 156 (7.44%) QlikView
14 115 (5.49%) Big Data
15 111 (5.30%) MongoDB
15 111 (5.30%) SQL Server 2014
16 80 (3.82%) Azure SQL Data Warehouse
17 76 (3.63%) Hadoop
18 67 (3.20%) PostgreSQL
Development Applications
1 122 (5.82%) Visual Studio
2 100 (4.77%) Team Foundation Server
3 70 (3.34%) Git (software)
4 64 (3.05%) JIRA
5 55 (2.62%) SQL Server Management Studio (SSMS)
6 36 (1.72%) Jenkins
7 23 (1.10%) Subversion
8 22 (1.05%) Maven
8 22 (1.05%) Visual Studio Team System
9 15 (0.72%) Eclipse
10 12 (0.57%) ERwin
11 11 (0.52%) ER Studio
12 8 (0.38%) Bitbucket
12 8 (0.38%) FishEye
13 7 (0.33%) Chocolatey
13 7 (0.33%) Oracle Forms
14 6 (0.29%) Octopus Deploy
14 6 (0.29%) TeamCity
15 5 (0.24%) VSS/SourceSafe
16 4 (0.19%) JUnit
General
1 517 (24.67%) Finance
2 118 (5.63%) Retail
3 78 (3.72%) Marketing
4 50 (2.39%) Banking
5 39 (1.86%) Legal
6 34 (1.62%) Advertising
7 23 (1.10%) Telecoms
8 18 (0.86%) Financial Institution
8 18 (0.86%) Manufacturing
9 15 (0.72%) Back Office
10 13 (0.62%) Law
11 12 (0.57%) Games
11 12 (0.57%) Investment Banking
12 10 (0.48%) Automotive
13 7 (0.33%) Billing
13 7 (0.33%) Publishing
14 5 (0.24%) Electronics
14 5 (0.24%) Pharmaceutical
15 4 (0.19%) General Ledger
16 3 (0.14%) Local Government
Job Titles
1 1,254 (59.83%) Developer
2 806 (38.45%) Business Intelligence Developer
3 460 (21.95%) SQL Developer
4 258 (12.31%) SQL BI Developer
5 223 (10.64%) Analyst
5 223 (10.64%) DBA
6 206 (9.83%) Senior Developer
7 190 (9.06%) SQL DBA
8 176 (8.40%) SSRS Developer
9 158 (7.54%) SSIS Developer
10 140 (6.68%) Senior Business Intelligence Developer
11 137 (6.54%) SQL Server Developer
12 134 (6.39%) Data Warehouse Developer
13 122 (5.82%) Business Developer
14 120 (5.73%) Business Intelligence Analyst
15 104 (4.96%) Business Intelligence Lead
16 95 (4.53%) SSAS Developer
17 94 (4.48%) Lead Developer
18 92 (4.39%) Consultant
19 89 (4.25%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 328 (15.65%) .NET
2 258 (12.31%) MDX
3 105 (5.01%) ASP.NET
4 83 (3.96%) HTML
5 67 (3.20%) Web Services
6 61 (2.91%) CSS
7 54 (2.58%) XML
8 48 (2.29%) .NET Framework
9 38 (1.81%) HTML5
10 34 (1.62%) AngularJS
11 29 (1.38%) Entity Framework
12 28 (1.34%) ASP.NET Web API
12 28 (1.34%) JSON
12 28 (1.34%) REST
13 27 (1.29%) jQuery
14 25 (1.19%) WPF
15 24 (1.15%) SOAP
16 20 (0.95%) RabbitMQ
16 20 (0.95%) React
17 16 (0.76%) ASP.NET Web Forms
Miscellaneous
1 267 (12.74%) Analytical Skills
2 101 (4.82%) Clustering
3 100 (4.77%) Greenfield Project
4 85 (4.06%) Replication
5 46 (2.19%) Data Centre
5 46 (2.19%) Self-Motivation
6 44 (2.10%) Management Information System
7 41 (1.96%) Fintech
8 34 (1.62%) Credit Risk
9 33 (1.57%) Reinsurance
10 32 (1.53%) Data Structures
11 26 (1.24%) Hedge funds
12 19 (0.91%) Enterprise Software
13 16 (0.76%) Linux Command Line
14 15 (0.72%) Analytical Mindset
14 15 (0.72%) Client/Server
14 15 (0.72%) Market Risk
15 13 (0.62%) iSeries
16 12 (0.57%) User Experience
17 10 (0.48%) Algorithms
Operating Systems
1 107 (5.10%) Windows
2 58 (2.77%) Windows Server
3 50 (2.39%) Linux
4 28 (1.34%) Windows Server 2008
5 17 (0.81%) Windows 7
6 16 (0.76%) Windows 10
6 16 (0.76%) Windows 8
7 14 (0.67%) Windows Server 2012
8 13 (0.62%) Red Hat Enterprise Linux
9 8 (0.38%) CentOS
9 8 (0.38%) Ubuntu
9 8 (0.38%) Windows Server 2003
10 4 (0.19%) Unix
11 3 (0.14%) Solaris
12 2 (0.095%) Android
12 2 (0.095%) Apple iOS
12 2 (0.095%) Windows 2000
Processes & Methodologies
1 1,631 (77.81%) Business Intelligence
2 800 (38.17%) ETL
3 546 (26.05%) Agile Software Development
4 493 (23.52%) Analytics
5 378 (18.03%) Data Modelling
6 359 (17.13%) Visualisation
7 299 (14.27%) Kimball Methodology
8 190 (9.06%) Problem-Solving
9 181 (8.64%) Scrum
10 165 (7.87%) Data Analytics
11 142 (6.77%) SDLC
12 140 (6.68%) Migration
13 136 (6.49%) Performance Tuning
14 132 (6.30%) Data Management
14 132 (6.30%) Dimensional Modelling
15 129 (6.15%) Data Visualisation
16 128 (6.11%) DevOps
17 103 (4.91%) Data Architecture
18 98 (4.68%) High Availability
19 91 (4.34%) Data Analysis
Programming Languages
1 1,601 (76.38%) SQL
2 893 (42.60%) T-SQL
3 422 (20.13%) C#
4 304 (14.50%) Data Analysis Expressions (DAX)
5 196 (9.35%) Python
6 139 (6.63%) PowerShell
7 118 (5.63%) R
8 108 (5.15%) JavaScript
9 95 (4.53%) VBA
10 65 (3.10%) VB.NET
11 53 (2.53%) Java
12 29 (1.38%) PHP
12 29 (1.38%) VB
13 27 (1.29%) PL/SQL
14 20 (0.95%) TypeScript
15 13 (0.62%) Bash Shell
15 13 (0.62%) C++
16 12 (0.57%) U-SQL
17 10 (0.48%) RPG
18 8 (0.38%) MATLAB
Qualifications
1 150 (7.16%) Degree
2 80 (3.82%) Microsoft Certification
3 31 (1.48%) Computer Science Degree
4 27 (1.29%) MCSA
5 26 (1.24%) Security Cleared
6 19 (0.91%) Master's Degree
7 17 (0.81%) SC Cleared
8 13 (0.62%) MCSE
9 11 (0.52%) DBS Check
9 11 (0.52%) ISEB
10 10 (0.48%) MCT
11 8 (0.38%) MCITP
11 8 (0.38%) MCP
12 6 (0.29%) ISTQB
13 5 (0.24%) MCTS
14 4 (0.19%) MCDBA
15 3 (0.14%) MBCS
15 3 (0.14%) MCAD
15 3 (0.14%) MCSD
16 2 (0.095%) Numerate Degree
Quality Assurance & Compliance
1 134 (6.39%) Data Quality
2 61 (2.91%) QA
3 43 (2.05%) GDPR
4 28 (1.34%) SLA
5 20 (0.95%) ISO/IEC 27001
6 8 (0.38%) Solvency II
7 5 (0.24%) PMO
8 4 (0.19%) IFRS
9 3 (0.14%) HL7
10 2 (0.095%) IFRS 9
10 2 (0.095%) PCI DSS
System Software
1 45 (2.15%) VMware Infrastructure
2 31 (1.48%) Active Directory
3 18 (0.86%) Hyper-V
4 16 (0.76%) LXC
5 10 (0.48%) Docker
6 7 (0.33%) Virtual Machines
7 3 (0.14%) Apache Flume
8 1 (0.048%) HDFS
Systems Management
1 22 (1.05%) Failover Clustering
2 21 (1.00%) Perfmon
3 20 (0.95%) Ansible
4 15 (0.72%) Grafana
5 12 (0.57%) Microsoft Clustering
6 8 (0.38%) Hadoop YARN
7 7 (0.33%) Prometheus
8 6 (0.29%) SQL Sentry
9 4 (0.19%) CloudHub
9 4 (0.19%) Dollar Universe
10 3 (0.14%) Oracle RMAN
10 3 (0.14%) WMI
11 2 (0.095%) Ambari
11 2 (0.095%) HP ALM
11 2 (0.095%) Kubernetes
11 2 (0.095%) Opscode Chef
11 2 (0.095%) Puppet
11 2 (0.095%) Salt
12 1 (0.048%) Terraform
Vendors
1 983 (46.90%) Microsoft
2 315 (15.03%) Tableau
3 119 (5.68%) Oracle
4 98 (4.68%) Databricks
5 57 (2.72%) SAP
6 46 (2.19%) VMware
7 39 (1.86%) IBM
8 35 (1.67%) Cognos
9 29 (1.38%) RedGate
10 26 (1.24%) Talend
11 23 (1.10%) Google
12 22 (1.05%) SolarWinds
13 21 (1.00%) Informatica
13 21 (1.00%) Veeam
14 20 (0.95%) Teradata
15 18 (0.86%) Red Hat
16 15 (0.72%) Netezza
17 12 (0.57%) Salesforce.com
18 10 (0.48%) JD Edwards
19 9 (0.43%) BT