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

3 months to
25 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 166 185 172
Rank change year-on-year
+19 -13
Permanent jobs citing OLAP 18 14 23
As % of all permanent IT jobs located in Hampshire 0.55% 0.39% 0.59%
As % of the Database & Business Intelligence category 1.62% 1.07% 2.01%
Number of salaries quoted 17 11 19
Median salary £45,000 £40,000 £40,000
Median salary % change year-on-year
+12.50% -
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -5.88%
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
1108 1311 1147
As % of all permanent IT jobs located in Hampshire 33.90% 36.16% 29.23%
Number of salaries quoted 1019 1134 1008
Median salary £42,500 £42,250 £40,000
Median salary % change year-on-year
+0.59% +5.62%
90% offered a salary of more than £30,000 £30,000 £27,500
10% offered a salary of more than £55,000 £55,000 £55,000
UK excluding London median salary £42,500 £41,000 £40,000
% change year-on-year
+3.65% +2.50%

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 25 May 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 25 May 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 +11 12 £45,000 +1.12% 4
Portsmouth +2 1 £34,000 -2.85%
Winchester - 1 £55,000 -
OLAP
South East

OLAP
Top 30 Related IT Skills in Hampshire

For the 6 months to 25 May 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 22 (91.67%) SQL Server
2 21 (87.50%) SQL
3 18 (75.00%) T-SQL
4 16 (66.67%) OLTP
5 14 (58.33%) Data Warehouse
6 11 (45.83%) Business Intelligence
7 10 (41.67%) Refactoring
8 9 (37.50%) Database Security
9 7 (29.17%) SQL Server Integration Services
9 7 (29.17%) SQL Server Reporting Services
10 6 (25.00%) Enterprise Software
11 5 (20.83%) OLAP Cube
11 5 (20.83%) SQL Server Analysis Services
11 5 (20.83%) Reverse Engineering
11 5 (20.83%) C#
11 5 (20.83%) Java
12 4 (16.67%) MS Excel
12 4 (16.67%) Cognos
12 4 (16.67%) Data Analysis
12 4 (16.67%) Retail
12 4 (16.67%) Data Management
12 4 (16.67%) Finance
13 3 (12.50%) Manufacturing
13 3 (12.50%) Subversion
13 3 (12.50%) Data Mining
13 3 (12.50%) Python
13 3 (12.50%) Microsoft
13 3 (12.50%) .NET
13 3 (12.50%) VB.NET
13 3 (12.50%) Windows

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 (4.17%) SAS
1 1 (4.17%) SharePoint
Applications
1 4 (16.67%) MS Excel
2 1 (4.17%) MS Office
Business Applications
1 3 (12.50%) Cognos TM1
2 2 (8.33%) Cognos Business Intelligence
2 2 (8.33%) Hyperion Planning
2 2 (8.33%) SAP BPC
3 1 (4.17%) Cognos Controller
Communications & Networking
1 1 (4.17%) LAN
1 1 (4.17%) WAN
Database & Business Intelligence
1 22 (91.67%) SQL Server
2 16 (66.67%) OLTP
3 14 (58.33%) Data Warehouse
4 7 (29.17%) SQL Server Integration Services
4 7 (29.17%) SQL Server Reporting Services
5 5 (20.83%) OLAP Cube
5 5 (20.83%) SQL Server Analysis Services
6 3 (12.50%) Data Mining
6 3 (12.50%) SQL Server 2008
6 3 (12.50%) SQL Server 2012
7 2 (8.33%) MySQL
8 1 (4.17%) BusinessObjects
8 1 (4.17%) Cognos Report Studio
8 1 (4.17%) Oracle OLAP
8 1 (4.17%) Oracle Reports
8 1 (4.17%) Power BI
8 1 (4.17%) Qlik Sense
8 1 (4.17%) QlikView
8 1 (4.17%) SQL Server 2014
Development Applications
1 3 (12.50%) Git (software)
1 3 (12.50%) Subversion
1 3 (12.50%) Team Foundation Server
General
1 4 (16.67%) Finance
1 4 (16.67%) Retail
2 3 (12.50%) Manufacturing
3 1 (4.17%) Advertising
3 1 (4.17%) Banking
3 1 (4.17%) Telecoms
Job Titles
1 18 (75.00%) Developer
2 15 (62.50%) SQL Developer
3 13 (54.17%) Database Developer
4 11 (45.83%) SQL Database Developer
5 6 (25.00%) SQL Server Developer
6 4 (16.67%) Lead Developer
7 2 (8.33%) Accountant
7 2 (8.33%) Analyst
7 2 (8.33%) DBA
7 2 (8.33%) Senior Database Developer
7 2 (8.33%) Senior Developer
7 2 (8.33%) SQL DBA
7 2 (8.33%) SQL Server DBA
7 2 (8.33%) SSRS Developer
7 2 (8.33%) Systems Accountant
8 1 (4.17%) Business Intelligence Lead
8 1 (4.17%) QlikView Developer
8 1 (4.17%) SSIS Developer
8 1 (4.17%) TM1 Analyst
8 1 (4.17%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 3 (12.50%) .NET
2 2 (8.33%) Dapper ORM
2 2 (8.33%) EJB
2 2 (8.33%) Entity Framework
2 2 (8.33%) Hibernate
2 2 (8.33%) LINQ
2 2 (8.33%) LINQ to SQL
2 2 (8.33%) MDX
Miscellaneous
1 6 (25.00%) Enterprise Software
2 2 (8.33%) Replication
3 1 (4.17%) Clustering
3 1 (4.17%) Computer Science
3 1 (4.17%) NHS
3 1 (4.17%) Statistics
Operating Systems
1 3 (12.50%) Windows
2 1 (4.17%) Windows 7
2 1 (4.17%) Windows Server
2 1 (4.17%) Windows Server 2008
2 1 (4.17%) Windows Server 2012
Processes & Methodologies
1 11 (45.83%) Business Intelligence
2 10 (41.67%) Refactoring
3 9 (37.50%) Database Security
4 5 (20.83%) Reverse Engineering
5 4 (16.67%) Data Analysis
5 4 (16.67%) Data Management
6 3 (12.50%) OO
6 3 (12.50%) Unit Testing
7 2 (8.33%) Active Record
7 2 (8.33%) High Availability
8 1 (4.17%) Capacity Planning
8 1 (4.17%) Database Mirroring
8 1 (4.17%) ERP
8 1 (4.17%) ETL
8 1 (4.17%) Functional Programming
8 1 (4.17%) ITIL
8 1 (4.17%) Performance Tuning
8 1 (4.17%) SDLC
8 1 (4.17%) Time Management
8 1 (4.17%) Use Case
Programming Languages
1 21 (87.50%) SQL
2 18 (75.00%) T-SQL
3 5 (20.83%) C#
3 5 (20.83%) Java
4 3 (12.50%) Python
4 3 (12.50%) Ruby
4 3 (12.50%) VB.NET
5 2 (8.33%) PowerShell
5 2 (8.33%) VBA
6 1 (4.17%) Data Mining Extensions (DMX)
6 1 (4.17%) R
6 1 (4.17%) Scala
Qualifications
1 2 (8.33%) ACCA
1 2 (8.33%) CIMA
1 2 (8.33%) Degree
2 1 (4.17%) MCDBA
2 1 (4.17%) MCITP
2 1 (4.17%) Microsoft Certification
Vendors
1 4 (16.67%) Cognos
2 3 (12.50%) Microsoft
3 2 (8.33%) Hyperion
3 2 (8.33%) IBM
3 2 (8.33%) SAP
4 1 (4.17%) Baan
4 1 (4.17%) Oracle
4 1 (4.17%) VMware
Hampshire
Austin Fraser
Salary: £45000 - £50000 per annum + Benefits
Posted: 4 hours ago
Hampshire
Austin Fraser
Salary: £41 - £45000 per annum + Benefits
Posted: 5 hours ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 2 days ago
Southampton, Hampshire
Red Funnel
Salary: From £35,000 to £38,000 per annum
Posted: 8 days ago
Southampton
Deerfoot IT Resources Ltd
Salary: £50000 per annum
Posted: 15 days ago
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 20 days ago