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

3 months to
25 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 126 156 153
Rank change year-on-year
+30 -3
Permanent jobs citing OLAP 13 3 3
As % of all permanent IT jobs located in Hertfordshire 0.65% 0.12% 0.12%
As % of the Database & Business Intelligence category 2.45% 0.37% 0.39%
Number of salaries quoted 13 2 3
Median salary £53,000 £47,250 £45,000
Median salary % change year-on-year
+12.16% +5.00%
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
531 819 770
As % of all permanent IT jobs located in Hertfordshire 26.42% 33.43% 30.81%
Number of salaries quoted 463 678 674
Median salary £50,000 £45,000 £45,000
Median salary % change year-on-year
+11.11% -
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 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 25 July 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 25 July 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 +21 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 25 July 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 21 (100.00%) Business Intelligence
2 18 (85.71%) SQL Server Reporting Services
3 17 (80.95%) OLAP Cube
4 16 (76.19%) Data Warehouse
4 16 (76.19%) Hadoop
5 14 (66.67%) SQL
6 13 (61.90%) Oracle
6 13 (61.90%) SQL Server
6 13 (61.90%) Tableau
6 13 (61.90%) Analytics
6 13 (61.90%) Oracle OLAP
7 12 (57.14%) Data Migration
7 12 (57.14%) Netezza
7 12 (57.14%) Data Analytics
7 12 (57.14%) Teradata
7 12 (57.14%) SAS
7 12 (57.14%) Migration
7 12 (57.14%) Enterprise Data Warehouse
8 10 (47.62%) Data Modelling
9 9 (42.86%) ETL
9 9 (42.86%) SQL Server Integration Services
9 9 (42.86%) QlikView
10 8 (38.10%) Analytical Skills
11 7 (33.33%) T-SQL
11 7 (33.33%) SQL Server Analysis Services
12 6 (28.57%) MDX
12 6 (28.57%) Data Governance
12 6 (28.57%) Translating Business Requirements
13 5 (23.81%) SDLC
13 5 (23.81%) SQL Server 2012

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 (57.14%) SAS
Applications
1 1 (4.76%) MS Excel
Business Applications
1 1 (4.76%) JDE OneWorld
Cloud Services
1 1 (4.76%) SaaS
Database & Business Intelligence
1 18 (85.71%) SQL Server Reporting Services
2 17 (80.95%) OLAP Cube
3 16 (76.19%) Data Warehouse
3 16 (76.19%) Hadoop
4 13 (61.90%) Oracle OLAP
4 13 (61.90%) SQL Server
5 12 (57.14%) Enterprise Data Warehouse
6 9 (42.86%) QlikView
6 9 (42.86%) SQL Server Integration Services
7 7 (33.33%) SQL Server Analysis Services
8 5 (23.81%) SQL Server 2005
8 5 (23.81%) SQL Server 2008
8 5 (23.81%) SQL Server 2012
9 4 (19.05%) Big Data
9 4 (19.05%) PerformancePoint
9 4 (19.05%) Power BI
9 4 (19.05%) PowerPivot
10 3 (14.29%) BusinessObjects
11 2 (9.52%) SQL Server 2014
12 1 (4.76%) SQL Server 2016
Development Applications
1 1 (4.76%) SQL Server Management Studio (SSMS)
General
1 3 (14.29%) Retail
Job Titles
1 12 (57.14%) Architect
1 12 (57.14%) Data Architect
2 8 (38.10%) Developer
3 4 (19.05%) Business Intelligence Developer
4 2 (9.52%) Business Developer
4 2 (9.52%) Data Warehouse Architect
4 2 (9.52%) Enterprise Data Architect
4 2 (9.52%) ETL Developer
4 2 (9.52%) SQL Developer
4 2 (9.52%) SSAS Developer
4 2 (9.52%) SSRS Developer
5 1 (4.76%) DBA
5 1 (4.76%) IT Manager
5 1 (4.76%) Senior Developer
5 1 (4.76%) Senior SQL Developer
5 1 (4.76%) SQL DBA
5 1 (4.76%) Systems Manager
Libraries, Frameworks & Software Standards
1 6 (28.57%) MDX
2 1 (4.76%) .NET
Miscellaneous
1 8 (38.10%) Analytical Skills
2 1 (4.76%) Computer Science
2 1 (4.76%) Data Structures
2 1 (4.76%) Mathematics
2 1 (4.76%) Physics
2 1 (4.76%) Replication
Processes & Methodologies
1 21 (100.00%) Business Intelligence
2 13 (61.90%) Analytics
3 12 (57.14%) Data Analytics
3 12 (57.14%) Data Migration
3 12 (57.14%) Migration
4 10 (47.62%) Data Modelling
5 9 (42.86%) ETL
6 6 (28.57%) Data Governance
6 6 (28.57%) Translating Business Requirements
7 5 (23.81%) Dimensional Modelling
7 5 (23.81%) SDLC
8 4 (19.05%) Agile Software Development
8 4 (19.05%) Kimball Methodology
9 2 (9.52%) ETL Development
10 1 (4.76%) Data Transformation
10 1 (4.76%) Database Tuning
10 1 (4.76%) ERP
10 1 (4.76%) Mentoring
10 1 (4.76%) Performance Tuning
10 1 (4.76%) Software Engineering
Programming Languages
1 14 (66.67%) SQL
2 7 (33.33%) T-SQL
3 1 (4.76%) R
Qualifications
1 2 (9.52%) Degree
2 1 (4.76%) Oracle Certification
Vendors
1 13 (61.90%) Oracle
1 13 (61.90%) Tableau
2 12 (57.14%) Netezza
2 12 (57.14%) Teradata
3 5 (23.81%) Microsoft
4 3 (14.29%) MicroStrategy
5 1 (4.76%) JD Edwards