The table below looks at the statistics for OLAP skills in IT jobs advertised for the London region. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 8 February 2016 with a comparison to the same period in the previous 2 years.

Location
3 months to
8 Feb 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 462 393 319
Rank change year-on-year
-69 -74
Permanent jobs citing OLAP 182 268 385
As % of all permanent IT jobs located in London 0.44% 0.64% 0.91%
As % of the Database & Business Intelligence category 1.42% 2.14% 2.94%
Number of salaries quoted 148 219 326
Average salary £57,500 £62,500 £55,000
Average salary % change year-on-year
-8.00% +13.63%
90% offered a salary of more than £45,175 £40,000 £43,750
10% offered a salary of more than £75,000 £77,500 £71,250
UK excluding London average salary £43,000 £40,000 £40,000
% change year-on-year
+7.50% -
OLAP
England

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 London region.

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
12841 12513 13116
As % of all permanent IT jobs located in London 31.30% 30.04% 30.92%
Number of salaries quoted 11157 10791 11175
Average salary £55,000 £55,000 £55,000
90% offered a salary of more than £40,000 £37,500 £37,500
10% offered a salary of more than £80,000 £77,500 £75,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in London

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the London region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in London

OLAP
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the London region.

OLAP Salary Trend in London

OLAP
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing OLAP across the London region over the 3 months to 8 February 2016.

OLAP Salary Histogram in London

OLAP
Job Locations in London

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the London region over the 3 months to 8 February 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +54 49 £55,000 -21.42% 7
Kingston Upon Thames - 4 £59,250 -
Surbiton - 3 £55,000 -
Teddington - 1 - - 1
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 8 February 2016, IT jobs across the 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 315 (72.92%) Business Intelligence
2 303 (70.14%) SQL
3 298 (68.98%) SQL Server
4 263 (60.88%) Data Warehouse
5 260 (60.19%) SQL Server Integration Services
6 243 (56.25%) SQL Server Analysis Services
7 229 (53.01%) ETL
8 209 (48.38%) SQL Server Reporting Services
9 185 (42.82%) Microsoft
10 141 (32.64%) Data Modelling
10 141 (32.64%) OLAP Cube
11 137 (31.71%) Finance
12 132 (30.56%) T-SQL
13 118 (27.31%) MS Excel
13 118 (27.31%) Analytics
14 116 (26.85%) MDX
15 112 (25.93%) Agile Software Development
16 98 (22.69%) SQL Server 2008
17 82 (18.98%) Kimball Methodology
17 82 (18.98%) Relational Database
18 76 (17.59%) OLTP
19 72 (16.67%) Oracle
19 72 (16.67%) Oracle OLAP
20 69 (15.97%) Dimensional Modelling
20 69 (15.97%) .NET
21 60 (13.89%) Analytical Skills
22 58 (13.43%) Banking
23 57 (13.19%) SQL Server 2012
24 53 (12.27%) C#
25 52 (12.04%) Tableau

OLAP
Top Related IT Skills in London by Category

For the 6 months to 8 February 2016, IT jobs across the 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 (7.87%) SharePoint
2 17 (3.94%) SAS
3 16 (3.70%) Apache Spark
4 15 (3.47%) Tomcat
5 12 (2.78%) Confluence
5 12 (2.78%) GemFire
6 10 (2.31%) JBoss
7 5 (1.16%) Node.js
8 4 (0.93%) IIS
9 3 (0.69%) Adobe Experience Manager
9 3 (0.69%) CMS
9 3 (0.69%) Drupal
9 3 (0.69%) Joomla!
9 3 (0.69%) OpenCms
9 3 (0.69%) Oracle Spatial
9 3 (0.69%) WordPress
10 2 (0.46%) Apache Pig
10 2 (0.46%) SharePoint 2010
10 2 (0.46%) SharePoint Server
11 1 (0.23%) Oracle Workflow
Applications
1 118 (27.31%) MS Excel
2 11 (2.55%) MS Visio
3 10 (2.31%) MS Office
4 2 (0.46%) SPSS
5 1 (0.23%) MS PowerPoint
Business Applications
1 9 (2.08%) Cognos Business Intelligence
2 6 (1.39%) HFM
3 2 (0.46%) Cognos Controller
3 2 (0.46%) Cognos TM1
3 2 (0.46%) SAP Oil and Gas
4 1 (0.23%) Dynamics AX
4 1 (0.23%) Dynamics CRM
4 1 (0.23%) Hyperion Planning
4 1 (0.23%) Oracle EBS
4 1 (0.23%) Unica
Cloud Services
1 43 (9.95%) Microsoft Azure
2 17 (3.94%) Amazon AWS
3 7 (1.62%) IaaS
4 6 (1.39%) Azure Machine Learning
4 6 (1.39%) PaaS
5 5 (1.16%) Office 365
6 4 (0.93%) SaaS
7 3 (0.69%) GitHub
8 1 (0.23%) Amazon EMR
Communications & Networking
1 5 (1.16%) HTTP
1 5 (1.16%) TCP/IP
Database & Business Intelligence
1 298 (68.98%) SQL Server
2 263 (60.88%) Data Warehouse
3 260 (60.19%) SQL Server Integration Services
4 243 (56.25%) SQL Server Analysis Services
5 209 (48.38%) SQL Server Reporting Services
6 141 (32.64%) OLAP Cube
7 98 (22.69%) SQL Server 2008
8 82 (18.98%) Relational Database
9 76 (17.59%) OLTP
10 72 (16.67%) Oracle OLAP
11 57 (13.19%) SQL Server 2012
12 47 (10.88%) Microsoft Analysis Services
13 36 (8.33%) RDBMS
14 35 (8.10%) MySQL
15 34 (7.87%) PowerPivot
16 33 (7.64%) QlikView
17 32 (7.41%) Hadoop
18 31 (7.18%) SQL Server 2014
19 29 (6.71%) Big Data
19 29 (6.71%) Power BI
Development Applications
1 23 (5.32%) Git (software)
2 20 (4.63%) Maven
3 16 (3.70%) JIRA
4 15 (3.47%) Jenkins
4 15 (3.47%) Team Foundation Server
5 11 (2.55%) PowerDesigner
6 7 (1.62%) Visual Studio
6 7 (1.62%) Visual Studio Tools for Office
7 6 (1.39%) Eclipse
7 6 (1.39%) Oracle Forms
8 5 (1.16%) JUnit
General
1 137 (31.71%) Finance
2 58 (13.43%) Banking
3 40 (9.26%) Investment Banking
3 40 (9.26%) Marketing
4 37 (8.56%) Retail
5 26 (6.02%) Games
6 18 (4.17%) Legal
7 17 (3.94%) Financial Institution
8 16 (3.70%) Front Office
9 7 (1.62%) Telecoms
10 6 (1.39%) Publishing
11 5 (1.16%) Advertising
12 4 (0.93%) Pharmaceutical
13 3 (0.69%) Law
14 2 (0.46%) Back Office
14 2 (0.46%) Billing
14 2 (0.46%) Electronics
14 2 (0.46%) Manufacturing
15 1 (0.23%) Military
Job Titles
1 270 (62.50%) Developer
2 155 (35.88%) Business Intelligence Developer
3 122 (28.24%) SQL Developer
4 72 (16.67%) SQL BI Developer
5 64 (14.81%) Senior Developer
6 62 (14.35%) Analyst
7 46 (10.65%) Data Warehouse Developer
7 46 (10.65%) DBA
8 31 (7.18%) Business Intelligence Analyst
8 31 (7.18%) Senior SQL Developer
9 30 (6.94%) Consultant
9 30 (6.94%) SQL Server Developer
10 28 (6.48%) Analyst Developer
10 28 (6.48%) Java Developer
11 27 (6.25%) Lead Developer
11 27 (6.25%) Senior Business Intelligence Developer
12 26 (6.02%) Architect
13 23 (5.32%) Business Developer
14 22 (5.09%) SQL Server BI Developer
15 21 (4.86%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 116 (26.85%) MDX
2 69 (15.97%) .NET
3 20 (4.63%) Spring
4 16 (3.70%) Web Services
5 15 (3.47%) XML
6 14 (3.24%) HTML
7 13 (3.01%) Oracle GoldenGate
8 12 (2.78%) JMS
8 12 (2.78%) Spring Batch
8 12 (2.78%) Spring XD
9 11 (2.55%) CSS
9 11 (2.55%) RESTful
10 10 (2.31%) Ext JS
10 10 (2.31%) J2SE
11 9 (2.08%) ASP.NET
11 9 (2.08%) jQuery
12 8 (1.85%) J2EE
13 6 (1.39%) D3.js
13 6 (1.39%) JSON
13 6 (1.39%) Leaflet
Miscellaneous
1 60 (13.89%) Analytical Skills
2 44 (10.19%) Replication
3 38 (8.80%) Visualisation
4 34 (7.87%) Computer Science
5 32 (7.41%) Credit Risk
6 29 (6.71%) Mathematics
7 22 (5.09%) Clustering
7 22 (5.09%) Online Games
8 19 (4.40%) Equities
8 19 (4.40%) Statistics
9 17 (3.94%) Fixed Income
10 15 (3.47%) Data Integration
10 15 (3.47%) Management Information System
11 12 (2.78%) Market Risk
12 11 (2.55%) Foreign Exchange (FX)
12 11 (2.55%) Reinsurance
13 10 (2.31%) Hedge funds
14 9 (2.08%) Derivative
15 8 (1.85%) Mobile App
15 8 (1.85%) Neural Network
Operating Systems
1 38 (8.80%) Linux
2 16 (3.70%) Unix
3 8 (1.85%) Windows
4 6 (1.39%) Oracle Linux
5 5 (1.16%) Windows Server
5 5 (1.16%) Windows Server 2008
6 3 (0.69%) AIX
Processes & Methodologies
1 315 (72.92%) Business Intelligence
2 229 (53.01%) ETL
3 141 (32.64%) Data Modelling
4 118 (27.31%) Analytics
5 112 (25.93%) Agile Software Development
6 82 (18.98%) Kimball Methodology
7 69 (15.97%) Dimensional Modelling
8 45 (10.42%) Performance Tuning
9 43 (9.95%) E-Commerce
10 42 (9.72%) SDLC
11 41 (9.49%) Data Management
12 34 (7.87%) Data Analysis
13 26 (6.02%) Scrum
14 25 (5.79%) Open Source
15 24 (5.56%) Migration
16 22 (5.09%) CRM
17 21 (4.86%) Waterfall
18 20 (4.63%) Business Analysis
19 19 (4.40%) Continuous Improvement
19 19 (4.40%) Marketing Analytics
Programming Languages
1 303 (70.14%) SQL
2 132 (30.56%) T-SQL
3 53 (12.27%) C#
4 50 (11.57%) Java
5 30 (6.94%) PL/SQL
6 28 (6.48%) C
7 25 (5.79%) JavaScript
8 23 (5.32%) VBA
9 21 (4.86%) VB
10 16 (3.70%) Data Analysis Expressions (DAX)
11 13 (3.01%) VB.NET
12 10 (2.31%) Python
12 10 (2.31%) R
12 10 (2.31%) Shell Script
13 7 (1.62%) C++
14 5 (1.16%) Perl
14 5 (1.16%) PHP
15 2 (0.46%) Ruby
15 2 (0.46%) Scala
16 1 (0.23%) PowerShell
Qualifications
1 51 (11.81%) Degree
2 6 (1.39%) ACCA
2 6 (1.39%) CIMA
3 4 (0.93%) Microsoft Certification
4 2 (0.46%) IBM Certification
4 2 (0.46%) ISEB
4 2 (0.46%) MCDBA
5 1 (0.23%) CIPFA
5 1 (0.23%) PhD
Quality Assurance & Compliance
1 17 (3.94%) Data Quality
2 15 (3.47%) PCI DSS
2 15 (3.47%) QA
3 5 (1.16%) Sarbanes-Oxley
3 5 (1.16%) SLA
4 3 (0.69%) COBIT
System Software
1 7 (1.62%) Oracle RAC
2 3 (0.69%) Varnish
3 1 (0.23%) Docker
Systems Management
1 12 (2.78%) Puppet
2 10 (2.31%) Oracle Enterprise Manager
3 7 (1.62%) Data Guard
4 3 (0.69%) Oracle RMAN
5 1 (0.23%) Mesos
Vendors
1 185 (42.82%) Microsoft
2 72 (16.67%) Oracle
3 52 (12.04%) Tableau
4 25 (5.79%) Cognos
5 22 (5.09%) Sybase
6 19 (4.40%) IBM
7 18 (4.17%) SAP
8 13 (3.01%) hybris
9 11 (2.55%) Hyperion
9 11 (2.55%) MicroStrategy
10 10 (2.31%) PTC
11 9 (2.08%) Hitachi
11 9 (2.08%) Vertica
12 8 (1.85%) Teradata
13 7 (1.62%) Red Gate
14 5 (1.16%) Informatica
15 3 (0.69%) Ab Initio
15 3 (0.69%) Adobe
15 3 (0.69%) DataFlux
16 2 (0.46%) FactSet
London
Bridge Noble
Salary: £45000 - £70000 per annum + stock options
Posted: 11 hours ago
London
Venturi
Salary: £30000.00 - £40000.00 per annum + bonus and benefits
Posted: 11 hours ago
London
Hitachi Consulting UK
Salary: From £35,000 to £80,000 per annum Incl Benefits + Bonus
Posted: 15 hours ago
Central London
Bluefire Professional Services
Salary: £30,000 - £40,000 per year + fantastic benefits package
Posted: 3 days ago
London
Exposed Solutions
Salary: £45000 - £55000 per annum
Posted: 3 days ago
London
Exposed Solutions
Salary: £35000 - £45000 per annum
Posted: 3 days ago
London
Joseph Harry Ltd
Salary: £50000 - £65000 per annum + 10% Pension + c.25% Bonus
Posted: 4 days ago
City, London
TEKsystems
Salary: £40000 - £50000 per annum + brilliant bonuses and benefits
Posted: 5 days ago
City, London
ANSON MCCADE
Salary: £35k - £60k plus attractive benefits and extensive career progression
Posted: 5 days ago
Central London / West End
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 5 days ago
London
Lawrence Harvey Enterprise
Salary: £45000.00 - £52000.00 per annum
Posted: 5 days ago
Central London / West End
ANSON MCCADE
Salary: £40,000 - £80,000 (Depending on Experience)
Posted: 6 days ago
Central London / West End
Maclean Moore Consulting
Salary: From £40,000 to £60,000 per annum
Posted: 6 days ago
London
Blue Fire Professional Services
Salary: Unspecified circa £35,000 + fantastic benefits package
Posted: 6 days ago
London
Nigel Frank International Ltd
Salary: £50000 - £58000 per annum + company benefits
Posted: 14 days ago
London
Lawrence Harvey
Salary: £48000.00 - £53000.00 per annum + benefits
Posted: 18 days ago
London
iKas International
Salary: £55000 - £70000 per annum
Posted: 18 days ago
Teddington
Ortolan Group
Posted: 19 days ago
London
Nigel Frank International Ltd
Salary: £55000 - £75000 per annum + Company benefits
Posted: 20 days ago
London
Nigel Frank International Ltd
Salary: £80000 - £110000 per annum + 40000 OTE and Benefits
Posted: 21 days ago
London
Churchill Frank International
Salary: £40000 - £45000 per annum + Lifestyle/Negotiable
Posted: 24 days ago
London
Nigel Frank International Ltd
Salary: £45000 - £55000 per annum + Benefits
Posted: 25 days ago
London
Nigel Frank International Ltd
Salary: £80000 - £100000 per annum + Company Bonus and Benefits
Posted: 27 days ago
London
Nigel Frank International Ltd
Salary: £53000 - £62000 per annum
Posted: 27 days ago