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

Location
3 months to
29 Jun 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank - 69 -
Permanent jobs citing OLAP 0 1 0
As % of all permanent IT jobs located in Warrington - 0.19% -
As % of the Database & Business Intelligence category - 0.50% -
Number of salaries quoted 0 1 0
Average salary - £30,000 -
UK excluding London average salary £40,000 £42,500 £45,000
% change year-on-year
-5.88% -5.55%
OLAP
Cheshire

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

Database & Business Intelligence Category
Warrington
Permanent IT job ads with a match in the
Database & Business Intelligence category
212 199 122
As % of all permanent IT jobs located in Warrington 41.57% 38.49% 31.61%
Number of salaries quoted 200 160 109
Average salary £40,000 £39,000 £34,500
Average salary % change year-on-year
+2.56% +13.04%
90% offered a salary of more than £30,000 £27,500 £26,000
10% offered a salary of more than £45,000 £40,000 £55,000
UK excluding London average salary £42,000 £40,000 £38,000
% change year-on-year
+5.00% +5.26%

OLAP
Jobs Demand Trend in Warrington

This chart provides a 3-month moving total of permanent IT jobs citing OLAP across the Warrington region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Warrington

OLAP
Salary Trend in Warrington

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

OLAP Salary Trend in Warrington

OLAP
Top 30 Related IT Skills in Warrington

For the 6 months to 29 June 2015, IT jobs across the Warrington region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 11 (100.00%) SQL
1 11 (100.00%) SQL Server
1 11 (100.00%) Replication
1 11 (100.00%) SQL Server Reporting Services
1 11 (100.00%) OLAP Cube
2 10 (90.91%) T-SQL
3 9 (81.82%) Finance
3 9 (81.82%) SQL Server 2012
3 9 (81.82%) Clustering
4 8 (72.73%) SQL Server 2008
4 8 (72.73%) Capacity Planning
4 8 (72.73%) ETL
4 8 (72.73%) Microsoft
4 8 (72.73%) Performance Tuning
5 5 (45.45%) NHS
5 5 (45.45%) BCP
5 5 (45.45%) Disaster Recovery
5 5 (45.45%) Management Information System
5 5 (45.45%) Business Intelligence
5 5 (45.45%) CRM
5 5 (45.45%) Business Continuity Planning
5 5 (45.45%) ISO/IEC 27001
5 5 (45.45%) Business Continuity
5 5 (45.45%) Business Analysis
5 5 (45.45%) Dynamics NAV
5 5 (45.45%) Dynamics CRM
6 4 (36.36%) Degree
7 3 (27.27%) SQL Server Analysis Services
7 3 (27.27%) Data Warehouse
7 3 (27.27%) MS Excel

OLAP
Top Related IT Skills in Warrington by Category

For the 6 months to 29 June 2015, IT jobs across the Warrington region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Applications
1 3 (27.27%) MS Excel
Business Applications
1 5 (45.45%) Dynamics NAV
1 5 (45.45%) Dynamics CRM
Database & Business Intelligence
1 11 (100.00%) SQL Server
1 11 (100.00%) SQL Server Reporting Services
1 11 (100.00%) OLAP Cube
2 9 (81.82%) SQL Server 2012
3 8 (72.73%) SQL Server 2008
4 3 (27.27%) SQL Server Analysis Services
4 3 (27.27%) Data Warehouse
5 1 (9.09%) SQL Server Integration Services
General
1 9 (81.82%) Finance
Job Titles
1 11 (100.00%) DBA
2 10 (90.91%) SQL DBA
3 3 (27.27%) Administrator
3 3 (27.27%) SQL Server DBA
4 2 (18.18%) SQL Developer
4 2 (18.18%) Developer
Miscellaneous
1 11 (100.00%) Replication
2 9 (81.82%) Clustering
3 5 (45.45%) NHS
3 5 (45.45%) Management Information System
Processes & Methodologies
1 8 (72.73%) ETL
1 8 (72.73%) Capacity Planning
1 8 (72.73%) Performance Tuning
2 5 (45.45%) CRM
2 5 (45.45%) Business Continuity Planning
2 5 (45.45%) Business Intelligence
2 5 (45.45%) BCP
2 5 (45.45%) Disaster Recovery
2 5 (45.45%) Business Continuity
2 5 (45.45%) Business Analysis
Programming Languages
1 11 (100.00%) SQL
2 10 (90.91%) T-SQL
Qualifications
1 4 (36.36%) Degree
2 3 (27.27%) Microsoft Certification
Quality Assurance & Compliance
1 5 (45.45%) ISO/IEC 27001
Vendors
1 8 (72.73%) Microsoft