The first table below looks at the demand for OLAP skills in IT jobs advertised for the St Albans region. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 17 April 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category for the St Albans region.

Location
3 months to
17 Apr 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 31 24 36
Rank change year-on-year
-7 +12
Permanent jobs citing OLAP 1 15 5
As % of all permanent IT jobs located in St Albans 0.73% 7.04% 2.87%
As % of the Database & Business Intelligence category 1.75% 17.24% 6.58%
Number of salaries quoted 0 7 0
Average salary - £35,000 -
UK excluding London average salary £40,000 £45,000 £42,500
% change year-on-year
-11.11% +5.88%
Database & Business Intelligence Category
St Albans
Permanent IT job ads with a match in the
Database & Business Intelligence category
57 87 76
As % of all permanent IT jobs located in St Albans 41.61% 40.85% 43.68%
Number of salaries quoted 52 67 47
Average salary £50,000 £45,000 £36,500
Average salary % change year-on-year
+11.11% +23.28%
90% offered a salary of more than £35,000 £31,500 £28,000
10% offered a salary of more than £65,000 £65,000 £49,400
UK excluding London average salary £40,000 £39,500 £37,500
% change year-on-year
+1.26% +5.33%
OLAP
Hertfordshire

OLAP
Jobs Demand Trend in St Albans

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the St Albans region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in St Albans

OLAP
Salary Trend in St Albans

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the St Albans region.

OLAP Salary Trend in St Albans

OLAP
Top 30 Related IT Skills in St Albans

For the 6 months to 17 April 2014, IT jobs across the St Albans 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 1 (100.00%) SQL
1 1 (100.00%) SQL Server
1 1 (100.00%) Visual Studio
1 1 (100.00%) MS Excel
1 1 (100.00%) SharePoint
1 1 (100.00%) Data Warehouse
1 1 (100.00%) ETL
1 1 (100.00%) Broadband
1 1 (100.00%) Business Intelligence
1 1 (100.00%) Star Schema
1 1 (100.00%) Microsoft
1 1 (100.00%) ISEB
1 1 (100.00%) Finance
1 1 (100.00%) SQL Server Reporting Services
1 1 (100.00%) Software Testing
1 1 (100.00%) SQL Server 2005
1 1 (100.00%) ISTQB
1 1 (100.00%) Marketing
1 1 (100.00%) MDX
1 1 (100.00%) Unit Testing
1 1 (100.00%) Test Management
1 1 (100.00%) SQL Server Analysis Services
1 1 (100.00%) Dimensional Modelling
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) PerformancePoint
1 1 (100.00%) Test Strategy
1 1 (100.00%) PowerPivot
1 1 (100.00%) Root Cause Analysis
1 1 (100.00%) SQL Server 2012
1 1 (100.00%) Kimball Methodology

OLAP
Top Related IT Skills in St Albans by Category

For the 6 months to 17 April 2014, IT jobs across the St Albans 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 (100.00%) SharePoint
Applications
1 1 (100.00%) MS Excel
1 1 (100.00%) PowerPivot
Communications & Networking
1 1 (100.00%) Broadband
Database & Business Intelligence
1 1 (100.00%) SQL Server
1 1 (100.00%) Data Warehouse
1 1 (100.00%) Star Schema
1 1 (100.00%) SQL Server Reporting Services
1 1 (100.00%) SQL Server 2005
1 1 (100.00%) SQL Server Analysis Services
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) PerformancePoint
1 1 (100.00%) SQL Server 2012
1 1 (100.00%) Relational Database
Development Applications
1 1 (100.00%) Visual Studio
General
1 1 (100.00%) Finance
1 1 (100.00%) Marketing
Job Titles
1 1 (100.00%) Analyst
1 1 (100.00%) Test Analyst
1 1 (100.00%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 1 (100.00%) MDX
Processes & Methodologies
1 1 (100.00%) ETL
1 1 (100.00%) Business Intelligence
1 1 (100.00%) Software Testing
1 1 (100.00%) Unit Testing
1 1 (100.00%) Test Management
1 1 (100.00%) Dimensional Modelling
1 1 (100.00%) Test Strategy
1 1 (100.00%) Root Cause Analysis
1 1 (100.00%) Kimball Methodology
Programming Languages
1 1 (100.00%) SQL
Qualifications
1 1 (100.00%) ISEB
1 1 (100.00%) ISTQB
Vendors
1 1 (100.00%) Microsoft