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 salaries offered in IT jobs that have cited OLAP over the 3 months to 4 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
4 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 233 231 272
Rank change year-on-year
-2 +41
Permanent jobs citing OLAP 33 80 76
As % of all permanent IT jobs located in the City of London 0.47% 0.77% 0.61%
As % of the Database & Business Intelligence category 1.71% 2.61% 2.02%
Number of salaries quoted 30 76 54
Median salary £60,000 £62,500 £52,500
Median salary % change year-on-year
-4.00% +19.04%
90% offered a salary of more than £49,500 £52,500 £40,000
10% offered a salary of more than £67,500 £72,500 £68,500
UK excluding London median salary £46,750 £40,000 £41,500
% change year-on-year
+16.87% -3.61%
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
1930 3063 3756
As % of all permanent IT jobs located in the City of London 27.76% 29.38% 30.02%
Number of salaries quoted 1731 2665 3271
Median salary £55,000 £55,000 £52,500
Median salary % change year-on-year
- +4.76%
90% offered a salary of more than £40,000 £39,000 £36,000
10% offered a salary of more than £75,000 £75,000 £75,000
UK excluding London median salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in the City of London

The demand trend of job ads across the City of London region citing OLAP as a proportion of all IT jobs with a match in 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 4 May 2016.

OLAP Salary Histogram in the City of London

OLAP
Top 30 Related IT Skills in the City of London

For the 6 months to 4 May 2016, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the City of London region with a requirement for OLAP.

1 64 (76.19%) Business Intelligence
2 58 (69.05%) ETL
3 56 (66.67%) SQL Server
4 53 (63.10%) SQL Server Integration Services
5 49 (58.33%) SQL Server Analysis Services
6 45 (53.57%) Microsoft
6 45 (53.57%) Data Warehouse
7 44 (52.38%) SQL Server Reporting Services
8 43 (51.19%) SQL
9 38 (45.24%) MS Excel
10 37 (44.05%) Finance
11 34 (40.48%) Data Modelling
12 31 (36.90%) Analytics
13 29 (34.52%) MDX
14 25 (29.76%) T-SQL
15 21 (25.00%) OLTP
16 20 (23.81%) Agile Software Development
17 17 (20.24%) Marketing
18 16 (19.05%) Oracle OLAP
18 16 (19.05%) Oracle
19 15 (17.86%) Analytical Skills
19 15 (17.86%) OLAP Cube
20 14 (16.67%) .NET
20 14 (16.67%) C#
20 14 (16.67%) E-Commerce
20 14 (16.67%) Microsoft Azure
21 13 (15.48%) Open Source
21 13 (15.48%) Retail
21 13 (15.48%) Data Analysis
21 13 (15.48%) Data Mining

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

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 4 (4.76%) SAS
2 2 (2.38%) Apache
3 1 (1.19%) Apache Spark
3 1 (1.19%) Blackberry Enterprise Server
3 1 (1.19%) IIS
3 1 (1.19%) MS Exchange
3 1 (1.19%) SharePoint
3 1 (1.19%) WebSphere
Applications
1 38 (45.24%) MS Excel
2 3 (3.57%) MS Office
3 2 (2.38%) MS PowerPoint
3 2 (2.38%) MS Visio
3 2 (2.38%) Spreadsheet
3 2 (2.38%) SPSS
4 1 (1.19%) Acrobat
4 1 (1.19%) MS Project
Business Applications
1 6 (7.14%) HFM
2 3 (3.57%) Cognos Business Intelligence
3 1 (1.19%) Hyperion Planning
3 1 (1.19%) Oracle EBS
Cloud Services
1 14 (16.67%) Microsoft Azure
2 1 (1.19%) Amazon AWS
2 1 (1.19%) SaaS
Communications & Networking
1 2 (2.38%) Intranet
2 1 (1.19%) DHCP
2 1 (1.19%) DNS
2 1 (1.19%) LAN
2 1 (1.19%) Network Security
2 1 (1.19%) Remote Desktop
2 1 (1.19%) TCP/IP
2 1 (1.19%) WAN
Database & Business Intelligence
1 56 (66.67%) SQL Server
2 53 (63.10%) SQL Server Integration Services
3 49 (58.33%) SQL Server Analysis Services
4 45 (53.57%) Data Warehouse
5 44 (52.38%) SQL Server Reporting Services
6 21 (25.00%) OLTP
7 16 (19.05%) Oracle OLAP
8 15 (17.86%) OLAP Cube
9 13 (15.48%) Data Mining
10 12 (14.29%) QlikView
11 11 (13.10%) SQL Server 2008
12 9 (10.71%) BusinessObjects
12 9 (10.71%) Data Mart
13 8 (9.52%) Big Data
14 7 (8.33%) Power BI
15 6 (7.14%) Oracle Reports
15 6 (7.14%) Relational Database
15 6 (7.14%) SAP Data Services
15 6 (7.14%) SQL Server 2014
16 5 (5.95%) Oracle BI EE
Development Applications
1 8 (9.52%) Eclipse
2 4 (4.76%) Team Foundation Server
3 1 (1.19%) Git (software)
3 1 (1.19%) Jenkins
3 1 (1.19%) JIRA
3 1 (1.19%) Talend Open Studio
General
1 37 (44.05%) Finance
2 17 (20.24%) Marketing
3 13 (15.48%) Retail
4 9 (10.71%) Banking
5 6 (7.14%) Legal
6 3 (3.57%) Financial Institution
7 2 (2.38%) Back Office
7 2 (2.38%) Investment Banking
8 1 (1.19%) Advertising
8 1 (1.19%) Games
8 1 (1.19%) Law
8 1 (1.19%) Military
Job Titles
1 56 (66.67%) Developer
2 34 (40.48%) Business Intelligence Developer
3 18 (21.43%) SSAS Developer
4 17 (20.24%) SSIS Developer
4 17 (20.24%) SSRS Developer
5 16 (19.05%) Senior Developer
6 15 (17.86%) Analyst
7 12 (14.29%) Azure Developer
7 12 (14.29%) Database Developer
7 12 (14.29%) Marketing Database Developer
7 12 (14.29%) Senior Database Developer
8 10 (11.90%) SQL Developer
9 9 (10.71%) Data Analyst
9 9 (10.71%) SQL Server Developer
10 8 (9.52%) Business Intelligence Analyst
10 8 (9.52%) Lead Developer
10 8 (9.52%) SQL BI Developer
10 8 (9.52%) SQL Server BI Developer
11 6 (7.14%) Analyst Developer
11 6 (7.14%) Solutions Analyst
Libraries, Frameworks & Software Standards
1 29 (34.52%) MDX
2 14 (16.67%) .NET
3 3 (3.57%) HTML
4 2 (2.38%) CSS
4 2 (2.38%) D3.js
4 2 (2.38%) jQuery
4 2 (2.38%) JSON
4 2 (2.38%) SVG
5 1 (1.19%) ODBC
5 1 (1.19%) WebSphere MQ
5 1 (1.19%) XML
Miscellaneous
1 15 (17.86%) Analytical Skills
2 9 (10.71%) Data Integration
2 9 (10.71%) Reinsurance
2 9 (10.71%) Visualisation
3 6 (7.14%) Data Extraction
4 5 (5.95%) Computer Science
5 3 (3.57%) Blackberry
5 3 (3.57%) Foreign Exchange (FX)
5 3 (3.57%) Mathematics
6 2 (2.38%) Data Conversion
6 2 (2.38%) Derivative
6 2 (2.38%) Statistics
7 1 (1.19%) Animation
7 1 (1.19%) Device Driver
7 1 (1.19%) Digital Media
7 1 (1.19%) Economics
7 1 (1.19%) iPad
7 1 (1.19%) Management Information System
7 1 (1.19%) Market Risk
7 1 (1.19%) Oracle Exalogic
Operating Systems
1 3 (3.57%) Linux
2 2 (2.38%) Unix
3 1 (1.19%) Windows
3 1 (1.19%) Windows 7
3 1 (1.19%) Windows Vista
Processes & Methodologies
1 64 (76.19%) Business Intelligence
2 58 (69.05%) ETL
3 34 (40.48%) Data Modelling
4 31 (36.90%) Analytics
5 20 (23.81%) Agile Software Development
6 14 (16.67%) E-Commerce
7 13 (15.48%) Data Analysis
7 13 (15.48%) Marketing Analytics
7 13 (15.48%) Open Source
8 12 (14.29%) Dimensional Modelling
8 12 (14.29%) Performance Tuning
8 12 (14.29%) Statistical Analysis
9 9 (10.71%) BCP
9 9 (10.71%) Data Security
9 9 (10.71%) SDLC
10 8 (9.52%) Kimball Methodology
10 8 (9.52%) Stakeholder Management
11 7 (8.33%) Data Management
11 7 (8.33%) ETL Development
12 6 (7.14%) Data Visualisation
Programming Languages
1 43 (51.19%) SQL
2 25 (29.76%) T-SQL
3 14 (16.67%) C#
4 10 (11.90%) Data Analysis Expressions (DAX)
5 3 (3.57%) JavaScript
5 3 (3.57%) PL/SQL
5 3 (3.57%) VBA
6 2 (2.38%) C++
6 2 (2.38%) Java
6 2 (2.38%) PowerShell
6 2 (2.38%) R
7 1 (1.19%) C
7 1 (1.19%) PHP
7 1 (1.19%) Python
7 1 (1.19%) Ruby
7 1 (1.19%) Scala
7 1 (1.19%) VB
Qualifications
1 8 (9.52%) Degree
2 5 (5.95%) ACCA
2 5 (5.95%) CIMA
3 3 (3.57%) IBM Certification
4 2 (2.38%) ISEB
4 2 (2.38%) Microsoft Certification
5 1 (1.19%) HND
5 1 (1.19%) ITIL Certification
5 1 (1.19%) MBA
Quality Assurance & Compliance
1 7 (8.33%) QA
2 5 (5.95%) Data Quality
2 5 (5.95%) Sarbanes-Oxley
3 1 (1.19%) SLA
System Software
1 1 (1.19%) Active Directory
1 1 (1.19%) Microsoft Virtual Server
1 1 (1.19%) VMware Infrastructure
Vendors
1 45 (53.57%) Microsoft
2 16 (19.05%) Oracle
3 10 (11.90%) SAP
4 9 (10.71%) Tableau
5 7 (8.33%) Cognos
5 7 (8.33%) Sybase
6 6 (7.14%) Hyperion
6 6 (7.14%) IBM
7 5 (5.95%) MicroStrategy
8 4 (4.76%) Informatica
9 2 (2.38%) Teradata
9 2 (2.38%) Vertica
10 1 (1.19%) Ab Initio
10 1 (1.19%) Alteryx
10 1 (1.19%) DataFlux
10 1 (1.19%) Endeca
10 1 (1.19%) hybris
10 1 (1.19%) Netezza
10 1 (1.19%) Talend
10 1 (1.19%) VMware
City, London
onezeero.
Salary: £50000 - £60000 per annum + Bonus + Benefits
Posted: 20 hours ago
City, London
Streamline Connections
Salary: £55000 - £70000 per annum + Benefits
Posted: Yesterday
City of London
Lawrence Harvey
Salary: £55000.00 - £65000.00 per annum
Posted: 10 days ago
City of London
Hays London City Cheapside
Salary: £60000.00 - £80000.00 per annum
Posted: 13 days ago
City Of London
HFG
Salary: £55000 - £65000 per annum, Benefits: Bonus + Benefits
Posted: 15 days ago
City of London
Nigel Frank International Ltd
Salary: £50000 - £60000 per annum + Package and Benefits Scheme
Posted: 16 days ago
City of London
Deerfoot IT Resources Ltd
Salary: £60000 - £65000 per annum + Bonus and Benefits
Posted: 20 days ago