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

3 months to
1 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 461 403 376
Rank change year-on-year
-58 -27
Permanent jobs citing OLAP 172 276 373
As % of all permanent IT jobs located in London 0.43% 0.64% 0.76%
As % of the Database & Business Intelligence category 1.43% 2.00% 2.38%
Number of salaries quoted 123 227 295
Median salary £60,000 £62,500 £55,000
Median salary % change year-on-year
-4.00% +13.63%
90% offered a salary of more than £45,000 £46,500 £40,000
10% offered a salary of more than £80,000 £75,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
12054 13806 15667
As % of all permanent IT jobs located in London 29.91% 32.22% 31.88%
Number of salaries quoted 10530 11778 13594
Median salary £57,500 £57,500 £52,500
Median salary % change year-on-year
- +9.52%
90% offered a salary of more than £40,000 £39,000 £36,000
10% offered a salary of more than £80,000 £75,000 £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 1 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 1 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 +6 35 £60,000 - 3
Teddington - 4 £52,500 - 2
Romford - 1 £82,500 -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 1 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 266 (75.78%) Business Intelligence
2 235 (66.95%) SQL Server
3 234 (66.67%) Data Warehouse
4 231 (65.81%) SQL
5 195 (55.56%) ETL
6 171 (48.72%) SQL Server Analysis Services
7 167 (47.58%) SQL Server Integration Services
8 155 (44.16%) SQL Server Reporting Services
9 138 (39.32%) Microsoft
10 133 (37.89%) Finance
11 115 (32.76%) MS Excel
12 108 (30.77%) Agile Software Development
13 107 (30.48%) OLAP Cube
14 97 (27.64%) Kimball Methodology
15 94 (26.78%) Oracle OLAP
15 94 (26.78%) MDX
15 94 (26.78%) Oracle
16 83 (23.65%) OLTP
17 82 (23.36%) Data Modelling
18 79 (22.51%) Relational Database
19 78 (22.22%) Analytics
20 74 (21.08%) T-SQL
21 69 (19.66%) SQL Server 2008
22 66 (18.80%) Performance Tuning
23 65 (18.52%) SQL Server 2012
24 63 (17.95%) Dimensional Modelling
25 59 (16.81%) Banking
26 54 (15.38%) Analytical Skills
27 51 (14.53%) Degree
28 48 (13.68%) PL/SQL

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.27%) SAS
2 11 (3.13%) Tomcat
3 10 (2.85%) Apache
4 9 (2.56%) IIS
5 7 (1.99%) SharePoint
5 7 (1.99%) WebSphere
6 6 (1.71%) Confluence
6 6 (1.71%) Oracle Coherence
6 6 (1.71%) Oracle HTTP Server
7 5 (1.42%) Apache Pig
7 5 (1.42%) Apache Spark
7 5 (1.42%) Oracle Spatial
7 5 (1.42%) Oracle Workflow
8 4 (1.14%) Elasticsearch
9 1 (0.28%) Adobe Experience Manager
9 1 (0.28%) Drupal
9 1 (0.28%) Joomla!
9 1 (0.28%) Node.js
9 1 (0.28%) OpenCms
9 1 (0.28%) WordPress
Applications
1 115 (32.76%) MS Excel
2 8 (2.28%) MS Office
3 4 (1.14%) SPSS
4 3 (0.85%) MS Visio
5 2 (0.57%) MS PowerPoint
5 2 (0.57%) Spreadsheet
6 1 (0.28%) Acrobat
6 1 (0.28%) MS Project
Business Applications
1 7 (1.99%) HFM
2 5 (1.42%) Cognos Business Intelligence
2 5 (1.42%) Cognos TM1
2 5 (1.42%) Unica
3 2 (0.57%) Cognos Controller
3 2 (0.57%) Cognos Planning
3 2 (0.57%) SAP BPC
4 1 (0.28%) Dynamics NAV
4 1 (0.28%) Oracle EBS
Cloud Services
1 19 (5.41%) Microsoft Azure
2 15 (4.27%) Amazon AWS
3 4 (1.14%) SaaS
4 1 (0.28%) GitHub
Communications & Networking
1 8 (2.28%) SAN
2 7 (1.99%) HTTP
2 7 (1.99%) LAN
2 7 (1.99%) WAN
3 6 (1.71%) FCoE
3 6 (1.71%) Fibre Channel
3 6 (1.71%) iSCSI
3 6 (1.71%) Multicast
3 6 (1.71%) NAS
4 2 (0.57%) DHCP
4 2 (0.57%) DNS
4 2 (0.57%) Intranet
4 2 (0.57%) TCP/IP
5 1 (0.28%) Asterisk PBX
5 1 (0.28%) Firewall
5 1 (0.28%) Network Security
5 1 (0.28%) PABX
5 1 (0.28%) Remote Desktop
5 1 (0.28%) VLAN
5 1 (0.28%) VoIP
Database & Business Intelligence
1 235 (66.95%) SQL Server
2 234 (66.67%) Data Warehouse
3 171 (48.72%) SQL Server Analysis Services
4 167 (47.58%) SQL Server Integration Services
5 155 (44.16%) SQL Server Reporting Services
6 107 (30.48%) OLAP Cube
7 94 (26.78%) Oracle OLAP
8 83 (23.65%) OLTP
9 79 (22.51%) Relational Database
10 69 (19.66%) SQL Server 2008
11 65 (18.52%) SQL Server 2012
12 39 (11.11%) Microsoft Analysis Services
12 39 (11.11%) RDBMS
13 35 (9.97%) SQL Server 2014
14 34 (9.69%) MySQL
15 31 (8.83%) Big Data
15 31 (8.83%) PowerPivot
16 30 (8.55%) Oracle Database
17 26 (7.41%) Microsoft Power View
18 25 (7.12%) Data Mart
Development Applications
1 15 (4.27%) Git (software)
2 9 (2.56%) Jenkins
3 8 (2.28%) Team Foundation Server
4 7 (1.99%) Eclipse
4 7 (1.99%) JIRA
5 4 (1.14%) Oracle Forms
6 2 (0.57%) Maven
7 1 (0.28%) JUnit
7 1 (0.28%) Subversion
7 1 (0.28%) Talend Open Studio
7 1 (0.28%) Visual Studio
General
1 133 (37.89%) Finance
2 59 (16.81%) Banking
3 45 (12.82%) Marketing
4 36 (10.26%) Games
5 35 (9.97%) Investment Banking
6 21 (5.98%) Retail
7 20 (5.70%) Telecoms
8 16 (4.56%) Front Office
9 13 (3.70%) Legal
10 7 (1.99%) Publishing
11 6 (1.71%) Advertising
11 6 (1.71%) Back Office
12 4 (1.14%) Financial Institution
12 4 (1.14%) Law
13 3 (0.85%) Manufacturing
14 1 (0.28%) Billing
14 1 (0.28%) Military
14 1 (0.28%) Pharmaceutical
Job Titles
1 182 (51.85%) Developer
2 124 (35.33%) Business Intelligence Developer
3 72 (20.51%) SQL Developer
4 67 (19.09%) SSAS Developer
5 62 (17.66%) SQL BI Developer
6 50 (14.25%) Analyst
7 39 (11.11%) Senior Developer
8 38 (10.83%) SSRS Developer
9 37 (10.54%) SSIS Developer
10 36 (10.26%) Architect
11 34 (9.69%) SQL Server Developer
12 33 (9.40%) DBA
13 31 (8.83%) SQL Server BI Developer
14 29 (8.26%) Consultant
15 28 (7.98%) Data Warehouse Developer
16 26 (7.41%) Business Intelligence Consultant
17 24 (6.84%) Oracle Developer
18 22 (6.27%) Data Analyst
19 17 (4.84%) Business Intelligence Analyst
19 17 (4.84%) Database Developer
Libraries, Frameworks & Software Standards
1 94 (26.78%) MDX
2 29 (8.26%) .NET
3 16 (4.56%) Oracle GoldenGate
4 15 (4.27%) Web Services
4 15 (4.27%) XML
5 7 (1.99%) Middleware
6 6 (1.71%) HTML
6 6 (1.71%) jQuery
7 5 (1.42%) CSS
7 5 (1.42%) JSON
8 4 (1.14%) J2SE
8 4 (1.14%) RESTful
9 3 (0.85%) ODBC
10 2 (0.57%) ASP.NET
10 2 (0.57%) D3.js
10 2 (0.57%) Django
10 2 (0.57%) J2EE
10 2 (0.57%) Spring
10 2 (0.57%) SVG
11 1 (0.28%) JSF
Miscellaneous
1 54 (15.38%) Analytical Skills
2 34 (9.69%) Replication
3 27 (7.69%) Data Integration
4 26 (7.41%) Credit Risk
4 26 (7.41%) Online Games
5 25 (7.12%) Statistics
6 22 (6.27%) Computer Science
6 22 (6.27%) Management Information System
7 21 (5.98%) Enterprise Software
8 14 (3.99%) Economics
9 13 (3.70%) Clustering
9 13 (3.70%) Visualisation
10 11 (3.13%) Data Extraction
11 10 (2.85%) Fintech
11 10 (2.85%) Mathematics
12 7 (1.99%) Reinsurance
13 5 (1.42%) N-Tier
14 4 (1.14%) Foreign Exchange (FX)
14 4 (1.14%) Hedge funds
15 3 (0.85%) Data Conversion
Operating Systems
1 41 (11.68%) Linux
2 19 (5.41%) Windows
3 13 (3.70%) Oracle Linux
4 11 (3.13%) Unix
5 6 (1.71%) Solaris
6 3 (0.85%) Windows Server 2008
6 3 (0.85%) Windows Server 2012
7 2 (0.57%) Windows Server
8 1 (0.28%) AIX
8 1 (0.28%) CentOS
8 1 (0.28%) Windows 7
8 1 (0.28%) Windows Vista
Processes & Methodologies
1 266 (75.78%) Business Intelligence
2 195 (55.56%) ETL
3 108 (30.77%) Agile Software Development
4 97 (27.64%) Kimball Methodology
5 82 (23.36%) Data Modelling
6 78 (22.22%) Analytics
7 66 (18.80%) Performance Tuning
8 63 (17.95%) Dimensional Modelling
9 33 (9.40%) SDLC
10 31 (8.83%) Data Analysis
10 31 (8.83%) Data Management
11 30 (8.55%) Presales
12 27 (7.69%) Business Analysis
13 25 (7.12%) DNA
14 24 (6.84%) Data Architecture
14 24 (6.84%) Open Source
15 22 (6.27%) E-Commerce
15 22 (6.27%) Scrum
16 21 (5.98%) Information Management
17 19 (5.41%) Translating Business Requirements
Programming Languages
1 231 (65.81%) SQL
2 74 (21.08%) T-SQL
3 48 (13.68%) PL/SQL
4 30 (8.55%) C#
5 29 (8.26%) Java
6 26 (7.41%) C
7 18 (5.13%) Data Analysis Expressions (DAX)
8 17 (4.84%) Python
9 15 (4.27%) Shell Script
10 13 (3.70%) JavaScript
11 9 (2.56%) C++
12 7 (1.99%) PHP
12 7 (1.99%) VBA
13 6 (1.71%) Perl
14 5 (1.42%) PowerShell
15 3 (0.85%) VB.NET
16 2 (0.57%) R
16 2 (0.57%) Ruby
17 1 (0.28%) Bash Shell
17 1 (0.28%) Clojure
Qualifications
1 51 (14.53%) Degree
2 9 (2.56%) ACCA
2 9 (2.56%) CIMA
3 3 (0.85%) IBM Certification
4 2 (0.57%) AAT
4 2 (0.57%) ISEB
4 2 (0.57%) Microsoft Certification
5 1 (0.28%) CIPFA
5 1 (0.28%) HND
5 1 (0.28%) ITIL Certification
5 1 (0.28%) MBA
Quality Assurance & Compliance
1 44 (12.54%) Data Quality
2 24 (6.84%) QA
3 8 (2.28%) PCI DSS
4 5 (1.42%) Sarbanes-Oxley
5 4 (1.14%) Basel II
5 4 (1.14%) SLA
6 1 (0.28%) COBIT
System Software
1 19 (5.41%) Oracle RAC
2 7 (1.99%) KVM
2 7 (1.99%) VMware Infrastructure
3 6 (1.71%) Hyper-V
3 6 (1.71%) NFS
3 6 (1.71%) SRDF
3 6 (1.71%) Xen
4 1 (0.28%) Active Directory
4 1 (0.28%) Docker
4 1 (0.28%) Microsoft Virtual Server
4 1 (0.28%) Varnish
4 1 (0.28%) VirtualBox
Systems Management
1 14 (3.99%) Oracle Enterprise Manager
2 13 (3.70%) Data Guard
3 5 (1.42%) Mesos
4 3 (0.85%) Puppet
5 2 (0.57%) Cisco IPCC
6 1 (0.28%) Oracle RMAN
Vendors
1 138 (39.32%) Microsoft
2 94 (26.78%) Oracle
3 37 (10.54%) Tableau
4 27 (7.69%) Cognos
5 25 (7.12%) IBM
6 17 (4.84%) SAP
7 12 (3.42%) Hitachi
8 10 (2.85%) Sybase
9 9 (2.56%) Hyperion
9 9 (2.56%) Vertica
10 8 (2.28%) Teradata
11 7 (1.99%) Informatica
11 7 (1.99%) VMware
12 6 (1.71%) Cisco
12 6 (1.71%) EMC
12 6 (1.71%) Intel
12 6 (1.71%) MicroStrategy
12 6 (1.71%) NetApp
13 5 (1.42%) Alterian
13 5 (1.42%) Facebook
London
ninesharp
Salary: £55000 - £65000 per annum + Bonus, Pension, Healthcare
Posted: 22 hours ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 22 hours ago
Teddington, Middlesex
Profile 29 Limited
Salary: Up to £55,000 per annum + benefits (see advert)
Posted: 22 hours ago
London
ninesharp
Salary: £55000 - £65000 per annum + Bonus, Pension, Healthcare
Posted: 22 hours ago
City, London
ANSON MCCADE
Salary: £45,000 - £65,000 and Competitive Package
Posted: 20 hours ago
London
Joseph Harry Ltd
Salary: £45000 - £60000 per annum + 10% Pension + c.25% Bonus
Posted: 5 days ago
London
Lorien Resourcing
Salary: £48000 - £53000 per annum + Excellent benefits + Bonus
Posted: 4 days ago
London
Computer Futures
Salary: competitive
Posted: 8 days ago
City Of London
HFG
Salary: £50000 - £55000 per annum, Benefits: Bonus + Corp Bens.
Posted: 16 days ago
London
Vivid Resourcing
Posted: 16 days ago
London
Vivid Resourcing
Salary: £60 - £65 per annum + benefits
Posted: 12 days ago
London
onezeero.
Salary: £55000 - £65000 per annum + 20% uncapped bonus + 12% pension
Posted: 6 days ago
Central London / West End
ANSON MCCADE
Salary: £35k - £60k plus attractive benefits and extensive career progression
Posted: 6 days ago
Teddington
Ortolan Group
Posted: 26 days ago