Period
to 22 July 2017

The following table provides summary statistics for permanent job vacancies advertised in the South West 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 22 July 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
England > South West
6 months to
22 Jul 2017
Same period 2016 Same period 2015
Rank 310 323 306
Rank change year-on-year +13 -17 +12
Permanent jobs citing OLAP 28 27 55
As % of all permanent IT jobs advertised in the South West 0.27% 0.24% 0.46%
As % of the Database & Business Intelligence category 0.86% 0.76% 1.41%
Number of salaries quoted 13 24 29
South West median annual salary £37,500 £41,000 £47,500
Median salary % change year-on-year -8.54% -13.68% +11.76%
10th Percentile £31,250 £35,000 £35,000
90th Percentile £67,500 £56,000 £70,000
England median annual salary £50,000 £50,000 £52,500
% change year-on-year - -4.76% +5.00%

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the South West with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
South West
Permanent job vacancies with a requirement for database and business intelligence skills 3265 3564 3887
As % of all permanent IT job vacancies advertised in the South West 31.02% 31.97% 32.19%
Number of salaries quoted 2835 2990 3293
South West median annual salary £40,000 £40,000 £37,500
Median salary % change year-on-year - +6.67% -
10th Percentile £26,250 £26,250 £25,000
90th Percentile £62,500 £61,250 £55,000
England median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% -

OLAP
Job Vacancy Trend in the South West

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

Job vacancy trend for OLAP in the South West

OLAP
Salary Trend in the South West

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

Salary trend for OLAP in the South West

OLAP
Salary Histogram in the South West

The salary distribution of IT jobs citing OLAP in the South West over the 6 months to 22 July 2017.

Salary histogram for OLAP in the South West

OLAP
Job Locations in the South West

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the South West region over the 6 months to 22 July 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
Somerset -5 20 £32,500 -20.73%
Bristol -9 5 £65,000 +73.33%
Dorset +23 1 £52,500 +61.54%
Devon - 1 £40,000 -
Wiltshire - 1 - - 1
OLAP
England

For the 6 months to 22 July 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 West region with a requirement for OLAP.

1 24 (85.71%) SQL Server
1 24 (85.71%) Microsoft
2 20 (71.43%) Business Intelligence
2 20 (71.43%) SQL Server Reporting Services
3 19 (67.86%) Data Warehouse
4 15 (53.57%) SQL
5 14 (50.00%) ETL
6 13 (46.43%) Windows
7 12 (42.86%) Solaris
7 12 (42.86%) Unix
7 12 (42.86%) SharePoint
7 12 (42.86%) NetApp
7 12 (42.86%) Management Information System
7 12 (42.86%) Data Analysis
7 12 (42.86%) VMware
7 12 (42.86%) Data Management
7 12 (42.86%) QA
7 12 (42.86%) QlikView
7 12 (42.86%) Data Structures
7 12 (42.86%) Power BI
7 12 (42.86%) Renewable Energy
8 10 (35.71%) SQL Server 2014
9 9 (32.14%) OLTP
9 9 (32.14%) T-SQL
10 8 (28.57%) Visual Studio
10 8 (28.57%) SQL Server 2016
10 8 (28.57%) tSQLt
10 8 (28.57%) SSDT
10 8 (28.57%) SQL Server Integration Services
10 8 (28.57%) SQL Server Analysis Services

OLAP
Co-occurring IT Skills in the South West 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 12 (42.86%) SharePoint
2 2 (7.14%) Elasticsearch
Business Applications
1 4 (14.29%) Cognos Business Intelligence
2 1 (3.57%) Dynamics AX
Cloud Services
1 8 (28.57%) GitHub
Database & Business Intelligence
1 24 (85.71%) SQL Server
2 20 (71.43%) SQL Server Reporting Services
3 19 (67.86%) Data Warehouse
4 12 (42.86%) Power BI
4 12 (42.86%) QlikView
5 10 (35.71%) SQL Server 2014
6 9 (32.14%) OLTP
7 8 (28.57%) SQL Server 2016
7 8 (28.57%) SQL Server Analysis Services
7 8 (28.57%) SQL Server Integration Services
7 8 (28.57%) SSDT
8 3 (10.71%) OLAP Cube
9 2 (7.14%) MySQL
9 2 (7.14%) NoSQL
10 1 (3.57%) Relational Database
10 1 (3.57%) SQL Server 2012
Development Applications
1 8 (28.57%) tSQLt
1 8 (28.57%) Visual Studio
General
1 4 (14.29%) Finance
2 3 (10.71%) Advertising
Job Titles
1 20 (71.43%) DBA
2 19 (67.86%) Administrator
3 7 (25.00%) SQL DBA
3 7 (25.00%) SQL Server DBA
4 4 (14.29%) Business Intelligence Developer
4 4 (14.29%) Developer
5 3 (10.71%) Microsoft BI Developer
5 3 (10.71%) Microsoft Developer
6 2 (7.14%) Business Intelligence Manager
7 1 (3.57%) Cognos Consultant
7 1 (3.57%) Consultant
7 1 (3.57%) Data Manager
7 1 (3.57%) Data Warehouse Manager
7 1 (3.57%) MI Manager
7 1 (3.57%) Senior Business Intelligence Developer
7 1 (3.57%) Senior Developer
7 1 (3.57%) Senior Microsoft Developer
7 1 (3.57%) SSAS Developer
7 1 (3.57%) SSIS Developer
7 1 (3.57%) SSRS Developer
Miscellaneous
1 12 (42.86%) Data Structures
1 12 (42.86%) Management Information System
1 12 (42.86%) Renewable Energy
2 1 (3.57%) Computer Science
Operating Systems
1 13 (46.43%) Windows
2 12 (42.86%) Solaris
2 12 (42.86%) Unix
Processes & Methodologies
1 20 (71.43%) Business Intelligence
2 14 (50.00%) ETL
3 12 (42.86%) Data Analysis
3 12 (42.86%) Data Management
4 8 (28.57%) Agile Software Development
5 6 (21.43%) E-Commerce
6 5 (17.86%) Kimball Methodology
6 5 (17.86%) Stakeholder Management
7 4 (14.29%) Information Management
7 4 (14.29%) People Management
8 2 (7.14%) ETL Development
9 1 (3.57%) Change Management
9 1 (3.57%) ERP
9 1 (3.57%) Proactive Monitoring
Programming Languages
1 15 (53.57%) SQL
2 9 (32.14%) T-SQL
3 8 (28.57%) PowerShell
4 1 (3.57%) X++
Quality Assurance & Compliance
1 12 (42.86%) QA
Systems Management
1 1 (3.57%) Systems Management Server (SMS)
Vendors
1 24 (85.71%) Microsoft
2 12 (42.86%) NetApp
2 12 (42.86%) VMware
3 8 (28.57%) RedGate
4 4 (14.29%) Cognos
Salisbury
Nigel Frank International
Salary: £30000 - £47000 per annum + Pension, Negotiable
Posted: 3 days ago