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

3 months to
29 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 150 161 193
Rank change year-on-year
+11 +32
Permanent jobs citing OLAP 32 28 18
As % of all permanent IT jobs located in Hampshire 0.93% 0.79% 0.45%
As % of the Database & Business Intelligence category 2.63% 2.35% 1.42%
Number of salaries quoted 29 27 17
Median salary £45,000 £37,500 £31,250
Median salary % change year-on-year
+20.00% +20.00%
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
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
1217 1194 1267
As % of all permanent IT jobs located in Hampshire 35.37% 33.71% 31.53%
Number of salaries quoted 1100 1043 1003
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 £27,500 £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 29 August 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 29 August 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 - 24 £50,000 - 1
Basingstoke - 4 £28,500 -
Fareham -11 1 £35,000 -26.31%
OLAP
South East

OLAP
Top 30 Related IT Skills in Hampshire

For the 6 months to 29 August 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 47 (95.92%) SQL Server
2 45 (91.84%) SQL
3 41 (83.67%) OLTP
4 40 (81.63%) T-SQL
5 28 (57.14%) Data Warehouse
6 19 (38.78%) MS Excel
7 18 (36.73%) Microsoft
7 18 (36.73%) Enterprise Software
7 18 (36.73%) Database Security
8 17 (34.69%) Degree
9 16 (32.65%) Computer Science
10 15 (30.61%) Reverse Engineering
11 14 (28.57%) Data Analysis
12 13 (26.53%) Data Management
13 12 (24.49%) Finance
13 12 (24.49%) Business Intelligence
14 11 (22.45%) Windows
14 11 (22.45%) Disaster Recovery
14 11 (22.45%) Replication
14 11 (22.45%) VMware
14 11 (22.45%) Clustering
14 11 (22.45%) Retail
14 11 (22.45%) Refactoring
14 11 (22.45%) Capacity Planning
14 11 (22.45%) Performance Tuning
14 11 (22.45%) High Availability
14 11 (22.45%) Microsoft Clustering
15 7 (14.29%) Software Engineering
15 7 (14.29%) MS Access
15 7 (14.29%) C#

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 19 (38.78%) MS Excel
Business Applications
1 4 (8.16%) Cognos Business Intelligence
1 4 (8.16%) Cognos TM1
2 3 (6.12%) Cognos Controller
2 3 (6.12%) Oracle EBS
3 1 (2.04%) Hyperion Planning
3 1 (2.04%) SAP BPC
Database & Business Intelligence
1 47 (95.92%) SQL Server
2 41 (83.67%) OLTP
3 28 (57.14%) Data Warehouse
4 7 (14.29%) MS Access
5 6 (12.24%) SQL Server Integration Services
5 6 (12.24%) SQL Server Reporting Services
6 5 (10.20%) OLAP Cube
7 4 (8.16%) Oracle OLAP
7 4 (8.16%) SQL Server Analysis Services
8 2 (4.08%) BusinessObjects
8 2 (4.08%) Data Mining
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%) Qlik Sense
9 1 (2.04%) QlikView
9 1 (2.04%) SQL Server 2012
Development Applications
1 2 (4.08%) Git (software)
1 2 (4.08%) Subversion
1 2 (4.08%) Team Foundation Server
General
1 12 (24.49%) Finance
2 11 (22.45%) Retail
3 2 (4.08%) Manufacturing
4 1 (2.04%) Advertising
4 1 (2.04%) Banking
4 1 (2.04%) Telecoms
Job Titles
1 29 (59.18%) Developer
2 26 (53.06%) SQL Developer
3 11 (22.45%) Database Developer
3 11 (22.45%) DBA
3 11 (22.45%) Senior DBA
3 11 (22.45%) Senior SQL DBA
3 11 (22.45%) SQL DBA
4 10 (20.41%) Senior SQL Server DBA
4 10 (20.41%) SQL Server DBA
5 9 (18.37%) Analyst
5 9 (18.37%) SQL Database Developer
6 7 (14.29%) Lead Developer
6 7 (14.29%) SQL Server Developer
7 5 (10.20%) T-SQL Developer
8 4 (8.16%) OLAP Analyst
8 4 (8.16%) OLAP Developer
8 4 (8.16%) Senior Analyst
8 4 (8.16%) Senior Data Warehouse Analyst
8 4 (8.16%) SQL Analyst
8 4 (8.16%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 2 (4.08%) .NET
1 2 (4.08%) MDX
2 1 (2.04%) Dapper ORM
2 1 (2.04%) EJB
2 1 (2.04%) Entity Framework
2 1 (2.04%) Hibernate
2 1 (2.04%) LINQ
2 1 (2.04%) LINQ to SQL
Miscellaneous
1 18 (36.73%) Enterprise Software
2 16 (32.65%) Computer Science
3 11 (22.45%) Clustering
3 11 (22.45%) Replication
4 3 (6.12%) Algorithms
4 3 (6.12%) Statistics
5 1 (2.04%) FMCG
5 1 (2.04%) NHS
Operating Systems
1 11 (22.45%) Windows
Processes & Methodologies
1 18 (36.73%) Database Security
2 15 (30.61%) Reverse Engineering
3 14 (28.57%) Data Analysis
4 13 (26.53%) Data Management
5 12 (24.49%) Business Intelligence
6 11 (22.45%) Capacity Planning
6 11 (22.45%) Disaster Recovery
6 11 (22.45%) High Availability
6 11 (22.45%) Performance Tuning
6 11 (22.45%) Refactoring
7 7 (14.29%) Software Engineering
8 3 (6.12%) Analytics
8 3 (6.12%) CRM
8 3 (6.12%) Data Analytics
8 3 (6.12%) OO
9 2 (4.08%) Agile Software Development
9 2 (4.08%) Functional Programming
9 2 (4.08%) Scrum
9 2 (4.08%) SDLC
9 2 (4.08%) Unit Testing
Programming Languages
1 45 (91.84%) SQL
2 40 (81.63%) T-SQL
3 7 (14.29%) C#
3 7 (14.29%) Java
4 2 (4.08%) Python
4 2 (4.08%) Ruby
4 2 (4.08%) VB.NET
4 2 (4.08%) VBA
5 1 (2.04%) VB
5 1 (2.04%) VB6
Qualifications
1 17 (34.69%) Degree
2 1 (2.04%) ACCA
2 1 (2.04%) CIMA
Quality Assurance & Compliance
1 3 (6.12%) QA
Systems Management
1 11 (22.45%) Microsoft Clustering
Vendors
1 18 (36.73%) Microsoft
2 11 (22.45%) VMware
3 6 (12.24%) Cognos
4 5 (10.20%) IBM
5 4 (8.16%) Oracle
6 2 (4.08%) SAP
7 1 (2.04%) Baan
7 1 (2.04%) Hyperion
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 4 days ago