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

Location
3 months to
22 Oct 2014
Same period 2013 Same period 2012
Relational Online Analytical Processing (ROLAP)
Rank 833 861 870
Rank change year-on-year
+28 +9
Permanent jobs citing ROLAP 27 15 4
As % of all permanent IT jobs located in England 0.026% 0.015% 0.004%
As % of the Database & Business Intelligence category 0.085% 0.046% 0.012%
Number of salaries quoted 19 15 4
Average salary £42,500 £62,500 £61,250
Average salary % change year-on-year
-32.00% +2.04%
90% offered a salary of more than £40,000 £48,500 £45,250
10% offered a salary of more than £71,000 £72,000 £65,000
UK excluding London average salary £42,500 £65,000 £65,000
% change year-on-year
-34.61% -
ROLAP
UK

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

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
31854 32483 34175
As % of all permanent IT jobs located in England 30.18% 32.03% 31.67%
Number of salaries quoted 27119 28430 30257
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £67,500
UK excluding London average salary £40,000 £40,000 £40,000

ROLAP
Jobs Demand Trend in England

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

ROLAP Jobs Demand Trend in England

ROLAP
Salary Trend in England

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

ROLAP Salary Trend in England

ROLAP
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing ROLAP across the England region over the 3 months to 22 October 2014.

ROLAP Salary Histogram in England

ROLAP
Job Locations in England

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing ROLAP within the England region over the 3 months to 22 October 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
East of England - 11 £40,000 -
London +11 8 £72,500 +20.83%
South East -13 3 £67,500 +3.84%
Yorkshire - 3 £46,500 -
North West -12 2 £47,500 -24.00%
ROLAP
UK

ROLAP
Top 30 Related IT Skills in England

For the 6 months to 22 October 2014, IT jobs across the England region 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 47 (92.16%) Business Intelligence
2 38 (74.51%) OLAP
3 37 (72.55%) Data Warehouse
4 33 (64.71%) ETL
5 28 (54.90%) Oracle
5 28 (54.90%) SQL
6 26 (50.98%) Oracle OLAP
7 23 (45.10%) MOLAP
8 22 (43.14%) SQL Server Reporting Services
9 21 (41.18%) SQL Server
9 21 (41.18%) Kimball Methodology
10 16 (31.37%) Data Modelling
10 16 (31.37%) SQL Server Analysis Services
10 16 (31.37%) SQL Server Integration Services
11 14 (27.45%) Cognos
11 14 (27.45%) Business Objects
11 14 (27.45%) Teradata
12 13 (25.49%) Cognos TM1
12 13 (25.49%) Dimensional Modelling
12 13 (25.49%) Analytics
13 12 (23.53%) Master Data Management
13 12 (23.53%) Degree
13 12 (23.53%) Netezza
13 12 (23.53%) Data Management
13 12 (23.53%) Management Information System
13 12 (23.53%) Finance
14 11 (21.57%) Agile Software Development
14 11 (21.57%) T-SQL
14 11 (21.57%) Tableau
15 10 (19.61%) Analytical Skills

ROLAP
Top Related IT Skills in England by Category

For the 6 months to 22 October 2014, IT jobs across the England region 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 5 (9.80%) SharePoint
Applications
1 6 (11.76%) MS Excel
Business Applications
1 13 (25.49%) Cognos TM1
2 8 (15.69%) Cognos Business Intelligence
3 7 (13.73%) SAP MDM
Database & Business Intelligence
1 38 (74.51%) OLAP
2 37 (72.55%) Data Warehouse
3 26 (50.98%) Oracle OLAP
4 23 (45.10%) MOLAP
5 22 (43.14%) SQL Server Reporting Services
6 21 (41.18%) SQL Server
7 16 (31.37%) SQL Server Analysis Services
7 16 (31.37%) SQL Server Integration Services
8 7 (13.73%) SAP Data Services
8 7 (13.73%) SAP BI
8 7 (13.73%) Oracle Reports
8 7 (13.73%) DB2
8 7 (13.73%) OLTP
8 7 (13.73%) Star Schema
9 6 (11.76%) Data Mining
10 5 (9.80%) SQL Server 2008
11 4 (7.84%) Relational Database
12 2 (3.92%) Oracle ODI
12 2 (3.92%) BusinessObjects
13 1 (1.96%) Oracle Database 10g
General
1 12 (23.53%) Finance
2 5 (9.80%) Advertising
3 4 (7.84%) Marketing
4 1 (1.96%) Manufacturing
4 1 (1.96%) Banking
4 1 (1.96%) Retail
Job Titles
1 17 (33.33%) Developer
2 13 (25.49%) Business Manager
2 13 (25.49%) Business Intelligence Manager
3 12 (23.53%) Business Intelligence Developer
4 11 (21.57%) Analyst
4 11 (21.57%) Business Analyst
4 11 (21.57%) Business Intelligence Analyst
5 10 (19.61%) Information Systems Manager
5 10 (19.61%) Information Manager
5 10 (19.61%) Systems Manager
6 8 (15.69%) Consultant
6 8 (15.69%) SQL Developer
7 7 (13.73%) Business Intelligence Consultant
8 5 (9.80%) Senior Developer
8 5 (9.80%) Business Developer
8 5 (9.80%) Business Consultant
8 5 (9.80%) Senior Business Intelligence Developer
9 4 (7.84%) Senior SQL Server Developer
9 4 (7.84%) SQL Server BI Developer
9 4 (7.84%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 8 (15.69%) MDX
2 7 (13.73%) .NET
2 7 (13.73%) XML
Miscellaneous
1 12 (23.53%) Management Information System
2 10 (19.61%) Analytical Skills
3 8 (15.69%) Visualisation
3 8 (15.69%) Data Integration
4 7 (13.73%) Computer Science
5 2 (3.92%) FMCG
6 1 (1.96%) Replication
6 1 (1.96%) Data Structures
Processes & Methodologies
1 47 (92.16%) Business Intelligence
2 33 (64.71%) ETL
3 21 (41.18%) Kimball Methodology
4 16 (31.37%) Data Modelling
5 13 (25.49%) Dimensional Modelling
5 13 (25.49%) Analytics
6 12 (23.53%) Master Data Management
6 12 (23.53%) Data Management
7 11 (21.57%) Agile Software Development
8 7 (13.73%) Data Architecture
8 7 (13.73%) Capacity Planning
8 7 (13.73%) Inmon Methodology
9 5 (9.80%) Migration
9 5 (9.80%) Project Management
9 5 (9.80%) Information Management
9 5 (9.80%) Data Migration
9 5 (9.80%) Strategic Planning
10 4 (7.84%) Data Mapping
10 4 (7.84%) Change Data Capture
10 4 (7.84%) Data Visualisation
Programming Languages
1 28 (54.90%) SQL
2 11 (21.57%) T-SQL
3 9 (17.65%) PL/SQL
4 8 (15.69%) C#
5 5 (9.80%) VBA
6 4 (7.84%) XPath
6 4 (7.84%) VB
7 3 (5.88%) VB.NET
8 2 (3.92%) PowerHouse
Qualifications
1 12 (23.53%) Degree
2 2 (3.92%) Microsoft Certification
3 1 (1.96%) OCP
3 1 (1.96%) Oracle Certification
3 1 (1.96%) MCSE
3 1 (1.96%) MCTS
Quality Assurance & Compliance
1 6 (11.76%) ISO 9001
2 3 (5.88%) QA
Vendors
1 28 (54.90%) Oracle
2 14 (27.45%) Cognos
2 14 (27.45%) Business Objects
2 14 (27.45%) Teradata
3 12 (23.53%) Netezza
4 11 (21.57%) Tableau
5 9 (17.65%) SAP
6 7 (13.73%) IBM
7 6 (11.76%) Microsoft
8 5 (9.80%) Vertica
9 1 (1.96%) Informatica