Period
to 22 November 2017

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 6 months to 22 November 2017 with a comparison to the same period in the previous 2 years.

Relational OLAP (ROLAP)
UK
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 1178 1224 1295
Rank change year-on-year +46 +71 -4
Permanent jobs citing ROLAP 4 1 14
As % of all permanent IT jobs advertised in the UK 0.002% 0.001% 0.006%
As % of the Database & Business Intelligence category 0.007% 0.002% 0.021%
Number of salaries quoted 2 1 11
UK median annual salary £50,000 £45,000 £47,500
Median salary % change year-on-year +11.11% -5.26% -20.83%
10th Percentile £43,000 £42,500 £40,000
90th Percentile £61,000 £47,500 £57,300
UK excluding London median annual salary - - £41,250

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 54610 56430 67973
As % of all permanent IT jobs advertised in the UK 30.24% 29.67% 31.50%
Number of salaries quoted 44953 48258 57223
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

ROLAP
Job Vacancy Trend

Job postings citing ROLAP as a percentage of all IT jobs advertised.

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 2 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 6 months to 22 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +21 4 £50,000 +11.11%
London 0 4 £50,000 +11.11%

For the 6 months to 22 November 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 4 (100.00%) Business Intelligence
1 4 (100.00%) MOLAP
2 2 (50.00%) Microsoft
2 2 (50.00%) Agile Software Development
2 2 (50.00%) SQL Server Reporting Services
2 2 (50.00%) SQL Server Integration Services
2 2 (50.00%) SQL Server Analysis Services
2 2 (50.00%) Visualisation
2 2 (50.00%) Tableau
2 2 (50.00%) Data Quality
2 2 (50.00%) Statistical Modelling
2 2 (50.00%) SQL Server 2012
2 2 (50.00%) Mentoring
2 2 (50.00%) Analytical Skills
2 2 (50.00%) SDLC
2 2 (50.00%) Budgeting and Forecasting
2 2 (50.00%) Planning and Forecasting
2 2 (50.00%) Business Forecasting
2 2 (50.00%) SQL
2 2 (50.00%) T-SQL
2 2 (50.00%) SQL Server
2 2 (50.00%) OLAP
2 2 (50.00%) Data Warehouse
2 2 (50.00%) Data Mining
2 2 (50.00%) ETL

ROLAP
Co-occurring 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:

Database & Business Intelligence
1 4 (100.00%) MOLAP
2 2 (50.00%) Data Mining
2 2 (50.00%) Data Warehouse
2 2 (50.00%) OLAP
2 2 (50.00%) SQL Server
2 2 (50.00%) SQL Server 2012
2 2 (50.00%) SQL Server Analysis Services
2 2 (50.00%) SQL Server Integration Services
2 2 (50.00%) SQL Server Reporting Services
Job Titles
1 2 (50.00%) Business Consultant
1 2 (50.00%) Business Intelligence Consultant
1 2 (50.00%) Consultant
1 2 (50.00%) Data Warehouse Developer
1 2 (50.00%) Developer
2 1 (25.00%) ETL Developer
Miscellaneous
1 2 (50.00%) Analytical Skills
Processes & Methodologies
1 4 (100.00%) Business Intelligence
2 2 (50.00%) Agile Software Development
2 2 (50.00%) Budgeting and Forecasting
2 2 (50.00%) Business Forecasting
2 2 (50.00%) ETL
2 2 (50.00%) Mentoring
2 2 (50.00%) Planning and Forecasting
2 2 (50.00%) SDLC
2 2 (50.00%) Statistical Modelling
2 2 (50.00%) Visualisation
Programming Languages
1 2 (50.00%) SQL
1 2 (50.00%) T-SQL
Quality Assurance & Compliance
1 2 (50.00%) Data Quality
Vendors
1 2 (50.00%) Microsoft
1 2 (50.00%) Tableau