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

Location
3 months to
22 May 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 227 247 225
Rank change year-on-year
+20 -22
Permanent jobs citing OLAP 75 96 108
As % of all permanent IT jobs located in the City of London 0.75% 0.76% 0.92%
As % of the Database & Business Intelligence category 2.54% 2.53% 3.46%
Number of salaries quoted 72 81 100
Average salary £60,000 £55,000 £61,500
Average salary % change year-on-year
+9.09% -10.56%
90% offered a salary of more than £52,500 £40,000 £47,500
10% offered a salary of more than £72,500 £65,000 £70,000
UK excluding London average salary £40,000 £42,500 £45,000
% change year-on-year
-5.88% -5.55%
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
2947 3788 3125
As % of all permanent IT jobs located in the City of London 29.36% 29.98% 26.61%
Number of salaries quoted 2560 3296 2744
Average salary £57,500 £52,500 £52,500
Average salary % change year-on-year
+9.52% -
90% offered a salary of more than £40,000 £37,500 £35,000
10% offered a salary of more than £75,000 £72,500 £77,500
UK excluding London average salary £41,500 £40,000 £38,500
% change year-on-year
+3.75% +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 May 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 22 May 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 100 (78.74%) Business Intelligence
2 92 (72.44%) SQL Server
3 85 (66.93%) Data Warehouse
3 85 (66.93%) SQL Server Integration Services
4 84 (66.14%) ETL
5 81 (63.78%) SQL Server Analysis Services
6 76 (59.84%) SQL
6 76 (59.84%) SQL Server Reporting Services
7 63 (49.61%) Microsoft
8 58 (45.67%) OLAP Cube
9 50 (39.37%) Data Modelling
10 43 (33.86%) Finance
11 40 (31.50%) Analytics
12 32 (25.20%) Oracle
12 32 (25.20%) Oracle OLAP
13 29 (22.83%) MS Excel
14 28 (22.05%) SQL Server 2008
15 25 (19.69%) T-SQL
16 24 (18.90%) MDX
16 24 (18.90%) Business Objects
17 23 (18.11%) SAP
17 23 (18.11%) Tableau
18 22 (17.32%) Analytical Skills
19 21 (16.54%) Big Data
19 21 (16.54%) Cognos
20 20 (15.75%) Banking
21 19 (14.96%) Agile Software Development
21 19 (14.96%) SQL Server 2012
22 18 (14.17%) Degree
22 18 (14.17%) Java

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

For the 6 months to 22 May 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 17 (13.39%) SharePoint
2 5 (3.94%) SAS
3 4 (3.15%) SharePoint 2010
4 2 (1.57%) BizTalk Server
5 1 (0.79%) Oracle Workflow
5 1 (0.79%) SharePoint 2013
Applications
1 29 (22.83%) MS Excel
2 15 (11.81%) MS Visio
3 14 (11.02%) PowerPivot
4 5 (3.94%) SPSS
5 2 (1.57%) MS Office
6 1 (0.79%) MS Project
6 1 (0.79%) MS PowerPoint
6 1 (0.79%) FastStats
Business Applications
1 6 (4.72%) Hyperion Planning
1 6 (4.72%) Cognos TM1
1 6 (4.72%) Oracle Applications
2 5 (3.94%) Cognos Business Intelligence
3 3 (2.36%) Oracle EBS
3 3 (2.36%) Oracle EBS R12
4 2 (1.57%) Oracle Procure-to-Pay
4 2 (1.57%) ION MarketView
4 2 (1.57%) Dynamics NAV
4 2 (1.57%) Oracle Financials
5 1 (0.79%) Oracle ERP
5 1 (0.79%) SAP Oil and Gas
5 1 (0.79%) Cognos Planning
5 1 (0.79%) SAP BPC
Cloud Services
1 3 (2.36%) Cloud Computing
2 2 (1.57%) Amazon AWS
Database & Business Intelligence
1 92 (72.44%) SQL Server
2 85 (66.93%) Data Warehouse
2 85 (66.93%) SQL Server Integration Services
3 81 (63.78%) SQL Server Analysis Services
4 76 (59.84%) SQL Server Reporting Services
5 58 (45.67%) OLAP Cube
6 32 (25.20%) Oracle OLAP
7 28 (22.05%) SQL Server 2008
8 21 (16.54%) Big Data
9 19 (14.96%) SQL Server 2012
10 16 (12.60%) QlikView
10 16 (12.60%) SSDT
11 15 (11.81%) Relational Database
11 15 (11.81%) BusinessObjects
11 15 (11.81%) Data Mining
12 14 (11.02%) Oracle Database
13 12 (9.45%) Oracle BI EE
14 11 (8.66%) OLTP
15 10 (7.87%) IBM InfoSphere
15 10 (7.87%) DataStage
Development Applications
1 17 (13.39%) PowerDesigner
2 1 (0.79%) Visual Studio
2 1 (0.79%) VSS/SourceSafe
2 1 (0.79%) ClearCase
2 1 (0.79%) Oracle Forms
2 1 (0.79%) ClearQuest
2 1 (0.79%) Subversion
2 1 (0.79%) CruiseControl
2 1 (0.79%) Team Foundation Server
General
1 43 (33.86%) Finance
2 20 (15.75%) Banking
3 8 (6.30%) General Ledger
4 7 (5.51%) Advertising
5 6 (4.72%) Front Office
6 4 (3.15%) Financial Institution
7 3 (2.36%) Investment Banking
7 3 (2.36%) Retail
7 3 (2.36%) Marketing
8 2 (1.57%) Telecoms
9 1 (0.79%) Electronics
9 1 (0.79%) Back Office
9 1 (0.79%) Law
9 1 (0.79%) Legal
9 1 (0.79%) Manufacturing
9 1 (0.79%) Games
9 1 (0.79%) Billing
Job Titles
1 79 (62.20%) Developer
2 31 (24.41%) Analyst
3 29 (22.83%) Senior Developer
4 26 (20.47%) Consultant
5 25 (19.69%) Business Intelligence Developer
6 20 (15.75%) Analyst Developer
7 17 (13.39%) Business Intelligence Consultant
8 14 (11.02%) MI Analyst
9 12 (9.45%) SQL Developer
9 12 (9.45%) Java Developer
10 11 (8.66%) Senior Java Developer
11 9 (7.09%) Architect
12 8 (6.30%) Java Consultant
12 8 (6.30%) Senior Java Consultant
12 8 (6.30%) Senior Consultant
13 7 (5.51%) DBA
13 7 (5.51%) Business Intelligence Analyst
13 7 (5.51%) Oracle Developer
13 7 (5.51%) Business Consultant
13 7 (5.51%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 24 (18.90%) MDX
2 6 (4.72%) XML
3 5 (3.94%) .NET
3 5 (3.94%) XSD
3 5 (3.94%) XSLT
4 2 (1.57%) SAP XI
5 1 (0.79%) MSMQ
5 1 (0.79%) ASP.NET
5 1 (0.79%) COM
5 1 (0.79%) Web Services
5 1 (0.79%) WinForms
5 1 (0.79%) .NET Remoting
5 1 (0.79%) NHibernate
5 1 (0.79%) WCF
5 1 (0.79%) Spring.NET
5 1 (0.79%) ASP.NET Web Forms
5 1 (0.79%) Cascading
Miscellaneous
1 22 (17.32%) Analytical Skills
2 10 (7.87%) Data Structures
3 8 (6.30%) Replication
4 7 (5.51%) Data Integration
5 4 (3.15%) Open Source
5 4 (3.15%) Management Information System
6 3 (2.36%) Data Conversion
6 3 (2.36%) Hedge funds
7 2 (1.57%) Computer Science
8 1 (0.79%) N-Tier
8 1 (0.79%) PMI
8 1 (0.79%) Fixed Income
8 1 (0.79%) Clustering
8 1 (0.79%) Foreign Exchange (FX)
8 1 (0.79%) DTV
8 1 (0.79%) Visualisation
8 1 (0.79%) Digital Media
Operating Systems
1 15 (11.81%) Windows
2 7 (5.51%) Linux
3 3 (2.36%) Windows Server 2008
3 3 (2.36%) Windows Server 2012
4 1 (0.79%) Red Hat Enterprise Linux
Processes & Methodologies
1 100 (78.74%) Business Intelligence
2 84 (66.14%) ETL
3 50 (39.37%) Data Modelling
4 40 (31.50%) Analytics
5 19 (14.96%) Agile Software Development
6 15 (11.81%) Regression Testing
7 14 (11.02%) Data Analysis
8 12 (9.45%) Kimball Methodology
8 12 (9.45%) Data Management
9 11 (8.66%) Data Architecture
9 11 (8.66%) Mentoring
10 10 (7.87%) Project Management
11 9 (7.09%) Dimensional Modelling
11 9 (7.09%) Master Data Management
11 9 (7.09%) Database Security
12 8 (6.30%) Change Control
12 8 (6.30%) Data Cleansing
13 7 (5.51%) Scrum
13 7 (5.51%) Change Management
13 7 (5.51%) Low Latency
Programming Languages
1 76 (59.84%) SQL
2 25 (19.69%) T-SQL
3 18 (14.17%) Java
4 10 (7.87%) PL/SQL
5 6 (4.72%) C
6 5 (3.94%) C#
7 4 (3.15%) Data Analysis Expressions (DAX)
8 3 (2.36%) PowerShell
9 1 (0.79%) VB.NET
9 1 (0.79%) VBA
Qualifications
1 18 (14.17%) Degree
2 8 (6.30%) Microsoft Certification
3 6 (4.72%) OCP
3 6 (4.72%) Oracle Certification
4 5 (3.94%) MCSE
4 5 (3.94%) IBM Certification
5 3 (2.36%) MCDBA
5 3 (2.36%) MCITP
6 2 (1.57%) SC Cleared
6 2 (1.57%) Security Cleared
7 1 (0.79%) PMI Certification
Quality Assurance & Compliance
1 3 (2.36%) QA
2 2 (1.57%) Data Quality
3 1 (0.79%) Solvency II
Vendors
1 63 (49.61%) Microsoft
2 32 (25.20%) Oracle
3 24 (18.90%) Business Objects
4 23 (18.11%) SAP
4 23 (18.11%) Tableau
5 21 (16.54%) Cognos
6 17 (13.39%) IBM
7 15 (11.81%) Sybase
8 12 (9.45%) Informatica
8 12 (9.45%) MicroStrategy
9 10 (7.87%) Teradata
9 10 (7.87%) Netezza
9 10 (7.87%) Hyperion
10 5 (3.94%) Ab Initio
10 5 (3.94%) Logi Analytics
10 5 (3.94%) DataFlux
11 2 (1.57%) ION Trading
11 2 (1.57%) Pegasus
12 1 (0.79%) Adobe
12 1 (0.79%) Sun
City, London
Client Server
Salary: £60k to £75k + bonus + benefits
Posted: 3 days ago
City, London
McGregor Boyall
Salary: £50000 - £60000 per annum
Posted: 4 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £50000 - £60000 per annum + benefits, bonus
Posted: 6 days ago
City of London
Nigel Frank International Limited - Newcastle
Salary: £50000 - £70000 per annum + bonus, car allowance
Posted: 6 days ago
City of London
Lewis Paige
Salary: £45000 - £55000 per annum
Posted: 24 days ago