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

3 months to
27 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 471 441 321
Rank change year-on-year
-30 -120
Permanent jobs citing OLAP 151 224 429
As % of all permanent IT jobs located in London 0.38% 0.50% 0.89%
As % of the Database & Business Intelligence category 1.32% 1.63% 2.83%
Number of salaries quoted 115 177 363
Median salary £65,000 £60,000 £57,500
Median salary % change year-on-year
+8.33% +4.34%
90% offered a salary of more than £50,000 £42,500 £40,000
10% offered a salary of more than £90,000 £80,000 £72,500
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
11476 13768 15137
As % of all permanent IT jobs located in London 29.12% 30.97% 31.48%
Number of salaries quoted 9957 11638 13182
Median salary £57,500 £57,500 £55,000
Median salary % change year-on-year
- +4.54%
90% offered a salary of more than £40,000 £38,500 £37,000
10% offered a salary of more than £82,500 £75,000 £80,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 27 July 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 27 July 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 +34 26 £67,125 +16.73% 4
Teddington - 3 £52,500 -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 27 July 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 246 (76.40%) Business Intelligence
2 228 (70.81%) SQL
3 211 (65.53%) SQL Server
4 209 (64.91%) Data Warehouse
5 174 (54.04%) ETL
6 139 (43.17%) SQL Server Reporting Services
7 138 (42.86%) SQL Server Analysis Services
8 130 (40.37%) SQL Server Integration Services
9 117 (36.34%) Microsoft
10 113 (35.09%) Finance
11 104 (32.30%) Agile Software Development
12 95 (29.50%) Oracle
12 95 (29.50%) Oracle OLAP
13 84 (26.09%) OLAP Cube
14 82 (25.47%) MS Excel
15 80 (24.84%) Kimball Methodology
16 79 (24.53%) T-SQL
17 78 (24.22%) OLTP
18 76 (23.60%) Analytics
19 68 (21.12%) Performance Tuning
20 63 (19.57%) Relational Database
21 62 (19.25%) Data Modelling
21 62 (19.25%) Analytical Skills
22 61 (18.94%) MDX
23 59 (18.32%) SQL Server 2012
24 57 (17.70%) SQL Server 2008
25 50 (15.53%) Dimensional Modelling
25 50 (15.53%) Tableau
26 49 (15.22%) Banking
26 49 (15.22%) Linux

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 21 (6.52%) SAS
2 16 (4.97%) Apache
2 16 (4.97%) SharePoint
2 16 (4.97%) Tomcat
3 15 (4.66%) IIS
4 13 (4.04%) WebSphere
5 12 (3.73%) Apache Spark
5 12 (3.73%) Oracle Coherence
5 12 (3.73%) Oracle HTTP Server
6 6 (1.86%) Elasticsearch
7 4 (1.24%) Apache Pig
7 4 (1.24%) Confluence
7 4 (1.24%) Oracle Spatial
7 4 (1.24%) Oracle Workflow
8 2 (0.62%) SharePoint 2013
9 1 (0.31%) Blackberry Enterprise Server
9 1 (0.31%) MS Exchange
Applications
1 82 (25.47%) MS Excel
2 8 (2.48%) MS Office
3 3 (0.93%) Gephi
3 3 (0.93%) MS Visio
3 3 (0.93%) SPSS
4 2 (0.62%) MS PowerPoint
4 2 (0.62%) Spreadsheet
5 1 (0.31%) Acrobat
5 1 (0.31%) MS Project
Business Applications
1 4 (1.24%) Unica
2 3 (0.93%) Cognos Business Intelligence
2 3 (0.93%) Cognos TM1
3 2 (0.62%) Cognos Planning
3 2 (0.62%) HFM
3 2 (0.62%) SAP BPC
4 1 (0.31%) Dynamics NAV
4 1 (0.31%) JDE EnterpriseOne
4 1 (0.31%) Oracle EBS
Cloud Services
1 20 (6.21%) Microsoft Azure
2 16 (4.97%) Amazon AWS
3 7 (2.17%) Azure Machine Learning
3 7 (2.17%) Data Lake Analytics
3 7 (2.17%) IaaS
3 7 (2.17%) PaaS
4 5 (1.55%) SaaS
5 2 (0.62%) GitHub
Communications & Networking
1 17 (5.28%) SAN
2 13 (4.04%) HTTP
2 13 (4.04%) LAN
2 13 (4.04%) WAN
3 12 (3.73%) FCoE
3 12 (3.73%) Fibre Channel
3 12 (3.73%) iSCSI
3 12 (3.73%) Multicast
3 12 (3.73%) NAS
4 2 (0.62%) DHCP
4 2 (0.62%) DNS
4 2 (0.62%) Intranet
4 2 (0.62%) TCP/IP
5 1 (0.31%) Asterisk PBX
5 1 (0.31%) Firewall
5 1 (0.31%) Network Security
5 1 (0.31%) PABX
5 1 (0.31%) Remote Desktop
5 1 (0.31%) VLAN
5 1 (0.31%) VoIP
Database & Business Intelligence
1 211 (65.53%) SQL Server
2 209 (64.91%) Data Warehouse
3 139 (43.17%) SQL Server Reporting Services
4 138 (42.86%) SQL Server Analysis Services
5 130 (40.37%) SQL Server Integration Services
6 95 (29.50%) Oracle OLAP
7 84 (26.09%) OLAP Cube
8 78 (24.22%) OLTP
9 63 (19.57%) Relational Database
10 59 (18.32%) SQL Server 2012
11 57 (17.70%) SQL Server 2008
12 41 (12.73%) Big Data
13 40 (12.42%) Microsoft Analysis Services
14 33 (10.25%) MySQL
14 33 (10.25%) RDBMS
15 28 (8.70%) DB2
16 25 (7.76%) PowerPivot
16 25 (7.76%) SQL Server 2014
17 24 (7.45%) Hadoop
18 23 (7.14%) Oracle Database
Development Applications
1 10 (3.11%) Git (software)
1 10 (3.11%) Team Foundation Server
2 9 (2.80%) Visual Studio
3 7 (2.17%) Visual Studio Tools for Office
4 6 (1.86%) Jenkins
4 6 (1.86%) JIRA
5 5 (1.55%) Eclipse
6 1 (0.31%) JUnit
6 1 (0.31%) Maven
6 1 (0.31%) Subversion
6 1 (0.31%) Talend Open Studio
General
1 113 (35.09%) Finance
2 49 (15.22%) Banking
3 30 (9.32%) Marketing
4 23 (7.14%) Games
5 21 (6.52%) Investment Banking
5 21 (6.52%) Telecoms
6 19 (5.90%) Retail
7 18 (5.59%) Front Office
8 14 (4.35%) Legal
9 11 (3.42%) Manufacturing
9 11 (3.42%) Publishing
10 7 (2.17%) Back Office
11 6 (1.86%) Advertising
12 2 (0.62%) Financial Institution
12 2 (0.62%) Law
13 1 (0.31%) Billing
13 1 (0.31%) Pharmaceutical
Job Titles
1 155 (48.14%) Developer
2 114 (35.40%) Business Intelligence Developer
3 56 (17.39%) SQL Developer
4 51 (15.84%) SSAS Developer
5 49 (15.22%) Architect
5 49 (15.22%) SQL BI Developer
6 34 (10.56%) Consultant
7 32 (9.94%) Analyst
8 31 (9.63%) SSRS Developer
9 29 (9.01%) SQL Server Developer
10 27 (8.39%) Data Architect
10 27 (8.39%) SSIS Developer
11 26 (8.07%) Senior Developer
11 26 (8.07%) SQL Server BI Developer
12 25 (7.76%) DBA
13 24 (7.45%) Business Intelligence Consultant
14 20 (6.21%) Oracle Developer
15 15 (4.66%) Data Warehouse Developer
15 15 (4.66%) Lead Architect
16 14 (4.35%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 61 (18.94%) MDX
2 27 (8.39%) .NET
3 14 (4.35%) HTML
4 13 (4.04%) Middleware
4 13 (4.04%) Web Services
4 13 (4.04%) XML
5 12 (3.73%) D3.js
5 12 (3.73%) Oracle GoldenGate
6 9 (2.80%) HTML5
7 7 (2.17%) Leaflet
8 6 (1.86%) Django
8 6 (1.86%) jQuery
9 5 (1.55%) ASP.NET
9 5 (1.55%) CSS
9 5 (1.55%) JSON
10 4 (1.24%) J2SE
10 4 (1.24%) RESTful
11 3 (0.93%) ODBC
12 2 (0.62%) SVG
13 1 (0.31%) WebSphere MQ
Miscellaneous
1 62 (19.25%) Analytical Skills
2 35 (10.87%) Data Integration
3 25 (7.76%) Replication
4 24 (7.45%) Enterprise Software
4 24 (7.45%) Management Information System
5 23 (7.14%) Statistics
6 17 (5.28%) Visualisation
7 16 (4.97%) Credit Risk
7 16 (4.97%) Fintech
8 15 (4.66%) Computer Science
9 14 (4.35%) Online Games
10 12 (3.73%) Data Extraction
11 11 (3.42%) Clustering
12 10 (3.11%) Economics
12 10 (3.11%) Mathematics
12 10 (3.11%) Neural Network
13 7 (2.17%) Mobile App
14 5 (1.55%) Data Conversion
14 5 (1.55%) Hedge funds
14 5 (1.55%) N-Tier
Operating Systems
1 49 (15.22%) Linux
2 36 (11.18%) Windows
3 16 (4.97%) Unix
4 12 (3.73%) Solaris
5 8 (2.48%) Oracle Linux
6 6 (1.86%) Windows Server
7 5 (1.55%) Windows Server 2008
7 5 (1.55%) Windows Server 2012
8 1 (0.31%) CentOS
8 1 (0.31%) Windows 7
8 1 (0.31%) Windows Vista
Processes & Methodologies
1 246 (76.40%) Business Intelligence
2 174 (54.04%) ETL
3 104 (32.30%) Agile Software Development
4 80 (24.84%) Kimball Methodology
5 76 (23.60%) Analytics
6 68 (21.12%) Performance Tuning
7 62 (19.25%) Data Modelling
8 50 (15.53%) Dimensional Modelling
9 38 (11.80%) Business Analysis
10 32 (9.94%) Data Management
10 32 (9.94%) SDLC
11 29 (9.01%) Data Architecture
12 27 (8.39%) DNA
12 27 (8.39%) Project Management
13 24 (7.45%) Presales
14 23 (7.14%) Scrum
15 20 (6.21%) Data Analysis
16 19 (5.90%) ITIL
17 17 (5.28%) Performance Management
17 17 (5.28%) Waterfall
Programming Languages
1 228 (70.81%) SQL
2 79 (24.53%) T-SQL
3 36 (11.18%) PL/SQL
4 33 (10.25%) Java
5 31 (9.63%) C#
6 28 (8.70%) JavaScript
7 26 (8.07%) Python
8 18 (5.59%) Data Analysis Expressions (DAX)
9 16 (4.97%) C
10 12 (3.73%) R
11 9 (2.80%) C++
11 9 (2.80%) PHP
12 8 (2.48%) PowerShell
12 8 (2.48%) Shell Script
12 8 (2.48%) VBA
13 6 (1.86%) Perl
14 4 (1.24%) VB.NET
15 3 (0.93%) Bash Shell
16 2 (0.62%) Scala
17 1 (0.31%) VBScript
Qualifications
1 39 (12.11%) Degree
2 3 (0.93%) ACCA
2 3 (0.93%) CIMA
2 3 (0.93%) IBM Certification
2 3 (0.93%) Microsoft Certification
3 2 (0.62%) AAT
4 1 (0.31%) HND
4 1 (0.31%) ITIL Certification
4 1 (0.31%) MBA
4 1 (0.31%) MCITP
4 1 (0.31%) MCSE
Quality Assurance & Compliance
1 43 (13.35%) Data Quality
2 22 (6.83%) QA
3 5 (1.55%) PCI DSS
4 4 (1.24%) Basel II
5 3 (0.93%) SLA
System Software
1 20 (6.21%) Oracle RAC
2 13 (4.04%) KVM
2 13 (4.04%) VMware Infrastructure
3 12 (3.73%) Hyper-V
3 12 (3.73%) NFS
3 12 (3.73%) SRDF
3 12 (3.73%) Xen
4 7 (2.17%) Virtual Machines
5 1 (0.31%) Active Directory
5 1 (0.31%) Microsoft Virtual Server
5 1 (0.31%) Virtual Servers
5 1 (0.31%) VirtualBox
Systems Management
1 8 (2.48%) Data Guard
1 8 (2.48%) Oracle Enterprise Manager
2 4 (1.24%) Mesos
3 2 (0.62%) Cisco IPCC
4 1 (0.31%) ITRS Geneos
4 1 (0.31%) Puppet
Vendors
1 117 (36.34%) Microsoft
2 95 (29.50%) Oracle
3 50 (15.53%) Tableau
4 26 (8.07%) IBM
5 21 (6.52%) Cognos
6 13 (4.04%) VMware
7 12 (3.73%) Cisco
7 12 (3.73%) EMC
7 12 (3.73%) Intel
7 12 (3.73%) NetApp
8 10 (3.11%) SAP
9 9 (2.80%) Sybase
10 8 (2.48%) Vertica
11 6 (1.86%) Teradata
12 5 (1.55%) Facebook
12 5 (1.55%) Informatica
13 4 (1.24%) Alterian
13 4 (1.24%) Apteco
13 4 (1.24%) Hitachi
14 3 (0.93%) Salesforce.com
London
Lorien Resourcing
Salary: £65000 per annum
Posted: Yesterday
South East London
Vantage Recruitment Solutions Ltd
Salary: From £55,000 to £65,000 per annum Bonus, Pension, Training, Healthcare
Posted: 2 days ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 3 days ago
London
Big Wednesday Digital Ltd
Posted: 2 days ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 3 days ago
London
Lorien Resourcing
Posted: 4 days ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 2 days ago
City of London
Hays London City Cheapside
Salary: £50000.00 - £65000.00 per annum
Posted: 14 days ago
City of London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + bonus, pension, flexible working
Posted: 13 days ago
London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 9 days ago
City, London
DCV Technologies
Salary: From £65,000 to £70,000 per annum Plus Benefits
Posted: 6 days ago
London - Mornington Crescent
ASOS
Posted: 22 days ago
City of London
Modis International Ltd
Salary: £70000 per annum
Posted: 23 days ago