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 29 June 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
England / London
3 months to
29 Jun 2017
Same period 2016 Same period 2015
Rank 429 475 448
Rank change year-on-year +46 -27  
Permanent jobs citing OLAP 195 171 238
As % of all permanent IT jobs advertised in London 0.53% 0.43% 0.53%
As % of the Database & Business Intelligence category 1.78% 1.46% 1.65%
Number of salaries quoted 138 122 196
Median salary £60,000 £60,000 £60,000
90% offered a salary of more than £42,500 £46,325 £42,500
10% offered a salary of more than £75,375 £85,000 £90,000
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 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 10957 11742 14456
As % of all permanent IT job vacancies advertised in London 29.86% 29.40% 32.15%
Number of salaries quoted 21540 24947 30934
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.34% -  
90% offered a salary of more than £37,500 £37,500 £36,250
10% offered a salary of more than £87,500 £85,000 £85,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

OLAP
Job Vacancy Trend in London

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

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 29 June 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 29 June 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 +27 31 £67,500 +8.00% 4
Ealing - 2 £38,607 -
Moorgate - 1 £42,500 -
OLAP
England

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

1 257 (80.31%) SQL
2 228 (71.25%) Data Warehouse
3 208 (65.00%) Business Intelligence
4 204 (63.75%) SQL Server
5 197 (61.56%) ETL
6 181 (56.56%) SQL Server Analysis Services
7 165 (51.56%) SQL Server Integration Services
8 147 (45.94%) OLAP Cube
9 129 (40.31%) Microsoft
10 125 (39.06%) SQL Server Reporting Services
11 109 (34.06%) Finance
12 96 (30.00%) T-SQL
13 89 (27.81%) Agile Software Development
14 87 (27.19%) Dimensional Modelling
15 86 (26.88%) Kimball Methodology
16 84 (26.25%) Relational Database
17 76 (23.75%) Data Modelling
18 72 (22.50%) Oracle
18 72 (22.50%) Oracle OLAP
19 70 (21.88%) Power BI
20 68 (21.25%) MDX
21 62 (19.38%) Analytics
22 61 (19.06%) PL/SQL
23 56 (17.50%) SQL Server 2012
24 53 (16.56%) Banking
24 53 (16.56%) Tableau
25 47 (14.69%) Java
25 47 (14.69%) Python
26 46 (14.38%) RDBMS
26 46 (14.38%) Analytical Skills

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 28 (8.75%) Apache Spark
2 19 (5.94%) Elasticsearch
3 17 (5.31%) Apache
3 17 (5.31%) Apache Airflow
4 11 (3.44%) SharePoint
5 4 (1.25%) Tomcat
5 4 (1.25%) WebSphere
6 3 (0.94%) Oracle SOA Suite
7 2 (0.63%) GemFire
7 2 (0.63%) SharePoint 2013
8 1 (0.31%) Apache Solr
8 1 (0.31%) OpenStack
8 1 (0.31%) Oracle Coherence
8 1 (0.31%) SAS
Applications
1 25 (7.81%) MS Visio
2 23 (7.19%) Microsoft Excel
3 2 (0.63%) Microsoft Office
4 1 (0.31%) SPSS
Business Applications
1 17 (5.31%) Cognos TM1
2 11 (3.44%) Infor SunSystems
3 7 (2.19%) Cognos Business Intelligence
4 2 (0.63%) Hyperion Planning
4 2 (0.63%) SAP BPC
5 1 (0.31%) ION MarketView
5 1 (0.31%) PeopleSoft HRMS
Cloud Services
1 27 (8.44%) Amazon AWS
2 17 (5.31%) Amazon Kinesis
2 17 (5.31%) Microsoft Azure
3 3 (0.94%) IaaS
3 3 (0.94%) Office 365
4 2 (0.63%) Google Cloud Platform
4 2 (0.63%) SaaS
5 1 (0.31%) Adobe Analytics
5 1 (0.31%) Cloud Computing
5 1 (0.31%) Datadog
5 1 (0.31%) Google Analytics
Communications & Networking
1 7 (2.19%) SAN
2 3 (0.94%) Kerberos
2 3 (0.94%) NAS
3 1 (0.31%) FTP
3 1 (0.31%) HTTP
3 1 (0.31%) LAN
3 1 (0.31%) WAN
Database & Business Intelligence
1 228 (71.25%) Data Warehouse
2 204 (63.75%) SQL Server
3 181 (56.56%) SQL Server Analysis Services
4 165 (51.56%) SQL Server Integration Services
5 147 (45.94%) OLAP Cube
6 125 (39.06%) SQL Server Reporting Services
7 84 (26.25%) Relational Database
8 72 (22.50%) Oracle OLAP
9 70 (21.88%) Power BI
10 56 (17.50%) SQL Server 2012
11 46 (14.38%) RDBMS
12 45 (14.06%) MySQL
13 40 (12.50%) OLTP
14 36 (11.25%) SQL Server 2008
15 35 (10.94%) SQL Server 2014
16 32 (10.00%) QlikView
17 30 (9.38%) Microsoft Analysis Services
18 27 (8.44%) BusinessObjects
19 25 (7.81%) SSDT
20 24 (7.50%) DB2
Development Applications
1 25 (7.81%) PowerDesigner
2 11 (3.44%) JIRA
3 10 (3.13%) Eclipse
3 10 (3.13%) Team Foundation Server
4 6 (1.88%) Visual Studio
5 5 (1.56%) Maven
6 4 (1.25%) JUnit
6 4 (1.25%) Octopus Deploy
7 3 (0.94%) Git (software)
8 2 (0.63%) TeamCity
9 1 (0.31%) Bitbucket
9 1 (0.31%) ERwin
9 1 (0.31%) MagicDraw
9 1 (0.31%) Visual Studio Team System
9 1 (0.31%) Xcode
General
1 109 (34.06%) Finance
2 53 (16.56%) Banking
3 40 (12.50%) Retail
4 35 (10.94%) Investment Banking
5 34 (10.63%) Marketing
6 24 (7.50%) Retail Banking
7 22 (6.88%) Legal
8 11 (3.44%) Front Office
9 7 (2.19%) Advertising
10 6 (1.88%) Financial Institution
10 6 (1.88%) Law
11 5 (1.56%) Publishing
12 2 (0.63%) Automotive
12 2 (0.63%) French Language
12 2 (0.63%) German Language
12 2 (0.63%) Spanish Language
12 2 (0.63%) Telecoms
13 1 (0.31%) Back Office
13 1 (0.31%) Manufacturing
13 1 (0.31%) Music Industry
Job Titles
1 175 (54.69%) Developer
2 97 (30.31%) Business Intelligence Developer
3 55 (17.19%) SQL Developer
4 51 (15.94%) Analyst
5 50 (15.63%) Senior Developer
6 45 (14.06%) SSAS Developer
7 42 (13.13%) Business Intelligence Analyst
8 39 (12.19%) Senior Business Intelligence Developer
9 37 (11.56%) Data Warehouse Developer
10 31 (9.69%) OLAP Developer
11 25 (7.81%) Tableau Developer
12 24 (7.50%) Business Developer
12 24 (7.50%) Senior OLAP Developer
12 24 (7.50%) SQL BI Developer
12 24 (7.50%) SSRS Developer
13 21 (6.56%) Data Visualisation Developer
13 21 (6.56%) Quantitative Developer
14 20 (6.25%) SQL Analyst
15 19 (5.94%) Data Engineer
15 19 (5.94%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 68 (21.25%) MDX
2 27 (8.44%) .NET
2 27 (8.44%) Web Services
3 24 (7.50%) XML
4 22 (6.88%) Oracle GoldenGate
5 17 (5.31%) Kafka
5 17 (5.31%) Scrapy
6 13 (4.06%) GraphX
6 13 (4.06%) Serverless Framework
7 9 (2.81%) REST
7 9 (2.81%) XSD
8 8 (2.50%) SOAP
8 8 (2.50%) WSDL
8 8 (2.50%) XML Messaging
9 6 (1.88%) Spring
10 5 (1.56%) HTML
10 5 (1.56%) RESTful
11 4 (1.25%) Ajax
11 4 (1.25%) HTML5
12 3 (0.94%) SAML
Miscellaneous
1 46 (14.38%) Analytical Skills
2 26 (8.13%) Enterprise Software
3 22 (6.88%) Management Information System
4 19 (5.94%) Fintech
4 19 (5.94%) Replication
5 8 (2.50%) Computer Science
6 7 (2.19%) Clustering
7 4 (1.25%) Greenfield Project
8 3 (0.94%) Credit Risk
8 3 (0.94%) Foreign Exchange (FX)
9 2 (0.63%) Data Structures
9 2 (0.63%) Derivative
9 2 (0.63%) Equities
9 2 (0.63%) Fixed Income
9 2 (0.63%) Hedge funds
9 2 (0.63%) Market Risk
9 2 (0.63%) Reference Data
9 2 (0.63%) Social Media
9 2 (0.63%) User Experience
10 1 (0.31%) Mobile App
Operating Systems
1 22 (6.88%) Unix
2 12 (3.75%) Windows
3 8 (2.50%) Linux
4 4 (1.25%) Windows Server
4 4 (1.25%) Windows Server 2008
4 4 (1.25%) Windows Server 2012
Processes & Methodologies
1 208 (65.00%) Business Intelligence
2 197 (61.56%) ETL
3 89 (27.81%) Agile Software Development
4 87 (27.19%) Dimensional Modelling
5 86 (26.88%) Kimball Methodology
6 76 (23.75%) Data Modelling
7 62 (19.38%) Analytics
8 42 (13.13%) Visualisation
9 40 (12.50%) Data Analytics
10 36 (11.25%) Performance Tuning
11 34 (10.63%) Data Visualisation
12 29 (9.06%) ETL Development
12 29 (9.06%) SOA
13 28 (8.75%) Scrum
14 24 (7.50%) Regression Testing
15 23 (7.19%) Asset Management
16 22 (6.88%) Data Management
16 22 (6.88%) Quantitative Research
16 22 (6.88%) Release Management
17 21 (6.56%) Wealth Management
Programming Languages
1 257 (80.31%) SQL
2 96 (30.00%) T-SQL
3 61 (19.06%) PL/SQL
4 47 (14.69%) Java
4 47 (14.69%) Python
5 27 (8.44%) C#
6 23 (7.19%) R
7 22 (6.88%) Perl
8 21 (6.56%) C++
9 13 (4.06%) Data Analysis Expressions (DAX)
10 11 (3.44%) VB.NET
11 9 (2.81%) PowerShell
12 6 (1.88%) JavaScript
12 6 (1.88%) VBA
13 4 (1.25%) PHP
14 3 (0.94%) Scala
15 1 (0.31%) Bash Shell
15 1 (0.31%) Data Mining Extensions (DMX)
15 1 (0.31%) Go
15 1 (0.31%) SPARQL
Qualifications
1 35 (10.94%) Degree
2 8 (2.50%) ITIL Certification
3 6 (1.88%) Computer Science Degree
4 4 (1.25%) Microsoft Certification
5 3 (0.94%) CIMA
6 2 (0.63%) Master's Degree
7 1 (0.31%) MCITP
7 1 (0.31%) MCSE
7 1 (0.31%) Numerate Degree
7 1 (0.31%) Postgraduate
Quality Assurance & Compliance
1 35 (10.94%) Data Quality
2 28 (8.75%) QA
3 3 (0.94%) PMO
4 2 (0.63%) SLA
5 1 (0.31%) Basel III
5 1 (0.31%) Dodd-Frank
5 1 (0.31%) GCP
5 1 (0.31%) PCI DSS
5 1 (0.31%) Sarbanes-Oxley
System Software
1 1 (0.31%) Apache Flume
1 1 (0.31%) Docker
1 1 (0.31%) HDFS
1 1 (0.31%) KVM
1 1 (0.31%) VMware Infrastructure
Systems Management
1 18 (5.63%) Kibana
2 3 (0.94%) Ansible
3 2 (0.63%) Opscode Chef
3 2 (0.63%) Puppet
4 1 (0.31%) Cobbler
4 1 (0.31%) Control-M
4 1 (0.31%) Kubernetes
4 1 (0.31%) Nagios
4 1 (0.31%) Oozie
4 1 (0.31%) PowerCLI
4 1 (0.31%) Rundeck
4 1 (0.31%) ZABBIX
Vendors
1 129 (40.31%) Microsoft
2 72 (22.50%) Oracle
3 53 (16.56%) Tableau
4 29 (9.06%) Cognos
5 25 (7.81%) Sybase
6 21 (6.56%) MicroStrategy
7 19 (5.94%) SAP
8 13 (4.06%) Infor
9 11 (3.44%) Jedox
10 10 (3.13%) Informatica
11 8 (2.50%) Callidus
11 8 (2.50%) Guidewire
11 8 (2.50%) Hyperion
12 7 (2.19%) Cognizant
12 7 (2.19%) Sun
13 5 (1.56%) TIBCO
14 4 (1.25%) Citrix
15 3 (0.94%) Atlassian
15 3 (0.94%) Google
15 3 (0.94%) IBM
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 23 hours ago
City, London
I.T. Skillfinder
Salary: From £65,000 to £70,000 per annum Benefits
Posted: Yesterday
London
Venturi
Salary: £40000.00 - £55000.00 per annum + Bonus & Benefits
Posted: 3 days ago
London
Premier Group Recruitment
Salary: £40000 - £50000 per annum
Posted: Yesterday
London
Talent Spa
Salary: £70k per year
Posted: 6 days ago
Central London / West End
The Workshop
Posted: 5 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 13 days ago
London
Opus Recruitment Solutions Ltd
Salary: £100000 - £150000 per annum
Posted: 2 days ago
East London
Cognizant
Salary: Competitive
Posted: 9 days ago