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

Location
3 months to
5 May 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 223 258 216
Rank change year-on-year
+35 -42
Permanent jobs citing OLAP 81 81 118
As % of all permanent IT jobs located in the City of London 0.78% 0.64% 1.00%
As % of the Database & Business Intelligence category 2.68% 2.18% 3.65%
Number of salaries quoted 77 59 107
Average salary £62,500 £52,500 £57,500
Average salary % change year-on-year
+19.04% -8.69%
90% offered a salary of more than £52,500 £40,000 £45,000
10% offered a salary of more than £72,500 £66,000 £70,000
UK excluding London average salary £40,000 £42,250 £45,000
% change year-on-year
-5.32% -6.11%
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
3025 3711 3237
As % of all permanent IT jobs located in the City of London 28.96% 29.41% 27.31%
Number of salaries quoted 2628 3216 2870
Average salary £55,000 £52,500 £52,500
Average salary % change year-on-year
+4.76% -
90% offered a salary of more than £40,000 £37,500 £35,000
10% offered a salary of more than £75,000 £72,200 £75,000
UK excluding London average salary £41,000 £40,000 £39,000
% change year-on-year
+2.50% +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 5 May 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 5 May 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 109 (79.56%) Business Intelligence
2 102 (74.45%) SQL Server
3 92 (67.15%) SQL Server Integration Services
4 89 (64.96%) ETL
4 89 (64.96%) Data Warehouse
5 86 (62.77%) SQL Server Analysis Services
6 85 (62.04%) SQL
7 84 (61.31%) SQL Server Reporting Services
8 65 (47.45%) Microsoft
9 60 (43.80%) OLAP Cube
10 55 (40.15%) Data Modelling
11 50 (36.50%) Finance
12 41 (29.93%) Analytics
13 34 (24.82%) Oracle
13 34 (24.82%) Oracle OLAP
13 34 (24.82%) SQL Server 2008
14 31 (22.63%) T-SQL
15 29 (21.17%) MDX
16 28 (20.44%) MS Excel
17 27 (19.71%) SQL Server 2012
18 25 (18.25%) Tableau
19 24 (17.52%) Analytical Skills
19 24 (17.52%) SAP
20 23 (16.79%) Business Objects
20 23 (16.79%) Banking
20 23 (16.79%) Degree
21 22 (16.06%) Cognos
22 21 (15.33%) SharePoint
23 20 (14.60%) Agile Software Development
23 20 (14.60%) Big Data

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

For the 6 months to 5 May 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 21 (15.33%) SharePoint
2 7 (5.11%) SharePoint 2010
3 3 (2.19%) SharePoint 2013
3 3 (2.19%) SAS
3 3 (2.19%) BizTalk Server
4 1 (0.73%) Oracle Workflow
Applications
1 28 (20.44%) MS Excel
2 15 (10.95%) PowerPivot
3 14 (10.22%) MS Visio
4 3 (2.19%) MS Office
4 3 (2.19%) SPSS
5 1 (0.73%) MS Project
5 1 (0.73%) FastStats
5 1 (0.73%) MS PowerPoint
Business Applications
1 7 (5.11%) Hyperion Planning
1 7 (5.11%) Cognos TM1
2 6 (4.38%) Cognos Business Intelligence
2 6 (4.38%) Oracle Applications
3 2 (1.46%) Dynamics NAV
3 2 (1.46%) Oracle EBS R12
3 2 (1.46%) ION MarketView
3 2 (1.46%) Oracle EBS
3 2 (1.46%) Oracle Financials
3 2 (1.46%) Oracle Procure-to-Pay
4 1 (0.73%) SAP BPC
4 1 (0.73%) Cognos Planning
4 1 (0.73%) SAP Oil and Gas
Cloud Services
1 3 (2.19%) Cloud Computing
2 2 (1.46%) SaaS
3 1 (0.73%) Amazon AWS
Database & Business Intelligence
1 102 (74.45%) SQL Server
2 92 (67.15%) SQL Server Integration Services
3 89 (64.96%) Data Warehouse
4 86 (62.77%) SQL Server Analysis Services
5 84 (61.31%) SQL Server Reporting Services
6 60 (43.80%) OLAP Cube
7 34 (24.82%) Oracle OLAP
7 34 (24.82%) SQL Server 2008
8 27 (19.71%) SQL Server 2012
9 20 (14.60%) Big Data
10 18 (13.14%) QlikView
11 17 (12.41%) OLTP
12 16 (11.68%) Relational Database
13 15 (10.95%) SSDT
13 15 (10.95%) Data Mining
14 14 (10.22%) Oracle Database
15 13 (9.49%) BusinessObjects
16 10 (7.30%) Oracle BI EE
17 9 (6.57%) IBM InfoSphere
17 9 (6.57%) Oracle Database 12c
Development Applications
1 16 (11.68%) PowerDesigner
2 2 (1.46%) Subversion
2 2 (1.46%) Oracle Forms
3 1 (0.73%) ClearCase
3 1 (0.73%) Visual Studio
3 1 (0.73%) VSS/SourceSafe
3 1 (0.73%) ClearQuest
3 1 (0.73%) Team Foundation Server
3 1 (0.73%) CruiseControl
General
1 50 (36.50%) Finance
2 23 (16.79%) Banking
3 9 (6.57%) General Ledger
4 7 (5.11%) Advertising
5 6 (4.38%) Front Office
6 5 (3.65%) Financial Institution
7 4 (2.92%) Investment Banking
8 3 (2.19%) Telecoms
8 3 (2.19%) Marketing
9 2 (1.46%) Retail
9 2 (1.46%) Law
10 1 (0.73%) Legal
10 1 (0.73%) Manufacturing
10 1 (0.73%) Electronics
10 1 (0.73%) Back Office
10 1 (0.73%) Games
10 1 (0.73%) Billing
Job Titles
1 86 (62.77%) Developer
2 31 (22.63%) Analyst
3 29 (21.17%) Business Intelligence Developer
4 28 (20.44%) Senior Developer
5 26 (18.98%) Consultant
6 19 (13.87%) Analyst Developer
7 17 (12.41%) Business Intelligence Consultant
8 13 (9.49%) MI Analyst
9 12 (8.76%) SQL Developer
9 12 (8.76%) Java Developer
10 11 (8.03%) Senior Java Developer
11 10 (7.30%) Architect
12 9 (6.57%) Business Developer
12 9 (6.57%) Java Consultant
13 8 (5.84%) Senior Java Consultant
13 8 (5.84%) Senior Consultant
13 8 (5.84%) DBA
14 7 (5.11%) Senior Architect
14 7 (5.11%) Business Intelligence Analyst
14 7 (5.11%) Oracle Developer
Libraries, Frameworks & Software Standards
1 29 (21.17%) MDX
2 7 (5.11%) .NET
2 7 (5.11%) XML
3 5 (3.65%) XSD
3 5 (3.65%) XSLT
4 2 (1.46%) SAP XI
5 1 (0.73%) ASP.NET Web Forms
5 1 (0.73%) Cascading
5 1 (0.73%) MSMQ
5 1 (0.73%) ASP.NET
5 1 (0.73%) COM
5 1 (0.73%) Web Services
5 1 (0.73%) .NET Remoting
5 1 (0.73%) WCF
5 1 (0.73%) Spring.NET
5 1 (0.73%) WinForms
5 1 (0.73%) NHibernate
Miscellaneous
1 24 (17.52%) Analytical Skills
2 10 (7.30%) Data Structures
3 8 (5.84%) Data Integration
3 8 (5.84%) Replication
4 4 (2.92%) Open Source
4 4 (2.92%) Management Information System
5 3 (2.19%) Hedge funds
5 3 (2.19%) Clustering
5 3 (2.19%) Data Conversion
6 2 (1.46%) Reference Data
6 2 (1.46%) Computer Science
6 2 (1.46%) Visualisation
7 1 (0.73%) Digital Media
7 1 (0.73%) N-Tier
7 1 (0.73%) PMI
7 1 (0.73%) Fixed Income
7 1 (0.73%) Foreign Exchange (FX)
7 1 (0.73%) DTV
7 1 (0.73%) Economics
Operating Systems
1 14 (10.22%) Windows
2 6 (4.38%) Linux
3 2 (1.46%) Windows Server 2008
3 2 (1.46%) Windows Server 2012
Processes & Methodologies
1 109 (79.56%) Business Intelligence
2 89 (64.96%) ETL
3 55 (40.15%) Data Modelling
4 41 (29.93%) Analytics
5 20 (14.60%) Agile Software Development
6 18 (13.14%) Data Analysis
7 14 (10.22%) Regression Testing
8 13 (9.49%) Kimball Methodology
8 13 (9.49%) Data Architecture
9 12 (8.76%) Mentoring
10 11 (8.03%) Dimensional Modelling
11 10 (7.30%) Project Management
12 9 (6.57%) Database Security
12 9 (6.57%) Change Control
12 9 (6.57%) Data Management
13 8 (5.84%) Information Management
13 8 (5.84%) Data Cleansing
13 8 (5.84%) Performance Tuning
14 7 (5.11%) Low Latency
14 7 (5.11%) Scrum
Programming Languages
1 85 (62.04%) SQL
2 31 (22.63%) T-SQL
3 19 (13.87%) Java
4 13 (9.49%) PL/SQL
5 6 (4.38%) C
5 6 (4.38%) C#
6 5 (3.65%) Data Analysis Expressions (DAX)
7 2 (1.46%) PowerShell
8 1 (0.73%) R
8 1 (0.73%) JavaScript
8 1 (0.73%) VB.NET
8 1 (0.73%) VBA
Qualifications
1 23 (16.79%) Degree
2 8 (5.84%) Microsoft Certification
3 6 (4.38%) IBM Certification
3 6 (4.38%) OCP
3 6 (4.38%) Oracle Certification
3 6 (4.38%) MCSE
4 2 (1.46%) MCITP
4 2 (1.46%) SC Cleared
4 2 (1.46%) Security Cleared
4 2 (1.46%) MCDBA
5 1 (0.73%) PMI Certification
Quality Assurance & Compliance
1 4 (2.92%) Data Quality
2 3 (2.19%) QA
3 1 (0.73%) Solvency II
System Software
1 1 (0.73%) Oracle RAC
Vendors
1 65 (47.45%) Microsoft
2 34 (24.82%) Oracle
3 25 (18.25%) Tableau
4 24 (17.52%) SAP
5 23 (16.79%) Business Objects
6 22 (16.06%) Cognos
7 16 (11.68%) IBM
8 14 (10.22%) Sybase
9 13 (9.49%) Informatica
10 11 (8.03%) Teradata
11 10 (7.30%) MicroStrategy
11 10 (7.30%) Hyperion
12 9 (6.57%) Netezza
13 6 (4.38%) Logi Analytics
14 3 (2.19%) Ab Initio
14 3 (2.19%) DataFlux
15 2 (1.46%) ION Trading
15 2 (1.46%) Sun
15 2 (1.46%) Pegasus
15 2 (1.46%) Birst
City, London
Miller Maxwell Ltd
Salary: From £35,000 to £55,000 per annum +Bonus +Benefits
Posted: 3 days ago
City, London
Miller Maxwell Ltd
Salary: From £60,000 to £80,000 per annum +Bonus +Benefits
Posted: 3 days ago
City, London
Nigel Frank International Ltd
Salary: £50000 - £60000 per annum
Posted: 3 days ago
City, London
Lewis Paige
Salary: £45000 - £55000 per annum
Posted: 4 days ago
City, London
McGregor Boyall
Salary: £40000 - £50000 per annum + benefits
Posted: 5 days ago
City, London
Informatiq Consulting
Salary: £30000 - £35000 per annum + full bens
Posted: 6 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £65000 - £75000 per annum
Posted: 12 days ago
City of London
Real Staffing
Salary: competitive
Posted: 19 days ago
City of London
Interquest - IQ Telecom
Salary: £50000 - £55000 per annum + bonus + pension
Posted: 21 days ago
City of London
Deerfoot IT
Salary: £60000 - £70000 per annum + banking bonus + bens
Posted: 27 days ago