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

3 months to
4 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 130 133 127
Rank change year-on-year
+3 -6
Permanent jobs citing OLAP 9 16 26
As % of all permanent IT jobs located in Hertfordshire 0.42% 0.73% 1.06%
As % of the Database & Business Intelligence category 1.55% 2.40% 3.35%
Number of salaries quoted 6 13 20
Median salary £45,000 £57,400 £42,500
Median salary % change year-on-year
-21.60% +35.05%
90% offered a salary of more than £37,500 £46,000 £39,750
10% offered a salary of more than £61,250 £60,000 £47,500
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +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
579 668 775
As % of all permanent IT jobs located in Hertfordshire 27.03% 30.38% 31.62%
Number of salaries quoted 475 581 622
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 £33,000 £27,150 £28,500
10% offered a salary of more than £65,000 £65,000 £65,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 4 December 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 4 December 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
Borehamwood - 3 £45,000 -
Hemel Hempstead +4 1 £67,500 +53.40%
Stevenage - 1 £30,000 - 1
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 4 December 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 14 (100.00%) SQL Server
2 11 (78.57%) SQL
3 9 (64.29%) Microsoft
3 9 (64.29%) SQL Server 2005
4 8 (57.14%) Business Intelligence
5 7 (50.00%) OLTP
5 7 (50.00%) Data Warehouse
5 7 (50.00%) SQL Server Analysis Services
5 7 (50.00%) SQL Server Integration Services
5 7 (50.00%) SQL Server 2008
6 6 (42.86%) SC Cleared
6 6 (42.86%) Security Cleared
6 6 (42.86%) MCITP
6 6 (42.86%) SQL Server Reporting Services
6 6 (42.86%) RDBMS
6 6 (42.86%) ETL
6 6 (42.86%) Microsoft Certification
6 6 (42.86%) Computacenter
6 6 (42.86%) Relational Database
6 6 (42.86%) Server Building
7 5 (35.71%) OLAP Cube
7 5 (35.71%) T-SQL
7 5 (35.71%) MDX
7 5 (35.71%) Analytics
8 4 (28.57%) Microsoft Analysis Services
8 4 (28.57%) SQL Server 2014
8 4 (28.57%) SQL Server 2016
9 3 (21.43%) SDLC
9 3 (21.43%) Analytical Skills
9 3 (21.43%) SQL Server Management Studio (SSMS)

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 (7.14%) SAS
Applications
1 1 (7.14%) MS Excel
Cloud Services
1 3 (21.43%) SaaS
Database & Business Intelligence
1 14 (100.00%) SQL Server
2 9 (64.29%) SQL Server 2005
3 7 (50.00%) Data Warehouse
3 7 (50.00%) OLTP
3 7 (50.00%) SQL Server 2008
3 7 (50.00%) SQL Server Analysis Services
3 7 (50.00%) SQL Server Integration Services
4 6 (42.86%) RDBMS
4 6 (42.86%) Relational Database
4 6 (42.86%) SQL Server Reporting Services
5 5 (35.71%) OLAP Cube
6 4 (28.57%) Microsoft Analysis Services
6 4 (28.57%) SQL Server 2014
6 4 (28.57%) SQL Server 2016
7 3 (21.43%) DTS
7 3 (21.43%) SQL Server 2012
8 1 (7.14%) Hadoop
8 1 (7.14%) Oracle OLAP
8 1 (7.14%) PowerPivot
8 1 (7.14%) QlikView
Development Applications
1 3 (21.43%) SQL Server Management Studio (SSMS)
General
1 3 (21.43%) Advertising
1 3 (21.43%) Billing
2 1 (7.14%) Pharmaceutical
Job Titles
1 6 (42.86%) DBA
1 6 (42.86%) Developer
1 6 (42.86%) SQL DBA
1 6 (42.86%) SQL Server DBA
2 5 (35.71%) SQL Developer
3 2 (14.29%) Business Intelligence Developer
4 1 (7.14%) Analyst
4 1 (7.14%) Analyst Developer
4 1 (7.14%) Business Intelligence Analyst
4 1 (7.14%) Business Intelligence Manager
4 1 (7.14%) Senior Analyst
4 1 (7.14%) Senior Analyst Developer
4 1 (7.14%) Senior Business Intelligence Analyst
4 1 (7.14%) Senior Business Intelligence Developer
4 1 (7.14%) Senior Developer
4 1 (7.14%) SQL BI Developer
4 1 (7.14%) SSAS Developer
4 1 (7.14%) SSIS Developer
4 1 (7.14%) SSRS Developer
4 1 (7.14%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 5 (35.71%) MDX
2 3 (21.43%) .NET
Miscellaneous
1 3 (21.43%) Analytical Skills
1 3 (21.43%) Computer Science
1 3 (21.43%) Management Information System
1 3 (21.43%) Mathematics
1 3 (21.43%) Physics
2 1 (7.14%) Data Integration
Processes & Methodologies
1 8 (57.14%) Business Intelligence
2 6 (42.86%) ETL
2 6 (42.86%) Server Building
3 5 (35.71%) Analytics
4 3 (21.43%) Data Transformation
4 3 (21.43%) Dimensional Modelling
4 3 (21.43%) Kimball Methodology
4 3 (21.43%) Performance Optimisation
4 3 (21.43%) SDLC
4 3 (21.43%) Software Engineering
5 2 (14.29%) Data Migration
5 2 (14.29%) Mentoring
5 2 (14.29%) Migration
6 1 (7.14%) Coaching
6 1 (7.14%) Data Analytics
6 1 (7.14%) Data Cleansing
6 1 (7.14%) Data Governance
6 1 (7.14%) Data Modelling
6 1 (7.14%) Inmon Methodology
Programming Languages
1 11 (78.57%) SQL
2 5 (35.71%) T-SQL
3 3 (21.43%) R
Qualifications
1 6 (42.86%) MCITP
1 6 (42.86%) Microsoft Certification
1 6 (42.86%) SC Cleared
1 6 (42.86%) Security Cleared
2 3 (21.43%) Degree
Vendors
1 9 (64.29%) Microsoft
2 6 (42.86%) Computacenter
3 1 (7.14%) Netezza
3 1 (7.14%) Oracle
3 1 (7.14%) Teradata
Stevenage, Hertfordshire
Nigel Frank International Ltd
Salary: £25000 - £32000 per annum + Benefits
Posted: 2 days ago