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

3 months to
24 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
East of England / Hertfordshire
Rank 133 141 139
Rank change year-on-year
+8 -2
Permanent jobs citing OLAP 5 6 6
As % of all permanent IT jobs located in Hertfordshire 0.24% 0.27% 0.29%
As % of the Database & Business Intelligence category 0.84% 0.91% 0.77%
Number of salaries quoted 5 6 4
Median salary £45,000 £58,750 £47,500
Median salary % change year-on-year
-23.40% +23.68%
UK excluding London median salary £45,000 £45,500 £40,000
% change year-on-year
-1.09% +13.75%

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
594 660 784
As % of all permanent IT jobs located in Hertfordshire 28.85% 29.15% 38.23%
Number of salaries quoted 496 552 587
Median salary £47,500 £47,500 £47,500
90% offered a salary of more than £33,500 £35,000 £28,500
10% offered a salary of more than £65,000 £65,000 £65,000
UK excluding London median salary £42,500 £42,500 £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 24 February 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 24 February 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
Stevenage - 2 £30,000 -
Borehamwood - 1 £45,000 -
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 24 February 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%) Business Intelligence
3 11 (68.75%) Microsoft
3 11 (68.75%) SQL Server Integration Services
3 11 (68.75%) SQL Server Analysis Services
4 10 (62.50%) SQL Server Reporting Services
5 9 (56.25%) ETL
5 9 (56.25%) Data Warehouse
5 9 (56.25%) SQL Server 2005
6 8 (50.00%) T-SQL
7 7 (43.75%) OLTP
7 7 (43.75%) Microsoft Analysis Services
8 6 (37.50%) MDX
8 6 (37.50%) SQL Server 2008
8 6 (37.50%) Kimball Methodology
9 5 (31.25%) Analytics
9 5 (31.25%) Relational Database
9 5 (31.25%) MCITP
9 5 (31.25%) SC Cleared
9 5 (31.25%) Security Cleared
9 5 (31.25%) RDBMS
9 5 (31.25%) Microsoft Certification
9 5 (31.25%) Computacenter
9 5 (31.25%) OLAP Cube
9 5 (31.25%) Server Building
9 5 (31.25%) SQL Server 2014
9 5 (31.25%) SQL Server 2016
10 4 (25.00%) Performance Optimisation
10 4 (25.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 2 (12.50%) SharePoint
Applications
1 2 (12.50%) MS Excel
1 2 (12.50%) MS Visio
Cloud Services
1 4 (25.00%) SaaS
Database & Business Intelligence
1 16 (100.00%) SQL Server
2 11 (68.75%) SQL Server Analysis Services
2 11 (68.75%) SQL Server Integration Services
3 10 (62.50%) SQL Server Reporting Services
4 9 (56.25%) Data Warehouse
4 9 (56.25%) SQL Server 2005
5 7 (43.75%) Microsoft Analysis Services
5 7 (43.75%) OLTP
6 6 (37.50%) SQL Server 2008
7 5 (31.25%) OLAP Cube
7 5 (31.25%) RDBMS
7 5 (31.25%) Relational Database
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 10 (62.50%) Developer
2 9 (56.25%) SQL Developer
3 5 (31.25%) DBA
3 5 (31.25%) SQL DBA
3 5 (31.25%) SQL Server DBA
4 4 (25.00%) Business Intelligence Developer
5 3 (18.75%) Analyst
5 3 (18.75%) Analyst Developer
5 3 (18.75%) Business Intelligence Analyst
5 3 (18.75%) SQL BI Developer
6 2 (12.50%) Developer Analyst
6 2 (12.50%) Report Analyst
6 2 (12.50%) Report Developer
6 2 (12.50%) SQL Analyst
6 2 (12.50%) SQL Reporting Analyst
7 1 (6.25%) Business Intelligence Manager
7 1 (6.25%) Senior Analyst
7 1 (6.25%) Senior Business Intelligence Analyst
7 1 (6.25%) Senior Business Intelligence Developer
7 1 (6.25%) Senior 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
Processes & Methodologies
1 11 (68.75%) Business Intelligence
2 9 (56.25%) ETL
3 6 (37.50%) Kimball Methodology
4 5 (31.25%) Analytics
4 5 (31.25%) Server Building
5 4 (25.00%) Data Transformation
5 4 (25.00%) Dimensional Modelling
5 4 (25.00%) Mathematics
5 4 (25.00%) Performance Optimisation
5 4 (25.00%) Physics
5 4 (25.00%) SDLC
5 4 (25.00%) Software Engineering
6 2 (12.50%) Business Transformation
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%) Coaching
7 1 (6.25%) Data Modelling
7 1 (6.25%) Inmon Methodology
Programming Languages
1 14 (87.50%) SQL
2 8 (50.00%) T-SQL
3 4 (25.00%) R
Qualifications
1 5 (31.25%) MCITP
1 5 (31.25%) Microsoft Certification
1 5 (31.25%) SC Cleared
1 5 (31.25%) Security Cleared
2 4 (25.00%) Degree
Vendors
1 11 (68.75%) Microsoft
2 5 (31.25%) Computacenter