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

3 months to
30 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 480 435 316
Rank change year-on-year
-45 -119
Permanent jobs citing OLAP 138 234 420
As % of all permanent IT jobs located in London 0.35% 0.54% 0.91%
As % of the Database & Business Intelligence category 1.19% 1.81% 2.90%
Number of salaries quoted 112 179 355
Median salary £65,000 £57,500 £55,000
Median salary % change year-on-year
+13.04% +4.54%
90% offered a salary of more than £50,000 £42,500 £40,000
10% offered a salary of more than £95,000 £76,000 £75,000
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
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
11559 12953 14460
As % of all permanent IT jobs located in London 29.50% 29.87% 31.19%
Number of salaries quoted 10069 10960 12580
Median salary £60,000 £57,500 £52,500
Median salary % change year-on-year
+4.34% +9.52%
90% offered a salary of more than £40,000 £40,000 £36,600
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 30 August 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 30 August 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 +24 18 £80,000 +33.33%
Teddington - 1 - -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 30 August 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 232 (75.32%) Business Intelligence
2 228 (74.03%) SQL
3 201 (65.26%) SQL Server
4 197 (63.96%) Data Warehouse
5 156 (50.65%) ETL
6 133 (43.18%) SQL Server Analysis Services
7 122 (39.61%) SQL Server Reporting Services
8 119 (38.64%) Finance
9 115 (37.34%) SQL Server Integration Services
10 114 (37.01%) Microsoft
11 97 (31.49%) Agile Software Development
12 90 (29.22%) Oracle
12 90 (29.22%) T-SQL
12 90 (29.22%) Oracle OLAP
13 79 (25.65%) OLAP Cube
14 78 (25.32%) MS Excel
15 74 (24.03%) Kimball Methodology
16 70 (22.73%) Performance Tuning
17 69 (22.40%) OLTP
18 68 (22.08%) Analytics
19 64 (20.78%) MDX
20 57 (18.51%) Linux
20 57 (18.51%) Data Modelling
21 56 (18.18%) Analytical Skills
21 56 (18.18%) Tableau
22 54 (17.53%) Relational Database
23 52 (16.88%) Banking
24 48 (15.58%) SQL Server 2012
25 46 (14.94%) Windows
26 44 (14.29%) Microsoft Analysis Services

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 26 (8.44%) SAS
2 22 (7.14%) IIS
3 21 (6.82%) Apache
3 21 (6.82%) Tomcat
4 19 (6.17%) Apache Spark
5 18 (5.84%) Oracle Coherence
5 18 (5.84%) WebSphere
6 17 (5.52%) Oracle HTTP Server
7 16 (5.19%) SharePoint
8 6 (1.95%) Elasticsearch
9 4 (1.30%) Apache Pig
9 4 (1.30%) Oracle Spatial
9 4 (1.30%) Oracle Workflow
10 2 (0.65%) SharePoint 2013
11 1 (0.32%) Blackberry Enterprise Server
11 1 (0.32%) MS Exchange
Applications
1 78 (25.32%) MS Excel
2 9 (2.92%) MS Office
3 4 (1.30%) Gephi
3 4 (1.30%) SPSS
4 3 (0.97%) MS Visio
5 2 (0.65%) MS PowerPoint
5 2 (0.65%) Spreadsheet
6 1 (0.32%) Acrobat
6 1 (0.32%) MS Project
Business Applications
1 4 (1.30%) Unica
2 3 (0.97%) Cognos Business Intelligence
2 3 (0.97%) Cognos TM1
2 3 (0.97%) Dynamics NAV
3 2 (0.65%) Cognos Planning
3 2 (0.65%) HFM
3 2 (0.65%) Magento
3 2 (0.65%) SAP BPC
4 1 (0.32%) JDE EnterpriseOne
4 1 (0.32%) Oracle EBS
Cloud Services
1 16 (5.19%) Microsoft Azure
2 10 (3.25%) Amazon AWS
3 7 (2.27%) Azure Machine Learning
3 7 (2.27%) Data Lake Analytics
3 7 (2.27%) IaaS
3 7 (2.27%) PaaS
4 4 (1.30%) SaaS
5 2 (0.65%) GitHub
Communications & Networking
1 23 (7.47%) SAN
2 18 (5.84%) LAN
2 18 (5.84%) WAN
3 17 (5.52%) FCoE
3 17 (5.52%) Fibre Channel
3 17 (5.52%) HTTP
3 17 (5.52%) iSCSI
3 17 (5.52%) Multicast
3 17 (5.52%) NAS
4 2 (0.65%) DHCP
4 2 (0.65%) DNS
4 2 (0.65%) Intranet
4 2 (0.65%) TCP/IP
5 1 (0.32%) Asterisk PBX
5 1 (0.32%) Firewall
5 1 (0.32%) Network Security
5 1 (0.32%) PABX
5 1 (0.32%) Remote Desktop
5 1 (0.32%) VLAN
5 1 (0.32%) VoIP
Database & Business Intelligence
1 201 (65.26%) SQL Server
2 197 (63.96%) Data Warehouse
3 133 (43.18%) SQL Server Analysis Services
4 122 (39.61%) SQL Server Reporting Services
5 115 (37.34%) SQL Server Integration Services
6 90 (29.22%) Oracle OLAP
7 79 (25.65%) OLAP Cube
8 69 (22.40%) OLTP
9 54 (17.53%) Relational Database
10 48 (15.58%) SQL Server 2012
11 44 (14.29%) Microsoft Analysis Services
11 44 (14.29%) SQL Server 2008
12 42 (13.64%) Big Data
13 32 (10.39%) DB2
14 29 (9.42%) Hadoop
15 26 (8.44%) RDBMS
16 25 (8.12%) QlikView
17 24 (7.79%) Enterprise Data Warehouse
17 24 (7.79%) MySQL
17 24 (7.79%) Star Schema
Development Applications
1 11 (3.57%) Team Foundation Server
2 9 (2.92%) Visual Studio
3 7 (2.27%) Visual Studio Tools for Office
4 3 (0.97%) Eclipse
4 3 (0.97%) Git (software)
4 3 (0.97%) Maven
5 2 (0.65%) JIRA
5 2 (0.65%) Subversion
6 1 (0.32%) Gradle
6 1 (0.32%) Jenkins
6 1 (0.32%) Talend Open Studio
6 1 (0.32%) TeamCity
General
1 119 (38.64%) Finance
2 52 (16.88%) Banking
3 23 (7.47%) Marketing
4 20 (6.49%) Retail
5 19 (6.17%) Front Office
5 19 (6.17%) Telecoms
6 18 (5.84%) Games
6 18 (5.84%) Investment Banking
7 16 (5.19%) Legal
7 16 (5.19%) Manufacturing
8 11 (3.57%) Publishing
9 7 (2.27%) Back Office
10 6 (1.95%) Advertising
11 2 (0.65%) Financial Institution
11 2 (0.65%) Law
12 1 (0.32%) Billing
Job Titles
1 152 (49.35%) Developer
2 112 (36.36%) Business Intelligence Developer
3 53 (17.21%) Architect
4 46 (14.94%) SSAS Developer
5 45 (14.61%) SQL Developer
6 41 (13.31%) SQL BI Developer
7 36 (11.69%) Consultant
8 30 (9.74%) Data Architect
9 27 (8.77%) Business Intelligence Consultant
10 26 (8.44%) SQL Server Developer
10 26 (8.44%) SSIS Developer
10 26 (8.44%) SSRS Developer
11 25 (8.12%) Senior Developer
12 23 (7.47%) SQL Server BI Developer
13 21 (6.82%) Analyst
13 21 (6.82%) Lead Architect
14 19 (6.17%) DBA
15 17 (5.52%) ETL Developer
15 17 (5.52%) Infrastructure Architect
15 17 (5.52%) SAS Consultant
Libraries, Frameworks & Software Standards
1 64 (20.78%) MDX
2 19 (6.17%) .NET
3 18 (5.84%) Middleware
4 16 (5.19%) XML
5 13 (4.22%) D3.js
5 13 (4.22%) Web Services
6 12 (3.90%) HTML
7 11 (3.57%) Oracle GoldenGate
8 9 (2.92%) HTML5
9 7 (2.27%) Leaflet
10 6 (1.95%) Django
11 5 (1.62%) JSON
12 4 (1.30%) Akka
12 4 (1.30%) ASP.NET
12 4 (1.30%) J2SE
12 4 (1.30%) RESTful
13 3 (0.97%) CSS
13 3 (0.97%) jQuery
13 3 (0.97%) ODBC
13 3 (0.97%) Spring
Miscellaneous
1 56 (18.18%) Analytical Skills
2 32 (10.39%) Data Integration
3 26 (8.44%) Visualisation
4 22 (7.14%) Enterprise Software
5 20 (6.49%) Replication
6 18 (5.84%) Management Information System
7 16 (5.19%) Fintech
7 16 (5.19%) Statistics
8 13 (4.22%) Computer Science
8 13 (4.22%) Credit Risk
8 13 (4.22%) Data Extraction
9 11 (3.57%) Neural Network
10 10 (3.25%) Online Games
11 9 (2.92%) Mathematics
12 8 (2.60%) Economics
13 7 (2.27%) Clustering
13 7 (2.27%) Mobile App
14 6 (1.95%) Data Conversion
14 6 (1.95%) Hedge funds
15 5 (1.62%) Data Structures
Operating Systems
1 57 (18.51%) Linux
2 46 (14.94%) Windows
3 22 (7.14%) Unix
4 17 (5.52%) Solaris
5 8 (2.60%) Windows Server
6 7 (2.27%) Oracle Linux
7 5 (1.62%) Windows Server 2008
7 5 (1.62%) Windows Server 2012
8 1 (0.32%) CentOS
8 1 (0.32%) Windows 7
8 1 (0.32%) Windows Vista
Processes & Methodologies
1 232 (75.32%) Business Intelligence
2 156 (50.65%) ETL
3 97 (31.49%) Agile Software Development
4 74 (24.03%) Kimball Methodology
5 70 (22.73%) Performance Tuning
6 68 (22.08%) Analytics
7 57 (18.51%) Data Modelling
8 44 (14.29%) Dimensional Modelling
9 36 (11.69%) Business Analysis
10 34 (11.04%) SDLC
11 32 (10.39%) Project Management
12 29 (9.42%) Data Management
13 26 (8.44%) Data Architecture
14 23 (7.47%) DNA
15 22 (7.14%) Scrum
16 19 (6.17%) Risk Management
17 18 (5.84%) Benchmarking
17 18 (5.84%) CRM
18 17 (5.52%) Data Analytics
18 17 (5.52%) Presales
Programming Languages
1 228 (74.03%) SQL
2 90 (29.22%) T-SQL
3 36 (11.69%) Java
4 28 (9.09%) JavaScript
5 27 (8.77%) C#
5 27 (8.77%) PL/SQL
5 27 (8.77%) Python
6 17 (5.52%) Data Analysis Expressions (DAX)
7 14 (4.55%) C
8 12 (3.90%) R
9 9 (2.92%) PowerShell
10 8 (2.60%) PHP
11 7 (2.27%) Shell Script
11 7 (2.27%) VBA
12 6 (1.95%) Scala
13 4 (1.30%) C++
13 4 (1.30%) VB.NET
14 3 (0.97%) Bash Shell
14 3 (0.97%) Perl
14 3 (0.97%) XMLA
Qualifications
1 33 (10.71%) Degree
2 5 (1.62%) Microsoft Certification
3 3 (0.97%) ACCA
3 3 (0.97%) CIMA
3 3 (0.97%) IBM Certification
4 2 (0.65%) AAT
5 1 (0.32%) HND
5 1 (0.32%) ITIL Certification
5 1 (0.32%) MBA
5 1 (0.32%) MCITP
5 1 (0.32%) MCSE
Quality Assurance & Compliance
1 31 (10.06%) Data Quality
2 20 (6.49%) QA
3 3 (0.97%) SLA
4 1 (0.32%) Basel II
System Software
1 24 (7.79%) Oracle RAC
2 18 (5.84%) KVM
2 18 (5.84%) VMware Infrastructure
3 17 (5.52%) Hyper-V
3 17 (5.52%) NFS
3 17 (5.52%) SRDF
3 17 (5.52%) Xen
4 7 (2.27%) Virtual Machines
5 2 (0.65%) Apache Flume
5 2 (0.65%) HDFS
6 1 (0.32%) Active Directory
6 1 (0.32%) Microsoft Virtual Server
6 1 (0.32%) Virtual Servers
6 1 (0.32%) VirtualBox
Systems Management
1 7 (2.27%) Data Guard
1 7 (2.27%) Oracle Enterprise Manager
2 4 (1.30%) Mesos
3 2 (0.65%) Cisco IPCC
3 2 (0.65%) ITRS Geneos
3 2 (0.65%) Oozie
Vendors
1 114 (37.01%) Microsoft
2 90 (29.22%) Oracle
3 56 (18.18%) Tableau
4 27 (8.77%) IBM
5 19 (6.17%) Cognos
6 18 (5.84%) VMware
7 17 (5.52%) Cisco
7 17 (5.52%) EMC
7 17 (5.52%) Intel
7 17 (5.52%) NetApp
8 10 (3.25%) Sybase
9 9 (2.92%) SAP
10 6 (1.95%) Informatica
11 5 (1.62%) Google
11 5 (1.62%) Teradata
11 5 (1.62%) Vertica
12 4 (1.30%) Actian
12 4 (1.30%) Alterian
12 4 (1.30%) Apteco
13 3 (0.97%) Salesforce.com
London
Lawrence Harvey Enterprise
Salary: £50000.00 - £60000.00 per annum + pension, health care, discounts
Posted: 4 days ago
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 3 days ago
Central London / West End
Gamesys
Posted: 3 days ago
London
Stafford-Sharp Associates
Salary: £400 - £475 per day
Posted: 4 days ago
London
Nicoll Curtin
Salary: £80000.00 - £115000.00 per annum + Package
Posted: 3 days ago
London
Lawrence Harvey Enterprise
Salary: £50000.00 - £85000.00 per annum + bonus + benefits
Posted: 5 days ago
London
Accenture
Posted: 12 days ago
Sutton, London UK
Reed Business Information
Salary: Competitive Salary + bonus + benefits
Posted: 14 days ago