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 22 September 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
22 Sep 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 196 252 201
Rank change year-on-year
+56 -51
Permanent jobs citing OLAP 132 70 146
As % of all permanent IT jobs located in the City of London 1.15% 0.59% 1.14%
As % of the Database & Business Intelligence category 4.10% 2.07% 4.07%
Number of salaries quoted 117 59 136
Average salary £60,000 £60,000 £55,000
Average salary % change year-on-year
- +9.09%
90% offered a salary of more than £47,500 £44,500 £40,000
10% offered a salary of more than £72,500 £72,500 £77,500
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -
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
3216 3377 3589
As % of all permanent IT jobs located in the City of London 28.14% 28.45% 28.01%
Number of salaries quoted 2819 3025 3296
Average salary £54,500 £55,000 £55,000
Average salary % change year-on-year
-0.90% -
90% offered a salary of more than £37,500 £37,500 £35,000
10% offered a salary of more than £75,000 £75,000 £72,500
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

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 22 September 2014.

OLAP Salary Histogram in the City of London

OLAP
Top 30 Related IT Skills in the City of London

For the 6 months to 22 September 2014, 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 211 (84.06%) SQL Server
2 174 (69.32%) SQL Server Analysis Services
3 169 (67.33%) SQL Server Integration Services
4 165 (65.74%) Business Intelligence
5 156 (62.15%) SQL
6 155 (61.75%) Data Warehouse
7 146 (58.17%) SQL Server Reporting Services
8 125 (49.80%) ETL
9 98 (39.04%) Microsoft
10 81 (32.27%) MDX
11 77 (30.68%) Finance
12 76 (30.28%) SQL Server 2008
13 68 (27.09%) Data Modelling
13 68 (27.09%) .NET
14 67 (26.69%) T-SQL
15 54 (21.51%) Oracle
15 54 (21.51%) MS Excel
15 54 (21.51%) Oracle OLAP
16 45 (17.93%) C#
17 43 (17.13%) XML
18 39 (15.54%) Banking
18 39 (15.54%) Kimball Methodology
19 36 (14.34%) Performance Tuning
20 35 (13.94%) Agile Software Development
21 34 (13.55%) SharePoint
22 33 (13.15%) Scrum
23 32 (12.75%) OLTP
24 27 (10.76%) ASP.NET
24 27 (10.76%) MS Office
24 27 (10.76%) SQL Server 2012

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

For the 6 months to 22 September 2014, 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 34 (13.55%) SharePoint
2 13 (5.18%) SAS
3 9 (3.59%) IIS
3 9 (3.59%) BizTalk Server
4 5 (1.99%) SharePoint 2010
5 2 (0.80%) Tomcat
5 2 (0.80%) Oracle Coherence
6 1 (0.40%) SharePoint Server
6 1 (0.40%) CMS
6 1 (0.40%) SharePoint 2013
6 1 (0.40%) Apache Pig
6 1 (0.40%) Sitecore CMS
Applications
1 54 (21.51%) MS Excel
2 27 (10.76%) MS Office
3 9 (3.59%) MS Project
3 9 (3.59%) PowerPivot
4 8 (3.19%) MS Visio
5 1 (0.40%) MS PowerPoint
5 1 (0.40%) SPSS
Business Applications
1 6 (2.39%) Cognos TM1
2 4 (1.59%) Cognos Business Intelligence
3 3 (1.20%) Oracle General Ledger
4 2 (0.80%) Hyperion Planning
4 2 (0.80%) HFM
4 2 (0.80%) Oracle EBS
4 2 (0.80%) Dynamics NAV
5 1 (0.40%) Dynamics CRM
5 1 (0.40%) Oracle CRM
5 1 (0.40%) Magento
Communications & Networking
1 14 (5.58%) Intranet
2 3 (1.20%) SAN
3 2 (0.80%) LDAP
4 1 (0.40%) Internet
Database & Business Intelligence
1 211 (84.06%) SQL Server
2 174 (69.32%) SQL Server Analysis Services
3 169 (67.33%) SQL Server Integration Services
4 155 (61.75%) Data Warehouse
5 146 (58.17%) SQL Server Reporting Services
6 76 (30.28%) SQL Server 2008
7 54 (21.51%) Oracle OLAP
8 32 (12.75%) OLTP
9 27 (10.76%) SQL Server 2012
10 26 (10.36%) Oracle Database
10 26 (10.36%) Microsoft Analysis Services
10 26 (10.36%) SQL Server 2005
11 23 (9.16%) Data Mining
12 18 (7.17%) Relational Database
12 18 (7.17%) QlikView
13 17 (6.77%) Oracle Database 11g
14 16 (6.37%) RDBMS
15 11 (4.38%) MySQL
15 11 (4.38%) SQL Server 2000
15 11 (4.38%) Oracle Exadata
Development Applications
1 11 (4.38%) Team Foundation Server
2 9 (3.59%) ERwin
2 9 (3.59%) PowerDesigner
3 8 (3.19%) Visual Studio
4 6 (2.39%) Subversion
5 2 (0.80%) WiX
5 2 (0.80%) Ant
6 1 (0.40%) Oracle APEX
6 1 (0.40%) Maven
6 1 (0.40%) JUnit
6 1 (0.40%) Eclipse
6 1 (0.40%) Toad
General
1 77 (30.68%) Finance
2 39 (15.54%) Banking
3 20 (7.97%) Law
3 20 (7.97%) Investment Banking
4 18 (7.17%) Advertising
5 16 (6.37%) Marketing
6 7 (2.79%) Retail
7 6 (2.39%) International Banking
8 5 (1.99%) Legal
8 5 (1.99%) Front Office
9 4 (1.59%) Pharmaceutical
10 3 (1.20%) General Ledger
10 3 (1.20%) Financial Institution
11 2 (0.80%) Back Office
12 1 (0.40%) Games
12 1 (0.40%) Publishing
Job Titles
1 163 (64.94%) Developer
2 80 (31.87%) Business Intelligence Developer
3 38 (15.14%) SQL Developer
4 32 (12.75%) DBA
5 29 (11.55%) Senior Developer
6 22 (8.76%) ETL Developer
7 20 (7.97%) Analyst
8 15 (5.98%) Administrator
9 14 (5.58%) SQL DBA
10 11 (4.38%) Report Developer
10 11 (4.38%) Oracle DBA
10 11 (4.38%) Development Manager
11 10 (3.98%) Architect
11 10 (3.98%) Web Developer
11 10 (3.98%) Business Developer
11 10 (3.98%) Database Developer
12 9 (3.59%) Analyst Developer
12 9 (3.59%) SQL Server Developer
12 9 (3.59%) Senior Business Intelligence Developer
13 8 (3.19%) Consultant
Libraries, Frameworks & Software Standards
1 81 (32.27%) MDX
2 68 (27.09%) .NET
3 43 (17.13%) XML
4 27 (10.76%) ASP.NET
5 18 (7.17%) Web Services
6 15 (5.98%) HTML
6 15 (5.98%) CSS
7 9 (3.59%) OOXML
8 3 (1.20%) JMS
8 3 (1.20%) WPF
8 3 (1.20%) ASP.NET MVC
9 2 (0.80%) iXBRL
9 2 (0.80%) XBRL
9 2 (0.80%) ADO.NET
9 2 (0.80%) JDBC
9 2 (0.80%) WCF
9 2 (0.80%) .NET Framework
10 1 (0.40%) Spring
10 1 (0.40%) XML Schema
10 1 (0.40%) Razor View Engine
Miscellaneous
1 21 (8.37%) Analytical Skills
2 14 (5.58%) Reference Data
3 11 (4.38%) Clustering
4 10 (3.98%) Replication
4 10 (3.98%) Mathematics
4 10 (3.98%) Computer Science
5 6 (2.39%) Data Integration
6 5 (1.99%) Management Information System
7 4 (1.59%) Visualisation
7 4 (1.59%) Economics
8 3 (1.20%) Statistics
8 3 (1.20%) PMI
8 3 (1.20%) Market Risk
9 2 (0.80%) Inversion of Control
9 2 (0.80%) Data Conversion
9 2 (0.80%) iPhone
9 2 (0.80%) Oracle Exalogic
9 2 (0.80%) Oracle Exalytics
9 2 (0.80%) BBC
9 2 (0.80%) Derivative
Operating Systems
1 19 (7.57%) Windows
2 17 (6.77%) Linux
3 12 (4.78%) UNIX
4 7 (2.79%) Oracle Linux
5 3 (1.20%) Windows Server 2008
6 2 (0.80%) Red Hat Enterprise Linux
7 1 (0.40%) AIX
7 1 (0.40%) Apple iOS
Processes & Methodologies
1 165 (65.74%) Business Intelligence
2 125 (49.80%) ETL
3 68 (27.09%) Data Modelling
4 39 (15.54%) Kimball Methodology
5 36 (14.34%) Performance Tuning
6 35 (13.94%) Agile Software Development
7 33 (13.15%) Scrum
8 25 (9.96%) CRM
9 20 (7.97%) Project Management
10 19 (7.57%) Data Management
11 18 (7.17%) E-Commerce
11 18 (7.17%) Software Architecture
12 16 (6.37%) Data Architecture
13 14 (5.58%) Analytics
13 14 (5.58%) System Testing
13 14 (5.58%) OpenUP
14 12 (4.78%) Web Development
15 11 (4.38%) Dimensional Modelling
16 10 (3.98%) Migration
16 10 (3.98%) Practice Management
Programming Languages
1 156 (62.15%) SQL
2 67 (26.69%) T-SQL
3 45 (17.93%) C#
4 16 (6.37%) PL/SQL
5 15 (5.98%) Data Mining Extensions (DMX)
6 14 (5.58%) JavaScript
7 11 (4.38%) Shell Script
8 8 (3.19%) Data Analysis Expressions (DAX)
9 7 (2.79%) Java
10 6 (2.39%) VB
10 6 (2.39%) C
11 3 (1.20%) VB.NET
11 3 (1.20%) Python
11 3 (1.20%) R
11 3 (1.20%) SAS Macro
12 2 (0.80%) PowerShell
12 2 (0.80%) VBA
13 1 (0.40%) Perl
13 1 (0.40%) PHP
13 1 (0.40%) Bash Shell
Qualifications
1 23 (9.16%) Microsoft Certification
2 18 (7.17%) MCDBA
3 16 (6.37%) Degree
4 3 (1.20%) MCITP
4 3 (1.20%) MCTS
4 3 (1.20%) PMI Certification
5 1 (0.40%) PhD
5 1 (0.40%) CIMA
5 1 (0.40%) ACCA
5 1 (0.40%) SAS Certification
5 1 (0.40%) IIBA
Quality Assurance & Compliance
1 3 (1.20%) QA
2 1 (0.40%) GAAP
System Software
1 9 (3.59%) Oracle RAC
2 5 (1.99%) Oracle RMAN
3 3 (1.20%) VMware Infrastructure
4 2 (0.80%) VMware ESX
Systems Management
1 11 (4.38%) Data Guard
2 7 (2.79%) Oracle Enterprise Manager
3 4 (1.59%) Foglight
Vendors
1 98 (39.04%) Microsoft
2 54 (21.51%) Oracle
3 25 (9.96%) Business Objects
4 14 (5.58%) SAP
4 14 (5.58%) IBM
5 13 (5.18%) Cognos
6 10 (3.98%) Sybase
7 9 (3.59%) Dundas
8 7 (2.79%) MicroStrategy
8 7 (2.79%) Red Gate
9 5 (1.99%) VMware
9 5 (1.99%) Sun
10 3 (1.20%) PeopleSoft
10 3 (1.20%) Red Hat
10 3 (1.20%) Informatica
10 3 (1.20%) Nintex
11 2 (0.80%) Hyperion
11 2 (0.80%) Endeca
11 2 (0.80%) Netezza
12 1 (0.40%) Applix
City of London
Nigel Frank International Limited - Newcastle
Salary: £30000 - £35000 per annum + Package
Posted: 4 hours ago
City, London
Quant Capital
Salary: Up to £100,000 per annum Bonus Medical Pension (8%)
Posted: 5 hours ago
City, London
Lawrence Harvey Enterprise
Salary: £55000.00 - £70000 per annum + Bonus
Posted: 8 hours ago
City of London
Real Staffing
Salary: £55000 - £68000 per annum + competitive
Posted: 3 days ago
City, London
Energon Technology
Salary: From £60,000 to £70,000 per annum + benefits + bonus
Posted: 3 days ago
City, London
Harrington Starr
Salary: £45000 - £85000 per annum + Bonus + benefits + training
Posted: 5 days ago
City of London
Churchill Frank
Salary: £45000 - £50000 per annum + Bonus + Pension + Benefits
Posted: 5 days ago
City, London
Digitech Resourcing Ltd
Salary: From £20,000 to £60,000 per annum Great Benefits and Training
Posted: 6 days ago
City, London
Bridge Noble
Salary: £75 - £75000 per annum
Posted: 6 days ago
City of London
iKonnect
Salary: £65000 - £85000 per annum + bonus
Posted: 7 days ago
City of London
Real Staffing
Salary: £50000 - £60000 per annum + competitive benefits package
Posted: 14 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £75000 per annum + Benefits Package
Posted: 19 days ago
City of London
Churchill Frank
Salary: £50000 - £60000 per annum + Pension + Benefits + Training
Posted: 24 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £65000 - £70000 per annum + Benefits Package
Posted: 26 days ago