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

3 months to
28 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 158 169 167
Rank change year-on-year
+11 -2
Permanent jobs citing OLAP 26 23 28
As % of all permanent IT jobs located in Hampshire 0.76% 0.64% 0.71%
As % of the Database & Business Intelligence category 2.11% 1.79% 2.33%
Number of salaries quoted 24 17 27
Median salary £45,000 £37,500 £40,000
Median salary % change year-on-year
+20.00% -6.25%
90% offered a salary of more than £40,750 £34,000 £31,250
10% offered a salary of more than £50,000 £41,800 £42,500
UK excluding London median salary £47,500 £40,000 £42,562
% change year-on-year
+18.75% -6.01%
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
1231 1286 1203
As % of all permanent IT jobs located in Hampshire 36.07% 35.58% 30.59%
Number of salaries quoted 1124 1114 1022
Median salary £42,500 £41,500 £40,000
Median salary % change year-on-year
+2.40% +3.75%
90% offered a salary of more than £30,000 £27,500 £30,000
10% offered a salary of more than £55,000 £55,000 £55,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 28 June 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 28 June 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 +17 20 £47,500 +6.74% 3
Fareham - 1 £35,000 -
Winchester - 1 £55,000 -
OLAP
South East

OLAP
Top 30 Related IT Skills in Hampshire

For the 6 months to 28 June 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 36 (94.74%) SQL
2 35 (92.11%) SQL Server
3 31 (81.58%) T-SQL
3 31 (81.58%) OLTP
4 25 (65.79%) Data Warehouse
5 15 (39.47%) Database Security
6 13 (34.21%) MS Excel
6 13 (34.21%) Enterprise Software
6 13 (34.21%) Refactoring
7 12 (31.58%) Data Analysis
7 12 (31.58%) Business Intelligence
7 12 (31.58%) Microsoft
8 11 (28.95%) Degree
8 11 (28.95%) Reverse Engineering
9 10 (26.32%) Computer Science
9 10 (26.32%) Data Management
10 9 (23.68%) Retail
11 8 (21.05%) Finance
11 8 (21.05%) SQL Server Integration Services
11 8 (21.05%) SQL Server Reporting Services
12 7 (18.42%) Windows
13 6 (15.79%) C#
13 6 (15.79%) Java
13 6 (15.79%) Replication
13 6 (15.79%) SQL Server Analysis Services
13 6 (15.79%) High Availability
14 5 (13.16%) Performance Tuning
14 5 (13.16%) Capacity Planning
14 5 (13.16%) Software Engineering
14 5 (13.16%) VMware

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.63%) SAS
1 1 (2.63%) SharePoint
Applications
1 13 (34.21%) MS Excel
2 1 (2.63%) MS Office
Business Applications
1 2 (5.26%) Cognos TM1
1 2 (5.26%) Hyperion Planning
1 2 (5.26%) SAP BPC
2 1 (2.63%) Cognos Business Intelligence
Communications & Networking
1 1 (2.63%) LAN
1 1 (2.63%) WAN
Database & Business Intelligence
1 35 (92.11%) SQL Server
2 31 (81.58%) OLTP
3 25 (65.79%) Data Warehouse
4 8 (21.05%) SQL Server Integration Services
4 8 (21.05%) SQL Server Reporting Services
5 6 (15.79%) SQL Server Analysis Services
6 5 (13.16%) MS Access
7 4 (10.53%) OLAP Cube
8 3 (7.89%) Data Mining
8 3 (7.89%) SQL Server 2008
8 3 (7.89%) SQL Server 2012
9 2 (5.26%) BusinessObjects
9 2 (5.26%) MySQL
10 1 (2.63%) Cognos Report Studio
10 1 (2.63%) Oracle OLAP
10 1 (2.63%) Oracle Reports
10 1 (2.63%) Power BI
10 1 (2.63%) Qlik Sense
10 1 (2.63%) QlikView
10 1 (2.63%) SQL Server 2014
Development Applications
1 3 (7.89%) Git (software)
1 3 (7.89%) Subversion
1 3 (7.89%) Team Foundation Server
General
1 9 (23.68%) Retail
2 8 (21.05%) Finance
3 3 (7.89%) Manufacturing
4 1 (2.63%) Advertising
4 1 (2.63%) Banking
4 1 (2.63%) Telecoms
Job Titles
1 26 (68.42%) Developer
2 23 (60.53%) SQL Developer
3 14 (36.84%) Database Developer
4 12 (31.58%) SQL Database Developer
5 9 (23.68%) SQL Server Developer
6 6 (15.79%) DBA
6 6 (15.79%) Lead Developer
6 6 (15.79%) SQL DBA
7 5 (13.16%) Analyst
7 5 (13.16%) Senior DBA
7 5 (13.16%) Senior SQL DBA
7 5 (13.16%) SQL Server DBA
8 4 (10.53%) Senior SQL Server DBA
8 4 (10.53%) T-SQL Developer
9 3 (7.89%) Data Analyst
9 3 (7.89%) OLAP Analyst
9 3 (7.89%) OLAP Developer
9 3 (7.89%) Senior Data Warehouse Analyst
9 3 (7.89%) SQL Analyst
9 3 (7.89%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 3 (7.89%) .NET
2 2 (5.26%) Dapper ORM
2 2 (5.26%) EJB
2 2 (5.26%) Entity Framework
2 2 (5.26%) Hibernate
2 2 (5.26%) LINQ
2 2 (5.26%) LINQ to SQL
2 2 (5.26%) MDX
Miscellaneous
1 13 (34.21%) Enterprise Software
2 10 (26.32%) Computer Science
3 6 (15.79%) Replication
4 5 (13.16%) Clustering
5 4 (10.53%) Statistics
6 3 (7.89%) Algorithms
7 1 (2.63%) NHS
Operating Systems
1 7 (18.42%) Windows
2 1 (2.63%) Windows 7
2 1 (2.63%) Windows Server
2 1 (2.63%) Windows Server 2008
2 1 (2.63%) Windows Server 2012
Processes & Methodologies
1 15 (39.47%) Database Security
2 13 (34.21%) Refactoring
3 12 (31.58%) Business Intelligence
3 12 (31.58%) Data Analysis
4 11 (28.95%) Reverse Engineering
5 10 (26.32%) Data Management
6 6 (15.79%) High Availability
7 5 (13.16%) Capacity Planning
7 5 (13.16%) Disaster Recovery
7 5 (13.16%) Performance Tuning
7 5 (13.16%) Software Engineering
8 4 (10.53%) OO
9 3 (7.89%) Unit Testing
10 2 (5.26%) Active Record
10 2 (5.26%) Agile Software Development
10 2 (5.26%) Functional Programming
10 2 (5.26%) Scrum
10 2 (5.26%) SDLC
10 2 (5.26%) TDD
11 1 (2.63%) Database Mirroring
Programming Languages
1 36 (94.74%) SQL
2 31 (81.58%) T-SQL
3 6 (15.79%) C#
3 6 (15.79%) Java
4 3 (7.89%) Python
4 3 (7.89%) Ruby
4 3 (7.89%) VB.NET
5 2 (5.26%) PowerShell
5 2 (5.26%) VBA
6 1 (2.63%) Data Mining Extensions (DMX)
6 1 (2.63%) R
6 1 (2.63%) Scala
Qualifications
1 11 (28.95%) Degree
2 2 (5.26%) ACCA
2 2 (5.26%) CIMA
3 1 (2.63%) MCDBA
3 1 (2.63%) MCITP
3 1 (2.63%) Microsoft Certification
Systems Management
1 5 (13.16%) Microsoft Clustering
Vendors
1 12 (31.58%) Microsoft
2 5 (13.16%) VMware
3 4 (10.53%) Cognos
4 3 (7.89%) SAP
5 2 (5.26%) Hyperion
5 2 (5.26%) IBM
6 1 (2.63%) Baan
6 1 (2.63%) Oracle
Southampton, Hampshire
Go IT Recruitment Ltd
Salary: From £35,000 to £50,000 per annum + 25 days Holiday + Great career pro
Posted: Yesterday
Basingstoke
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: Yesterday
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 12 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 8 days ago