The first table below looks at the demand for OLAP skills in IT jobs advertised for the East Midlands region. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 17 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category for the East Midlands region.

Location
3 months to
17 May 2013
Same period 2012 Same period 2011
Online Analytical Processing (OLAP)
Rank 148 157 124
Rank change year-on-year
+9 -33
Permanent jobs citing OLAP 16 9 48
As % of all permanent IT jobs located in the East Midlands 0.523% 0.264% 1.325%
As % of the Database & Business Intelligence category 1.467% 0.765% 4.037%
Number of salaries quoted 16 9 47
Average salary £40,000 £34,000 £40,000
Average salary % change year-on-year
+17.64% -15.00%
90% offered a salary of more than £33,500 £24,000 £34,000
10% offered a salary of more than £58,750 £41,700 £47,500
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -
All Database & Business Intelligence
East Midlands
Permanent IT job ads with a match in the
Database & Business Intelligence category
1091 1176 1189
As % of all permanent IT jobs located in the East Midlands 35.67% 34.50% 32.83%
Number of salaries quoted 994 1102 1041
Average salary £37,500 £34,000 £35,000
Average salary % change year-on-year
+10.29% -2.85%
90% offered a salary of more than £27,500 £24,500 £25,000
10% offered a salary of more than £46,500 £47,500 £45,000
UK excluding London average salary £38,500 £37,500 £37,500
% change year-on-year
+2.66% -
OLAP
England

OLAP
Jobs Demand Trend

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

East Midlands OLAP Jobs Demand Trend

OLAP
Salary Trend

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

East Midlands OLAP Salary Trend

OLAP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLAP across the East Midlands region over the 3 months to 17 May 2013.

East Midlands OLAP Salary Histogram

OLAP
Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the East Midlands region over the 3 months to 17 May 2013. 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 each for more statistics)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Nottinghamshire +8 11 £40,000 -2.43%
Derbyshire +5 1 £40,000 +4.57%
Leicestershire -9 1 £32,000 -2.29%
Northamptonshire - 1 £47,500 -
OLAP
England

OLAP
Top 30 Related IT Skills

For the 6 months to 17 May 2013, IT jobs across the East Midlands 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 45 (88.24%) SQL
2 43 (84.31%) Business Intelligence
3 40 (78.43%) Data Warehouse
4 39 (76.47%) SQL Server
5 36 (70.59%) SQL Server Reporting Services
5 36 (70.59%) SQL Server Integration Services
5 36 (70.59%) SQL Server Analysis Services
6 29 (56.86%) MDX
7 26 (50.98%) SharePoint
8 23 (45.10%) .NET
9 22 (43.14%) SQL Server 2008
10 21 (41.18%) C#
10 21 (41.18%) ASP.NET
11 20 (39.22%) Microsoft Analysis Services
12 15 (29.41%) Microsoft
12 15 (29.41%) SQL Server 2005
13 13 (25.49%) Windows
14 12 (23.53%) MS Excel
15 11 (21.57%) T-SQL
16 10 (19.61%) ETL
17 8 (15.69%) RDBMS
17 8 (15.69%) Windows SharePoint Services
18 7 (13.73%) Data Migration
18 7 (13.73%) Migration
19 6 (11.76%) Cognos
20 5 (9.804%) Business Objects
20 5 (9.804%) Data Modelling
20 5 (9.804%) OLTP
20 5 (9.804%) Information Management
21 4 (7.843%) Advertising

OLAP
Top Related IT Skills by Category

For the 6 months to 17 May 2013, IT jobs across the East Midlands 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.

Application Development
1 29 (56.86%) MDX
2 23 (45.10%) .NET
3 21 (41.18%) ASP.NET
4 8 (15.69%) Windows SharePoint Services
5 2 (3.922%) J2EE
6 1 (1.961%) CSS
6 1 (1.961%) XML
6 1 (1.961%) SAP XI
Application Platforms
1 26 (50.98%) SharePoint
2 3 (5.882%) SharePoint Server
3 1 (1.961%) SAS
Applications
1 12 (23.53%) MS Excel
2 1 (1.961%) MS PowerPoint
2 1 (1.961%) MS Office
Business Applications
1 2 (3.922%) SAP BPC
2 1 (1.961%) Cognos Business Intelligence
Communications & Networking
1 1 (1.961%) HTTP
Database & Business Intelligence
1 40 (78.43%) Data Warehouse
2 39 (76.47%) SQL Server
3 36 (70.59%) SQL Server Reporting Services
3 36 (70.59%) SQL Server Integration Services
3 36 (70.59%) SQL Server Analysis Services
4 22 (43.14%) SQL Server 2008
5 20 (39.22%) Microsoft Analysis Services
6 15 (29.41%) SQL Server 2005
7 8 (15.69%) RDBMS
8 5 (9.804%) OLTP
9 4 (7.843%) SQL Server 2012
10 3 (5.882%) SAP HANA
10 3 (5.882%) BusinessObjects Web Intelligence
10 3 (5.882%) Xcelsius
10 3 (5.882%) Crystal Reports
10 3 (5.882%) Star Schema
10 3 (5.882%) BusinessObjects
11 2 (3.922%) DB2
11 2 (3.922%) DataStage
11 2 (3.922%) Crystal Dashboard Design
Development Applications
1 1 (1.961%) ERwin
General
1 4 (7.843%) Advertising
2 1 (1.961%) Retail
2 1 (1.961%) Finance
Job Titles
1 37 (72.55%) Developer
2 27 (52.94%) Business Intelligence Developer
3 16 (31.37%) Senior Developer
4 15 (29.41%) Business Developer
5 5 (9.804%) DBA
5 5 (9.804%) Architect
5 5 (9.804%) SQL DBA
6 4 (7.843%) SQL Developer
6 4 (7.843%) Business Intelligence Architect
7 3 (5.882%) Senior DBA
7 3 (5.882%) SQL Server DBA
7 3 (5.882%) Senior SQL DBA
8 2 (3.922%) Senior SQL Developer
8 2 (3.922%) Senior Software Developer
8 2 (3.922%) Business Architect
8 2 (3.922%) SQL Server Developer
8 2 (3.922%) Software Developer
8 2 (3.922%) Analyst
8 2 (3.922%) Web Developer
8 2 (3.922%) Senior Microsoft Developer
Miscellaneous
1 2 (3.922%) Statistics
1 2 (3.922%) NHS
2 1 (1.961%) Replication
2 1 (1.961%) Data Protection Act
2 1 (1.961%) Computer Science
2 1 (1.961%) Data Integration
Operating Systems
1 13 (25.49%) Windows
2 1 (1.961%) AIX
2 1 (1.961%) UNIX
Processes & Methodologies
1 43 (84.31%) Business Intelligence
2 10 (19.61%) ETL
3 7 (13.73%) Data Migration
3 7 (13.73%) Migration
4 5 (9.804%) Data Modelling
4 5 (9.804%) Information Management
5 4 (7.843%) Analytics
6 3 (5.882%) Data Analysis
7 2 (3.922%) Performance Management
7 2 (3.922%) E-Commerce
7 2 (3.922%) Agile Software Development
7 2 (3.922%) Configuration Management
7 2 (3.922%) Kimball Methodology
7 2 (3.922%) Data Architecture
7 2 (3.922%) Database Tuning
8 1 (1.961%) Capacity Planning
8 1 (1.961%) Statistical Modelling
8 1 (1.961%) Database Security
8 1 (1.961%) MVC
8 1 (1.961%) Validation
Programming Languages
1 45 (88.24%) SQL
2 21 (41.18%) C#
3 11 (21.57%) T-SQL
4 3 (5.882%) VB
4 3 (5.882%) VB.NET
5 2 (3.922%) Java
5 2 (3.922%) C
6 1 (1.961%) VBScript
6 1 (1.961%) VBA
6 1 (1.961%) PowerShell
Qualifications
1 1 (1.961%) MCDBA
1 1 (1.961%) Microsoft Certification
1 1 (1.961%) MCITP
1 1 (1.961%) Degree
1 1 (1.961%) Security Cleared
Quality Assurance & Compliance
1 3 (5.882%) ISO 9001
1 3 (5.882%) TickIT
2 2 (3.922%) Data Quality
3 1 (1.961%) SLA
System Software
1 1 (1.961%) Oracle RAC
Systems Management
1 1 (1.961%) Data Guard
Vendors
1 15 (29.41%) Microsoft
2 6 (11.76%) Cognos
3 5 (9.804%) Business Objects
4 3 (5.882%) SAP
5 2 (3.922%) Sybase
6 1 (1.961%) Oracle
6 1 (1.961%) IBM
6 1 (1.961%) Teradata
6 1 (1.961%) Red Gate
Northamptonshire
Windows Server 2008 / R2. SAN Technologies. Exposure to Data warehousing. Experience in SQL Server Replication (Snapshot, Transactional) Experience with DTS and SSIS... SOX, PII & PCI)... Experience with SSRS...
PNG Recruitment Solutions
Salary: From £35,000 to £40,000 per annum £35k - £40k basic + benefits package
Posted: 17 May 2013