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

Location
3 months to
22 Sep 2014
Same period 2013 Same period 2012
Data Warehousing
Rank 76 39 -
Rank change year-on-year
-37 -
Permanent jobs citing Data Warehouse 2 20 0
As % of all permanent IT jobs located in Portsmouth 0.51% 4.99% -
As % of the Database & Business Intelligence category 0.93% 12.50% -
Number of salaries quoted 2 16 0
Average salary £38,250 £47,500 -
Average salary % change year-on-year
-19.47% -
UK excluding London average salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%
Data Warehouse
Hampshire

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

Database & Business Intelligence Category
Portsmouth
Permanent IT job ads with a match in the
Database & Business Intelligence category
215 160 101
As % of all permanent IT jobs located in Portsmouth 54.85% 39.90% 28.69%
Number of salaries quoted 140 143 97
Average salary £40,000 £40,000 £37,500
Average salary % change year-on-year
- +6.66%
90% offered a salary of more than £23,500 £22,500 £26,900
10% offered a salary of more than £49,600 £50,000 £50,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

Data Warehouse
Jobs Demand Trend in Portsmouth

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

Data Warehouse Jobs Demand Trend in Portsmouth

Data Warehouse
Salary Trend in Portsmouth

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

Data Warehouse Salary Trend in Portsmouth

Data Warehouse
Salary Histogram in Portsmouth

This chart provides a salary histogram for IT jobs citing Data Warehouse across the Portsmouth region over the 3 months to 22 September 2014.

Data Warehouse Salary Histogram in Portsmouth

Data Warehouse
Top 30 Related IT Skills in Portsmouth

For the 6 months to 22 September 2014, IT jobs across the Portsmouth 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 15 (71.43%) Business Intelligence
2 14 (66.67%) SQL
3 11 (52.38%) Oracle
4 10 (47.62%) Data Modelling
5 9 (42.86%) Oracle Reports
5 9 (42.86%) Java
5 9 (42.86%) Oracle Database 11g
5 9 (42.86%) Analytics
5 9 (42.86%) Oracle Database
6 8 (38.10%) Tableau
6 8 (38.10%) Relational Database
6 8 (38.10%) Data Integration
6 8 (38.10%) Data Architecture
6 8 (38.10%) Hadoop
6 8 (38.10%) Degree
6 8 (38.10%) QlikView
6 8 (38.10%) Google
6 8 (38.10%) Mathematics
6 8 (38.10%) Physics
6 8 (38.10%) Computer Science
6 8 (38.10%) Agile Software Development
6 8 (38.10%) Scrum
6 8 (38.10%) SOA
6 8 (38.10%) Oracle Database 10g
6 8 (38.10%) Actuate
7 6 (28.57%) Cognos
7 6 (28.57%) Shell Script
7 6 (28.57%) UNIX
7 6 (28.57%) Cognos Business Intelligence
8 5 (23.81%) Problem Management

Data Warehouse
Top Related IT Skills in Portsmouth by Category

For the 6 months to 22 September 2014, IT jobs across the Portsmouth 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.

Application Platforms
1 1 (4.76%) Oracle Workflow
Applications
1 3 (14.29%) SPSS
Business Applications
1 6 (28.57%) Cognos Business Intelligence
2 3 (14.29%) Oracle EBS
2 3 (14.29%) Cognos TM1
3 1 (4.76%) Oracle Applications
3 1 (4.76%) Oracle Financials
3 1 (4.76%) Oracle 11i
3 1 (4.76%) Oracle Payables
3 1 (4.76%) Oracle Receivables
3 1 (4.76%) Oracle E-Business Tax
3 1 (4.76%) Oracle Internet Expenses
3 1 (4.76%) Oracle iProcurement
3 1 (4.76%) Oracle General Ledger
3 1 (4.76%) Oracle EBS R12
Database & Business Intelligence
1 9 (42.86%) Oracle Reports
1 9 (42.86%) Oracle Database 11g
1 9 (42.86%) Oracle Database
2 8 (38.10%) Relational Database
2 8 (38.10%) Hadoop
2 8 (38.10%) QlikView
2 8 (38.10%) Oracle Database 10g
3 5 (23.81%) DB2
3 5 (23.81%) IBM InfoSphere
3 5 (23.81%) Cognos Framework Manager
4 2 (9.52%) Cognos Metric Studio
4 2 (9.52%) Cognos Transformer
4 2 (9.52%) Cognos Query Studio
4 2 (9.52%) Cognos Analysis Studio
4 2 (9.52%) Cognos Report Studio
4 2 (9.52%) SQL Server
4 2 (9.52%) Star Schema
4 2 (9.52%) SQL Server Integration Services
4 2 (9.52%) Data Mart
5 1 (4.76%) Oracle BI EE
Development Applications
1 1 (4.76%) JDeveloper
1 1 (4.76%) Oracle Forms
1 1 (4.76%) Toad
General
1 4 (19.05%) Finance
2 3 (14.29%) Retail
Job Titles
1 15 (71.43%) Developer
2 11 (52.38%) Business Intelligence Developer
3 8 (38.10%) Senior Business Intelligence Developer
3 8 (38.10%) Senior Developer
4 5 (23.81%) DB2 DBA
4 5 (23.81%) Administrator
4 5 (23.81%) DBA
5 4 (19.05%) Cognos Developer
6 2 (9.52%) Cognos BI Developer
7 1 (4.76%) Oracle Developer
7 1 (4.76%) SQL Developer
7 1 (4.76%) Cognos Specialist
7 1 (4.76%) Oracle Financials Developer
7 1 (4.76%) Business Intelligence Specialist
Libraries, Frameworks & Software Standards
1 5 (23.81%) Middleware
2 1 (4.76%) Apache Flex
2 1 (4.76%) XML
Miscellaneous
1 8 (38.10%) Data Integration
1 8 (38.10%) Mathematics
1 8 (38.10%) Physics
1 8 (38.10%) Computer Science
2 5 (23.81%) Replication
2 5 (23.81%) HACMP
3 3 (14.29%) Analytical Skills
4 2 (9.52%) Management Information System
Operating Systems
1 6 (28.57%) UNIX
2 5 (23.81%) Windows
2 5 (23.81%) AIX
Processes & Methodologies
1 15 (71.43%) Business Intelligence
2 10 (47.62%) Data Modelling
3 9 (42.86%) Analytics
4 8 (38.10%) Data Architecture
4 8 (38.10%) Agile Software Development
4 8 (38.10%) Scrum
4 8 (38.10%) SOA
5 5 (23.81%) Problem Management
5 5 (23.81%) Performance Management
5 5 (23.81%) Capacity Planning
5 5 (23.81%) Database Tuning
6 3 (14.29%) Data Analysis
6 3 (14.29%) Requirements Analysis
6 3 (14.29%) ETL
7 2 (9.52%) Performance Tuning
7 2 (9.52%) Dimensional Modelling
7 2 (9.52%) Release Management
8 1 (4.76%) Workflow
8 1 (4.76%) ITIL
Programming Languages
1 14 (66.67%) SQL
2 9 (42.86%) Java
3 6 (28.57%) Shell Script
4 5 (23.81%) Korn
5 1 (4.76%) PL/SQL
Qualifications
1 8 (38.10%) Degree
System Software
1 5 (23.81%) PowerHA
Systems Management
1 5 (23.81%) Tivoli
1 5 (23.81%) Tivoli Storage Manager
Vendors
1 11 (52.38%) Oracle
2 8 (38.10%) Tableau
2 8 (38.10%) Google
2 8 (38.10%) Actuate
3 6 (28.57%) Cognos
4 5 (23.81%) IBM
Portsmouth, Hampshire
Connectus
Salary: £25000 - £33000 per annum
Posted: 5 days ago