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

3 months to
29 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 82 112 119
Rank change year-on-year
+30 +7
Permanent jobs citing OLAP 2 7 7
As % of all permanent IT jobs located in Cheshire 0.21% 0.40% 0.40%
As % of the Database & Business Intelligence category 0.76% 1.15% 1.08%
Number of salaries quoted 2 5 6
Median salary £47,500 £40,000 £42,500
Median salary % change year-on-year
+18.75% -5.88%
90% offered a salary of more than £37,500 £36,000 £36,250
10% offered a salary of more than £57,500 £44,000 £43,750
UK excluding London median salary £47,500 £40,000 £42,562
% change year-on-year
+18.75% -6.01%
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
264 609 650
As % of all permanent IT jobs located in Cheshire 27.76% 35.08% 37.36%
Number of salaries quoted 242 510 525
Median salary £38,000 £40,000 £37,500
Median salary % change year-on-year
-5.00% +6.66%
90% offered a salary of more than £27,500 £31,950 £27,500
10% offered a salary of more than £54,750 £50,000 £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 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 29 June 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 29 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
Macclesfield +4 1 £35,000 -12.50%
OLAP
North West

OLAP
Top 30 Related IT Skills in Cheshire

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

1 3 (100.00%) SQL
1 3 (100.00%) Data Warehouse
1 3 (100.00%) Business Intelligence
2 2 (66.67%) SQL Server Integration Services
2 2 (66.67%) Microsoft
2 2 (66.67%) SQL Server Reporting Services
2 2 (66.67%) SQL Server Analysis Services
2 2 (66.67%) Finance
2 2 (66.67%) ETL
2 2 (66.67%) MS Excel
2 2 (66.67%) T-SQL
2 2 (66.67%) OLAP Cube
3 1 (33.33%) Translating Business Requirements
3 1 (33.33%) .NET
3 1 (33.33%) Oracle
3 1 (33.33%) SQL Server
3 1 (33.33%) XML
3 1 (33.33%) Oracle Reports
3 1 (33.33%) Cognos
3 1 (33.33%) SharePoint
3 1 (33.33%) Scrum
3 1 (33.33%) Essbase
3 1 (33.33%) Agile Software Development
3 1 (33.33%) Investment Management
3 1 (33.33%) Oracle BI EE
3 1 (33.33%) Kimball Methodology
3 1 (33.33%) Oracle ODI
3 1 (33.33%) Relational Database
3 1 (33.33%) Analytical Skills
3 1 (33.33%) PL/SQL

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 (33.33%) SharePoint
Applications
1 2 (66.67%) MS Excel
Database & Business Intelligence
1 3 (100.00%) Data Warehouse
2 2 (66.67%) OLAP Cube
2 2 (66.67%) SQL Server Analysis Services
2 2 (66.67%) SQL Server Integration Services
2 2 (66.67%) SQL Server Reporting Services
3 1 (33.33%) Essbase
3 1 (33.33%) Oracle BI EE
3 1 (33.33%) Oracle ODI
3 1 (33.33%) Oracle OLAP
3 1 (33.33%) Oracle Reports
3 1 (33.33%) Relational Database
3 1 (33.33%) SQL Server
General
1 2 (66.67%) Finance
Job Titles
1 3 (100.00%) Business Intelligence Developer
1 3 (100.00%) Developer
2 1 (33.33%) Business Developer
2 1 (33.33%) Business Intelligence Lead
2 1 (33.33%) Business Intelligence Manager
2 1 (33.33%) Business Manager
2 1 (33.33%) Lead Developer
2 1 (33.33%) OBIEE Developer
2 1 (33.33%) Oracle BI Developer
2 1 (33.33%) Oracle Developer
2 1 (33.33%) Senior Business Intelligence Developer
2 1 (33.33%) Senior Developer
2 1 (33.33%) Senior SQL Developer
2 1 (33.33%) SQL BI Developer
2 1 (33.33%) SQL Developer
Libraries, Frameworks & Software Standards
1 1 (33.33%) .NET
1 1 (33.33%) MDX
1 1 (33.33%) XML
Miscellaneous
1 1 (33.33%) Analytical Skills
Processes & Methodologies
1 3 (100.00%) Business Intelligence
2 2 (66.67%) ETL
3 1 (33.33%) Agile Software Development
3 1 (33.33%) Investment Management
3 1 (33.33%) Kimball Methodology
3 1 (33.33%) Project Management
3 1 (33.33%) Scrum
3 1 (33.33%) Translating Business Requirements
Programming Languages
1 3 (100.00%) SQL
2 2 (66.67%) T-SQL
3 1 (33.33%) PL/SQL
Vendors
1 2 (66.67%) Microsoft
2 1 (33.33%) Cognos
2 1 (33.33%) Oracle
Crewe
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: 2 days ago