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

Location
3 months to
27 Feb 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 263 243 219
Rank change year-on-year
-20 -24
Permanent jobs citing OLAP 48 70 96
As % of all permanent IT jobs located in the City of London 0.46% 0.67% 0.88%
As % of the Database & Business Intelligence category 1.72% 2.46% 3.07%
Number of salaries quoted 45 57 84
Average salary £70,000 £57,500 £50,000
Average salary % change year-on-year
+21.73% +15.00%
90% offered a salary of more than £46,600 £45,000 £35,000
10% offered a salary of more than £75,000 £87,000 £77,750
UK excluding London average salary £42,500 £40,000 £45,000
% change year-on-year
+6.25% -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
2783 2841 3125
As % of all permanent IT jobs located in the City of London 26.75% 27.35% 28.77%
Number of salaries quoted 2465 2478 2855
Average salary £55,000 £55,000 £50,000
Average salary % change year-on-year
- +10.00%
90% offered a salary of more than £38,000 £35,000 £35,000
10% offered a salary of more than £75,000 £70,900 £75,000
UK excluding London average salary £40,000 £40,000 £39,000
% change year-on-year
- +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 27 February 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 27 February 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 (70.29%) SQL Server
2 96 (69.57%) Business Intelligence
3 90 (65.22%) SQL
4 86 (62.32%) ETL
5 84 (60.87%) SQL Server Integration Services
6 81 (58.70%) SQL Server Reporting Services
7 78 (56.52%) SQL Server Analysis Services
8 74 (53.62%) Data Warehouse
9 67 (48.55%) Finance
10 57 (41.30%) Microsoft
11 54 (39.13%) OLAP Cube
12 51 (36.96%) T-SQL
13 43 (31.16%) Data Modelling
14 40 (28.99%) Oracle
14 40 (28.99%) Oracle OLAP
15 36 (26.09%) SQL Server 2008
16 34 (24.64%) SQL Server 2012
17 33 (23.91%) Analytics
18 30 (21.74%) Analytical Skills
19 29 (21.01%) Banking
20 25 (18.12%) Tableau
21 24 (17.39%) Degree
22 23 (16.67%) OLTP
23 22 (15.94%) MDX
24 21 (15.22%) Agile Software Development
24 21 (15.22%) Business Objects
24 21 (15.22%) MS Excel
25 19 (13.77%) SAP
26 18 (13.04%) SharePoint
26 18 (13.04%) Cognos

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

For the 6 months to 27 February 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 (13.04%) SharePoint
2 7 (5.07%) SharePoint 2010
3 5 (3.62%) SharePoint 2013
4 4 (2.90%) SAS
4 4 (2.90%) BizTalk Server
5 1 (0.72%) SharePoint Server
5 1 (0.72%) Tomcat
5 1 (0.72%) SharePoint Foundation
Applications
1 21 (15.22%) MS Excel
2 10 (7.25%) MS Visio
3 8 (5.80%) PowerPivot
4 7 (5.07%) MS Office
5 1 (0.72%) SPSS
5 1 (0.72%) FastStats
Business Applications
1 10 (7.25%) Hyperion Planning
2 9 (6.52%) Cognos TM1
2 9 (6.52%) Cognos Business Intelligence
3 4 (2.90%) Oracle EBS
4 2 (1.45%) HFM
4 2 (1.45%) Oracle Financials
4 2 (1.45%) Dynamics NAV
4 2 (1.45%) Oracle EBS R12
4 2 (1.45%) Oracle Procure-to-Pay
5 1 (0.72%) ION MarketView
5 1 (0.72%) SAP BPC
5 1 (0.72%) Cognos Planning
5 1 (0.72%) SAP Oil and Gas
Cloud Services
1 3 (2.17%) Cloud Computing
1 3 (2.17%) SaaS
Communications & Networking
1 2 (1.45%) SAN
Database & Business Intelligence
1 97 (70.29%) SQL Server
2 84 (60.87%) SQL Server Integration Services
3 81 (58.70%) SQL Server Reporting Services
4 78 (56.52%) SQL Server Analysis Services
5 74 (53.62%) Data Warehouse
6 54 (39.13%) OLAP Cube
7 40 (28.99%) Oracle OLAP
8 36 (26.09%) SQL Server 2008
9 34 (24.64%) SQL Server 2012
10 23 (16.67%) OLTP
11 17 (12.32%) QlikView
11 17 (12.32%) Oracle Database
12 15 (10.87%) Big Data
12 15 (10.87%) Oracle Database 11g
13 14 (10.14%) Relational Database
14 11 (7.97%) Oracle Database 12c
15 10 (7.25%) Oracle BI EE
15 10 (7.25%) Essbase
15 10 (7.25%) DB2
16 8 (5.80%) DataStage
Development Applications
1 10 (7.25%) PowerDesigner
2 3 (2.17%) Subversion
2 3 (2.17%) Oracle Forms
3 2 (1.45%) Team Foundation Server
4 1 (0.72%) Maven
4 1 (0.72%) ERwin
4 1 (0.72%) JUnit
4 1 (0.72%) Visual Studio
General
1 67 (48.55%) Finance
2 29 (21.01%) Banking
3 10 (7.25%) Law
3 10 (7.25%) General Ledger
4 8 (5.80%) Investment Banking
5 7 (5.07%) Advertising
6 6 (4.35%) Financial Institution
7 5 (3.62%) Marketing
8 4 (2.90%) Retail
9 3 (2.17%) Front Office
10 2 (1.45%) Telecoms
11 1 (0.72%) Electronics
11 1 (0.72%) Manufacturing
Job Titles
1 80 (57.97%) Developer
2 28 (20.29%) Business Intelligence Developer
3 26 (18.84%) Consultant
4 19 (13.77%) Analyst
4 19 (13.77%) SQL Developer
5 17 (12.32%) Senior Developer
6 15 (10.87%) Business Intelligence Consultant
7 12 (8.70%) DBA
8 10 (7.25%) Business Developer
8 10 (7.25%) SQL Server Developer
9 9 (6.52%) Java Consultant
9 9 (6.52%) Java Developer
9 9 (6.52%) Database Developer
9 9 (6.52%) MI Analyst
10 8 (5.80%) Senior Java Developer
10 8 (5.80%) Analyst Developer
10 8 (5.80%) Architect
11 7 (5.07%) Senior Consultant
11 7 (5.07%) Business Consultant
11 7 (5.07%) Data Analyst
Libraries, Frameworks & Software Standards
1 22 (15.94%) MDX
2 9 (6.52%) .NET
3 8 (5.80%) XML
4 2 (1.45%) SAP XI
5 1 (0.72%) Spring
5 1 (0.72%) XSD
5 1 (0.72%) XSLT
5 1 (0.72%) COM
Miscellaneous
1 30 (21.74%) Analytical Skills
2 10 (7.25%) Clustering
3 9 (6.52%) Data Integration
4 8 (5.80%) Reference Data
5 5 (3.62%) Data Structures
6 4 (2.90%) Replication
7 3 (2.17%) Data Conversion
7 3 (2.17%) Visualisation
8 2 (1.45%) Oracle Exalogic
8 2 (1.45%) iPhone
8 2 (1.45%) BBC
8 2 (1.45%) Oracle Exalytics
9 1 (0.72%) DTV
9 1 (0.72%) Management Information System
9 1 (0.72%) Economics
9 1 (0.72%) Derivative
9 1 (0.72%) Computer Science
9 1 (0.72%) Digital Media
9 1 (0.72%) Open Source
9 1 (0.72%) Hedge funds
Operating Systems
1 4 (2.90%) UNIX
2 3 (2.17%) Windows
3 2 (1.45%) Linux
4 1 (0.72%) Oracle Linux
Processes & Methodologies
1 96 (69.57%) Business Intelligence
2 86 (62.32%) ETL
3 43 (31.16%) Data Modelling
4 33 (23.91%) Analytics
5 21 (15.22%) Agile Software Development
6 15 (10.87%) Data Analysis
7 13 (9.42%) Data Management
8 12 (8.70%) Data Architecture
9 11 (7.97%) Dimensional Modelling
9 11 (7.97%) Kimball Methodology
9 11 (7.97%) Scrum
10 9 (6.52%) Project Management
10 9 (6.52%) Performance Tuning
11 8 (5.80%) High Availability
11 8 (5.80%) Regression Testing
11 8 (5.80%) Disaster Recovery
11 8 (5.80%) E-Commerce
11 8 (5.80%) Load Balancing
12 7 (5.07%) Information Management
12 7 (5.07%) PRINCE
Programming Languages
1 90 (65.22%) SQL
2 51 (36.96%) T-SQL
3 12 (8.70%) Java
4 9 (6.52%) PL/SQL
5 5 (3.62%) Data Analysis Expressions (DAX)
6 4 (2.90%) R
7 3 (2.17%) Shell Script
7 3 (2.17%) C#
8 2 (1.45%) SAS Macro
8 2 (1.45%) PowerShell
9 1 (0.72%) Data Mining Extensions (DMX)
9 1 (0.72%) JavaScript
9 1 (0.72%) VBA
9 1 (0.72%) Python
Qualifications
1 24 (17.39%) Degree
2 12 (8.70%) Microsoft Certification
3 7 (5.07%) MCSE
3 7 (5.07%) IBM Certification
4 5 (3.62%) MCDBA
5 1 (0.72%) SAS Certification
Quality Assurance & Compliance
1 5 (3.62%) Data Quality
2 3 (2.17%) QA
3 1 (0.72%) Solvency II
System Software
1 7 (5.07%) Oracle RAC
Systems Management
1 1 (0.72%) Oracle Enterprise Manager
1 1 (0.72%) Foglight
1 1 (0.72%) Data Guard
Vendors
1 57 (41.30%) Microsoft
2 40 (28.99%) Oracle
3 25 (18.12%) Tableau
4 21 (15.22%) Business Objects
5 19 (13.77%) SAP
6 18 (13.04%) Cognos
7 14 (10.14%) Informatica
8 12 (8.70%) Hyperion
9 11 (7.97%) Teradata
9 11 (7.97%) IBM
10 8 (5.80%) Sybase
10 8 (5.80%) Netezza
11 7 (5.07%) Logi Analytics
12 4 (2.90%) MicroStrategy
13 3 (2.17%) Birst
14 2 (1.45%) Endeca
14 2 (1.45%) Pegasus
14 2 (1.45%) Sun
15 1 (0.72%) CA
15 1 (0.72%) ION Trading
City, London
Harrington Starr
Salary: £45000 - £75000 per annum + Bonus + benefits + training
Posted: 5 hours ago
City of London
Real Staffing
Salary: £50000 - £60000 per annum + competitive
Posted: 7 hours ago
City, London
Vadis People
Salary: Up to £75,000 + good bens package
Posted: Yesterday
City, London
Streamline Connections
Salary: £45000 - £65000 per annum + Benefits
Posted: Yesterday
City of London
Interquest - IQ Telecom
Salary: £50000.0000 per annum + bonus + pension
Posted: Yesterday
City, London
Ashdown IT
Salary: £70000 - £75000 per annum
Posted: 2 days ago
City of London
Lewis Paige
Salary: £45000 - £55000 per annum
Posted: 2 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £60000 - £70000 per annum + benefits, bonus
Posted: 4 days ago
City, London
Understanding Recruitment
Salary: £65000 - £80000 per annum + Bens - Health, Pension,
Posted: 5 days ago