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 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 207 193 240
Rank change year-on-year
-14 +47
Permanent jobs citing OLAP 19 47 35
As % of all permanent IT jobs located in Yorkshire 0.36% 0.75% 0.46%
As % of the Database & Business Intelligence category 1.19% 2.21% 1.47%
Number of salaries quoted 16 38 31
Median salary £45,000 £45,000 £43,500
Median salary % change year-on-year
- +3.44%
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
OLAP
England

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
1591 2130 2381
As % of all permanent IT jobs located in Yorkshire 30.02% 33.82% 31.53%
Number of salaries quoted 1419 1735 1973
Median salary £42,500 £40,000 £40,000
Median salary % change year-on-year
+6.25% -
90% offered a salary of more than £30,500 £30,000 £27,500
10% offered a salary of more than £55,000 £52,500 £55,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 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 3 December 2016.

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 3 December 2016. 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
(Click see detailed
statistics and trends)
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 -1 18 £45,000 -
South Yorkshire +2 1 £50,000 +11.11%
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

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

1 37 (71.15%) Business Intelligence
2 36 (69.23%) SQL Server
3 34 (65.38%) OLAP Cube
4 29 (55.77%) Microsoft
4 29 (55.77%) ETL
5 25 (48.08%) SQL Server Analysis Services
6 24 (46.15%) SQL Server 2012
7 23 (44.23%) SQL Server 2014
8 20 (38.46%) Tableau
9 19 (36.54%) Agile Software Development
9 19 (36.54%) SQL
10 18 (34.62%) SQL Server 2016
11 17 (32.69%) Analytical Skills
12 16 (30.77%) C#
12 16 (30.77%) Data Warehouse
12 16 (30.77%) Data Integration
12 16 (30.77%) Hadoop
13 15 (28.85%) Big Data
14 14 (26.92%) Continuous Improvement
14 14 (26.92%) NoSQL
14 14 (26.92%) Microsoft Azure
14 14 (26.92%) Data Management
14 14 (26.92%) Data Analysis Expressions (DAX)
15 12 (23.08%) SQL Server Reporting Services
15 12 (23.08%) Splunk
16 11 (21.15%) SOA
17 10 (19.23%) MS Excel
18 9 (17.31%) Intranet
18 9 (17.31%) Extranet
18 9 (17.31%) Business Continuity

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 3 (5.77%) Oracle SOA Suite
1 3 (5.77%) SAS
2 2 (3.85%) SharePoint
Applications
1 10 (19.23%) MS Excel
Cloud Services
1 14 (26.92%) Microsoft Azure
2 3 (5.77%) Google Cloud Platform
Communications & Networking
1 9 (17.31%) Extranet
1 9 (17.31%) Intranet
2 5 (9.62%) Firewall
3 3 (5.77%) Skype
4 1 (1.92%) GPRS
Database & Business Intelligence
1 36 (69.23%) SQL Server
2 34 (65.38%) OLAP Cube
3 25 (48.08%) SQL Server Analysis Services
4 24 (46.15%) SQL Server 2012
5 23 (44.23%) SQL Server 2014
6 18 (34.62%) SQL Server 2016
7 16 (30.77%) Data Warehouse
7 16 (30.77%) Hadoop
8 15 (28.85%) Big Data
9 14 (26.92%) NoSQL
10 12 (23.08%) SQL Server Reporting Services
11 9 (17.31%) OLTP
12 6 (11.54%) Oracle OLAP
13 5 (9.62%) Snowflake Schema
13 5 (9.62%) SQL Server Integration Services
13 5 (9.62%) Star Schema
14 4 (7.69%) PerformancePoint
14 4 (7.69%) QlikView
14 4 (7.69%) SQL Server 2005
14 4 (7.69%) SQL Server 2008
Development Applications
1 2 (3.85%) ERwin
1 2 (3.85%) Team Foundation Server
2 1 (1.92%) Jenkins
General
1 7 (13.46%) Finance
2 2 (3.85%) Retail
3 1 (1.92%) Manufacturing
Job Titles
1 36 (69.23%) Developer
2 33 (63.46%) Business Intelligence Developer
3 19 (36.54%) ETL Developer
4 10 (19.23%) Architect
5 5 (9.62%) Data Warehouse Developer
6 4 (7.69%) Business Developer
6 4 (7.69%) Security Architect
6 4 (7.69%) Senior Business Intelligence Developer
6 4 (7.69%) Senior Developer
7 3 (5.77%) Analyst
8 2 (3.85%) Business Architect
8 2 (3.85%) Enterprise Architect
8 2 (3.85%) Infrastructure Architect
8 2 (3.85%) Oracle BI Developer
8 2 (3.85%) Oracle Data Warehouse Developer
8 2 (3.85%) Oracle Developer
8 2 (3.85%) Senior Data Warehouse Developer
8 2 (3.85%) Senior ETL Developer
8 2 (3.85%) SQL Developer
8 2 (3.85%) Technical Architect
Libraries, Frameworks & Software Standards
1 5 (9.62%) XML
2 4 (7.69%) .NET
3 3 (5.77%) MDX
3 3 (5.77%) Middleware
3 3 (5.77%) Oracle GoldenGate
3 3 (5.77%) REST
3 3 (5.77%) SOAP
3 3 (5.77%) WCF
3 3 (5.77%) WF
3 3 (5.77%) Windows Identity Foundation
4 2 (3.85%) JSON
5 1 (1.92%) ASP.NET
5 1 (1.92%) ASP.NET MVC
5 1 (1.92%) CSS
5 1 (1.92%) D3.js
5 1 (1.92%) HTML
5 1 (1.92%) jQuery
5 1 (1.92%) React
5 1 (1.92%) Ruby on Rails
5 1 (1.92%) Sass
Miscellaneous
1 17 (32.69%) Analytical Skills
2 16 (30.77%) Data Integration
3 5 (9.62%) Data Protection Act
4 3 (5.77%) Replication
5 2 (3.85%) Visualisation
6 1 (1.92%) CESG
6 1 (1.92%) Telematics
Operating Systems
1 1 (1.92%) Windows
Processes & Methodologies
1 37 (71.15%) Business Intelligence
2 29 (55.77%) ETL
3 19 (36.54%) Agile Software Development
4 14 (26.92%) Continuous Improvement
4 14 (26.92%) Data Management
5 11 (21.15%) SOA
6 9 (17.31%) Business Continuity
7 8 (15.38%) Dimensional Modelling
8 7 (13.46%) B2B
8 7 (13.46%) B2C
9 5 (9.62%) Data Protection
9 5 (9.62%) Stakeholder Management
10 4 (7.69%) Information Security
10 4 (7.69%) Project Management
11 3 (5.77%) Analytics
11 3 (5.77%) Continuous Integration
11 3 (5.77%) Migration
12 2 (3.85%) Business Transformation
12 2 (3.85%) Enterprise Architecture
12 2 (3.85%) Mentoring
Programming Languages
1 19 (36.54%) SQL
2 16 (30.77%) C#
3 14 (26.92%) Data Analysis Expressions (DAX)
4 6 (11.54%) T-SQL
5 2 (3.85%) PL/SQL
5 2 (3.85%) PowerShell
6 1 (1.92%) ABAP
6 1 (1.92%) CoffeeScript
6 1 (1.92%) JavaScript
6 1 (1.92%) Ruby
6 1 (1.92%) SAS Macro
Qualifications
1 4 (7.69%) Degree
2 2 (3.85%) Microsoft Certification
3 1 (1.92%) CISSP
Quality Assurance & Compliance
1 2 (3.85%) PCI DSS
Vendors
1 29 (55.77%) Microsoft
2 20 (38.46%) Tableau
3 12 (23.08%) Splunk
4 6 (11.54%) Oracle
5 3 (5.77%) Google
6 1 (1.92%) SAP
Skipton, North Yorkshire
Redrock Consulting Ltd
Salary: £35000 - £40000 per annum + Good
Posted: Yesterday
Skipton, North Yorkshire
Modis International
Salary: £35000 - £40000 per annum
Posted: 2 days ago