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 30 September 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
30 Sep 2014
Same period 2013 Same period 2012
Data Warehousing
Rank 76 43 -
Rank change year-on-year
-33 -
Permanent jobs citing Data Warehouse 2 18 0
As % of all permanent IT jobs located in Portsmouth 0.53% 4.65% -
As % of the Database & Business Intelligence category 0.97% 11.25% -
Number of salaries quoted 2 15 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
206 160 100
As % of all permanent IT jobs located in Portsmouth 54.93% 41.34% 29.85%
Number of salaries quoted 137 143 94
Average salary £40,000 £42,500 £35,500
Average salary % change year-on-year
-5.88% +19.71%
90% offered a salary of more than £23,500 £22,500 £27,500
10% offered a salary of more than £48,200 £50,000 £52,500
UK excluding London average salary £40,000 £40,000 £40,000

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 30 September 2014.

Data Warehouse Salary Histogram in Portsmouth

Data Warehouse
Top 30 Related IT Skills in Portsmouth

For the 6 months to 30 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 11 (64.71%) SQL
1 11 (64.71%) Business Intelligence
2 7 (41.18%) Oracle
3 6 (35.29%) Java
3 6 (35.29%) UNIX
3 6 (35.29%) Oracle Reports
3 6 (35.29%) Data Modelling
3 6 (35.29%) Shell Script
3 6 (35.29%) Oracle Database 11g
3 6 (35.29%) Analytics
3 6 (35.29%) Oracle Database
4 5 (29.41%) IBM InfoSphere
4 5 (29.41%) Hadoop
4 5 (29.41%) Capacity Planning
4 5 (29.41%) PowerHA
4 5 (29.41%) Tableau
4 5 (29.41%) Relational Database
4 5 (29.41%) Data Structures
4 5 (29.41%) Problem Management
4 5 (29.41%) QlikView
4 5 (29.41%) Degree
4 5 (29.41%) Cognos Business Intelligence
4 5 (29.41%) Mathematics
4 5 (29.41%) Physics
4 5 (29.41%) Computer Science
4 5 (29.41%) Data Integration
4 5 (29.41%) Data Architecture
4 5 (29.41%) Performance Management
4 5 (29.41%) Database Tuning
4 5 (29.41%) Cognos

Data Warehouse
Top Related IT Skills in Portsmouth by Category

For the 6 months to 30 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 (5.88%) Oracle Workflow
Applications
1 3 (17.65%) SPSS
Business Applications
1 5 (29.41%) Cognos Business Intelligence
2 3 (17.65%) Cognos TM1
3 2 (11.76%) Oracle EBS
4 1 (5.88%) Oracle Applications
4 1 (5.88%) Oracle Financials
4 1 (5.88%) Oracle 11i
4 1 (5.88%) Oracle General Ledger
4 1 (5.88%) Oracle EBS R12
4 1 (5.88%) Oracle iProcurement
4 1 (5.88%) Oracle Payables
4 1 (5.88%) Oracle Receivables
4 1 (5.88%) Oracle E-Business Tax
4 1 (5.88%) Oracle Internet Expenses
Database & Business Intelligence
1 6 (35.29%) Oracle Reports
1 6 (35.29%) Oracle Database 11g
1 6 (35.29%) Oracle Database
2 5 (29.41%) Hadoop
2 5 (29.41%) IBM InfoSphere
2 5 (29.41%) Relational Database
2 5 (29.41%) Oracle Database 10g
2 5 (29.41%) DB2
2 5 (29.41%) QlikView
3 4 (23.53%) Cognos Framework Manager
4 1 (5.88%) Cognos Metric Studio
4 1 (5.88%) Cognos Transformer
4 1 (5.88%) SQL Server
4 1 (5.88%) Oracle Discoverer
4 1 (5.88%) Star Schema
4 1 (5.88%) Data Mart
4 1 (5.88%) SQL Server Integration Services
4 1 (5.88%) Oracle BI EE
4 1 (5.88%) Cognos Query Studio
4 1 (5.88%) Cognos Analysis Studio
Development Applications
1 1 (5.88%) Oracle Forms
1 1 (5.88%) Toad
1 1 (5.88%) JDeveloper
General
1 4 (23.53%) Finance
2 3 (17.65%) Retail
Job Titles
1 11 (64.71%) Developer
2 8 (47.06%) Business Intelligence Developer
3 5 (29.41%) Senior Business Intelligence Developer
3 5 (29.41%) DB2 DBA
3 5 (29.41%) DBA
3 5 (29.41%) Senior Developer
3 5 (29.41%) Administrator
4 3 (17.65%) Cognos Developer
5 2 (11.76%) Cognos BI Developer
6 1 (5.88%) Business Intelligence Specialist
6 1 (5.88%) Oracle Developer
6 1 (5.88%) SQL Developer
6 1 (5.88%) Cognos Specialist
6 1 (5.88%) Oracle Financials Developer
Libraries, Frameworks & Software Standards
1 5 (29.41%) Middleware
2 1 (5.88%) Apache Flex
2 1 (5.88%) XML
Miscellaneous
1 5 (29.41%) Replication
1 5 (29.41%) Mathematics
1 5 (29.41%) Physics
1 5 (29.41%) Computer Science
1 5 (29.41%) Data Integration
1 5 (29.41%) HACMP
1 5 (29.41%) Data Structures
2 3 (17.65%) Analytical Skills
3 2 (11.76%) Management Information System
Operating Systems
1 6 (35.29%) UNIX
2 5 (29.41%) Windows
2 5 (29.41%) AIX
Processes & Methodologies
1 11 (64.71%) Business Intelligence
2 6 (35.29%) Data Modelling
2 6 (35.29%) Analytics
3 5 (29.41%) Data Architecture
3 5 (29.41%) Database Tuning
3 5 (29.41%) Capacity Planning
3 5 (29.41%) Problem Management
3 5 (29.41%) Performance Management
3 5 (29.41%) SOA
3 5 (29.41%) Scrum
3 5 (29.41%) Agile Software Development
4 3 (17.65%) Data Analysis
4 3 (17.65%) Requirements Analysis
5 2 (11.76%) ETL
6 1 (5.88%) Workflow
6 1 (5.88%) Dimensional Modelling
6 1 (5.88%) Release Management
6 1 (5.88%) Performance Tuning
6 1 (5.88%) ITIL
Programming Languages
1 11 (64.71%) SQL
2 6 (35.29%) Shell Script
2 6 (35.29%) Java
3 5 (29.41%) Korn
4 1 (5.88%) PL/SQL
Qualifications
1 5 (29.41%) Degree
System Software
1 5 (29.41%) PowerHA
Systems Management
1 5 (29.41%) Tivoli
1 5 (29.41%) Tivoli Storage Manager
Vendors
1 7 (41.18%) Oracle
2 5 (29.41%) Cognos
2 5 (29.41%) IBM
2 5 (29.41%) Actuate
2 5 (29.41%) Google
2 5 (29.41%) Tableau