Period
to 21 November 2017

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 6 months to 21 November 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
England > London
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 479 616 507
Rank change year-on-year +137 -109 -112
Permanent jobs citing OLAP 386 241 467
As % of all permanent IT jobs advertised in London 0.51% 0.32% 0.53%
As % of the Database & Business Intelligence category 1.74% 1.08% 1.72%
Number of salaries quoted 227 188 374
London median annual salary £57,500 £60,000 £57,500
Median salary % change year-on-year -4.17% +4.35% -
10th Percentile £40,750 £41,250 £40,375
90th Percentile £77,500 £95,750 £84,250
England median annual salary £50,000 £50,000 £50,000

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 London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 22238 22293 27092
As % of all permanent IT jobs advertised in London 29.43% 29.46% 30.60%
Number of salaries quoted 17833 19427 22914
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% +4.76%
10th Percentile £36,250 £35,000 £35,000
90th Percentile £88,750 £87,500 £85,000
England median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

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 6 months to 21 November 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 6 months to 21 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London +29 51 £55,000 -16.67% 4
East London +14 21 £57,500 +21.05%
West London +14 5 £38,607 -26.46%
South London +4 5 £47,500 -31.65%
North London +3 2 £50,000 -23.08%
OLAP
England

For the 6 months to 21 November 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 324 (83.94%) SQL
2 305 (79.02%) Data Warehouse
3 207 (53.63%) SQL Server
4 202 (52.33%) Business Intelligence
5 194 (50.26%) ETL
6 179 (46.37%) Agile Software Development
7 173 (44.82%) Oracle OLAP
7 173 (44.82%) Oracle
8 168 (43.52%) SQL Server Integration Services
8 168 (43.52%) Finance
8 168 (43.52%) SQL Server Analysis Services
9 152 (39.38%) SQL Server Reporting Services
10 142 (36.79%) PL/SQL
11 139 (36.01%) Analytics
12 136 (35.23%) Java
13 130 (33.68%) Banking
14 121 (31.35%) MDX
14 121 (31.35%) Python
14 121 (31.35%) Kimball Methodology
15 110 (28.50%) Analytical Skills
16 109 (28.24%) Microsoft
17 108 (27.98%) Data Analytics
18 105 (27.20%) Dimensional Modelling
19 104 (26.94%) OLAP Cube
20 103 (26.68%) Asset Management
21 102 (26.42%) Investment Banking
21 102 (26.42%) T-SQL
22 101 (26.17%) Retail Banking
23 98 (25.39%) Unix
24 97 (25.13%) Enterprise Software

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 33 (8.55%) SharePoint
2 17 (4.40%) Apache Spark
3 10 (2.59%) Apache
4 9 (2.33%) IIS
4 9 (2.33%) SAS
4 9 (2.33%) Skype for Business
5 4 (1.04%) Elasticsearch
6 2 (0.52%) GemFire
6 2 (0.52%) Oracle SOA Suite
7 1 (0.26%) Apache Solr
7 1 (0.26%) Tomcat
Applications
1 17 (4.40%) Microsoft Excel
2 8 (2.07%) Microsoft Office
3 5 (1.30%) MS Visio
4 2 (0.52%) Microsoft PowerPoint
Business Applications
1 9 (2.33%) Cognos TM1
2 6 (1.55%) Cognos Business Intelligence
3 5 (1.30%) Cognos Planning
3 5 (1.30%) HFM
4 1 (0.26%) Oracle Applications
4 1 (0.26%) Remedy ITSM
Cloud Services
1 33 (8.55%) Microsoft Azure
2 19 (4.92%) Amazon AWS
3 11 (2.85%) Azure Data Factory
4 6 (1.55%) Office 365
5 4 (1.04%) Google Cloud Platform
6 2 (0.52%) Amazon EMR
6 2 (0.52%) Amazon S3
7 1 (0.26%) Cloud Computing
7 1 (0.26%) SaaS
Communications & Networking
1 9 (2.33%) HTTPS
1 9 (2.33%) ISDN
1 9 (2.33%) SAN
2 5 (1.30%) SSL
3 2 (0.52%) Kerberos
4 1 (0.26%) DHCP
4 1 (0.26%) DNS
4 1 (0.26%) HTTP
Database & Business Intelligence
1 305 (79.02%) Data Warehouse
2 207 (53.63%) SQL Server
3 173 (44.82%) Oracle OLAP
4 168 (43.52%) SQL Server Analysis Services
4 168 (43.52%) SQL Server Integration Services
5 152 (39.38%) SQL Server Reporting Services
6 104 (26.94%) OLAP Cube
7 92 (23.83%) Power BI
8 72 (18.65%) Relational Database
9 60 (15.54%) Big Data
10 57 (14.77%) OLTP
10 57 (14.77%) QlikView
11 50 (12.95%) SQL Server 2008
12 48 (12.44%) MySQL
13 45 (11.66%) Microsoft Analysis Services
14 37 (9.59%) Oracle Database
15 35 (9.07%) BusinessObjects
15 35 (9.07%) DB2
16 31 (8.03%) SQL Server 2012
17 27 (6.99%) PowerPivot
Development Applications
1 25 (6.48%) Team Foundation Server
2 18 (4.66%) Visual Studio
3 14 (3.63%) JIRA
4 11 (2.85%) Eclipse
5 8 (2.07%) Git (software)
5 8 (2.07%) Maven
6 7 (1.81%) Octopus Deploy
7 5 (1.30%) JUnit
8 4 (1.04%) PowerDesigner
9 2 (0.52%) ERwin
9 2 (0.52%) Talend Open Studio
9 2 (0.52%) Xcode
10 1 (0.26%) Bitbucket
10 1 (0.26%) MSI
10 1 (0.26%) TeamCity
10 1 (0.26%) Toad
10 1 (0.26%) Visual Studio Team System
General
1 168 (43.52%) Finance
2 130 (33.68%) Banking
3 102 (26.42%) Investment Banking
4 101 (26.17%) Retail Banking
5 23 (5.96%) Marketing
6 17 (4.40%) Publishing
7 13 (3.37%) Retail
8 6 (1.55%) Front Office
9 5 (1.30%) Legal
10 4 (1.04%) Advertising
11 2 (0.52%) Financial Institution
12 1 (0.26%) International Banking
12 1 (0.26%) Telecoms
Job Titles
1 229 (59.33%) Developer
2 98 (25.39%) Business Intelligence Developer
3 73 (18.91%) Quantitative Developer
4 72 (18.65%) SQL Developer
5 41 (10.62%) SQL BI Developer
6 40 (10.36%) Analyst
7 34 (8.81%) Data Warehouse Developer
7 34 (8.81%) SSRS Developer
8 32 (8.29%) SSIS Developer
9 31 (8.03%) Consultant
10 26 (6.74%) Business Developer
11 25 (6.48%) SSAS Developer
12 24 (6.22%) Oracle Developer
13 23 (5.96%) Oracle Data Warehouse Developer
14 21 (5.44%) Business Intelligence Consultant
15 20 (5.18%) Architect
15 20 (5.18%) T-SQL Developer
16 19 (4.92%) SQL Server Developer
17 17 (4.40%) Quantitative Analyst
17 17 (4.40%) Research Analyst
Libraries, Frameworks & Software Standards
1 121 (31.35%) MDX
2 36 (9.33%) XML
3 35 (9.07%) Web Services
4 25 (6.48%) Oracle GoldenGate
5 18 (4.66%) .NET
6 11 (2.85%) SOAP
7 10 (2.59%) JSON
7 10 (2.59%) WSDL
8 8 (2.07%) REST
8 8 (2.07%) Spring
9 5 (1.30%) Pandas
9 5 (1.30%) RESTful
9 5 (1.30%) XML Messaging
9 5 (1.30%) XSD
10 3 (0.78%) Velocity
11 2 (0.52%) HTML
11 2 (0.52%) J2SE
11 2 (0.52%) JDBC
11 2 (0.52%) ODBC
11 2 (0.52%) SAML
Miscellaneous
1 110 (28.50%) Analytical Skills
2 97 (25.13%) Enterprise Software
3 27 (6.99%) Replication
4 11 (2.85%) Fintech
5 9 (2.33%) Cyber Attack
6 7 (1.81%) Computer Science
6 7 (1.81%) Credit Risk
6 7 (1.81%) iPhone
6 7 (1.81%) Mobile App
7 6 (1.55%) Equities
7 6 (1.55%) Reinsurance
8 5 (1.30%) Data Centre
8 5 (1.30%) Management Information System
9 3 (0.78%) Greenfield Project
9 3 (0.78%) Market Risk
10 2 (0.52%) Data Structures
10 2 (0.52%) Derivative
10 2 (0.52%) Hedge funds
11 1 (0.26%) Equity Derivative
11 1 (0.26%) Fixed Income
Operating Systems
1 98 (25.39%) Unix
2 26 (6.74%) Linux
3 11 (2.85%) Windows
4 9 (2.33%) Windows Server
5 1 (0.26%) Solaris
5 1 (0.26%) Windows Server 2008
Processes & Methodologies
1 202 (52.33%) Business Intelligence
2 194 (50.26%) ETL
3 179 (46.37%) Agile Software Development
4 139 (36.01%) Analytics
5 121 (31.35%) Kimball Methodology
6 108 (27.98%) Data Analytics
7 105 (27.20%) Dimensional Modelling
8 103 (26.68%) Asset Management
9 93 (24.09%) Wealth Management
10 92 (23.83%) Release Management
11 90 (23.32%) Quantitative Research
12 63 (16.32%) Data Modelling
13 61 (15.80%) Performance Tuning
14 51 (13.21%) ETL Development
15 39 (10.10%) Visualisation
16 37 (9.59%) Scrum
17 33 (8.55%) Data Visualisation
18 31 (8.03%) Kanban
19 27 (6.99%) Data Management
20 23 (5.96%) Migration
Programming Languages
1 324 (83.94%) SQL
2 142 (36.79%) PL/SQL
3 136 (35.23%) Java
4 121 (31.35%) Python
5 102 (26.42%) T-SQL
6 92 (23.83%) R
7 91 (23.58%) Perl
8 90 (23.32%) C++
9 30 (7.77%) C#
10 21 (5.44%) Data Analysis Expressions (DAX)
11 16 (4.15%) PowerShell
12 7 (1.81%) VB.NET
13 6 (1.55%) VB
13 6 (1.55%) VBA
14 5 (1.30%) C
14 5 (1.30%) Scala
15 4 (1.04%) JavaScript
16 3 (0.78%) PHP
17 2 (0.52%) Bash Shell
17 2 (0.52%) Go
Qualifications
1 44 (11.40%) Degree
2 8 (2.07%) MBA
3 7 (1.81%) MCITP
3 7 (1.81%) MCSE
3 7 (1.81%) Microsoft Certification
4 1 (0.26%) Computer Science Degree
4 1 (0.26%) Numerate Degree
4 1 (0.26%) OCP
4 1 (0.26%) Oracle Certification
Quality Assurance & Compliance
1 41 (10.62%) Data Quality
2 30 (7.77%) QA
3 9 (2.33%) ISO/IEC 27001
4 2 (0.52%) GCP
5 1 (0.26%) SLA
System Software
1 9 (2.33%) Active Directory
2 2 (0.52%) Apache Flume
2 2 (0.52%) Docker
2 2 (0.52%) HDFS
3 1 (0.26%) VMware ESXi
3 1 (0.26%) VMware Infrastructure
Systems Management
1 3 (0.78%) Ansible
2 2 (0.52%) Hadoop YARN
2 2 (0.52%) Kubernetes
3 1 (0.26%) Netcool
3 1 (0.26%) vCenter Server
Vendors
1 173 (44.82%) Oracle
2 109 (28.24%) Microsoft
3 59 (15.28%) Tableau
4 20 (5.18%) Cognos
5 18 (4.66%) MicroStrategy
6 11 (2.85%) Hyperion
7 10 (2.59%) Informatica
8 9 (2.33%) Apple
8 9 (2.33%) Avaya
8 9 (2.33%) NetApp
8 9 (2.33%) Tagetik
9 7 (1.81%) RedGate
9 7 (1.81%) SAP
9 7 (1.81%) TIBCO
10 6 (1.55%) IBM
11 5 (1.30%) Callidus
11 5 (1.30%) Cisco
11 5 (1.30%) Guidewire
11 5 (1.30%) Pega
12 4 (1.04%) Cloudera