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

3 months to
6 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 218 235 241
Rank change year-on-year
+17 +6
Permanent jobs citing OLAP 36 26 34
As % of all permanent IT jobs located in Yorkshire 0.58% 0.37% 0.46%
As % of the Database & Business Intelligence category 1.78% 1.11% 1.42%
Number of salaries quoted 20 17 30
Median salary £42,500 £32,500 £35,000
Median salary % change year-on-year
+30.76% -7.14%
90% offered a salary of more than £32,500 £29,000 £30,000
10% offered a salary of more than £65,000 £45,000 £55,250
UK excluding London median salary £46,000 £40,000 £42,250
% change year-on-year
+15.00% -5.32%
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
2028 2336 2402
As % of all permanent IT jobs located in Yorkshire 32.81% 33.13% 32.41%
Number of salaries quoted 1662 1975 2008
Median salary £40,000 £38,500 £37,500
Median salary % change year-on-year
+3.89% +2.66%
90% offered a salary of more than £30,000 £28,500 £27,500
10% offered a salary of more than £55,000 £50,000 £50,000
UK excluding London median salary £42,500 £40,500 £40,000
% change year-on-year
+4.93% +1.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 6 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 6 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 +17 29 £52,500 +31.25% 2
North Yorkshire +5 7 £32,500 +1.56% 1
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 6 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 55 (63.95%) Business Intelligence
2 54 (62.79%) Microsoft
2 54 (62.79%) SQL Server
3 53 (61.63%) ETL
4 51 (59.30%) SQL
5 47 (54.65%) SQL Server Analysis Services
6 42 (48.84%) SQL Server 2012
7 37 (43.02%) Data Warehouse
8 36 (41.86%) SQL Server 2014
9 35 (40.70%) Hadoop
10 32 (37.21%) OLAP Cube
11 31 (36.05%) SQL Server Integration Services
11 31 (36.05%) MS Excel
12 27 (31.40%) Agile Software Development
13 25 (29.07%) Data Integration
13 25 (29.07%) Analytical Skills
14 24 (27.91%) SQL Server Reporting Services
15 23 (26.74%) Splunk
15 23 (26.74%) Tableau
15 23 (26.74%) Finance
16 22 (25.58%) Data Management
17 18 (20.93%) NoSQL
17 18 (20.93%) SAS
18 17 (19.77%) ETL Development
19 16 (18.60%) SAS Enterprise Guide
19 16 (18.60%) OLTP
20 15 (17.44%) Data Mining
20 15 (17.44%) Base SAS
21 14 (16.28%) SOA
22 13 (15.12%) Intranet

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 18 (20.93%) SAS
2 4 (4.65%) SharePoint
Applications
1 31 (36.05%) MS Excel
Cloud Services
1 13 (15.12%) Microsoft Azure
Communications & Networking
1 13 (15.12%) Extranet
1 13 (15.12%) Intranet
2 1 (1.16%) SAN
Database & Business Intelligence
1 54 (62.79%) SQL Server
2 47 (54.65%) SQL Server Analysis Services
3 42 (48.84%) SQL Server 2012
4 37 (43.02%) Data Warehouse
5 36 (41.86%) SQL Server 2014
6 35 (40.70%) Hadoop
7 32 (37.21%) OLAP Cube
8 31 (36.05%) SQL Server Integration Services
9 24 (27.91%) SQL Server Reporting Services
10 18 (20.93%) NoSQL
11 16 (18.60%) OLTP
11 16 (18.60%) SAS Enterprise Guide
12 15 (17.44%) Base SAS
12 15 (17.44%) Data Mining
13 13 (15.12%) SQL Server 2016
14 12 (13.95%) Big Data
14 12 (13.95%) SQL Server 2005
15 10 (11.63%) Power BI
15 10 (11.63%) PowerPivot
15 10 (11.63%) SAS EBI
Development Applications
1 3 (3.49%) ERwin
2 2 (2.33%) JIRA
3 1 (1.16%) Team Foundation Server
General
1 23 (26.74%) Finance
2 3 (3.49%) Banking
3 1 (1.16%) Games
3 1 (1.16%) Retail
Job Titles
1 47 (54.65%) Developer
2 36 (41.86%) SQL Developer
3 35 (40.70%) SQL Server Developer
4 26 (30.23%) Business Intelligence Developer
5 23 (26.74%) Business Developer
6 21 (24.42%) ETL Developer
7 20 (23.26%) SQL BI Developer
7 20 (23.26%) SQL Server BI Developer
8 16 (18.60%) Architect
8 16 (18.60%) OLAP Developer
8 16 (18.60%) SSAS Developer
8 16 (18.60%) SSIS Developer
9 13 (15.12%) Infrastructure Architect
10 11 (12.79%) Consultant
10 11 (12.79%) SAS Consultant
11 10 (11.63%) Azure Developer
11 10 (11.63%) NoSQL Developer
12 5 (5.81%) Programmer
12 5 (5.81%) SAS Programmer
12 5 (5.81%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 8 (9.30%) REST
1 8 (9.30%) SOAP
1 8 (9.30%) WCF
1 8 (9.30%) XML
2 5 (5.81%) .NET
2 5 (5.81%) WF
2 5 (5.81%) Windows Identity Foundation
Miscellaneous
1 25 (29.07%) Analytical Skills
1 25 (29.07%) Data Integration
2 6 (6.98%) Data Protection Act
3 2 (2.33%) Credit Risk
4 1 (1.16%) NHS
Operating Systems
1 11 (12.79%) Unix
2 3 (3.49%) Windows
3 2 (2.33%) Windows Server
4 1 (1.16%) Windows Server 2012
Processes & Methodologies
1 55 (63.95%) Business Intelligence
2 53 (61.63%) ETL
3 27 (31.40%) Agile Software Development
4 22 (25.58%) Data Management
5 17 (19.77%) ETL Development
6 14 (16.28%) SOA
7 13 (15.12%) Business Continuity
8 10 (11.63%) E-Commerce
9 9 (10.47%) Stakeholder Management
10 8 (9.30%) Data Modelling
11 7 (8.14%) TOGAF
12 6 (6.98%) Analytics
12 6 (6.98%) Data Protection
13 5 (5.81%) Enterprise Architecture
13 5 (5.81%) Migration
13 5 (5.81%) Performance Management
13 5 (5.81%) SDLC
14 4 (4.65%) Business Analysis
14 4 (4.65%) Coaching
14 4 (4.65%) Dashboard Development
Programming Languages
1 51 (59.30%) SQL
2 11 (12.79%) T-SQL
3 4 (4.65%) SAS Macro
Qualifications
1 10 (11.63%) Microsoft Certification
2 4 (4.65%) MCAD
Vendors
1 54 (62.79%) Microsoft
2 23 (26.74%) Splunk
2 23 (26.74%) Tableau
3 1 (1.16%) Cognos
3 1 (1.16%) Oracle
3 1 (1.16%) SAP
3 1 (1.16%) Teradata
Sheffield
Computer Futures
Salary: competitive
Posted: Yesterday
York
Computer Futures
Salary: competitive
Posted: Yesterday
Sheffield
Churchill Frank International
Salary: £40000 - £45000 per annum + Lifestyle/Negotiable
Posted: 18 days ago
Leeds
Computer Futures
Salary: £39999 - £55000 per annum + bonus, home working
Posted: 22 days ago