The following table provides summary statistics for permanent job vacancies advertised in the City of London 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 3 months to 28 June 2017 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
London / City of London
3 months to
28 Jun 2017
Same period 2016 Same period 2015
Rank 92 110 103
Rank change year-on-year +18 -7  
Permanent jobs citing SQL Server Analysis Services 146 160 263
As % of all permanent IT jobs advertised in the City of London 2.84% 2.51% 2.59%
As % of the Database & Business Intelligence category 9.11% 9.16% 8.76%
Number of salaries quoted 138 147 236
Median salary £59,250 £55,000 £57,500
Median salary % change year-on-year +7.72% -4.34%  
90% offered a salary of more than £45,000 £41,250 £41,250
10% offered a salary of more than £72,500 £71,750 £77,500
UK excluding London median salary £42,500 £42,500 £42,500

SQL Server Analysis Services is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
City of London
Permanent job vacancies with a requirement for database and business intelligence skills 1602 1746 3001
As % of all permanent IT job vacancies advertised in the City of London 31.17% 27.41% 29.50%
Number of salaries quoted 3648 4452 6730
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.34% -  
90% offered a salary of more than £37,500 £37,500 £37,450
10% offered a salary of more than £80,000 £80,000 £85,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

SQL Server Analysis Services
Job Vacancy Trend in the City of London

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL Server Analysis Services in the City of London.

Salary trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Salary Histogram in the City of London

The salary distribution of IT jobs citing SQL Server Analysis Services in the City of London over the 3 months to 28 June 2017.

Salary histogram for SQL Server Analysis Services in the City of London

For the 6 months to 28 June 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 across the City of London region with a requirement for SQL Server Analysis Services.

1 324 (92.31%) SQL Server
2 296 (84.33%) SQL Server Integration Services
3 263 (74.93%) SQL
4 254 (72.36%) SQL Server Reporting Services
5 245 (69.80%) Business Intelligence
6 227 (64.67%) Microsoft
7 175 (49.86%) T-SQL
8 172 (49.00%) Data Warehouse
9 160 (45.58%) Finance
10 142 (40.46%) ETL
11 136 (38.75%) Power BI
12 81 (23.08%) .NET
13 74 (21.08%) C#
14 69 (19.66%) Tableau
15 65 (18.52%) Banking
15 65 (18.52%) MDX
16 59 (16.81%) Degree
16 59 (16.81%) SQL Server 2008
17 58 (16.52%) Agile Software Development
18 53 (15.10%) Sybase
19 52 (14.81%) Data Modelling
20 45 (12.82%) OLAP
21 43 (12.25%) Oracle
22 38 (10.83%) Data Analysis Expressions (DAX)
23 36 (10.26%) Performance Tuning
23 36 (10.26%) Java
24 35 (9.97%) Greenfield Project
24 35 (9.97%) Kimball Methodology
25 34 (9.69%) Big Data
25 34 (9.69%) OLAP Cube

SQL Server Analysis Services
Co-occurring IT Skills in the City of London 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 28 (7.98%) SharePoint
2 19 (5.41%) Confluence
3 9 (2.56%) IIS
4 6 (1.71%) Anypoint
4 6 (1.71%) BizTalk Server
4 6 (1.71%) JBoss
5 4 (1.14%) CMS
5 4 (1.14%) EPiServer
6 3 (0.85%) WebSphere
7 2 (0.57%) SharePoint 2013
8 1 (0.28%) Apache
8 1 (0.28%) Apache Spark
8 1 (0.28%) Jetty
8 1 (0.28%) MS Project Server
8 1 (0.28%) SAS
8 1 (0.28%) SharePoint 2010
Applications
1 29 (8.26%) Microsoft Excel
2 26 (7.41%) MS Visio
3 6 (1.71%) Spreadsheet
4 1 (0.28%) Microsoft Office
4 1 (0.28%) Microsoft Project
4 1 (0.28%) SPSS
Business Applications
1 16 (4.56%) Markit EDM
2 12 (3.42%) thinkFolio
3 2 (0.57%) Dynamics GP
3 2 (0.57%) Maximo
4 1 (0.28%) Eagle PACE
Cloud Services
1 28 (7.98%) Microsoft Azure
2 3 (0.85%) Amazon AWS
3 2 (0.57%) Azure Machine Learning
4 1 (0.28%) SaaS
Communications & Networking
1 9 (2.56%) Intranet
2 5 (1.42%) SAN
3 4 (1.14%) Internet
4 2 (0.57%) LAN
5 1 (0.28%) Firewall
5 1 (0.28%) FTP
5 1 (0.28%) HTTP
5 1 (0.28%) NAS
5 1 (0.28%) WAN
Database & Business Intelligence
1 324 (92.31%) SQL Server
2 296 (84.33%) SQL Server Integration Services
3 254 (72.36%) SQL Server Reporting Services
4 172 (49.00%) Data Warehouse
5 136 (38.75%) Power BI
6 59 (16.81%) SQL Server 2008
7 45 (12.82%) OLAP
8 34 (9.69%) Big Data
8 34 (9.69%) OLAP Cube
9 33 (9.40%) NoSQL
10 32 (9.12%) SQL Server 2012
11 29 (8.26%) SQL Server 2014
12 25 (7.12%) Microsoft Analysis Services
12 25 (7.12%) QlikView
12 25 (7.12%) SSDT
13 11 (3.13%) SQL Server 2016
14 10 (2.85%) Hadoop
14 10 (2.85%) Pentaho
14 10 (2.85%) SQL Server 2005
15 8 (2.28%) Data Lake
Development Applications
1 25 (7.12%) PowerDesigner
2 24 (6.84%) JIRA
2 24 (6.84%) Subversion
3 17 (4.84%) Team Foundation Server
4 15 (4.27%) Visual Studio
5 13 (3.70%) TeamCity
6 7 (1.99%) Jenkins
6 7 (1.99%) SQL Server Management Studio (SSMS)
6 7 (1.99%) TortoiseSVN
7 6 (1.71%) Octopus Deploy
8 5 (1.42%) RStudio
9 3 (0.85%) MSTest
9 3 (0.85%) NSubstitute
9 3 (0.85%) Rhino Mocks
9 3 (0.85%) Visual Studio Tools for Office
10 2 (0.57%) Maven
11 1 (0.28%) Eclipse
General
1 160 (45.58%) Finance
2 65 (18.52%) Banking
3 28 (7.98%) Law
4 27 (7.69%) Legal
5 12 (3.42%) Front Office
6 7 (1.99%) Investment Banking
7 6 (1.71%) Advertising
8 4 (1.14%) Marketing
8 4 (1.14%) Retail
9 3 (0.85%) Pharmaceutical
10 2 (0.57%) Back Office
Job Titles
1 222 (63.25%) Developer
2 158 (45.01%) Business Intelligence Developer
3 93 (26.50%) SSAS Developer
4 70 (19.94%) SQL Developer
5 54 (15.38%) Senior Developer
6 53 (15.10%) Analyst
7 52 (14.81%) Business Developer
7 52 (14.81%) Senior Business Intelligence Developer
8 42 (11.97%) SQL BI Developer
9 36 (10.26%) DBA
9 36 (10.26%) SSIS Developer
10 34 (9.69%) SQL DBA
11 33 (9.40%) SSRS Developer
12 25 (7.12%) SQL Server DBA
13 24 (6.84%) Dashboard Developer
13 24 (6.84%) OLAP Developer
13 24 (6.84%) Senior OLAP Developer
13 24 (6.84%) Tableau Developer
14 23 (6.55%) Business Intelligence Analyst
15 21 (5.98%) Senior DBA
Libraries, Frameworks & Software Standards
1 81 (23.08%) .NET
2 65 (18.52%) MDX
3 31 (8.83%) ASP.NET
4 20 (5.70%) ASP.NET MVC
5 9 (2.56%) XML
6 7 (1.99%) jQuery
6 7 (1.99%) Visualforce
6 7 (1.99%) Web Services
7 5 (1.42%) .NET Framework
8 4 (1.14%) Ajax
8 4 (1.14%) ASP.NET MVC 3
8 4 (1.14%) ASP.NET Web Forms
8 4 (1.14%) HTML
8 4 (1.14%) LESS
8 4 (1.14%) Sass
8 4 (1.14%) XSLT
9 3 (0.85%) AngularJS
9 3 (0.85%) COM
9 3 (0.85%) Entity Framework
10 2 (0.57%) HTML5
Miscellaneous
1 35 (9.97%) Greenfield Project
2 14 (3.99%) Management Information System
2 14 (3.99%) User Experience
3 13 (3.70%) Data Structures
4 11 (3.13%) Analytical Skills
4 11 (3.13%) Computer Science
5 6 (1.71%) Enterprise Software
6 5 (1.42%) Clustering
6 5 (1.42%) Data Centre
7 4 (1.14%) FMCG
8 3 (0.85%) Credit Risk
8 3 (0.85%) Reinsurance
8 3 (0.85%) Replication
9 2 (0.57%) Derivative
9 2 (0.57%) Foreign Exchange (FX)
9 2 (0.57%) Hedge funds
9 2 (0.57%) Spread Betting
10 1 (0.28%) BYOD
10 1 (0.28%) Fintech
10 1 (0.28%) NHS
Operating Systems
1 16 (4.56%) Windows
2 15 (4.27%) Windows Server
3 5 (1.42%) Windows Server 2008
3 5 (1.42%) Windows Server 2012
4 1 (0.28%) Android
4 1 (0.28%) Unix
4 1 (0.28%) Windows Server 2003
Processes & Methodologies
1 245 (69.80%) Business Intelligence
2 142 (40.46%) ETL
3 58 (16.52%) Agile Software Development
4 52 (14.81%) Data Modelling
5 36 (10.26%) Performance Tuning
6 35 (9.97%) Kimball Methodology
7 33 (9.40%) Visualisation
8 31 (8.83%) Dashboard Development
9 30 (8.55%) Data Visualisation
9 30 (8.55%) Web Development
10 28 (7.98%) Regression Testing
11 25 (7.12%) Configuration Management
12 24 (6.84%) Analytics
13 23 (6.55%) Practice Management
14 22 (6.27%) Asset Management
15 21 (5.98%) Mentoring
16 20 (5.70%) MVC
17 18 (5.13%) Scrum
18 17 (4.84%) Coaching
18 17 (4.84%) Migration
Programming Languages
1 263 (74.93%) SQL
2 175 (49.86%) T-SQL
3 74 (21.08%) C#
4 38 (10.83%) Data Analysis Expressions (DAX)
5 36 (10.26%) Java
6 33 (9.40%) PowerShell
7 15 (4.27%) VBA
8 8 (2.28%) JavaScript
9 7 (1.99%) Apex Code
9 7 (1.99%) R
10 6 (1.71%) VB
11 4 (1.14%) XPath
12 3 (0.85%) C
12 3 (0.85%) C++
12 3 (0.85%) PL/SQL
13 2 (0.57%) PHP
13 2 (0.57%) VB.NET
14 1 (0.28%) Data Mining Extensions (DMX)
14 1 (0.28%) Korn
14 1 (0.28%) Python
Qualifications
1 59 (16.81%) Degree
2 9 (2.56%) Microsoft Certification
3 6 (1.71%) Computer Science Degree
4 3 (0.85%) ITIL Certification
4 3 (0.85%) Numerate Degree
Quality Assurance & Compliance
1 15 (4.27%) QA
2 11 (3.13%) Data Quality
3 2 (0.57%) COBIT
4 1 (0.28%) MiFID
4 1 (0.28%) SLA
System Software
1 7 (1.99%) Active Directory
2 5 (1.42%) HDFS
3 1 (0.28%) Hyper-V
3 1 (0.28%) VMware Infrastructure
Systems Management
1 10 (2.85%) Control-M
2 6 (1.71%) Puppet
3 4 (1.14%) SQL Sentry
4 1 (0.28%) SCOM
Vendors
1 227 (64.67%) Microsoft
2 69 (19.66%) Tableau
3 53 (15.10%) Sybase
4 43 (12.25%) Oracle
5 22 (6.27%) Salesforce.com
6 20 (5.70%) Cognos
7 7 (1.99%) VMware
8 6 (1.71%) Siebel
8 6 (1.71%) webMethods
9 5 (1.42%) SAP
10 4 (1.14%) SolarWinds
10 4 (1.14%) Sun
11 3 (0.85%) Concur
11 3 (0.85%) IBM
12 1 (0.28%) Apple
12 1 (0.28%) DevExpress
12 1 (0.28%) MicroStrategy
12 1 (0.28%) Red Hat
12 1 (0.28%) Teradata
12 1 (0.28%) TIBCO
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 10 hours ago
City, London
Henderson Drake
Salary: From £35,000 to £40,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 3 hours ago
City, London
I3
Salary: £45000 - £50000 per annum + benefits + bonus
Posted: Yesterday
City, London
Harrington Starr
Salary: £65000 - £75000 per annum + Benefits + Bonus
Posted: 2 days ago
City, London
Deerfoot IT Resources Ltd
Salary: £40000 - £55000 per annum
Posted: 5 days ago
City of London
Nigel Frank International
Salary: £55000 per annum
Posted: 23 days ago
City, London
I3
Salary: £69000 - £80000 per annum + bonus + extensive benefits
Posted: 6 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 13 days ago