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 20 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
20 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
England / Yorkshire
Rank 215 193 249
Rank change year-on-year
-22 +56
Permanent jobs citing OLAP 9 54 21
As % of all permanent IT jobs located in Yorkshire 0.17% 0.89% 0.30%
As % of the Database & Business Intelligence category 0.57% 2.51% 1.00%
Number of salaries quoted 6 41 19
Median salary £43,750 £42,500 £40,000
Median salary % change year-on-year
+2.94% +6.25%
90% offered a salary of more than £30,000 £35,500 £33,000
10% offered a salary of more than £55,000 £75,000 £47,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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
1582 2149 2104
As % of all permanent IT jobs located in Yorkshire 30.62% 35.57% 30.42%
Number of salaries quoted 1387 1735 1783
Median salary £41,000 £40,000 £40,000
Median salary % change year-on-year
+2.50% -
90% offered a salary of more than £31,500 £30,000 £27,500
10% offered a salary of more than £55,000 £50,000 £57,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 20 January 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 20 January 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 -15 8 £45,000 +5.88% 4
North Yorkshire -2 1 £37,500 -11.76%
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 20 January 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 34 (82.93%) Business Intelligence
2 31 (75.61%) OLAP Cube
3 29 (70.73%) SQL Server
4 28 (68.29%) ETL
5 24 (58.54%) Microsoft
6 23 (56.10%) SQL Server Analysis Services
7 22 (53.66%) SQL Server 2012
8 21 (51.22%) SQL Server 2014
9 20 (48.78%) Agile Software Development
10 19 (46.34%) Tableau
11 18 (43.90%) SQL Server 2016
12 16 (39.02%) Data Integration
12 16 (39.02%) Hadoop
12 16 (39.02%) Data Warehouse
12 16 (39.02%) C#
13 15 (36.59%) SQL
13 15 (36.59%) Big Data
13 15 (36.59%) Analytical Skills
14 14 (34.15%) Data Analysis Expressions (DAX)
14 14 (34.15%) Continuous Improvement
14 14 (34.15%) NoSQL
14 14 (34.15%) Microsoft Azure
14 14 (34.15%) Data Management
15 12 (29.27%) Splunk
16 8 (19.51%) SOA
17 7 (17.07%) Oracle
17 7 (17.07%) SQL Server Reporting Services
17 7 (17.07%) Oracle OLAP
18 6 (14.63%) Dimensional Modelling
18 6 (14.63%) Snowflake Schema

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 (9.76%) Oracle SOA Suite
2 2 (4.88%) SAS
2 2 (4.88%) SharePoint
Applications
1 4 (9.76%) MS Excel
Business Applications
1 1 (2.44%) Dynamics AX
Cloud Services
1 14 (34.15%) Microsoft Azure
2 4 (9.76%) Google Cloud Platform
Communications & Networking
1 2 (4.88%) Extranet
1 2 (4.88%) Intranet
2 1 (2.44%) Firewall
2 1 (2.44%) GPRS
2 1 (2.44%) Skype
Database & Business Intelligence
1 31 (75.61%) OLAP Cube
2 29 (70.73%) SQL Server
3 23 (56.10%) SQL Server Analysis Services
4 22 (53.66%) SQL Server 2012
5 21 (51.22%) SQL Server 2014
6 18 (43.90%) SQL Server 2016
7 16 (39.02%) Data Warehouse
7 16 (39.02%) Hadoop
8 15 (36.59%) Big Data
9 14 (34.15%) NoSQL
10 7 (17.07%) Oracle OLAP
10 7 (17.07%) SQL Server Reporting Services
11 6 (14.63%) Snowflake Schema
11 6 (14.63%) Star Schema
12 5 (12.20%) Oracle BI EE
12 5 (12.20%) QlikView
13 4 (9.76%) Oracle ODI
13 4 (9.76%) Qlik Sense
14 3 (7.32%) SQL Server 2005
14 3 (7.32%) SQL Server Integration Services
Development Applications
1 2 (4.88%) ERwin
1 2 (4.88%) Team Foundation Server
2 1 (2.44%) Jenkins
General
1 3 (7.32%) Finance
2 2 (4.88%) Manufacturing
2 2 (4.88%) Retail
3 1 (2.44%) Advertising
Job Titles
1 32 (78.05%) Developer
2 31 (75.61%) Business Intelligence Developer
3 19 (46.34%) ETL Developer
4 6 (14.63%) Business Developer
5 4 (9.76%) Analyst
6 3 (7.32%) Architect
6 3 (7.32%) Data Warehouse Developer
7 2 (4.88%) Lead Architect
7 2 (4.88%) Lead Solutions Architect
7 2 (4.88%) Oracle BI Developer
7 2 (4.88%) Oracle Data Warehouse Developer
7 2 (4.88%) Oracle Developer
7 2 (4.88%) SAP Analyst
7 2 (4.88%) SAP BW Analyst
7 2 (4.88%) Senior Business Intelligence Developer
7 2 (4.88%) Senior Developer
7 2 (4.88%) Senior ETL Developer
7 2 (4.88%) Solutions Architect
8 1 (2.44%) Junior Business Intelligence Developer
8 1 (2.44%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 4 (9.76%) Middleware
1 4 (9.76%) Oracle GoldenGate
1 4 (9.76%) XML
2 3 (7.32%) .NET
3 2 (4.88%) EDI
3 2 (4.88%) JSON
3 2 (4.88%) MDX
3 2 (4.88%) REST
3 2 (4.88%) SOAP
3 2 (4.88%) WCF
3 2 (4.88%) WF
3 2 (4.88%) Windows Identity Foundation
4 1 (2.44%) ASP.NET
4 1 (2.44%) ASP.NET MVC
4 1 (2.44%) D3.js
4 1 (2.44%) Ember.js
4 1 (2.44%) jQuery
4 1 (2.44%) React
4 1 (2.44%) Ruby on Rails
4 1 (2.44%) Sass
Miscellaneous
1 16 (39.02%) Data Integration
2 15 (36.59%) Analytical Skills
3 2 (4.88%) Data Protection Act
3 2 (4.88%) Visualisation
4 1 (2.44%) Replication
4 1 (2.44%) Telematics
Operating Systems
1 1 (2.44%) Windows
Processes & Methodologies
1 34 (82.93%) Business Intelligence
2 28 (68.29%) ETL
3 20 (48.78%) Agile Software Development
4 14 (34.15%) Continuous Improvement
4 14 (34.15%) Data Management
5 8 (19.51%) SOA
6 6 (14.63%) Dimensional Modelling
7 4 (9.76%) Data Modelling
8 3 (7.32%) Analytics
8 3 (7.32%) Continuous Integration
9 2 (4.88%) B2B
9 2 (4.88%) B2C
9 2 (4.88%) Coaching
9 2 (4.88%) Data Protection
9 2 (4.88%) Data Visualisation
9 2 (4.88%) E-Commerce
9 2 (4.88%) Information Architecture
9 2 (4.88%) Migration
9 2 (4.88%) Performance Management
9 2 (4.88%) Stakeholder Management
Programming Languages
1 16 (39.02%) C#
2 15 (36.59%) SQL
3 14 (34.15%) Data Analysis Expressions (DAX)
4 3 (7.32%) T-SQL
5 2 (4.88%) ABAP
5 2 (4.88%) PL/SQL
5 2 (4.88%) PowerShell
6 1 (2.44%) CoffeeScript
6 1 (2.44%) JavaScript
6 1 (2.44%) Ruby
Qualifications
1 1 (2.44%) Degree
Quality Assurance & Compliance
1 2 (4.88%) PCI DSS
Vendors
1 24 (58.54%) Microsoft
2 19 (46.34%) Tableau
3 12 (29.27%) Splunk
4 7 (17.07%) Oracle
5 4 (9.76%) Google
6 2 (4.88%) SAP
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + company bonus and benefits
Posted: 3 days ago
Leeds, West Yorkshire
Verticality Ltd
Salary: £40-45k DOE
Posted: Yesterday
Leeds
Progressive Recruitment
Salary: competitive
Posted: 2 days ago
Leeds
Progressive Recruitment
Salary: competitive
Posted: 7 days ago