The following table provides summary statistics for permanent job vacancies advertised in 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 30 March 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
England / London
3 months to
30 Mar 2017
Same period 2016 Same period 2015
Rank 464 479 378
Rank change year-on-year +15 -101  
Permanent jobs citing OLAP 123 172 287
As % of all permanent IT jobs advertised in London 0.36% 0.40% 0.67%
As % of the Database & Business Intelligence category 1.20% 1.29% 2.20%
Number of salaries quoted 109 132 239
Median salary £60,000 £57,500 £62,500
Median salary % change year-on-year +4.34% -8.00%  
90% offered a salary of more than £45,000 £45,000 £45,000
10% offered a salary of more than £70,000 £75,000 £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 London with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
London
Permanent job vacancies with a requirement for database and business intelligence skills 10266 13298 13060
As % of all permanent IT job vacancies advertised in London 30.30% 31.28% 30.47%
Number of salaries quoted 8907 11620 11222
Median salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.34% +4.54%  
90% offered a salary of more than £40,000 £40,000 £38,000
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

OLAP
Job Vacancy Trend in London

The job posting trend of jobs advertised in 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 London

OLAP
Salary Trend in London

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

Salary trend for OLAP in London

OLAP
Salary Histogram in London

The salary distribution of IT jobs citing OLAP in London over the 3 months to 30 March 2017.

Salary histogram for OLAP in London

OLAP
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the London region over the 3 months to 30 March 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +23 29 £62,500 +8.69% 5
Brentford +2 1 £60,000 -4.00%
OLAP
England

For the 6 months to 30 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 London region with a requirement for OLAP.

1 179 (79.56%) SQL
2 156 (69.33%) Data Warehouse
3 154 (68.44%) Business Intelligence
4 139 (61.78%) SQL Server
5 124 (55.11%) SQL Server Analysis Services
6 113 (50.22%) ETL
6 113 (50.22%) SQL Server Integration Services
7 99 (44.00%) SQL Server Reporting Services
8 82 (36.44%) Microsoft
9 74 (32.89%) Finance
10 72 (32.00%) T-SQL
11 70 (31.11%) OLAP Cube
12 60 (26.67%) Data Modelling
12 60 (26.67%) Agile Software Development
13 53 (23.56%) Kimball Methodology
14 51 (22.67%) Analytics
15 49 (21.78%) Relational Database
15 49 (21.78%) MS Excel
16 47 (20.89%) SQL Server 2012
16 47 (20.89%) Dimensional Modelling
17 46 (20.44%) Power BI
17 46 (20.44%) Oracle
17 46 (20.44%) Oracle OLAP
18 40 (17.78%) .NET
19 38 (16.89%) Tableau
20 36 (16.00%) MDX
21 34 (15.11%) OLTP
22 32 (14.22%) Big Data
22 32 (14.22%) Performance Tuning
23 31 (13.78%) C#

OLAP
Co-occurring IT Skills in 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 22 (9.78%) Apache
2 19 (8.44%) Apache Spark
3 12 (5.33%) SharePoint
3 12 (5.33%) Tomcat
3 12 (5.33%) WebSphere
4 11 (4.89%) Apache Airflow
4 11 (4.89%) Elasticsearch
5 10 (4.44%) IIS
5 10 (4.44%) Oracle Coherence
5 10 (4.44%) Oracle HTTP Server
6 4 (1.78%) SAS
6 4 (1.78%) SharePoint 2013
7 2 (0.89%) Apache Solr
8 1 (0.44%) Apache Pig
Applications
1 49 (21.78%) MS Excel
2 9 (4.00%) MS Visio
3 4 (1.78%) MS Office
4 1 (0.44%) MS PowerPoint
4 1 (0.44%) SPSS
Business Applications
1 13 (5.78%) Cognos TM1
2 5 (2.22%) Infor SunSystems
3 3 (1.33%) Cognos Business Intelligence
4 2 (0.89%) Adobe Campaign
4 2 (0.89%) Dynamics CRM
4 2 (0.89%) Eloqua
4 2 (0.89%) Hyperion Planning
4 2 (0.89%) SAP BPC
4 2 (0.89%) Unica
Cloud Services
1 26 (11.56%) Microsoft Azure
2 11 (4.89%) Amazon AWS
2 11 (4.89%) Amazon Kinesis
3 5 (2.22%) Azure Machine Learning
3 5 (2.22%) Data Lake Analytics
4 3 (1.33%) IaaS
4 3 (1.33%) SaaS
5 2 (0.89%) Responsys
6 1 (0.44%) Adobe Analytics
6 1 (0.44%) Google Analytics
6 1 (0.44%) Google Cloud Platform
Communications & Networking
1 18 (8.00%) SAN
2 13 (5.78%) NAS
3 11 (4.89%) HTTP
3 11 (4.89%) LAN
3 11 (4.89%) WAN
4 10 (4.44%) FCoE
4 10 (4.44%) Fibre Channel
4 10 (4.44%) iSCSI
4 10 (4.44%) Multicast
5 3 (1.33%) Internet
5 3 (1.33%) SSL
6 1 (0.44%) FTP
Database & Business Intelligence
1 156 (69.33%) Data Warehouse
2 139 (61.78%) SQL Server
3 124 (55.11%) SQL Server Analysis Services
4 113 (50.22%) SQL Server Integration Services
5 99 (44.00%) SQL Server Reporting Services
6 70 (31.11%) OLAP Cube
7 49 (21.78%) Relational Database
8 47 (20.89%) SQL Server 2012
9 46 (20.44%) Oracle OLAP
9 46 (20.44%) Power BI
10 34 (15.11%) OLTP
11 32 (14.22%) Big Data
12 27 (12.00%) MySQL
13 25 (11.11%) QlikView
13 25 (11.11%) RDBMS
13 25 (11.11%) SQL Server 2016
14 23 (10.22%) Hadoop
14 23 (10.22%) Microsoft Analysis Services
15 22 (9.78%) SQL Server 2014
16 21 (9.33%) DB2
Development Applications
1 9 (4.00%) PowerDesigner
2 8 (3.56%) Eclipse
3 7 (3.11%) Visual Studio
4 6 (2.67%) JIRA
5 5 (2.22%) Team Foundation Server
6 3 (1.33%) Maven
7 2 (0.89%) JUnit
7 2 (0.89%) Oracle Forms
8 1 (0.44%) ERwin
8 1 (0.44%) Git (software)
8 1 (0.44%) MagicDraw
General
1 74 (32.89%) Finance
2 22 (9.78%) Banking
2 22 (9.78%) Marketing
3 15 (6.67%) Legal
4 13 (5.78%) Investment Banking
5 9 (4.00%) Advertising
5 9 (4.00%) Financial Institution
6 5 (2.22%) Games
7 4 (1.78%) Automotive
7 4 (1.78%) German Language
7 4 (1.78%) Retail
7 4 (1.78%) Spanish Language
8 3 (1.33%) Music Industry
8 3 (1.33%) Telecoms
9 2 (0.89%) French Language
10 1 (0.44%) Front Office
10 1 (0.44%) Local Government
10 1 (0.44%) Wholesale Banking
Job Titles
1 109 (48.44%) Developer
2 56 (24.89%) Business Intelligence Developer
3 39 (17.33%) Senior Developer
4 35 (15.56%) SQL Developer
5 30 (13.33%) Analyst
6 29 (12.89%) SSAS Developer
7 23 (10.22%) OLAP Developer
7 23 (10.22%) SSRS Developer
8 21 (9.33%) Data Warehouse Developer
8 21 (9.33%) Senior Business Intelligence Developer
9 20 (8.89%) Business Intelligence Analyst
9 20 (8.89%) Consultant
9 20 (8.89%) SSIS Developer
10 19 (8.44%) Architect
11 17 (7.56%) SQL Server Developer
12 16 (7.11%) DBA
13 15 (6.67%) Business Intelligence Consultant
14 14 (6.22%) Data Engineer
15 13 (5.78%) Business Developer
15 13 (5.78%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 40 (17.78%) .NET
2 36 (16.00%) MDX
3 20 (8.89%) Web Services
4 19 (8.44%) XML
5 15 (6.67%) Oracle GoldenGate
6 12 (5.33%) Kafka
7 11 (4.89%) Scrapy
8 10 (4.44%) Middleware
9 8 (3.56%) GraphX
9 8 (3.56%) Serverless Framework
10 6 (2.67%) HTML
10 6 (2.67%) Spring
11 5 (2.22%) Akka
11 5 (2.22%) JSON
12 4 (1.78%) .NET Framework
12 4 (1.78%) SOAP
12 4 (1.78%) WSDL
13 3 (1.33%) ASP.NET
13 3 (1.33%) HTML5
13 3 (1.33%) REST
Miscellaneous
1 17 (7.56%) Fintech
1 17 (7.56%) Replication
2 14 (6.22%) Management Information System
3 13 (5.78%) Analytical Skills
4 8 (3.56%) Clustering
5 6 (2.67%) Computer Science
5 6 (2.67%) Mobile App
6 4 (1.78%) Social Media
7 3 (1.33%) Data Centre
7 3 (1.33%) Data Structures
7 3 (1.33%) Enterprise Software
8 2 (0.89%) Online Games
8 2 (0.89%) Reference Data
9 1 (0.44%) Credit Derivative
9 1 (0.44%) Credit Risk
9 1 (0.44%) Derivative
9 1 (0.44%) Equities
9 1 (0.44%) Spread Betting
9 1 (0.44%) STB
9 1 (0.44%) Taxonomies
Operating Systems
1 25 (11.11%) Windows
2 17 (7.56%) Linux
3 10 (4.44%) Solaris
4 5 (2.22%) Windows Server
4 5 (2.22%) Windows Server 2008
4 5 (2.22%) Windows Server 2012
5 2 (0.89%) Unix
Processes & Methodologies
1 154 (68.44%) Business Intelligence
2 113 (50.22%) ETL
3 60 (26.67%) Agile Software Development
3 60 (26.67%) Data Modelling
4 53 (23.56%) Kimball Methodology
5 51 (22.67%) Analytics
6 47 (20.89%) Dimensional Modelling
7 32 (14.22%) Performance Tuning
8 23 (10.22%) Scrum
9 19 (8.44%) Data Analytics
9 19 (8.44%) Visualisation
10 17 (7.56%) Data Analysis
11 15 (6.67%) Presales
12 14 (6.22%) Data Management
12 14 (6.22%) Performance Management
13 13 (5.78%) Data Visualisation
13 13 (5.78%) ETL Development
13 13 (5.78%) SOA
14 12 (5.33%) Data Transformation
14 12 (5.33%) Microservices
Programming Languages
1 179 (79.56%) SQL
2 72 (32.00%) T-SQL
3 31 (13.78%) C#
4 30 (13.33%) PL/SQL
5 21 (9.33%) Java
6 18 (8.00%) Python
7 17 (7.56%) Data Analysis Expressions (DAX)
8 9 (4.00%) R
8 9 (4.00%) VB.NET
9 8 (3.56%) VBA
10 5 (2.22%) PowerShell
10 5 (2.22%) Scala
11 4 (1.78%) JavaScript
12 3 (1.33%) PHP
13 2 (0.89%) Data Mining Extensions (DMX)
14 1 (0.44%) C
14 1 (0.44%) C++
14 1 (0.44%) SPARQL
14 1 (0.44%) XMLA
Qualifications
1 28 (12.44%) Degree
2 9 (4.00%) Microsoft Certification
3 5 (2.22%) CIMA
4 2 (0.89%) MCITP
4 2 (0.89%) MCTS
5 1 (0.44%) Postgraduate
Quality Assurance & Compliance
1 24 (10.67%) Data Quality
2 23 (10.22%) QA
3 5 (2.22%) PMO
4 4 (1.78%) SLA
5 3 (1.33%) ISO/IEC 20000
6 1 (0.44%) Basel III
6 1 (0.44%) Dodd-Frank
System Software
1 10 (4.44%) Hyper-V
1 10 (4.44%) KVM
1 10 (4.44%) NFS
1 10 (4.44%) Oracle RAC
1 10 (4.44%) SRDF
1 10 (4.44%) VMware Infrastructure
1 10 (4.44%) Xen
2 1 (0.44%) Apache Flume
2 1 (0.44%) HDFS
Systems Management
1 11 (4.89%) Kibana
2 1 (0.44%) Oozie
Vendors
1 82 (36.44%) Microsoft
2 46 (20.44%) Oracle
3 38 (16.89%) Tableau
4 18 (8.00%) Cognos
5 15 (6.67%) IBM
6 13 (5.78%) Cisco
6 13 (5.78%) MicroStrategy
7 10 (4.44%) EMC
7 10 (4.44%) Intel
7 10 (4.44%) NetApp
7 10 (4.44%) VMware
8 9 (4.00%) Sybase
9 7 (3.11%) Hyperion
9 7 (3.11%) Infor
10 5 (2.22%) Actian
10 5 (2.22%) Jedox
10 5 (2.22%) SAP
11 4 (1.78%) Informatica
12 3 (1.33%) Citrix
12 3 (1.33%) Greenplum
London
Nigel Frank International
Salary: £40000 - £45000 per annum + benefits
Posted: 12 hours ago
City, London
Harrington Starr
Salary: £80000 - £100000 per annum + Bonus
Posted: 9 hours ago
London
Harvey Nash plc
Salary: £45000 - £55000 per annum
Posted: Yesterday
London
Nigel Frank International
Salary: £40000 - £50000 per annum
Posted: 2 days ago
London
Talent International
Salary: £350 - £500 per day
Posted: 3 days ago
London
Venturi
Salary: £40000 - £60000.00 per annum + company benefits
Posted: 3 days ago
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 3 days ago
City of London
Lawrence Harvey
Salary: £600 - £700 per annum
Posted: 10 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + stock options
Posted: 3 days ago
Central London / West End
The Workshop
Posted: 9 days ago
City of London
Huxley
Salary: competitive
Posted: 13 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + equity, benefits
Posted: 6 days ago
City of London
Lawrence Harvey
Salary: £50000.00 - £65000.00 per annum
Posted: 22 days ago