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

3 months to
25 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 85 120 124
Rank change year-on-year
+35 +4
Permanent jobs citing OLAP 5 3 5
As % of all permanent IT jobs located in Cheshire 0.50% 0.17% 0.28%
As % of the Database & Business Intelligence category 1.76% 0.49% 0.76%
Number of salaries quoted 5 3 4
Median salary £28,500 £45,000 £36,250
Median salary % change year-on-year
-36.66% +24.13%
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
OLAP
North West

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

Database & Business Intelligence Category
Cheshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
284 609 656
As % of all permanent IT jobs located in Cheshire 28.34% 34.86% 37.21%
Number of salaries quoted 254 498 526
Median salary £37,500 £40,000 £37,500
Median salary % change year-on-year
-6.25% +6.66%
90% offered a salary of more than £27,500 £32,500 £30,000
10% offered a salary of more than £47,500 £52,500 £47,500
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

OLAP
Jobs Demand Trend in Cheshire

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

OLAP Jobs Demand Trend in Cheshire

OLAP
Salary Trend in Cheshire

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

OLAP Salary Trend in Cheshire

OLAP
Salary Histogram in Cheshire

This chart provides a salary histogram for IT jobs citing OLAP across the Cheshire region over the 3 months to 25 July 2016.

OLAP Salary Histogram in Cheshire

OLAP
Job Locations in Cheshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Cheshire region over the 3 months to 25 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
Crewe - 3 £28,500 - 1
Macclesfield - 1 £35,000 -
OLAP
North West

OLAP
Top 30 Related IT Skills in Cheshire

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

1 6 (100.00%) Business Intelligence
2 5 (83.33%) Finance
2 5 (83.33%) OLAP Cube
3 4 (66.67%) Oracle OLAP
3 4 (66.67%) Cognos
3 4 (66.67%) Oracle
3 4 (66.67%) SQL Server
4 3 (50.00%) SQL
4 3 (50.00%) Data Warehouse
4 3 (50.00%) IBM
4 3 (50.00%) CRM
4 3 (50.00%) Oracle EBS
4 3 (50.00%) Cognos TM1
4 3 (50.00%) Cognos Controller
4 3 (50.00%) Cognos Business Intelligence
4 3 (50.00%) QA
4 3 (50.00%) Analytics
4 3 (50.00%) Data Analytics
5 2 (33.33%) SQL Server Analysis Services
5 2 (33.33%) SQL Server Integration Services
5 2 (33.33%) SQL Server Reporting Services
5 2 (33.33%) Microsoft
5 2 (33.33%) ETL
5 2 (33.33%) T-SQL
5 2 (33.33%) MS Excel
6 1 (16.67%) PL/SQL
6 1 (16.67%) .NET
6 1 (16.67%) XML
6 1 (16.67%) Oracle Reports
6 1 (16.67%) SharePoint

OLAP
Top Related IT Skills in Cheshire 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 1 (16.67%) SharePoint
Applications
1 2 (33.33%) MS Excel
Business Applications
1 3 (50.00%) Cognos Business Intelligence
1 3 (50.00%) Cognos Controller
1 3 (50.00%) Cognos TM1
1 3 (50.00%) Oracle EBS
Database & Business Intelligence
1 5 (83.33%) OLAP Cube
2 4 (66.67%) Oracle OLAP
2 4 (66.67%) SQL Server
3 3 (50.00%) Data Warehouse
4 2 (33.33%) SQL Server Analysis Services
4 2 (33.33%) SQL Server Integration Services
4 2 (33.33%) SQL Server Reporting Services
5 1 (16.67%) Essbase
5 1 (16.67%) Oracle BI EE
5 1 (16.67%) Oracle ODI
5 1 (16.67%) Oracle Reports
5 1 (16.67%) Relational Database
General
1 5 (83.33%) Finance
Job Titles
1 3 (50.00%) Analyst
1 3 (50.00%) Business Intelligence Developer
1 3 (50.00%) Developer
1 3 (50.00%) Junior
1 3 (50.00%) Junior Analyst
2 1 (16.67%) Business Developer
2 1 (16.67%) Business Intelligence Lead
2 1 (16.67%) Business Intelligence Manager
2 1 (16.67%) Business Manager
2 1 (16.67%) Lead Developer
2 1 (16.67%) OBIEE Developer
2 1 (16.67%) Oracle BI Developer
2 1 (16.67%) Oracle Developer
2 1 (16.67%) Senior Business Intelligence Developer
2 1 (16.67%) Senior Developer
2 1 (16.67%) Senior SQL Developer
2 1 (16.67%) SQL BI Developer
2 1 (16.67%) SQL Developer
Libraries, Frameworks & Software Standards
1 1 (16.67%) .NET
1 1 (16.67%) MDX
1 1 (16.67%) XML
Miscellaneous
1 1 (16.67%) Analytical Skills
Processes & Methodologies
1 6 (100.00%) Business Intelligence
2 3 (50.00%) Analytics
2 3 (50.00%) CRM
2 3 (50.00%) Data Analytics
3 2 (33.33%) ETL
4 1 (16.67%) Agile Software Development
4 1 (16.67%) Investment Management
4 1 (16.67%) Kimball Methodology
4 1 (16.67%) Project Management
4 1 (16.67%) Scrum
4 1 (16.67%) Translating Business Requirements
Programming Languages
1 3 (50.00%) SQL
2 2 (33.33%) T-SQL
3 1 (16.67%) PL/SQL
Quality Assurance & Compliance
1 3 (50.00%) QA
Vendors
1 4 (66.67%) Cognos
1 4 (66.67%) Oracle
2 3 (50.00%) IBM
3 2 (33.33%) Microsoft
Ellesmere Port, Merseyside
Uniting Ambition
Salary: Market related
Posted: 6 days ago
Crewe
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: 27 days ago