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

Location
3 months to
30 Jan 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 252 237 225
Rank change year-on-year
-15 -12
Permanent jobs citing OLAP 58 77 89
As % of all permanent IT jobs located in the City of London 0.56% 0.74% 0.82%
As % of the Database & Business Intelligence category 2.15% 2.72% 2.80%
Number of salaries quoted 56 70 81
Average salary £68,750 £57,500 £50,000
Average salary % change year-on-year
+19.56% +15.00%
90% offered a salary of more than £40,000 £47,500 £33,000
10% offered a salary of more than £77,500 £80,500 £85,000
UK excluding London average salary £40,000 £40,000 £45,000
% change year-on-year
- -11.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
2693 2830 3173
As % of all permanent IT jobs located in the City of London 26.16% 27.30% 29.18%
Number of salaries quoted 2430 2477 2902
Average salary £55,000 £55,000 £50,000
Average salary % change year-on-year
- +10.00%
90% offered a salary of more than £37,500 £35,000 £35,000
10% offered a salary of more than £75,000 £74,400 £77,500
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +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 30 January 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 30 January 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 122 (73.94%) SQL Server
2 115 (69.70%) Business Intelligence
3 110 (66.67%) SQL
4 101 (61.21%) SQL Server Integration Services
5 98 (59.39%) ETL
6 97 (58.79%) SQL Server Analysis Services
7 94 (56.97%) SQL Server Reporting Services
8 93 (56.36%) Data Warehouse
9 75 (45.45%) Finance
10 71 (43.03%) OLAP Cube
11 62 (37.58%) Microsoft
12 59 (35.76%) T-SQL
13 51 (30.91%) Oracle
13 51 (30.91%) Oracle OLAP
14 46 (27.88%) SQL Server 2008
15 43 (26.06%) Data Modelling
16 39 (23.64%) SQL Server 2012
17 34 (20.61%) Banking
18 33 (20.00%) MDX
19 32 (19.39%) Analytics
20 31 (18.79%) MS Excel
21 29 (17.58%) Analytical Skills
22 28 (16.97%) SharePoint
22 28 (16.97%) OLTP
23 23 (13.94%) Agile Software Development
24 22 (13.33%) .NET
25 21 (12.73%) Business Objects
25 21 (12.73%) Cognos
25 21 (12.73%) Degree
25 21 (12.73%) Tableau

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

For the 6 months to 30 January 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 28 (16.97%) SharePoint
2 10 (6.06%) SharePoint 2010
3 5 (3.03%) SharePoint 2013
4 4 (2.42%) SAS
4 4 (2.42%) BizTalk Server
5 1 (0.61%) SharePoint Foundation
5 1 (0.61%) SharePoint Server
5 1 (0.61%) Tomcat
Applications
1 31 (18.79%) MS Excel
2 11 (6.67%) PowerPivot
2 11 (6.67%) MS Office
3 8 (4.85%) MS Visio
4 1 (0.61%) FastStats
4 1 (0.61%) SPSS
Business Applications
1 10 (6.06%) Cognos TM1
1 10 (6.06%) Hyperion Planning
2 9 (5.45%) Cognos Business Intelligence
3 4 (2.42%) Oracle EBS
4 2 (1.21%) Oracle Financials
4 2 (1.21%) HFM
4 2 (1.21%) Dynamics NAV
4 2 (1.21%) Oracle General Ledger
4 2 (1.21%) Oracle EBS R12
4 2 (1.21%) Oracle Procure-to-Pay
5 1 (0.61%) SAP BPC
5 1 (0.61%) Cognos Planning
Cloud Services
1 3 (1.82%) Cloud Computing
1 3 (1.82%) SaaS
Communications & Networking
1 2 (1.21%) SAN
2 1 (0.61%) Intranet
2 1 (0.61%) LDAP
Database & Business Intelligence
1 122 (73.94%) SQL Server
2 101 (61.21%) SQL Server Integration Services
3 97 (58.79%) SQL Server Analysis Services
4 94 (56.97%) SQL Server Reporting Services
5 93 (56.36%) Data Warehouse
6 71 (43.03%) OLAP Cube
7 51 (30.91%) Oracle OLAP
8 46 (27.88%) SQL Server 2008
9 39 (23.64%) SQL Server 2012
10 28 (16.97%) OLTP
11 20 (12.12%) Oracle Database
11 20 (12.12%) QlikView
12 17 (10.30%) Oracle Database 11g
13 15 (9.09%) Microsoft Analysis Services
14 12 (7.27%) DB2
14 12 (7.27%) Big Data
14 12 (7.27%) Relational Database
15 11 (6.67%) Oracle Database 12c
15 11 (6.67%) Oracle BI EE
16 10 (6.06%) Essbase
Development Applications
1 8 (4.85%) PowerDesigner
2 6 (3.64%) Subversion
3 4 (2.42%) Visual Studio
4 3 (1.82%) Oracle Forms
5 2 (1.21%) Team Foundation Server
6 1 (0.61%) Maven
6 1 (0.61%) ERwin
6 1 (0.61%) JUnit
General
1 75 (45.45%) Finance
2 34 (20.61%) Banking
3 15 (9.09%) Law
4 12 (7.27%) Investment Banking
5 8 (4.85%) General Ledger
6 7 (4.24%) Advertising
7 6 (3.64%) Financial Institution
8 4 (2.42%) Retail
8 4 (2.42%) Marketing
9 3 (1.82%) Front Office
10 1 (0.61%) Back Office
10 1 (0.61%) Telecoms
Job Titles
1 100 (60.61%) Developer
2 46 (27.88%) Business Intelligence Developer
3 22 (13.33%) SQL Developer
4 21 (12.73%) Consultant
5 20 (12.12%) Analyst
6 19 (11.52%) Senior Developer
7 15 (9.09%) Database Developer
8 14 (8.48%) DBA
8 14 (8.48%) Business Developer
9 12 (7.27%) Business Intelligence Consultant
10 11 (6.67%) SQL Server Developer
11 10 (6.06%) ETL Developer
12 9 (5.45%) SQL Database Developer
13 8 (4.85%) Architect
14 7 (4.24%) TM1 Consultant
14 7 (4.24%) Senior Business Intelligence Developer
14 7 (4.24%) Senior Architect
14 7 (4.24%) MI Analyst
14 7 (4.24%) Cognos Consultant
14 7 (4.24%) Data Analyst
Libraries, Frameworks & Software Standards
1 33 (20.00%) MDX
2 22 (13.33%) .NET
3 14 (8.48%) XML
4 4 (2.42%) Web Services
5 2 (1.21%) SAP XI
6 1 (0.61%) Spring
6 1 (0.61%) HTML
6 1 (0.61%) ASP.NET
6 1 (0.61%) CSS
Miscellaneous
1 29 (17.58%) Analytical Skills
2 12 (7.27%) Data Integration
2 12 (7.27%) Reference Data
3 10 (6.06%) Clustering
4 5 (3.03%) Visualisation
5 4 (2.42%) BBC
5 4 (2.42%) Replication
5 4 (2.42%) iPhone
5 4 (2.42%) Data Structures
6 3 (1.82%) Data Conversion
6 3 (1.82%) PMI
7 2 (1.21%) Mathematics
7 2 (1.21%) Oracle Exalogic
7 2 (1.21%) Oracle Exalytics
8 1 (0.61%) Digital Media
8 1 (0.61%) Hedge funds
8 1 (0.61%) Computer Science
8 1 (0.61%) Economics
8 1 (0.61%) Derivative
8 1 (0.61%) Management Information System
Operating Systems
1 6 (3.64%) Windows
2 5 (3.03%) UNIX
3 3 (1.82%) Linux
4 1 (0.61%) Oracle Linux
Processes & Methodologies
1 115 (69.70%) Business Intelligence
2 98 (59.39%) ETL
3 43 (26.06%) Data Modelling
4 32 (19.39%) Analytics
5 23 (13.94%) Agile Software Development
6 18 (10.91%) Scrum
7 17 (10.30%) Data Architecture
7 17 (10.30%) Data Management
8 16 (9.70%) Data Analysis
9 15 (9.09%) Project Management
9 15 (9.09%) Kimball Methodology
10 12 (7.27%) Performance Tuning
11 11 (6.67%) E-Commerce
12 10 (6.06%) CRM
12 10 (6.06%) Disaster Recovery
12 10 (6.06%) Dimensional Modelling
13 9 (5.45%) Software Architecture
13 9 (5.45%) OpenUP
13 9 (5.45%) System Testing
14 8 (4.85%) Load Balancing
Programming Languages
1 110 (66.67%) SQL
2 59 (35.76%) T-SQL
3 13 (7.88%) PL/SQL
4 12 (7.27%) Data Analysis Expressions (DAX)
5 9 (5.45%) C#
6 8 (4.85%) Java
7 4 (2.42%) R
8 3 (1.82%) Shell Script
8 3 (1.82%) VBA
9 2 (1.21%) JavaScript
9 2 (1.21%) SAS Macro
9 2 (1.21%) PowerShell
10 1 (0.61%) Data Mining Extensions (DMX)
10 1 (0.61%) Python
Qualifications
1 21 (12.73%) Degree
2 17 (10.30%) Microsoft Certification
3 10 (6.06%) MCDBA
4 7 (4.24%) MCSE
4 7 (4.24%) IBM Certification
5 3 (1.82%) PMI Certification
6 1 (0.61%) SAS Certification
Quality Assurance & Compliance
1 5 (3.03%) Data Quality
2 3 (1.82%) QA
3 1 (0.61%) Solvency II
System Software
1 7 (4.24%) Oracle RAC
Systems Management
1 1 (0.61%) Data Guard
1 1 (0.61%) Foglight
1 1 (0.61%) Oracle Enterprise Manager
Vendors
1 62 (37.58%) Microsoft
2 51 (30.91%) Oracle
3 21 (12.73%) Business Objects
3 21 (12.73%) Cognos
3 21 (12.73%) Tableau
4 18 (10.91%) SAP
5 15 (9.09%) Informatica
6 14 (8.48%) IBM
7 12 (7.27%) Hyperion
8 11 (6.67%) Teradata
9 10 (6.06%) Netezza
10 7 (4.24%) Logi Analytics
11 6 (3.64%) Sybase
12 4 (2.42%) MicroStrategy
13 3 (1.82%) Birst
13 3 (1.82%) Nintex
14 2 (1.21%) Sun
14 2 (1.21%) PeopleSoft
14 2 (1.21%) Pegasus
14 2 (1.21%) Endeca
City, London
Ashdown IT
Salary: £70000 - £75000 per annum
Posted: 21 hours ago
City, London
Henderson Drake
Salary: From £45,000 to £60,000 per annum Bonus + Pension + Insurance + Dental
Posted: Yesterday
City, London
Energon People
Salary: £0.00 per annum
Posted: Yesterday
City of London
Interquest - IQ Telecom
Salary: £50000.0000 per annum + bonus + pension
Posted: 3 days ago
City, London
TEKsystems
Salary: £65000 - £75000 per annum + Excellent Bonus + Benefits
Posted: 4 days ago
City, London
Understanding Recruitment
Salary: £65000 - £80000 per annum + Bens - Health, Pension,
Posted: 4 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £60000 - £70000 per annum + benefits, bonus
Posted: 25 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £35000 - £38000 per annum
Posted: 25 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £40000 - £45000 per annum
Posted: 25 days ago