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 29 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
29 Jul 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 256 202 243
Rank change year-on-year
-54 +41
Permanent jobs citing OLAP 50 141 81
As % of all permanent IT jobs located in the City of London 0.48% 1.14% 0.68%
As % of the Database & Business Intelligence category 1.70% 3.82% 2.49%
Number of salaries quoted 47 127 75
Average salary £57,500 £59,000 £62,500
Average salary % change year-on-year
-2.54% -5.60%
90% offered a salary of more than £42,100 £46,500 £40,000
10% offered a salary of more than £67,500 £71,000 £70,000
UK excluding London average salary £40,000 £45,000 £43,500
% change year-on-year
-11.11% +3.44%
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
2944 3694 3249
As % of all permanent IT jobs located in the City of London 27.99% 29.77% 27.12%
Number of salaries quoted 2528 3189 2879
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 £80,000 £72,500 £80,000
UK excluding London average salary £42,500 £40,000 £39,000
% change year-on-year
+6.25% +2.56%

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 29 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 29 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 101 (78.29%) Business Intelligence
2 94 (72.87%) SQL Server
3 89 (68.99%) ETL
4 85 (65.89%) Data Warehouse
4 85 (65.89%) SQL Server Integration Services
5 80 (62.02%) SQL Server Analysis Services
6 76 (58.91%) SQL
7 75 (58.14%) SQL Server Reporting Services
8 60 (46.51%) Microsoft
9 54 (41.86%) OLAP Cube
10 48 (37.21%) Data Modelling
11 41 (31.78%) Finance
12 38 (29.46%) Analytics
13 33 (25.58%) MS Excel
14 32 (24.81%) Oracle
14 32 (24.81%) Oracle OLAP
15 27 (20.93%) SQL Server 2008
16 26 (20.16%) MDX
17 24 (18.60%) BusinessObjects
18 23 (17.83%) Big Data
19 22 (17.05%) Data Mining
20 20 (15.50%) T-SQL
20 20 (15.50%) Java
20 20 (15.50%) SQL Server 2012
21 19 (14.73%) Agile Software Development
21 19 (14.73%) SharePoint
22 18 (13.95%) SAP
23 17 (13.18%) Windows
23 17 (13.18%) Cognos
23 17 (13.18%) Oracle Database

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

For the 6 months to 29 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 19 (14.73%) SharePoint
2 11 (8.53%) SAS
3 5 (3.88%) SharePoint 2010
4 2 (1.55%) SharePoint 2013
4 2 (1.55%) SharePoint Server
5 1 (0.78%) Apache Spark
5 1 (0.78%) Oracle Workflow
Applications
1 33 (25.58%) MS Excel
2 16 (12.40%) PowerPivot
3 15 (11.63%) MS Visio
4 7 (5.43%) SPSS
5 4 (3.10%) MS Office
6 1 (0.78%) MS Project
6 1 (0.78%) Gephi
6 1 (0.78%) MS PowerPoint
Business Applications
1 8 (6.20%) Oracle Applications
2 4 (3.10%) Oracle EBS
3 3 (2.33%) Hyperion Planning
3 3 (2.33%) HFM
4 2 (1.55%) ION MarketView
5 1 (0.78%) SAP Oil and Gas
5 1 (0.78%) Dynamics CRM
5 1 (0.78%) Oracle EBS R12
5 1 (0.78%) Oracle ERP
Cloud Services
1 6 (4.65%) Amazon AWS
Communications & Networking
1 1 (0.78%) HTTP
Database & Business Intelligence
1 94 (72.87%) SQL Server
2 85 (65.89%) Data Warehouse
2 85 (65.89%) SQL Server Integration Services
3 80 (62.02%) SQL Server Analysis Services
4 75 (58.14%) SQL Server Reporting Services
5 54 (41.86%) OLAP Cube
6 32 (24.81%) Oracle OLAP
7 27 (20.93%) SQL Server 2008
8 24 (18.60%) BusinessObjects
9 23 (17.83%) Big Data
10 22 (17.05%) Data Mining
11 20 (15.50%) SQL Server 2012
12 17 (13.18%) Oracle Database
13 16 (12.40%) SSDT
14 15 (11.63%) Hadoop
15 14 (10.85%) OLTP
16 12 (9.30%) Oracle BI EE
16 12 (9.30%) Oracle Database 11g
17 11 (8.53%) Oracle Database 12c
17 11 (8.53%) Relational Database
Development Applications
1 15 (11.63%) PowerDesigner
2 1 (0.78%) ClearQuest
2 1 (0.78%) CruiseControl
2 1 (0.78%) Maven
2 1 (0.78%) Team Foundation Server
2 1 (0.78%) JUnit
2 1 (0.78%) Visual Studio
2 1 (0.78%) VSS/SourceSafe
2 1 (0.78%) ClearCase
General
1 41 (31.78%) Finance
2 15 (11.63%) Banking
3 6 (4.65%) Front Office
4 5 (3.88%) Advertising
4 5 (3.88%) General Ledger
4 5 (3.88%) Marketing
5 4 (3.10%) Retail
6 3 (2.33%) Telecoms
6 3 (2.33%) Law
7 2 (1.55%) Investment Banking
8 1 (0.78%) Billing
8 1 (0.78%) Legal
8 1 (0.78%) Manufacturing
8 1 (0.78%) Publishing
8 1 (0.78%) Games
8 1 (0.78%) Back Office
8 1 (0.78%) Electronics
Job Titles
1 87 (67.44%) Developer
2 28 (21.71%) Senior Developer
3 27 (20.93%) Business Intelligence Developer
4 25 (19.38%) Analyst
5 22 (17.05%) Consultant
6 20 (15.50%) Analyst Developer
7 16 (12.40%) Business Intelligence Consultant
8 13 (10.08%) MI Analyst
8 13 (10.08%) SQL Developer
9 10 (7.75%) Business Developer
9 10 (7.75%) Data Warehouse Developer
10 9 (6.98%) Java Developer
10 9 (6.98%) Oracle Developer
10 9 (6.98%) DBA
11 8 (6.20%) SQL Server Developer
11 8 (6.20%) Senior Java Developer
12 7 (5.43%) Senior Oracle Developer
12 7 (5.43%) Business Intelligence Analyst
12 7 (5.43%) Business Consultant
12 7 (5.43%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 26 (20.16%) MDX
2 10 (7.75%) .NET
3 6 (4.65%) XML
4 5 (3.88%) XSD
4 5 (3.88%) XSLT
5 3 (2.33%) CSS
5 3 (2.33%) HTML
5 3 (2.33%) Web Services
6 1 (0.78%) JDBC
6 1 (0.78%) J2EE
6 1 (0.78%) ASP.NET
6 1 (0.78%) COM
6 1 (0.78%) MSMQ
6 1 (0.78%) WinForms
6 1 (0.78%) Spring
6 1 (0.78%) JTA
6 1 (0.78%) NHibernate
6 1 (0.78%) .NET Remoting
6 1 (0.78%) JSON
6 1 (0.78%) WCF
Miscellaneous
1 17 (13.18%) Analytical Skills
2 10 (7.75%) Data Structures
2 10 (7.75%) Management Information System
3 9 (6.98%) Replication
4 8 (6.20%) Data Integration
5 5 (3.88%) Data Conversion
6 4 (3.10%) Computer Science
7 3 (2.33%) Visualisation
7 3 (2.33%) Hedge funds
7 3 (2.33%) Oracle Exalogic
7 3 (2.33%) Oracle Exalytics
8 2 (1.55%) Statistics
8 2 (1.55%) Mathematics
8 2 (1.55%) Physics
8 2 (1.55%) N-Tier
9 1 (0.78%) PMI
9 1 (0.78%) Foreign Exchange (FX)
9 1 (0.78%) DTV
9 1 (0.78%) Fixed Income
9 1 (0.78%) Neural Network
Operating Systems
1 17 (13.18%) Windows
2 10 (7.75%) Linux
3 3 (2.33%) Windows Server 2008
3 3 (2.33%) Windows Server 2012
4 2 (1.55%) UNIX
5 1 (0.78%) Red Hat Enterprise Linux
Processes & Methodologies
1 101 (78.29%) Business Intelligence
2 89 (68.99%) ETL
3 48 (37.21%) Data Modelling
4 38 (29.46%) Analytics
5 19 (14.73%) Agile Software Development
6 16 (12.40%) Data Management
7 15 (11.63%) Regression Testing
8 14 (10.85%) Master Data Management
9 12 (9.30%) Data Architecture
9 12 (9.30%) ETL Development
10 11 (8.53%) Performance Tuning
10 11 (8.53%) Database Security
11 10 (7.75%) Mentoring
12 9 (6.98%) Kimball Methodology
12 9 (6.98%) Dimensional Modelling
13 7 (5.43%) Change Control
13 7 (5.43%) Scrum
13 7 (5.43%) Change Management
13 7 (5.43%) Low Latency
13 7 (5.43%) Dashboard Development
Programming Languages
1 76 (58.91%) SQL
2 20 (15.50%) T-SQL
2 20 (15.50%) Java
3 13 (10.08%) PL/SQL
4 8 (6.20%) C
4 8 (6.20%) C#
5 6 (4.65%) Data Analysis Expressions (DAX)
6 4 (3.10%) R
6 4 (3.10%) VB.NET
6 4 (3.10%) VBA
7 3 (2.33%) Python
7 3 (2.33%) PowerShell
8 2 (1.55%) Scala
8 2 (1.55%) JavaScript
Qualifications
1 14 (10.85%) Degree
2 8 (6.20%) OCP
2 8 (6.20%) Oracle Certification
3 4 (3.10%) MCDBA
3 4 (3.10%) Microsoft Certification
3 4 (3.10%) MCITP
4 2 (1.55%) SC Cleared
4 2 (1.55%) Security Cleared
5 1 (0.78%) PMI Certification
5 1 (0.78%) MCP
5 1 (0.78%) MCSD
System Software
1 1 (0.78%) Docker
Vendors
1 60 (46.51%) Microsoft
2 32 (24.81%) Oracle
3 18 (13.95%) SAP
4 17 (13.18%) Cognos
5 16 (12.40%) Sybase
5 16 (12.40%) Tableau
6 14 (10.85%) IBM
6 14 (10.85%) MicroStrategy
7 9 (6.98%) Teradata
8 8 (6.20%) Informatica
9 7 (5.43%) Ab Initio
9 7 (5.43%) Hyperion
9 7 (5.43%) Netezza
9 7 (5.43%) DataFlux
10 3 (2.33%) Endeca
11 2 (1.55%) ION Trading
11 2 (1.55%) Vertica
12 1 (0.78%) ParAccel
12 1 (0.78%) Alteryx
12 1 (0.78%) Actian
City, London
Oscar Associates (UK) Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: 2 hours ago
City, London
Deerfoot IT Resources Ltd
Salary: £65000 - £72000 per annum + Banking bonus
Posted: 14 hours ago
City, London
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 18 hours ago
City of London
Hays IT - Uk Posting account
Salary: £50000.00 - £60000.00 per annum + package
Posted: 2 days ago
City, London
Hays Finance Technology
Salary: £35000.00 - £50000.00 per annum
Posted: 4 days ago
City, London
Ashdown IT
Salary: £35000 - £40000 per annum + substantial benefits
Posted: 6 days ago
City, London
Careerwise UK Limited
Salary: £50000 - £75000 per annum + package
Posted: 6 days ago
City of London
Progressive Recruitment
Salary: £40000 - £50000 per annum + Competitive Benefits
Posted: 12 days ago
City of London
First Point
Salary: £40000 - £55000 per annum
Posted: 12 days ago