The table below looks at the statistics for OLAP skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 3 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
3 Jul 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 250 232 243
Rank change year-on-year
-18 +11
Permanent jobs citing OLAP 58 113 89
As % of all permanent IT jobs located in the City of London 0.56% 0.89% 0.74%
As % of the Database & Business Intelligence category 1.94% 2.96% 2.75%
Number of salaries quoted 54 103 84
Average salary £60,000 £57,500 £62,000
Average salary % change year-on-year
+4.34% -7.25%
90% offered a salary of more than £45,750 £45,500 £41,500
10% offered a salary of more than £67,500 £70,000 £70,000
UK excluding London average salary £40,000 £44,000 £45,000
% change year-on-year
-9.09% -2.22%
OLAP
London

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 City of London region.

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2984 3816 3238
As % of all permanent IT jobs located in the City of London 28.79% 30.16% 26.79%
Number of salaries quoted 2589 3309 2841
Average salary £57,500 £55,000 £55,000
Average salary % change year-on-year
+4.54% -
90% offered a salary of more than £40,000 £37,500 £35,000
10% offered a salary of more than £77,500 £72,500 £80,000
UK excluding London average salary £42,000 £40,000 £38,500
% change year-on-year
+5.00% +3.89%

OLAP
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in the City of London

OLAP
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the City of London region.

OLAP Salary Trend in the City of London

OLAP
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing OLAP across the City of London region over the 3 months to 3 July 2015.

OLAP Salary Histogram in the City of London

OLAP
Top 30 Related IT Skills in the City of London

For the 6 months to 3 July 2015, IT jobs across the City of London region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 97 (76.38%) Business Intelligence
2 92 (72.44%) SQL Server
3 86 (67.72%) ETL
4 82 (64.57%) SQL Server Integration Services
5 80 (62.99%) Data Warehouse
6 77 (60.63%) SQL Server Analysis Services
7 74 (58.27%) SQL
8 70 (55.12%) SQL Server Reporting Services
9 62 (48.82%) Microsoft
10 56 (44.09%) OLAP Cube
11 47 (37.01%) Data Modelling
12 39 (30.71%) Finance
13 37 (29.13%) Analytics
14 33 (25.98%) Oracle
14 33 (25.98%) Oracle OLAP
15 31 (24.41%) MS Excel
16 27 (21.26%) SQL Server 2008
17 26 (20.47%) MDX
17 26 (20.47%) Business Objects
17 26 (20.47%) Big Data
18 22 (17.32%) SQL Server 2012
18 22 (17.32%) SAP
18 22 (17.32%) Data Mining
19 21 (16.54%) Cognos
19 21 (16.54%) T-SQL
20 19 (14.96%) Java
20 19 (14.96%) BusinessObjects
21 18 (14.17%) SharePoint
21 18 (14.17%) Agile Software Development
22 17 (13.39%) Windows

OLAP
Top Related IT Skills in the City of London by Category

For the 6 months to 3 July 2015, IT jobs across the City of London region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 18 (14.17%) SharePoint
2 10 (7.87%) SAS
3 5 (3.94%) SharePoint 2010
4 2 (1.57%) SharePoint Server
5 1 (0.79%) SharePoint 2013
5 1 (0.79%) Apache Spark
5 1 (0.79%) BizTalk Server
5 1 (0.79%) Oracle Workflow
Applications
1 31 (24.41%) MS Excel
2 16 (12.60%) PowerPivot
3 15 (11.81%) MS Visio
4 8 (6.30%) SPSS
5 3 (2.36%) MS Office
6 1 (0.79%) MS Project
6 1 (0.79%) Gephi
6 1 (0.79%) MS PowerPoint
6 1 (0.79%) FastStats
Business Applications
1 8 (6.30%) Oracle Applications
2 4 (3.15%) Hyperion Planning
2 4 (3.15%) Oracle EBS
3 2 (1.57%) Oracle EBS R12
3 2 (1.57%) ION MarketView
3 2 (1.57%) HFM
3 2 (1.57%) Cognos TM1
4 1 (0.79%) SAP Oil and Gas
4 1 (0.79%) Dynamics NAV
4 1 (0.79%) Dynamics CRM
4 1 (0.79%) Cognos Planning
4 1 (0.79%) Cognos Business Intelligence
4 1 (0.79%) SAP BPC
4 1 (0.79%) Oracle Procure-to-Pay
4 1 (0.79%) Oracle ERP
4 1 (0.79%) Oracle Financials
Cloud Services
1 4 (3.15%) Amazon AWS
Database & Business Intelligence
1 92 (72.44%) SQL Server
2 82 (64.57%) SQL Server Integration Services
3 80 (62.99%) Data Warehouse
4 77 (60.63%) SQL Server Analysis Services
5 70 (55.12%) SQL Server Reporting Services
6 56 (44.09%) OLAP Cube
7 33 (25.98%) Oracle OLAP
8 27 (21.26%) SQL Server 2008
9 26 (20.47%) Big Data
10 22 (17.32%) SQL Server 2012
10 22 (17.32%) Data Mining
11 19 (14.96%) BusinessObjects
12 16 (12.60%) SSDT
12 16 (12.60%) Oracle Database
13 15 (11.81%) Hadoop
14 14 (11.02%) OLTP
15 13 (10.24%) Oracle BI EE
16 12 (9.45%) QlikView
17 11 (8.66%) Oracle Database 11g
17 11 (8.66%) Relational Database
Development Applications
1 16 (12.60%) PowerDesigner
2 1 (0.79%) ClearQuest
2 1 (0.79%) CruiseControl
2 1 (0.79%) Team Foundation Server
2 1 (0.79%) Visual Studio
2 1 (0.79%) VSS/SourceSafe
2 1 (0.79%) ClearCase
General
1 39 (30.71%) Finance
2 16 (12.60%) Banking
3 6 (4.72%) Front Office
4 5 (3.94%) Advertising
4 5 (3.94%) General Ledger
4 5 (3.94%) Marketing
5 3 (2.36%) Retail
6 2 (1.57%) Investment Banking
6 2 (1.57%) Telecoms
6 2 (1.57%) Law
7 1 (0.79%) Legal
7 1 (0.79%) Manufacturing
7 1 (0.79%) Financial Institution
7 1 (0.79%) Back Office
7 1 (0.79%) Electronics
7 1 (0.79%) Billing
7 1 (0.79%) Games
Job Titles
1 84 (66.14%) Developer
2 29 (22.83%) Senior Developer
3 26 (20.47%) Analyst
3 26 (20.47%) Consultant
3 26 (20.47%) Business Intelligence Developer
4 20 (15.75%) Analyst Developer
5 17 (13.39%) Business Intelligence Consultant
6 14 (11.02%) MI Analyst
7 12 (9.45%) SQL Developer
7 12 (9.45%) Java Developer
8 11 (8.66%) Senior Java Developer
9 9 (7.09%) Oracle Developer
9 9 (7.09%) DBA
9 9 (7.09%) Senior Consultant
9 9 (7.09%) Business Developer
10 8 (6.30%) Business Consultant
10 8 (6.30%) SQL Server Developer
10 8 (6.30%) Java Consultant
10 8 (6.30%) Senior Java Consultant
11 7 (5.51%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 26 (20.47%) MDX
2 7 (5.51%) .NET
3 6 (4.72%) XML
4 5 (3.94%) XSD
4 5 (3.94%) XSLT
5 2 (1.57%) Web Services
6 1 (0.79%) ASP.NET
6 1 (0.79%) COM
6 1 (0.79%) WCF
6 1 (0.79%) Spring.NET
6 1 (0.79%) D3.js
6 1 (0.79%) ASP.NET Web Forms
6 1 (0.79%) Cascading
6 1 (0.79%) MSMQ
6 1 (0.79%) SAP XI
6 1 (0.79%) WinForms
6 1 (0.79%) NHibernate
6 1 (0.79%) .NET Remoting
Miscellaneous
1 16 (12.60%) Analytical Skills
2 10 (7.87%) Data Structures
3 9 (7.09%) Management Information System
3 9 (7.09%) Replication
4 8 (6.30%) Data Integration
5 5 (3.94%) Data Conversion
6 3 (2.36%) Hedge funds
7 2 (1.57%) Oracle Exalogic
7 2 (1.57%) Computer Science
7 2 (1.57%) Visualisation
7 2 (1.57%) Oracle Exalytics
8 1 (0.79%) Digital Media
8 1 (0.79%) Data Centre
8 1 (0.79%) Fixed Income
8 1 (0.79%) Neural Network
8 1 (0.79%) N-Tier
8 1 (0.79%) PMI
8 1 (0.79%) Foreign Exchange (FX)
8 1 (0.79%) DTV
Operating Systems
1 17 (13.39%) Windows
2 10 (7.87%) Linux
3 3 (2.36%) Windows Server 2008
3 3 (2.36%) Windows Server 2012
4 2 (1.57%) UNIX
5 1 (0.79%) Red Hat Enterprise Linux
Processes & Methodologies
1 97 (76.38%) Business Intelligence
2 86 (67.72%) ETL
3 47 (37.01%) Data Modelling
4 37 (29.13%) Analytics
5 18 (14.17%) Agile Software Development
6 16 (12.60%) Data Management
7 15 (11.81%) Regression Testing
8 14 (11.02%) Master Data Management
9 13 (10.24%) Data Architecture
10 11 (8.66%) Database Security
10 11 (8.66%) ETL Development
11 10 (7.87%) Mentoring
12 9 (7.09%) Performance Tuning
12 9 (7.09%) Dimensional Modelling
12 9 (7.09%) Kimball Methodology
13 7 (5.51%) Change Control
13 7 (5.51%) Data Analysis
13 7 (5.51%) Scrum
13 7 (5.51%) Change Management
13 7 (5.51%) Low Latency
Programming Languages
1 74 (58.27%) SQL
2 21 (16.54%) T-SQL
3 19 (14.96%) Java
4 13 (10.24%) PL/SQL
5 8 (6.30%) C
6 6 (4.72%) Data Analysis Expressions (DAX)
7 5 (3.94%) C#
8 3 (2.36%) R
8 3 (2.36%) PowerShell
9 2 (1.57%) Python
10 1 (0.79%) Scala
10 1 (0.79%) JavaScript
10 1 (0.79%) VB.NET
10 1 (0.79%) VBA
Qualifications
1 15 (11.81%) Degree
2 8 (6.30%) OCP
2 8 (6.30%) Oracle Certification
3 5 (3.94%) Microsoft Certification
4 4 (3.15%) MCDBA
4 4 (3.15%) MCITP
5 2 (1.57%) SC Cleared
5 2 (1.57%) Security Cleared
6 1 (0.79%) MCP
6 1 (0.79%) MCSD
6 1 (0.79%) MCSE
6 1 (0.79%) PMI Certification
6 1 (0.79%) IBM Certification
Quality Assurance & Compliance
1 1 (0.79%) Data Quality
System Software
1 1 (0.79%) Docker
Vendors
1 62 (48.82%) Microsoft
2 33 (25.98%) Oracle
3 26 (20.47%) Business Objects
4 22 (17.32%) SAP
5 21 (16.54%) Cognos
6 17 (13.39%) Tableau
7 16 (12.60%) IBM
7 16 (12.60%) Sybase
8 15 (11.81%) MicroStrategy
9 10 (7.87%) Informatica
9 10 (7.87%) Teradata
10 9 (7.09%) Hyperion
10 9 (7.09%) Netezza
11 8 (6.30%) DataFlux
11 8 (6.30%) Ab Initio
12 2 (1.57%) ION Trading
12 2 (1.57%) Endeca
13 1 (0.79%) Vertica
13 1 (0.79%) ParAccel
13 1 (0.79%) Alteryx
City, London
Churchill Frank
Posted: 2 days ago
City, London
Nigel Frank International Ltd
Salary: £50000 - £60000 per annum
Posted: 2 days ago
City, London
Careerwise UK Limited
Salary: £50000 - £75000 per annum + package
Posted: 3 days ago
City of London
Ortolan Group
Salary: £70000 - £80000 per annum
Posted: 3 days ago
City, London
Lawrence Harvey Enterprise
Salary: £55000.00 - £70000 per annum + 20% Bonus
Posted: 4 days ago
City of London
Venturi
Salary: £50000 - £75000.00 per annum + full bens
Posted: 7 days ago
City of London
Deerfoot IT
Salary: £60000 - £70000 per annum + banking bonus + bens
Posted: 7 days ago
City of London
Churchill Frank
Salary: £40000 - £45000 per annum
Posted: 11 days ago
City of London
First Point
Salary: £40000 - £55000 per annum
Posted: 22 days ago
City of London
Interquest - IQ Telecom
Salary: £50000 - £55000 per annum + bonus + pension
Posted: 25 days ago