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 30 June 2016 with a comparison to the same period over the previous 2 years.

3 months to
30 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 118 154 156
Rank change year-on-year
+36 +2
Permanent jobs citing OLAP 19 1 3
As % of all permanent IT jobs located in Hertfordshire 0.94% 0.041% 0.11%
As % of the Database & Business Intelligence category 3.82% 0.13% 0.38%
Number of salaries quoted 19 1 3
Median salary £65,000 £45,000 £45,000
Median salary % change year-on-year
+44.44% -
UK excluding London median salary £47,500 £40,000 £42,500
% change year-on-year
+18.75% -5.88%
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
497 787 788
As % of all permanent IT jobs located in Hertfordshire 24.47% 32.48% 29.88%
Number of salaries quoted 438 648 695
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £30,000 £32,500
10% offered a salary of more than £65,000 £65,000 £62,500
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 30 June 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 30 June 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
St Albans - 4 £53,000 -
Broxbourne - 3 £60,000 -
Watford +22 2 £47,500 +5.55%
Borehamwood - 1 £37,500 -
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 30 June 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 25 (100.00%) Business Intelligence
2 22 (88.00%) SQL Server Reporting Services
3 20 (80.00%) Data Warehouse
4 17 (68.00%) OLAP Cube
5 16 (64.00%) Hadoop
6 15 (60.00%) SQL
7 14 (56.00%) SQL Server
7 14 (56.00%) Analytics
8 13 (52.00%) Oracle
8 13 (52.00%) ETL
8 13 (52.00%) Tableau
8 13 (52.00%) SQL Server Integration Services
8 13 (52.00%) Oracle OLAP
9 12 (48.00%) Netezza
9 12 (48.00%) Data Analytics
9 12 (48.00%) Data Migration
9 12 (48.00%) SAS
9 12 (48.00%) Migration
9 12 (48.00%) Teradata
9 12 (48.00%) Enterprise Data Warehouse
10 11 (44.00%) SQL Server Analysis Services
11 10 (40.00%) MDX
11 10 (40.00%) Data Modelling
12 9 (36.00%) QlikView
13 8 (32.00%) Analytical Skills
14 7 (28.00%) T-SQL
15 6 (24.00%) Microsoft
15 6 (24.00%) Data Governance
15 6 (24.00%) Translating Business Requirements
16 5 (20.00%) SDLC

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 12 (48.00%) SAS
Applications
1 1 (4.00%) MS Excel
Business Applications
1 1 (4.00%) JDE OneWorld
Cloud Services
1 1 (4.00%) SaaS
Database & Business Intelligence
1 22 (88.00%) SQL Server Reporting Services
2 20 (80.00%) Data Warehouse
3 17 (68.00%) OLAP Cube
4 16 (64.00%) Hadoop
5 14 (56.00%) SQL Server
6 13 (52.00%) Oracle OLAP
6 13 (52.00%) SQL Server Integration Services
7 12 (48.00%) Enterprise Data Warehouse
8 11 (44.00%) SQL Server Analysis Services
9 9 (36.00%) QlikView
10 5 (20.00%) SQL Server 2005
10 5 (20.00%) SQL Server 2008
10 5 (20.00%) SQL Server 2012
11 4 (16.00%) Big Data
11 4 (16.00%) PerformancePoint
11 4 (16.00%) Power BI
11 4 (16.00%) PowerPivot
12 3 (12.00%) BusinessObjects
12 3 (12.00%) Star Schema
13 2 (8.00%) SQL Server 2014
Development Applications
1 1 (4.00%) SQL Server Management Studio (SSMS)
General
1 3 (12.00%) Retail
2 1 (4.00%) Advertising
Job Titles
1 12 (48.00%) Architect
1 12 (48.00%) Data Architect
2 9 (36.00%) Developer
3 5 (20.00%) Business Intelligence Developer
4 3 (12.00%) Business Intelligence Lead
4 3 (12.00%) SQL Developer
4 3 (12.00%) SSAS Developer
4 3 (12.00%) SSRS Developer
4 3 (12.00%) Technical Leader
5 2 (8.00%) Business Developer
5 2 (8.00%) Data Warehouse Architect
5 2 (8.00%) Enterprise Data Architect
5 2 (8.00%) ETL Developer
6 1 (4.00%) DBA
6 1 (4.00%) IT Manager
6 1 (4.00%) Senior Developer
6 1 (4.00%) Senior SQL Developer
6 1 (4.00%) SQL DBA
6 1 (4.00%) SSIS Developer
6 1 (4.00%) Systems Manager
Libraries, Frameworks & Software Standards
1 10 (40.00%) MDX
2 1 (4.00%) .NET
2 1 (4.00%) COM
Miscellaneous
1 8 (32.00%) Analytical Skills
2 1 (4.00%) Computer Science
2 1 (4.00%) Data Integration
2 1 (4.00%) Data Structures
2 1 (4.00%) Mathematics
2 1 (4.00%) Physics
2 1 (4.00%) Replication
Processes & Methodologies
1 25 (100.00%) Business Intelligence
2 14 (56.00%) Analytics
3 13 (52.00%) ETL
4 12 (48.00%) Data Analytics
4 12 (48.00%) Data Migration
4 12 (48.00%) Migration
5 10 (40.00%) Data Modelling
6 6 (24.00%) Data Governance
6 6 (24.00%) Translating Business Requirements
7 5 (20.00%) Dimensional Modelling
7 5 (20.00%) Kimball Methodology
7 5 (20.00%) SDLC
8 4 (16.00%) Agile Software Development
9 2 (8.00%) ETL Development
10 1 (4.00%) Data Acquisition
10 1 (4.00%) Data Transformation
10 1 (4.00%) ERP
10 1 (4.00%) Mentoring
10 1 (4.00%) Performance Optimisation
10 1 (4.00%) Software Engineering
Programming Languages
1 15 (60.00%) SQL
2 7 (28.00%) T-SQL
3 1 (4.00%) R
Qualifications
1 2 (8.00%) Degree
2 1 (4.00%) Oracle Certification
Vendors
1 13 (52.00%) Oracle
1 13 (52.00%) Tableau
2 12 (48.00%) Netezza
2 12 (48.00%) Teradata
3 6 (24.00%) Microsoft
4 3 (12.00%) MicroStrategy
5 1 (4.00%) JD Edwards