Period
to 21 July 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 July 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 Jul 2018
Same period 2017 Same period 2016
Rank 101 92 119
Rank change year-on-year -9 +27 +5
Permanent jobs citing SQL Server Analysis Services 346 331 345
As % of all permanent IT jobs advertised in the City of London 3.10% 3.20% 2.55%
As % of the Database & Business Intelligence category 9.80% 10.10% 9.01%
Number of salaries quoted 317 320 322
City of London median annual salary £62,500 £62,500 £55,000
Median salary % change year-on-year - +13.64% -
10th Percentile £41,700 £43,750 £41,750
90th Percentile £77,500 £75,000 £72,500
Central London median annual salary £62,500 £62,000 £55,000
% change year-on-year +0.81% +12.73% -

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,532 3,276 3,827
As % of all permanent IT jobs advertised in the City of London 31.67% 31.67% 28.26%
Number of salaries quoted 3,203 2,943 3,438
City of London median annual salary £65,000 £60,000 £55,000
Median salary % change year-on-year +8.33% +9.09% -
10th Percentile £40,000 £37,500 £36,250
90th Percentile £92,500 £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 21 July 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 21 July 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 21 July 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 330 (95.38%) SQL Server Integration Services
2 309 (89.31%) SQL Server Reporting Services
3 295 (85.26%) SQL
3 295 (85.26%) SQL Server
4 265 (76.59%) Business Intelligence
5 224 (64.74%) Microsoft
6 217 (62.72%) Data Warehouse
7 176 (50.87%) T-SQL
8 171 (49.42%) Power BI
9 170 (49.13%) Finance
10 144 (41.62%) ETL
11 123 (35.55%) Agile Software Development
12 77 (22.25%) .NET
13 76 (21.97%) Analytics
14 75 (21.68%) SDLC
15 71 (20.52%) Microsoft Azure
16 69 (19.94%) Tableau
17 65 (18.79%) C#
18 60 (17.34%) SQL Server 2012
19 55 (15.90%) Data Modelling
20 51 (14.74%) Scrum
20 51 (14.74%) SQL Server 2008
21 50 (14.45%) Team Foundation Server
22 48 (13.87%) SQL Server 2016
22 48 (13.87%) Data Lake
23 47 (13.58%) Analytical Skills
23 47 (13.58%) Microsoft Excel
24 45 (13.01%) PowerShell
24 45 (13.01%) Problem-Solving
25 43 (12.43%) Mentoring

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 12 (3.47%) NServiceBus
1 12 (3.47%) SAS
2 8 (2.31%) Apache Spark
2 8 (2.31%) SharePoint
3 5 (1.45%) Apache
4 4 (1.16%) Anypoint
4 4 (1.16%) BizTalk Server
4 4 (1.16%) IIS
4 4 (1.16%) JBoss
5 2 (0.58%) SharePoint 2013
6 1 (0.29%) Apache Pig
6 1 (0.29%) SharePoint Server
Applications
1 47 (13.58%) Microsoft Excel
2 15 (4.34%) Spreadsheet
3 1 (0.29%) Microsoft Office
3 1 (0.29%) Microsoft PowerPoint
3 1 (0.29%) MS Visio
Business Applications
1 3 (0.87%) Markit EDM
1 3 (0.87%) MetaTrader
2 2 (0.58%) Cognos Planning
2 2 (0.58%) Cognos TM1
2 2 (0.58%) Elite 3E
2 2 (0.58%) HFM
3 1 (0.29%) Dynamics CRM
Cloud Services
1 71 (20.52%) Microsoft Azure
2 22 (6.36%) Azure Data Factory
3 12 (3.47%) Azure Machine Learning
4 11 (3.18%) PaaS
5 8 (2.31%) Data Lake Analytics
6 4 (1.16%) GitHub
7 3 (0.87%) Amazon AWS
7 3 (0.87%) Cortana Intelligence Suite
8 2 (0.58%) Dynamics 365
8 2 (0.58%) Google Analytics
9 1 (0.29%) SaaS
Database & Business Intelligence
1 330 (95.38%) SQL Server Integration Services
2 309 (89.31%) SQL Server Reporting Services
3 295 (85.26%) SQL Server
4 217 (62.72%) Data Warehouse
5 171 (49.42%) Power BI
6 60 (17.34%) SQL Server 2012
7 51 (14.74%) SQL Server 2008
8 48 (13.87%) Data Lake
8 48 (13.87%) SQL Server 2016
9 42 (12.14%) OLAP
10 35 (10.12%) Azure SQL Database
10 35 (10.12%) Big Data
11 33 (9.54%) Microsoft Analysis Services
12 32 (9.25%) OLTP
13 28 (8.09%) SQL Server 2014
14 25 (7.23%) Azure SQL Data Warehouse
15 24 (6.94%) PowerPivot
16 20 (5.78%) BusinessObjects
16 20 (5.78%) OLAP Cube
17 15 (4.34%) Snowflake Schema
Development Applications
1 50 (14.45%) Team Foundation Server
2 33 (9.54%) Visual Studio
3 9 (2.60%) Git (software)
4 8 (2.31%) Jenkins
4 8 (2.31%) Octopus Deploy
5 7 (2.02%) Subversion
6 5 (1.45%) TeamCity
6 5 (1.45%) Visual Studio Team System
7 4 (1.16%) Eclipse
7 4 (1.16%) RStudio
7 4 (1.16%) SQL Server Management Studio (SSMS)
8 2 (0.58%) JIRA
8 2 (0.58%) tSQLt
9 1 (0.29%) TestRail
General
1 170 (49.13%) Finance
2 20 (5.78%) Advertising
3 13 (3.76%) Law
3 13 (3.76%) Retail
4 11 (3.18%) Banking
5 7 (2.02%) Games
5 7 (2.02%) General Ledger
6 6 (1.73%) Legal
7 2 (0.58%) Investment Banking
8 1 (0.29%) Financial Institution
Job Titles
1 232 (67.05%) Developer
2 131 (37.86%) Business Intelligence Developer
3 110 (31.79%) SQL Developer
4 69 (19.94%) SSIS Developer
5 67 (19.36%) SQL BI Developer
6 54 (15.61%) SSRS Developer
7 49 (14.16%) SSAS Developer
8 46 (13.29%) Analyst
9 41 (11.85%) .NET Developer
9 41 (11.85%) Power BI Developer
10 35 (10.12%) C# Developer
11 33 (9.54%) Microsoft Developer
12 32 (9.25%) Business Intelligence Analyst
13 31 (8.96%) C# .NET Developer
14 28 (8.09%) T-SQL Developer
15 27 (7.80%) Analyst Developer
15 27 (7.80%) Consultant
16 26 (7.51%) ETL Developer
17 25 (7.23%) SQL Server Developer
18 24 (6.94%) Senior Developer
Libraries, Frameworks & Software Standards
1 77 (22.25%) .NET
2 41 (11.85%) .NET Framework
3 23 (6.65%) Entity Framework
4 22 (6.36%) MDX
5 19 (5.49%) REST
5 19 (5.49%) SOAP
6 15 (4.34%) Web Services
7 11 (3.18%) JSON
8 10 (2.89%) ASP.NET
8 10 (2.89%) XML
9 8 (2.31%) HTML
10 7 (2.02%) ASP.NET MVC
11 6 (1.73%) CSS
12 5 (1.45%) ASP.NET Web API
13 4 (1.16%) HTML5
14 3 (0.87%) jQuery
14 3 (0.87%) WCF
15 2 (0.58%) DHTML
15 2 (0.58%) Twitter Bootstrap
15 2 (0.58%) XSLT
Miscellaneous
1 47 (13.58%) Analytical Skills
2 32 (9.25%) Data Structures
3 26 (7.51%) User Experience
4 21 (6.07%) Reinsurance
5 19 (5.49%) Self-Motivation
6 18 (5.20%) Computer Science
7 14 (4.05%) Replication
8 11 (3.18%) Virtual Team
9 10 (2.89%) Management Information System
10 7 (2.02%) Fintech
10 7 (2.02%) Greenfield Project
11 6 (1.73%) Analytical Mindset
12 5 (1.45%) Hybrid Cloud
12 5 (1.45%) Tandem
13 4 (1.16%) Enterprise Software
13 4 (1.16%) Foreign Exchange (FX)
14 3 (0.87%) Spread Betting
15 2 (0.58%) Blog
15 2 (0.58%) Clustering
15 2 (0.58%) FMCG
Operating Systems
1 12 (3.47%) Windows
2 4 (1.16%) Linux
2 4 (1.16%) VMS
2 4 (1.16%) Windows Server
Processes & Methodologies
1 265 (76.59%) Business Intelligence
2 144 (41.62%) ETL
3 123 (35.55%) Agile Software Development
4 76 (21.97%) Analytics
5 75 (21.68%) SDLC
6 55 (15.90%) Data Modelling
7 51 (14.74%) Scrum
8 45 (13.01%) Problem-Solving
9 43 (12.43%) Mentoring
10 37 (10.69%) Performance Tuning
11 36 (10.40%) Visualisation
12 33 (9.54%) Data Analytics
12 33 (9.54%) Kimball Methodology
13 32 (9.25%) Data Analysis
14 31 (8.96%) Unit Testing
15 30 (8.67%) Continuous Improvement
15 30 (8.67%) Data Management
15 30 (8.67%) Mathematics
16 29 (8.38%) Configuration Management
17 28 (8.09%) SOA
Programming Languages
1 295 (85.26%) SQL
2 176 (50.87%) T-SQL
3 65 (18.79%) C#
4 45 (13.01%) PowerShell
5 27 (7.80%) Data Analysis Expressions (DAX)
6 26 (7.51%) VB
6 26 (7.51%) VBA
7 16 (4.62%) Java
7 16 (4.62%) Python
8 11 (3.18%) R
9 9 (2.60%) JavaScript
10 5 (1.45%) PHP
10 5 (1.45%) PL/SQL
10 5 (1.45%) VBScript
11 3 (0.87%) U-SQL
12 1 (0.29%) C
12 1 (0.29%) VB.NET
Qualifications
1 36 (10.40%) Degree
2 15 (4.34%) Microsoft Certification
3 9 (2.60%) MCITP
3 9 (2.60%) Microsoft Certified Architect
4 6 (1.73%) Security Cleared
5 3 (0.87%) Computer Science Degree
5 3 (0.87%) MBA
6 2 (0.58%) PMI Certification
6 2 (0.58%) PMP
6 2 (0.58%) SC Cleared
7 1 (0.29%) ISTQB
7 1 (0.29%) Master's Degree
Quality Assurance & Compliance
1 23 (6.65%) Data Quality
2 21 (6.07%) QA
3 1 (0.29%) MiFID
3 1 (0.29%) PCI DSS
3 1 (0.29%) SLA
System Software
1 4 (1.16%) Active Directory
2 1 (0.29%) Apache Flume
Systems Management
1 4 (1.16%) Opscode Chef
1 4 (1.16%) Puppet
2 3 (0.87%) Control-M
2 3 (0.87%) HP Quality Center
Vendors
1 224 (64.74%) Microsoft
2 69 (19.94%) Tableau
3 15 (4.34%) Oracle
3 15 (4.34%) Siebel
4 10 (2.89%) Cognos
5 5 (1.45%) MicroStrategy
6 4 (1.16%) VMware
6 4 (1.16%) webMethods
7 3 (0.87%) Alteryx
7 3 (0.87%) HP
8 2 (0.58%) Aderant
8 2 (0.58%) Google
8 2 (0.58%) Hyperion
8 2 (0.58%) SAP
8 2 (0.58%) Tagetik
8 2 (0.58%) TIBCO
9 1 (0.29%) Databricks
9 1 (0.29%) IBM
9 1 (0.29%) Salesforce.com