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

3 months to
26 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 469 432 353
Rank change year-on-year
-37 -79
Permanent jobs citing OLAP 166 246 416
As % of all permanent IT jobs located in London 0.42% 0.55% 0.83%
As % of the Database & Business Intelligence category 1.43% 1.71% 2.61%
Number of salaries quoted 119 203 352
Median salary £60,000 £60,000 £55,000
Median salary % change year-on-year
- +9.09%
90% offered a salary of more than £46,850 £45,000 £40,000
10% offered a salary of more than £80,000 £80,000 £70,000
UK excluding London median salary £46,750 £40,000 £42,500
% change year-on-year
+16.87% -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
11600 14382 15929
As % of all permanent IT jobs located in London 29.43% 32.14% 31.72%
Number of salaries quoted 10106 12196 13877
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 £39,000 £37,000
10% offered a salary of more than £80,000 £77,500 £80,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 26 June 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 26 June 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 +27 36 £62,500 +4.16%
Teddington - 3 £52,500 - 2
Romford - 1 £82,500 -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 26 June 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 251 (74.48%) Business Intelligence
2 229 (67.95%) SQL Server
3 227 (67.36%) SQL
4 224 (66.47%) Data Warehouse
5 184 (54.60%) ETL
6 156 (46.29%) SQL Server Integration Services
7 153 (45.40%) SQL Server Analysis Services
8 147 (43.62%) SQL Server Reporting Services
9 125 (37.09%) Finance
10 124 (36.80%) Microsoft
11 106 (31.45%) Agile Software Development
12 97 (28.78%) MS Excel
13 94 (27.89%) Oracle
13 94 (27.89%) Oracle OLAP
14 93 (27.60%) OLAP Cube
15 87 (25.82%) Kimball Methodology
16 86 (25.52%) OLTP
17 76 (22.55%) MDX
18 72 (21.36%) T-SQL
18 72 (21.36%) Data Modelling
19 71 (21.07%) Analytics
20 69 (20.47%) Relational Database
21 66 (19.58%) Performance Tuning
22 63 (18.69%) SQL Server 2012
22 63 (18.69%) SQL Server 2008
23 60 (17.80%) Dimensional Modelling
24 55 (16.32%) Analytical Skills
25 53 (15.73%) Banking
26 44 (13.06%) Data Quality
27 43 (12.76%) Degree

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 15 (4.45%) SAS
2 13 (3.86%) Apache
2 13 (3.86%) Tomcat
3 12 (3.56%) IIS
4 10 (2.97%) WebSphere
5 9 (2.67%) Oracle Coherence
5 9 (2.67%) Oracle HTTP Server
5 9 (2.67%) SharePoint
6 6 (1.78%) Confluence
7 5 (1.48%) Apache Pig
7 5 (1.48%) Apache Spark
7 5 (1.48%) Oracle Spatial
7 5 (1.48%) Oracle Workflow
8 4 (1.19%) Elasticsearch
9 2 (0.59%) SharePoint 2013
10 1 (0.30%) Blackberry Enterprise Server
10 1 (0.30%) MS Exchange
Applications
1 97 (28.78%) MS Excel
2 8 (2.37%) MS Office
3 3 (0.89%) MS Visio
3 3 (0.89%) SPSS
4 2 (0.59%) MS PowerPoint
4 2 (0.59%) Spreadsheet
5 1 (0.30%) Acrobat
5 1 (0.30%) MS Project
Business Applications
1 5 (1.48%) HFM
1 5 (1.48%) Unica
2 4 (1.19%) Cognos Business Intelligence
2 4 (1.19%) Cognos TM1
3 2 (0.59%) Cognos Planning
3 2 (0.59%) SAP BPC
4 1 (0.30%) Cognos Controller
4 1 (0.30%) Dynamics NAV
4 1 (0.30%) Oracle EBS
Cloud Services
1 18 (5.34%) Microsoft Azure
2 16 (4.75%) Amazon AWS
3 4 (1.19%) SaaS
4 2 (0.59%) Azure Machine Learning
4 2 (0.59%) IaaS
4 2 (0.59%) PaaS
Communications & Networking
1 12 (3.56%) SAN
2 10 (2.97%) HTTP
2 10 (2.97%) LAN
2 10 (2.97%) WAN
3 9 (2.67%) FCoE
3 9 (2.67%) Fibre Channel
3 9 (2.67%) iSCSI
3 9 (2.67%) Multicast
3 9 (2.67%) NAS
4 2 (0.59%) DHCP
4 2 (0.59%) DNS
4 2 (0.59%) Intranet
4 2 (0.59%) TCP/IP
5 1 (0.30%) Asterisk PBX
5 1 (0.30%) Firewall
5 1 (0.30%) Network Security
5 1 (0.30%) PABX
5 1 (0.30%) Remote Desktop
5 1 (0.30%) VLAN
5 1 (0.30%) VoIP
Database & Business Intelligence
1 229 (67.95%) SQL Server
2 224 (66.47%) Data Warehouse
3 156 (46.29%) SQL Server Integration Services
4 153 (45.40%) SQL Server Analysis Services
5 147 (43.62%) SQL Server Reporting Services
6 94 (27.89%) Oracle OLAP
7 93 (27.60%) OLAP Cube
8 86 (25.52%) OLTP
9 69 (20.47%) Relational Database
10 63 (18.69%) SQL Server 2008
10 63 (18.69%) SQL Server 2012
11 39 (11.57%) Microsoft Analysis Services
12 36 (10.68%) MySQL
12 36 (10.68%) RDBMS
13 32 (9.50%) SQL Server 2014
14 31 (9.20%) Big Data
15 27 (8.01%) PowerPivot
16 26 (7.72%) DB2
16 26 (7.72%) Oracle Database
17 24 (7.12%) Oracle ODI
Development Applications
1 14 (4.15%) Git (software)
2 9 (2.67%) Jenkins
2 9 (2.67%) JIRA
3 8 (2.37%) Team Foundation Server
4 7 (2.08%) Eclipse
5 3 (0.89%) Visual Studio
6 2 (0.59%) Visual Studio Tools for Office
7 1 (0.30%) JUnit
7 1 (0.30%) Maven
7 1 (0.30%) Oracle Forms
7 1 (0.30%) Subversion
7 1 (0.30%) Talend Open Studio
General
1 125 (37.09%) Finance
2 53 (15.73%) Banking
3 37 (10.98%) Marketing
4 29 (8.61%) Investment Banking
5 28 (8.31%) Games
6 23 (6.82%) Telecoms
7 22 (6.53%) Retail
8 17 (5.04%) Front Office
9 13 (3.86%) Legal
10 7 (2.08%) Publishing
11 6 (1.78%) Advertising
11 6 (1.78%) Back Office
11 6 (1.78%) Manufacturing
12 2 (0.59%) Financial Institution
12 2 (0.59%) Law
13 1 (0.30%) Billing
13 1 (0.30%) Military
13 1 (0.30%) Pharmaceutical
Job Titles
1 172 (51.04%) Developer
2 120 (35.61%) Business Intelligence Developer
3 68 (20.18%) SQL Developer
4 61 (18.10%) SQL BI Developer
4 61 (18.10%) SSAS Developer
5 45 (13.35%) Analyst
6 37 (10.98%) Architect
7 35 (10.39%) SQL Server Developer
7 35 (10.39%) SSRS Developer
8 34 (10.09%) SSIS Developer
9 33 (9.79%) Senior Developer
10 32 (9.50%) SQL Server BI Developer
11 30 (8.90%) Consultant
11 30 (8.90%) DBA
12 25 (7.42%) Business Intelligence Consultant
13 22 (6.53%) Data Warehouse Developer
13 22 (6.53%) Oracle Developer
14 19 (5.64%) Data Analyst
15 17 (5.04%) Data Architect
16 15 (4.45%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 76 (22.55%) MDX
2 28 (8.31%) .NET
3 15 (4.45%) Web Services
3 15 (4.45%) XML
4 14 (4.15%) Oracle GoldenGate
5 10 (2.97%) Middleware
6 9 (2.67%) HTML
7 5 (1.48%) Django
7 5 (1.48%) jQuery
7 5 (1.48%) JSON
8 4 (1.19%) CSS
8 4 (1.19%) D3.js
8 4 (1.19%) HTML5
8 4 (1.19%) J2SE
8 4 (1.19%) RESTful
9 3 (0.89%) ASP.NET
9 3 (0.89%) ODBC
10 2 (0.59%) Leaflet
10 2 (0.59%) SVG
11 1 (0.30%) Twitter Bootstrap
Miscellaneous
1 55 (16.32%) Analytical Skills
2 32 (9.50%) Data Integration
3 31 (9.20%) Replication
4 25 (7.42%) Enterprise Software
5 23 (6.82%) Credit Risk
5 23 (6.82%) Statistics
6 21 (6.23%) Management Information System
7 18 (5.34%) Online Games
8 17 (5.04%) Computer Science
9 15 (4.45%) Fintech
10 12 (3.56%) Clustering
10 12 (3.56%) Data Extraction
10 12 (3.56%) Economics
10 12 (3.56%) Visualisation
11 10 (2.97%) Mathematics
12 5 (1.48%) Data Conversion
12 5 (1.48%) N-Tier
12 5 (1.48%) Reinsurance
13 4 (1.19%) Foreign Exchange (FX)
13 4 (1.19%) Hedge funds
Operating Systems
1 41 (12.17%) Linux
2 26 (7.72%) Windows
3 11 (3.26%) Unix
4 10 (2.97%) Oracle Linux
5 9 (2.67%) Solaris
6 4 (1.19%) Windows Server
6 4 (1.19%) Windows Server 2008
6 4 (1.19%) Windows Server 2012
7 1 (0.30%) CentOS
7 1 (0.30%) Windows 7
7 1 (0.30%) Windows Vista
Processes & Methodologies
1 251 (74.48%) Business Intelligence
2 184 (54.60%) ETL
3 106 (31.45%) Agile Software Development
4 87 (25.82%) Kimball Methodology
5 72 (21.36%) Data Modelling
6 71 (21.07%) Analytics
7 66 (19.58%) Performance Tuning
8 60 (17.80%) Dimensional Modelling
9 32 (9.50%) Business Analysis
9 32 (9.50%) SDLC
10 29 (8.61%) Data Management
10 29 (8.61%) DNA
11 27 (8.01%) Presales
12 24 (7.12%) Data Analysis
12 24 (7.12%) Data Architecture
13 19 (5.64%) ITIL
13 19 (5.64%) Project Management
14 17 (5.04%) E-Commerce
14 17 (5.04%) Open Source
14 17 (5.04%) Scrum
Programming Languages
1 227 (67.36%) SQL
2 72 (21.36%) T-SQL
3 41 (12.17%) PL/SQL
4 30 (8.90%) C#
5 29 (8.61%) Java
6 23 (6.82%) C
7 18 (5.34%) Data Analysis Expressions (DAX)
7 18 (5.34%) Python
8 17 (5.04%) JavaScript
9 10 (2.97%) Shell Script
10 9 (2.67%) C++
10 9 (2.67%) PHP
11 7 (2.08%) VBA
12 6 (1.78%) Perl
12 6 (1.78%) PowerShell
13 4 (1.19%) R
14 3 (0.89%) VB.NET
15 2 (0.59%) Ruby
16 1 (0.30%) Bash Shell
16 1 (0.30%) Clojure
Qualifications
1 43 (12.76%) Degree
2 6 (1.78%) ACCA
2 6 (1.78%) CIMA
3 3 (0.89%) IBM Certification
4 2 (0.59%) AAT
4 2 (0.59%) ISEB
4 2 (0.59%) Microsoft Certification
5 1 (0.30%) HND
5 1 (0.30%) ITIL Certification
5 1 (0.30%) MBA
Quality Assurance & Compliance
1 44 (13.06%) Data Quality
2 24 (7.12%) QA
3 8 (2.37%) PCI DSS
4 4 (1.19%) Basel II
5 3 (0.89%) Sarbanes-Oxley
5 3 (0.89%) SLA
System Software
1 19 (5.64%) Oracle RAC
2 10 (2.97%) KVM
2 10 (2.97%) VMware Infrastructure
3 9 (2.67%) Hyper-V
3 9 (2.67%) NFS
3 9 (2.67%) SRDF
3 9 (2.67%) Xen
4 2 (0.59%) Virtual Machines
5 1 (0.30%) Active Directory
5 1 (0.30%) Docker
5 1 (0.30%) Microsoft Virtual Server
5 1 (0.30%) Virtual Servers
5 1 (0.30%) VirtualBox
Systems Management
1 10 (2.97%) Data Guard
1 10 (2.97%) Oracle Enterprise Manager
2 5 (1.48%) Mesos
3 3 (0.89%) Puppet
4 2 (0.59%) Cisco IPCC
5 1 (0.30%) ITRS Geneos
Vendors
1 124 (36.80%) Microsoft
2 94 (27.89%) Oracle
3 37 (10.98%) Tableau
4 24 (7.12%) IBM
5 23 (6.82%) Cognos
6 15 (4.45%) SAP
7 11 (3.26%) Sybase
8 10 (2.97%) VMware
9 9 (2.67%) Cisco
9 9 (2.67%) EMC
9 9 (2.67%) Hitachi
9 9 (2.67%) Intel
9 9 (2.67%) NetApp
10 8 (2.37%) Vertica
11 7 (2.08%) Teradata
12 6 (1.78%) Hyperion
12 6 (1.78%) Informatica
13 5 (1.48%) Alterian
13 5 (1.48%) Facebook
13 5 (1.48%) MicroStrategy
London
Lorien Resourcing
Posted: 6 days ago
London
NST Recruitment Limited
Salary: Benefits
Posted: 8 hours ago
London
Spencer Rose
Salary: From £60,000 to £65,000 per annum
Posted: 6 days ago
London
Harvey Nash plc
Salary: £80000 per annum
Posted: 4 days ago
London
Square One Resources
Salary: From £90,000 to £95,000 per annum
Posted: 4 days ago
London
Venturi
Salary: £60000.00 - £85000.00 per annum + Bonus and Benefits
Posted: 2 days ago
London
Networking People
Posted: 6 days ago
London
TDA Group
Salary: £65000 per annum + Benefits & Bonus
Posted: 3 days ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 6 days ago
Teddington, Middlesex
Profile 29 Limited
Salary: Up to £68,000 per annum + benefits (see advert)
Posted: 5 days ago
Teddington
Ortolan Group
Posted: 10 days ago