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

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 107 130 118
Rank change year-on-year
+23 -12
Permanent jobs citing OLAP 3 7 2
As % of all permanent IT jobs located in Oxfordshire 0.23% 0.36% 0.13%
As % of the Database & Business Intelligence category 0.72% 0.95% 0.39%
Number of salaries quoted 3 6 2
Median salary £57,500 £40,000 £22,500
Median salary % change year-on-year
+43.75% +77.77%
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +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 Oxfordshire region.

Database & Business Intelligence Category
Oxfordshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
419 737 516
As % of all permanent IT jobs located in Oxfordshire 31.72% 37.79% 33.27%
Number of salaries quoted 380 591 450
Median salary £47,500 £45,000 £40,000
Median salary % change year-on-year
+5.55% +12.50%
90% offered a salary of more than £31,500 £33,500 £30,000
10% offered a salary of more than £62,000 £55,000 £62,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

OLAP
Jobs Demand Trend in Oxfordshire

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

OLAP Jobs Demand Trend in Oxfordshire

OLAP
Salary Trend in Oxfordshire

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

OLAP Salary Trend in Oxfordshire

OLAP
Salary Histogram in Oxfordshire

This chart provides a salary histogram for IT jobs citing OLAP across the Oxfordshire region over the 3 months to 3 December 2016.

OLAP Salary Histogram in Oxfordshire

OLAP
Top 30 Related IT Skills in Oxfordshire

For the 6 months to 3 December 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 Oxfordshire region with a requirement for OLAP.

1 9 (100.00%) SQL Server
2 7 (77.78%) SQL
2 7 (77.78%) T-SQL
2 7 (77.78%) Data Warehouse
2 7 (77.78%) SQL Server 2008
3 6 (66.67%) RedGate
3 6 (66.67%) Tableau
3 6 (66.67%) SQL Server Reporting Services
3 6 (66.67%) SQL Server Analysis Services
3 6 (66.67%) OLTP
4 5 (55.56%) RDBMS
4 5 (55.56%) IBM
4 5 (55.56%) Microsoft
4 5 (55.56%) SAN
4 5 (55.56%) CommVault
4 5 (55.56%) MySQL
4 5 (55.56%) Web Services
4 5 (55.56%) Windows
4 5 (55.56%) MS Excel
4 5 (55.56%) Cognos
4 5 (55.56%) Disaster Recovery
4 5 (55.56%) Firewall
4 5 (55.56%) PostgreSQL
4 5 (55.56%) VMware
4 5 (55.56%) VMware ESX
4 5 (55.56%) Clustering
4 5 (55.56%) NetApp
4 5 (55.56%) Sophos
4 5 (55.56%) Project Management
4 5 (55.56%) Microsoft Analysis Services

OLAP
Top Related IT Skills in Oxfordshire 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:

Applications
1 5 (55.56%) MS Excel
Business Applications
1 2 (22.22%) HFM
Cloud Services
1 5 (55.56%) Amazon AWS
Communications & Networking
1 5 (55.56%) Firewall
1 5 (55.56%) SAN
Database & Business Intelligence
1 9 (100.00%) SQL Server
2 7 (77.78%) Data Warehouse
2 7 (77.78%) SQL Server 2008
3 6 (66.67%) OLTP
3 6 (66.67%) SQL Server Analysis Services
3 6 (66.67%) SQL Server Reporting Services
4 5 (55.56%) Amazon DynamoDB
4 5 (55.56%) Microsoft Analysis Services
4 5 (55.56%) MySQL
4 5 (55.56%) PostgreSQL
4 5 (55.56%) RDBMS
4 5 (55.56%) Relational Database
4 5 (55.56%) SQL Server 2016
5 2 (22.22%) Essbase
5 2 (22.22%) Oracle BI EE
5 2 (22.22%) Oracle Database
5 2 (22.22%) Oracle Database 11g
5 2 (22.22%) Oracle OLAP
5 2 (22.22%) SQL Server Integration Services
6 1 (11.11%) QlikView
Development Applications
1 1 (11.11%) Talend Open Studio
Job Titles
1 5 (55.56%) Administrator
1 5 (55.56%) DBA
1 5 (55.56%) SQL DBA
2 4 (44.44%) Developer
3 2 (22.22%) Business Intelligence Developer
3 2 (22.22%) OBIEE Developer
4 1 (11.11%) Analyst
4 1 (11.11%) Analyst Developer
4 1 (11.11%) Business Developer
4 1 (11.11%) Senior Business Intelligence Developer
4 1 (11.11%) Senior Developer
4 1 (11.11%) SSIS Developer
4 1 (11.11%) SSRS Developer
4 1 (11.11%) Talend Developer
Libraries, Frameworks & Software Standards
1 5 (55.56%) Web Services
Miscellaneous
1 5 (55.56%) Clustering
1 5 (55.56%) Microsoft Licensing
Operating Systems
1 5 (55.56%) Windows
1 5 (55.56%) Windows Server
Processes & Methodologies
1 5 (55.56%) Change Control
1 5 (55.56%) Disaster Recovery
1 5 (55.56%) Performance Tuning
1 5 (55.56%) Project Management
1 5 (55.56%) Software Licensing
2 4 (44.44%) Business Intelligence
2 4 (44.44%) ETL
3 2 (22.22%) Agile Software Development
3 2 (22.22%) Data Modelling
3 2 (22.22%) Waterfall
4 1 (11.11%) Dimensional Modelling
Programming Languages
1 7 (77.78%) SQL
1 7 (77.78%) T-SQL
2 5 (55.56%) PowerShell
System Software
1 5 (55.56%) Virtual Machines
1 5 (55.56%) VMware ESX
1 5 (55.56%) VMware Infrastructure
1 5 (55.56%) vSphere
Vendors
1 6 (66.67%) RedGate
1 6 (66.67%) Tableau
2 5 (55.56%) Atlassian
2 5 (55.56%) Cognos
2 5 (55.56%) CommVault
2 5 (55.56%) IBM
2 5 (55.56%) Microsoft
2 5 (55.56%) NetApp
2 5 (55.56%) SolarWinds
2 5 (55.56%) Sophos
2 5 (55.56%) VMware
3 2 (22.22%) Hyperion
3 2 (22.22%) Oracle
4 1 (11.11%) Talend