Period
to 19 November 2017

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 19 November 2017 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
19 Nov 2017
Same period 2016 Same period 2015
Rank 138 115 124
Rank change year-on-year -23 +9 -22
Permanent jobs citing SQL Server Analysis Services 217 302 425
As % of all permanent IT jobs advertised in the City of London 2.14% 2.60% 2.47%
As % of the Database & Business Intelligence category 6.84% 8.60% 8.32%
Number of salaries quoted 197 284 400
City of London median annual salary £57,500 £60,000 £57,500
Median salary % change year-on-year -4.17% +4.35% +4.55%
10th Percentile £43,750 £43,400 £42,500
90th Percentile £77,250 £77,500 £81,250
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 3171 3510 5106
As % of all permanent IT jobs advertised in the City of London 31.30% 30.19% 29.70%
Number of salaries quoted 2899 3219 4436
City of London median annual salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.35% - +4.55%
10th Percentile £41,250 £36,250 £36,250
90th Percentile £87,500 £86,250 £85,000
Central London median annual salary £59,500 £55,000 £56,000
% change year-on-year +8.18% -1.79% +1.82%

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 19 November 2017.

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

For the 6 months to 19 November 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 199 (91.71%) SQL Server
2 193 (88.94%) SQL Server Integration Services
3 179 (82.49%) SQL
4 175 (80.65%) SQL Server Reporting Services
5 145 (66.82%) Microsoft
6 142 (65.44%) Business Intelligence
7 124 (57.14%) ETL
8 122 (56.22%) T-SQL
9 112 (51.61%) Data Warehouse
10 106 (48.85%) Finance
11 72 (33.18%) .NET
11 72 (33.18%) Power BI
12 55 (25.35%) C#
13 49 (22.58%) Microsoft Azure
14 46 (21.20%) Degree
14 46 (21.20%) SQL Server 2012
15 44 (20.28%) Agile Software Development
16 41 (18.89%) SQL Server 2008
17 36 (16.59%) Tableau
18 34 (15.67%) ASP.NET
19 31 (14.29%) Windows
20 30 (13.82%) SharePoint
20 30 (13.82%) Dimensional Modelling
21 29 (13.36%) Data Analysis
21 29 (13.36%) Data Modelling
21 29 (13.36%) Analytics
22 28 (12.90%) Kimball Methodology
23 26 (11.98%) Analytical Skills
23 26 (11.98%) Test Automation
24 25 (11.52%) Amazon AWS

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 30 (13.82%) SharePoint
2 22 (10.14%) IIS
3 14 (6.45%) Anypoint
3 14 (6.45%) BizTalk Server
3 14 (6.45%) JBoss
4 7 (3.23%) SharePoint 2010
4 7 (3.23%) WordPress
5 6 (2.76%) SharePoint 2013
6 3 (1.38%) Drupal
7 1 (0.46%) CMS
7 1 (0.46%) EPiServer
7 1 (0.46%) SAS
7 1 (0.46%) SharePoint Server
7 1 (0.46%) WebSphere
Applications
1 16 (7.37%) Microsoft Excel
2 6 (2.76%) Spreadsheet
3 5 (2.30%) MS Visio
4 2 (0.92%) Microsoft Office
Business Applications
1 7 (3.23%) Cognos Business Intelligence
2 3 (1.38%) Workday HCM
3 2 (0.92%) Dynamics AX
3 2 (0.92%) Raiser's Edge
4 1 (0.46%) Cognos Planning
4 1 (0.46%) Cognos TM1
4 1 (0.46%) Dynamics CRM
4 1 (0.46%) HFM
Cloud Services
1 49 (22.58%) Microsoft Azure
2 25 (11.52%) Amazon AWS
3 13 (5.99%) Azure Machine Learning
4 7 (3.23%) GitHub
5 3 (1.38%) Azure Data Factory
5 3 (1.38%) Cortana Intelligence Suite
5 3 (1.38%) PaaS
5 3 (1.38%) SaaS
6 1 (0.46%) Dynamics 365
6 1 (0.46%) IaaS
Communications & Networking
1 7 (3.23%) Intranet
2 1 (0.46%) Internet
2 1 (0.46%) SMS
2 1 (0.46%) TCP/IP
Database & Business Intelligence
1 199 (91.71%) SQL Server
2 193 (88.94%) SQL Server Integration Services
3 175 (80.65%) SQL Server Reporting Services
4 112 (51.61%) Data Warehouse
5 72 (33.18%) Power BI
6 46 (21.20%) SQL Server 2012
7 41 (18.89%) SQL Server 2008
8 24 (11.06%) NoSQL
8 24 (11.06%) QlikView
9 22 (10.14%) Big Data
10 21 (9.68%) SQL Server 2016
11 20 (9.22%) OLAP
12 17 (7.83%) OLAP Cube
13 15 (6.91%) SQL Server 2014
14 14 (6.45%) DTS
14 14 (6.45%) EDRMS
15 13 (5.99%) Amazon RDS
15 13 (5.99%) Amazon Redshift
16 12 (5.53%) Hadoop
16 12 (5.53%) Microsoft Analysis Services
Development Applications
1 22 (10.14%) SQL Server Management Studio (SSMS)
1 22 (10.14%) Visual Studio
2 16 (7.37%) Team Foundation Server
3 15 (6.91%) TeamCity
4 14 (6.45%) Jenkins
4 14 (6.45%) Octopus Deploy
5 10 (4.61%) JIRA
5 10 (4.61%) RStudio
5 10 (4.61%) Subversion
6 7 (3.23%) Git (software)
7 4 (1.84%) PowerDesigner
8 1 (0.46%) Bugzilla
8 1 (0.46%) Eclipse
8 1 (0.46%) ERwin
8 1 (0.46%) Toad
General
1 106 (48.85%) Finance
2 11 (5.07%) Advertising
2 11 (5.07%) Banking
3 10 (4.61%) Law
4 8 (3.69%) Investment Banking
4 8 (3.69%) Retail
5 7 (3.23%) Legal
6 2 (0.92%) Marketing
7 1 (0.46%) Back Office
7 1 (0.46%) Financial Institution
7 1 (0.46%) Front Office
7 1 (0.46%) Japanese Language
Job Titles
1 113 (52.07%) Developer
2 63 (29.03%) Business Intelligence Developer
3 62 (28.57%) SQL Developer
4 36 (16.59%) SSAS Developer
4 36 (16.59%) SSIS Developer
5 32 (14.75%) SSRS Developer
6 26 (11.98%) SQL BI Developer
7 25 (11.52%) Business Intelligence Lead
8 23 (10.60%) T-SQL Developer
9 21 (9.68%) Analyst
9 21 (9.68%) Architect
9 21 (9.68%) DBA
10 19 (8.76%) ETL Developer
11 18 (8.29%) Solutions Architect
11 18 (8.29%) SQL DBA
12 16 (7.37%) Database Developer
12 16 (7.37%) SQL Database Developer
13 15 (6.91%) Consultant
13 15 (6.91%) SQL Server Developer
14 14 (6.45%) TOGAF Architect
Libraries, Frameworks & Software Standards
1 72 (33.18%) .NET
2 34 (15.67%) ASP.NET
3 21 (9.68%) MDX
4 18 (8.29%) JSON
5 15 (6.91%) ASP.NET MVC
6 10 (4.61%) CSS
6 10 (4.61%) HTML
7 8 (3.69%) jQuery
7 8 (3.69%) Web Services
7 8 (3.69%) XML
8 7 (3.23%) Ajax
8 7 (3.23%) Node.js
8 7 (3.23%) Razor View Engine
8 7 (3.23%) WAMP
8 7 (3.23%) WinForms
9 3 (1.38%) HTML5
9 3 (1.38%) SOAP
10 1 (0.46%) ASP.NET MVC 3
10 1 (0.46%) JDBC
10 1 (0.46%) ODBC
Miscellaneous
1 26 (11.98%) Analytical Skills
2 22 (10.14%) Management Information System
3 16 (7.37%) Enterprise Software
4 12 (5.53%) Replication
5 10 (4.61%) Computer Science
5 10 (4.61%) Data Structures
5 10 (4.61%) Greenfield Project
6 8 (3.69%) Clustering
7 7 (3.23%) Reinsurance
8 6 (2.76%) User Experience
9 1 (0.46%) Blog
9 1 (0.46%) Data Centre
9 1 (0.46%) Fintech
9 1 (0.46%) Market Risk
9 1 (0.46%) Reference Data
Operating Systems
1 31 (14.29%) Windows
2 20 (9.22%) Windows Server
3 10 (4.61%) Linux
4 3 (1.38%) Unix
4 3 (1.38%) Windows 10
4 3 (1.38%) Windows 7
5 1 (0.46%) VMS
Processes & Methodologies
1 142 (65.44%) Business Intelligence
2 124 (57.14%) ETL
3 44 (20.28%) Agile Software Development
4 30 (13.82%) Dimensional Modelling
5 29 (13.36%) Analytics
5 29 (13.36%) Data Analysis
5 29 (13.36%) Data Modelling
6 28 (12.90%) Kimball Methodology
7 26 (11.98%) Test Automation
8 25 (11.52%) Mentoring
9 23 (10.60%) Visualisation
10 20 (9.22%) Coaching
10 20 (9.22%) Time Management
11 19 (8.76%) Data Visualisation
11 19 (8.76%) DevOps
12 18 (8.29%) Performance Tuning
12 18 (8.29%) TOGAF
13 17 (7.83%) Configuration Management
14 16 (7.37%) OO
15 15 (6.91%) MVC
Programming Languages
1 179 (82.49%) SQL
2 122 (56.22%) T-SQL
3 55 (25.35%) C#
4 19 (8.76%) PowerShell
4 19 (8.76%) R
5 18 (8.29%) Java
5 18 (8.29%) Python
5 18 (8.29%) VB
6 13 (5.99%) VBA
7 10 (4.61%) PHP
8 8 (3.69%) Data Analysis Expressions (DAX)
9 7 (3.23%) PL/SQL
10 6 (2.76%) VBScript
11 5 (2.30%) JavaScript
12 2 (0.92%) Korn
12 2 (0.92%) Perl
13 1 (0.46%) C
13 1 (0.46%) SAS Macro
13 1 (0.46%) VB.NET
Qualifications
1 46 (21.20%) Degree
2 3 (1.38%) Computer Science Degree
2 3 (1.38%) Microsoft Certification
Quality Assurance & Compliance
1 17 (7.83%) QA
2 8 (3.69%) Data Quality
3 1 (0.46%) COBIT
3 1 (0.46%) MiFID
System Software
1 9 (4.15%) HDFS
2 3 (1.38%) Docker
2 3 (1.38%) Microsoft App-V
3 1 (0.46%) Active Directory
Systems Management
1 14 (6.45%) Puppet
2 6 (2.76%) Perfmon
3 3 (1.38%) Ansible
3 3 (1.38%) Opscode Chef
4 2 (0.92%) HP Quality Center
5 1 (0.46%) HP Data Protector
Vendors
1 145 (66.82%) Microsoft
2 36 (16.59%) Tableau
3 18 (8.29%) VMware
4 15 (6.91%) Cognos
5 14 (6.45%) Sybase
5 14 (6.45%) webMethods
6 13 (5.99%) Alteryx
7 10 (4.61%) Siebel
8 6 (2.76%) Bloomberg
8 6 (2.76%) Calypso
8 6 (2.76%) Murex
8 6 (2.76%) Oracle
8 6 (2.76%) Reuters
8 6 (2.76%) Salesforce.com
9 5 (2.30%) Informatica
10 4 (1.84%) Citrix
10 4 (1.84%) TIBCO
11 3 (1.38%) EMC
11 3 (1.38%) Google
11 3 (1.38%) HP