The first table below looks at the demand for OLAP skills in IT jobs advertised for the Leeds 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 Leeds region.

Location
3 months to
17 May 2013
Same period 2012 Same period 2011
Online Analytical Processing (OLAP)
Rank 110 117 112
Rank change year-on-year
+7 -5
Permanent jobs citing OLAP 37 12 5
As % of all permanent IT jobs located in Leeds 1.408% 0.573% 0.274%
As % of the Database & Business Intelligence category 4.125% 1.602% 0.671%
Number of salaries quoted 16 11 5
Average salary £33,500 £30,000 £30,000
Average salary % change year-on-year
+11.66% -
90% offered a salary of more than £30,000 £24,000 £27,700
10% offered a salary of more than £48,750 £40,000 £63,000
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -
All Database & Business Intelligence
Leeds
Permanent IT job ads with a match in the
Database & Business Intelligence category
897 749 745
As % of all permanent IT jobs located in Leeds 34.13% 35.75% 40.84%
Number of salaries quoted 738 680 653
Average salary £35,000 £35,000 £32,500
Average salary % change year-on-year
- +7.69%
90% offered a salary of more than £26,500 £25,000 £27,000
10% offered a salary of more than £50,000 £45,000 £47,500
UK excluding London average salary £38,500 £37,500 £37,500
% change year-on-year
+2.66% -
OLAP
West Yorkshire

OLAP
Jobs Demand Trend

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

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

Leeds OLAP Salary Trend

OLAP
Salary Histogram

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

Leeds OLAP Salary Histogram

OLAP
Top 30 Related IT Skills

For the 6 months to 17 May 2013, IT jobs across the Leeds 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 70 (94.59%) SQL Server
2 63 (85.14%) SQL Server Integration Services
3 62 (83.78%) SQL Server Analysis Services
4 61 (82.43%) Business Intelligence
5 60 (81.08%) Data Warehouse
6 58 (78.38%) SQL Server Reporting Services
7 56 (75.68%) SQL
8 53 (71.62%) Microsoft
8 53 (71.62%) SQL Server 2008
9 46 (62.16%) SQL Server 2005
10 44 (59.46%) ETL
11 39 (52.70%) T-SQL
12 37 (50.00%) MS Excel
13 27 (36.49%) MDX
14 25 (33.78%) Microsoft Analysis Services
15 24 (32.43%) Dimensional Modelling
15 24 (32.43%) Finance
16 14 (18.92%) Cognos
16 14 (18.92%) COM
17 13 (17.57%) RDBMS
17 13 (17.57%) SQL Server 2012
18 12 (16.22%) Data Quality
18 12 (16.22%) Cognos Business Intelligence
18 12 (16.22%) ITIL
18 12 (16.22%) OLTP
19 11 (14.86%) .NET
19 11 (14.86%) Service Management
19 11 (14.86%) Data Mart
20 10 (13.51%) Enterprise Modelling
20 10 (13.51%) ERwin

OLAP
Top Related IT Skills by Category

For the 6 months to 17 May 2013, IT jobs across the Leeds 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 27 (36.49%) MDX
2 14 (18.92%) COM
3 11 (14.86%) .NET
4 3 (4.054%) XML
Application Platforms
1 2 (2.703%) BizTalk Server
2 1 (1.351%) SharePoint
Applications
1 37 (50.00%) MS Excel
Business Applications
1 12 (16.22%) Cognos Business Intelligence
Database & Business Intelligence
1 70 (94.59%) SQL Server
2 63 (85.14%) SQL Server Integration Services
3 62 (83.78%) SQL Server Analysis Services
4 60 (81.08%) Data Warehouse
5 58 (78.38%) SQL Server Reporting Services
6 53 (71.62%) SQL Server 2008
7 46 (62.16%) SQL Server 2005
8 25 (33.78%) Microsoft Analysis Services
9 13 (17.57%) RDBMS
9 13 (17.57%) SQL Server 2012
10 12 (16.22%) OLTP
11 11 (14.86%) Data Mart
12 8 (10.81%) Oracle OLAP
12 8 (10.81%) Informix
13 7 (9.459%) Data Mining
13 7 (9.459%) PostgreSQL
14 2 (2.703%) PerformancePoint
15 1 (1.351%) IBM InfoSphere
15 1 (1.351%) MySQL
15 1 (1.351%) MS Access
Development Applications
1 10 (13.51%) ERwin
2 5 (6.757%) Visual Studio
General
1 24 (32.43%) Finance
2 3 (4.054%) Retail
3 2 (2.703%) Advertising
4 1 (1.351%) Legal
Job Titles
1 60 (81.08%) Developer
2 38 (51.35%) Business Intelligence Developer
3 30 (40.54%) SQL Developer
4 24 (32.43%) Business Developer
5 12 (16.22%) Senior Developer
6 11 (14.86%) Database Developer
6 11 (14.86%) SQL Server Developer
7 10 (13.51%) Architect
7 10 (13.51%) Data Architect
8 6 (8.108%) Microsoft Developer
9 5 (6.757%) Teradata DBA
9 5 (6.757%) SQL Database Developer
9 5 (6.757%) SQL DBA
10 4 (5.405%) Lead Developer
10 4 (5.405%) Lead SQL Server Developer
11 3 (4.054%) DBA
12 2 (2.703%) Analyst
13 1 (1.351%) Consultant
13 1 (1.351%) Database Analyst
13 1 (1.351%) Data Analyst
Miscellaneous
1 9 (12.16%) Data Extraction
2 2 (2.703%) Data Integration
Operating Systems
1 1 (1.351%) UNIX
Processes & Methodologies
1 61 (82.43%) Business Intelligence
2 44 (59.46%) ETL
3 24 (32.43%) Dimensional Modelling
4 12 (16.22%) ITIL
5 11 (14.86%) Service Management
6 10 (13.51%) Enterprise Modelling
7 9 (12.16%) Agile Software Development
7 9 (12.16%) Data Modelling
8 8 (10.81%) E-Commerce
9 7 (9.459%) Data Analysis
10 6 (8.108%) Project Management
11 3 (4.054%) Migration
12 2 (2.703%) Data Migration
12 2 (2.703%) UML
12 2 (2.703%) TDD
13 1 (1.351%) Asset Management
13 1 (1.351%) Data Management
13 1 (1.351%) Systems Analysis
13 1 (1.351%) Requirements Analysis
13 1 (1.351%) Quality Management
Programming Languages
1 56 (75.68%) SQL
2 39 (52.70%) T-SQL
3 7 (9.459%) C#
4 3 (4.054%) VB.NET
5 1 (1.351%) Java
Qualifications
1 1 (1.351%) MCP
1 1 (1.351%) MCSD
1 1 (1.351%) Microsoft Certification
1 1 (1.351%) MCITP
1 1 (1.351%) Degree
Quality Assurance & Compliance
1 12 (16.22%) Data Quality
Vendors
1 53 (71.62%) Microsoft
2 14 (18.92%) Cognos
3 8 (10.81%) Oracle
4 1 (1.351%) Sybase
4 1 (1.351%) Siebel
4 1 (1.351%) IBM
4 1 (1.351%) Informatica
Leeds, Yorkshire
Skills: MS SQL 2008, SQL 2005, T-SQL, SSIS, SSAS, SSRS, ETL, OLAP SQL Server Developer, SQL Developer, Database Developer, Database Manager, Database Analyst, Datawarehouse Developer, Data Warehousing...
IQ Resourcing
Salary: £25000 - £35000 per annum + excellent bens
Posted: 3 May 2013
Leeds, West Yorkshire
Strong SQL skills on multiple platforms including Oracle, Informix, Postgres and SQL Server... Strong experience architecting OLTP / OLAP databases with enterprise modelling tools such as ERStudio and Erwin.
4it Recruitment Ltd
Salary: £Excellent Salary and £Excellent Benefits
Posted: 14 May 2013
Leeds, Yorkshire
Database Architect / Data Architect / Data Warehouse Architect(Hands on role with strategic output)A major client with sites across the UK is actively seeking an experienced and technically...
IQ Resourcing
Salary: £50000 - £65000 per annum + excellent benefits package
Posted: 26 April 2013