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

3 months to
27 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 211 215 234
Rank change year-on-year
+4 +19
Permanent jobs citing OLAP 21 43 29
As % of all permanent IT jobs located in Yorkshire 0.38% 0.62% 0.41%
As % of the Database & Business Intelligence category 1.28% 1.80% 1.27%
Number of salaries quoted 18 38 25
Median salary £55,000 £45,000 £35,000
Median salary % change year-on-year
+22.22% +28.57%
90% offered a salary of more than £41,750 £32,000 £29,100
10% offered a salary of more than £81,500 £81,000 £46,500
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
1638 2393 2278
As % of all permanent IT jobs located in Yorkshire 29.60% 34.49% 32.44%
Number of salaries quoted 1373 2054 1899
Median salary £41,500 £40,000 £38,000
Median salary % change year-on-year
+3.75% +5.26%
90% offered a salary of more than £30,000 £30,000 £27,500
10% offered a salary of more than £55,000 £50,000 £60,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 27 July 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 27 July 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 +13 16 £79,000 +75.55% 1
South Yorkshire +8 1 £42,500 -55.26%
East Yorkshire - 1 £23,000 -
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 27 July 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 38 (64.41%) SQL Server
2 36 (61.02%) Microsoft
3 34 (57.63%) Business Intelligence
4 33 (55.93%) SQL
5 32 (54.24%) ETL
6 31 (52.54%) SQL Server Analysis Services
7 28 (47.46%) SQL Server Reporting Services
8 27 (45.76%) SQL Server Integration Services
9 25 (42.37%) MS Excel
10 23 (38.98%) SQL Server 2012
11 21 (35.59%) Data Warehouse
12 20 (33.90%) SQL Server 2014
13 18 (30.51%) OLTP
13 18 (30.51%) Hadoop
14 17 (28.81%) OLAP Cube
15 16 (27.12%) Business Continuity
15 16 (27.12%) Intranet
15 16 (27.12%) Extranet
16 14 (23.73%) SQL Server 2005
16 14 (23.73%) Microsoft Azure
16 14 (23.73%) NoSQL
16 14 (23.73%) SQL Server 2016
17 13 (22.03%) Big Data
17 13 (22.03%) SOA
17 13 (22.03%) T-SQL
17 13 (22.03%) Finance
18 11 (18.64%) E-Commerce
18 11 (18.64%) PowerPivot
18 11 (18.64%) Power BI
19 10 (16.95%) Analytical Skills

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 (6.78%) SAS
2 3 (5.08%) SharePoint
Applications
1 25 (42.37%) MS Excel
Cloud Services
1 14 (23.73%) Microsoft Azure
Communications & Networking
1 16 (27.12%) Extranet
1 16 (27.12%) Intranet
2 4 (6.78%) Firewall
3 2 (3.39%) Skype
Database & Business Intelligence
1 38 (64.41%) SQL Server
2 31 (52.54%) SQL Server Analysis Services
3 28 (47.46%) SQL Server Reporting Services
4 27 (45.76%) SQL Server Integration Services
5 23 (38.98%) SQL Server 2012
6 21 (35.59%) Data Warehouse
7 20 (33.90%) SQL Server 2014
8 18 (30.51%) Hadoop
8 18 (30.51%) OLTP
9 17 (28.81%) OLAP Cube
10 14 (23.73%) NoSQL
10 14 (23.73%) SQL Server 2005
10 14 (23.73%) SQL Server 2016
11 13 (22.03%) Big Data
12 11 (18.64%) Power BI
12 11 (18.64%) PowerPivot
13 4 (6.78%) Base SAS
13 4 (6.78%) Data Mining
13 4 (6.78%) SAS Enterprise Guide
14 3 (5.08%) PerformancePoint
Development Applications
1 2 (3.39%) ERwin
1 2 (3.39%) JIRA
General
1 13 (22.03%) Finance
2 1 (1.69%) Games
2 1 (1.69%) Manufacturing
Job Titles
1 36 (61.02%) Developer
2 26 (44.07%) SQL Developer
3 23 (38.98%) SQL Server Developer
4 18 (30.51%) Architect
4 18 (30.51%) SSIS Developer
5 15 (25.42%) Business Intelligence Developer
6 11 (18.64%) Azure Developer
6 11 (18.64%) NoSQL Developer
7 9 (15.25%) Business Developer
7 9 (15.25%) Infrastructure Architect
8 7 (11.86%) SQL BI Developer
8 7 (11.86%) SQL Server BI Developer
9 6 (10.17%) ETL Developer
10 5 (8.47%) SSAS Developer
10 5 (8.47%) T-SQL Developer
11 4 (6.78%) Infrastructure Solutions Architect
11 4 (6.78%) IT Architect
11 4 (6.78%) OLAP Developer
11 4 (6.78%) Security Architect
11 4 (6.78%) Solutions Architect
Libraries, Frameworks & Software Standards
1 6 (10.17%) REST
1 6 (10.17%) SOAP
1 6 (10.17%) WCF
1 6 (10.17%) XML
2 4 (6.78%) .NET
2 4 (6.78%) WF
2 4 (6.78%) Windows Identity Foundation
3 2 (3.39%) MDX
Miscellaneous
1 10 (16.95%) Analytical Skills
2 8 (13.56%) Data Protection Act
3 7 (11.86%) Data Integration
4 2 (3.39%) Replication
5 1 (1.69%) CESG
5 1 (1.69%) NHS
Operating Systems
1 2 (3.39%) Unix
Processes & Methodologies
1 34 (57.63%) Business Intelligence
2 32 (54.24%) ETL
3 16 (27.12%) Business Continuity
4 13 (22.03%) SOA
5 11 (18.64%) E-Commerce
6 9 (15.25%) Agile Software Development
6 9 (15.25%) Stakeholder Management
7 8 (13.56%) Data Protection
8 7 (11.86%) B2B
8 7 (11.86%) B2C
9 6 (10.17%) Data Modelling
9 6 (10.17%) Enterprise Architecture
10 5 (8.47%) Data Management
10 5 (8.47%) TOGAF
11 4 (6.78%) ETL Development
11 4 (6.78%) Information Security
11 4 (6.78%) SDLC
12 3 (5.08%) Business Analysis
12 3 (5.08%) Coaching
12 3 (5.08%) Performance Management
Programming Languages
1 33 (55.93%) SQL
2 13 (22.03%) T-SQL
3 2 (3.39%) SAS Macro
Qualifications
1 10 (16.95%) Microsoft Certification
2 3 (5.08%) Degree
2 3 (5.08%) MCAD
3 1 (1.69%) CISSP
Quality Assurance & Compliance
1 2 (3.39%) PCI DSS
Vendors
1 36 (61.02%) Microsoft
2 7 (11.86%) Tableau
3 5 (8.47%) Splunk
4 1 (1.69%) Cognos
4 1 (1.69%) Oracle
4 1 (1.69%) SAP
4 1 (1.69%) Teradata