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

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
England / London
Rank 493 442 392
Rank change year-on-year
-51 -50
Permanent jobs citing OLAP 97 203 263
As % of all permanent IT jobs located in London 0.29% 0.50% 0.64%
As % of the Database & Business Intelligence category 0.97% 1.59% 2.11%
Number of salaries quoted 80 171 215
Median salary £60,000 £57,500 £60,000
Median salary % change year-on-year
+4.34% -4.16%
90% offered a salary of more than £45,000 £42,500 £35,000
10% offered a salary of more than £74,250 £75,000 £77,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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
9962 12803 12462
As % of all permanent IT jobs located in London 29.91% 31.50% 30.18%
Number of salaries quoted 8776 11070 10736
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
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 £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 19 January 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 19 January 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 +6 17 £55,000 - 5
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 19 January 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 163 (78.37%) SQL
2 143 (68.75%) Data Warehouse
3 138 (66.35%) SQL Server
4 133 (63.94%) Business Intelligence
5 112 (53.85%) SQL Server Analysis Services
6 92 (44.23%) SQL Server Integration Services
7 89 (42.79%) SQL Server Reporting Services
7 89 (42.79%) ETL
8 82 (39.42%) Finance
9 75 (36.06%) Microsoft
10 71 (34.13%) T-SQL
11 57 (27.40%) Agile Software Development
12 56 (26.92%) Analytics
13 53 (25.48%) MS Excel
14 52 (25.00%) Data Modelling
14 52 (25.00%) Oracle
14 52 (25.00%) Oracle OLAP
15 47 (22.60%) Kimball Methodology
16 46 (22.12%) MDX
17 42 (20.19%) Tableau
18 41 (19.71%) Big Data
19 40 (19.23%) OLTP
20 39 (18.75%) Windows
20 39 (18.75%) Linux
20 39 (18.75%) OLAP Cube
21 38 (18.27%) Performance Tuning
21 38 (18.27%) SQL Server 2012
22 36 (17.31%) Relational Database
23 35 (16.83%) Power BI
23 35 (16.83%) QlikView

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 24 (11.54%) Apache
2 22 (10.58%) IIS
3 21 (10.10%) Oracle Coherence
4 20 (9.62%) Oracle HTTP Server
4 20 (9.62%) Tomcat
4 20 (9.62%) WebSphere
5 18 (8.65%) SharePoint
6 17 (8.17%) Apache Spark
7 14 (6.73%) SAS
8 3 (1.44%) Apache Pig
9 2 (0.96%) SharePoint 2013
10 1 (0.48%) Apache Airflow
10 1 (0.48%) Apache Solr
10 1 (0.48%) Elasticsearch
Applications
1 53 (25.48%) MS Excel
2 5 (2.40%) MS Office
3 3 (1.44%) MS Visio
4 2 (0.96%) Gephi
5 1 (0.48%) MS PowerPoint
5 1 (0.48%) SPSS
Business Applications
1 3 (1.44%) Cognos TM1
2 2 (0.96%) Adobe Campaign
2 2 (0.96%) Dynamics CRM
2 2 (0.96%) Dynamics NAV
2 2 (0.96%) Eloqua
2 2 (0.96%) Magento
2 2 (0.96%) Unica
Cloud Services
1 22 (10.58%) Microsoft Azure
2 7 (3.37%) Azure Machine Learning
2 7 (3.37%) Data Lake Analytics
3 3 (1.44%) Google Cloud Platform
3 3 (1.44%) IaaS
4 2 (0.96%) Amazon AWS
4 2 (0.96%) PaaS
4 2 (0.96%) Responsys
5 1 (0.48%) Amazon Kinesis
5 1 (0.48%) Google Play
5 1 (0.48%) SaaS
Communications & Networking
1 23 (11.06%) SAN
2 20 (9.62%) FCoE
2 20 (9.62%) Fibre Channel
2 20 (9.62%) HTTP
2 20 (9.62%) iSCSI
2 20 (9.62%) LAN
2 20 (9.62%) Multicast
2 20 (9.62%) NAS
2 20 (9.62%) WAN
3 3 (1.44%) Internet
3 3 (1.44%) SSL
Database & Business Intelligence
1 143 (68.75%) Data Warehouse
2 138 (66.35%) SQL Server
3 112 (53.85%) SQL Server Analysis Services
4 92 (44.23%) SQL Server Integration Services
5 89 (42.79%) SQL Server Reporting Services
6 52 (25.00%) Oracle OLAP
7 41 (19.71%) Big Data
8 40 (19.23%) OLTP
9 39 (18.75%) OLAP Cube
10 38 (18.27%) SQL Server 2012
11 36 (17.31%) Relational Database
12 35 (16.83%) Power BI
12 35 (16.83%) QlikView
13 31 (14.90%) Hadoop
14 30 (14.42%) Microsoft Analysis Services
15 27 (12.98%) DB2
16 23 (11.06%) SQL Server 2016
17 22 (10.58%) RDBMS
18 18 (8.65%) HBase
18 18 (8.65%) SQL Server 2008
Development Applications
1 8 (3.85%) Team Foundation Server
1 8 (3.85%) Visual Studio
2 5 (2.40%) JIRA
2 5 (2.40%) Maven
3 3 (1.44%) Git (software)
3 3 (1.44%) PowerDesigner
4 2 (0.96%) Oracle Forms
4 2 (0.96%) Visual Studio Tools for Office
5 1 (0.48%) Gradle
5 1 (0.48%) Subversion
5 1 (0.48%) TeamCity
General
1 82 (39.42%) Finance
2 27 (12.98%) Banking
3 17 (8.17%) Legal
4 11 (5.29%) Investment Banking
5 10 (4.81%) Marketing
5 10 (4.81%) Retail
6 7 (3.37%) Games
6 7 (3.37%) Manufacturing
7 5 (2.40%) Financial Institution
8 4 (1.92%) Advertising
8 4 (1.92%) Automotive
8 4 (1.92%) German Language
8 4 (1.92%) Publishing
8 4 (1.92%) Spanish Language
9 3 (1.44%) Music Industry
9 3 (1.44%) Telecoms
10 2 (0.96%) Front Office
11 1 (0.48%) Law
11 1 (0.48%) Local Government
Job Titles
1 98 (47.12%) Developer
2 53 (25.48%) Business Intelligence Developer
3 33 (15.87%) Architect
4 28 (13.46%) Consultant
4 28 (13.46%) Senior Developer
5 26 (12.50%) SQL Developer
6 25 (12.02%) SSIS Developer
7 24 (11.54%) SSAS Developer
8 23 (11.06%) Business Intelligence Consultant
9 22 (10.58%) Lead Architect
10 20 (9.62%) Infrastructure Architect
10 20 (9.62%) OLAP Developer
10 20 (9.62%) SSRS Developer
11 16 (7.69%) Analyst
12 14 (6.73%) Data Warehouse Developer
12 14 (6.73%) ETL Developer
13 13 (6.25%) Business Developer
14 12 (5.77%) Senior Business Intelligence Developer
14 12 (5.77%) SQL BI Developer
14 12 (5.77%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 46 (22.12%) MDX
2 32 (15.38%) .NET
3 23 (11.06%) XML
4 20 (9.62%) Middleware
5 18 (8.65%) Web Services
6 12 (5.77%) JSON
7 11 (5.29%) Oracle GoldenGate
8 10 (4.81%) Akka
9 8 (3.85%) Spring
10 7 (3.37%) HTML
11 5 (2.40%) SOAP
12 4 (1.92%) D3.js
12 4 (1.92%) HTML5
13 3 (1.44%) ASP.NET
13 3 (1.44%) J2EE
13 3 (1.44%) REST
13 3 (1.44%) WSDL
14 2 (0.96%) .NET Framework
14 2 (0.96%) CSS
14 2 (0.96%) JDBC
Miscellaneous
1 25 (12.02%) Visualisation
2 17 (8.17%) Analytical Skills
3 15 (7.21%) Replication
4 12 (5.77%) Fintech
5 10 (4.81%) Management Information System
6 8 (3.85%) Data Integration
6 8 (3.85%) Mobile App
7 6 (2.88%) Economics
7 6 (2.88%) Statistics
8 5 (2.40%) Clustering
8 5 (2.40%) Computer Science
9 4 (1.92%) Derivative
9 4 (1.92%) Neural Network
10 3 (1.44%) Data Centre
10 3 (1.44%) Data Extraction
10 3 (1.44%) Data Structures
10 3 (1.44%) Enterprise Software
10 3 (1.44%) Fixed Income
10 3 (1.44%) Online Games
11 2 (0.96%) Virtual Team
Operating Systems
1 39 (18.75%) Linux
1 39 (18.75%) Windows
2 20 (9.62%) Solaris
3 14 (6.73%) Unix
4 5 (2.40%) Windows Server
5 1 (0.48%) Android
5 1 (0.48%) Apple iOS
5 1 (0.48%) Windows Server 2008
5 1 (0.48%) Windows Server 2012
Processes & Methodologies
1 133 (63.94%) Business Intelligence
2 89 (42.79%) ETL
3 57 (27.40%) Agile Software Development
4 56 (26.92%) Analytics
5 52 (25.00%) Data Modelling
6 47 (22.60%) Kimball Methodology
7 38 (18.27%) Performance Tuning
8 30 (14.42%) Dimensional Modelling
9 24 (11.54%) Data Analytics
10 23 (11.06%) Risk Management
11 20 (9.62%) Benchmarking
12 19 (9.13%) Business Analysis
13 18 (8.65%) Scrum
14 14 (6.73%) Data Management
14 14 (6.73%) Data Visualisation
15 13 (6.25%) Performance Management
16 12 (5.77%) Data Transformation
16 12 (5.77%) Inmon Methodology
17 11 (5.29%) ETL Development
17 11 (5.29%) Logical Data Model
Programming Languages
1 163 (78.37%) SQL
2 71 (34.13%) T-SQL
3 32 (15.38%) Java
4 25 (12.02%) C#
5 22 (10.58%) PL/SQL
6 17 (8.17%) Data Analysis Expressions (DAX)
7 13 (6.25%) Python
7 13 (6.25%) R
8 12 (5.77%) JavaScript
9 10 (4.81%) Scala
10 6 (2.88%) VB.NET
11 5 (2.40%) C
11 5 (2.40%) PHP
11 5 (2.40%) VBA
12 3 (1.44%) C++
12 3 (1.44%) PowerShell
12 3 (1.44%) XMLA
13 2 (0.96%) Data Mining Extensions (DMX)
14 1 (0.48%) VB
Qualifications
1 17 (8.17%) Degree
2 16 (7.69%) Microsoft Certification
3 5 (2.40%) MCSE
4 3 (1.44%) CIMA
5 2 (0.96%) MCITP
5 2 (0.96%) MCTS
6 1 (0.48%) ACCA
6 1 (0.48%) Postgraduate
Quality Assurance & Compliance
1 16 (7.69%) QA
2 13 (6.25%) Data Quality
3 2 (0.96%) SLA
4 1 (0.48%) Basel III
4 1 (0.48%) Dodd-Frank
System Software
1 20 (9.62%) Hyper-V
1 20 (9.62%) KVM
1 20 (9.62%) NFS
1 20 (9.62%) Oracle RAC
1 20 (9.62%) SRDF
1 20 (9.62%) VMware Infrastructure
1 20 (9.62%) Xen
2 3 (1.44%) Apache Flume
2 3 (1.44%) HDFS
3 2 (0.96%) Virtual Machines
Systems Management
1 3 (1.44%) Oozie
2 2 (0.96%) ITRS Geneos
3 1 (0.48%) Kibana
Vendors
1 75 (36.06%) Microsoft
2 52 (25.00%) Oracle
3 42 (20.19%) Tableau
4 23 (11.06%) Cisco
4 23 (11.06%) IBM
5 20 (9.62%) EMC
5 20 (9.62%) Intel
5 20 (9.62%) NetApp
5 20 (9.62%) VMware
6 11 (5.29%) Cognos
7 10 (4.81%) Actian
8 6 (2.88%) Google
8 6 (2.88%) Sybase
9 4 (1.92%) Hyperion
9 4 (1.92%) MicroStrategy
10 3 (1.44%) DataSynapse
10 3 (1.44%) Greenplum
10 3 (1.44%) Informatica
11 2 (0.96%) Cloudera
11 2 (0.96%) Hortonworks
City, London
I3
Salary: £55000 - £70000 per annum + benefits + bonus
Posted: Yesterday
London
HFG
Salary: £40000 - £60000 per annum, Benefits + bonus + benefits
Posted: 2 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + stock options
Posted: 8 hours ago
London
Premier IT
Salary: £45000 - £60000 per annum
Posted: 2 days ago
City, London
Henderson Drake
Salary: From £34,000 to £40,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 3 days ago
City, London
ANSON MCCADE
Salary: £45,000 - £70,000 + extensive benefits package
Posted: 2 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 8 days ago
London
Lawrence Harvey
Salary: £50000 - £55000 per annum + Benefits
Posted: 16 days ago
London
Lawrence Harvey
Salary: £55000 - £60000 per annum + Benefits
Posted: 16 days ago
City of London
Lawrence Harvey
Salary: £45000.00 - £60000.00 per annum
Posted: 16 days ago