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

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
23 Oct 2017
Same period 2016 Same period 2015
Rank 239 239 173
Rank change year-on-year 0 -66 +5
Permanent jobs citing SQL Server Analysis Services 2584 2702 4320
As % of all permanent IT jobs advertised in the UK 1.47% 1.42% 1.97%
As % of the Database & Business Intelligence category 4.82% 4.81% 6.25%
Number of salaries quoted 2279 2398 3826
UK median annual salary £47,500 £50,000 £47,500
Median salary % change year-on-year -5.00% +5.26% +2.70%
10th Percentile £32,500 £32,500 £32,500
90th Percentile £70,000 £71,250 £73,750
UK excluding London median annual salary £42,500 £45,000 £42,500
% change year-on-year -5.56% +5.88% +6.25%

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 53569 56197 69091
As % of all permanent IT jobs advertised in the UK 30.52% 29.64% 31.59%
Number of salaries quoted 44034 47845 58259
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £30,000 £28,750 £28,000
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

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 October 2017.

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 23 October 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 +2 2499 £47,750 -4.50% 125
UK excluding London +34 1515 £42,500 -5.56% 76
London -26 1026 £57,500 - 51
North of England +28 600 £42,500 - 26
Yorkshire +52 302 £45,000 +5.88% 15
Midlands +75 294 £42,500 - 17
North West +7 287 £40,000 -5.88% 10
South East -39 261 £45,000 -5.26% 18
West Midlands +38 173 £42,500 +4.29% 10
East of England +35 168 £42,500 -15.00% 6
South West +10 137 £42,500 +3.66% 7
East Midlands +77 119 £43,250 -8.95% 7
Scotland -12 45 £35,000 -15.50% 1
North East +6 11 £38,000 -5.00% 1
Wales -17 9 £52,500 +31.25%
Northern Ireland -24 1 £35,000 -12.50%

For the 6 months to 23 October 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 2347 (90.83%) SQL Server Integration Services
2 2206 (85.37%) SQL
3 2202 (85.22%) SQL Server Reporting Services
4 2155 (83.40%) SQL Server
5 1936 (74.92%) Business Intelligence
6 1375 (53.21%) Microsoft
7 1322 (51.16%) T-SQL
8 1304 (50.46%) Data Warehouse
9 1005 (38.89%) ETL
10 689 (26.66%) Power BI
11 658 (25.46%) Finance
12 578 (22.37%) Agile Software Development
13 534 (20.67%) .NET
14 457 (17.69%) Microsoft Azure
15 446 (17.26%) SQL Server 2012
16 438 (16.95%) SQL Server 2008
16 438 (16.95%) C#
17 426 (16.49%) SQL Server 2014
18 384 (14.86%) SQL Server 2016
18 384 (14.86%) Data Modelling
19 377 (14.59%) Microsoft Analysis Services
20 374 (14.47%) Performance Tuning
21 347 (13.43%) OLAP
22 345 (13.35%) MDX
23 337 (13.04%) Tableau
24 325 (12.58%) Kimball Methodology
25 290 (11.22%) QlikView
26 282 (10.91%) Analytics
27 272 (10.53%) Degree
28 270 (10.45%) Analytical Skills

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 192 (7.43%) SharePoint
2 78 (3.02%) IIS
3 37 (1.43%) SAS
4 34 (1.32%) Apache
5 28 (1.08%) BizTalk Server
6 24 (0.93%) Apache Spark
7 17 (0.66%) Confluence
7 17 (0.66%) SharePoint 2010
8 14 (0.54%) JBoss
8 14 (0.54%) SharePoint 2013
9 12 (0.46%) Anypoint
10 11 (0.43%) Oracle SOA Suite
11 7 (0.27%) WebSphere
11 7 (0.27%) WordPress
12 6 (0.23%) Drupal
12 6 (0.23%) SharePoint Server
13 5 (0.19%) CMS
13 5 (0.19%) MS Exchange
14 4 (0.15%) Apache Pig
14 4 (0.15%) Gentran
Applications
1 196 (7.59%) Microsoft Excel
2 68 (2.63%) Microsoft Office
3 48 (1.86%) MS Visio
4 19 (0.74%) SPSS
5 8 (0.31%) Spreadsheet
5 8 (0.31%) Stata
6 7 (0.27%) Microsoft Project
7 5 (0.19%) Microsoft PowerPoint
8 1 (0.039%) InfoPath
Business Applications
1 67 (2.59%) Dynamics AX
2 49 (1.90%) Dynamics CRM
3 29 (1.12%) Dynamics NAV
4 25 (0.97%) Cognos Business Intelligence
5 11 (0.43%) Cognos TM1
6 7 (0.27%) Markit EDM
7 6 (0.23%) thinkFolio
8 5 (0.19%) HFM
9 4 (0.15%) Cognos Planning
9 4 (0.15%) Workday HCM
10 3 (0.12%) Sage 200
11 2 (0.077%) Dynamics GP
11 2 (0.077%) Infor SunSystems
11 2 (0.077%) Misys Opics
11 2 (0.077%) NetSuite
11 2 (0.077%) Raiser's Edge
11 2 (0.077%) Softmar
12 1 (0.039%) Sage 50
12 1 (0.039%) SAP Business One
12 1 (0.039%) StreamServe
Cloud Services
1 457 (17.69%) Microsoft Azure
2 104 (4.02%) Amazon AWS
3 58 (2.24%) Dynamics 365
4 53 (2.05%) Azure Data Factory
5 44 (1.70%) Azure Machine Learning
6 41 (1.59%) SaaS
7 26 (1.01%) IaaS
8 23 (0.89%) Cortana Intelligence Suite
9 22 (0.85%) PaaS
10 21 (0.81%) Office 365
11 13 (0.50%) GitHub
12 11 (0.43%) Firebase
13 7 (0.27%) Amazon EMR
13 7 (0.27%) Google Analytics
14 6 (0.23%) Cloud Computing
15 3 (0.12%) Amazon S3
15 3 (0.12%) Boomi
15 3 (0.12%) Data Lake Analytics
15 3 (0.12%) Mimecast
16 2 (0.077%) Google Play
Communications & Networking
1 52 (2.01%) Internet
2 22 (0.85%) Firewall
3 13 (0.50%) DNS
4 12 (0.46%) FTP
5 11 (0.43%) Intranet
6 8 (0.31%) SMS
7 6 (0.23%) Skype
8 5 (0.19%) AMQP
9 4 (0.15%) TCP/IP
10 3 (0.12%) GoToMeeting
10 3 (0.12%) SSL
10 3 (0.12%) WebEx
11 2 (0.077%) Cisco ASA
11 2 (0.077%) Kerberos
12 1 (0.039%) Extranet
12 1 (0.039%) LDAP
12 1 (0.039%) VPN
Database & Business Intelligence
1 2347 (90.83%) SQL Server Integration Services
2 2202 (85.22%) SQL Server Reporting Services
3 2155 (83.40%) SQL Server
4 1304 (50.46%) Data Warehouse
5 689 (26.66%) Power BI
6 446 (17.26%) SQL Server 2012
7 438 (16.95%) SQL Server 2008
8 426 (16.49%) SQL Server 2014
9 384 (14.86%) SQL Server 2016
10 377 (14.59%) Microsoft Analysis Services
11 347 (13.43%) OLAP
12 290 (11.22%) QlikView
13 249 (9.64%) Relational Database
14 209 (8.09%) Big Data
15 164 (6.35%) OLAP Cube
16 134 (5.19%) NoSQL
17 123 (4.76%) RDBMS
18 117 (4.53%) BusinessObjects
19 106 (4.10%) MySQL
20 103 (3.99%) SQL Server 2005
Development Applications
1 210 (8.13%) Visual Studio
2 177 (6.85%) Team Foundation Server
3 125 (4.84%) SQL Server Management Studio (SSMS)
4 60 (2.32%) Octopus Deploy
5 58 (2.24%) JIRA
6 47 (1.82%) TeamCity
7 40 (1.55%) Git (software)
8 37 (1.43%) Jenkins
9 33 (1.28%) Subversion
10 17 (0.66%) Selenium
11 16 (0.62%) Jasmine
12 15 (0.58%) SpecFlow
13 14 (0.54%) webpack
14 13 (0.50%) PowerDesigner
15 11 (0.43%) Karma Test Runner
15 11 (0.43%) PhantomJS
16 8 (0.31%) MSTest
17 7 (0.27%) Maven
17 7 (0.27%) Talend Open Studio
18 6 (0.23%) ERwin
General
1 658 (25.46%) Finance
2 226 (8.75%) Retail
3 142 (5.50%) Advertising
4 119 (4.61%) Banking
5 116 (4.49%) Marketing
6 111 (4.30%) Legal
7 49 (1.90%) Electronics
8 44 (1.70%) Manufacturing
9 40 (1.55%) Games
10 37 (1.43%) Telecoms
11 33 (1.28%) Law
12 31 (1.20%) Front Office
13 30 (1.16%) Investment Banking
14 29 (1.12%) Publishing
15 16 (0.62%) Automotive
16 11 (0.43%) Back Office
16 11 (0.43%) Retail Banking
17 9 (0.35%) Financial Institution
18 6 (0.23%) Pharmaceutical
19 3 (0.12%) Retail Finance
Job Titles
1 1508 (58.36%) Developer
2 851 (32.93%) Business Intelligence Developer
3 722 (27.94%) SQL Developer
4 379 (14.67%) DBA
5 355 (13.74%) SQL BI Developer
6 336 (13.00%) SQL DBA
7 306 (11.84%) SQL Server Developer
8 285 (11.03%) Analyst
9 264 (10.22%) SSIS Developer
10 203 (7.86%) SSRS Developer
11 201 (7.78%) Business Developer
12 194 (7.51%) Senior Developer
13 178 (6.89%) SSAS Developer
14 159 (6.15%) Consultant
15 158 (6.11%) Data Warehouse Developer
16 146 (5.65%) Administrator
16 146 (5.65%) SQL Server BI Developer
17 128 (4.95%) SQL Server DBA
18 123 (4.76%) T-SQL Developer
19 120 (4.64%) Architect
Libraries, Frameworks & Software Standards
1 534 (20.67%) .NET
2 345 (13.35%) MDX
3 187 (7.24%) ASP.NET
4 142 (5.50%) HTML
5 98 (3.79%) CSS
6 84 (3.25%) XML
7 78 (3.02%) Web Services
8 65 (2.52%) HTML5
9 57 (2.21%) .NET Framework
10 53 (2.05%) SOAP
11 51 (1.97%) AngularJS
12 49 (1.90%) Entity Framework
13 45 (1.74%) REST
14 44 (1.70%) ASP.NET Web API
15 42 (1.63%) ASP.NET MVC
16 39 (1.51%) WPF
17 37 (1.43%) jQuery
18 35 (1.35%) JSON
19 33 (1.28%) WCF
20 31 (1.20%) Node.js
Miscellaneous
1 270 (10.45%) Analytical Skills
2 131 (5.07%) Replication
3 116 (4.49%) Clustering
4 97 (3.75%) Computer Science
5 93 (3.60%) Management Information System
6 56 (2.17%) Greenfield Project
7 47 (1.82%) Data Structures
8 45 (1.74%) Fintech
9 44 (1.70%) Enterprise Software
10 28 (1.08%) Client/Server
11 26 (1.01%) NHS
12 21 (0.81%) Data Protection Act
13 20 (0.77%) User Experience
14 18 (0.70%) BBC
14 18 (0.70%) Social Media
15 17 (0.66%) Blog
16 16 (0.62%) iPad
17 15 (0.58%) Reinsurance
18 13 (0.50%) Algorithms
18 13 (0.50%) Credit Risk
Operating Systems
1 237 (9.17%) Windows
2 139 (5.38%) Windows Server
3 74 (2.86%) Linux
4 25 (0.97%) Unix
5 24 (0.93%) Android
6 22 (0.85%) Apple iOS
7 20 (0.77%) Windows Server 2012
8 11 (0.43%) Windows Server 2008
9 8 (0.31%) Windows 7
10 6 (0.23%) Windows 10
11 5 (0.19%) Solaris
11 5 (0.19%) VMS
12 2 (0.077%) Windows Server 2003
13 1 (0.039%) HPUX
13 1 (0.039%) Red Hat Enterprise Linux
13 1 (0.039%) Ubuntu
Processes & Methodologies
1 1936 (74.92%) Business Intelligence
2 1005 (38.89%) ETL
3 578 (22.37%) Agile Software Development
4 384 (14.86%) Data Modelling
5 374 (14.47%) Performance Tuning
6 325 (12.58%) Kimball Methodology
7 282 (10.91%) Analytics
8 269 (10.41%) Visualisation
9 205 (7.93%) Migration
10 203 (7.86%) Data Visualisation
11 177 (6.85%) Scrum
12 166 (6.42%) Mentoring
13 155 (6.00%) Disaster Recovery
14 152 (5.88%) Data Management
15 150 (5.80%) High Availability
16 143 (5.53%) CRM
17 133 (5.15%) Dimensional Modelling
18 109 (4.22%) E-Commerce
19 107 (4.14%) SDLC
20 103 (3.99%) ERP
Programming Languages
1 2206 (85.37%) SQL
2 1322 (51.16%) T-SQL
3 438 (16.95%) C#
4 198 (7.66%) PowerShell
5 116 (4.49%) Data Analysis Expressions (DAX)
6 112 (4.33%) Java
7 108 (4.18%) JavaScript
8 104 (4.02%) VB.NET
9 85 (3.29%) VBA
10 75 (2.90%) R
11 74 (2.86%) Python
12 67 (2.59%) VB
13 38 (1.47%) C
14 37 (1.43%) PL/SQL
15 32 (1.24%) X++
16 27 (1.04%) VBScript
17 24 (0.93%) Perl
17 24 (0.93%) Ruby
18 22 (0.85%) PHP
18 22 (0.85%) VB6
Qualifications
1 272 (10.53%) Degree
2 138 (5.34%) Microsoft Certification
3 40 (1.55%) Computer Science Degree
4 34 (1.32%) MCSE
5 32 (1.24%) MCITP
5 32 (1.24%) MCSA
6 31 (1.20%) Numerate Degree
7 24 (0.93%) MCTS
8 20 (0.77%) Security Cleared
9 18 (0.70%) Master's Degree
10 13 (0.50%) PhD
10 13 (0.50%) SC Cleared
11 9 (0.35%) MCP
12 7 (0.27%) ITIL Certification
12 7 (0.27%) MBA
13 6 (0.23%) DV Cleared
14 5 (0.19%) Oracle Certification
15 4 (0.15%) MCSD
15 4 (0.15%) PRINCE2 Practitioner
16 1 (0.039%) HND
Quality Assurance & Compliance
1 111 (4.30%) Data Quality
2 72 (2.79%) QA
3 29 (1.12%) PCI DSS
4 25 (0.97%) SLA
5 21 (0.81%) GDPR
6 10 (0.39%) ISO/IEC 27001
7 6 (0.23%) Cyber Essentials
7 6 (0.23%) SEPA
8 3 (0.12%) COBIT
8 3 (0.12%) MiFID
9 1 (0.039%) HL7
9 1 (0.039%) ISO 9001
9 1 (0.039%) PMO
System Software
1 62 (2.40%) Active Directory
2 17 (0.66%) VMware Infrastructure
3 14 (0.54%) Docker
4 10 (0.39%) HDFS
5 7 (0.27%) Oracle RAC
6 6 (0.23%) Virtual Machines
7 4 (0.15%) Apache Flume
7 4 (0.15%) Microsoft App-V
7 4 (0.15%) Microsoft Virtual Server
7 4 (0.15%) Virtual Servers
8 3 (0.12%) Hyper-V
9 2 (0.077%) Veritas Cluster Server
10 1 (0.039%) XenApp
10 1 (0.039%) XenDesktop
Systems Management
1 26 (1.01%) Failover Clustering
2 24 (0.93%) Puppet
3 16 (0.62%) Perfmon
4 15 (0.58%) Systems Management Server (SMS)
5 10 (0.39%) Grafana
6 9 (0.35%) Ansible
7 7 (0.27%) Data Guard
7 7 (0.27%) Microsoft Clustering
7 7 (0.27%) Nagios
7 7 (0.27%) Oracle RMAN
8 6 (0.23%) Opscode Chef
8 6 (0.23%) SCOM
9 5 (0.19%) Oozie
10 4 (0.15%) Control-M
11 3 (0.12%) Oracle Enterprise Manager
12 2 (0.077%) Kibana
12 2 (0.077%) SCCM
12 2 (0.077%) SQL Sentry
13 1 (0.039%) HP Quality Center
13 1 (0.039%) SCOrch
Vendors
1 1375 (53.21%) Microsoft
2 337 (13.04%) Tableau
3 263 (10.18%) Oracle
4 143 (5.53%) Cognos
5 106 (4.10%) SAP
6 55 (2.13%) Sybase
7 51 (1.97%) IBM
8 38 (1.47%) VMware
9 36 (1.39%) Facebook
10 31 (1.20%) Google
11 29 (1.12%) RedGate
12 26 (1.01%) MicroStrategy
13 24 (0.93%) Informatica
14 19 (0.74%) MuleSoft
15 18 (0.70%) Apple
15 18 (0.70%) JD Edwards
15 18 (0.70%) Sony
15 18 (0.70%) Yahoo!
16 15 (0.58%) Siebel
17 14 (0.54%) Salesforce.com