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

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 226 211 232
Rank change year-on-year
-15 +21
Permanent jobs citing OLAP 21 47 38
As % of all permanent IT jobs located in Yorkshire 0.38% 0.69% 0.53%
As % of the Database & Business Intelligence category 1.23% 1.99% 1.63%
Number of salaries quoted 14 41 33
Median salary £71,250 £40,000 £35,000
Median salary % change year-on-year
+78.12% +14.28%
90% offered a salary of more than £42,500 £32,000 £30,000
10% offered a salary of more than £80,000 £70,000 £49,000
UK excluding London median salary £46,750 £40,000 £42,624
% change year-on-year
+16.87% -6.15%
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
1703 2361 2329
As % of all permanent IT jobs located in Yorkshire 30.42% 34.69% 32.51%
Number of salaries quoted 1402 2039 1943
Median salary £40,000 £40,000 £38,000
Median salary % change year-on-year
- +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 £57,500
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 1 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 1 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 +17 20 £77,500 +72.22%
South Yorkshire +16 1 £42,500 -41.37%
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 1 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 41 (61.19%) SQL
1 41 (61.19%) SQL Server
1 41 (61.19%) Business Intelligence
2 40 (59.70%) Microsoft
3 37 (55.22%) ETL
4 36 (53.73%) SQL Server Analysis Services
5 28 (41.79%) Data Warehouse
5 28 (41.79%) SQL Server Integration Services
6 27 (40.30%) SQL Server 2012
7 25 (37.31%) SQL Server Reporting Services
7 25 (37.31%) MS Excel
7 25 (37.31%) SQL Server 2014
8 23 (34.33%) Hadoop
9 21 (31.34%) Finance
10 19 (28.36%) OLAP Cube
11 18 (26.87%) OLTP
12 16 (23.88%) Intranet
12 16 (23.88%) Extranet
12 16 (23.88%) Business Continuity
13 15 (22.39%) NoSQL
13 15 (22.39%) SOA
14 14 (20.90%) Agile Software Development
14 14 (20.90%) Microsoft Azure
14 14 (20.90%) SQL Server 2005
14 14 (20.90%) SQL Server 2016
14 14 (20.90%) Analytical Skills
15 13 (19.40%) Big Data
15 13 (19.40%) T-SQL
16 12 (17.91%) Data Integration
17 11 (16.42%) PowerPivot

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 10 (14.93%) SAS
2 3 (4.48%) SharePoint
Applications
1 25 (37.31%) MS Excel
Cloud Services
1 14 (20.90%) Microsoft Azure
Communications & Networking
1 16 (23.88%) Extranet
1 16 (23.88%) Intranet
2 4 (5.97%) Firewall
3 2 (2.99%) Skype
Database & Business Intelligence
1 41 (61.19%) SQL Server
2 36 (53.73%) SQL Server Analysis Services
3 28 (41.79%) Data Warehouse
3 28 (41.79%) SQL Server Integration Services
4 27 (40.30%) SQL Server 2012
5 25 (37.31%) SQL Server 2014
5 25 (37.31%) SQL Server Reporting Services
6 23 (34.33%) Hadoop
7 19 (28.36%) OLAP Cube
8 18 (26.87%) OLTP
9 15 (22.39%) NoSQL
10 14 (20.90%) SQL Server 2005
10 14 (20.90%) SQL Server 2016
11 13 (19.40%) Big Data
12 11 (16.42%) Power BI
12 11 (16.42%) PowerPivot
13 10 (14.93%) Base SAS
13 10 (14.93%) Data Mining
13 10 (14.93%) SAS Enterprise Guide
14 7 (10.45%) SAS EBI
Development Applications
1 2 (2.99%) ERwin
1 2 (2.99%) JIRA
2 1 (1.49%) Team Foundation Server
General
1 21 (31.34%) Finance
2 1 (1.49%) Games
2 1 (1.49%) Manufacturing
Job Titles
1 37 (55.22%) Developer
2 30 (44.78%) SQL Developer
3 28 (41.79%) SQL Server Developer
4 19 (28.36%) SSIS Developer
5 18 (26.87%) Architect
6 16 (23.88%) Business Intelligence Developer
7 13 (19.40%) Business Developer
8 11 (16.42%) Azure Developer
8 11 (16.42%) ETL Developer
8 11 (16.42%) NoSQL Developer
8 11 (16.42%) SQL BI Developer
8 11 (16.42%) SQL Server BI Developer
9 10 (14.93%) Infrastructure Architect
10 9 (13.43%) SSAS Developer
11 8 (11.94%) Consultant
11 8 (11.94%) OLAP Developer
11 8 (11.94%) SAS Consultant
12 6 (8.96%) T-SQL Developer
13 4 (5.97%) Security Architect
13 4 (5.97%) Solutions Architect
Libraries, Frameworks & Software Standards
1 7 (10.45%) REST
1 7 (10.45%) SOAP
1 7 (10.45%) WCF
1 7 (10.45%) XML
2 5 (7.46%) .NET
2 5 (7.46%) WF
2 5 (7.46%) Windows Identity Foundation
3 1 (1.49%) MDX
Miscellaneous
1 14 (20.90%) Analytical Skills
2 12 (17.91%) Data Integration
3 8 (11.94%) Data Protection Act
4 1 (1.49%) CESG
4 1 (1.49%) NHS
4 1 (1.49%) Replication
4 1 (1.49%) Smartphone
Operating Systems
1 8 (11.94%) Unix
2 1 (1.49%) Windows
2 1 (1.49%) Windows Server 2012
Processes & Methodologies
1 41 (61.19%) Business Intelligence
2 37 (55.22%) ETL
3 16 (23.88%) Business Continuity
4 15 (22.39%) SOA
5 14 (20.90%) Agile Software Development
6 11 (16.42%) E-Commerce
7 10 (14.93%) Data Management
8 8 (11.94%) Data Protection
8 8 (11.94%) ETL Development
8 8 (11.94%) Stakeholder Management
9 7 (10.45%) Data Modelling
10 6 (8.96%) B2B
10 6 (8.96%) B2C
11 5 (7.46%) Enterprise Architecture
11 5 (7.46%) TOGAF
12 4 (5.97%) Information Security
12 4 (5.97%) SDLC
13 3 (4.48%) Business Analysis
13 3 (4.48%) Coaching
13 3 (4.48%) Performance Management
Programming Languages
1 41 (61.19%) SQL
2 13 (19.40%) T-SQL
3 2 (2.99%) SAS Macro
Qualifications
1 10 (14.93%) Microsoft Certification
2 3 (4.48%) MCAD
3 2 (2.99%) Degree
4 1 (1.49%) CISSP
Quality Assurance & Compliance
1 2 (2.99%) PCI DSS
Vendors
1 40 (59.70%) Microsoft
2 11 (16.42%) Tableau
3 10 (14.93%) Splunk
4 1 (1.49%) Cognos
4 1 (1.49%) Oracle
4 1 (1.49%) SAP
4 1 (1.49%) Teradata
Yorkshire
Lawrence Harvey
Salary: £40000 - £55000 per annum
Posted: 3 days ago
North Yorkshire
Lawrence Harvey Enterprise
Salary: £40000 - £55000 per annum
Posted: 3 days ago