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

Location
3 months to
22 Aug 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 188 244 204
Rank change year-on-year
+56 -40
Permanent jobs citing OLAP 144 76 138
As % of all permanent IT jobs located in the City of London 1.20% 0.63% 1.07%
As % of the Database & Business Intelligence category 4.09% 2.24% 3.77%
Number of salaries quoted 127 67 129
Average salary £60,000 £60,000 £55,000
Average salary % change year-on-year
- +9.09%
90% offered a salary of more than £45,000 £39,000 £43,300
10% offered a salary of more than £72,500 £69,500 £78,000
UK excluding London average salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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
3519 3400 3658
As % of all permanent IT jobs located in the City of London 29.22% 28.06% 28.45%
Number of salaries quoted 3063 3055 3380
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 £36,500
10% offered a salary of more than £75,000 £75,000 £72,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 22 August 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 August 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 204 (84.30%) SQL Server
2 166 (68.60%) SQL Server Analysis Services
3 162 (66.94%) Business Intelligence
3 162 (66.94%) SQL Server Integration Services
4 148 (61.16%) Data Warehouse
5 147 (60.74%) SQL
6 143 (59.09%) SQL Server Reporting Services
7 118 (48.76%) ETL
8 97 (40.08%) Microsoft
9 91 (37.60%) MDX
10 82 (33.88%) SQL Server 2008
11 69 (28.51%) Finance
12 68 (28.10%) T-SQL
13 67 (27.69%) .NET
14 60 (24.79%) Data Modelling
15 50 (20.66%) MS Excel
16 48 (19.83%) Oracle
16 48 (19.83%) Oracle OLAP
17 47 (19.42%) C#
18 39 (16.12%) XML
19 38 (15.70%) Banking
19 38 (15.70%) Kimball Methodology
20 37 (15.29%) Performance Tuning
21 35 (14.46%) OLTP
22 33 (13.64%) SQL Server 2005
23 30 (12.40%) SharePoint
24 29 (11.98%) ASP.NET
24 29 (11.98%) Scrum
25 28 (11.57%) SQL Server 2012
26 27 (11.16%) Data Mining

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

For the 6 months to 22 August 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 30 (12.40%) SharePoint
2 13 (5.37%) BizTalk Server
3 10 (4.13%) SAS
4 9 (3.72%) IIS
5 4 (1.65%) SharePoint 2010
6 2 (0.83%) Oracle Coherence
7 1 (0.41%) Apache Pig
7 1 (0.41%) Sitecore CMS
7 1 (0.41%) CMS
7 1 (0.41%) SharePoint Server
7 1 (0.41%) Apache
7 1 (0.41%) Tomcat
Applications
1 50 (20.66%) MS Excel
2 24 (9.92%) MS Office
3 9 (3.72%) PowerPivot
3 9 (3.72%) MS Project
4 4 (1.65%) MS Visio
5 1 (0.41%) MS PowerPoint
5 1 (0.41%) SPSS
Business Applications
1 6 (2.48%) Cognos TM1
2 3 (1.24%) Oracle General Ledger
2 3 (1.24%) Cognos Business Intelligence
2 3 (1.24%) Dynamics NAV
3 1 (0.41%) Hyperion Planning
3 1 (0.41%) Magento
3 1 (0.41%) Oracle CRM
3 1 (0.41%) Oracle EBS
3 1 (0.41%) Dynamics CRM
3 1 (0.41%) HFM
Cloud Services
1 2 (0.83%) SaaS
Communications & Networking
1 14 (5.79%) Intranet
2 3 (1.24%) SAN
3 2 (0.83%) LDAP
4 1 (0.41%) Internet
Database & Business Intelligence
1 204 (84.30%) SQL Server
2 166 (68.60%) SQL Server Analysis Services
3 162 (66.94%) SQL Server Integration Services
4 148 (61.16%) Data Warehouse
5 143 (59.09%) SQL Server Reporting Services
6 82 (33.88%) SQL Server 2008
7 48 (19.83%) Oracle OLAP
8 35 (14.46%) OLTP
9 33 (13.64%) SQL Server 2005
10 28 (11.57%) SQL Server 2012
11 27 (11.16%) Data Mining
12 24 (9.92%) Microsoft Analysis Services
13 23 (9.50%) Oracle Database
14 19 (7.85%) Relational Database
15 18 (7.44%) QlikView
16 17 (7.02%) RDBMS
17 14 (5.79%) Oracle Database 11g
18 11 (4.55%) MySQL
18 11 (4.55%) SQL Server 2000
19 9 (3.72%) Hadoop
Development Applications
1 11 (4.55%) Team Foundation Server
2 8 (3.31%) ERwin
2 8 (3.31%) Visual Studio
3 6 (2.48%) Subversion
4 5 (2.07%) PowerDesigner
5 2 (0.83%) Eclipse
5 2 (0.83%) Ant
5 2 (0.83%) WiX
6 1 (0.41%) Oracle APEX
6 1 (0.41%) Maven
6 1 (0.41%) JUnit
6 1 (0.41%) Toad
6 1 (0.41%) JDeveloper
General
1 69 (28.51%) Finance
2 38 (15.70%) Banking
3 24 (9.92%) Advertising
4 18 (7.44%) Investment Banking
5 15 (6.20%) Law
5 15 (6.20%) Marketing
6 8 (3.31%) Retail
7 7 (2.89%) Pharmaceutical
8 6 (2.48%) International Banking
9 5 (2.07%) Legal
9 5 (2.07%) Front Office
10 3 (1.24%) General Ledger
11 2 (0.83%) Financial Institution
11 2 (0.83%) Back Office
12 1 (0.41%) Billing
12 1 (0.41%) Games
12 1 (0.41%) Publishing
12 1 (0.41%) Telecoms
Job Titles
1 159 (65.70%) Developer
2 75 (30.99%) Business Intelligence Developer
3 36 (14.88%) SQL Developer
4 32 (13.22%) DBA
5 28 (11.57%) Senior Developer
6 18 (7.44%) ETL Developer
7 16 (6.61%) Administrator
8 15 (6.20%) Analyst
8 15 (6.20%) SQL DBA
9 14 (5.79%) Report Developer
10 11 (4.55%) Data Warehouse Developer
10 11 (4.55%) Development Manager
10 11 (4.55%) Architect
11 10 (4.13%) Web Developer
11 10 (4.13%) Business Developer
11 10 (4.13%) Oracle DBA
12 8 (3.31%) Senior Web Developer
12 8 (3.31%) SQL Server Developer
12 8 (3.31%) Team Leader
12 8 (3.31%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 91 (37.60%) MDX
2 67 (27.69%) .NET
3 39 (16.12%) XML
4 29 (11.98%) ASP.NET
5 18 (7.44%) Web Services
6 16 (6.61%) HTML
7 15 (6.20%) CSS
8 9 (3.72%) OOXML
9 5 (2.07%) WPF
10 4 (1.65%) ASP.NET MVC
11 3 (1.24%) Silverlight
11 3 (1.24%) WCF
11 3 (1.24%) JMS
12 2 (0.83%) XBRL
12 2 (0.83%) ADO.NET
12 2 (0.83%) JDBC
12 2 (0.83%) .NET Framework
12 2 (0.83%) iXBRL
13 1 (0.41%) AngularJS
13 1 (0.41%) Razor View Engine
Miscellaneous
1 12 (4.96%) Computer Science
2 11 (4.55%) Mathematics
2 11 (4.55%) Replication
3 10 (4.13%) Clustering
3 10 (4.13%) Reference Data
4 5 (2.07%) Data Integration
5 4 (1.65%) Management Information System
5 4 (1.65%) Economics
6 3 (1.24%) Market Risk
6 3 (1.24%) Statistics
6 3 (1.24%) PMI
7 2 (0.83%) BBC
7 2 (0.83%) iPhone
7 2 (0.83%) Inversion of Control
7 2 (0.83%) Visualisation
7 2 (0.83%) Credit Risk
8 1 (0.41%) Oracle Exalytics
8 1 (0.41%) Digital Media
8 1 (0.41%) Oracle Exalogic
8 1 (0.41%) Data Conversion
Operating Systems
1 20 (8.26%) Windows
2 15 (6.20%) Linux
3 10 (4.13%) UNIX
4 6 (2.48%) Oracle Linux
5 4 (1.65%) Windows Server 2008
6 2 (0.83%) Red Hat Enterprise Linux
7 1 (0.41%) Apple iOS
7 1 (0.41%) AIX
Processes & Methodologies
1 162 (66.94%) Business Intelligence
2 118 (48.76%) ETL
3 60 (24.79%) Data Modelling
4 38 (15.70%) Kimball Methodology
5 37 (15.29%) Performance Tuning
6 29 (11.98%) Scrum
7 21 (8.68%) CRM
8 20 (8.26%) Project Management
9 15 (6.20%) E-Commerce
9 15 (6.20%) Software Architecture
10 14 (5.79%) Agile Software Development
11 13 (5.37%) Data Management
12 12 (4.96%) Web Development
12 12 (4.96%) Data Architecture
13 11 (4.55%) Analytics
13 11 (4.55%) Migration
14 10 (4.13%) Practice Management
14 10 (4.13%) OpenUP
14 10 (4.13%) System Testing
15 9 (3.72%) Dimensional Modelling
Programming Languages
1 147 (60.74%) SQL
2 68 (28.10%) T-SQL
3 47 (19.42%) C#
4 19 (7.85%) Data Mining Extensions (DMX)
5 15 (6.20%) JavaScript
5 15 (6.20%) PL/SQL
6 10 (4.13%) Shell Script
7 9 (3.72%) Java
8 8 (3.31%) Data Analysis Expressions (DAX)
9 6 (2.48%) C
9 6 (2.48%) VB
10 3 (1.24%) VB.NET
11 2 (0.83%) Python
11 2 (0.83%) VBA
11 2 (0.83%) PowerShell
12 1 (0.41%) R
12 1 (0.41%) SAS Macro
12 1 (0.41%) Bash Shell
12 1 (0.41%) Perl
12 1 (0.41%) PHP
Qualifications
1 20 (8.26%) Microsoft Certification
2 19 (7.85%) Degree
3 14 (5.79%) MCDBA
4 3 (1.24%) MCITP
4 3 (1.24%) MCTS
4 3 (1.24%) PMI Certification
5 1 (0.41%) IIBA
5 1 (0.41%) PhD
5 1 (0.41%) CIMA
5 1 (0.41%) ACCA
Quality Assurance & Compliance
1 3 (1.24%) QA
2 1 (0.41%) GAAP
System Software
1 9 (3.72%) Oracle RAC
2 5 (2.07%) Oracle RMAN
3 3 (1.24%) VMware Infrastructure
4 2 (0.83%) VMware ESX
Systems Management
1 10 (4.13%) Data Guard
2 6 (2.48%) Oracle Enterprise Manager
3 3 (1.24%) Foglight
Vendors
1 97 (40.08%) Microsoft
2 48 (19.83%) Oracle
3 22 (9.09%) Business Objects
4 14 (5.79%) SAP
4 14 (5.79%) IBM
5 13 (5.37%) Cognos
6 9 (3.72%) Dundas
7 7 (2.89%) Red Gate
7 7 (2.89%) Sybase
7 7 (2.89%) MicroStrategy
8 5 (2.07%) VMware
8 5 (2.07%) Sun
9 3 (1.24%) Nintex
9 3 (1.24%) PeopleSoft
9 3 (1.24%) Informatica
9 3 (1.24%) Red Hat
10 2 (0.83%) Netezza
11 1 (0.41%) Tableau
11 1 (0.41%) Sitecore
11 1 (0.41%) Endeca
City of London
Nigel Frank International Limited - Newcastle
Salary: £65000 - £70000 per annum + Benefits Package
Posted: 16 hours ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £35000 - £40000 per annum
Posted: 16 hours ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £45000 per annum + 10% Bonus & Package
Posted: 16 hours ago
City of London
Churchill Frank
Salary: £45000 - £50000 per annum + Bonus/Pension/SAS Training
Posted: 16 hours ago
City of London
Modis International - London
Salary: £50000 - £65000 per annum
Posted: 17 hours ago
City, London
Quant Capital
Salary: Up to £90,000 per annum 10% Bonus
Posted: Yesterday
City, London
Oliver James Associates
Salary: £45000 - £50000 per annum + Bonus + Benefits package
Posted: 2 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £60000 - £70000 per annum + benefits
Posted: 3 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £75000 per annum + Package
Posted: 4 days ago
City, London
Digitech Resourcing Ltd
Salary: From £20,000 to £60,000 per annum Great Benefits and Training
Posted: 4 days ago
City, London
I3
Salary: £60000 - £75000 per annum
Posted: 4 days ago
City, London
Harrington Starr
Salary: £55000 - £75000 per annum + Bonus + benefits + training
Posted: 6 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £75000 - £76000 per annum + Package
Posted: 8 days ago
City of London
Computer Futures
Salary: £35000 - £40000 per annum + competitive
Posted: 10 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £45000 - £50000 per annum + Package
Posted: 14 days ago
City of London
Real Staffing
Salary: £55000 - £70000 per annum + competitive
Posted: 14 days ago
City of London
Real Staffing
Salary: £55000 - £70000 per annum + Good Benefits
Posted: 21 days ago