The table below looks at the statistics for OLAP skills in IT jobs advertised for the Hertfordshire region. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 13 February 2016 with a comparison to the same period in the previous 2 years.

Location
3 months to
13 Feb 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 136 138 132
Rank change year-on-year
+2 -6
Permanent jobs citing OLAP 9 8 3
As % of all permanent IT jobs located in Hertfordshire 0.41% 0.40% 0.15%
As % of the Database & Business Intelligence category 1.37% 1.06% 0.47%
Number of salaries quoted 9 5 2
Average salary £57,500 £47,500 £32,250
Average salary % change year-on-year
+21.05% +47.28%
90% offered a salary of more than £50,000 £47,500 £32,050
10% offered a salary of more than £60,000 £47,500 £32,450
UK excluding London average salary £43,000 £40,000 £40,000
% change year-on-year
+7.50% -
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
655 752 633
As % of all permanent IT jobs located in Hertfordshire 30.10% 37.79% 30.94%
Number of salaries quoted 563 554 487
Average salary £47,500 £47,500 £40,000
Average salary % change year-on-year
- +18.75%
90% offered a salary of more than £35,000 £30,000 £30,000
10% offered a salary of more than £65,000 £53,000 £65,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in Hertfordshire

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the Hertfordshire region as a proportion of the total demand within 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
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the Hertfordshire region over the 3 months to 13 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Royston - 2 £50,000 -
Watford +9 1 £57,400 -
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 13 February 2016, IT jobs across the Hertfordshire region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 17 (80.95%) Business Intelligence
2 15 (71.43%) ETL
2 15 (71.43%) Data Warehouse
3 13 (61.90%) SQL
4 12 (57.14%) SQL Server Reporting Services
4 12 (57.14%) SQL Server Integration Services
5 9 (42.86%) MDX
5 9 (42.86%) Retail
6 8 (38.10%) Enterprise Architecture
6 8 (38.10%) SQL Server Analysis Services
7 7 (33.33%) Data Architecture
7 7 (33.33%) SQL Server
7 7 (33.33%) Data Modelling
8 6 (28.57%) Oracle
8 6 (28.57%) Oracle OLAP
9 5 (23.81%) Analytics
9 5 (23.81%) Analytical Skills
9 5 (23.81%) Star Schema
10 4 (19.05%) E-Commerce
10 4 (19.05%) Technical Architecture
11 3 (14.29%) Degree
11 3 (14.29%) SQL Server 2008
11 3 (14.29%) Master Data Management
11 3 (14.29%) Metadata Management
11 3 (14.29%) Information Architecture
11 3 (14.29%) Logical Data Model
11 3 (14.29%) Enterprise Data Warehouse
11 3 (14.29%) Data Governance
11 3 (14.29%) Data Management
11 3 (14.29%) TOGAF

OLAP
Top Related IT Skills in Hertfordshire by Category

For the 6 months to 13 February 2016, IT jobs across the Hertfordshire region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 1 (4.76%) BizTalk Server
1 1 (4.76%) Oracle Workflow
1 1 (4.76%) SharePoint
Applications
1 2 (9.52%) MS Excel
Business Applications
1 1 (4.76%) JDE OneWorld
Cloud Services
1 2 (9.52%) Microsoft Azure
Communications & Networking
1 1 (4.76%) Firewall
Database & Business Intelligence
1 15 (71.43%) Data Warehouse
2 12 (57.14%) SQL Server Integration Services
2 12 (57.14%) SQL Server Reporting Services
3 8 (38.10%) SQL Server Analysis Services
4 7 (33.33%) SQL Server
5 6 (28.57%) Oracle OLAP
6 5 (23.81%) Star Schema
7 3 (14.29%) Enterprise Data Warehouse
7 3 (14.29%) OLTP
7 3 (14.29%) SQL Server 2008
8 2 (9.52%) Azure SQL Database
8 2 (9.52%) OLAP Cube
8 2 (9.52%) SQL Server 2012
9 1 (4.76%) DataStage
9 1 (4.76%) Hadoop
9 1 (4.76%) Oracle Database
9 1 (4.76%) Oracle Database 11g
9 1 (4.76%) SQL Server 2000
9 1 (4.76%) SQL Server 2014
9 1 (4.76%) SQL Server 2016
Development Applications
1 3 (14.29%) ERwin
1 3 (14.29%) Toad
General
1 9 (42.86%) Retail
2 1 (4.76%) Advertising
2 1 (4.76%) Banking
2 1 (4.76%) Finance
2 1 (4.76%) Legal
Job Titles
1 9 (42.86%) Developer
1 9 (42.86%) Technical Leader
2 8 (38.10%) SQL Developer
3 4 (19.05%) Architect
3 4 (19.05%) Data Modeller
3 4 (19.05%) Lead Developer
3 4 (19.05%) Technical Developer
4 3 (14.29%) Business Intelligence Developer
4 3 (14.29%) Data Architect
4 3 (14.29%) SQL BI Developer
5 2 (9.52%) DBA
5 2 (9.52%) IT Manager
5 2 (9.52%) Senior Business Intelligence Developer
5 2 (9.52%) Senior Developer
5 2 (9.52%) Senior SQL Developer
5 2 (9.52%) SQL DBA
5 2 (9.52%) Systems Manager
6 1 (4.76%) Administrator
6 1 (4.76%) Applications Architect
6 1 (4.76%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 9 (42.86%) MDX
2 3 (14.29%) Middleware
3 1 (4.76%) COM
3 1 (4.76%) SAP PI
Miscellaneous
1 5 (23.81%) Analytical Skills
2 1 (4.76%) Data Centre
2 1 (4.76%) Data Integration
2 1 (4.76%) iPad
2 1 (4.76%) Management Information System
2 1 (4.76%) PKI
2 1 (4.76%) Replication
2 1 (4.76%) User Experience
Operating Systems
1 1 (4.76%) Android
1 1 (4.76%) Windows
Processes & Methodologies
1 17 (80.95%) Business Intelligence
2 15 (71.43%) ETL
3 8 (38.10%) Enterprise Architecture
4 7 (33.33%) Data Architecture
4 7 (33.33%) Data Modelling
5 5 (23.81%) Analytics
6 4 (19.05%) E-Commerce
6 4 (19.05%) Technical Architecture
7 3 (14.29%) Data Governance
7 3 (14.29%) Data Management
7 3 (14.29%) Information Architecture
7 3 (14.29%) Logical Data Model
7 3 (14.29%) Master Data Management
7 3 (14.29%) Metadata Management
7 3 (14.29%) SOA
7 3 (14.29%) TOGAF
8 2 (9.52%) ERP
8 2 (9.52%) Kimball Methodology
8 2 (9.52%) Mentoring
8 2 (9.52%) Performance Monitoring
Programming Languages
1 13 (61.90%) SQL
2 3 (14.29%) T-SQL
3 2 (9.52%) R
4 1 (4.76%) Data Analysis Expressions (DAX)
Qualifications
1 3 (14.29%) Degree
2 2 (9.52%) Oracle Certification
System Software
1 1 (4.76%) Active Directory
1 1 (4.76%) Hyper-V
1 1 (4.76%) VMware Infrastructure
Systems Management
1 1 (4.76%) SCCM
1 1 (4.76%) SCOM
1 1 (4.76%) SCVMM
Vendors
1 6 (28.57%) Oracle
2 2 (9.52%) IBM
2 2 (9.52%) JD Edwards
2 2 (9.52%) Microsoft
3 1 (4.76%) F5
3 1 (4.76%) Nintex
3 1 (4.76%) SAP
3 1 (4.76%) VMware
Hertfordshire
Computer Futures
Salary: £50000 - £65000 per annum + competitive
Posted: 3 days ago