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

3 months to
30 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 225 223 225
Rank change year-on-year
-2 +2
Permanent jobs citing OLAP 25 35 38
As % of all permanent IT jobs located in Yorkshire 0.43% 0.52% 0.52%
As % of the Database & Business Intelligence category 1.36% 1.56% 1.57%
Number of salaries quoted 13 29 35
Median salary £42,500 £38,500 £35,000
Median salary % change year-on-year
+10.38% +10.00%
90% offered a salary of more than £32,500 £30,000 £30,000
10% offered a salary of more than £65,000 £60,000 £55,000
UK excluding London median salary £45,500 £40,000 £42,500
% change year-on-year
+13.75% -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
1840 2250 2428
As % of all permanent IT jobs located in Yorkshire 31.81% 33.39% 32.91%
Number of salaries quoted 1498 1919 2066
Median salary £40,000 £40,000 £37,500
Median salary % change year-on-year
- +6.66%
90% offered a salary of more than £30,000 £30,000 £28,000
10% offered a salary of more than £55,000 £50,000 £55,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 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 30 May 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 30 May 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 +14 19 £63,750 +50.00% 1
North Yorkshire -2 5 £32,500 +1.56% 1
South Yorkshire +18 1 £42,500 +47.82% 2
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 30 May 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 51 (67.11%) SQL Server
1 51 (67.11%) Microsoft
2 50 (65.79%) Business Intelligence
2 50 (65.79%) SQL
3 47 (61.84%) ETL
4 45 (59.21%) SQL Server Analysis Services
5 38 (50.00%) SQL Server 2012
6 37 (48.68%) Data Warehouse
7 33 (43.42%) SQL Server 2014
8 32 (42.11%) Hadoop
8 32 (42.11%) SQL Server Integration Services
9 29 (38.16%) MS Excel
10 28 (36.84%) OLAP Cube
11 25 (32.89%) SQL Server Reporting Services
12 23 (30.26%) Agile Software Development
13 22 (28.95%) Finance
14 21 (27.63%) Data Integration
14 21 (27.63%) Analytical Skills
15 19 (25.00%) Tableau
15 19 (25.00%) NoSQL
15 19 (25.00%) Splunk
16 18 (23.68%) Data Management
17 14 (18.42%) Microsoft Azure
17 14 (18.42%) SAS
17 14 (18.42%) SQL Server 2016
18 13 (17.11%) Data Mining
18 13 (17.11%) OLTP
18 13 (17.11%) Base SAS
18 13 (17.11%) SAS Enterprise Guide
18 13 (17.11%) SQL Server 2005

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 14 (18.42%) SAS
2 4 (5.26%) SharePoint
Applications
1 29 (38.16%) MS Excel
Cloud Services
1 14 (18.42%) Microsoft Azure
Communications & Networking
1 11 (14.47%) Extranet
1 11 (14.47%) Intranet
2 1 (1.32%) SAN
Database & Business Intelligence
1 51 (67.11%) SQL Server
2 45 (59.21%) SQL Server Analysis Services
3 38 (50.00%) SQL Server 2012
4 37 (48.68%) Data Warehouse
5 33 (43.42%) SQL Server 2014
6 32 (42.11%) Hadoop
6 32 (42.11%) SQL Server Integration Services
7 28 (36.84%) OLAP Cube
8 25 (32.89%) SQL Server Reporting Services
9 19 (25.00%) NoSQL
10 14 (18.42%) SQL Server 2016
11 13 (17.11%) Base SAS
11 13 (17.11%) Big Data
11 13 (17.11%) Data Mining
11 13 (17.11%) OLTP
11 13 (17.11%) SAS Enterprise Guide
11 13 (17.11%) SQL Server 2005
12 11 (14.47%) Power BI
12 11 (14.47%) PowerPivot
13 10 (13.16%) SAS EBI
Development Applications
1 2 (2.63%) ERwin
1 2 (2.63%) JIRA
2 1 (1.32%) Team Foundation Server
General
1 22 (28.95%) Finance
2 1 (1.32%) Banking
2 1 (1.32%) Games
2 1 (1.32%) Manufacturing
2 1 (1.32%) Retail
Job Titles
1 43 (56.58%) Developer
2 34 (44.74%) SQL Developer
3 32 (42.11%) SQL Server Developer
4 22 (28.95%) Business Intelligence Developer
5 19 (25.00%) Business Developer
6 18 (23.68%) SSIS Developer
7 17 (22.37%) ETL Developer
8 16 (21.05%) SQL BI Developer
8 16 (21.05%) SQL Server BI Developer
9 13 (17.11%) Architect
9 13 (17.11%) SSAS Developer
10 12 (15.79%) OLAP Developer
11 11 (14.47%) Azure Developer
11 11 (14.47%) Consultant
11 11 (14.47%) Infrastructure Architect
11 11 (14.47%) NoSQL Developer
11 11 (14.47%) SAS Consultant
12 6 (7.89%) T-SQL Developer
13 4 (5.26%) Infrastructure Solutions Architect
13 4 (5.26%) Solutions Architect
Libraries, Frameworks & Software Standards
1 7 (9.21%) REST
1 7 (9.21%) SOAP
1 7 (9.21%) WCF
1 7 (9.21%) XML
2 5 (6.58%) .NET
2 5 (6.58%) WF
2 5 (6.58%) Windows Identity Foundation
Miscellaneous
1 21 (27.63%) Analytical Skills
1 21 (27.63%) Data Integration
2 4 (5.26%) Data Protection Act
3 1 (1.32%) Credit Risk
3 1 (1.32%) NHS
3 1 (1.32%) Smartphone
Operating Systems
1 11 (14.47%) Unix
2 2 (2.63%) Windows
3 1 (1.32%) Windows Server
3 1 (1.32%) Windows Server 2012
Processes & Methodologies
1 50 (65.79%) Business Intelligence
2 47 (61.84%) ETL
3 23 (30.26%) Agile Software Development
4 18 (23.68%) Data Management
5 13 (17.11%) ETL Development
6 12 (15.79%) SOA
7 11 (14.47%) Business Continuity
7 11 (14.47%) E-Commerce
8 8 (10.53%) Data Modelling
9 7 (9.21%) Stakeholder Management
10 6 (7.89%) Analytics
11 5 (6.58%) Migration
11 5 (6.58%) TOGAF
12 4 (5.26%) Business Analysis
12 4 (5.26%) Data Protection
12 4 (5.26%) Enterprise Architecture
12 4 (5.26%) Performance Management
12 4 (5.26%) SDLC
13 3 (3.95%) Coaching
14 2 (2.63%) Dashboard Development
Programming Languages
1 50 (65.79%) SQL
2 12 (15.79%) T-SQL
3 2 (2.63%) SAS Macro
Qualifications
1 10 (13.16%) Microsoft Certification
2 4 (5.26%) MCAD
Vendors
1 51 (67.11%) Microsoft
2 19 (25.00%) Splunk
2 19 (25.00%) Tableau
3 1 (1.32%) Cognos
3 1 (1.32%) Oracle
3 1 (1.32%) SAP
3 1 (1.32%) Teradata
Leeds, West Yorkshire
CoreCom Consulting
Salary: £35000 - £45000 per annum + Benefits
Posted: 2 days ago
York
Computer Futures
Salary: competitive
Posted: 25 days ago
Sheffield
Computer Futures
Salary: competitive
Posted: 25 days ago
Sheffield
Churchill Frank International
Salary: £40000 - £45000 per annum + Lifestyle/Negotiable
Posted: 11 days ago