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

3 months to
1 Oct 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 343 364 380
Rank change year-on-year
+21 +16
Permanent jobs citing OLAP 74 117 99
As % of all permanent IT jobs located in the South East 0.43% 0.56% 0.45%
As % of the Database & Business Intelligence category 1.47% 1.72% 1.52%
Number of salaries quoted 68 93 81
Median salary £50,000 £42,500 £52,500
Median salary % change year-on-year
+17.64% -19.04%
90% offered a salary of more than £38,500 £30,000 £31,250
10% offered a salary of more than £62,500 £53,400 £67,500
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -
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
5018 6816 6499
As % of all permanent IT jobs located in the South East 29.14% 32.46% 29.81%
Number of salaries quoted 4342 5881 5336
Median salary £47,500 £43,500 £42,500
Median salary % change year-on-year
+9.19% +2.35%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £60,000 £62,500 £60,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

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 1 October 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 1 October 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
West Sussex +28 17 £54,000 +20.00%
Hampshire -9 17 £50,000 +29.03% 1
Berkshire +29 14 £52,500 +31.25%
Surrey +19 12 £60,000 +26.31%
Oxfordshire +7 8 £50,000 +11.11% 1
Kent +4 6 £50,000 +122.22%
OLAP
England

OLAP
Top 30 Related IT Skills in the South East

For the 6 months to 1 October 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 101 (82.11%) SQL
2 89 (72.36%) SQL Server
3 71 (57.72%) Data Warehouse
3 71 (57.72%) OLTP
4 68 (55.28%) T-SQL
5 65 (52.85%) Business Intelligence
6 47 (38.21%) Microsoft
7 43 (34.96%) ETL
8 41 (33.33%) MS Excel
9 40 (32.52%) SQL Server Integration Services
10 35 (28.46%) SQL Server Reporting Services
11 32 (26.02%) SQL Server Analysis Services
12 30 (24.39%) Oracle OLAP
12 30 (24.39%) Finance
12 30 (24.39%) Oracle
13 29 (23.58%) Data Modelling
13 29 (23.58%) Performance Tuning
14 26 (21.14%) MySQL
14 26 (21.14%) Scrum
15 25 (20.33%) Big Data
15 25 (20.33%) OLAP Cube
16 24 (19.51%) Cognos
17 22 (17.89%) Clustering
17 22 (17.89%) JIRA
18 21 (17.07%) Agile Software Development
19 20 (16.26%) Hadoop
20 19 (15.45%) Data Management
20 19 (15.45%) Windows
21 18 (14.63%) Disaster Recovery
21 18 (14.63%) VMware

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 8 (6.50%) SAS
2 7 (5.69%) Apache Pig
3 2 (1.63%) Jupyter
3 2 (1.63%) NetWeaver
3 2 (1.63%) SharePoint
Applications
1 41 (33.33%) MS Excel
Business Applications
1 5 (4.07%) SAP BPC
2 4 (3.25%) Cognos Business Intelligence
2 4 (3.25%) Cognos TM1
3 3 (2.44%) Cognos Controller
3 3 (2.44%) Oracle EBS
4 2 (1.63%) Infor M3
5 1 (0.81%) Dynamics CRM
5 1 (0.81%) FastStats
5 1 (0.81%) HFM
5 1 (0.81%) Hyperion Planning
5 1 (0.81%) Oracle CRM
5 1 (0.81%) Oracle Financial Analyzer
5 1 (0.81%) SAP CRM
5 1 (0.81%) SAP SD
Cloud Services
1 12 (9.76%) Amazon AWS
2 11 (8.94%) GitHub
3 5 (4.07%) Amazon S3
4 1 (0.81%) SaaS
Communications & Networking
1 5 (4.07%) Firewall
1 5 (4.07%) SAN
2 1 (0.81%) Ethernet
Database & Business Intelligence
1 89 (72.36%) SQL Server
2 71 (57.72%) Data Warehouse
2 71 (57.72%) OLTP
3 40 (32.52%) SQL Server Integration Services
4 35 (28.46%) SQL Server Reporting Services
5 32 (26.02%) SQL Server Analysis Services
6 30 (24.39%) Oracle OLAP
7 26 (21.14%) MySQL
8 25 (20.33%) Big Data
8 25 (20.33%) OLAP Cube
9 20 (16.26%) Hadoop
10 18 (14.63%) SQL Server 2012
11 16 (13.01%) NoSQL
12 15 (12.20%) SQL Server 2008
13 14 (11.38%) SQL Server 2014
14 13 (10.57%) Microsoft Analysis Services
15 12 (9.76%) Power BI
16 9 (7.32%) BusinessObjects
16 9 (7.32%) Relational Database
17 8 (6.50%) BusinessObjects XI
Development Applications
1 22 (17.89%) JIRA
2 10 (8.13%) Talend Open Studio
3 9 (7.32%) Jenkins
3 9 (7.32%) Vagrant
3 9 (7.32%) Visual Studio
4 7 (5.69%) Cucumber
5 5 (4.07%) SQL Server Management Studio (SSMS)
6 4 (3.25%) ERwin
7 1 (0.81%) Team Foundation Server
General
1 30 (24.39%) Finance
2 13 (10.57%) Retail
3 3 (2.44%) Banking
4 1 (0.81%) Advertising
4 1 (0.81%) Electronics
4 1 (0.81%) Legal
4 1 (0.81%) Manufacturing
4 1 (0.81%) Telecoms
Job Titles
1 69 (56.10%) Developer
2 39 (31.71%) SQL Developer
3 27 (21.95%) Business Intelligence Developer
4 22 (17.89%) DBA
4 22 (17.89%) SQL DBA
5 16 (13.01%) SQL Server DBA
6 13 (10.57%) Analyst
6 13 (10.57%) Senior DBA
6 13 (10.57%) Senior SQL DBA
7 12 (9.76%) Senior SQL Server DBA
7 12 (9.76%) SSIS Developer
8 10 (8.13%) ETL Developer
9 9 (7.32%) Lead Developer
9 9 (7.32%) Senior Developer
10 8 (6.50%) Architect
10 8 (6.50%) Database Developer
10 8 (6.50%) SQL Database Developer
11 7 (5.69%) Administrator
11 7 (5.69%) Data Architect
11 7 (5.69%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 17 (13.82%) MDX
2 14 (11.38%) .NET
3 8 (6.50%) Web Services
4 5 (4.07%) .NET Framework
5 4 (3.25%) HTML
5 4 (3.25%) jQuery
6 3 (2.44%) ASP.NET
7 1 (0.81%) AngularJS
7 1 (0.81%) COM
7 1 (0.81%) CSS
7 1 (0.81%) Node.js
7 1 (0.81%) RESTful
7 1 (0.81%) SOAP
Miscellaneous
1 22 (17.89%) Clustering
2 18 (14.63%) Computer Science
3 17 (13.82%) Replication
4 16 (13.01%) Enterprise Software
5 8 (6.50%) Statistics
6 5 (4.07%) Microsoft Licensing
7 4 (3.25%) Data Integration
7 4 (3.25%) Management Information System
8 3 (2.44%) Algorithms
8 3 (2.44%) Analytical Skills
8 3 (2.44%) Visualisation
9 1 (0.81%) Data Centre
9 1 (0.81%) FMCG
9 1 (0.81%) NHS
9 1 (0.81%) Physics
Operating Systems
1 19 (15.45%) Windows
2 5 (4.07%) Windows Server
3 1 (0.81%) Linux
Processes & Methodologies
1 65 (52.85%) Business Intelligence
2 43 (34.96%) ETL
3 29 (23.58%) Data Modelling
3 29 (23.58%) Performance Tuning
4 26 (21.14%) Scrum
5 21 (17.07%) Agile Software Development
6 19 (15.45%) Data Management
7 18 (14.63%) Disaster Recovery
7 18 (14.63%) High Availability
7 18 (14.63%) Kimball Methodology
8 15 (12.20%) Database Security
9 14 (11.38%) Analytics
10 13 (10.57%) Capacity Planning
10 13 (10.57%) Data Analysis
11 12 (9.76%) Dimensional Modelling
11 12 (9.76%) Migration
11 12 (9.76%) Reverse Engineering
12 10 (8.13%) Data Analytics
13 9 (7.32%) Kanban
13 9 (7.32%) OO
Programming Languages
1 101 (82.11%) SQL
2 68 (55.28%) T-SQL
3 14 (11.38%) Java
4 13 (10.57%) PL/SQL
5 12 (9.76%) C#
5 12 (9.76%) PowerShell
6 11 (8.94%) Data Analysis Expressions (DAX)
7 7 (5.69%) Shell Script
8 4 (3.25%) JavaScript
8 4 (3.25%) VBA
9 3 (2.44%) Python
10 2 (1.63%) C
10 2 (1.63%) VB.NET
11 1 (0.81%) Embedded C
11 1 (0.81%) PHP
11 1 (0.81%) VB
11 1 (0.81%) VB6
Qualifications
1 18 (14.63%) Degree
2 4 (3.25%) Microsoft Certification
3 3 (2.44%) MCSE
4 1 (0.81%) ACCA
4 1 (0.81%) CIMA
Quality Assurance & Compliance
1 4 (3.25%) QA
2 3 (2.44%) Data Quality
3 1 (0.81%) HIPAA
3 1 (0.81%) ISO/IEC 27001
3 1 (0.81%) PCI DSS
3 1 (0.81%) SSAE 16
System Software
1 5 (4.07%) HDFS
1 5 (4.07%) Virtual Machines
1 5 (4.07%) VMware ESX
1 5 (4.07%) VMware Infrastructure
1 5 (4.07%) vSphere
2 1 (0.81%) Firmware
Systems Management
1 13 (10.57%) Microsoft Clustering
2 11 (8.94%) Puppet
Vendors
1 47 (38.21%) Microsoft
2 30 (24.39%) Oracle
3 24 (19.51%) Cognos
4 18 (14.63%) VMware
5 10 (8.13%) Talend
6 9 (7.32%) IBM
6 9 (7.32%) SAP
6 9 (7.32%) Tableau
7 6 (4.88%) RedGate
8 5 (4.07%) Atlassian
8 5 (4.07%) CommVault
8 5 (4.07%) NetApp
8 5 (4.07%) SolarWinds
8 5 (4.07%) Sophos
9 3 (2.44%) MicroStrategy
10 2 (1.63%) Actuate
10 2 (1.63%) Hyperion
10 2 (1.63%) Jaspersoft
11 1 (0.81%) Birst
11 1 (0.81%) MapR
Oxfordshire
Lawrence Harvey
Salary: £55000.00 - £60000.00 per annum + pension, bonus, health care
Posted: 10 days ago