The table below looks at the statistics for Data Warehouse skills in IT jobs advertised for the Canary Wharf region. Included is a guide to the average salaries offered in IT jobs that have cited Data Warehouse over the 3 months to 22 August 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
22 Aug 2014
Same period 2013 Same period 2012
Data Warehousing
Rank 24 30 43
Rank change year-on-year
+6 +13
Permanent jobs citing Data Warehouse 4 5 14
As % of all permanent IT jobs located in Canary Wharf 2.58% 2.65% 3.33%
As % of the Database & Business Intelligence category 11.76% 9.80% 16.09%
Number of salaries quoted 2 4 13
Average salary £64,000 £62,500 £82,500
Average salary % change year-on-year
+2.40% -24.24%
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -
Data Warehouse
London

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 Canary Wharf region.

Database & Business Intelligence Category
Canary Wharf
Permanent IT job ads with a match in the
Database & Business Intelligence category
34 51 87
As % of all permanent IT jobs located in Canary Wharf 21.94% 26.98% 20.67%
Number of salaries quoted 29 47 61
Average salary £64,000 £50,000 £75,000
Average salary % change year-on-year
+28.00% -33.33%
90% offered a salary of more than £51,000 £45,000 £47,500
10% offered a salary of more than £71,500 £87,000 £85,000
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

Data Warehouse
Jobs Demand Trend in Canary Wharf

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

Data Warehouse Jobs Demand Trend in Canary Wharf

Data Warehouse
Salary Trend in Canary Wharf

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse across the Canary Wharf region.

Data Warehouse Salary Trend in Canary Wharf

Data Warehouse
Top 30 Related IT Skills in Canary Wharf

For the 6 months to 22 August 2014, IT jobs across the Canary Wharf region citing Data Warehouse 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 Data Warehouse.

1 9 (100.00%) SQL
2 7 (77.78%) Oracle
2 7 (77.78%) Windows
2 7 (77.78%) Cognos
2 7 (77.78%) Data Modelling
2 7 (77.78%) Toad
2 7 (77.78%) Business Intelligence
2 7 (77.78%) Performance Tuning
3 4 (44.44%) Cognos Framework Manager
3 4 (44.44%) Analytics
3 4 (44.44%) Stakeholder Management
3 4 (44.44%) Oracle BI EE
4 3 (33.33%) Cognos Business Intelligence
4 3 (33.33%) Cognos TM1
4 3 (33.33%) ETL
4 3 (33.33%) Oracle ODI
4 3 (33.33%) Oracle Database
4 3 (33.33%) Oracle Database 11g
4 3 (33.33%) Cognos Event Studio
4 3 (33.33%) Cognos Metric Studio
5 2 (22.22%) PMI
5 2 (22.22%) PMI Certification
5 2 (22.22%) Foreign Exchange (FX)
5 2 (22.22%) Shell Script
5 2 (22.22%) UNIX
5 2 (22.22%) Java
5 2 (22.22%) Regression Testing
5 2 (22.22%) Finance
5 2 (22.22%) Software Testing
5 2 (22.22%) ISTQB

Data Warehouse
Top Related IT Skills in Canary Wharf by Category

For the 6 months to 22 August 2014, IT jobs across the Canary Wharf region citing Data Warehouse 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 Data Warehouse. Up to 20 skills are shown per category.

Business Applications
1 3 (33.33%) Cognos Business Intelligence
1 3 (33.33%) Cognos TM1
Database & Business Intelligence
1 4 (44.44%) Cognos Framework Manager
1 4 (44.44%) Oracle BI EE
2 3 (33.33%) Oracle ODI
2 3 (33.33%) Oracle Database
2 3 (33.33%) Oracle Database 11g
2 3 (33.33%) Cognos Event Studio
2 3 (33.33%) Cognos Metric Studio
Development Applications
1 7 (77.78%) Toad
2 2 (22.22%) JIRA
2 2 (22.22%) Selenium
General
1 2 (22.22%) Finance
1 2 (22.22%) Banking
Job Titles
1 4 (44.44%) Solutions Designer
1 4 (44.44%) Business Intelligence Specialist
1 4 (44.44%) Designer
2 3 (33.33%) Solutions Architect
2 3 (33.33%) Architect
3 2 (22.22%) Analyst
3 2 (22.22%) QA Analyst
4 1 (11.11%) Business Intelligence Architect
Miscellaneous
1 2 (22.22%) PMI
1 2 (22.22%) Foreign Exchange (FX)
1 2 (22.22%) SWIFT
Operating Systems
1 7 (77.78%) Windows
2 2 (22.22%) UNIX
Processes & Methodologies
1 7 (77.78%) Data Modelling
1 7 (77.78%) Business Intelligence
1 7 (77.78%) Performance Tuning
2 4 (44.44%) Analytics
2 4 (44.44%) Stakeholder Management
3 3 (33.33%) ETL
4 2 (22.22%) Regression Testing
4 2 (22.22%) Software Testing
4 2 (22.22%) Test Strategy
4 2 (22.22%) Test Automation
4 2 (22.22%) Test Scripting
Programming Languages
1 9 (100.00%) SQL
2 2 (22.22%) Shell Script
2 2 (22.22%) Java
Qualifications
1 2 (22.22%) PMI Certification
1 2 (22.22%) ISTQB
Quality Assurance & Compliance
1 2 (22.22%) QA
Vendors
1 7 (77.78%) Oracle
1 7 (77.78%) Cognos