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

Location
3 months to
5 Feb 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 209 264 249
Rank change year-on-year
+55 -15
Permanent jobs citing OLAP 52 54 72
As % of all permanent IT jobs located in the City of London 0.78% 0.53% 0.70%
As % of the Database & Business Intelligence category 2.58% 1.98% 2.52%
Number of salaries quoted 48 52 66
Average salary £55,000 £70,000 £57,500
Average salary % change year-on-year
-21.42% +21.73%
90% offered a salary of more than £51,050 £42,750 £47,500
10% offered a salary of more than £63,550 £77,500 £82,500
UK excluding London average salary £43,750 £40,000 £40,000
% change year-on-year
+9.37% -
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
2014 2731 2861
As % of all permanent IT jobs located in the City of London 30.09% 26.78% 27.87%
Number of salaries quoted 1782 2467 2505
Average salary £55,000 £55,000 £55,000
90% offered a salary of more than £40,000 £37,500 £35,000
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 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 5 February 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 5 February 2016, 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 79 (80.61%) Business Intelligence
2 74 (75.51%) SQL Server
3 73 (74.49%) ETL
4 69 (70.41%) SQL Server Integration Services
5 59 (60.20%) SQL Server Reporting Services
6 58 (59.18%) SQL Server Analysis Services
7 52 (53.06%) Microsoft
8 51 (52.04%) Data Warehouse
9 50 (51.02%) Data Modelling
10 46 (46.94%) SQL
11 40 (40.82%) Finance
12 35 (35.71%) Analytics
13 32 (32.65%) MS Excel
14 29 (29.59%) MDX
15 25 (25.51%) OLAP Cube
16 22 (22.45%) Agile Software Development
17 21 (21.43%) T-SQL
18 20 (20.41%) Microsoft Azure
19 19 (19.39%) Marketing
20 18 (18.37%) OLTP
21 17 (17.35%) SQL Server 2008
22 16 (16.33%) Retail
23 15 (15.31%) C#
23 15 (15.31%) Sybase
23 15 (15.31%) Analytical Skills
24 14 (14.29%) .NET
24 14 (14.29%) Banking
24 14 (14.29%) Data Analysis
25 13 (13.27%) E-Commerce
25 13 (13.27%) Open Source

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

For the 6 months to 5 February 2016, 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 4 (4.08%) SAS
2 1 (1.02%) Apache Spark
Applications
1 32 (32.65%) MS Excel
2 7 (7.14%) MS Visio
3 6 (6.12%) MS Office
4 2 (2.04%) SPSS
5 1 (1.02%) PowerPivot
Business Applications
1 7 (7.14%) Cognos Business Intelligence
2 6 (6.12%) HFM
3 1 (1.02%) Dynamics AX
3 1 (1.02%) Hyperion Planning
3 1 (1.02%) Oracle EBS
Cloud Services
1 20 (20.41%) Microsoft Azure
2 1 (1.02%) Amazon AWS
2 1 (1.02%) SaaS
Database & Business Intelligence
1 74 (75.51%) SQL Server
2 69 (70.41%) SQL Server Integration Services
3 59 (60.20%) SQL Server Reporting Services
4 58 (59.18%) SQL Server Analysis Services
5 51 (52.04%) Data Warehouse
6 25 (25.51%) OLAP Cube
7 18 (18.37%) OLTP
8 17 (17.35%) SQL Server 2008
9 12 (12.24%) Data Mining
9 12 (12.24%) QlikView
10 11 (11.22%) SSDT
11 10 (10.20%) Oracle OLAP
12 9 (9.18%) Data Mart
12 9 (9.18%) Power BI
13 8 (8.16%) BusinessObjects
14 7 (7.14%) Cognos Analysis Studio
14 7 (7.14%) Cognos Event Studio
14 7 (7.14%) Cognos Metric Studio
15 6 (6.12%) SAP Data Services
16 5 (5.10%) Hyperion Smart View
Development Applications
1 7 (7.14%) PowerDesigner
2 6 (6.12%) Eclipse
3 1 (1.02%) Git (software)
3 1 (1.02%) JIRA
3 1 (1.02%) Team Foundation Server
General
1 40 (40.82%) Finance
2 19 (19.39%) Marketing
3 16 (16.33%) Retail
4 14 (14.29%) Banking
5 8 (8.16%) Financial Institution
6 2 (2.04%) Advertising
6 2 (2.04%) Back Office
6 2 (2.04%) Telecoms
7 1 (1.02%) Billing
7 1 (1.02%) Games
7 1 (1.02%) Investment Banking
7 1 (1.02%) Legal
7 1 (1.02%) Military
Job Titles
1 77 (78.57%) Developer
2 45 (45.92%) Business Intelligence Developer
3 23 (23.47%) Analyst
4 20 (20.41%) Senior Developer
5 19 (19.39%) SQL Developer
6 15 (15.31%) Analyst Developer
7 13 (13.27%) Database Developer
7 13 (13.27%) Lead Developer
7 13 (13.27%) SQL BI Developer
7 13 (13.27%) SQL Server Developer
8 12 (12.24%) Azure Developer
8 12 (12.24%) Marketing Database Developer
8 12 (12.24%) Senior Database Developer
9 11 (11.22%) Business Intelligence Analyst
9 11 (11.22%) SQL Server BI Developer
10 10 (10.20%) Data Analyst
11 8 (8.16%) Business Developer
11 8 (8.16%) Developer Analyst
11 8 (8.16%) Senior Business Intelligence Developer
12 7 (7.14%) Cognos BI Developer
Libraries, Frameworks & Software Standards
1 29 (29.59%) MDX
2 14 (14.29%) .NET
3 4 (4.08%) XML
4 2 (2.04%) CSS
4 2 (2.04%) HTML
Miscellaneous
1 15 (15.31%) Analytical Skills
2 10 (10.20%) Visualisation
3 9 (9.18%) Reinsurance
4 6 (6.12%) Computer Science
5 5 (5.10%) Data Integration
6 4 (4.08%) Mathematics
7 2 (2.04%) Blackberry
7 2 (2.04%) Data Conversion
7 2 (2.04%) Derivative
7 2 (2.04%) Foreign Exchange (FX)
7 2 (2.04%) Management Information System
7 2 (2.04%) Physics
7 2 (2.04%) Statistics
8 1 (1.02%) Animation
8 1 (1.02%) Credit Risk
8 1 (1.02%) Life Science
8 1 (1.02%) Oracle Exalogic
8 1 (1.02%) Oracle Exalytics
8 1 (1.02%) Replication
8 1 (1.02%) User Experience
Processes & Methodologies
1 79 (80.61%) Business Intelligence
2 73 (74.49%) ETL
3 50 (51.02%) Data Modelling
4 35 (35.71%) Analytics
5 22 (22.45%) Agile Software Development
6 14 (14.29%) Data Analysis
7 13 (13.27%) E-Commerce
7 13 (13.27%) Open Source
8 12 (12.24%) Marketing Analytics
8 12 (12.24%) SDLC
8 12 (12.24%) Statistical Analysis
9 11 (11.22%) Data Management
10 9 (9.18%) BCP
10 9 (9.18%) Data Security
10 9 (9.18%) Dimensional Modelling
11 7 (7.14%) CRM
11 7 (7.14%) Regression Testing
11 7 (7.14%) Waterfall
12 6 (6.12%) ETL Development
13 5 (5.10%) Mentoring
Programming Languages
1 46 (46.94%) SQL
2 21 (21.43%) T-SQL
3 15 (15.31%) C#
4 7 (7.14%) Data Analysis Expressions (DAX)
5 5 (5.10%) C
6 3 (3.06%) Java
6 3 (3.06%) VBA
7 2 (2.04%) VB.NET
8 1 (1.02%) Python
8 1 (1.02%) R
8 1 (1.02%) Ruby
8 1 (1.02%) Scala
8 1 (1.02%) VB
Qualifications
1 9 (9.18%) Degree
2 5 (5.10%) ACCA
2 5 (5.10%) CIMA
3 2 (2.04%) IBM Certification
3 2 (2.04%) ISEB
Quality Assurance & Compliance
1 5 (5.10%) Sarbanes-Oxley
2 3 (3.06%) QA
3 1 (1.02%) SLA
Vendors
1 52 (53.06%) Microsoft
2 15 (15.31%) Sybase
3 12 (12.24%) Cognos
4 10 (10.20%) Oracle
4 10 (10.20%) SAP
5 9 (9.18%) IBM
6 7 (7.14%) Hyperion
6 7 (7.14%) Tableau
7 5 (5.10%) MicroStrategy
8 3 (3.06%) Informatica
8 3 (3.06%) Teradata
9 2 (2.04%) Ab Initio
9 2 (2.04%) DataFlux
10 1 (1.02%) Endeca
10 1 (1.02%) hybris
10 1 (1.02%) Netezza
10 1 (1.02%) Vertica
City, London
TEKsystems
Salary: £40000 - £50000 per annum + brilliant bonuses and benefits
Posted: 2 days ago
City, London
ANSON MCCADE
Salary: £35k - £60k plus attractive benefits and extensive career progression
Posted: 2 days ago
City Of London
HFG
Salary: Competitive
Posted: 25 days ago