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

3 months to
24 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 159 156 194
Rank change year-on-year
-3 +38
Permanent jobs citing OLAP 22 37 11
As % of all permanent IT jobs located in Hampshire 0.69% 1.00% 0.28%
As % of the Database & Business Intelligence category 2.00% 2.98% 0.87%
Number of salaries quoted 21 33 10
Median salary £45,000 £37,500 £31,250
Median salary % change year-on-year
+20.00% +20.00%
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -
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
1102 1243 1271
As % of all permanent IT jobs located in Hampshire 34.68% 33.65% 31.96%
Number of salaries quoted 1000 1095 1001
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 £30,000 £27,500
10% offered a salary of more than £55,000 £55,000 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 24 September 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 24 September 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 - 16 £50,000 - 1
Basingstoke - 5 £28,500 -
Fareham +1 1 £35,000 -26.31%
OLAP
South East

OLAP
Top 30 Related IT Skills in Hampshire

For the 6 months to 24 September 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 (95.83%) SQL Server
2 44 (91.67%) SQL
3 40 (83.33%) OLTP
4 39 (81.25%) T-SQL
5 26 (54.17%) Data Warehouse
6 22 (45.83%) MS Excel
7 21 (43.75%) Microsoft
8 17 (35.42%) Degree
8 17 (35.42%) Enterprise Software
9 16 (33.33%) Computer Science
10 15 (31.25%) Database Security
11 13 (27.08%) Performance Tuning
11 13 (27.08%) Capacity Planning
11 13 (27.08%) High Availability
11 13 (27.08%) Microsoft Clustering
11 13 (27.08%) Disaster Recovery
11 13 (27.08%) Windows
11 13 (27.08%) Replication
11 13 (27.08%) VMware
11 13 (27.08%) Clustering
11 13 (27.08%) Data Analysis
12 12 (25.00%) Data Management
12 12 (25.00%) Finance
12 12 (25.00%) Reverse Engineering
13 10 (20.83%) Business Intelligence
13 10 (20.83%) Retail
14 8 (16.67%) Refactoring
15 7 (14.58%) MS Access
15 7 (14.58%) Software Engineering
16 6 (12.50%) Cognos

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:

Applications
1 22 (45.83%) MS Excel
Business Applications
1 4 (8.33%) Cognos Business Intelligence
1 4 (8.33%) Cognos TM1
2 3 (6.25%) Cognos Controller
2 3 (6.25%) Oracle EBS
3 1 (2.08%) Hyperion Planning
3 1 (2.08%) SAP BPC
Database & Business Intelligence
1 46 (95.83%) SQL Server
2 40 (83.33%) OLTP
3 26 (54.17%) Data Warehouse
4 7 (14.58%) MS Access
5 6 (12.50%) OLAP Cube
5 6 (12.50%) SQL Server Integration Services
5 6 (12.50%) SQL Server Reporting Services
6 5 (10.42%) SQL Server Analysis Services
7 4 (8.33%) Oracle OLAP
8 2 (4.17%) BusinessObjects
9 1 (2.08%) Cognos Report Studio
9 1 (2.08%) Enterprise Data Warehouse
9 1 (2.08%) Oracle Reports
9 1 (2.08%) Pentaho
9 1 (2.08%) Qlik Sense
9 1 (2.08%) QlikView
9 1 (2.08%) SQL Server 2008
9 1 (2.08%) SQL Server 2012
9 1 (2.08%) SQL Server 2016
General
1 12 (25.00%) Finance
2 10 (20.83%) Retail
3 2 (4.17%) Manufacturing
4 1 (2.08%) Banking
4 1 (2.08%) Telecoms
Job Titles
1 26 (54.17%) Developer
2 24 (50.00%) SQL Developer
3 13 (27.08%) DBA
3 13 (27.08%) Senior DBA
3 13 (27.08%) Senior SQL DBA
3 13 (27.08%) SQL DBA
4 12 (25.00%) Senior SQL Server DBA
4 12 (25.00%) SQL Server DBA
5 9 (18.75%) Analyst
5 9 (18.75%) Database Developer
5 9 (18.75%) SQL Database Developer
6 7 (14.58%) Lead Developer
7 6 (12.50%) SQL Server Developer
8 4 (8.33%) Data Analyst
8 4 (8.33%) Data Warehouse Analyst
8 4 (8.33%) OLAP Developer
8 4 (8.33%) Senior Analyst
8 4 (8.33%) Senior Data Analyst
8 4 (8.33%) Senior Data Warehouse Analyst
8 4 (8.33%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 2 (4.17%) MDX
Miscellaneous
1 17 (35.42%) Enterprise Software
2 16 (33.33%) Computer Science
3 13 (27.08%) Clustering
3 13 (27.08%) Replication
4 3 (6.25%) Algorithms
4 3 (6.25%) Statistics
5 1 (2.08%) FMCG
5 1 (2.08%) NHS
Operating Systems
1 13 (27.08%) Windows
Processes & Methodologies
1 15 (31.25%) Database Security
2 13 (27.08%) Capacity Planning
2 13 (27.08%) Data Analysis
2 13 (27.08%) Disaster Recovery
2 13 (27.08%) High Availability
2 13 (27.08%) Performance Tuning
3 12 (25.00%) Data Management
3 12 (25.00%) Reverse Engineering
4 10 (20.83%) Business Intelligence
5 8 (16.67%) Refactoring
6 7 (14.58%) Software Engineering
7 3 (6.25%) Analytics
7 3 (6.25%) CRM
7 3 (6.25%) Data Analytics
8 2 (4.17%) Agile Software Development
8 2 (4.17%) Functional Programming
8 2 (4.17%) OO
8 2 (4.17%) Scrum
8 2 (4.17%) SDLC
8 2 (4.17%) TDD
Programming Languages
1 44 (91.67%) SQL
2 39 (81.25%) T-SQL
3 4 (8.33%) C#
3 4 (8.33%) Java
4 2 (4.17%) VBA
5 1 (2.08%) VB
5 1 (2.08%) VB6
Qualifications
1 17 (35.42%) Degree
2 1 (2.08%) ACCA
2 1 (2.08%) CIMA
Quality Assurance & Compliance
1 3 (6.25%) QA
Systems Management
1 13 (27.08%) Microsoft Clustering
Vendors
1 21 (43.75%) Microsoft
2 13 (27.08%) VMware
3 6 (12.50%) Cognos
4 5 (10.42%) IBM
5 4 (8.33%) Oracle
6 2 (4.17%) SAP
7 1 (2.08%) Baan
7 1 (2.08%) Hyperion
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 24 days ago