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 24 October 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
24 Oct 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 125 119 147
Rank change year-on-year
-6 +28
Permanent jobs citing OLAP 20 9 26
As % of all permanent IT jobs located in Hertfordshire 0.85% 0.46% 0.84%
As % of the Database & Business Intelligence category 2.84% 1.37% 2.51%
Number of salaries quoted 17 9 25
Average salary £42,500 £32,500 £45,000
Average salary % change year-on-year
+30.76% -27.77%
90% offered a salary of more than £40,000 £31,300 £35,000
10% offered a salary of more than £47,500 £48,000 £53,200
UK excluding London average salary £42,500 £40,000 £40,500
% change year-on-year
+6.25% -1.23%
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
704 655 1037
As % of all permanent IT jobs located in Hertfordshire 29.96% 33.13% 33.61%
Number of salaries quoted 568 536 884
Average salary £45,000 £40,000 £45,000
Average salary % change year-on-year
+12.50% -11.11%
90% offered a salary of more than £27,500 £28,500 £30,000
10% offered a salary of more than £65,000 £55,000 £55,000
UK excluding London average salary £40,000 £40,000 £40,000

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 24 October 2014. 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
Letchworth - 6 £41,250 -
Hitchin - 5 £40,000 -
Borehamwood - 1 £40,000 -
Potters Bar - 1 £47,500 - 1
OLAP
East of England

OLAP
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 24 October 2014, 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 20 (86.96%) Business Intelligence
2 18 (78.26%) SQL
3 16 (69.57%) SQL Server
4 12 (52.17%) SQL Server Reporting Services
4 12 (52.17%) SQL Server Analysis Services
5 11 (47.83%) MOLAP
5 11 (47.83%) ROLAP
5 11 (47.83%) Business Objects
5 11 (47.83%) Oracle
5 11 (47.83%) Degree
5 11 (47.83%) Oracle OLAP
6 10 (43.48%) Analytics
7 9 (39.13%) .NET
8 8 (34.78%) Microsoft
8 8 (34.78%) ETL
8 8 (34.78%) ISO 9001
9 7 (30.43%) Finance
10 6 (26.09%) Data Modelling
10 6 (26.09%) Data Mining
10 6 (26.09%) T-SQL
10 6 (26.09%) C#
10 6 (26.09%) HTML
10 6 (26.09%) JavaScript
10 6 (26.09%) PL/SQL
10 6 (26.09%) ASP.NET
10 6 (26.09%) CSS
10 6 (26.09%) Oracle Reports
10 6 (26.09%) Data Warehouse
10 6 (26.09%) SQL Server Integration Services
10 6 (26.09%) Visualisation

OLAP
Top Related IT Skills in Hertfordshire by Category

For the 6 months to 24 October 2014, 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 4 (17.39%) SharePoint
Applications
1 3 (13.04%) MS Excel
1 3 (13.04%) MS Visio
Database & Business Intelligence
1 16 (69.57%) SQL Server
2 12 (52.17%) SQL Server Reporting Services
2 12 (52.17%) SQL Server Analysis Services
3 11 (47.83%) Oracle OLAP
3 11 (47.83%) MOLAP
3 11 (47.83%) ROLAP
4 6 (26.09%) SQL Server Integration Services
4 6 (26.09%) Oracle Reports
4 6 (26.09%) Data Warehouse
4 6 (26.09%) Data Mining
5 5 (21.74%) Microsoft Analysis Services
6 3 (13.04%) Crystal Reports
7 2 (8.70%) DTS
8 1 (4.35%) PerformancePoint
Development Applications
1 2 (8.70%) SQL Server Management Studio (SSMS)
2 1 (4.35%) Team Foundation Server
General
1 7 (30.43%) Finance
2 3 (13.04%) Marketing
3 2 (8.70%) Billing
4 1 (4.35%) Retail Banking
4 1 (4.35%) Banking
4 1 (4.35%) Retail
Job Titles
1 14 (60.87%) Analyst
1 14 (60.87%) Business Intelligence Analyst
2 12 (52.17%) Developer
3 11 (47.83%) Business Analyst
4 6 (26.09%) Web Developer
5 4 (17.39%) SQL Developer
5 4 (17.39%) Business Intelligence Developer
6 3 (13.04%) MI Developer
6 3 (13.04%) SQL Reporting Analyst
6 3 (13.04%) .NET Web Developer
6 3 (13.04%) Developer Analyst
6 3 (13.04%) Report Analyst
6 3 (13.04%) .NET Developer
6 3 (13.04%) Analyst Developer
7 2 (8.70%) SQL Server Developer
7 2 (8.70%) Server Analyst
7 2 (8.70%) SQL Server Analyst
8 1 (4.35%) MI Analyst
8 1 (4.35%) Business Developer
Libraries, Frameworks & Software Standards
1 9 (39.13%) .NET
2 6 (26.09%) ASP.NET
2 6 (26.09%) CSS
2 6 (26.09%) HTML
3 3 (13.04%) Highcharts JS
3 3 (13.04%) MDX
4 2 (8.70%) ASP.NET MVC
Miscellaneous
1 6 (26.09%) Visualisation
2 5 (21.74%) Mathematics
2 5 (21.74%) Physics
2 5 (21.74%) Computer Science
3 2 (8.70%) Kindle
3 2 (8.70%) Analytical Skills
Processes & Methodologies
1 20 (86.96%) Business Intelligence
2 10 (43.48%) Analytics
3 8 (34.78%) ETL
4 6 (26.09%) Data Modelling
5 5 (21.74%) MVC
5 5 (21.74%) Software Engineering
5 5 (21.74%) Strategic Planning
6 3 (13.04%) Web Development
6 3 (13.04%) Kimball Methodology
7 2 (8.70%) Data Transformation
7 2 (8.70%) Dimensional Modelling
7 2 (8.70%) Migration
7 2 (8.70%) Scrum
7 2 (8.70%) Agile Software Development
Programming Languages
1 18 (78.26%) SQL
2 6 (26.09%) T-SQL
2 6 (26.09%) C#
2 6 (26.09%) JavaScript
2 6 (26.09%) PL/SQL
3 2 (8.70%) R
Qualifications
1 11 (47.83%) Degree
Quality Assurance & Compliance
1 8 (34.78%) ISO 9001
2 1 (4.35%) Solvency II
Vendors
1 11 (47.83%) Oracle
1 11 (47.83%) Business Objects
2 8 (34.78%) Microsoft
Potters Bar, Hertfordshire
Understanding Recruitment
Salary: £40000 - £55000 per annum + Benefits
Posted: 2 days ago
Hertfordshire
Deerfoot IT
Salary: £45000 - £50000 per annum + 23 days holiday, pension scheme
Posted: 10 days ago
Hertfordshire
Progressive Recruitment
Salary: £45000 - £50000 per annum + competitive
Posted: 13 days ago