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

3 months to
2 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 485 386 381
Rank change year-on-year
-99 -5
Permanent jobs citing OLAP 177 313 346
As % of all permanent IT jobs located in London 0.42% 0.69% 0.70%
As % of the Database & Business Intelligence category 1.37% 2.21% 2.19%
Number of salaries quoted 127 263 267
Median salary £59,000 £62,500 £52,500
Median salary % change year-on-year
-5.60% +19.04%
90% offered a salary of more than £42,300 £46,300 £40,000
10% offered a salary of more than £77,000 £75,000 £70,000
UK excluding London median salary £46,000 £40,000 £41,500
% change year-on-year
+15.00% -3.61%
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
12966 14180 15791
As % of all permanent IT jobs located in London 30.73% 31.38% 31.75%
Number of salaries quoted 11355 12172 13503
Median salary £57,000 £55,000 £52,500
Median salary % change year-on-year
+3.63% +4.76%
90% offered a salary of more than £40,000 £39,000 £35,000
10% offered a salary of more than £80,000 £75,000 £80,000
UK excluding London median salary £42,500 £40,000 £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 2 May 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 2 May 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 -1 31 £60,000 -4.00% 6
Kingston Upon Thames - 3 £59,250 -
Teddington - 2 - -
Brentford +7 1 £62,500 +38.88%
Romford - 1 £82,500 -
Surbiton - 1 £57,500 -
Wimbledon - 1 - -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 2 May 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 278 (75.54%) Business Intelligence
2 249 (67.66%) Data Warehouse
3 241 (65.49%) SQL
4 240 (65.22%) SQL Server
5 199 (54.08%) ETL
6 198 (53.80%) SQL Server Analysis Services
7 193 (52.45%) SQL Server Integration Services
8 172 (46.74%) SQL Server Reporting Services
9 161 (43.75%) Microsoft
10 123 (33.42%) MS Excel
11 121 (32.88%) Finance
12 114 (30.98%) Agile Software Development
12 114 (30.98%) OLAP Cube
13 112 (30.43%) Kimball Methodology
14 106 (28.80%) MDX
15 94 (25.54%) Analytics
16 88 (23.91%) T-SQL
17 86 (23.37%) Oracle
17 86 (23.37%) Oracle OLAP
18 85 (23.10%) Data Modelling
19 83 (22.55%) Relational Database
20 82 (22.28%) SQL Server 2008
21 78 (21.20%) OLTP
22 73 (19.84%) SQL Server 2012
23 62 (16.85%) Dimensional Modelling
24 61 (16.58%) Performance Tuning
24 61 (16.58%) Analytical Skills
25 56 (15.22%) Banking
26 50 (13.59%) PL/SQL
26 50 (13.59%) Tableau

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 14 (3.80%) SharePoint
2 13 (3.53%) SAS
3 10 (2.72%) Tomcat
4 6 (1.63%) Apache
4 6 (1.63%) Apache Spark
4 6 (1.63%) Confluence
5 5 (1.36%) Apache Pig
6 4 (1.09%) Elasticsearch
6 4 (1.09%) Oracle Spatial
6 4 (1.09%) Oracle Workflow
7 3 (0.82%) Adobe Experience Manager
7 3 (0.82%) CMS
7 3 (0.82%) Drupal
7 3 (0.82%) IIS
7 3 (0.82%) Joomla!
7 3 (0.82%) OpenCms
7 3 (0.82%) WebSphere
7 3 (0.82%) WordPress
8 2 (0.54%) Node.js
8 2 (0.54%) Oracle HTTP Server
Applications
1 123 (33.42%) MS Excel
2 6 (1.63%) MS Office
3 5 (1.36%) SPSS
4 3 (0.82%) MS Visio
5 2 (0.54%) MS PowerPoint
6 1 (0.27%) Acrobat
6 1 (0.27%) MS Project
6 1 (0.27%) Spreadsheet
Business Applications
1 8 (2.17%) HFM
2 5 (1.36%) Cognos Business Intelligence
3 4 (1.09%) Cognos TM1
3 4 (1.09%) Unica
4 2 (0.54%) Cognos Controller
4 2 (0.54%) Cognos Planning
4 2 (0.54%) Oracle EBS
4 2 (0.54%) SAP BPC
5 1 (0.27%) Dynamics NAV
5 1 (0.27%) Hyperion Planning
Cloud Services
1 25 (6.79%) Microsoft Azure
2 13 (3.53%) Amazon AWS
3 4 (1.09%) Azure Machine Learning
3 4 (1.09%) IaaS
3 4 (1.09%) PaaS
3 4 (1.09%) SaaS
4 3 (0.82%) GitHub
Communications & Networking
1 4 (1.09%) HTTP
2 3 (0.82%) LAN
2 3 (0.82%) WAN
3 2 (0.54%) FCoE
3 2 (0.54%) Fibre Channel
3 2 (0.54%) Intranet
3 2 (0.54%) iSCSI
3 2 (0.54%) Multicast
3 2 (0.54%) NAS
3 2 (0.54%) SAN
4 1 (0.27%) DHCP
4 1 (0.27%) DNS
4 1 (0.27%) Network Security
4 1 (0.27%) Remote Desktop
4 1 (0.27%) TCP/IP
Database & Business Intelligence
1 249 (67.66%) Data Warehouse
2 240 (65.22%) SQL Server
3 198 (53.80%) SQL Server Analysis Services
4 193 (52.45%) SQL Server Integration Services
5 172 (46.74%) SQL Server Reporting Services
6 114 (30.98%) OLAP Cube
7 86 (23.37%) Oracle OLAP
8 83 (22.55%) Relational Database
9 82 (22.28%) SQL Server 2008
10 78 (21.20%) OLTP
11 73 (19.84%) SQL Server 2012
12 46 (12.50%) Microsoft Analysis Services
13 39 (10.60%) RDBMS
14 37 (10.05%) Big Data
15 35 (9.51%) PowerPivot
15 35 (9.51%) SQL Server 2014
16 33 (8.97%) MySQL
16 33 (8.97%) Oracle Database
17 30 (8.15%) QlikView
18 27 (7.34%) Power BI
Development Applications
1 18 (4.89%) Git (software)
2 9 (2.45%) Jenkins
3 8 (2.17%) JIRA
3 8 (2.17%) Team Foundation Server
4 7 (1.90%) Eclipse
5 5 (1.36%) Maven
5 5 (1.36%) Oracle Forms
6 2 (0.54%) JUnit
7 1 (0.27%) Talend Open Studio
7 1 (0.27%) Visual Studio
General
1 121 (32.88%) Finance
2 56 (15.22%) Banking
3 47 (12.77%) Marketing
4 41 (11.14%) Games
5 38 (10.33%) Investment Banking
6 18 (4.89%) Legal
6 18 (4.89%) Retail
7 17 (4.62%) Telecoms
8 14 (3.80%) Front Office
9 10 (2.72%) Financial Institution
10 8 (2.17%) Advertising
11 7 (1.90%) Publishing
12 6 (1.63%) Back Office
13 4 (1.09%) Law
14 1 (0.27%) Military
14 1 (0.27%) Pharmaceutical
Job Titles
1 199 (54.08%) Developer
2 131 (35.60%) Business Intelligence Developer
3 78 (21.20%) SSAS Developer
4 72 (19.57%) SQL Developer
5 59 (16.03%) SQL BI Developer
6 48 (13.04%) Analyst
7 47 (12.77%) Senior Developer
8 46 (12.50%) SSIS Developer
9 44 (11.96%) SSRS Developer
10 37 (10.05%) Data Warehouse Developer
11 36 (9.78%) DBA
12 34 (9.24%) Architect
13 31 (8.42%) SQL Server Developer
14 28 (7.61%) SQL Server BI Developer
15 27 (7.34%) Consultant
16 24 (6.52%) Business Intelligence Consultant
17 23 (6.25%) Data Analyst
17 23 (6.25%) Oracle Developer
18 21 (5.71%) Senior Business Intelligence Developer
19 20 (5.43%) Database Developer
Libraries, Frameworks & Software Standards
1 106 (28.80%) MDX
2 37 (10.05%) .NET
3 17 (4.62%) Oracle GoldenGate
3 17 (4.62%) Web Services
4 15 (4.08%) XML
5 9 (2.45%) jQuery
6 8 (2.17%) HTML
7 7 (1.90%) CSS
8 6 (1.63%) D3.js
8 6 (1.63%) JSON
9 5 (1.36%) J2EE
9 5 (1.36%) J2SE
9 5 (1.36%) RESTful
9 5 (1.36%) Spring
10 4 (1.09%) Leaflet
11 3 (0.82%) CSS3
11 3 (0.82%) Hibernate
11 3 (0.82%) HTML5
11 3 (0.82%) JSF
11 3 (0.82%) Middleware
Miscellaneous
1 61 (16.58%) Analytical Skills
2 35 (9.51%) Replication
3 29 (7.88%) Online Games
4 28 (7.61%) Credit Risk
5 24 (6.52%) Data Integration
5 24 (6.52%) Statistics
6 23 (6.25%) Computer Science
7 21 (5.71%) Visualisation
8 19 (5.16%) Enterprise Software
8 19 (5.16%) Management Information System
9 12 (3.26%) Economics
10 11 (2.99%) Clustering
10 11 (2.99%) Mathematics
11 9 (2.45%) Data Extraction
11 9 (2.45%) Reinsurance
12 6 (1.63%) Fintech
12 6 (1.63%) Mobile App
12 6 (1.63%) Neural Network
12 6 (1.63%) N-Tier
13 5 (1.36%) Hedge funds
Operating Systems
1 36 (9.78%) Linux
2 14 (3.80%) Oracle Linux
3 11 (2.99%) Windows
4 10 (2.72%) Unix
5 2 (0.54%) AIX
5 2 (0.54%) Solaris
6 1 (0.27%) Windows 7
6 1 (0.27%) Windows Server 2008
6 1 (0.27%) Windows Server 2012
6 1 (0.27%) Windows Vista
Processes & Methodologies
1 278 (75.54%) Business Intelligence
2 199 (54.08%) ETL
3 114 (30.98%) Agile Software Development
4 112 (30.43%) Kimball Methodology
5 94 (25.54%) Analytics
6 85 (23.10%) Data Modelling
7 62 (16.85%) Dimensional Modelling
8 61 (16.58%) Performance Tuning
9 38 (10.33%) SDLC
10 36 (9.78%) Data Management
11 31 (8.42%) Data Analysis
11 31 (8.42%) Scrum
12 30 (8.15%) Presales
13 26 (7.07%) Business Analysis
14 25 (6.79%) Data Architecture
14 25 (6.79%) Information Management
14 25 (6.79%) Open Source
15 24 (6.52%) E-Commerce
16 21 (5.71%) DNA
17 20 (5.43%) Marketing Analytics
Programming Languages
1 241 (65.49%) SQL
2 88 (23.91%) T-SQL
3 50 (13.59%) PL/SQL
4 38 (10.33%) C#
5 33 (8.97%) Java
6 28 (7.61%) C
7 17 (4.62%) Data Analysis Expressions (DAX)
8 16 (4.35%) Shell Script
9 15 (4.08%) JavaScript
9 15 (4.08%) Python
10 9 (2.45%) C++
10 9 (2.45%) R
11 8 (2.17%) VB.NET
12 7 (1.90%) Perl
13 6 (1.63%) PHP
14 4 (1.09%) VBA
15 2 (0.54%) PowerShell
15 2 (0.54%) Ruby
15 2 (0.54%) Scala
16 1 (0.27%) Clojure
Qualifications
1 45 (12.23%) Degree
2 8 (2.17%) ACCA
2 8 (2.17%) CIMA
3 5 (1.36%) Microsoft Certification
4 3 (0.82%) IBM Certification
5 2 (0.54%) AAT
5 2 (0.54%) ISEB
6 1 (0.27%) CIPFA
6 1 (0.27%) HND
6 1 (0.27%) ITIL Certification
6 1 (0.27%) MBA
6 1 (0.27%) MCDBA
Quality Assurance & Compliance
1 39 (10.60%) Data Quality
2 19 (5.16%) QA
3 8 (2.17%) PCI DSS
4 5 (1.36%) Sarbanes-Oxley
4 5 (1.36%) SLA
5 4 (1.09%) Basel II
6 2 (0.54%) COBIT
System Software
1 16 (4.35%) Oracle RAC
2 3 (0.82%) Varnish
2 3 (0.82%) VMware Infrastructure
3 2 (0.54%) Hyper-V
3 2 (0.54%) KVM
3 2 (0.54%) NFS
3 2 (0.54%) SRDF
3 2 (0.54%) Xen
4 1 (0.27%) Active Directory
4 1 (0.27%) Docker
4 1 (0.27%) Microsoft Virtual Server
Systems Management
1 16 (4.35%) Oracle Enterprise Manager
2 14 (3.80%) Data Guard
3 5 (1.36%) Mesos
4 3 (0.82%) Puppet
5 2 (0.54%) Cisco IPCC
5 2 (0.54%) Oracle RMAN
Vendors
1 161 (43.75%) Microsoft
2 86 (23.37%) Oracle
3 50 (13.59%) Tableau
4 25 (6.79%) Cognos
5 19 (5.16%) IBM
5 19 (5.16%) SAP
6 12 (3.26%) Hitachi
7 11 (2.99%) Sybase
8 10 (2.72%) Hyperion
9 9 (2.45%) Teradata
9 9 (2.45%) Vertica
10 6 (1.63%) Informatica
10 6 (1.63%) MicroStrategy
10 6 (1.63%) RedGate
11 5 (1.36%) Facebook
12 4 (1.09%) Adobe
12 4 (1.09%) Alterian
12 4 (1.09%) Apteco
12 4 (1.09%) hybris
12 4 (1.09%) Infor
London
Harvey Nash plc
Salary: £80000 per annum
Posted: 3 days ago
London
Lorien Resourcing
Salary: Excellent benefits
Posted: 4 days ago
Central London / West End
ANSON MCCADE
Salary: £35k - £60k plus attractive benefits and extensive career progression
Posted: 6 days ago
Central London / West End
ANSON MCCADE
Salary: £130,000- £160,000 + Bonus + Share Options etc
Posted: 6 days ago
Central London / West End
ANSON MCCADE
Salary: £70,000 - £90,000 plus attractive benefits, 30 days holiday and extens
Posted: 6 days ago
South West London
HAYS INFORMATION TECHNOLOGY
Salary: £50000.00 - £60000.00 per annum
Posted: 6 days ago
City of London
Lawrence Harvey
Salary: £55000.00 - £65000.00 per annum
Posted: 7 days ago
City of London
Hays London City Cheapside
Salary: £60000.00 - £80000.00 per annum
Posted: 10 days ago
City Of London
HFG
Salary: £55000 - £65000 per annum, Benefits: Bonus + Benefits
Posted: 13 days ago
London
Computer Futures
Salary: £80000 per annum + competitive
Posted: 13 days ago
City of London
Nigel Frank International Ltd
Salary: £50000 - £60000 per annum + Package and Benefits Scheme
Posted: 14 days ago
London
Computer Futures
Salary: £80000 per annum + competitive
Posted: 14 days ago
City of London
Deerfoot IT Resources Ltd
Salary: £60000 - £65000 per annum + Bonus and Benefits
Posted: 18 days ago
London
Computer Futures
Salary: £80000 per annum + competitive
Posted: 18 days ago
South East London
TFL
Salary: From £50,000 to £60,000 per annum + Excellent Benefits
Posted: 26 days ago