Period
to 27 May 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 27 May 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
27 May 2018
Same period 2017 Same period 2016
Rank 99 82 114
Rank change year-on-year -17 +32 +9
Permanent jobs citing SQL Server Analysis Services 324 368 371
As % of all permanent IT jobs advertised in the City of London 3.05% 3.59% 2.74%
As % of the Database & Business Intelligence category 9.74% 11.29% 9.67%
Number of salaries quoted 283 360 351
City of London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £42,500 £41,500 £41,875
90th Percentile £77,250 £72,500 £72,500
Central London median annual salary £60,000 £60,000 £55,000
% change year-on-year - +9.09% -

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,326 3,259 3,835
As % of all permanent IT jobs advertised in the City of London 31.35% 31.80% 28.37%
Number of salaries quoted 2,972 2,932 3,444
City of London median annual salary £65,000 £60,000 £55,000
Median salary % change year-on-year +8.33% +9.09% -
10th Percentile £41,250 £37,500 £36,750
90th Percentile £90,000 £87,500 £82,500
Central London median annual salary £62,500 £60,000 £55,000
% change year-on-year +4.17% +9.09% -

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 27 May 2018.

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

SQL Server Analysis Services
Job Locations in the City of London

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 City of London region over the 6 months to 27 May 2018. 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
London Bridge - 1 £44,000 -
SQL Server Analysis Services
Central London

For the 6 months to 27 May 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 311 (95.99%) SQL Server Integration Services
2 288 (88.89%) SQL Server Reporting Services
3 283 (87.35%) SQL Server
4 269 (83.02%) SQL
5 232 (71.60%) Business Intelligence
6 212 (65.43%) Microsoft
7 199 (61.42%) Data Warehouse
8 157 (48.46%) Finance
9 146 (45.06%) T-SQL
10 137 (42.28%) ETL
11 132 (40.74%) Power BI
12 127 (39.20%) Agile Software Development
13 75 (23.15%) .NET
14 71 (21.91%) Analytics
15 68 (20.99%) Microsoft Azure
16 63 (19.44%) SDLC
17 58 (17.90%) SQL Server 2012
18 54 (16.67%) Tableau
19 53 (16.36%) C#
20 52 (16.05%) Problem-Solving
21 48 (14.81%) Analytical Skills
21 48 (14.81%) Data Modelling
21 48 (14.81%) Team Foundation Server
22 46 (14.20%) Mentoring
23 43 (13.27%) SQL Server 2016
23 43 (13.27%) SQL Server 2008
24 41 (12.65%) Scrum
25 39 (12.04%) Kimball Methodology
26 38 (11.73%) OLAP
27 37 (11.42%) Visual Studio

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 15 (4.63%) SharePoint
2 7 (2.16%) NServiceBus
3 6 (1.85%) Apache Spark
3 6 (1.85%) SAS
4 4 (1.23%) Anypoint
4 4 (1.23%) Apache
4 4 (1.23%) BizTalk Server
4 4 (1.23%) IIS
4 4 (1.23%) JBoss
5 1 (0.31%) SharePoint 2013
5 1 (0.31%) SharePoint Server
Applications
1 35 (10.80%) Microsoft Excel
2 14 (4.32%) Spreadsheet
Business Applications
1 4 (1.23%) Elite 3E
2 3 (0.93%) Markit EDM
2 3 (0.93%) MetaTrader
3 2 (0.62%) Cognos Planning
3 2 (0.62%) Cognos TM1
3 2 (0.62%) HFM
4 1 (0.31%) Beauchamp
4 1 (0.31%) Dynamics CRM
Cloud Services
1 68 (20.99%) Microsoft Azure
2 16 (4.94%) Azure Data Factory
3 12 (3.70%) Azure Machine Learning
4 11 (3.40%) PaaS
5 4 (1.23%) Data Lake Analytics
6 2 (0.62%) Cortana Intelligence Suite
6 2 (0.62%) Dynamics 365
7 1 (0.31%) Amazon AWS
7 1 (0.31%) Google Analytics
Communications & Networking
1 2 (0.62%) SMS
2 1 (0.31%) Intranet
2 1 (0.31%) TCP/IP
Database & Business Intelligence
1 311 (95.99%) SQL Server Integration Services
2 288 (88.89%) SQL Server Reporting Services
3 283 (87.35%) SQL Server
4 199 (61.42%) Data Warehouse
5 132 (40.74%) Power BI
6 58 (17.90%) SQL Server 2012
7 43 (13.27%) SQL Server 2008
7 43 (13.27%) SQL Server 2016
8 38 (11.73%) OLAP
9 36 (11.11%) Data Lake
10 33 (10.19%) Azure SQL Database
11 32 (9.88%) Big Data
11 32 (9.88%) OLTP
12 23 (7.10%) PowerPivot
13 22 (6.79%) Microsoft Analysis Services
13 22 (6.79%) SQL Server 2014
14 20 (6.17%) Azure SQL Data Warehouse
14 20 (6.17%) QlikView
15 17 (5.25%) Enterprise Data Warehouse
16 15 (4.63%) Snowflake Schema
Development Applications
1 48 (14.81%) Team Foundation Server
2 37 (11.42%) Visual Studio
3 13 (4.01%) Jenkins
3 13 (4.01%) Octopus Deploy
4 10 (3.09%) JIRA
5 9 (2.78%) Visual Studio Team System
6 8 (2.47%) Git (software)
7 7 (2.16%) Eclipse
8 5 (1.54%) SQL Server Management Studio (SSMS)
8 5 (1.54%) TeamCity
9 4 (1.23%) RStudio
9 4 (1.23%) Subversion
10 2 (0.62%) Moq
10 2 (0.62%) MSTest
10 2 (0.62%) NUnit
10 2 (0.62%) Rhino Mocks
11 1 (0.31%) tSQLt
General
1 157 (48.46%) Finance
2 17 (5.25%) Advertising
3 11 (3.40%) Law
4 9 (2.78%) Legal
5 8 (2.47%) Banking
5 8 (2.47%) Games
6 7 (2.16%) Retail
7 3 (0.93%) Investment Banking
8 1 (0.31%) Billing
8 1 (0.31%) General Ledger
Job Titles
1 210 (64.81%) Developer
2 118 (36.42%) Business Intelligence Developer
3 94 (29.01%) SQL Developer
4 62 (19.14%) SSIS Developer
5 54 (16.67%) SQL BI Developer
6 48 (14.81%) SSRS Developer
7 41 (12.65%) .NET Developer
7 41 (12.65%) Analyst
8 39 (12.04%) SSAS Developer
9 35 (10.80%) C# Developer
9 35 (10.80%) Power BI Developer
10 34 (10.49%) ETL Developer
11 32 (9.88%) C# .NET Developer
12 31 (9.57%) SQL Server Developer
13 25 (7.72%) Business Intelligence Analyst
14 23 (7.10%) Analyst Developer
15 22 (6.79%) Microsoft Developer
16 21 (6.48%) T-SQL Developer
17 20 (6.17%) Business Intelligence Lead
17 20 (6.17%) Consultant
Libraries, Frameworks & Software Standards
1 75 (23.15%) .NET
2 24 (7.41%) .NET Framework
3 22 (6.79%) MDX
4 19 (5.86%) Web Services
5 17 (5.25%) ASP.NET
6 16 (4.94%) Entity Framework
6 16 (4.94%) JSON
7 15 (4.63%) ASP.NET MVC
8 14 (4.32%) REST
8 14 (4.32%) SOAP
9 8 (2.47%) Angular 2
9 8 (2.47%) HTML
10 6 (1.85%) WCF
10 6 (1.85%) WPF
11 5 (1.54%) CSS
11 5 (1.54%) HTML5
12 3 (0.93%) XML
13 2 (0.62%) jQuery
13 2 (0.62%) Twitter Bootstrap
14 1 (0.31%) Pandas
Miscellaneous
1 48 (14.81%) Analytical Skills
2 33 (10.19%) Data Structures
3 25 (7.72%) Self-Motivation
4 18 (5.56%) User Experience
5 17 (5.25%) Computer Science
6 16 (4.94%) Reinsurance
7 14 (4.32%) Virtual Team
8 11 (3.40%) Management Information System
9 9 (2.78%) Hybrid Cloud
10 8 (2.47%) Fintech
10 8 (2.47%) Replication
11 6 (1.85%) Greenfield Project
12 5 (1.54%) Analytical Mindset
12 5 (1.54%) Tandem
13 4 (1.23%) Enterprise Software
13 4 (1.23%) Foreign Exchange (FX)
13 4 (1.23%) Spread Betting
14 3 (0.93%) FMCG
15 1 (0.31%) Blog
15 1 (0.31%) Hedge funds
Operating Systems
1 9 (2.78%) VMS
2 7 (2.16%) Windows
3 6 (1.85%) Windows Server
4 4 (1.23%) Linux
Processes & Methodologies
1 232 (71.60%) Business Intelligence
2 137 (42.28%) ETL
3 127 (39.20%) Agile Software Development
4 71 (21.91%) Analytics
5 63 (19.44%) SDLC
6 52 (16.05%) Problem-Solving
7 48 (14.81%) Data Modelling
8 46 (14.20%) Mentoring
9 41 (12.65%) Scrum
10 39 (12.04%) Kimball Methodology
11 36 (11.11%) Data Analysis
11 36 (11.11%) Test Automation
12 33 (10.19%) Data Analytics
12 33 (10.19%) Performance Tuning
13 31 (9.57%) Release Management
14 30 (9.26%) Configuration Management
15 29 (8.95%) Continuous Improvement
16 27 (8.33%) Unit Testing
17 26 (8.02%) Continuous Integration
18 25 (7.72%) Mathematics
Programming Languages
1 269 (83.02%) SQL
2 146 (45.06%) T-SQL
3 53 (16.36%) C#
4 36 (11.11%) PowerShell
5 21 (6.48%) VBA
6 20 (6.17%) Data Analysis Expressions (DAX)
7 17 (5.25%) VB
8 12 (3.70%) Python
9 10 (3.09%) Java
9 10 (3.09%) R
10 9 (2.78%) JavaScript
10 9 (2.78%) VB.NET
11 7 (2.16%) PL/SQL
12 2 (0.62%) PHP
13 1 (0.31%) U-SQL
13 1 (0.31%) VBScript
Qualifications
1 33 (10.19%) Degree
2 9 (2.78%) Microsoft Certification
3 8 (2.47%) MCITP
3 8 (2.47%) Microsoft Certified Architect
4 7 (2.16%) Security Cleared
5 3 (0.93%) MBA
5 3 (0.93%) SC Cleared
6 2 (0.62%) PMI Certification
6 2 (0.62%) PMP
7 1 (0.31%) Computer Science Degree
7 1 (0.31%) ITIL Foundation Certificate
7 1 (0.31%) MCSE
Quality Assurance & Compliance
1 27 (8.33%) QA
2 21 (6.48%) Data Quality
3 1 (0.31%) SLA
System Software
1 1 (0.31%) Active Directory
1 1 (0.31%) HDFS
Systems Management
1 9 (2.78%) Opscode Chef
2 4 (1.23%) Puppet
3 3 (0.93%) Control-M
3 3 (0.93%) HP Quality Center
4 1 (0.31%) HP Data Protector
Vendors
1 212 (65.43%) Microsoft
2 54 (16.67%) Tableau
3 15 (4.63%) Oracle
3 15 (4.63%) Siebel
4 12 (3.70%) Cognos
5 8 (2.47%) Infragistics
6 6 (1.85%) VMware
7 5 (1.54%) Aderant
7 5 (1.54%) MicroStrategy
8 4 (1.23%) HP
8 4 (1.23%) webMethods
9 2 (0.62%) Alteryx
9 2 (0.62%) Hyperion
9 2 (0.62%) Tagetik
9 2 (0.62%) TIBCO
10 1 (0.31%) Databricks
10 1 (0.31%) Google
10 1 (0.31%) IBM
10 1 (0.31%) Salesforce.com