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

3 months to
26 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 148 157 175
Rank change year-on-year
+9 +18
Permanent jobs citing OLAP 36 31 23
As % of all permanent IT jobs located in Hampshire 1.04% 0.86% 0.58%
As % of the Database & Business Intelligence category 2.84% 2.50% 1.91%
Number of salaries quoted 33 26 22
Median salary £43,000 £37,500 £31,250
Median salary % change year-on-year
+14.66% +20.00%
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
OLAP
South East

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 Hampshire region.

Database & Business Intelligence Category
Hampshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1266 1239 1205
As % of all permanent IT jobs located in Hampshire 36.49% 34.19% 30.60%
Number of salaries quoted 1142 1072 996
Median salary £42,500 £42,500 £40,000
Median salary % change year-on-year
- +6.25%
90% offered a salary of more than £30,000 £28,500 £28,000
10% offered a salary of more than £55,000 £55,000 £57,500
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

OLAP
Jobs Demand Trend in Hampshire

The demand trend of job ads across the Hampshire region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Hampshire

OLAP
Salary Trend in Hampshire

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

OLAP Salary Trend in Hampshire

OLAP
Salary Histogram in Hampshire

This chart provides a salary histogram for IT jobs citing OLAP across the Hampshire region over the 3 months to 26 July 2016.

OLAP Salary Histogram in Hampshire

OLAP
Job Locations in Hampshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Hampshire region over the 3 months to 26 July 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
Southampton +25 28 £45,000 - 1
Basingstoke - 4 £28,500 -
Fareham -17 1 £35,000 -26.31%
OLAP
South East

OLAP
Top 30 Related IT Skills in Hampshire

For the 6 months to 26 July 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 Hampshire region with a requirement for OLAP.

1 46 (93.88%) SQL Server
2 44 (89.80%) SQL
3 40 (81.63%) OLTP
4 39 (79.59%) T-SQL
5 31 (63.27%) Data Warehouse
6 20 (40.82%) Enterprise Software
6 20 (40.82%) Database Security
7 16 (32.65%) Reverse Engineering
7 16 (32.65%) MS Excel
8 15 (30.61%) Data Management
8 15 (30.61%) Data Analysis
8 15 (30.61%) Degree
9 14 (28.57%) Refactoring
9 14 (28.57%) Computer Science
9 14 (28.57%) Business Intelligence
9 14 (28.57%) Microsoft
10 13 (26.53%) Finance
11 11 (22.45%) Retail
12 8 (16.33%) C#
12 8 (16.33%) Java
13 7 (14.29%) MS Access
13 7 (14.29%) Windows
13 7 (14.29%) Cognos
13 7 (14.29%) Disaster Recovery
13 7 (14.29%) Replication
13 7 (14.29%) VMware
13 7 (14.29%) Clustering
13 7 (14.29%) Software Engineering
13 7 (14.29%) SQL Server Integration Services
13 7 (14.29%) SQL Server Reporting Services

OLAP
Top Related IT Skills in Hampshire 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 (2.04%) SAS
Applications
1 16 (32.65%) MS Excel
Business Applications
1 5 (10.20%) Cognos TM1
2 4 (8.16%) Cognos Business Intelligence
3 3 (6.12%) Cognos Controller
3 3 (6.12%) Oracle EBS
4 2 (4.08%) Hyperion Planning
4 2 (4.08%) SAP BPC
Database & Business Intelligence
1 46 (93.88%) SQL Server
2 40 (81.63%) OLTP
3 31 (63.27%) Data Warehouse
4 7 (14.29%) MS Access
4 7 (14.29%) SQL Server Integration Services
4 7 (14.29%) SQL Server Reporting Services
5 5 (10.20%) OLAP Cube
5 5 (10.20%) SQL Server Analysis Services
6 4 (8.16%) Oracle OLAP
7 3 (6.12%) Data Mining
8 2 (4.08%) BusinessObjects
8 2 (4.08%) SQL Server 2008
9 1 (2.04%) Cognos Report Studio
9 1 (2.04%) Oracle Reports
9 1 (2.04%) Pentaho
9 1 (2.04%) Power BI
9 1 (2.04%) Qlik Sense
9 1 (2.04%) QlikView
9 1 (2.04%) SQL Server 2012
Development Applications
1 3 (6.12%) Git (software)
1 3 (6.12%) Subversion
1 3 (6.12%) Team Foundation Server
General
1 13 (26.53%) Finance
2 11 (22.45%) Retail
3 3 (6.12%) Manufacturing
4 1 (2.04%) Advertising
4 1 (2.04%) Banking
4 1 (2.04%) Telecoms
Job Titles
1 32 (65.31%) Developer
2 29 (59.18%) SQL Developer
3 14 (28.57%) Database Developer
4 12 (24.49%) SQL Database Developer
5 10 (20.41%) SQL Server Developer
6 9 (18.37%) Analyst
7 7 (14.29%) DBA
7 7 (14.29%) Lead Developer
7 7 (14.29%) Senior DBA
7 7 (14.29%) Senior SQL DBA
7 7 (14.29%) SQL DBA
8 6 (12.24%) Senior SQL Server DBA
8 6 (12.24%) SQL Server DBA
9 5 (10.20%) T-SQL Developer
10 4 (8.16%) Data Analyst
10 4 (8.16%) Data Warehouse Analyst
10 4 (8.16%) Senior Analyst
10 4 (8.16%) Senior Data Analyst
10 4 (8.16%) Senior Data Warehouse Analyst
10 4 (8.16%) SQL Analyst
Libraries, Frameworks & Software Standards
1 3 (6.12%) .NET
1 3 (6.12%) MDX
2 2 (4.08%) Dapper ORM
2 2 (4.08%) EJB
2 2 (4.08%) Entity Framework
2 2 (4.08%) Hibernate
2 2 (4.08%) LINQ
2 2 (4.08%) LINQ to SQL
Miscellaneous
1 20 (40.82%) Enterprise Software
2 14 (28.57%) Computer Science
3 7 (14.29%) Clustering
3 7 (14.29%) Replication
4 4 (8.16%) Statistics
5 3 (6.12%) Algorithms
6 1 (2.04%) FMCG
6 1 (2.04%) NHS
Operating Systems
1 7 (14.29%) Windows
Processes & Methodologies
1 20 (40.82%) Database Security
2 16 (32.65%) Reverse Engineering
3 15 (30.61%) Data Analysis
3 15 (30.61%) Data Management
4 14 (28.57%) Business Intelligence
4 14 (28.57%) Refactoring
5 7 (14.29%) Capacity Planning
5 7 (14.29%) Disaster Recovery
5 7 (14.29%) High Availability
5 7 (14.29%) Performance Tuning
5 7 (14.29%) Software Engineering
6 4 (8.16%) OO
7 3 (6.12%) Analytics
7 3 (6.12%) CRM
7 3 (6.12%) Data Analytics
7 3 (6.12%) Unit Testing
8 2 (4.08%) Active Record
8 2 (4.08%) Agile Software Development
8 2 (4.08%) Functional Programming
8 2 (4.08%) Scrum
Programming Languages
1 44 (89.80%) SQL
2 39 (79.59%) T-SQL
3 8 (16.33%) C#
3 8 (16.33%) Java
4 3 (6.12%) Python
4 3 (6.12%) Ruby
4 3 (6.12%) VB.NET
4 3 (6.12%) VBA
5 1 (2.04%) Data Mining Extensions (DMX)
5 1 (2.04%) PowerShell
5 1 (2.04%) R
5 1 (2.04%) Scala
5 1 (2.04%) VB
5 1 (2.04%) VB6
Qualifications
1 15 (30.61%) Degree
2 2 (4.08%) ACCA
2 2 (4.08%) CIMA
Quality Assurance & Compliance
1 3 (6.12%) QA
Systems Management
1 7 (14.29%) Microsoft Clustering
Vendors
1 14 (28.57%) Microsoft
2 7 (14.29%) Cognos
2 7 (14.29%) VMware
3 5 (10.20%) IBM
4 4 (8.16%) Oracle
5 3 (6.12%) SAP
6 2 (4.08%) Hyperion
7 1 (2.04%) Baan
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 19 hours ago