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 June 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 Jun 2017
Same period 2016 Same period 2015
Rank 196 219 255
Rank change year-on-year +23 +36  
Permanent jobs citing OLAP 31 36 60
As % of all permanent IT jobs advertised in the City of London 0.60% 0.57% 0.59%
As % of the Database & Business Intelligence category 1.94% 2.06% 2.00%
Number of salaries quoted 30 33 56
Median salary £67,500 £62,500 £60,000
Median salary % change year-on-year +8.00% +4.16%  
90% offered a salary of more than £40,000 £55,500 £46,250
10% offered a salary of more than £76,000 £82,000 £68,750
UK excluding London median salary £42,500 £47,500 £40,000
% change year-on-year -10.52% +18.75%  

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 1602 1746 3001
As % of all permanent IT job vacancies advertised in the City of London 31.17% 27.41% 29.50%
Number of salaries quoted 1420 1572 2605
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.34% -  
90% offered a salary of more than £41,000 £40,000 £40,000
10% offered a salary of more than £77,500 £77,500 £80,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

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 June 2017.

Salary histogram for OLAP in the City of London

For the 6 months to 28 June 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 54 (90.00%) Business Intelligence
2 48 (80.00%) SQL Server
3 45 (75.00%) SQL
3 45 (75.00%) Data Warehouse
3 45 (75.00%) SQL Server Integration Services
3 45 (75.00%) SQL Server Analysis Services
4 44 (73.33%) ETL
5 43 (71.67%) Microsoft
6 36 (60.00%) OLAP Cube
7 31 (51.67%) Data Modelling
8 30 (50.00%) Power BI
9 29 (48.33%) Tableau
10 25 (41.67%) SSDT
10 25 (41.67%) PowerDesigner
10 25 (41.67%) MS Visio
10 25 (41.67%) Sybase
11 24 (40.00%) Regression Testing
11 24 (40.00%) SQL Server Reporting Services
12 22 (36.67%) Data Visualisation
12 22 (36.67%) Visualisation
13 15 (25.00%) MDX
14 13 (21.67%) T-SQL
15 11 (18.33%) Agile Software Development
15 11 (18.33%) SQL Server 2008
15 11 (18.33%) SQL Server 2012
16 10 (16.67%) SQL Server 2014
16 10 (16.67%) QlikView
16 10 (16.67%) SAP
17 9 (15.00%) BusinessObjects
17 9 (15.00%) Cognos

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 2 (3.33%) SharePoint
1 2 (3.33%) SharePoint 2013
2 1 (1.67%) GemFire
Applications
1 25 (41.67%) MS Visio
2 3 (5.00%) Microsoft Excel
Business Applications
1 6 (10.00%) Cognos Business Intelligence
2 2 (3.33%) Cognos TM1
3 1 (1.67%) Hyperion Planning
3 1 (1.67%) ION MarketView
3 1 (1.67%) SAP BPC
Cloud Services
1 3 (5.00%) Microsoft Azure
Communications & Networking
1 5 (8.33%) SAN
2 1 (1.67%) FTP
2 1 (1.67%) HTTP
2 1 (1.67%) LAN
2 1 (1.67%) NAS
2 1 (1.67%) WAN
Database & Business Intelligence
1 48 (80.00%) SQL Server
2 45 (75.00%) Data Warehouse
2 45 (75.00%) SQL Server Analysis Services
2 45 (75.00%) SQL Server Integration Services
3 36 (60.00%) OLAP Cube
4 30 (50.00%) Power BI
5 25 (41.67%) SSDT
6 24 (40.00%) SQL Server Reporting Services
7 11 (18.33%) SQL Server 2008
7 11 (18.33%) SQL Server 2012
8 10 (16.67%) QlikView
8 10 (16.67%) SQL Server 2014
9 9 (15.00%) BusinessObjects
10 8 (13.33%) BusinessObjects Web Intelligence
10 8 (13.33%) Microsoft Analysis Services
11 7 (11.67%) Crystal Reports
12 6 (10.00%) Oracle OLAP
12 6 (10.00%) Pentaho
13 5 (8.33%) Oracle BI EE
13 5 (8.33%) Yellowfin
Development Applications
1 25 (41.67%) PowerDesigner
2 5 (8.33%) Team Foundation Server
3 3 (5.00%) Visual Studio
4 1 (1.67%) Eclipse
4 1 (1.67%) Git (software)
General
1 7 (11.67%) Finance
2 3 (5.00%) Banking
3 2 (3.33%) Front Office
3 2 (3.33%) Investment Banking
3 2 (3.33%) Legal
4 1 (1.67%) Advertising
4 1 (1.67%) Back Office
4 1 (1.67%) Law
4 1 (1.67%) Marketing
Job Titles
1 42 (70.00%) Developer
2 37 (61.67%) Business Intelligence Developer
3 30 (50.00%) Senior Developer
4 28 (46.67%) Senior Business Intelligence Developer
5 25 (41.67%) OLAP Developer
5 25 (41.67%) SSAS Developer
6 24 (40.00%) Senior OLAP Developer
6 24 (40.00%) Tableau Developer
7 21 (35.00%) Data Visualisation Developer
8 10 (16.67%) Analyst
8 10 (16.67%) Business Intelligence Analyst
9 6 (10.00%) Business Intelligence Support Analyst
9 6 (10.00%) DBA
9 6 (10.00%) Support Analyst
10 5 (8.33%) Business Support Analyst
10 5 (8.33%) SQL DBA
10 5 (8.33%) SQL Server DBA
11 4 (6.67%) Data Warehouse Developer
12 3 (5.00%) SQL Developer
12 3 (5.00%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 15 (25.00%) MDX
2 7 (11.67%) .NET
3 4 (6.67%) HTML
4 3 (5.00%) HTML5
5 2 (3.33%) .NET Framework
5 2 (3.33%) XML
6 1 (1.67%) ASP.NET
6 1 (1.67%) CSS
6 1 (1.67%) Node.js
6 1 (1.67%) Spring
6 1 (1.67%) XSD
6 1 (1.67%) XSLT
Miscellaneous
1 4 (6.67%) Clustering
2 2 (3.33%) Social Media
3 1 (1.67%) Credit Risk
3 1 (1.67%) Data Structures
3 1 (1.67%) Fintech
3 1 (1.67%) Fixed Income
3 1 (1.67%) Foreign Exchange (FX)
3 1 (1.67%) Greenfield Project
3 1 (1.67%) Management Information System
3 1 (1.67%) Market Risk
3 1 (1.67%) Reinsurance
Operating Systems
1 4 (6.67%) Windows
1 4 (6.67%) Windows Server
1 4 (6.67%) Windows Server 2008
1 4 (6.67%) Windows Server 2012
2 1 (1.67%) Linux
Processes & Methodologies
1 54 (90.00%) Business Intelligence
2 44 (73.33%) ETL
3 31 (51.67%) Data Modelling
4 24 (40.00%) Regression Testing
5 22 (36.67%) Data Visualisation
5 22 (36.67%) Visualisation
6 11 (18.33%) Agile Software Development
7 9 (15.00%) Analytics
8 8 (13.33%) ITIL
9 6 (10.00%) Scrum
9 6 (10.00%) User Acceptance Testing
10 5 (8.33%) Kimball Methodology
11 4 (6.67%) Capacity Planning
11 4 (6.67%) Database Mirroring
11 4 (6.67%) Disaster Recovery
11 4 (6.67%) Information Security
11 4 (6.67%) Performance Tuning
11 4 (6.67%) Root Cause Analysis
11 4 (6.67%) Security Patching
11 4 (6.67%) Service Management
Programming Languages
1 45 (75.00%) SQL
2 13 (21.67%) T-SQL
3 7 (11.67%) C#
4 5 (8.33%) Data Analysis Expressions (DAX)
4 5 (8.33%) PowerShell
5 4 (6.67%) Java
6 2 (3.33%) JavaScript
6 2 (3.33%) PHP
6 2 (3.33%) VB.NET
6 2 (3.33%) VBA
7 1 (1.67%) C
7 1 (1.67%) Data Mining Extensions (DMX)
7 1 (1.67%) PL/SQL
7 1 (1.67%) XMLA
Qualifications
1 7 (11.67%) Degree
2 3 (5.00%) ITIL Certification
Quality Assurance & Compliance
1 4 (6.67%) QA
2 1 (1.67%) SLA
Vendors
1 43 (71.67%) Microsoft
2 29 (48.33%) Tableau
3 25 (41.67%) Sybase
4 10 (16.67%) SAP
5 9 (15.00%) Cognos
6 7 (11.67%) MicroStrategy
7 6 (10.00%) Hyperion
7 6 (10.00%) Oracle
8 5 (8.33%) Informatica
8 5 (8.33%) TIBCO
9 1 (1.67%) Alteryx
9 1 (1.67%) Greenplum
9 1 (1.67%) IBM
9 1 (1.67%) Infor
9 1 (1.67%) ION Trading
9 1 (1.67%) Tagetik
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 5 hours ago
City, London
I.T. Skillfinder
Salary: From £65,000 to £70,000 per annum Benefits
Posted: Yesterday
City, London
Charles Taylor plc
Salary: Market related
Posted: 13 days ago