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 OLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLAP over the 6 months to 21 February 2018 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
Central London > City of London
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 287 301 290
Rank change year-on-year +14 -11 +33
Permanent jobs citing OLAP 55 40 90
As % of all permanent IT jobs advertised in the City of London 0.51% 0.38% 0.65%
As % of the Database & Business Intelligence category 1.67% 1.21% 2.12%
Number of salaries quoted 45 37 86
City of London median annual salary £60,000 £62,500 £57,500
Median salary % change year-on-year -4.00% +8.70% -8.00%
10th Percentile £42,500 £42,000 £47,500
90th Percentile £77,500 £76,250 £69,000
Central London median annual salary £55,000 £66,000 £57,500
% change year-on-year -16.67% +14.78% -11.54%

OLAP 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%

OLAP
Job Vacancy Trend in the City of London

Job postings citing OLAP as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for OLAP in the City of London

OLAP
Salary Trend in the City of London

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

Salary trend for OLAP in the City of London

OLAP
Salary Histogram in the City of London

The salary distribution of IT jobs citing OLAP in the City of London over the 6 months to 21 February 2018.

Salary histogram for OLAP in the City of London

For the 6 months to 21 February 2018, IT jobs citing OLAP 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 OLAP.

1 35 (63.64%) ETL
2 34 (61.82%) Business Intelligence
3 33 (60.00%) SQL Server
4 32 (58.18%) SQL Server Integration Services
5 31 (56.36%) SQL Server Reporting Services
6 30 (54.55%) SQL Server Analysis Services
7 29 (52.73%) SQL
7 29 (52.73%) Data Warehouse
8 27 (49.09%) MDX
9 24 (43.64%) Finance
10 20 (36.36%) Power BI
11 18 (32.73%) Kimball Methodology
11 18 (32.73%) Microsoft
12 17 (30.91%) Fintech
13 15 (27.27%) T-SQL
13 15 (27.27%) Java
13 15 (27.27%) Big Data
14 13 (23.64%) OLTP
14 13 (23.64%) PowerShell
15 12 (21.82%) Tableau
15 12 (21.82%) Data Modelling
16 11 (20.00%) Eclipse
16 11 (20.00%) JUnit
16 11 (20.00%) Star Schema
16 11 (20.00%) Spring
16 11 (20.00%) Maven
16 11 (20.00%) Microsoft Azure
16 11 (20.00%) QlikView
17 10 (18.18%) OLAP Cube
17 10 (18.18%) Azure SQL Database

OLAP
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 3 (5.45%) Apache
1 3 (5.45%) Apache Spark
1 3 (5.45%) SharePoint
2 1 (1.82%) SAS
Applications
1 4 (7.27%) Microsoft Excel
2 3 (5.45%) Microsoft Office
3 1 (1.82%) MS Visio
Business Applications
1 6 (10.91%) Cognos TM1
2 3 (5.45%) Cognos Planning
2 3 (5.45%) HFM
3 2 (3.64%) Dynamics CRM
4 1 (1.82%) Oracle Applications
Cloud Services
1 11 (20.00%) Microsoft Azure
2 1 (1.82%) Amazon AWS
Database & Business Intelligence
1 33 (60.00%) SQL Server
2 32 (58.18%) SQL Server Integration Services
3 31 (56.36%) SQL Server Reporting Services
4 30 (54.55%) SQL Server Analysis Services
5 29 (52.73%) Data Warehouse
6 20 (36.36%) Power BI
7 15 (27.27%) Big Data
8 13 (23.64%) OLTP
9 11 (20.00%) QlikView
9 11 (20.00%) Star Schema
10 10 (18.18%) Azure SQL Database
10 10 (18.18%) OLAP Cube
11 9 (16.36%) Oracle OLAP
11 9 (16.36%) Snowflake Schema
11 9 (16.36%) SQL Server 2008
12 7 (12.73%) NoSQL
12 7 (12.73%) SQL Server 2012
13 6 (10.91%) Essbase
13 6 (10.91%) Relational Database
14 5 (9.09%) SQL Server 2016
Development Applications
1 11 (20.00%) Eclipse
1 11 (20.00%) JUnit
1 11 (20.00%) Maven
2 6 (10.91%) Team Foundation Server
3 5 (9.09%) Git (software)
4 3 (5.45%) ERwin
5 2 (3.64%) LINQPad
6 1 (1.82%) SQL Server Management Studio (SSMS)
6 1 (1.82%) TeamCity
6 1 (1.82%) Toad
6 1 (1.82%) Visual Studio
General
1 24 (43.64%) Finance
2 6 (10.91%) Banking
3 2 (3.64%) Investment Banking
3 2 (3.64%) Retail
4 1 (1.82%) Advertising
4 1 (1.82%) Front Office
4 1 (1.82%) International Banking
Job Titles
1 34 (61.82%) Developer
2 16 (29.09%) Business Intelligence Developer
3 14 (25.45%) SQL Developer
4 13 (23.64%) Consultant
5 11 (20.00%) Java Developer
5 11 (20.00%) SSIS Developer
5 11 (20.00%) SSRS Developer
6 8 (14.55%) Architect
6 8 (14.55%) SQL BI Developer
6 8 (14.55%) SQL Server BI Developer
6 8 (14.55%) SQL Server Developer
6 8 (14.55%) T-SQL Developer
7 7 (12.73%) Business Intelligence Consultant
7 7 (12.73%) Data Architect
7 7 (12.73%) ETL Developer
7 7 (12.73%) OLAP Developer
7 7 (12.73%) SSAS Developer
8 6 (10.91%) Java Consultant
9 5 (9.09%) Database Developer
10 4 (7.27%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 27 (49.09%) MDX
2 11 (20.00%) Spring
3 5 (9.09%) REST
3 5 (9.09%) SOAP
4 2 (3.64%) LINQ
5 1 (1.82%) .NET
5 1 (1.82%) Web Services
5 1 (1.82%) WSDL
5 1 (1.82%) XML
5 1 (1.82%) XML Messaging
5 1 (1.82%) XSD
Miscellaneous
1 17 (30.91%) Fintech
2 9 (16.36%) Analytical Skills
3 6 (10.91%) Virtual Team
4 4 (7.27%) Hedge funds
5 2 (3.64%) Hybrid Cloud
5 2 (3.64%) Taxonomies
6 1 (1.82%) Derivative
6 1 (1.82%) Fixed Income
6 1 (1.82%) Market Risk
Operating Systems
1 5 (9.09%) Linux
2 3 (5.45%) Windows
3 2 (3.64%) Windows Server 2008
3 2 (3.64%) Windows Server 2012
4 1 (1.82%) Unix
Processes & Methodologies
1 35 (63.64%) ETL
2 34 (61.82%) Business Intelligence
3 18 (32.73%) Kimball Methodology
4 12 (21.82%) Data Modelling
5 10 (18.18%) Analytics
6 8 (14.55%) Agile Software Development
6 8 (14.55%) SQL Optimisation
7 7 (12.73%) Data Architecture
7 7 (12.73%) SDLC
8 6 (10.91%) Visualisation
9 5 (9.09%) Asset Management
9 5 (9.09%) CRM
9 5 (9.09%) Data Integration
9 5 (9.09%) Data Management
9 5 (9.09%) Performance Tuning
9 5 (9.09%) Release Management
10 4 (7.27%) Data Strategy
10 4 (7.27%) Dimensional Modelling
10 4 (7.27%) Master Data Management
10 4 (7.27%) Metadata Management
Programming Languages
1 29 (52.73%) SQL
2 15 (27.27%) Java
2 15 (27.27%) T-SQL
3 13 (23.64%) PowerShell
4 5 (9.09%) C#
5 4 (7.27%) PL/SQL
5 4 (7.27%) Python
6 1 (1.82%) C
6 1 (1.82%) Data Analysis Expressions (DAX)
6 1 (1.82%) Perl
6 1 (1.82%) SAS Macro
6 1 (1.82%) Shell Script
6 1 (1.82%) VB
6 1 (1.82%) VB6
6 1 (1.82%) VBA
Qualifications
1 5 (9.09%) Degree
2 2 (3.64%) MBA
3 1 (1.82%) OCP
3 1 (1.82%) Oracle Certification
Quality Assurance & Compliance
1 4 (7.27%) Data Quality
System Software
1 2 (3.64%) Virtual Machines
Vendors
1 18 (32.73%) Microsoft
2 12 (21.82%) Tableau
3 9 (16.36%) Oracle
4 7 (12.73%) Cognos
5 6 (10.91%) Hyperion
5 6 (10.91%) Tagetik
6 3 (5.45%) MicroStrategy
6 3 (5.45%) SAP
6 3 (5.45%) TIBCO
7 1 (1.82%) Callidus
7 1 (1.82%) Guidewire
7 1 (1.82%) Informatica
7 1 (1.82%) Salesforce.com
7 1 (1.82%) Sybase