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

Location
3 months to
26 Nov 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 216 238 221
Rank change year-on-year
+22 -17
Permanent jobs citing OLAP 92 106 116
As % of all permanent IT jobs located in the City of London 0.85% 0.87% 0.96%
As % of the Database & Business Intelligence category 3.14% 2.96% 3.42%
Number of salaries quoted 87 91 108
Average salary £62,500 £55,000 £55,000
Average salary % change year-on-year
+13.63% -
90% offered a salary of more than £42,500 £40,000 £33,500
10% offered a salary of more than £72,500 £92,500 £80,000
UK excluding London average salary £42,500 £40,000 £42,500
% change year-on-year
+6.25% -5.88%
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
2932 3587 3391
As % of all permanent IT jobs located in the City of London 26.97% 29.49% 28.19%
Number of salaries quoted 2595 3140 3099
Average salary £55,000 £55,000 £52,500
Average salary % change year-on-year
- +4.76%
90% offered a salary of more than £37,500 £37,500 £35,000
10% offered a salary of more than £75,000 £75,000 £76,000
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 26 November 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 26 November 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 190 (80.85%) SQL Server
2 156 (66.38%) Business Intelligence
3 148 (62.98%) SQL Server Analysis Services
4 147 (62.55%) SQL Server Integration Services
5 143 (60.85%) SQL
6 135 (57.45%) Data Warehouse
7 132 (56.17%) SQL Server Reporting Services
8 121 (51.49%) ETL
9 92 (39.15%) OLAP Cube
10 85 (36.17%) Microsoft
11 84 (35.74%) Finance
12 67 (28.51%) SQL Server 2008
13 65 (27.66%) MDX
13 65 (27.66%) Oracle OLAP
13 65 (27.66%) Oracle
14 64 (27.23%) T-SQL
15 61 (25.96%) Data Modelling
16 44 (18.72%) OLTP
16 44 (18.72%) SQL Server 2012
17 43 (18.30%) .NET
18 41 (17.45%) MS Excel
19 40 (17.02%) Banking
20 34 (14.47%) Oracle Database
20 34 (14.47%) Analytical Skills
21 33 (14.04%) Kimball Methodology
21 33 (14.04%) SharePoint
22 32 (13.62%) Performance Tuning
23 31 (13.19%) C#
24 26 (11.06%) Agile Software Development
24 26 (11.06%) Oracle Database 11g

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

For the 6 months to 26 November 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 33 (14.04%) SharePoint
2 11 (4.68%) SharePoint 2010
3 6 (2.55%) SAS
4 5 (2.13%) BizTalk Server
4 5 (2.13%) SharePoint 2013
5 2 (0.85%) Oracle Coherence
6 1 (0.43%) Sitecore CMS
6 1 (0.43%) IIS
6 1 (0.43%) Tomcat
6 1 (0.43%) CMS
6 1 (0.43%) SharePoint Server
6 1 (0.43%) SharePoint Foundation
6 1 (0.43%) Apache Pig
Applications
1 41 (17.45%) MS Excel
2 16 (6.81%) MS Office
3 12 (5.11%) PowerPivot
4 11 (4.68%) MS Visio
5 1 (0.43%) SPSS
5 1 (0.43%) MS PowerPoint
5 1 (0.43%) MS Project
Business Applications
1 10 (4.26%) Cognos TM1
2 8 (3.40%) Cognos Business Intelligence
3 5 (2.13%) Hyperion Planning
4 3 (1.28%) Oracle General Ledger
5 2 (0.85%) Oracle EBS
5 2 (0.85%) HFM
6 1 (0.43%) Dynamics CRM
Cloud Services
1 3 (1.28%) SaaS
2 1 (0.43%) Cloud Computing
Communications & Networking
1 7 (2.98%) Intranet
2 5 (2.13%) SAN
3 2 (0.85%) LDAP
4 1 (0.43%) Internet
Database & Business Intelligence
1 190 (80.85%) SQL Server
2 148 (62.98%) SQL Server Analysis Services
3 147 (62.55%) SQL Server Integration Services
4 135 (57.45%) Data Warehouse
5 132 (56.17%) SQL Server Reporting Services
6 92 (39.15%) OLAP Cube
7 67 (28.51%) SQL Server 2008
8 65 (27.66%) Oracle OLAP
9 44 (18.72%) OLTP
9 44 (18.72%) SQL Server 2012
10 34 (14.47%) Oracle Database
11 26 (11.06%) Oracle Database 11g
12 25 (10.64%) QlikView
13 18 (7.66%) Microsoft Analysis Services
13 18 (7.66%) SQL Server 2000
13 18 (7.66%) Relational Database
14 17 (7.23%) Oracle Database 12c
15 15 (6.38%) SQL Server 2005
16 14 (5.96%) Oracle Database 10g
17 13 (5.53%) RDBMS
Development Applications
1 9 (3.83%) PowerDesigner
2 8 (3.40%) Team Foundation Server
3 7 (2.98%) ERwin
4 6 (2.55%) Subversion
5 5 (2.13%) Visual Studio
6 3 (1.28%) Oracle Forms
7 2 (0.85%) Ant
8 1 (0.43%) JUnit
8 1 (0.43%) Maven
General
1 84 (35.74%) Finance
2 40 (17.02%) Banking
3 25 (10.64%) Law
4 15 (6.38%) Investment Banking
5 7 (2.98%) General Ledger
5 7 (2.98%) Advertising
6 5 (2.13%) Legal
6 5 (2.13%) Marketing
7 3 (1.28%) Retail
7 3 (1.28%) Financial Institution
7 3 (1.28%) Front Office
8 2 (0.85%) Back Office
9 1 (0.43%) Telecoms
9 1 (0.43%) Publishing
9 1 (0.43%) International Banking
9 1 (0.43%) Pharmaceutical
Job Titles
1 153 (65.11%) Developer
2 74 (31.49%) Business Intelligence Developer
3 34 (14.47%) SQL Developer
4 31 (13.19%) DBA
5 24 (10.21%) Senior Developer
6 21 (8.94%) Analyst
7 18 (7.66%) ETL Developer
8 17 (7.23%) Database Developer
9 15 (6.38%) SQL Server Developer
10 14 (5.96%) Business Developer
10 14 (5.96%) Consultant
11 13 (5.53%) Report Developer
12 12 (5.11%) Oracle DBA
13 10 (4.26%) SQL Database Developer
14 9 (3.83%) SQL DBA
14 9 (3.83%) Analyst Developer
14 9 (3.83%) MI Analyst
14 9 (3.83%) Senior Business Intelligence Developer
15 8 (3.40%) Administrator
16 7 (2.98%) Team Leader
Libraries, Frameworks & Software Standards
1 65 (27.66%) MDX
2 43 (18.30%) .NET
3 23 (9.79%) XML
4 10 (4.26%) Web Services
5 8 (3.40%) ASP.NET
6 7 (2.98%) CSS
6 7 (2.98%) HTML
7 2 (0.85%) JMS
7 2 (0.85%) JDBC
7 2 (0.85%) ASP.NET MVC
7 2 (0.85%) .NET Framework
8 1 (0.43%) Razor View Engine
8 1 (0.43%) OOXML
8 1 (0.43%) Spring
Miscellaneous
1 34 (14.47%) Analytical Skills
2 18 (7.66%) Clustering
3 14 (5.96%) Reference Data
4 9 (3.83%) Computer Science
5 8 (3.40%) Data Integration
5 8 (3.40%) Replication
6 7 (2.98%) Mathematics
7 5 (2.13%) Economics
7 5 (2.13%) Visualisation
8 4 (1.70%) iPhone
8 4 (1.70%) Management Information System
8 4 (1.70%) BBC
8 4 (1.70%) Data Structures
9 3 (1.28%) PMI
9 3 (1.28%) Statistics
9 3 (1.28%) Market Risk
10 2 (0.85%) Data Conversion
10 2 (0.85%) Derivative
10 2 (0.85%) Oracle Exalogic
10 2 (0.85%) Oracle Exalytics
Operating Systems
1 14 (5.96%) Linux
2 13 (5.53%) UNIX
2 13 (5.53%) Windows
3 7 (2.98%) Oracle Linux
4 1 (0.43%) AIX
Processes & Methodologies
1 156 (66.38%) Business Intelligence
2 121 (51.49%) ETL
3 61 (25.96%) Data Modelling
4 33 (14.04%) Kimball Methodology
5 32 (13.62%) Performance Tuning
6 26 (11.06%) Agile Software Development
7 25 (10.64%) Analytics
8 22 (9.36%) Scrum
9 19 (8.09%) Data Architecture
10 17 (7.23%) CRM
11 15 (6.38%) E-Commerce
11 15 (6.38%) Data Management
12 14 (5.96%) Disaster Recovery
12 14 (5.96%) Project Management
13 13 (5.53%) Data Analysis
13 13 (5.53%) High Availability
13 13 (5.53%) Load Balancing
14 12 (5.11%) Practice Management
15 11 (4.68%) System Testing
15 11 (4.68%) Software Architecture
Programming Languages
1 143 (60.85%) SQL
2 64 (27.23%) T-SQL
3 31 (13.19%) C#
4 20 (8.51%) PL/SQL
5 12 (5.11%) Data Analysis Expressions (DAX)
6 10 (4.26%) Shell Script
7 8 (3.40%) Java
8 7 (2.98%) JavaScript
9 5 (2.13%) VB
10 4 (1.70%) Data Mining Extensions (DMX)
10 4 (1.70%) PowerShell
10 4 (1.70%) R
11 2 (0.85%) SAS Macro
11 2 (0.85%) VBA
11 2 (0.85%) Python
12 1 (0.43%) VB.NET
12 1 (0.43%) C
Qualifications
1 23 (9.79%) Degree
2 22 (9.36%) Microsoft Certification
3 19 (8.09%) MCDBA
4 3 (1.28%) MCSE
4 3 (1.28%) PMI Certification
4 3 (1.28%) IBM Certification
5 1 (0.43%) ACCA
5 1 (0.43%) CIMA
5 1 (0.43%) SAS Certification
5 1 (0.43%) IIBA
Quality Assurance & Compliance
1 4 (1.70%) QA
2 3 (1.28%) Data Quality
3 1 (0.43%) GAAP
System Software
1 14 (5.96%) Oracle RAC
2 4 (1.70%) Oracle RMAN
3 3 (1.28%) VMware Infrastructure
Systems Management
1 11 (4.68%) Data Guard
2 6 (2.55%) Oracle Enterprise Manager
3 4 (1.70%) Foglight
Vendors
1 85 (36.17%) Microsoft
2 65 (27.66%) Oracle
3 21 (8.94%) Business Objects
4 19 (8.09%) Cognos
5 16 (6.81%) IBM
5 16 (6.81%) SAP
6 12 (5.11%) Informatica
7 11 (4.68%) Tableau
8 9 (3.83%) Sybase
9 6 (2.55%) Sun
9 6 (2.55%) Teradata
10 5 (2.13%) Hyperion
10 5 (2.13%) Netezza
11 3 (1.28%) VMware
11 3 (1.28%) Nintex
11 3 (1.28%) Birst
11 3 (1.28%) Logi Analytics
11 3 (1.28%) MicroStrategy
11 3 (1.28%) PeopleSoft
12 2 (0.85%) Red Gate
City, London
Logic Engagements Ltd
Salary: £50000 - £60000 per annum + Excellent benefits
Posted: 5 hours ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £35000 - £37000 per annum
Posted: 11 hours ago
City, London
Ashdown IT
Salary: £65000 - £80000 per annum
Posted: Yesterday
City, London
Swan IT
Salary: £80000 per annum + CAR, PENSION, HEALTHCARE
Posted: Yesterday
City, London
Opus Recruitment Solutions Ltd
Salary: £70000 to £75000 per annum
Posted: Yesterday
City, London
Harris Rubbert Associates
Salary: £70,000 per annum + Incentivised Bonus + Good Benefits
Posted: 5 days ago
City, London
Westbourne Partners
Salary: From £30,000 to £40,000 per annum
Posted: 6 days ago
City, London
Ashdown IT
Salary: £65000 - £80000 per annum
Posted: 6 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £65000 - £70000 per annum + Benefits Package
Posted: 15 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £35000 - £40000 per annum
Posted: 15 days ago
City of London
Churchill Frank
Salary: £500 - £501 per day
Posted: 26 days ago