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

3 months to
26 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 204 225 235
Rank change year-on-year
+21 +10
Permanent jobs citing OLAP 30 31 34
As % of all permanent IT jobs located in Yorkshire 0.52% 0.47% 0.46%
As % of the Database & Business Intelligence category 1.79% 1.47% 1.45%
Number of salaries quoted 29 24 32
Median salary £45,000 £45,000 £38,750
Median salary % change year-on-year
- +16.12%
90% offered a salary of more than £39,500 £35,050 £30,250
10% offered a salary of more than £56,000 £81,500 £47,350
UK excluding London median salary £48,750 £42,500 £42,500
% change year-on-year
+14.70% -
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
1679 2104 2350
As % of all permanent IT jobs located in Yorkshire 29.36% 31.91% 31.71%
Number of salaries quoted 1427 1767 1906
Median salary £42,500 £42,500 £38,250
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £30,000 £30,000 £27,500
10% offered a salary of more than £55,000 £52,500 £63,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +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 26 September 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 26 September 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 23 £45,000 - 1
South Yorkshire +8 1 £50,000 -47.36%
North Yorkshire +4 1 £37,500 +1.35% 1
East Yorkshire - 1 £23,000 -
OLAP
England

OLAP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 26 September 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 39 (75.00%) SQL Server
2 34 (65.38%) Business Intelligence
3 31 (59.62%) Microsoft
4 28 (53.85%) SQL Server Analysis Services
5 26 (50.00%) ETL
6 25 (48.08%) SQL Server 2012
6 25 (48.08%) OLAP Cube
7 24 (46.15%) SQL Server 2014
8 23 (44.23%) SQL
9 21 (40.38%) SQL Server Reporting Services
9 21 (40.38%) SQL Server 2016
10 19 (36.54%) Hadoop
11 17 (32.69%) Microsoft Azure
11 17 (32.69%) NoSQL
11 17 (32.69%) Data Warehouse
11 17 (32.69%) Big Data
12 16 (30.77%) MS Excel
13 14 (26.92%) Tableau
13 14 (26.92%) SQL Server Integration Services
14 13 (25.00%) Business Continuity
14 13 (25.00%) OLTP
14 13 (25.00%) Intranet
14 13 (25.00%) Extranet
14 13 (25.00%) Analytical Skills
15 11 (21.15%) SOA
15 11 (21.15%) Agile Software Development
15 11 (21.15%) SQL Server 2005
16 10 (19.23%) Data Integration
16 10 (19.23%) Continuous Improvement
16 10 (19.23%) Data Management

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%) SAS
2 2 (3.85%) SharePoint
Applications
1 16 (30.77%) MS Excel
Cloud Services
1 17 (32.69%) Microsoft Azure
2 1 (1.92%) Google Cloud Platform
Communications & Networking
1 13 (25.00%) Extranet
1 13 (25.00%) Intranet
2 5 (9.62%) Firewall
3 3 (5.77%) Skype
4 1 (1.92%) GPRS
Database & Business Intelligence
1 39 (75.00%) SQL Server
2 28 (53.85%) SQL Server Analysis Services
3 25 (48.08%) OLAP Cube
3 25 (48.08%) SQL Server 2012
4 24 (46.15%) SQL Server 2014
5 21 (40.38%) SQL Server 2016
5 21 (40.38%) SQL Server Reporting Services
6 19 (36.54%) Hadoop
7 17 (32.69%) Big Data
7 17 (32.69%) Data Warehouse
7 17 (32.69%) NoSQL
8 14 (26.92%) SQL Server Integration Services
9 13 (25.00%) OLTP
10 11 (21.15%) SQL Server 2005
11 7 (13.46%) Power BI
11 7 (13.46%) PowerPivot
12 4 (7.69%) PerformancePoint
12 4 (7.69%) SQL Server 2008
13 2 (3.85%) QlikView
13 2 (3.85%) Star Schema
Development Applications
1 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 24 (46.15%) Business Intelligence Developer
3 15 (28.85%) ETL Developer
4 13 (25.00%) Architect
5 11 (21.15%) SQL Developer
6 10 (19.23%) SSIS Developer
7 9 (17.31%) SQL Server Developer
8 7 (13.46%) Azure Developer
8 7 (13.46%) NoSQL Developer
9 6 (11.54%) Infrastructure Architect
10 4 (7.69%) Data Warehouse Developer
10 4 (7.69%) Security Architect
10 4 (7.69%) Senior Business Intelligence Developer
10 4 (7.69%) Senior Developer
11 3 (5.77%) Infrastructure Solutions Architect
11 3 (5.77%) IT Architect
11 3 (5.77%) Solutions Architect
11 3 (5.77%) Technical Architect
12 2 (3.85%) Infrastructure Technical Architect
12 2 (3.85%) Technical Infrastructure Architect
Libraries, Frameworks & Software Standards
1 5 (9.62%) XML
2 4 (7.69%) .NET
2 4 (7.69%) REST
2 4 (7.69%) SOAP
2 4 (7.69%) WCF
3 3 (5.77%) MDX
3 3 (5.77%) WF
3 3 (5.77%) Windows Identity Foundation
4 1 (1.92%) ASP.NET
4 1 (1.92%) ASP.NET MVC
4 1 (1.92%) CSS
4 1 (1.92%) D3.js
4 1 (1.92%) Ember.js
4 1 (1.92%) HTML
4 1 (1.92%) jQuery
4 1 (1.92%) JSON
4 1 (1.92%) Oracle GoldenGate
4 1 (1.92%) React
4 1 (1.92%) Ruby on Rails
4 1 (1.92%) Sass
Miscellaneous
1 13 (25.00%) Analytical Skills
2 10 (19.23%) Data Integration
3 6 (11.54%) Data Protection Act
4 3 (5.77%) Replication
5 1 (1.92%) CESG
5 1 (1.92%) Telematics
5 1 (1.92%) Visualisation
Operating Systems
1 1 (1.92%) Windows
Processes & Methodologies
1 34 (65.38%) Business Intelligence
2 26 (50.00%) ETL
3 13 (25.00%) Business Continuity
4 11 (21.15%) Agile Software Development
4 11 (21.15%) SOA
5 10 (19.23%) Continuous Improvement
5 10 (19.23%) Data Management
6 9 (17.31%) E-Commerce
6 9 (17.31%) Stakeholder Management
7 7 (13.46%) B2B
7 7 (13.46%) B2C
7 7 (13.46%) Dimensional Modelling
8 6 (11.54%) Data Protection
9 5 (9.62%) Enterprise Architecture
10 4 (7.69%) Information Security
10 4 (7.69%) Project Management
11 2 (3.85%) Business Transformation
11 2 (3.85%) Security Architecture
11 2 (3.85%) Stakeholder Engagement
11 2 (3.85%) TOGAF
Programming Languages
1 23 (44.23%) SQL
2 10 (19.23%) C#
2 10 (19.23%) Data Analysis Expressions (DAX)
3 8 (15.38%) T-SQL
4 1 (1.92%) CoffeeScript
4 1 (1.92%) JavaScript
4 1 (1.92%) PL/SQL
4 1 (1.92%) Ruby
4 1 (1.92%) SAS Macro
Qualifications
1 4 (7.69%) Degree
2 3 (5.77%) Microsoft Certification
3 1 (1.92%) CISSP
Quality Assurance & Compliance
1 2 (3.85%) PCI DSS
Vendors
1 31 (59.62%) Microsoft
2 14 (26.92%) Tableau
3 8 (15.38%) Splunk
4 1 (1.92%) Google
4 1 (1.92%) Oracle
Leeds, West Yorkshire
onezeero.
Salary: £45000 - £50000 per annum
Posted: 6 days ago
North Yorkshire
Redrock Consulting Ltd
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 4 days ago