The table below looks at the statistics for OLAP skills in IT jobs advertised for the London region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 20 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
20 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
England / London
Rank 468 452 406
Rank change year-on-year
-16 -46
Permanent jobs citing OLAP 122 189 271
As % of all permanent IT jobs located in London 0.36% 0.47% 0.65%
As % of the Database & Business Intelligence category 1.20% 1.48% 2.14%
Number of salaries quoted 109 145 219
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 £41,200
10% offered a salary of more than £70,500 £75,000 £77,500
UK excluding London median salary £45,000 £44,750 £40,000
% change year-on-year
+0.55% +11.87%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the London region.

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
10185 12743 12691
As % of all permanent IT jobs located in London 30.10% 31.40% 30.39%
Number of salaries quoted 8923 11046 10924
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
90% offered a salary of more than £39,200 £40,000 £37,500
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
Jobs Demand Trend in London

The demand trend of job ads across the London region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in London

OLAP
Salary Trend in London

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

OLAP Salary Trend in London

OLAP
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing OLAP across the London region over the 3 months to 20 February 2017.

OLAP Salary Histogram 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 20 February 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 +20 27 £62,500 +13.63% 3
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 20 February 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 167 (78.04%) SQL
2 148 (69.16%) Data Warehouse
3 141 (65.89%) Business Intelligence
4 133 (62.15%) SQL Server
5 116 (54.21%) SQL Server Analysis Services
6 104 (48.60%) SQL Server Integration Services
7 96 (44.86%) SQL Server Reporting Services
8 92 (42.99%) ETL
9 79 (36.92%) Finance
10 76 (35.51%) Microsoft
11 65 (30.37%) T-SQL
12 64 (29.91%) Agile Software Development
13 59 (27.57%) Data Modelling
14 52 (24.30%) MS Excel
14 52 (24.30%) Analytics
15 51 (23.83%) OLAP Cube
16 49 (22.90%) Oracle
16 49 (22.90%) Oracle OLAP
17 45 (21.03%) Kimball Methodology
17 45 (21.03%) Relational Database
18 43 (20.09%) SQL Server 2012
19 42 (19.63%) Power BI
20 41 (19.16%) OLTP
21 39 (18.22%) Big Data
21 39 (18.22%) Dimensional Modelling
22 38 (17.76%) Performance Tuning
23 37 (17.29%) .NET
23 37 (17.29%) MDX
24 34 (15.89%) Tableau
25 33 (15.42%) Windows

OLAP
Top Related 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 23 (10.75%) Apache
2 18 (8.41%) Apache Spark
2 18 (8.41%) SharePoint
2 18 (8.41%) Tomcat
2 18 (8.41%) WebSphere
3 16 (7.48%) IIS
3 16 (7.48%) Oracle Coherence
3 16 (7.48%) Oracle HTTP Server
4 7 (3.27%) SAS
5 6 (2.80%) Apache Airflow
5 6 (2.80%) Elasticsearch
6 4 (1.87%) SharePoint 2013
7 3 (1.40%) Apache Pig
8 2 (0.93%) Apache Solr
9 1 (0.47%) DataSynapse
Applications
1 52 (24.30%) MS Excel
2 6 (2.80%) MS Visio
3 4 (1.87%) MS Office
4 1 (0.47%) MS PowerPoint
4 1 (0.47%) SPSS
Business Applications
1 6 (2.80%) Cognos TM1
2 2 (0.93%) Adobe Campaign
2 2 (0.93%) Dynamics CRM
2 2 (0.93%) Eloqua
2 2 (0.93%) Hyperion Planning
2 2 (0.93%) Unica
3 1 (0.47%) Cognos Business Intelligence
3 1 (0.47%) SAP BPC
Cloud Services
1 23 (10.75%) Microsoft Azure
2 6 (2.80%) Amazon AWS
2 6 (2.80%) Amazon Kinesis
3 5 (2.34%) Azure Machine Learning
3 5 (2.34%) Data Lake Analytics
4 3 (1.40%) Google Cloud Platform
5 2 (0.93%) Responsys
6 1 (0.47%) Google Play
6 1 (0.47%) IaaS
6 1 (0.47%) SaaS
Communications & Networking
1 21 (9.81%) SAN
2 17 (7.94%) HTTP
2 17 (7.94%) LAN
2 17 (7.94%) WAN
3 16 (7.48%) FCoE
3 16 (7.48%) Fibre Channel
3 16 (7.48%) iSCSI
3 16 (7.48%) Multicast
3 16 (7.48%) NAS
4 3 (1.40%) Internet
4 3 (1.40%) SSL
5 1 (0.47%) FTP
Database & Business Intelligence
1 148 (69.16%) Data Warehouse
2 133 (62.15%) SQL Server
3 116 (54.21%) SQL Server Analysis Services
4 104 (48.60%) SQL Server Integration Services
5 96 (44.86%) SQL Server Reporting Services
6 51 (23.83%) OLAP Cube
7 49 (22.90%) Oracle OLAP
8 45 (21.03%) Relational Database
9 43 (20.09%) SQL Server 2012
10 42 (19.63%) Power BI
11 41 (19.16%) OLTP
12 39 (18.22%) Big Data
13 29 (13.55%) Hadoop
14 28 (13.08%) QlikView
15 26 (12.15%) Microsoft Analysis Services
16 24 (11.21%) DB2
16 24 (11.21%) RDBMS
17 22 (10.28%) SQL Server 2016
18 21 (9.81%) SQL Server 2008
19 20 (9.35%) MySQL
Development Applications
1 10 (4.67%) Team Foundation Server
2 7 (3.27%) Visual Studio
3 6 (2.80%) Eclipse
3 6 (2.80%) PowerDesigner
4 5 (2.34%) JIRA
5 4 (1.87%) Maven
6 2 (0.93%) Git (software)
6 2 (0.93%) JUnit
6 2 (0.93%) Oracle Forms
7 1 (0.47%) ERwin
7 1 (0.47%) MagicDraw
General
1 79 (36.92%) Finance
2 28 (13.08%) Banking
3 15 (7.01%) Investment Banking
3 15 (7.01%) Marketing
4 11 (5.14%) Legal
5 8 (3.74%) Financial Institution
5 8 (3.74%) Games
6 7 (3.27%) Advertising
6 7 (3.27%) Retail
7 4 (1.87%) Automotive
7 4 (1.87%) German Language
7 4 (1.87%) Spanish Language
8 3 (1.40%) Manufacturing
8 3 (1.40%) Music Industry
8 3 (1.40%) Telecoms
9 2 (0.93%) French Language
9 2 (0.93%) Front Office
10 1 (0.47%) Law
10 1 (0.47%) Local Government
10 1 (0.47%) Wholesale Banking
Job Titles
1 104 (48.60%) Developer
2 51 (23.83%) Business Intelligence Developer
3 39 (18.22%) Senior Developer
4 30 (14.02%) SQL Developer
5 27 (12.62%) Architect
6 22 (10.28%) Consultant
7 21 (9.81%) Analyst
7 21 (9.81%) SSAS Developer
8 19 (8.88%) Business Intelligence Consultant
8 19 (8.88%) OLAP Developer
9 18 (8.41%) SSIS Developer
9 18 (8.41%) SSRS Developer
10 17 (7.94%) Senior Business Intelligence Developer
11 16 (7.48%) Data Warehouse Developer
11 16 (7.48%) Infrastructure Architect
11 16 (7.48%) Lead Architect
12 14 (6.54%) Business Developer
12 14 (6.54%) SQL Server Developer
13 13 (6.07%) Big Data Developer
13 13 (6.07%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 37 (17.29%) .NET
1 37 (17.29%) MDX
2 22 (10.28%) XML
3 20 (9.35%) Web Services
4 16 (7.48%) Middleware
5 12 (5.61%) Oracle GoldenGate
6 10 (4.67%) Akka
7 9 (4.21%) JSON
8 8 (3.74%) HTML
9 7 (3.27%) Kafka
9 7 (3.27%) Spring
10 6 (2.80%) Scrapy
11 5 (2.34%) SOAP
12 4 (1.87%) .NET Framework
12 4 (1.87%) GraphX
12 4 (1.87%) HTML5
12 4 (1.87%) Serverless Framework
12 4 (1.87%) WSDL
13 3 (1.40%) ASP.NET
13 3 (1.40%) REST
Miscellaneous
1 16 (7.48%) Replication
2 14 (6.54%) Management Information System
3 13 (6.07%) Analytical Skills
3 13 (6.07%) Fintech
4 7 (3.27%) Clustering
5 6 (2.80%) Computer Science
5 6 (2.80%) Mobile App
6 4 (1.87%) Reference Data
6 4 (1.87%) Social Media
7 3 (1.40%) Data Centre
7 3 (1.40%) Data Structures
7 3 (1.40%) Derivative
7 3 (1.40%) Enterprise Software
7 3 (1.40%) Online Games
8 2 (0.93%) Credit Derivative
8 2 (0.93%) Credit Risk
8 2 (0.93%) Equities
8 2 (0.93%) Foreign Exchange (FX)
8 2 (0.93%) Virtual Team
9 1 (0.47%) iPad
Operating Systems
1 33 (15.42%) Windows
2 31 (14.49%) Linux
3 16 (7.48%) Solaris
4 9 (4.21%) Unix
5 6 (2.80%) Windows Server
6 5 (2.34%) Windows Server 2008
6 5 (2.34%) Windows Server 2012
7 1 (0.47%) Android
7 1 (0.47%) Apple iOS
Processes & Methodologies
1 141 (65.89%) Business Intelligence
2 92 (42.99%) ETL
3 64 (29.91%) Agile Software Development
4 59 (27.57%) Data Modelling
5 52 (24.30%) Analytics
6 45 (21.03%) Kimball Methodology
7 39 (18.22%) Dimensional Modelling
8 38 (17.76%) Performance Tuning
9 22 (10.28%) Data Analytics
10 18 (8.41%) Risk Management
10 18 (8.41%) Scrum
11 17 (7.94%) Visualisation
12 16 (7.48%) Benchmarking
12 16 (7.48%) Business Analysis
13 14 (6.54%) Data Management
13 14 (6.54%) Performance Management
14 13 (6.07%) Data Transformation
14 13 (6.07%) Logical Data Model
15 12 (5.61%) Data Integration
15 12 (5.61%) Presales
Programming Languages
1 167 (78.04%) SQL
2 65 (30.37%) T-SQL
3 30 (14.02%) C#
4 26 (12.15%) Java
5 25 (11.68%) PL/SQL
6 15 (7.01%) Data Analysis Expressions (DAX)
7 13 (6.07%) Python
8 10 (4.67%) Scala
9 9 (4.21%) R
9 9 (4.21%) VB.NET
10 6 (2.80%) JavaScript
10 6 (2.80%) VBA
11 5 (2.34%) PHP
11 5 (2.34%) PowerShell
12 3 (1.40%) C
12 3 (1.40%) C++
13 2 (0.93%) Data Mining Extensions (DMX)
14 1 (0.47%) SPARQL
Qualifications
1 27 (12.62%) Degree
2 14 (6.54%) Microsoft Certification
3 6 (2.80%) CIMA
4 5 (2.34%) MCSE
5 2 (0.93%) MCITP
5 2 (0.93%) MCTS
5 2 (0.93%) Postgraduate
6 1 (0.47%) ACCA
Quality Assurance & Compliance
1 21 (9.81%) QA
2 19 (8.88%) Data Quality
3 4 (1.87%) SLA
4 2 (0.93%) Basel III
4 2 (0.93%) Dodd-Frank
System Software
1 16 (7.48%) Hyper-V
1 16 (7.48%) KVM
1 16 (7.48%) NFS
1 16 (7.48%) Oracle RAC
1 16 (7.48%) SRDF
1 16 (7.48%) VMware Infrastructure
1 16 (7.48%) Xen
2 3 (1.40%) Apache Flume
2 3 (1.40%) HDFS
Systems Management
1 6 (2.80%) Kibana
2 3 (1.40%) Oozie
3 1 (0.47%) ITRS Geneos
Vendors
1 76 (35.51%) Microsoft
2 49 (22.90%) Oracle
3 34 (15.89%) Tableau
4 20 (9.35%) IBM
5 19 (8.88%) Cisco
6 16 (7.48%) EMC
6 16 (7.48%) Intel
6 16 (7.48%) NetApp
6 16 (7.48%) VMware
7 11 (5.14%) Cognos
8 10 (4.67%) Actian
9 8 (3.74%) Sybase
10 7 (3.27%) MicroStrategy
11 6 (2.80%) Hyperion
12 4 (1.87%) Google
12 4 (1.87%) Informatica
13 3 (1.40%) Greenplum
13 3 (1.40%) SAP
14 2 (0.93%) Hortonworks
14 2 (0.93%) Infor
London
Austin Fraser
Salary: £45000 - £55000 per annum
Posted: 2 days ago
London
HFG
Salary: £45000 - £65000 per annum, Benefits + bonus + benefits
Posted: 2 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 2 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 2 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 2 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 2 days ago
Central London / West End
Initi8 Recruitment
Salary: £35000 - £40000 Per Annum
Posted: 2 days ago
London
Opus Recruitment Solutions Ltd
Salary: £0 - £60000 per annum
Posted: 4 days ago
City, London
Venturi
Salary: £50000 - £60000 per annum + company benefits
Posted: 5 days ago
City, London
Henderson Drake
Salary: From £34,000 to £40,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 4 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + equity, benefits
Posted: 4 days ago
City of London
Venturi
Salary: £22000.00 - £30000.00 per annum
Posted: 11 days ago