Period
to 17 November 2017

The following table provides summary statistics for permanent job vacancies advertised in the South East with a requirement for OLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLAP over the 6 months to 17 November 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
England > South East
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 479 467 444
Rank change year-on-year -12 -23 +30
Permanent jobs citing OLAP 80 131 216
As % of all permanent IT jobs advertised in the South East 0.26% 0.37% 0.50%
As % of the Database & Business Intelligence category 0.83% 1.27% 1.55%
Number of salaries quoted 70 121 177
South East median annual salary £50,000 £50,000 £41,250
Median salary % change year-on-year - +21.21% -20.67%
10th Percentile £36,125 £38,750 £30,000
90th Percentile £65,000 £62,500 £57,500
England median annual salary £50,000 £50,000 £50,000

OLAP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the South East with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
South East
Permanent vacancies with a requirement for database or business intelligence skills 9598 10325 13932
As % of all permanent IT jobs advertised in the South East 31.36% 29.34% 32.51%
Number of salaries quoted 8258 9063 11896
South East median annual salary £45,000 £45,000 £43,000
Median salary % change year-on-year - +4.65% +3.61%
10th Percentile £27,500 £28,000 £27,500
90th Percentile £65,000 £65,000 £62,500
England median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

OLAP
Job Vacancy Trend in the South East

Job postings citing OLAP as a percentage of all IT jobs advertised in the South East.

Job vacancy trend for OLAP 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 in the South East.

Salary trend for OLAP in the South East

OLAP
Salary Histogram in the South East

The salary distribution of IT jobs citing OLAP in the South East over the 6 months to 17 November 2017.

Salary histogram for OLAP 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 6 months to 17 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
West Sussex +4 24 £57,500 +9.52%
Surrey -5 21 £47,500 -13.64% 1
Thames Valley +33 20 £51,000 +2.00% 1
Buckinghamshire - 15 £44,125 - 1
Hampshire -32 8 £42,500 -5.56% 1
Kent +12 5 £45,000 -10.00%
Berkshire +34 3 £70,000 +40.00%
Oxfordshire -4 2 £48,000 -4.00%
East Sussex - 2 £60,000 -
OLAP
England

For the 6 months to 17 November 2017, 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 64 (80.00%) SQL
2 59 (73.75%) Business Intelligence
3 56 (70.00%) SQL Server
4 48 (60.00%) Data Warehouse
5 46 (57.50%) ETL
6 45 (56.25%) SQL Server Integration Services
7 43 (53.75%) Microsoft
8 36 (45.00%) SQL Server Reporting Services
9 33 (41.25%) SQL Server Analysis Services
10 30 (37.50%) T-SQL
10 30 (37.50%) OLAP Cube
11 23 (28.75%) Analytics
12 21 (26.25%) Data Quality
13 20 (25.00%) .NET
14 19 (23.75%) C#
14 19 (23.75%) Data Architecture
15 17 (21.25%) Power BI
15 17 (21.25%) ITIL
15 17 (21.25%) Disaster Recovery
16 15 (18.75%) Data Modelling
16 15 (18.75%) Microsoft Excel
16 15 (18.75%) High Availability
16 15 (18.75%) Business Analytics
16 15 (18.75%) Relational Database
17 14 (17.50%) Performance Tuning
17 14 (17.50%) SQL Server 2012
17 14 (17.50%) Finance
18 13 (16.25%) Agile Software Development
18 13 (16.25%) Data Management
18 13 (16.25%) Master Data Management

OLAP
Co-occurring 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 3 (3.75%) SharePoint
2 1 (1.25%) Elasticsearch
Applications
1 15 (18.75%) Microsoft Excel
2 4 (5.00%) Microsoft PowerPoint
2 4 (5.00%) Microsoft Project
Business Applications
1 2 (2.50%) SAP ERP
Cloud Services
1 12 (15.00%) Microsoft Azure
2 2 (2.50%) Amazon AWS
Communications & Networking
1 5 (6.25%) NAS
1 5 (6.25%) SAN
2 3 (3.75%) Internet
3 2 (2.50%) Kerberos
Database & Business Intelligence
1 56 (70.00%) SQL Server
2 48 (60.00%) Data Warehouse
3 45 (56.25%) SQL Server Integration Services
4 36 (45.00%) SQL Server Reporting Services
5 33 (41.25%) SQL Server Analysis Services
6 30 (37.50%) OLAP Cube
7 17 (21.25%) Power BI
8 15 (18.75%) Relational Database
9 14 (17.50%) SQL Server 2012
10 13 (16.25%) SQL Server 2016
11 12 (15.00%) OLTP
11 12 (15.00%) SQL Server 2008
11 12 (15.00%) SQL Server 2014
12 10 (12.50%) Oracle OLAP
13 9 (11.25%) BusinessObjects
14 8 (10.00%) QlikView
14 8 (10.00%) SQL Server 2005
15 7 (8.75%) Microsoft Analysis Services
15 7 (8.75%) NoSQL
16 5 (6.25%) Apache Hive
Development Applications
1 4 (5.00%) SQL Server Management Studio (SSMS)
2 3 (3.75%) Team Foundation Server
3 2 (2.50%) Visual Studio
General
1 14 (17.50%) Finance
2 11 (13.75%) Advertising
3 4 (5.00%) Dutch Language
3 4 (5.00%) French Language
3 4 (5.00%) German Language
3 4 (5.00%) Italian Language
3 4 (5.00%) Spanish Language
4 3 (3.75%) Banking
4 3 (3.75%) Legal
Job Titles
1 31 (38.75%) Developer
2 13 (16.25%) SQL Developer
3 12 (15.00%) Business Intelligence Developer
3 12 (15.00%) DBA
4 11 (13.75%) Business Intelligence Manager
5 8 (10.00%) Analyst
6 7 (8.75%) Business Intelligence Lead
6 7 (8.75%) Business Intelligence Project Manager
6 7 (8.75%) Project Manager
6 7 (8.75%) SQL DBA
7 6 (7.50%) Administrator
7 6 (7.50%) Report Developer
7 6 (7.50%) SSIS Developer
8 5 (6.25%) Senior DBA
8 5 (6.25%) Senior Developer
8 5 (6.25%) SQL BI Developer
8 5 (6.25%) SQL Server DBA
8 5 (6.25%) SQL Server Developer
8 5 (6.25%) SSRS Developer
9 4 (5.00%) SQL Analyst
Libraries, Frameworks & Software Standards
1 20 (25.00%) .NET
2 11 (13.75%) MDX
3 8 (10.00%) WPF
4 4 (5.00%) HTML
5 2 (2.50%) .NET Framework
5 2 (2.50%) ASP.NET
5 2 (2.50%) CSS
5 2 (2.50%) jQuery
6 1 (1.25%) Web Services
Miscellaneous
1 13 (16.25%) Analytical Skills
2 8 (10.00%) Clustering
2 8 (10.00%) PMI
3 6 (7.50%) Management Information System
4 5 (6.25%) Replication
5 3 (3.75%) Reinsurance
6 2 (2.50%) Algorithms
6 2 (2.50%) Client/Server
6 2 (2.50%) N-Tier
6 2 (2.50%) RIA
7 1 (1.25%) Data Centre
7 1 (1.25%) Greenfield Project
Operating Systems
1 10 (12.50%) Windows
2 3 (3.75%) Linux
Processes & Methodologies
1 59 (73.75%) Business Intelligence
2 46 (57.50%) ETL
3 23 (28.75%) Analytics
4 19 (23.75%) Data Architecture
5 17 (21.25%) Disaster Recovery
5 17 (21.25%) ITIL
6 15 (18.75%) Business Analytics
6 15 (18.75%) Data Modelling
6 15 (18.75%) High Availability
7 14 (17.50%) Performance Tuning
8 13 (16.25%) Agile Software Development
8 13 (16.25%) Data Management
8 13 (16.25%) Master Data Management
8 13 (16.25%) SDLC
9 11 (13.75%) Project Management
10 10 (12.50%) B2B
10 10 (12.50%) B2C
10 10 (12.50%) E-Commerce
11 9 (11.25%) Data Integration
11 9 (11.25%) Kimball Methodology
Programming Languages
1 64 (80.00%) SQL
2 30 (37.50%) T-SQL
3 19 (23.75%) C#
4 7 (8.75%) Data Analysis Expressions (DAX)
5 4 (5.00%) VB.NET
6 3 (3.75%) Python
6 3 (3.75%) R
7 2 (2.50%) C
7 2 (2.50%) JavaScript
7 2 (2.50%) VB
7 2 (2.50%) VB6
8 1 (1.25%) Bash Shell
8 1 (1.25%) Perl
8 1 (1.25%) PHP
8 1 (1.25%) PowerShell
Qualifications
1 10 (12.50%) Degree
1 10 (12.50%) MCSA
1 10 (12.50%) Microsoft Certification
2 8 (10.00%) MCDBA
2 8 (10.00%) PMI Certification
3 4 (5.00%) SC Cleared
3 4 (5.00%) Security Cleared
4 2 (2.50%) MCSE
Quality Assurance & Compliance
1 21 (26.25%) Data Quality
2 2 (2.50%) QA
3 1 (1.25%) GDPR
System Software
1 5 (6.25%) Firmware
2 2 (2.50%) Active Directory
2 2 (2.50%) KVM
2 2 (2.50%) VMware Infrastructure
Systems Management
1 8 (10.00%) Microsoft Clustering
2 5 (6.25%) SCCM
2 5 (6.25%) SCOM
3 1 (1.25%) Opscode Chef
3 1 (1.25%) Puppet
Vendors
1 43 (53.75%) Microsoft
2 10 (12.50%) Oracle
3 8 (10.00%) Cognos
4 7 (8.75%) SAP
5 6 (7.50%) Tableau
6 5 (6.25%) IBM
6 5 (6.25%) RedGate
7 3 (3.75%) Netezza
7 3 (3.75%) Teradata
8 2 (2.50%) Percona
8 2 (2.50%) VMware