Period
to 21 May 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 May 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 May 2018
Same period 2017 Same period 2016
Rank 280 284 310
Rank change year-on-year +4 +26 +25
Permanent jobs citing OLAP 62 58 81
As % of all permanent IT jobs advertised in the City of London 0.59% 0.57% 0.60%
As % of the Database & Business Intelligence category 1.86% 1.80% 2.09%
Number of salaries quoted 55 56 75
City of London median annual salary £65,000 £67,500 £57,500
Median salary % change year-on-year -3.70% +17.39% -8.00%
10th Percentile £42,500 £41,875 £47,500
90th Percentile £83,750 £76,250 £72,000
Central London median annual salary £65,000 £67,500 £57,500
% change year-on-year -3.70% +17.39% -8.00%

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,326 3,224 3,872
As % of all permanent IT jobs advertised in the City of London 31.42% 31.68% 28.51%
Number of salaries quoted 2,969 2,906 3,472
City of London median annual salary £62,500 £60,000 £55,000
Median salary % change year-on-year +4.17% +9.09% -
10th Percentile £41,250 £37,500 £36,500
90th Percentile £90,000 £87,500 £83,625
Central London median annual salary £62,500 £60,000 £55,000
% change year-on-year +4.17% +9.09% -

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

Salary histogram for OLAP in the City of London

For the 6 months to 21 May 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 48 (77.42%) ETL
2 44 (70.97%) SQL Server
3 42 (67.74%) Business Intelligence
4 41 (66.13%) SQL Server Integration Services
5 40 (64.52%) SQL
6 39 (62.90%) Data Warehouse
7 38 (61.29%) SQL Server Analysis Services
8 34 (54.84%) SQL Server Reporting Services
9 27 (43.55%) Power BI
10 26 (41.94%) MDX
11 25 (40.32%) OLTP
12 24 (38.71%) Microsoft
12 24 (38.71%) Finance
13 20 (32.26%) Analytics
13 20 (32.26%) Problem-Solving
14 19 (30.65%) Microsoft Azure
15 18 (29.03%) PowerShell
15 18 (29.03%) Snowflake Schema
15 18 (29.03%) Star Schema
15 18 (29.03%) SQL Optimisation
16 17 (27.42%) Azure SQL Database
16 17 (27.42%) Oracle
16 17 (27.42%) Oracle OLAP
17 16 (25.81%) Data Modelling
18 15 (24.19%) Kimball Methodology
18 15 (24.19%) Big Data
18 15 (24.19%) Fintech
19 14 (22.58%) Analytical Skills
19 14 (22.58%) Tableau
20 13 (20.97%) T-SQL

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 4 (6.45%) Apache
1 4 (6.45%) Apache Spark
2 2 (3.23%) SharePoint
Applications
1 5 (8.06%) Microsoft Excel
2 4 (6.45%) Microsoft Office
Business Applications
1 6 (9.68%) Cognos TM1
2 2 (3.23%) Cognos Planning
2 2 (3.23%) Dynamics CRM
2 2 (3.23%) HFM
Cloud Services
1 19 (30.65%) Microsoft Azure
Database & Business Intelligence
1 44 (70.97%) SQL Server
2 41 (66.13%) SQL Server Integration Services
3 39 (62.90%) Data Warehouse
4 38 (61.29%) SQL Server Analysis Services
5 34 (54.84%) SQL Server Reporting Services
6 27 (43.55%) Power BI
7 25 (40.32%) OLTP
8 18 (29.03%) Snowflake Schema
8 18 (29.03%) Star Schema
9 17 (27.42%) Azure SQL Database
9 17 (27.42%) Oracle OLAP
10 15 (24.19%) Big Data
11 13 (20.97%) OLAP Cube
12 12 (19.35%) SQL Server 2008
13 11 (17.74%) Relational Database
14 10 (16.13%) SQL Server 2012
15 9 (14.52%) SQL Server 2016
16 7 (11.29%) Essbase
16 7 (11.29%) NoSQL
16 7 (11.29%) QlikView
Development Applications
1 8 (12.90%) Git (software)
1 8 (12.90%) Team Foundation Server
2 7 (11.29%) Eclipse
2 7 (11.29%) JUnit
2 7 (11.29%) Maven
3 6 (9.68%) ERwin
4 4 (6.45%) ER Studio
5 2 (3.23%) LINQPad
6 1 (1.61%) SQL Server Management Studio (SSMS)
General
1 24 (38.71%) Finance
2 7 (11.29%) Banking
3 4 (6.45%) International Banking
4 2 (3.23%) Investment Banking
5 1 (1.61%) Front Office
5 1 (1.61%) General Ledger
5 1 (1.61%) Retail
Job Titles
1 33 (53.23%) Developer
2 20 (32.26%) Business Intelligence Developer
3 19 (30.65%) SQL Developer
4 17 (27.42%) SSIS Developer
4 17 (27.42%) SSRS Developer
5 14 (22.58%) Architect
6 13 (20.97%) Data Architect
6 13 (20.97%) SQL BI Developer
6 13 (20.97%) SQL Server BI Developer
6 13 (20.97%) SQL Server Developer
7 12 (19.35%) Consultant
8 10 (16.13%) ETL Developer
8 10 (16.13%) OLAP Developer
8 10 (16.13%) SSAS Developer
8 10 (16.13%) T-SQL Developer
9 8 (12.90%) Business Intelligence Consultant
9 8 (12.90%) Database Developer
9 8 (12.90%) SQL Database Developer
10 7 (11.29%) Java Developer
10 7 (11.29%) Java Developer - Fintech
Libraries, Frameworks & Software Standards
1 26 (41.94%) MDX
2 7 (11.29%) REST
2 7 (11.29%) SOAP
2 7 (11.29%) Spring
3 2 (3.23%) LINQ
4 1 (1.61%) .NET
Miscellaneous
1 15 (24.19%) Fintech
2 14 (22.58%) Analytical Skills
3 9 (14.52%) Self-Motivation
3 9 (14.52%) Virtual Team
4 3 (4.84%) Hedge funds
4 3 (4.84%) Reference Data
4 3 (4.84%) Tandem
5 2 (3.23%) Greenfield Project
5 2 (3.23%) Hybrid Cloud
5 2 (3.23%) Taxonomies
6 1 (1.61%) Derivative
6 1 (1.61%) Fixed Income
6 1 (1.61%) Management Information System
Operating Systems
1 5 (8.06%) Linux
2 2 (3.23%) Windows
2 2 (3.23%) Windows Server 2008
2 2 (3.23%) Windows Server 2012
3 1 (1.61%) Unix
Processes & Methodologies
1 48 (77.42%) ETL
2 42 (67.74%) Business Intelligence
3 20 (32.26%) Analytics
3 20 (32.26%) Problem-Solving
4 18 (29.03%) SQL Optimisation
5 16 (25.81%) Data Modelling
6 15 (24.19%) Kimball Methodology
7 11 (17.74%) Agile Software Development
7 11 (17.74%) Data Integration
8 10 (16.13%) SDLC
9 9 (14.52%) Release Management
9 9 (14.52%) Visualisation
10 8 (12.90%) Data Architecture
11 7 (11.29%) Data Strategy
11 7 (11.29%) Performance Tuning
12 6 (9.68%) Data Management
12 6 (9.68%) Mentoring
13 5 (8.06%) CRM
13 5 (8.06%) Master Data Management
13 5 (8.06%) Metadata Management
Programming Languages
1 40 (64.52%) SQL
2 18 (29.03%) PowerShell
3 13 (20.97%) T-SQL
4 12 (19.35%) Java
5 5 (8.06%) Python
6 4 (6.45%) C#
6 4 (6.45%) PL/SQL
7 1 (1.61%) Perl
7 1 (1.61%) Shell Script
7 1 (1.61%) VB
7 1 (1.61%) VB6
7 1 (1.61%) VBA
Qualifications
1 5 (8.06%) Degree
2 3 (4.84%) MBA
Quality Assurance & Compliance
1 7 (11.29%) Data Quality
2 1 (1.61%) SLA
System Software
1 2 (3.23%) Virtual Machines
Vendors
1 24 (38.71%) Microsoft
2 17 (27.42%) Oracle
3 14 (22.58%) Tableau
4 7 (11.29%) Cognos
5 6 (9.68%) Hyperion
5 6 (9.68%) Tagetik
6 4 (6.45%) Informatica
6 4 (6.45%) MicroStrategy
6 4 (6.45%) SAP
7 2 (3.23%) TIBCO
8 1 (1.61%) IBM
8 1 (1.61%) Salesforce.com
8 1 (1.61%) Sybase