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 3 months to 28 March 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
London / City of London
3 months to
28 Mar 2017
Same period 2016 Same period 2015
Rank 203 230 258
Rank change year-on-year +27 +28  
Permanent jobs citing OLAP 29 39 63
As % of all permanent IT jobs advertised in the City of London 0.57% 0.55% 0.60%
As % of the Database & Business Intelligence category 1.75% 1.91% 2.18%
Number of salaries quoted 28 36 59
Median salary £62,500 £57,500 £67,500
Median salary % change year-on-year +8.69% -14.81%  
90% offered a salary of more than £40,250 £50,000 £51,500
10% offered a salary of more than £70,000 £63,750 £75,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year - +5.88%  

OLAP is in the database and business intelligence skills category. The next 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 and business intelligence skills.

Database & Business Intelligence Skills
City of London
Permanent job vacancies with a requirement for database and business intelligence skills 1657 2042 2895
As % of all permanent IT job vacancies advertised in the City of London 32.32% 28.60% 27.74%
Number of salaries quoted 1507 1814 2538
Median salary £62,500 £55,000 £55,000
Median salary % change year-on-year +13.63% -  
90% offered a salary of more than £40,000 £40,000 £38,674
10% offered a salary of more than £80,000 £75,000 £75,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

OLAP
Job Vacancy Trend in the City of London

The job posting trend of jobs advertised in the City of London citing OLAP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 28 March 2017.

Salary histogram for OLAP in the City of London

OLAP
Top 30 Co-occurring IT Skills in the City of London

For the 6 months to 28 March 2017, IT jobs citing OLAP 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 OLAP.

1 37 (88.10%) Business Intelligence
2 33 (78.57%) SQL Server Analysis Services
3 32 (76.19%) SQL Server Integration Services
4 31 (73.81%) SQL
4 31 (73.81%) SQL Server
5 27 (64.29%) SQL Server Reporting Services
6 26 (61.90%) Microsoft
7 23 (54.76%) ETL
8 21 (50.00%) OLAP Cube
9 20 (47.62%) Data Warehouse
10 17 (40.48%) Data Modelling
10 17 (40.48%) Tableau
11 16 (38.10%) Power BI
12 14 (33.33%) SQL Server 2012
13 12 (28.57%) T-SQL
14 10 (23.81%) .NET
14 10 (23.81%) MS Excel
14 10 (23.81%) MDX
14 10 (23.81%) SQL Server 2008
15 9 (21.43%) MS Visio
15 9 (21.43%) Sybase
15 9 (21.43%) Regression Testing
15 9 (21.43%) PowerDesigner
15 9 (21.43%) SSDT
16 8 (19.05%) C#
16 8 (19.05%) Degree
17 7 (16.67%) QlikView
17 7 (16.67%) Analytics
17 7 (16.67%) Data Analysis Expressions (DAX)
18 6 (14.29%) Data Visualisation

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 (7.14%) SharePoint
2 2 (4.76%) SharePoint 2013
Applications
1 10 (23.81%) MS Excel
2 9 (21.43%) MS Visio
Business Applications
1 2 (4.76%) Cognos Business Intelligence
1 2 (4.76%) Cognos TM1
2 1 (2.38%) Hyperion Planning
2 1 (2.38%) SAP BPC
Cloud Services
1 6 (14.29%) Microsoft Azure
Communications & Networking
1 5 (11.90%) SAN
2 1 (2.38%) FTP
2 1 (2.38%) HTTP
2 1 (2.38%) LAN
2 1 (2.38%) NAS
2 1 (2.38%) WAN
Database & Business Intelligence
1 33 (78.57%) SQL Server Analysis Services
2 32 (76.19%) SQL Server Integration Services
3 31 (73.81%) SQL Server
4 27 (64.29%) SQL Server Reporting Services
5 21 (50.00%) OLAP Cube
6 20 (47.62%) Data Warehouse
7 16 (38.10%) Power BI
8 14 (33.33%) SQL Server 2012
9 10 (23.81%) SQL Server 2008
10 9 (21.43%) SSDT
11 7 (16.67%) QlikView
12 6 (14.29%) Microsoft Analysis Services
12 6 (14.29%) OLTP
12 6 (14.29%) SQL Server 2014
12 6 (14.29%) SQL Server 2016
13 5 (11.90%) Azure SQL Database
13 5 (11.90%) Relational Database
14 4 (9.52%) Big Data
15 3 (7.14%) HBase
15 3 (7.14%) Voldemort
Development Applications
1 9 (21.43%) PowerDesigner
2 5 (11.90%) Team Foundation Server
3 1 (2.38%) Eclipse
3 1 (2.38%) Visual Studio
General
1 5 (11.90%) Legal
2 4 (9.52%) Finance
3 2 (4.76%) Banking
4 1 (2.38%) Advertising
4 1 (2.38%) Marketing
Job Titles
1 28 (66.67%) Developer
2 22 (52.38%) Business Intelligence Developer
3 15 (35.71%) Senior Developer
4 13 (30.95%) Senior Business Intelligence Developer
5 12 (28.57%) OLAP Developer
6 11 (26.19%) SSAS Developer
7 9 (21.43%) Senior OLAP Developer
7 9 (21.43%) Tableau Developer
8 5 (11.90%) DBA
8 5 (11.90%) SQL DBA
8 5 (11.90%) SQL Server DBA
9 4 (9.52%) Analyst
9 4 (9.52%) Business Developer
9 4 (9.52%) Business Intelligence Consultant
9 4 (9.52%) Consultant
9 4 (9.52%) Data Warehouse Developer
9 4 (9.52%) Microsoft BI Consultant
9 4 (9.52%) Senior Data Warehouse Developer
10 3 (7.14%) Big Data Developer
10 3 (7.14%) Microsoft BI Developer
Libraries, Frameworks & Software Standards
1 10 (23.81%) .NET
1 10 (23.81%) MDX
2 3 (7.14%) HTML
2 3 (7.14%) Spring
3 2 (4.76%) .NET Framework
3 2 (4.76%) HTML5
4 1 (2.38%) ASP.NET
4 1 (2.38%) CSS
4 1 (2.38%) XML
Miscellaneous
1 4 (9.52%) Clustering
2 3 (7.14%) Fintech
3 2 (4.76%) Social Media
4 1 (2.38%) Analytical Skills
4 1 (2.38%) Computer Science
4 1 (2.38%) Data Structures
4 1 (2.38%) Replication
Operating Systems
1 4 (9.52%) Windows
1 4 (9.52%) Windows Server
1 4 (9.52%) Windows Server 2008
1 4 (9.52%) Windows Server 2012
2 3 (7.14%) Linux
Processes & Methodologies
1 37 (88.10%) Business Intelligence
2 23 (54.76%) ETL
3 17 (40.48%) Data Modelling
4 9 (21.43%) Regression Testing
5 7 (16.67%) Analytics
6 6 (14.29%) Data Visualisation
6 6 (14.29%) Kimball Methodology
6 6 (14.29%) Visualisation
7 5 (11.90%) Agile Software Development
7 5 (11.90%) Disaster Recovery
7 5 (11.90%) ITIL
7 5 (11.90%) Presales
8 4 (9.52%) Capacity Planning
8 4 (9.52%) Database Mirroring
8 4 (9.52%) Information Security
8 4 (9.52%) Performance Tuning
8 4 (9.52%) Root Cause Analysis
8 4 (9.52%) Security Patching
8 4 (9.52%) Service Management
8 4 (9.52%) User Acceptance Testing
Programming Languages
1 31 (73.81%) SQL
2 12 (28.57%) T-SQL
3 8 (19.05%) C#
4 7 (16.67%) Data Analysis Expressions (DAX)
5 4 (9.52%) Java
5 4 (9.52%) PowerShell
6 3 (7.14%) VBA
7 2 (4.76%) PHP
7 2 (4.76%) VB.NET
8 1 (2.38%) Data Mining Extensions (DMX)
8 1 (2.38%) JavaScript
8 1 (2.38%) XMLA
Qualifications
1 8 (19.05%) Degree
2 2 (4.76%) Microsoft Certification
3 1 (2.38%) MCSE
Quality Assurance & Compliance
1 5 (11.90%) QA
2 1 (2.38%) SLA
Vendors
1 26 (61.90%) Microsoft
2 17 (40.48%) Tableau
3 9 (21.43%) Sybase
4 4 (9.52%) Cognos
5 3 (7.14%) Greenplum
5 3 (7.14%) MicroStrategy
6 2 (4.76%) Hyperion
6 2 (4.76%) Oracle
6 2 (4.76%) SAP
7 1 (2.38%) Alteryx
7 1 (2.38%) IBM
7 1 (2.38%) Infor
7 1 (2.38%) Informatica
7 1 (2.38%) TIBCO
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: Yesterday
City, London
The Datawarehousing Company
Salary: £65,000 per annum + pension, medical, dental, critical illness, childc
Posted: 6 days ago
City of London
Lawrence Harvey
Salary: £600 - £700 per annum
Posted: 8 days ago
City of London
Huxley
Salary: competitive
Posted: 11 days ago
City of London
Lawrence Harvey
Salary: £50000.00 - £65000.00 per annum
Posted: 20 days ago