The table below looks at the statistics for OLAP skills in IT jobs advertised for the Wales region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 26 June 2016 with a comparison to the same period over the previous 2 years.

3 months to
26 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 90 100 90
Rank change year-on-year
+10 -10
Permanent jobs citing OLAP 12 5 13
As % of all permanent IT jobs located in Wales 0.93% 0.35% 0.96%
As % of the Database & Business Intelligence category 3.41% 1.19% 3.85%
Number of salaries quoted 8 4 13
Median salary £33,750 £35,750 £37,500
Median salary % change year-on-year
-5.59% -4.66%
90% offered a salary of more than £22,200 £34,000 £27,500
10% offered a salary of more than £38,250 £40,125 £44,500
UK excluding London median salary £46,750 £40,000 £42,500
% change year-on-year
+16.87% -5.88%
OLAP
UK

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 Wales region.

Database & Business Intelligence Category
Wales
Permanent IT job ads with a match in the
Database & Business Intelligence category
352 420 338
As % of all permanent IT jobs located in Wales 27.31% 29.37% 24.87%
Number of salaries quoted 311 351 310
Median salary £38,500 £37,500 £35,000
Median salary % change year-on-year
+2.66% +7.14%
90% offered a salary of more than £25,000 £28,500 £25,000
10% offered a salary of more than £47,500 £47,500 £47,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 Wales

The demand trend of job ads across the Wales region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Wales

OLAP
Salary Trend in Wales

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the Wales region.

OLAP Salary Trend in Wales

OLAP
Salary Histogram in Wales

This chart provides a salary histogram for IT jobs citing OLAP across the Wales region over the 3 months to 26 June 2016.

OLAP Salary Histogram in Wales

OLAP
Job Locations in Wales

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Wales region over the 3 months to 26 June 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
South Wales +15 12 £33,750 -5.59%
OLAP
UK

OLAP
Top 30 Related IT Skills in Wales

For the 6 months to 26 June 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 Wales region with a requirement for OLAP.

1 25 (100.00%) Business Intelligence
2 23 (92.00%) SQL
3 21 (84.00%) SQL Server Analysis Services
4 19 (76.00%) SQL Server Integration Services
5 17 (68.00%) SQL Server
5 17 (68.00%) ETL
5 17 (68.00%) OLAP Cube
6 16 (64.00%) MDX
6 16 (64.00%) SQL Server Reporting Services
7 15 (60.00%) Data Warehouse
8 12 (48.00%) SQL Server 2012
9 11 (44.00%) Agile Software Development
9 11 (44.00%) MS Excel
9 11 (44.00%) Microsoft
10 7 (28.00%) TDD
11 6 (24.00%) T-SQL
12 5 (20.00%) SQL Server 2008
12 5 (20.00%) Hadoop
12 5 (20.00%) Big Data
13 4 (16.00%) Analytical Skills
13 4 (16.00%) Relational Database
13 4 (16.00%) Team Foundation Server
13 4 (16.00%) Visual Studio
13 4 (16.00%) OLTP
13 4 (16.00%) BusinessObjects
14 3 (12.00%) Advertising
14 3 (12.00%) Scrum
14 3 (12.00%) SharePoint
14 3 (12.00%) ITIL
14 3 (12.00%) PRINCE2

OLAP
Top Related IT Skills in Wales 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 (12.00%) SharePoint
2 1 (4.00%) SharePoint 2013
Applications
1 11 (44.00%) MS Excel
2 1 (4.00%) MS Office
Cloud Services
1 2 (8.00%) Microsoft Azure
Database & Business Intelligence
1 21 (84.00%) SQL Server Analysis Services
2 19 (76.00%) SQL Server Integration Services
3 17 (68.00%) OLAP Cube
3 17 (68.00%) SQL Server
4 16 (64.00%) SQL Server Reporting Services
5 15 (60.00%) Data Warehouse
6 12 (48.00%) SQL Server 2012
7 5 (20.00%) Big Data
7 5 (20.00%) Hadoop
7 5 (20.00%) SQL Server 2008
8 4 (16.00%) BusinessObjects
8 4 (16.00%) OLTP
8 4 (16.00%) Relational Database
9 3 (12.00%) Oracle OLAP
9 3 (12.00%) QlikView
10 2 (8.00%) Microsoft Analysis Services
11 1 (4.00%) DataStage
11 1 (4.00%) Microsoft Power View
11 1 (4.00%) SQL Server 2014
11 1 (4.00%) Star Schema
Development Applications
1 4 (16.00%) Team Foundation Server
1 4 (16.00%) Visual Studio
2 3 (12.00%) SQL Server Management Studio (SSMS)
General
1 3 (12.00%) Advertising
2 1 (4.00%) Finance
Job Titles
1 21 (84.00%) Developer
2 14 (56.00%) Database Developer
3 13 (52.00%) SQL Developer
4 12 (48.00%) SSAS Developer
5 10 (40.00%) Senior Database Developer
5 10 (40.00%) Senior Developer
6 9 (36.00%) SQL Database Developer
7 8 (32.00%) Business Intelligence Developer
8 7 (28.00%) Analyst
8 7 (28.00%) Business Intelligence Analyst
8 7 (28.00%) SSIS Developer
8 7 (28.00%) SSRS Developer
9 5 (20.00%) ETL Developer
9 5 (20.00%) Senior ETL Developer
9 5 (20.00%) Senior SQL Developer
9 5 (20.00%) SQL BI Developer
10 4 (16.00%) SQL Server Developer
11 3 (12.00%) Analyst Developer
11 3 (12.00%) T-SQL Developer
12 2 (8.00%) SQL Analyst
Libraries, Frameworks & Software Standards
1 16 (64.00%) MDX
2 1 (4.00%) Oracle Streams
Miscellaneous
1 4 (16.00%) Analytical Skills
2 3 (12.00%) Data Integration
3 2 (8.00%) Management Information System
Operating Systems
1 1 (4.00%) Windows
Processes & Methodologies
1 25 (100.00%) Business Intelligence
2 17 (68.00%) ETL
3 11 (44.00%) Agile Software Development
4 7 (28.00%) TDD
5 3 (12.00%) Inmon Methodology
5 3 (12.00%) ITIL
5 3 (12.00%) Kimball Methodology
5 3 (12.00%) PRINCE2
5 3 (12.00%) Scrum
6 1 (4.00%) Coaching
6 1 (4.00%) Content Management
6 1 (4.00%) Data Analysis
6 1 (4.00%) Data Migration
6 1 (4.00%) Data Transformation
6 1 (4.00%) Database Optimisation
6 1 (4.00%) Knowledge Management
6 1 (4.00%) Mentoring
6 1 (4.00%) Migration
6 1 (4.00%) Project Management
6 1 (4.00%) Service Delivery
Programming Languages
1 23 (92.00%) SQL
2 6 (24.00%) T-SQL
Qualifications
1 2 (8.00%) Degree
Quality Assurance & Compliance
1 3 (12.00%) QA
Vendors
1 11 (44.00%) Microsoft
2 3 (12.00%) Oracle
2 3 (12.00%) Tableau
3 1 (4.00%) IBM