The table below looks at the statistics for OLAP skills in IT jobs advertised for the Leeds 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 156 168 194
Rank change year-on-year
+12 +26
Permanent jobs citing OLAP 5 20 6
As % of all permanent IT jobs located in Leeds 0.18% 0.57% 0.16%
As % of the Database & Business Intelligence category 0.63% 1.72% 0.49%
Number of salaries quoted 3 16 6
Median salary £42,500 £41,250 £44,500
Median salary % change year-on-year
+3.03% -7.30%
90% offered a salary of more than £40,500 £40,000 £41,750
10% offered a salary of more than £70,500 £60,000 £52,500
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
OLAP
West Yorkshire

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 Leeds region.

Database & Business Intelligence Category
Leeds
Permanent IT job ads with a match in the
Database & Business Intelligence category
799 1160 1232
As % of all permanent IT jobs located in Leeds 29.16% 33.13% 33.56%
Number of salaries quoted 678 961 993
Median salary £42,500 £41,500 £40,000
Median salary % change year-on-year
+2.40% +3.75%
90% offered a salary of more than £30,000 £32,500 £27,500
10% offered a salary of more than £56,400 £52,500 £62,500
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

OLAP
Jobs Demand Trend in Leeds

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

OLAP Jobs Demand Trend in Leeds

OLAP
Salary Trend in Leeds

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

OLAP Salary Trend in Leeds

OLAP
Salary Histogram in Leeds

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

OLAP Salary Histogram in Leeds

OLAP
Top 30 Related IT Skills in Leeds

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 Leeds region with a requirement for OLAP.

1 25 (89.29%) Business Intelligence
2 22 (78.57%) ETL
3 21 (75.00%) Microsoft
3 21 (75.00%) SQL
3 21 (75.00%) SQL Server
4 20 (71.43%) SQL Server Analysis Services
5 18 (64.29%) Hadoop
5 18 (64.29%) SQL Server 2012
5 18 (64.29%) SQL Server 2014
6 16 (57.14%) SQL Server Integration Services
6 16 (57.14%) MS Excel
7 15 (53.57%) Data Warehouse
8 14 (50.00%) SQL Server Reporting Services
8 14 (50.00%) SQL Server 2016
8 14 (50.00%) Microsoft Azure
8 14 (50.00%) NoSQL
9 13 (46.43%) Big Data
10 12 (42.86%) SQL Server 2005
11 11 (39.29%) E-Commerce
11 11 (39.29%) Power BI
11 11 (39.29%) PowerPivot
12 9 (32.14%) OLAP Cube
13 7 (25.00%) Data Integration
13 7 (25.00%) Agile Software Development
14 6 (21.43%) Analytical Skills
15 5 (17.86%) Splunk
15 5 (17.86%) Tableau
15 5 (17.86%) Data Management
16 4 (14.29%) Base SAS
16 4 (14.29%) SAS Enterprise Guide

OLAP
Top Related IT Skills in Leeds 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 4 (14.29%) SAS
Applications
1 16 (57.14%) MS Excel
Cloud Services
1 14 (50.00%) Microsoft Azure
Communications & Networking
1 1 (3.57%) Extranet
1 1 (3.57%) Firewall
1 1 (3.57%) Intranet
Database & Business Intelligence
1 21 (75.00%) SQL Server
2 20 (71.43%) SQL Server Analysis Services
3 18 (64.29%) Hadoop
3 18 (64.29%) SQL Server 2012
3 18 (64.29%) SQL Server 2014
4 16 (57.14%) SQL Server Integration Services
5 15 (53.57%) Data Warehouse
6 14 (50.00%) NoSQL
6 14 (50.00%) SQL Server 2016
6 14 (50.00%) SQL Server Reporting Services
7 13 (46.43%) Big Data
8 12 (42.86%) SQL Server 2005
9 11 (39.29%) Power BI
9 11 (39.29%) PowerPivot
10 9 (32.14%) OLAP Cube
11 4 (14.29%) Base SAS
11 4 (14.29%) Data Mining
11 4 (14.29%) SAS Enterprise Guide
12 3 (10.71%) OLTP
13 2 (7.14%) Enterprise Data Warehouse
Development Applications
1 2 (7.14%) ERwin
General
1 3 (10.71%) Finance
2 1 (3.57%) Games
Job Titles
1 20 (71.43%) Developer
2 17 (60.71%) SQL Developer
2 17 (60.71%) SQL Server Developer
3 13 (46.43%) SSIS Developer
4 11 (39.29%) Azure Developer
4 11 (39.29%) NoSQL Developer
5 7 (25.00%) Business Intelligence Developer
6 6 (21.43%) ETL Developer
7 4 (14.29%) Business Developer
7 4 (14.29%) OLAP Developer
7 4 (14.29%) SQL BI Developer
7 4 (14.29%) SQL Server BI Developer
7 4 (14.29%) SSAS Developer
8 3 (10.71%) Architect
9 2 (7.14%) Consultant
9 2 (7.14%) Data Architect
9 2 (7.14%) Programmer
9 2 (7.14%) SAS Consultant
9 2 (7.14%) SAS Programmer
10 1 (3.57%) Business Manager
Libraries, Frameworks & Software Standards
1 1 (3.57%) .NET
1 1 (3.57%) REST
1 1 (3.57%) SOAP
1 1 (3.57%) WCF
1 1 (3.57%) WF
1 1 (3.57%) Windows Identity Foundation
1 1 (3.57%) XML
Miscellaneous
1 7 (25.00%) Data Integration
2 6 (21.43%) Analytical Skills
3 1 (3.57%) Data Protection Act
3 1 (3.57%) NHS
Operating Systems
1 2 (7.14%) Unix
Processes & Methodologies
1 25 (89.29%) Business Intelligence
2 22 (78.57%) ETL
3 11 (39.29%) E-Commerce
4 7 (25.00%) Agile Software Development
5 5 (17.86%) Data Management
6 4 (14.29%) ETL Development
7 2 (7.14%) Dashboard Development
7 2 (7.14%) Data Modelling
7 2 (7.14%) Enterprise Modelling
7 2 (7.14%) SDLC
7 2 (7.14%) TOGAF
8 1 (3.57%) B2B
8 1 (3.57%) B2C
8 1 (3.57%) Benchmarking
8 1 (3.57%) Business Continuity
8 1 (3.57%) Business Performance Management
8 1 (3.57%) Information Security
8 1 (3.57%) Predictive Analytics
8 1 (3.57%) SOA
8 1 (3.57%) Stakeholder Management
Programming Languages
1 21 (75.00%) SQL
2 2 (7.14%) SAS Macro
2 2 (7.14%) T-SQL
Qualifications
1 2 (7.14%) Microsoft Certification
Quality Assurance & Compliance
1 1 (3.57%) PCI DSS
Vendors
1 21 (75.00%) Microsoft
2 5 (17.86%) Splunk
2 5 (17.86%) Tableau
3 1 (3.57%) Cognos
3 1 (3.57%) Oracle
3 1 (3.57%) SAP
3 1 (3.57%) Teradata