The table below looks at the statistics for ROLAP skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited ROLAP over the 3 months to 24 December 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
24 Dec 2014
Same period 2013 Same period 2012
Relational Online Analytical Processing (ROLAP)
Rank 864 860 880
Rank change year-on-year
-4 +20
Permanent jobs citing ROLAP 16 19 14
As % of all permanent IT jobs located in the UK 0.014% 0.018% 0.012%
As % of the Database & Business Intelligence category 0.049% 0.055% 0.037%
Number of salaries quoted 14 19 13
Average salary £60,000 £32,500 £60,000
Average salary % change year-on-year
+84.61% -45.83%
90% offered a salary of more than £40,000 £29,000 £47,500
10% offered a salary of more than £87,500 £75,500 £65,000
UK excluding London average salary £40,000 £32,000 £49,000
% change year-on-year
+25.00% -34.69%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
32961 34625 37489
As % of all permanent IT jobs located in the UK 29.83% 32.12% 32.91%
Number of salaries quoted 28292 29471 33449
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £30,500 £30,000 £30,000
10% offered a salary of more than £70,000 £62,500 £67,500
UK excluding London average salary £40,000 £40,000 £39,000
% change year-on-year
- +2.56%

ROLAP
Jobs Demand Trend

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

ROLAP Jobs Demand Trend in the UK

ROLAP
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ROLAP within the UK.

ROLAP Salary Trend in the UK

ROLAP
Salary Histogram

This chart provides a salary histogram for IT jobs citing ROLAP over the 3 months to 24 December 2014 within the UK.

ROLAP Salary Histogram in the UK

ROLAP
Top 9 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing ROLAP within the UK over the 3 months to 24 December 2014. 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
England -5 16 £60,000 +84.61%
London -1 9 £87,500 +16.66%
Leeds - 4 £46,500 -
West Yorkshire - 4 £46,500 -
Yorkshire - 4 £46,500 -
Hertfordshire -25 3 £40,000 +37.93%
East of England -26 3 £40,000 +37.93%
Hitchin - 2 £40,000 -
Letchworth +5 1 £40,000 +37.93%

ROLAP
Top 30 Related IT Skills

For the 6 months to 24 December 2014, IT jobs within the UK citing ROLAP 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 ROLAP.

1 38 (79.17%) Business Intelligence
2 35 (72.92%) ETL
3 34 (70.83%) Data Warehouse
4 33 (68.75%) Oracle
5 29 (60.42%) OLAP
6 26 (54.17%) MOLAP
6 26 (54.17%) Oracle OLAP
7 25 (52.08%) SQL
8 17 (35.42%) SQL Server
8 17 (35.42%) Agile Software Development
8 17 (35.42%) SQL Server Reporting Services
9 16 (33.33%) Data Modelling
10 15 (31.25%) Business Objects
11 14 (29.17%) Teradata
12 13 (27.08%) Analytics
13 12 (25.00%) Degree
14 11 (22.92%) Management Information System
14 11 (22.92%) Finance
14 11 (22.92%) Data Management
14 11 (22.92%) Netezza
14 11 (22.92%) SQL Server Integration Services
14 11 (22.92%) SQL Server Analysis Services
14 11 (22.92%) Master Data Management
15 10 (20.83%) PL/SQL
15 10 (20.83%) Kimball Methodology
15 10 (20.83%) OLAP Cube
16 9 (18.75%) SAP
17 8 (16.67%) Cognos
17 8 (16.67%) Dimensional Modelling
17 8 (16.67%) Data Integration

ROLAP
Top Related IT Skills by Category

For the 6 months to 24 December 2014, IT jobs within the UK citing ROLAP 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 ROLAP. Up to 20 skills are shown per category.

Application Platforms
1 7 (14.58%) Apache Pig
1 7 (14.58%) Apache Spark
2 5 (10.42%) SharePoint
Applications
1 3 (6.25%) MS Excel
Business Applications
1 7 (14.58%) SAP MDM
1 7 (14.58%) Cognos TM1
1 7 (14.58%) Cognos Business Intelligence
Database & Business Intelligence
1 34 (70.83%) Data Warehouse
2 29 (60.42%) OLAP
3 26 (54.17%) MOLAP
3 26 (54.17%) Oracle OLAP
4 17 (35.42%) SQL Server Reporting Services
4 17 (35.42%) SQL Server
5 11 (22.92%) SQL Server Integration Services
5 11 (22.92%) SQL Server Analysis Services
6 10 (20.83%) OLAP Cube
7 7 (14.58%) Apache Hive
7 7 (14.58%) MongoDB
7 7 (14.58%) SAP Data Services
7 7 (14.58%) Big Data
7 7 (14.58%) Amazon DynamoDB
7 7 (14.58%) Star Schema
7 7 (14.58%) SAP BI
7 7 (14.58%) DB2
7 7 (14.58%) Oracle Reports
8 6 (12.50%) Data Mining
9 5 (10.42%) Hadoop
General
1 11 (22.92%) Finance
2 3 (6.25%) Marketing
2 3 (6.25%) Advertising
3 1 (2.08%) Games
3 1 (2.08%) Banking
3 1 (2.08%) Retail
3 1 (2.08%) Manufacturing
Job Titles
1 12 (25.00%) Developer
2 11 (22.92%) Analyst
2 11 (22.92%) Business Analyst
2 11 (22.92%) Business Intelligence Analyst
3 8 (16.67%) Business Intelligence Developer
3 8 (16.67%) Consultant
4 7 (14.58%) Business Intelligence Consultant
4 7 (14.58%) Technical Leader
4 7 (14.58%) Business Intelligence Manager
5 6 (12.50%) Business Manager
6 5 (10.42%) Business Consultant
6 5 (10.42%) Business Developer
7 4 (8.33%) Information Manager
7 4 (8.33%) Systems Manager
7 4 (8.33%) Team Leader
7 4 (8.33%) Architect
7 4 (8.33%) Information Systems Manager
8 3 (6.25%) SQL Developer
8 3 (6.25%) Oracle Developer
9 2 (4.17%) Oracle Consultant
Libraries, Frameworks & Software Standards
1 7 (14.58%) XML
2 4 (8.33%) .NET
3 3 (6.25%) MDX
4 2 (4.17%) REST
4 2 (4.17%) SOAP
Miscellaneous
1 11 (22.92%) Management Information System
2 8 (16.67%) Data Integration
3 6 (12.50%) Computer Science
4 5 (10.42%) Open Source
5 4 (8.33%) Analytical Skills
6 3 (6.25%) Visualisation
7 2 (4.17%) Linked Data
7 2 (4.17%) FMCG
8 1 (2.08%) Replication
8 1 (2.08%) Data Structures
Processes & Methodologies
1 38 (79.17%) Business Intelligence
2 35 (72.92%) ETL
3 17 (35.42%) Agile Software Development
4 16 (33.33%) Data Modelling
5 13 (27.08%) Analytics
6 11 (22.92%) Master Data Management
6 11 (22.92%) Data Management
7 10 (20.83%) Kimball Methodology
8 8 (16.67%) Dimensional Modelling
9 7 (14.58%) Data Architecture
9 7 (14.58%) Capacity Planning
9 7 (14.58%) TDD
9 7 (14.58%) MapReduce
9 7 (14.58%) Data Governance
9 7 (14.58%) Inmon Methodology
10 6 (12.50%) Information Management
11 5 (10.42%) Data Analysis
11 5 (10.42%) Strategic Planning
12 4 (8.33%) Data Migration
12 4 (8.33%) Project Management
Programming Languages
1 25 (52.08%) SQL
2 10 (20.83%) PL/SQL
3 7 (14.58%) T-SQL
4 4 (8.33%) VB.NET
4 4 (8.33%) VBA
5 3 (6.25%) XPath
5 3 (6.25%) VB
5 3 (6.25%) C#
6 2 (4.17%) Java
6 2 (4.17%) SPARQL
Qualifications
1 12 (25.00%) Degree
2 3 (6.25%) Microsoft Certification
3 2 (4.17%) OCP
3 2 (4.17%) Oracle Certification
3 2 (4.17%) MCSE
4 1 (2.08%) MCTS
Quality Assurance & Compliance
1 6 (12.50%) ISO 9001
2 4 (8.33%) QA
Vendors
1 33 (68.75%) Oracle
2 15 (31.25%) Business Objects
3 14 (29.17%) Teradata
4 11 (22.92%) Netezza
5 9 (18.75%) SAP
6 8 (16.67%) Cognos
7 7 (14.58%) IBM
7 7 (14.58%) Tableau
8 4 (8.33%) Vertica
9 3 (6.25%) Microsoft
10 1 (2.08%) Informatica