The table below looks at the statistics for OLAP skills in IT jobs advertised for the Hertfordshire region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 2 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
2 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 133 161 148
Rank change year-on-year
+28 -13
Permanent jobs citing OLAP 8 2 6
As % of all permanent IT jobs located in Hertfordshire 0.36% 0.086% 0.24%
As % of the Database & Business Intelligence category 1.57% 0.25% 0.81%
Number of salaries quoted 8 2 1
Median salary £68,750 £48,250 £37,500
Median salary % change year-on-year
+42.48% +28.66%
UK excluding London median salary £46,000 £40,000 £41,500
% change year-on-year
+15.00% -3.61%
OLAP
East of England

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

Database & Business Intelligence Category
Hertfordshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
508 797 741
As % of all permanent IT jobs located in Hertfordshire 22.90% 34.15% 29.13%
Number of salaries quoted 421 660 643
Median salary £45,000 £47,500 £42,500
Median salary % change year-on-year
-5.26% +11.76%
90% offered a salary of more than £31,500 £30,000 £32,000
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London median salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in Hertfordshire

The demand trend of job ads across the Hertfordshire region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Hertfordshire

OLAP
Salary Trend in Hertfordshire

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

OLAP Salary Trend in Hertfordshire

OLAP
Salary Histogram in Hertfordshire

This chart provides a salary histogram for IT jobs citing OLAP across the Hertfordshire region over the 3 months to 2 May 2016.

OLAP Salary Histogram in Hertfordshire

OLAP
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Hertfordshire region over the 3 months to 2 May 2016. 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
(Click see detailed
statistics and trends)
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
Hemel Hempstead +13 1 £37,500 -14.77%
Royston - 1 £50,000 -
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 2 May 2016, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Hertfordshire region with a requirement for OLAP.

1 16 (94.12%) Business Intelligence
2 15 (88.24%) Data Warehouse
2 15 (88.24%) SQL Server Reporting Services
3 9 (52.94%) SQL
4 8 (47.06%) Oracle
4 8 (47.06%) Data Modelling
4 8 (47.06%) ETL
4 8 (47.06%) SQL Server Integration Services
4 8 (47.06%) Oracle OLAP
4 8 (47.06%) Analytics
5 6 (35.29%) Data Analytics
5 6 (35.29%) Analytical Skills
5 6 (35.29%) OLAP Cube
5 6 (35.29%) Enterprise Data Warehouse
5 6 (35.29%) QlikView
5 6 (35.29%) Data Migration
5 6 (35.29%) Netezza
5 6 (35.29%) MDX
5 6 (35.29%) Hadoop
5 6 (35.29%) Tableau
5 6 (35.29%) SAS
5 6 (35.29%) Teradata
5 6 (35.29%) Migration
6 5 (29.41%) SQL Server
6 5 (29.41%) SQL Server Analysis Services
7 4 (23.53%) Translating Business Requirements
7 4 (23.53%) Star Schema
8 3 (17.65%) Retail
9 2 (11.76%) Microsoft
9 2 (11.76%) BusinessObjects

OLAP
Top Related IT Skills in Hertfordshire 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 6 (35.29%) SAS
Applications
1 2 (11.76%) MS Excel
Business Applications
1 1 (5.88%) JDE OneWorld
Database & Business Intelligence
1 15 (88.24%) Data Warehouse
1 15 (88.24%) SQL Server Reporting Services
2 8 (47.06%) Oracle OLAP
2 8 (47.06%) SQL Server Integration Services
3 6 (35.29%) Enterprise Data Warehouse
3 6 (35.29%) Hadoop
3 6 (35.29%) OLAP Cube
3 6 (35.29%) QlikView
4 5 (29.41%) SQL Server
4 5 (29.41%) SQL Server Analysis Services
5 4 (23.53%) Star Schema
6 2 (11.76%) BusinessObjects
7 1 (5.88%) SQL Server 2008
7 1 (5.88%) SQL Server 2012
7 1 (5.88%) SQL Server 2014
General
1 3 (17.65%) Retail
2 1 (5.88%) Advertising
2 1 (5.88%) Banking
2 1 (5.88%) Finance
Job Titles
1 6 (35.29%) Architect
1 6 (35.29%) Data Architect
1 6 (35.29%) Technical Leader
2 5 (29.41%) Developer
3 4 (23.53%) Business Intelligence Lead
3 4 (23.53%) SQL Developer
4 2 (11.76%) Data Modeller
4 2 (11.76%) Data Warehouse Architect
4 2 (11.76%) Enterprise Data Architect
4 2 (11.76%) IT Manager
4 2 (11.76%) Lead Developer
4 2 (11.76%) SSRS Developer
4 2 (11.76%) Systems Manager
4 2 (11.76%) Technical Developer
5 1 (5.88%) Business Intelligence Developer
5 1 (5.88%) Report Developer
5 1 (5.88%) SQL BI Developer
5 1 (5.88%) SQL DBA
5 1 (5.88%) SSAS Developer
5 1 (5.88%) SSIS Developer
Libraries, Frameworks & Software Standards
1 6 (35.29%) MDX
2 1 (5.88%) COM
Miscellaneous
1 6 (35.29%) Analytical Skills
2 1 (5.88%) Data Integration
2 1 (5.88%) Data Structures
2 1 (5.88%) Replication
Processes & Methodologies
1 16 (94.12%) Business Intelligence
2 8 (47.06%) Analytics
2 8 (47.06%) Data Modelling
2 8 (47.06%) ETL
3 6 (35.29%) Data Analytics
3 6 (35.29%) Data Migration
3 6 (35.29%) Migration
4 4 (23.53%) Translating Business Requirements
5 2 (11.76%) Data Architecture
5 2 (11.76%) Data Governance
5 2 (11.76%) E-Commerce
5 2 (11.76%) Enterprise Architecture
5 2 (11.76%) ERP
5 2 (11.76%) Kimball Methodology
5 2 (11.76%) Mentoring
6 1 (5.88%) CRM
6 1 (5.88%) Data Acquisition
6 1 (5.88%) Database Tuning
6 1 (5.88%) Performance Tuning
Programming Languages
1 9 (52.94%) SQL
2 2 (11.76%) T-SQL
3 1 (5.88%) Data Analysis Expressions (DAX)
Qualifications
1 2 (11.76%) Degree
1 2 (11.76%) Oracle Certification
Vendors
1 8 (47.06%) Oracle
2 6 (35.29%) Netezza
2 6 (35.29%) Tableau
2 6 (35.29%) Teradata
3 2 (11.76%) JD Edwards
3 2 (11.76%) Microsoft
3 2 (11.76%) MicroStrategy