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 8 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
8 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 508 432 402
Rank change year-on-year
-76 -30
Permanent jobs citing OLAP 104 229 282
As % of all permanent IT jobs located in London 0.29% 0.53% 0.63%
As % of the Database & Business Intelligence category 1.00% 1.68% 2.09%
Number of salaries quoted 75 197 248
Median salary £55,000 £57,500 £60,000
Median salary % change year-on-year
-4.34% -4.16%
90% offered a salary of more than £41,000 £42,500 £40,000
10% offered a salary of more than £72,500 £72,500 £72,500
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
OLAP
England

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
10429 13637 13516
As % of all permanent IT jobs located in London 29.56% 31.40% 30.09%
Number of salaries quoted 9066 11648 11669
Median salary £60,000 £56,000 £55,000
Median salary % change year-on-year
+7.14% +1.81%
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 8 December 2016.

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 8 December 2016. 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
(Click see detailed
statistics and trends)
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 -5 14 £60,250 -3.60% 5
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 8 December 2016, 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 181 (77.02%) SQL
2 156 (66.38%) Business Intelligence
3 155 (65.96%) Data Warehouse
4 153 (65.11%) SQL Server
5 111 (47.23%) SQL Server Analysis Services
6 100 (42.55%) ETL
7 92 (39.15%) SQL Server Reporting Services
8 87 (37.02%) Finance
8 87 (37.02%) Microsoft
9 85 (36.17%) SQL Server Integration Services
10 73 (31.06%) T-SQL
11 72 (30.64%) Agile Software Development
12 69 (29.36%) Oracle
12 69 (29.36%) Oracle OLAP
13 65 (27.66%) Analytics
14 57 (24.26%) MS Excel
15 54 (22.98%) OLTP
15 54 (22.98%) Kimball Methodology
16 53 (22.55%) Data Modelling
17 51 (21.70%) Performance Tuning
18 50 (21.28%) Windows
19 49 (20.85%) Linux
20 48 (20.43%) Tableau
21 47 (20.00%) MDX
22 46 (19.57%) Big Data
23 41 (17.45%) Relational Database
24 38 (16.17%) Java
25 37 (15.74%) SQL Server 2012
26 35 (14.89%) DB2
27 34 (14.47%) OLAP Cube

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 27 (11.49%) Apache
2 26 (11.06%) IIS
2 26 (11.06%) SharePoint
3 25 (10.64%) Oracle Coherence
4 24 (10.21%) Oracle HTTP Server
4 24 (10.21%) Tomcat
4 24 (10.21%) WebSphere
5 22 (9.36%) Apache Spark
5 22 (9.36%) SAS
6 4 (1.70%) SharePoint 2013
7 3 (1.28%) Apache Pig
8 2 (0.85%) Elasticsearch
9 1 (0.43%) Apache Solr
Applications
1 57 (24.26%) MS Excel
2 5 (2.13%) MS Office
3 4 (1.70%) Gephi
4 1 (0.43%) MS PowerPoint
4 1 (0.43%) SPSS
Business Applications
1 3 (1.28%) Cognos TM1
2 2 (0.85%) Adobe Campaign
2 2 (0.85%) Dynamics CRM
2 2 (0.85%) Dynamics NAV
2 2 (0.85%) Eloqua
2 2 (0.85%) Magento
2 2 (0.85%) Unica
3 1 (0.43%) JDE EnterpriseOne
Cloud Services
1 28 (11.91%) Microsoft Azure
2 12 (5.11%) Azure Machine Learning
2 12 (5.11%) Data Lake Analytics
3 8 (3.40%) IaaS
4 7 (2.98%) PaaS
5 4 (1.70%) Amazon AWS
6 3 (1.28%) Google Cloud Platform
6 3 (1.28%) SaaS
7 2 (0.85%) GitHub
7 2 (0.85%) Responsys
8 1 (0.43%) Google Play
Communications & Networking
1 29 (12.34%) SAN
2 24 (10.21%) FCoE
2 24 (10.21%) Fibre Channel
2 24 (10.21%) HTTP
2 24 (10.21%) iSCSI
2 24 (10.21%) LAN
2 24 (10.21%) Multicast
2 24 (10.21%) NAS
2 24 (10.21%) WAN
3 3 (1.28%) Internet
3 3 (1.28%) SSL
Database & Business Intelligence
1 155 (65.96%) Data Warehouse
2 153 (65.11%) SQL Server
3 111 (47.23%) SQL Server Analysis Services
4 92 (39.15%) SQL Server Reporting Services
5 85 (36.17%) SQL Server Integration Services
6 69 (29.36%) Oracle OLAP
7 54 (22.98%) OLTP
8 46 (19.57%) Big Data
9 41 (17.45%) Relational Database
10 37 (15.74%) SQL Server 2012
11 35 (14.89%) DB2
12 34 (14.47%) OLAP Cube
13 33 (14.04%) Microsoft Analysis Services
13 33 (14.04%) QlikView
14 32 (13.62%) Hadoop
15 29 (12.34%) Power BI
16 26 (11.06%) RDBMS
17 22 (9.36%) SQL Server 2016
18 20 (8.51%) SQL Server 2008
19 18 (7.66%) MySQL
Development Applications
1 13 (5.53%) Visual Studio
2 10 (4.26%) Team Foundation Server
3 7 (2.98%) JIRA
3 7 (2.98%) Visual Studio Tools for Office
4 5 (2.13%) Maven
5 3 (1.28%) Git (software)
6 2 (0.85%) Oracle Forms
7 1 (0.43%) Gradle
7 1 (0.43%) Subversion
7 1 (0.43%) TeamCity
General
1 87 (37.02%) Finance
2 27 (11.49%) Banking
3 17 (7.23%) Retail
4 14 (5.96%) Legal
5 13 (5.53%) Manufacturing
6 12 (5.11%) Marketing
7 9 (3.83%) Games
7 9 (3.83%) Publishing
8 7 (2.98%) Investment Banking
9 6 (2.55%) Telecoms
10 4 (1.70%) Front Office
11 3 (1.28%) Advertising
12 2 (0.85%) Automotive
12 2 (0.85%) Financial Institution
12 2 (0.85%) German Language
12 2 (0.85%) Music Industry
12 2 (0.85%) Spanish Language
13 1 (0.43%) Back Office
13 1 (0.43%) Law
13 1 (0.43%) Local Government
Job Titles
1 99 (42.13%) Developer
2 57 (24.26%) Business Intelligence Developer
3 47 (20.00%) Architect
4 38 (16.17%) Consultant
5 28 (11.91%) Business Intelligence Consultant
5 28 (11.91%) Lead Architect
6 24 (10.21%) Infrastructure Architect
6 24 (10.21%) SQL Developer
7 22 (9.36%) Senior Developer
8 19 (8.09%) Data Architect
8 19 (8.09%) SSAS Developer
8 19 (8.09%) SSIS Developer
9 18 (7.66%) SSRS Developer
10 15 (6.38%) Microsoft Consultant
11 14 (5.96%) ETL Developer
12 13 (5.53%) Business Developer
12 13 (5.53%) OLAP Developer
12 13 (5.53%) SAS BI Consultant
12 13 (5.53%) SAS Consultant
12 13 (5.53%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 47 (20.00%) MDX
2 33 (14.04%) .NET
3 25 (10.64%) XML
4 24 (10.21%) Middleware
5 21 (8.94%) Web Services
6 14 (5.96%) HTML
6 14 (5.96%) Oracle GoldenGate
7 12 (5.11%) JSON
8 11 (4.68%) D3.js
8 11 (4.68%) HTML5
9 9 (3.83%) Akka
10 7 (2.98%) Leaflet
11 5 (2.13%) ASP.NET
11 5 (2.13%) SOAP
11 5 (2.13%) Spring
12 3 (1.28%) .NET Framework
12 3 (1.28%) Django
12 3 (1.28%) J2EE
12 3 (1.28%) REST
12 3 (1.28%) WSDL
Miscellaneous
1 32 (13.62%) Analytical Skills
2 25 (10.64%) Visualisation
3 16 (6.81%) Data Integration
4 15 (6.38%) Replication
5 14 (5.96%) Fintech
6 13 (5.53%) Mobile App
7 12 (5.11%) Management Information System
8 11 (4.68%) Neural Network
9 8 (3.40%) Computer Science
9 8 (3.40%) Enterprise Software
10 7 (2.98%) Statistics
11 6 (2.55%) Data Structures
12 5 (2.13%) Clustering
12 5 (2.13%) Economics
12 5 (2.13%) Online Games
13 4 (1.70%) Data Extraction
13 4 (1.70%) Derivative
13 4 (1.70%) Fixed Income
14 3 (1.28%) Data Centre
14 3 (1.28%) Mathematics
Operating Systems
1 50 (21.28%) Windows
2 49 (20.85%) Linux
3 24 (10.21%) Solaris
4 21 (8.94%) Unix
5 8 (3.40%) Windows Server
6 3 (1.28%) Windows Server 2008
6 3 (1.28%) Windows Server 2012
7 1 (0.43%) Android
7 1 (0.43%) Apple iOS
Processes & Methodologies
1 156 (66.38%) Business Intelligence
2 100 (42.55%) ETL
3 72 (30.64%) Agile Software Development
4 65 (27.66%) Analytics
5 54 (22.98%) Kimball Methodology
6 53 (22.55%) Data Modelling
7 51 (21.70%) Performance Tuning
8 33 (14.04%) Business Analysis
8 33 (14.04%) Dimensional Modelling
9 27 (11.49%) Risk Management
10 24 (10.21%) Benchmarking
11 23 (9.79%) Data Management
12 22 (9.36%) Scrum
13 20 (8.51%) Project Management
14 17 (7.23%) Data Architecture
14 17 (7.23%) Performance Management
15 15 (6.38%) Data Analytics
15 15 (6.38%) Inmon Methodology
15 15 (6.38%) Machine Learning
16 14 (5.96%) Data Transformation
Programming Languages
1 181 (77.02%) SQL
2 73 (31.06%) T-SQL
3 38 (16.17%) Java
4 32 (13.62%) C#
5 22 (9.36%) JavaScript
5 22 (9.36%) PL/SQL
5 22 (9.36%) Python
6 20 (8.51%) R
7 17 (7.23%) Data Analysis Expressions (DAX)
8 11 (4.68%) Scala
9 8 (3.40%) VB.NET
10 7 (2.98%) PHP
10 7 (2.98%) VBA
11 5 (2.13%) C
11 5 (2.13%) PowerShell
12 3 (1.28%) C++
12 3 (1.28%) XMLA
13 2 (0.85%) Bash Shell
14 1 (0.43%) Perl
14 1 (0.43%) VB
Qualifications
1 22 (9.36%) Degree
2 14 (5.96%) Microsoft Certification
3 6 (2.55%) MCSE
4 3 (1.28%) MCITP
5 2 (0.85%) CIMA
5 2 (0.85%) MCTS
6 1 (0.43%) ACCA
6 1 (0.43%) Postgraduate
Quality Assurance & Compliance
1 17 (7.23%) QA
2 14 (5.96%) Data Quality
3 2 (0.85%) SLA
4 1 (0.43%) Basel III
4 1 (0.43%) Dodd-Frank
System Software
1 24 (10.21%) Hyper-V
1 24 (10.21%) KVM
1 24 (10.21%) NFS
1 24 (10.21%) Oracle RAC
1 24 (10.21%) SRDF
1 24 (10.21%) VMware Infrastructure
1 24 (10.21%) Xen
2 7 (2.98%) Virtual Machines
3 3 (1.28%) Apache Flume
3 3 (1.28%) HDFS
Systems Management
1 3 (1.28%) ITRS Geneos
1 3 (1.28%) Oozie
Vendors
1 87 (37.02%) Microsoft
2 69 (29.36%) Oracle
3 48 (20.43%) Tableau
4 29 (12.34%) IBM
5 27 (11.49%) Cisco
6 24 (10.21%) EMC
6 24 (10.21%) Intel
6 24 (10.21%) NetApp
6 24 (10.21%) VMware
7 15 (6.38%) Cognos
8 9 (3.83%) Actian
9 7 (2.98%) Google
10 4 (1.70%) DataSynapse
10 4 (1.70%) Hyperion
10 4 (1.70%) MicroStrategy
10 4 (1.70%) Sybase
11 3 (1.28%) Bloomberg
11 3 (1.28%) Informatica
11 3 (1.28%) Reuters
11 3 (1.28%) TIBCO
City, London
Capital IT Resourcing LTD
Salary: £40000 - £45000 per annum + Benefits
Posted: Yesterday
City, London
The Bridge Ltd
Salary: From £60,000 to £80,000 per annum Pension Scheme, Life & Medical Insur
Posted: 11 hours ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: Yesterday
City, London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 2 days ago
City, London
Henderson Drake
Salary: From £28,000 to £40,000 per annum Bonus + Pension + Insurance + Dental
Posted: Yesterday
West London
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: £60000 Per Annum Plus excellent benefits
Posted: 4 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 10 days ago
London
Venturi
Salary: £40000.00 - £50000.00 per annum + Bonus & Benefits
Posted: 17 days ago