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

3 months to
31 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 226 229 269
Rank change year-on-year
+3 +40
Permanent jobs citing OLAP 35 78 103
As % of all permanent IT jobs located in the City of London 0.54% 0.78% 0.80%
As % of the Database & Business Intelligence category 2.01% 2.60% 2.58%
Number of salaries quoted 32 75 89
Median salary £60,000 £60,000 £55,000
Median salary % change year-on-year
- +9.09%
90% offered a salary of more than £50,000 £49,500 £40,000
10% offered a salary of more than £69,750 £72,500 £65,000
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -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
1743 3001 3989
As % of all permanent IT jobs located in the City of London 26.78% 30.07% 30.94%
Number of salaries quoted 1577 2615 3478
Median salary £55,000 £57,500 £54,000
Median salary % change year-on-year
-4.34% +6.48%
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £77,500 £77,500 £75,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 31 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 31 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 63 (79.75%) Business Intelligence
2 54 (68.35%) SQL Server
3 52 (65.82%) ETL
3 52 (65.82%) SQL Server Integration Services
4 46 (58.23%) SQL Server Analysis Services
5 42 (53.16%) SQL Server Reporting Services
6 41 (51.90%) SQL
7 40 (50.63%) Microsoft
7 40 (50.63%) Data Warehouse
8 38 (48.10%) Finance
9 36 (45.57%) MS Excel
10 29 (36.71%) Data Modelling
11 27 (34.18%) MDX
12 25 (31.65%) Analytics
12 25 (31.65%) OLTP
12 25 (31.65%) T-SQL
13 20 (25.32%) Agile Software Development
14 15 (18.99%) Analytical Skills
14 15 (18.99%) OLAP Cube
14 15 (18.99%) Oracle
14 15 (18.99%) Oracle OLAP
15 14 (17.72%) Marketing
15 14 (17.72%) .NET
15 14 (17.72%) C#
15 14 (17.72%) E-Commerce
16 13 (16.46%) Dimensional Modelling
16 13 (16.46%) Retail
16 13 (16.46%) Marketing Analytics
16 13 (16.46%) Open Source
17 12 (15.19%) Microsoft Azure

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 3 (3.80%) SAS
2 2 (2.53%) Apache
3 1 (1.27%) Blackberry Enterprise Server
3 1 (1.27%) IIS
3 1 (1.27%) MS Exchange
3 1 (1.27%) SharePoint
3 1 (1.27%) WebSphere
Applications
1 36 (45.57%) MS Excel
2 3 (3.80%) MS Office
3 2 (2.53%) MS PowerPoint
3 2 (2.53%) MS Visio
3 2 (2.53%) Spreadsheet
4 1 (1.27%) Acrobat
4 1 (1.27%) MS Project
4 1 (1.27%) SPSS
Business Applications
1 5 (6.33%) HFM
2 3 (3.80%) Cognos Business Intelligence
Cloud Services
1 12 (15.19%) Microsoft Azure
2 1 (1.27%) SaaS
Communications & Networking
1 2 (2.53%) Intranet
2 1 (1.27%) DHCP
2 1 (1.27%) DNS
2 1 (1.27%) LAN
2 1 (1.27%) Network Security
2 1 (1.27%) Remote Desktop
2 1 (1.27%) TCP/IP
2 1 (1.27%) WAN
Database & Business Intelligence
1 54 (68.35%) SQL Server
2 52 (65.82%) SQL Server Integration Services
3 46 (58.23%) SQL Server Analysis Services
4 42 (53.16%) SQL Server Reporting Services
5 40 (50.63%) Data Warehouse
6 25 (31.65%) OLTP
7 15 (18.99%) OLAP Cube
7 15 (18.99%) Oracle OLAP
8 11 (13.92%) Data Mining
9 9 (11.39%) QlikView
9 9 (11.39%) Relational Database
9 9 (11.39%) SQL Server 2008
10 7 (8.86%) Big Data
10 7 (8.86%) BusinessObjects
10 7 (8.86%) Data Mart
11 6 (7.59%) Oracle Reports
12 5 (6.33%) Microsoft Analysis Services
12 5 (6.33%) Oracle ODI
12 5 (6.33%) PowerPivot
12 5 (6.33%) SQL Server 2012
Development Applications
1 7 (8.86%) Eclipse
2 4 (5.06%) Team Foundation Server
3 1 (1.27%) Git (software)
3 1 (1.27%) Jenkins
3 1 (1.27%) JIRA
3 1 (1.27%) Subversion
3 1 (1.27%) Talend Open Studio
3 1 (1.27%) Visual Studio
General
1 38 (48.10%) Finance
2 14 (17.72%) Marketing
3 13 (16.46%) Retail
4 9 (11.39%) Banking
5 6 (7.59%) Legal
6 2 (2.53%) Back Office
6 2 (2.53%) Financial Institution
6 2 (2.53%) Investment Banking
7 1 (1.27%) Advertising
7 1 (1.27%) Billing
7 1 (1.27%) Games
7 1 (1.27%) Law
7 1 (1.27%) Military
Job Titles
1 53 (67.09%) Developer
2 33 (41.77%) Business Intelligence Developer
3 16 (20.25%) Senior Developer
3 16 (20.25%) SSAS Developer
3 16 (20.25%) SSIS Developer
3 16 (20.25%) SSRS Developer
4 14 (17.72%) Analyst
5 12 (15.19%) Azure Developer
5 12 (15.19%) Database Developer
5 12 (15.19%) Marketing Database Developer
5 12 (15.19%) Senior Database Developer
6 11 (13.92%) SQL Developer
7 10 (12.66%) SQL Server Developer
8 9 (11.39%) SQL BI Developer
8 9 (11.39%) SQL Server BI Developer
9 8 (10.13%) Business Intelligence Analyst
9 8 (10.13%) Data Analyst
10 6 (7.59%) Analyst Developer
11 5 (6.33%) Lead Developer
11 5 (6.33%) Systems Accountant
Libraries, Frameworks & Software Standards
1 27 (34.18%) MDX
2 14 (17.72%) .NET
3 3 (3.80%) HTML
3 3 (3.80%) ODBC
4 2 (2.53%) CSS
4 2 (2.53%) D3.js
4 2 (2.53%) Django
4 2 (2.53%) jQuery
4 2 (2.53%) JSON
4 2 (2.53%) SVG
5 1 (1.27%) WebSphere MQ
5 1 (1.27%) XML
Miscellaneous
1 15 (18.99%) Analytical Skills
2 8 (10.13%) Visualisation
3 7 (8.86%) Data Extraction
3 7 (8.86%) Reinsurance
4 6 (7.59%) Data Integration
5 5 (6.33%) Computer Science
6 3 (3.80%) Blackberry
6 3 (3.80%) Foreign Exchange (FX)
6 3 (3.80%) Mathematics
7 2 (2.53%) Derivative
7 2 (2.53%) Statistics
8 1 (1.27%) Animation
8 1 (1.27%) Device Driver
8 1 (1.27%) Digital Media
8 1 (1.27%) Economics
8 1 (1.27%) Embedded Systems
8 1 (1.27%) iPad
8 1 (1.27%) Management Information System
8 1 (1.27%) Market Risk
8 1 (1.27%) User Experience
Operating Systems
1 3 (3.80%) Linux
2 2 (2.53%) Unix
3 1 (1.27%) Windows
3 1 (1.27%) Windows 7
3 1 (1.27%) Windows Vista
Processes & Methodologies
1 63 (79.75%) Business Intelligence
2 52 (65.82%) ETL
3 29 (36.71%) Data Modelling
4 25 (31.65%) Analytics
5 20 (25.32%) Agile Software Development
6 14 (17.72%) E-Commerce
7 13 (16.46%) Dimensional Modelling
7 13 (16.46%) Marketing Analytics
7 13 (16.46%) Open Source
8 12 (15.19%) Data Analysis
8 12 (15.19%) Performance Tuning
8 12 (15.19%) Statistical Analysis
9 10 (12.66%) SDLC
10 9 (11.39%) Stakeholder Management
11 7 (8.86%) BCP
11 7 (8.86%) Data Security
11 7 (8.86%) Data Visualisation
11 7 (8.86%) Kimball Methodology
11 7 (8.86%) Performance Management
12 6 (7.59%) CRM
Programming Languages
1 41 (51.90%) SQL
2 25 (31.65%) T-SQL
3 14 (17.72%) C#
4 9 (11.39%) Data Analysis Expressions (DAX)
5 5 (6.33%) JavaScript
6 4 (5.06%) VBA
7 3 (3.80%) PL/SQL
8 2 (2.53%) C++
8 2 (2.53%) Java
8 2 (2.53%) PowerShell
8 2 (2.53%) Python
9 1 (1.27%) C
9 1 (1.27%) PHP
9 1 (1.27%) R
9 1 (1.27%) Ruby
9 1 (1.27%) VB
Qualifications
1 10 (12.66%) Degree
2 6 (7.59%) ACCA
2 6 (7.59%) CIMA
3 3 (3.80%) IBM Certification
4 2 (2.53%) ISEB
4 2 (2.53%) Microsoft Certification
5 1 (1.27%) HND
5 1 (1.27%) ITIL Certification
5 1 (1.27%) MBA
Quality Assurance & Compliance
1 7 (8.86%) Data Quality
2 6 (7.59%) QA
3 5 (6.33%) Sarbanes-Oxley
4 1 (1.27%) SLA
System Software
1 1 (1.27%) Active Directory
1 1 (1.27%) Microsoft Virtual Server
1 1 (1.27%) VMware Infrastructure
Vendors
1 40 (50.63%) Microsoft
2 15 (18.99%) Oracle
3 8 (10.13%) SAP
3 8 (10.13%) Tableau
4 7 (8.86%) IBM
5 6 (7.59%) Cognos
5 6 (7.59%) Sybase
6 5 (6.33%) Hyperion
6 5 (6.33%) Informatica
7 4 (5.06%) MicroStrategy
8 3 (3.80%) Alteryx
9 1 (1.27%) Adobe
9 1 (1.27%) Citrix
9 1 (1.27%) hybris
9 1 (1.27%) Talend
9 1 (1.27%) Vertica
9 1 (1.27%) VMware
City, London
ANSON MCCADE
Salary: £45,000 - £65,000 and Competitive Package
Posted: 9 hours ago
City Of London
HFG
Salary: £50000 - £55000 per annum, Benefits: Bonus + Corp Bens.
Posted: 15 days ago