The first table below looks at the demand 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 23 July 2014 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 Portsmouth region.

Location
3 months to
23 Jul 2014
Same period 2013 Same period 2012
Data Warehousing
Rank 65 34 53
Rank change year-on-year
-31 +19
Permanent jobs citing Data Warehouse 10 23 1
As % of all permanent IT jobs located in Portsmouth 2.12% 5.62% 0.36%
As % of the Database & Business Intelligence category 4.22% 14.11% 0.94%
Number of salaries quoted 10 18 1
Average salary £50,500 £37,500 £32,500
Average salary % change year-on-year
+34.66% +15.38%
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -
Database & Business Intelligence Category
Portsmouth
Permanent IT job ads with a match in the
Database & Business Intelligence category
237 163 106
As % of all permanent IT jobs located in Portsmouth 50.32% 39.85% 37.99%
Number of salaries quoted 174 146 103
Average salary £45,000 £35,000 £33,500
Average salary % change year-on-year
+28.57% +4.47%
90% offered a salary of more than £22,500 £22,500 £25,000
10% offered a salary of more than £53,800 £50,000 £47,500
UK excluding London average salary £40,000 £39,000 £38,000
% change year-on-year
+2.56% +2.63%
Data Warehouse
Hampshire

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 23 July 2014.

Data Warehouse Salary Histogram in Portsmouth

Data Warehouse
Top 30 Related IT Skills in Portsmouth

For the 6 months to 23 July 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 24 (82.76%) Business Intelligence
2 18 (62.07%) Oracle
3 17 (58.62%) SQL
4 13 (44.83%) Data Modelling
4 13 (44.83%) Java
4 13 (44.83%) Oracle Reports
4 13 (44.83%) Oracle Database 11g
4 13 (44.83%) Analytics
4 13 (44.83%) Oracle Database
5 10 (34.48%) Oracle EBS
5 10 (34.48%) Cognos
5 10 (34.48%) UNIX
5 10 (34.48%) Shell Script
5 10 (34.48%) ETL
5 10 (34.48%) Cognos Business Intelligence
6 9 (31.03%) Data Architecture
6 9 (31.03%) Finance
7 8 (27.59%) Agile Software Development
7 8 (27.59%) Scrum
7 8 (27.59%) Google
7 8 (27.59%) Degree
7 8 (27.59%) Oracle Database 10g
7 8 (27.59%) Actuate
7 8 (27.59%) SOA
7 8 (27.59%) QlikView
7 8 (27.59%) Data Integration
7 8 (27.59%) Mathematics
7 8 (27.59%) Physics
7 8 (27.59%) Computer Science
7 8 (27.59%) Relational Database

Data Warehouse
Top Related IT Skills in Portsmouth by Category

For the 6 months to 23 July 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 5 (17.24%) Oracle Workflow
Applications
1 3 (10.34%) SPSS
Business Applications
1 10 (34.48%) Oracle EBS
1 10 (34.48%) Cognos Business Intelligence
2 5 (17.24%) Oracle General Ledger
2 5 (17.24%) Oracle EBS R12
2 5 (17.24%) Oracle iProcurement
2 5 (17.24%) Oracle Payables
2 5 (17.24%) Oracle Receivables
2 5 (17.24%) Oracle Applications
2 5 (17.24%) Oracle E-Business Tax
2 5 (17.24%) Oracle Internet Expenses
3 4 (13.79%) Oracle Cash Management
4 3 (10.34%) Cognos TM1
5 1 (3.45%) Oracle Financials
5 1 (3.45%) Oracle 11i
Communications & Networking
1 4 (13.79%) Internet
Database & Business Intelligence
1 13 (44.83%) Oracle Reports
1 13 (44.83%) Oracle Database 11g
1 13 (44.83%) Oracle Database
2 8 (27.59%) Hadoop
2 8 (27.59%) Relational Database
2 8 (27.59%) Oracle Database 10g
2 8 (27.59%) Cognos Framework Manager
2 8 (27.59%) QlikView
3 5 (17.24%) Cognos Metric Studio
3 5 (17.24%) Cognos Transformer
3 5 (17.24%) Data Mart
3 5 (17.24%) SQL Server Integration Services
3 5 (17.24%) Oracle BI EE
3 5 (17.24%) Oracle Discoverer
3 5 (17.24%) Star Schema
3 5 (17.24%) SQL Server
3 5 (17.24%) DB2
3 5 (17.24%) Cognos Query Studio
3 5 (17.24%) Cognos Analysis Studio
3 5 (17.24%) Cognos Report Studio
Development Applications
1 5 (17.24%) Oracle Forms
1 5 (17.24%) Toad
1 5 (17.24%) JDeveloper
General
1 9 (31.03%) Finance
2 4 (13.79%) General Ledger
3 3 (10.34%) Retail
Job Titles
1 22 (75.86%) Developer
2 11 (37.93%) Business Intelligence Developer
3 8 (27.59%) Cognos Developer
3 8 (27.59%) Senior Business Intelligence Developer
3 8 (27.59%) Senior Developer
4 5 (17.24%) Administrator
4 5 (17.24%) Oracle Developer
4 5 (17.24%) DBA
4 5 (17.24%) DB2 DBA
5 4 (13.79%) Business Developer
6 2 (6.90%) Cognos BI Developer
7 1 (3.45%) Business Intelligence Specialist
7 1 (3.45%) Architecture Manager
7 1 (3.45%) Integration Manager
7 1 (3.45%) Cognos Specialist
7 1 (3.45%) Information Manager
7 1 (3.45%) Oracle Financials Developer
Libraries, Frameworks & Software Standards
1 5 (17.24%) XML
1 5 (17.24%) Middleware
1 5 (17.24%) Apache Flex
Miscellaneous
1 8 (27.59%) Mathematics
1 8 (27.59%) Physics
1 8 (27.59%) Computer Science
1 8 (27.59%) Data Integration
2 5 (17.24%) HACMP
2 5 (17.24%) Replication
3 2 (6.90%) Management Information System
Operating Systems
1 10 (34.48%) UNIX
2 5 (17.24%) Windows
2 5 (17.24%) AIX
Processes & Methodologies
1 24 (82.76%) Business Intelligence
2 13 (44.83%) Data Modelling
2 13 (44.83%) Analytics
3 10 (34.48%) ETL
4 9 (31.03%) Data Architecture
5 8 (27.59%) SOA
5 8 (27.59%) Scrum
5 8 (27.59%) Agile Software Development
6 5 (17.24%) Workflow
6 5 (17.24%) Problem Management
6 5 (17.24%) Release Management
6 5 (17.24%) Performance Management
6 5 (17.24%) Dimensional Modelling
6 5 (17.24%) Database Tuning
6 5 (17.24%) Performance Tuning
6 5 (17.24%) Capacity Planning
7 4 (13.79%) Requirements Analysis
7 4 (13.79%) Cash Management
7 4 (13.79%) Data Analysis
7 4 (13.79%) Business Analysis
Programming Languages
1 17 (58.62%) SQL
2 13 (44.83%) Java
3 10 (34.48%) Shell Script
4 5 (17.24%) Korn
4 5 (17.24%) PL/SQL
Qualifications
1 8 (27.59%) Degree
System Software
1 5 (17.24%) PowerHA
Systems Management
1 5 (17.24%) Tivoli
1 5 (17.24%) Tivoli Storage Manager
Vendors
1 18 (62.07%) Oracle
2 10 (34.48%) Cognos
3 8 (27.59%) Actuate
3 8 (27.59%) Google
3 8 (27.59%) Tableau
4 5 (17.24%) IBM