The following table provides summary statistics for permanent job vacancies with a requirement for ROLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ROLAP over the 3 months to 23 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
23 Mar 2017
Same period 2016 Same period 2015
Relational OLAP (ROLAP)
UK
Rank 848 936 951
Rank change year-on-year +88 +15  
Permanent jobs citing ROLAP 1 10 5
As % of all permanent IT jobs advertised in the UK 0.001% 0.010% 0.005%
As % of the Database & Business Intelligence category 0.004% 0.031% 0.015%
Number of salaries quoted 1 10 5
Median salary £42,500 £52,500 £52,500
Median salary % change year-on-year -19.04% -  
UK excluding London median salary £42,500 £62,500 £34,000
% change year-on-year -32.00% +83.82%  

ROLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 25702 31812 32970
As % of all permanent IT job vacancies advertised in the UK 30.69% 31.01% 31.32%
Number of salaries quoted 21790 27061 27928
Median salary £47,500 £50,000 £45,000
Median salary % change year-on-year -5.00% +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

ROLAP
Job Vacancy Trend

The job posting trend of jobs advertised citing ROLAP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for ROLAP in the UK

ROLAP
Salary Trend

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

Salary trend for ROLAP in the UK

ROLAP
Top 4 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ROLAP within the UK over the 3 months to 23 March 2017. 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 Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +84 1 £42,500 -19.04%
Leeds - 1 £42,500 -
West Yorkshire - 1 £42,500 -
Yorkshire - 1 £42,500 -

ROLAP
Top 30 Related IT Skills

For the 6 months to 23 March 2017, IT jobs citing ROLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for ROLAP.

1 1 (100.00%) C#
1 1 (100.00%) SQL
1 1 (100.00%) T-SQL
1 1 (100.00%) VB.NET
1 1 (100.00%) .NET
1 1 (100.00%) SQL Server
1 1 (100.00%) OLAP
1 1 (100.00%) UML
1 1 (100.00%) MCSE
1 1 (100.00%) MS Excel
1 1 (100.00%) SharePoint
1 1 (100.00%) Data Warehouse
1 1 (100.00%) ETL
1 1 (100.00%) Business Intelligence
1 1 (100.00%) MOLAP
1 1 (100.00%) OLTP
1 1 (100.00%) Microsoft
1 1 (100.00%) Microsoft Certification
1 1 (100.00%) Migration
1 1 (100.00%) SQL Server Reporting Services
1 1 (100.00%) SQL Server Integration Services
1 1 (100.00%) MDX
1 1 (100.00%) SQL Server Analysis Services
1 1 (100.00%) Dimensional Modelling
1 1 (100.00%) Data Integration
1 1 (100.00%) Data Architecture
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) Data Quality
1 1 (100.00%) SQL Server 2012
1 1 (100.00%) Kimball Methodology

ROLAP
Top Related IT Skills 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 1 (100.00%) SharePoint
Applications
1 1 (100.00%) MS Excel
Database & Business Intelligence
1 1 (100.00%) Data Warehouse
1 1 (100.00%) MOLAP
1 1 (100.00%) OLAP
1 1 (100.00%) OLTP
1 1 (100.00%) SQL Server
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) SQL Server 2012
1 1 (100.00%) SQL Server Analysis Services
1 1 (100.00%) SQL Server Integration Services
1 1 (100.00%) SQL Server Reporting Services
Job Titles
1 1 (100.00%) Business Developer
1 1 (100.00%) Business Intelligence Developer
1 1 (100.00%) Developer
1 1 (100.00%) SQL BI Developer
1 1 (100.00%) SQL Developer
1 1 (100.00%) SQL Server BI Developer
1 1 (100.00%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 1 (100.00%) .NET
1 1 (100.00%) MDX
Processes & Methodologies
1 1 (100.00%) Business Intelligence
1 1 (100.00%) Data Architecture
1 1 (100.00%) Data Integration
1 1 (100.00%) Dimensional Modelling
1 1 (100.00%) ETL
1 1 (100.00%) Inmon Methodology
1 1 (100.00%) Kimball Methodology
1 1 (100.00%) Migration
1 1 (100.00%) Performance Tuning
1 1 (100.00%) UML
Programming Languages
1 1 (100.00%) C#
1 1 (100.00%) SQL
1 1 (100.00%) T-SQL
1 1 (100.00%) VB.NET
Qualifications
1 1 (100.00%) MCSE
1 1 (100.00%) Microsoft Certification
Quality Assurance & Compliance
1 1 (100.00%) Data Quality
Vendors
1 1 (100.00%) Microsoft