Period
to 21 February 2018

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

Microsoft SQL Server Analysis Services (SSAS)
Central London > City of London
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 132 83 115
Rank change year-on-year -49 +32 +22
Permanent jobs citing SQL Server Analysis Services 250 383 380
As % of all permanent IT jobs advertised in the City of London 2.33% 3.65% 2.74%
As % of the Database & Business Intelligence category 7.59% 11.60% 8.93%
Number of salaries quoted 210 380 364
City of London median annual salary £55,000 £60,000 £57,500
Median salary % change year-on-year -8.33% +4.35% +4.55%
10th Percentile £42,500 £41,500 £43,750
90th Percentile £76,250 £75,000 £79,625
Central London median annual salary £55,000 £60,000 £57,500
% change year-on-year -8.33% +4.35% +4.55%

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 advertised in the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 3,295 3,303 4,253
As % of all permanent IT jobs advertised in the City of London 30.72% 31.51% 30.70%
Number of salaries quoted 2,953 3,060 3,767
City of London median annual salary £60,500 £57,500 £57,500
Median salary % change year-on-year +5.22% - +4.55%
10th Percentile £41,250 £36,250 £37,500
90th Percentile £90,000 £87,500 £85,000
Central London median annual salary £60,000 £57,500 £57,500
% change year-on-year +4.35% - +4.55%

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 6 months to 21 February 2018.

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

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

1 237 (94.80%) SQL Server Integration Services
2 222 (88.80%) SQL Server
3 214 (85.60%) SQL Server Reporting Services
4 203 (81.20%) SQL
5 168 (67.20%) Business Intelligence
6 161 (64.40%) Microsoft
7 151 (60.40%) Data Warehouse
8 133 (53.20%) ETL
8 133 (53.20%) T-SQL
9 122 (48.80%) Finance
10 80 (32.00%) Power BI
11 79 (31.60%) Agile Software Development
12 74 (29.60%) .NET
13 57 (22.80%) Microsoft Azure
14 55 (22.00%) SQL Server 2012
15 53 (21.20%) C#
16 49 (19.60%) Tableau
16 49 (19.60%) Analytical Skills
17 47 (18.80%) Kimball Methodology
18 46 (18.40%) Analytics
19 41 (16.40%) SQL Server 2008
20 39 (15.60%) SQL Server 2016
21 36 (14.40%) Degree
21 36 (14.40%) Data Modelling
22 34 (13.60%) SDLC
23 33 (13.20%) Data Analysis
24 32 (12.80%) QlikView
25 31 (12.40%) Test Automation
25 31 (12.40%) Mentoring
26 30 (12.00%) Team Foundation Server

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 18 (7.20%) SharePoint
2 9 (3.60%) IIS
3 8 (3.20%) Anypoint
3 8 (3.20%) BizTalk Server
3 8 (3.20%) JBoss
4 3 (1.20%) Apache
4 3 (1.20%) Apache Spark
5 1 (0.40%) CMS
5 1 (0.40%) Drupal
5 1 (0.40%) EPiServer
5 1 (0.40%) SAS
5 1 (0.40%) WebSphere
5 1 (0.40%) WordPress
Applications
1 21 (8.40%) Microsoft Excel
2 10 (4.00%) Spreadsheet
3 2 (0.80%) Microsoft Office
4 1 (0.40%) MS Visio
Business Applications
1 5 (2.00%) Elite 3E
2 3 (1.20%) Cognos Planning
2 3 (1.20%) Cognos TM1
2 3 (1.20%) HFM
3 2 (0.80%) MetaTrader
3 2 (0.80%) Raiser's Edge
4 1 (0.40%) Beauchamp
4 1 (0.40%) Cognos Business Intelligence
4 1 (0.40%) Dynamics AX
4 1 (0.40%) Dynamics CRM
4 1 (0.40%) Workday HCM
Cloud Services
1 57 (22.80%) Microsoft Azure
2 16 (6.40%) Amazon AWS
3 13 (5.20%) Azure Machine Learning
4 3 (1.20%) Azure Data Factory
4 3 (1.20%) Cortana Intelligence Suite
4 3 (1.20%) PaaS
5 1 (0.40%) Dynamics 365
5 1 (0.40%) GitHub
5 1 (0.40%) SaaS
Communications & Networking
1 3 (1.20%) SMS
2 2 (0.80%) Intranet
2 2 (0.80%) TCP/IP
3 1 (0.40%) Internet
Database & Business Intelligence
1 237 (94.80%) SQL Server Integration Services
2 222 (88.80%) SQL Server
3 214 (85.60%) SQL Server Reporting Services
4 151 (60.40%) Data Warehouse
5 80 (32.00%) Power BI
6 55 (22.00%) SQL Server 2012
7 41 (16.40%) SQL Server 2008
8 39 (15.60%) SQL Server 2016
9 32 (12.80%) QlikView
10 30 (12.00%) OLAP
11 21 (8.40%) Big Data
12 18 (7.20%) Enterprise Data Warehouse
12 18 (7.20%) NoSQL
13 16 (6.40%) OLTP
14 13 (5.20%) Amazon RDS
14 13 (5.20%) Amazon Redshift
14 13 (5.20%) Crystal Reports
15 12 (4.80%) Azure SQL Database
15 12 (4.80%) DTS
16 11 (4.40%) PowerPivot
Development Applications
1 30 (12.00%) Team Foundation Server
2 29 (11.60%) Visual Studio
3 21 (8.40%) JIRA
4 15 (6.00%) Jenkins
4 15 (6.00%) Octopus Deploy
5 14 (5.60%) SQL Server Management Studio (SSMS)
6 9 (3.60%) TeamCity
7 8 (3.20%) Eclipse
7 8 (3.20%) Subversion
8 7 (2.80%) RStudio
8 7 (2.80%) Visual Studio Team System
9 5 (2.00%) Git (software)
10 2 (0.80%) Moq
10 2 (0.80%) MSTest
10 2 (0.80%) NUnit
10 2 (0.80%) Rhino Mocks
11 1 (0.40%) Bugzilla
11 1 (0.40%) ERwin
11 1 (0.40%) Toad
General
1 122 (48.80%) Finance
2 9 (3.60%) Advertising
3 8 (3.20%) Law
4 7 (2.80%) Legal
5 6 (2.40%) Banking
5 6 (2.40%) Retail
6 3 (1.20%) Investment Banking
7 2 (0.80%) Marketing
8 1 (0.40%) Billing
8 1 (0.40%) Financial Institution
8 1 (0.40%) Games
Job Titles
1 143 (57.20%) Developer
2 77 (30.80%) Business Intelligence Developer
3 74 (29.60%) SQL Developer
4 45 (18.00%) SSIS Developer
5 41 (16.40%) SSAS Developer
6 36 (14.40%) SSRS Developer
7 32 (12.80%) SQL Server Developer
8 31 (12.40%) Business Intelligence Lead
8 31 (12.40%) ETL Developer
9 30 (12.00%) SQL BI Developer
10 27 (10.80%) Analyst
11 19 (7.60%) Test Leader
12 17 (6.80%) Architect
12 17 (6.80%) Consultant
12 17 (6.80%) T-SQL Developer
13 16 (6.40%) .NET Developer
14 15 (6.00%) Analyst Developer
14 15 (6.00%) C# Developer
14 15 (6.00%) Database Developer
14 15 (6.00%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 74 (29.60%) .NET
2 27 (10.80%) ASP.NET
3 22 (8.80%) JSON
4 19 (7.60%) MDX
5 17 (6.80%) Web Services
6 14 (5.60%) ASP.NET MVC
7 10 (4.00%) Angular 2
8 7 (2.80%) XML
9 5 (2.00%) SOAP
9 5 (2.00%) WCF
9 5 (2.00%) WPF
10 4 (1.60%) .NET Framework
10 4 (1.60%) Entity Framework
10 4 (1.60%) HTML
10 4 (1.60%) REST
11 3 (1.20%) HTML5
12 2 (0.80%) CSS
12 2 (0.80%) jQuery
12 2 (0.80%) WinForms
13 1 (0.40%) Ajax
Miscellaneous
1 49 (19.60%) Analytical Skills
2 19 (7.60%) Data Structures
3 14 (5.60%) Computer Science
4 13 (5.20%) Management Information System
5 10 (4.00%) Enterprise Software
5 10 (4.00%) Reinsurance
6 7 (2.80%) Hybrid Cloud
7 6 (2.40%) Fintech
7 6 (2.40%) Virtual Team
8 5 (2.00%) User Experience
9 4 (1.60%) Greenfield Project
9 4 (1.60%) Replication
10 2 (0.80%) Foreign Exchange (FX)
10 2 (0.80%) Spread Betting
11 1 (0.40%) Clustering
11 1 (0.40%) FMCG
11 1 (0.40%) Hedge funds
11 1 (0.40%) Market Risk
11 1 (0.40%) Mobile App
11 1 (0.40%) Reference Data
Operating Systems
1 18 (7.20%) Windows
2 12 (4.80%) Windows Server
3 7 (2.80%) VMS
4 5 (2.00%) Linux
5 1 (0.40%) Unix
5 1 (0.40%) Windows 10
5 1 (0.40%) Windows 7
Processes & Methodologies
1 168 (67.20%) Business Intelligence
2 133 (53.20%) ETL
3 79 (31.60%) Agile Software Development
4 47 (18.80%) Kimball Methodology
5 46 (18.40%) Analytics
6 36 (14.40%) Data Modelling
7 34 (13.60%) SDLC
8 33 (13.20%) Data Analysis
9 31 (12.40%) Mentoring
9 31 (12.40%) Test Automation
10 24 (9.60%) Time Management
11 23 (9.20%) OO
11 23 (9.20%) Visualisation
12 22 (8.80%) User Acceptance Testing
13 21 (8.40%) Defect Management
13 21 (8.40%) Dimensional Modelling
13 21 (8.40%) Software Delivery
13 21 (8.40%) Test Planning
14 20 (8.00%) Configuration Management
14 20 (8.00%) Data Analytics
Programming Languages
1 203 (81.20%) SQL
2 133 (53.20%) T-SQL
3 53 (21.20%) C#
4 23 (9.20%) Python
5 21 (8.40%) R
6 20 (8.00%) PowerShell
7 14 (5.60%) Data Analysis Expressions (DAX)
8 12 (4.80%) Java
9 11 (4.40%) VB
10 10 (4.00%) VB.NET
10 10 (4.00%) VBA
11 8 (3.20%) PL/SQL
12 5 (2.00%) JavaScript
13 2 (0.80%) PHP
14 1 (0.40%) SAS Macro
14 1 (0.40%) VBScript
Qualifications
1 36 (14.40%) Degree
2 2 (0.80%) Computer Science Degree
2 2 (0.80%) MBA
2 2 (0.80%) Microsoft Certification
2 2 (0.80%) SC Cleared
2 2 (0.80%) Security Cleared
3 1 (0.40%) ITIL Foundation Certificate
3 1 (0.40%) MCSE
3 1 (0.40%) PMI Certification
3 1 (0.40%) PMP
Quality Assurance & Compliance
1 26 (10.40%) QA
2 18 (7.20%) Data Quality
System Software
1 6 (2.40%) HDFS
2 2 (0.80%) Active Directory
3 1 (0.40%) Docker
3 1 (0.40%) Microsoft App-V
Systems Management
1 8 (3.20%) Opscode Chef
1 8 (3.20%) Puppet
2 2 (0.80%) HP Data Protector
3 1 (0.40%) Ansible
3 1 (0.40%) HP Quality Center
Vendors
1 161 (64.40%) Microsoft
2 49 (19.60%) Tableau
3 13 (5.20%) Alteryx
3 13 (5.20%) Cognos
4 12 (4.80%) VMware
5 10 (4.00%) Infragistics
6 8 (3.20%) Oracle
6 8 (3.20%) webMethods
7 6 (2.40%) Aderant
8 4 (1.60%) TIBCO
9 3 (1.20%) Google
9 3 (1.20%) HP
9 3 (1.20%) Hyperion
9 3 (1.20%) Informatica
9 3 (1.20%) Siebel
9 3 (1.20%) Tagetik
9 3 (1.20%) Twitter
10 2 (0.80%) Salesforce.com
11 1 (0.40%) EMC
11 1 (0.40%) IBM