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

3 months to
19 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
England / Yorkshire
Rank 210 204 246
Rank change year-on-year
-6 +42
Permanent jobs citing OLAP 12 50 17
As % of all permanent IT jobs located in Yorkshire 0.23% 0.78% 0.23%
As % of the Database & Business Intelligence category 0.75% 2.22% 0.76%
Number of salaries quoted 9 37 15
Median salary £42,500 £42,500 £40,000
Median salary % change year-on-year
- +6.25%
90% offered a salary of more than £34,500 £36,600 £33,800
10% offered a salary of more than £49,000 £75,000 £45,900
UK excluding London median salary £45,000 £45,000 £40,000
% change year-on-year
- +12.50%

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

Database & Business Intelligence Category
Yorkshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1594 2256 2236
As % of all permanent IT jobs located in Yorkshire 30.79% 35.06% 30.79%
Number of salaries quoted 1365 1856 1925
Median salary £40,000 £40,000 £40,000
90% offered a salary of more than £30,000 £30,000 £27,500
10% offered a salary of more than £52,500 £50,000 £57,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in Yorkshire

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

OLAP Jobs Demand Trend in Yorkshire

OLAP
Salary Trend in Yorkshire

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

OLAP Salary Trend in Yorkshire

OLAP
Salary Histogram in Yorkshire

This chart provides a salary histogram for IT jobs citing OLAP across the Yorkshire region over the 3 months to 19 February 2017.

OLAP Salary Histogram in Yorkshire

OLAP
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Yorkshire region over the 3 months to 19 February 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
West Yorkshire -3 10 £42,500 - 4
North Yorkshire +7 2 £40,000 -5.88%
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 19 February 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 Yorkshire region with a requirement for OLAP.

1 26 (72.22%) Business Intelligence
2 22 (61.11%) ETL
2 22 (61.11%) OLAP Cube
3 20 (55.56%) SQL Server
4 17 (47.22%) Data Warehouse
4 17 (47.22%) Microsoft
4 17 (47.22%) SQL Server Analysis Services
5 15 (41.67%) SQL Server 2012
5 15 (41.67%) Agile Software Development
6 14 (38.89%) Tableau
6 14 (38.89%) SQL Server 2014
7 13 (36.11%) Big Data
7 13 (36.11%) SQL
8 11 (30.56%) C#
8 11 (30.56%) Data Integration
8 11 (30.56%) Hadoop
8 11 (30.56%) SQL Server 2016
9 10 (27.78%) Analytical Skills
9 10 (27.78%) Data Management
10 9 (25.00%) Microsoft Azure
10 9 (25.00%) Data Analysis Expressions (DAX)
10 9 (25.00%) Splunk
10 9 (25.00%) Continuous Improvement
10 9 (25.00%) NoSQL
11 8 (22.22%) Oracle OLAP
11 8 (22.22%) SOA
11 8 (22.22%) Oracle
12 6 (16.67%) Snowflake Schema
12 6 (16.67%) Star Schema
12 6 (16.67%) SQL Server Reporting Services

OLAP
Top Related IT Skills in Yorkshire 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 (11.11%) Oracle SOA Suite
2 1 (2.78%) SAS
2 1 (2.78%) SharePoint
Applications
1 3 (8.33%) MS Excel
Business Applications
1 1 (2.78%) Dynamics AX
Cloud Services
1 9 (25.00%) Microsoft Azure
2 4 (11.11%) Google Cloud Platform
Communications & Networking
1 2 (5.56%) Extranet
1 2 (5.56%) Intranet
2 1 (2.78%) Firewall
2 1 (2.78%) GPRS
2 1 (2.78%) Skype
Database & Business Intelligence
1 22 (61.11%) OLAP Cube
2 20 (55.56%) SQL Server
3 17 (47.22%) Data Warehouse
3 17 (47.22%) SQL Server Analysis Services
4 15 (41.67%) SQL Server 2012
5 14 (38.89%) SQL Server 2014
6 13 (36.11%) Big Data
7 11 (30.56%) Hadoop
7 11 (30.56%) SQL Server 2016
8 9 (25.00%) NoSQL
9 8 (22.22%) Oracle OLAP
10 6 (16.67%) Snowflake Schema
10 6 (16.67%) SQL Server Reporting Services
10 6 (16.67%) Star Schema
11 5 (13.89%) BusinessObjects
11 5 (13.89%) Oracle BI EE
11 5 (13.89%) QlikView
12 4 (11.11%) Oracle ODI
12 4 (11.11%) SAP BW
12 4 (11.11%) SAP HANA
Development Applications
1 2 (5.56%) ERwin
1 2 (5.56%) Team Foundation Server
2 1 (2.78%) Jenkins
General
1 4 (11.11%) Manufacturing
2 3 (8.33%) Finance
3 2 (5.56%) Advertising
3 2 (5.56%) Retail
Job Titles
1 24 (66.67%) Developer
2 22 (61.11%) Business Intelligence Developer
3 12 (33.33%) ETL Developer
4 6 (16.67%) Analyst
4 6 (16.67%) Business Developer
5 4 (11.11%) Architect
5 4 (11.11%) SAP Analyst
5 4 (11.11%) SAP BW Analyst
6 3 (8.33%) Data Warehouse Developer
6 3 (8.33%) Senior Developer
7 2 (5.56%) Data Architect
7 2 (5.56%) Lead Architect
7 2 (5.56%) Lead Solutions Architect
7 2 (5.56%) Oracle BI Developer
7 2 (5.56%) Oracle Data Warehouse Developer
7 2 (5.56%) Oracle Developer
7 2 (5.56%) Senior Business Intelligence Developer
7 2 (5.56%) Senior ETL Developer
7 2 (5.56%) Solutions Architect
8 1 (2.78%) SQL Support Analyst
Libraries, Frameworks & Software Standards
1 4 (11.11%) Middleware
1 4 (11.11%) Oracle GoldenGate
1 4 (11.11%) XML
2 3 (8.33%) .NET
2 3 (8.33%) MDX
3 2 (5.56%) EDI
3 2 (5.56%) JSON
3 2 (5.56%) REST
3 2 (5.56%) SOAP
3 2 (5.56%) WCF
3 2 (5.56%) WF
3 2 (5.56%) Windows Identity Foundation
4 1 (2.78%) ASP.NET
4 1 (2.78%) ASP.NET MVC
4 1 (2.78%) D3.js
4 1 (2.78%) Ember.js
4 1 (2.78%) jQuery
4 1 (2.78%) React
4 1 (2.78%) Ruby on Rails
4 1 (2.78%) Sass
Miscellaneous
1 11 (30.56%) Data Integration
2 10 (27.78%) Analytical Skills
3 2 (5.56%) Data Protection Act
3 2 (5.56%) Visualisation
4 1 (2.78%) Replication
4 1 (2.78%) Telematics
Operating Systems
1 1 (2.78%) Windows
Processes & Methodologies
1 26 (72.22%) Business Intelligence
2 22 (61.11%) ETL
3 15 (41.67%) Agile Software Development
4 10 (27.78%) Data Management
5 9 (25.00%) Continuous Improvement
6 8 (22.22%) SOA
7 5 (13.89%) Data Modelling
8 4 (11.11%) Dimensional Modelling
9 3 (8.33%) Analytics
9 3 (8.33%) Continuous Integration
10 2 (5.56%) B2B
10 2 (5.56%) B2C
10 2 (5.56%) Business Continuity
10 2 (5.56%) Coaching
10 2 (5.56%) CRM
10 2 (5.56%) Data Protection
10 2 (5.56%) Data Visualisation
10 2 (5.56%) Information Architecture
10 2 (5.56%) Migration
10 2 (5.56%) Performance Management
Programming Languages
1 13 (36.11%) SQL
2 11 (30.56%) C#
3 9 (25.00%) Data Analysis Expressions (DAX)
4 4 (11.11%) ABAP
4 4 (11.11%) T-SQL
5 2 (5.56%) PL/SQL
5 2 (5.56%) PowerShell
6 1 (2.78%) CoffeeScript
6 1 (2.78%) JavaScript
6 1 (2.78%) Ruby
Qualifications
1 1 (2.78%) Degree
Quality Assurance & Compliance
1 2 (5.56%) PCI DSS
Vendors
1 17 (47.22%) Microsoft
2 14 (38.89%) Tableau
3 9 (25.00%) Splunk
4 8 (22.22%) Oracle
5 4 (11.11%) Google
5 4 (11.11%) SAP
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + package
Posted: 2 days ago
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + company package
Posted: 4 days ago
Leeds, West Yorkshire
Spring Technology
Salary: £40000.00 - £45000.00 per annum
Posted: 4 days ago
Leeds, West Yorkshire
Verticality Ltd
Salary: £40-45k DOE
Posted: 4 days ago