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

3 months to
27 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 373 335 354
Rank change year-on-year
-38 +19
Permanent jobs citing OLAP 73 123 121
As % of all permanent IT jobs located in the South East 0.40% 0.59% 0.53%
As % of the Database & Business Intelligence category 1.26% 1.89% 1.69%
Number of salaries quoted 66 98 115
Median salary £50,000 £38,500 £52,000
Median salary % change year-on-year
+29.87% -25.96%
90% offered a salary of more than £40,000 £31,500 £31,250
10% offered a salary of more than £60,000 £54,200 £65,000
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
OLAP
England

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 South East region.

Database & Business Intelligence Category
South East
Permanent IT job ads with a match in the
Database & Business Intelligence category
5776 6506 7165
As % of all permanent IT jobs located in the South East 31.37% 31.25% 31.68%
Number of salaries quoted 5125 5562 6144
Median salary £45,000 £43,500 £45,000
Median salary % change year-on-year
+3.44% -3.33%
90% offered a salary of more than £31,048 £30,000 £30,000
10% offered a salary of more than £62,500 £61,500 £60,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

OLAP
Jobs Demand Trend in the South East

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

OLAP Jobs Demand Trend in the South East

OLAP
Salary Trend in the South East

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

OLAP Salary Trend in the South East

OLAP
Salary Histogram in the South East

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

OLAP Salary Histogram in the South East

OLAP
Job Locations in the South East

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the South East region over the 3 months to 27 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
Hampshire +7 36 £43,000 +14.66% 1
Surrey +32 17 £55,000 +18.91%
Berkshire -3 14 £50,000 -7.40% 1
Oxfordshire -21 4 - -
Kent -15 1 £22,500 -30.76%
West Sussex -17 1 £45,000 +4.65%
OLAP
England

OLAP
Top 30 Related IT Skills in the South East

For the 6 months to 27 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 South East region with a requirement for OLAP.

1 88 (76.52%) SQL Server
2 87 (75.65%) SQL
3 67 (58.26%) T-SQL
4 63 (54.78%) Business Intelligence
5 61 (53.04%) Data Warehouse
6 54 (46.96%) OLTP
7 45 (39.13%) Microsoft
8 43 (37.39%) SQL Server Reporting Services
9 41 (35.65%) SQL Server Integration Services
10 39 (33.91%) SQL Server Analysis Services
11 35 (30.43%) MS Excel
12 29 (25.22%) OLAP Cube
13 28 (24.35%) ETL
14 26 (22.61%) Oracle
14 26 (22.61%) SQL Server 2012
14 26 (22.61%) Oracle OLAP
15 25 (21.74%) SQL Server 2008
16 24 (20.87%) C#
16 24 (20.87%) Finance
17 22 (19.13%) Data Modelling
18 21 (18.26%) Cognos
18 21 (18.26%) Data Management
18 21 (18.26%) Performance Tuning
19 20 (17.39%) Enterprise Software
19 20 (17.39%) Database Security
20 19 (16.52%) BusinessObjects
21 18 (15.65%) .NET
22 17 (14.78%) Agile Software Development
22 17 (14.78%) Degree
23 16 (13.91%) Reverse Engineering

OLAP
Top Related IT Skills in the South East 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 7 (6.09%) SAS
2 4 (3.48%) SharePoint
3 2 (1.74%) NetWeaver
Applications
1 35 (30.43%) MS Excel
2 8 (6.96%) MS Office
2 8 (6.96%) MS Visio
Business Applications
1 6 (5.22%) Cognos Business Intelligence
2 5 (4.35%) Cognos TM1
3 4 (3.48%) SAP BPC
4 3 (2.61%) Cognos Controller
4 3 (2.61%) Oracle EBS
5 2 (1.74%) Hyperion Planning
6 1 (0.87%) Dynamics AX
6 1 (0.87%) Dynamics NAV
6 1 (0.87%) Infor M3
6 1 (0.87%) Oracle Financial Analyzer
Cloud Services
1 4 (3.48%) Amazon AWS
2 1 (0.87%) Microsoft Azure
Communications & Networking
1 4 (3.48%) Firewall
1 4 (3.48%) SAN
2 1 (0.87%) Ethernet
Database & Business Intelligence
1 88 (76.52%) SQL Server
2 61 (53.04%) Data Warehouse
3 54 (46.96%) OLTP
4 43 (37.39%) SQL Server Reporting Services
5 41 (35.65%) SQL Server Integration Services
6 39 (33.91%) SQL Server Analysis Services
7 29 (25.22%) OLAP Cube
8 26 (22.61%) Oracle OLAP
8 26 (22.61%) SQL Server 2012
9 25 (21.74%) SQL Server 2008
10 19 (16.52%) BusinessObjects
11 12 (10.43%) Relational Database
11 12 (10.43%) SQL Server 2014
12 10 (8.70%) QlikView
13 9 (7.83%) Microsoft Analysis Services
14 8 (6.96%) Cognos Powerplay
14 8 (6.96%) MS Access
14 8 (6.96%) MySQL
14 8 (6.96%) SQL Server 2005
15 7 (6.09%) Big Data
Development Applications
1 7 (6.09%) Visual Studio
2 4 (3.48%) JIRA
2 4 (3.48%) SQL Server Management Studio (SSMS)
3 3 (2.61%) Git (software)
3 3 (2.61%) Subversion
3 3 (2.61%) Team Foundation Server
4 1 (0.87%) ERwin
General
1 24 (20.87%) Finance
2 15 (13.04%) Retail
3 3 (2.61%) Manufacturing
4 2 (1.74%) Banking
5 1 (0.87%) Advertising
5 1 (0.87%) Electronics
5 1 (0.87%) Legal
5 1 (0.87%) Marketing
5 1 (0.87%) Telecoms
Job Titles
1 68 (59.13%) Developer
2 36 (31.30%) SQL Developer
3 29 (25.22%) Business Intelligence Developer
4 16 (13.91%) DBA
4 16 (13.91%) Senior Developer
4 16 (13.91%) SSIS Developer
5 15 (13.04%) Database Developer
5 15 (13.04%) SQL DBA
6 14 (12.17%) Consultant
7 13 (11.30%) Microsoft BI Developer
7 13 (11.30%) Microsoft Developer
7 13 (11.30%) SQL Database Developer
8 12 (10.43%) Business Intelligence Consultant
8 12 (10.43%) SSAS Developer
9 11 (9.57%) Senior Business Intelligence Developer
9 11 (9.57%) SQL Server Developer
9 11 (9.57%) SSRS Developer
10 10 (8.70%) Analyst
10 10 (8.70%) SQL Server DBA
11 8 (6.96%) Senior Consultant
Libraries, Frameworks & Software Standards
1 18 (15.65%) .NET
2 14 (12.17%) HTML
2 14 (12.17%) MDX
3 8 (6.96%) XML
4 6 (5.22%) jQuery
5 4 (3.48%) Web Services
6 3 (2.61%) AngularJS
6 3 (2.61%) ASP.NET
6 3 (2.61%) CSS
6 3 (2.61%) Node.js
7 2 (1.74%) Dapper ORM
7 2 (1.74%) EJB
7 2 (1.74%) Entity Framework
7 2 (1.74%) Hibernate
7 2 (1.74%) LINQ
7 2 (1.74%) LINQ to SQL
8 1 (0.87%) .NET Framework
8 1 (0.87%) Oracle GoldenGate
Miscellaneous
1 20 (17.39%) Enterprise Software
2 16 (13.91%) Computer Science
3 15 (13.04%) Clustering
4 12 (10.43%) Replication
5 10 (8.70%) Visualisation
6 6 (5.22%) Statistics
7 4 (3.48%) Microsoft Licensing
8 3 (2.61%) Algorithms
8 3 (2.61%) Analytical Skills
9 1 (0.87%) Data Structures
9 1 (0.87%) FMCG
9 1 (0.87%) NHS
9 1 (0.87%) Physics
Operating Systems
1 12 (10.43%) Windows
2 4 (3.48%) Windows Server
3 1 (0.87%) Linux
Processes & Methodologies
1 63 (54.78%) Business Intelligence
2 28 (24.35%) ETL
3 22 (19.13%) Data Modelling
4 21 (18.26%) Data Management
4 21 (18.26%) Performance Tuning
5 20 (17.39%) Database Security
6 17 (14.78%) Agile Software Development
7 16 (13.91%) Reverse Engineering
8 15 (13.04%) Data Analysis
9 14 (12.17%) Refactoring
9 14 (12.17%) Scrum
10 12 (10.43%) Disaster Recovery
10 12 (10.43%) High Availability
11 11 (9.57%) Analytics
12 10 (8.70%) Data Visualisation
12 10 (8.70%) OO
13 9 (7.83%) Data Analytics
14 8 (6.96%) Business Analysis
14 8 (6.96%) Migration
14 8 (6.96%) UML
Programming Languages
1 87 (75.65%) SQL
2 67 (58.26%) T-SQL
3 24 (20.87%) C#
4 14 (12.17%) JavaScript
5 13 (11.30%) PL/SQL
5 13 (11.30%) VBA
6 9 (7.83%) Java
7 6 (5.22%) Data Analysis Expressions (DAX)
8 5 (4.35%) PowerShell
9 4 (3.48%) Python
9 4 (3.48%) VB.NET
10 3 (2.61%) PHP
10 3 (2.61%) Ruby
11 1 (0.87%) C
11 1 (0.87%) Data Mining Extensions (DMX)
11 1 (0.87%) Embedded C
11 1 (0.87%) R
11 1 (0.87%) Scala
11 1 (0.87%) VB
11 1 (0.87%) VB6
Qualifications
1 17 (14.78%) Degree
2 3 (2.61%) MCSE
2 3 (2.61%) Microsoft Certification
3 2 (1.74%) ACCA
3 2 (1.74%) CIMA
4 1 (0.87%) Oracle Certification
Quality Assurance & Compliance
1 6 (5.22%) QA
System Software
1 4 (3.48%) Virtual Machines
1 4 (3.48%) VMware ESX
1 4 (3.48%) VMware Infrastructure
1 4 (3.48%) vSphere
2 1 (0.87%) Firmware
Systems Management
1 7 (6.09%) Microsoft Clustering
2 1 (0.87%) Data Guard
Vendors
1 45 (39.13%) Microsoft
2 26 (22.61%) Oracle
3 21 (18.26%) Cognos
4 11 (9.57%) SAP
4 11 (9.57%) VMware
5 10 (8.70%) Tableau
6 9 (7.83%) IBM
7 6 (5.22%) Actuate
7 6 (5.22%) MicroStrategy
8 4 (3.48%) Atlassian
8 4 (3.48%) CommVault
8 4 (3.48%) NetApp
8 4 (3.48%) RedGate
8 4 (3.48%) SolarWinds
8 4 (3.48%) Sophos
9 2 (1.74%) Hyperion
10 1 (0.87%) Baan
10 1 (0.87%) Cloudera
10 1 (0.87%) EMC
10 1 (0.87%) MapR
Slough, Berkshire
Oscar
Salary: £45000 - £55000 per annum + Benefits
Posted: Yesterday
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 2 days ago