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

3 months to
30 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 154 165 188
Rank change year-on-year
+11 +23
Permanent jobs citing OLAP 9 21 5
As % of all permanent IT jobs located in Leeds 0.32% 0.63% 0.14%
As % of the Database & Business Intelligence category 1.06% 1.88% 0.41%
Number of salaries quoted 3 17 5
Median salary £42,500 £40,000 £44,000
Median salary % change year-on-year
+6.25% -9.09%
90% offered a salary of more than £40,500 £39,400 £41,600
10% offered a salary of more than £70,500 £60,000 £52,500
UK excluding London median salary £47,500 £40,000 £42,500
% change year-on-year
+18.75% -5.88%
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
846 1116 1220
As % of all permanent IT jobs located in Leeds 29.62% 33.48% 33.28%
Number of salaries quoted 680 926 993
Median salary £40,000 £40,000 £40,000
90% offered a salary of more than £29,500 £30,000 £28,500
10% offered a salary of more than £57,500 £50,000 £60,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 30 June 2016.

OLAP Salary Histogram in Leeds

OLAP
Top 30 Related IT Skills in Leeds

For the 6 months to 30 June 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 35 (87.50%) Business Intelligence
2 29 (72.50%) SQL
3 28 (70.00%) ETL
4 27 (67.50%) Microsoft
4 27 (67.50%) SQL Server
5 26 (65.00%) SQL Server Analysis Services
6 24 (60.00%) Hadoop
6 24 (60.00%) SQL Server 2012
6 24 (60.00%) SQL Server 2014
7 23 (57.50%) Data Warehouse
8 20 (50.00%) MS Excel
9 18 (45.00%) SQL Server Integration Services
10 16 (40.00%) NoSQL
11 15 (37.50%) OLAP Cube
12 14 (35.00%) SQL Server 2016
12 14 (35.00%) Microsoft Azure
12 14 (35.00%) SQL Server Reporting Services
13 13 (32.50%) Agile Software Development
13 13 (32.50%) Data Integration
13 13 (32.50%) Big Data
14 12 (30.00%) Analytical Skills
14 12 (30.00%) SQL Server 2005
15 11 (27.50%) Data Management
15 11 (27.50%) E-Commerce
15 11 (27.50%) Power BI
15 11 (27.50%) PowerPivot
15 11 (27.50%) Splunk
15 11 (27.50%) Tableau
16 10 (25.00%) Data Mining
16 10 (25.00%) SAS

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 10 (25.00%) SAS
Applications
1 20 (50.00%) MS Excel
Cloud Services
1 14 (35.00%) Microsoft Azure
Communications & Networking
1 1 (2.50%) Extranet
1 1 (2.50%) Firewall
1 1 (2.50%) Intranet
Database & Business Intelligence
1 27 (67.50%) SQL Server
2 26 (65.00%) SQL Server Analysis Services
3 24 (60.00%) Hadoop
3 24 (60.00%) SQL Server 2012
3 24 (60.00%) SQL Server 2014
4 23 (57.50%) Data Warehouse
5 18 (45.00%) SQL Server Integration Services
6 16 (40.00%) NoSQL
7 15 (37.50%) OLAP Cube
8 14 (35.00%) SQL Server 2016
8 14 (35.00%) SQL Server Reporting Services
9 13 (32.50%) Big Data
10 12 (30.00%) SQL Server 2005
11 11 (27.50%) Power BI
11 11 (27.50%) PowerPivot
12 10 (25.00%) Base SAS
12 10 (25.00%) Data Mining
12 10 (25.00%) SAS Enterprise Guide
13 7 (17.50%) SAS EBI
14 3 (7.50%) OLTP
Development Applications
1 2 (5.00%) ERwin
General
1 9 (22.50%) Finance
2 1 (2.50%) Games
Job Titles
1 24 (60.00%) Developer
2 21 (52.50%) SQL Developer
2 21 (52.50%) SQL Server Developer
3 13 (32.50%) SSIS Developer
4 11 (27.50%) Azure Developer
4 11 (27.50%) Business Intelligence Developer
4 11 (27.50%) NoSQL Developer
5 10 (25.00%) ETL Developer
6 8 (20.00%) Business Developer
6 8 (20.00%) Consultant
6 8 (20.00%) OLAP Developer
6 8 (20.00%) SAS Consultant
6 8 (20.00%) SQL BI Developer
6 8 (20.00%) SQL Server BI Developer
6 8 (20.00%) SSAS Developer
7 3 (7.50%) Architect
8 2 (5.00%) Data Architect
8 2 (5.00%) Programmer
8 2 (5.00%) SAS Programmer
9 1 (2.50%) Security Architect
Libraries, Frameworks & Software Standards
1 1 (2.50%) .NET
1 1 (2.50%) REST
1 1 (2.50%) SOAP
1 1 (2.50%) WCF
1 1 (2.50%) WF
1 1 (2.50%) Windows Identity Foundation
1 1 (2.50%) XML
Miscellaneous
1 13 (32.50%) Data Integration
2 12 (30.00%) Analytical Skills
3 1 (2.50%) Data Protection Act
3 1 (2.50%) NHS
Operating Systems
1 8 (20.00%) Unix
Processes & Methodologies
1 35 (87.50%) Business Intelligence
2 28 (70.00%) ETL
3 13 (32.50%) Agile Software Development
4 11 (27.50%) Data Management
4 11 (27.50%) E-Commerce
5 8 (20.00%) ETL Development
6 3 (7.50%) Analytics
7 2 (5.00%) Dashboard Development
7 2 (5.00%) Data Modelling
7 2 (5.00%) Enterprise Modelling
7 2 (5.00%) Migration
7 2 (5.00%) SDLC
7 2 (5.00%) TOGAF
8 1 (2.50%) Business Continuity
8 1 (2.50%) Business Performance Management
8 1 (2.50%) Data Protection
8 1 (2.50%) Information Security
8 1 (2.50%) Performance Management
8 1 (2.50%) Predictive Analytics
8 1 (2.50%) Stakeholder Management
Programming Languages
1 29 (72.50%) SQL
2 2 (5.00%) SAS Macro
2 2 (5.00%) T-SQL
Qualifications
1 2 (5.00%) Microsoft Certification
Quality Assurance & Compliance
1 1 (2.50%) PCI DSS
Vendors
1 27 (67.50%) Microsoft
2 11 (27.50%) Splunk
2 11 (27.50%) Tableau
3 1 (2.50%) Cognos
3 1 (2.50%) Oracle
3 1 (2.50%) SAP
3 1 (2.50%) Teradata