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 23 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
23 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
East of England / Hertfordshire
Rank 120 124 128
Rank change year-on-year
+4 +4
Permanent jobs citing OLAP 7 14 15
As % of all permanent IT jobs located in Hertfordshire 0.34% 0.69% 0.73%
As % of the Database & Business Intelligence category 1.20% 2.13% 2.03%
Number of salaries quoted 7 13 10
Median salary £45,000 £57,500 £47,500
Median salary % change year-on-year
-21.73% +21.05%
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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
583 657 738
As % of all permanent IT jobs located in Hertfordshire 28.63% 32.25% 35.86%
Number of salaries quoted 475 566 548
Median salary £50,000 £47,500 £47,500
Median salary % change year-on-year
+5.26% -
90% offered a salary of more than £31,800 £32,500 £30,000
10% offered a salary of more than £65,000 £65,000 £65,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 23 January 2017.

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 23 January 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
Borehamwood - 2 £45,000 -
Stevenage - 2 £30,000 -
Hemel Hempstead - 1 £67,500 -
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 23 January 2017, 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 (100.00%) SQL Server
2 14 (87.50%) SQL
3 11 (68.75%) Microsoft
4 10 (62.50%) Business Intelligence
4 10 (62.50%) SQL Server 2005
4 10 (62.50%) SQL Server Integration Services
4 10 (62.50%) SQL Server Analysis Services
5 9 (56.25%) SQL Server Reporting Services
6 8 (50.00%) OLTP
6 8 (50.00%) Data Warehouse
6 8 (50.00%) ETL
7 7 (43.75%) SQL Server 2008
7 7 (43.75%) T-SQL
8 6 (37.50%) RDBMS
8 6 (37.50%) Microsoft Certification
8 6 (37.50%) Computacenter
8 6 (37.50%) Microsoft Analysis Services
8 6 (37.50%) Relational Database
8 6 (37.50%) Server Building
8 6 (37.50%) SC Cleared
8 6 (37.50%) Security Cleared
8 6 (37.50%) MCITP
8 6 (37.50%) MDX
9 5 (31.25%) Kimball Methodology
9 5 (31.25%) Analytics
9 5 (31.25%) OLAP Cube
9 5 (31.25%) SQL Server 2014
9 5 (31.25%) SQL Server 2016
10 4 (25.00%) Performance Optimisation
10 4 (25.00%) 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 1 (6.25%) SharePoint
Applications
1 2 (12.50%) MS Excel
2 1 (6.25%) MS Visio
Cloud Services
1 4 (25.00%) SaaS
Database & Business Intelligence
1 16 (100.00%) SQL Server
2 10 (62.50%) SQL Server 2005
2 10 (62.50%) SQL Server Analysis Services
2 10 (62.50%) SQL Server Integration Services
3 9 (56.25%) SQL Server Reporting Services
4 8 (50.00%) Data Warehouse
4 8 (50.00%) OLTP
5 7 (43.75%) SQL Server 2008
6 6 (37.50%) Microsoft Analysis Services
6 6 (37.50%) RDBMS
6 6 (37.50%) Relational Database
7 5 (31.25%) OLAP Cube
7 5 (31.25%) SQL Server 2014
7 5 (31.25%) SQL Server 2016
8 4 (25.00%) DTS
8 4 (25.00%) SQL Server 2012
9 1 (6.25%) Power BI
9 1 (6.25%) PowerPivot
9 1 (6.25%) QlikView
Development Applications
1 4 (25.00%) SQL Server Management Studio (SSMS)
General
1 4 (25.00%) Advertising
1 4 (25.00%) Billing
2 1 (6.25%) Pharmaceutical
Job Titles
1 9 (56.25%) Developer
2 8 (50.00%) SQL Developer
3 6 (37.50%) DBA
3 6 (37.50%) SQL DBA
3 6 (37.50%) SQL Server DBA
4 3 (18.75%) Business Intelligence Developer
5 2 (12.50%) Analyst
5 2 (12.50%) Analyst Developer
5 2 (12.50%) Business Intelligence Analyst
5 2 (12.50%) SQL BI Developer
6 1 (6.25%) Business Intelligence Manager
6 1 (6.25%) Developer Analyst
6 1 (6.25%) Report Developer
6 1 (6.25%) Senior Analyst Developer
6 1 (6.25%) Senior Business Intelligence Analyst
6 1 (6.25%) SQL Analyst
6 1 (6.25%) SSAS Developer
6 1 (6.25%) SSIS Developer
6 1 (6.25%) SSRS Developer
6 1 (6.25%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 6 (37.50%) MDX
2 4 (25.00%) .NET
Miscellaneous
1 4 (25.00%) Analytical Skills
1 4 (25.00%) Computer Science
1 4 (25.00%) Management Information System
1 4 (25.00%) Mathematics
1 4 (25.00%) Physics
2 1 (6.25%) Data Integration
Processes & Methodologies
1 10 (62.50%) Business Intelligence
2 8 (50.00%) ETL
3 6 (37.50%) Server Building
4 5 (31.25%) Analytics
4 5 (31.25%) Kimball Methodology
5 4 (25.00%) Data Transformation
5 4 (25.00%) Dimensional Modelling
5 4 (25.00%) Performance Optimisation
5 4 (25.00%) SDLC
5 4 (25.00%) Software Engineering
6 2 (12.50%) Data Cleansing
6 2 (12.50%) Data Migration
6 2 (12.50%) Mentoring
6 2 (12.50%) Migration
7 1 (6.25%) Business Transformation
7 1 (6.25%) Coaching
7 1 (6.25%) Data Modelling
7 1 (6.25%) Inmon Methodology
Programming Languages
1 14 (87.50%) SQL
2 7 (43.75%) T-SQL
3 4 (25.00%) R
Qualifications
1 6 (37.50%) MCITP
1 6 (37.50%) Microsoft Certification
1 6 (37.50%) SC Cleared
1 6 (37.50%) Security Cleared
2 4 (25.00%) Degree
Vendors
1 11 (68.75%) Microsoft
2 6 (37.50%) Computacenter