Period
to 22 July 2018

The following table provides summary statistics for permanent job vacancies advertised in Hampshire with a requirement for Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Warehouse over the 6 months to 22 July 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
South East > Hampshire
6 months to
22 Jul 2018
Same period 2017 Same period 2016
Rank 188 182 163
Rank change year-on-year -6 -19 -43
Permanent jobs citing Data Warehouse 70 63 120
As % of all permanent IT jobs advertised in Hampshire 1.06% 1.05% 1.73%
As % of the Database & Business Intelligence category 3.77% 3.28% 4.96%
Number of salaries quoted 49 60 100
Hampshire median annual salary £50,000 £45,000 £45,000
Median salary % change year-on-year +11.11% - -
10th Percentile £37,250 £28,123 £35,000
90th Percentile £82,300 £58,750 £60,750
South East median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - +11.11%

Data Warehouse is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Hampshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Hampshire
Permanent vacancies with a requirement for database or business intelligence skills 1,858 1,921 2,417
As % of all permanent IT jobs advertised in Hampshire 28.25% 31.94% 34.89%
Number of salaries quoted 1,530 1,741 2,202
Hampshire median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -
10th Percentile £29,250 £26,250 £26,250
90th Percentile £65,000 £63,750 £58,000
South East median annual salary £46,500 £45,000 £45,000
% change year-on-year +3.33% - +5.88%

Data Warehouse
Job Vacancy Trend in Hampshire

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Hampshire.

Job vacancy trend for Data Warehouse in Hampshire

Data Warehouse
Salary Trend in Hampshire

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

Salary trend for Data Warehouse in Hampshire

Data Warehouse
Salary Histogram in Hampshire

The salary distribution of IT jobs citing Data Warehouse in Hampshire over the 6 months to 22 July 2018.

Salary histogram for Data Warehouse in Hampshire

Data Warehouse
Job Locations in Hampshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Hampshire region over the 6 months to 22 July 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Basingstoke -13 14 £97,000 +76.36% 2
Portsmouth +13 12 £47,500 -5.00% 1
Southampton -6 12 £50,000 +21.21% 3
Fareham +10 5 £47,500 -1.04% 1
Farnborough -1 5 £50,000 +25.00% 1
Havant -6 4 £45,000 +32.35%
Ringwood - 4 £37,500 -
Winchester +4 2 £40,000 +35.98% 1
Eastleigh - 1 £52,500 - 3
Data Warehouse
South East

For the 6 months to 22 July 2018, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Hampshire region with a requirement for Data Warehouse.

1 49 (70.00%) SQL
2 42 (60.00%) Business Intelligence
3 38 (54.29%) SQL Server
4 30 (42.86%) ETL
5 26 (37.14%) Microsoft
6 25 (35.71%) Performance Tuning
7 24 (34.29%) SQL Server Reporting Services
8 23 (32.86%) SQL Server Integration Services
9 20 (28.57%) Oracle
10 19 (27.14%) SQL Server Analysis Services
11 18 (25.71%) Data Modelling
12 17 (24.29%) T-SQL
12 17 (24.29%) Agile Software Development
12 17 (24.29%) Data Architecture
13 15 (21.43%) OLAP
13 15 (21.43%) Windows
14 14 (20.00%) PL/SQL
15 13 (18.57%) Migration
15 13 (18.57%) Analytical Skills
15 13 (18.57%) Big Data
16 12 (17.14%) Analytics
16 12 (17.14%) Hadoop
16 12 (17.14%) Clustering
17 11 (15.71%) Linux
17 11 (15.71%) Data Migration
17 11 (15.71%) Oracle OLAP
17 11 (15.71%) Oracle Database
18 10 (14.29%) Data Quality
18 10 (14.29%) Data Guard
18 10 (14.29%) NoSQL

Data Warehouse
Co-occurring IT Skills in Hampshire by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 8 (11.43%) Oracle Application Server
2 7 (10.00%) Apache Spark
3 5 (7.14%) Apache
4 4 (5.71%) Apache Solr
5 3 (4.29%) Apache Pig
6 1 (1.43%) CMS
6 1 (1.43%) Umbraco
Applications
1 8 (11.43%) MS Visio
2 4 (5.71%) Microsoft Excel
3 1 (1.43%) Adobe Illustrator
3 1 (1.43%) Photoshop
Business Applications
1 4 (5.71%) SAP ERP
2 1 (1.43%) Infor M3
2 1 (1.43%) Magento
2 1 (1.43%) SAP S/4HANA
Cloud Services
1 7 (10.00%) Microsoft Azure
2 6 (8.57%) Amazon AWS
3 4 (5.71%) Cortana Intelligence Suite
3 4 (5.71%) SaaS
4 2 (2.86%) Amazon EMR
4 2 (2.86%) Azure Machine Learning
4 2 (2.86%) Google Cloud Platform
4 2 (2.86%) PaaS
4 2 (2.86%) Serverless
5 1 (1.43%) Adobe Creative Cloud
5 1 (1.43%) GitHub
Communications & Networking
1 8 (11.43%) SAN
2 5 (7.14%) Internet
3 2 (2.86%) LTE
4 1 (1.43%) Extranet
Database & Business Intelligence
1 38 (54.29%) SQL Server
2 24 (34.29%) SQL Server Reporting Services
3 23 (32.86%) SQL Server Integration Services
4 19 (27.14%) SQL Server Analysis Services
5 15 (21.43%) OLAP
6 13 (18.57%) Big Data
7 12 (17.14%) Hadoop
8 11 (15.71%) Oracle Database
8 11 (15.71%) Oracle OLAP
9 10 (14.29%) NoSQL
9 10 (14.29%) SQL Server 2016
10 9 (12.86%) OLTP
10 9 (12.86%) SQL Server 2014
11 8 (11.43%) Microsoft Analysis Services
11 8 (11.43%) SQLPlus
11 8 (11.43%) Star Schema
12 6 (8.57%) Apache Cassandra
13 5 (7.14%) Apache Hive
13 5 (7.14%) Azure SQL Database
13 5 (7.14%) MongoDB
Development Applications
1 8 (11.43%) JIRA
2 5 (7.14%) Visual Studio
3 2 (2.86%) Visual Studio Team System
4 1 (1.43%) Axure RP
4 1 (1.43%) Bitbucket
4 1 (1.43%) Git (software)
4 1 (1.43%) SQL Server Management Studio (SSMS)
4 1 (1.43%) Sublime Text
4 1 (1.43%) Subversion
General
1 8 (11.43%) Finance
2 7 (10.00%) Marketing
3 5 (7.14%) Retail
4 4 (5.71%) Legal
5 3 (4.29%) Advertising
6 1 (1.43%) Law
Job Titles
1 27 (38.57%) DBA
2 23 (32.86%) Developer
3 14 (20.00%) SQL DBA
3 14 (20.00%) SQL Server DBA
4 9 (12.86%) Oracle DBA
5 8 (11.43%) SQL Developer
5 8 (11.43%) SQL Server Developer
6 7 (10.00%) Administrator
6 7 (10.00%) Architect
7 6 (8.57%) Data Architect
7 6 (8.57%) Data Engineer
8 4 (5.71%) Big Data Architect
8 4 (5.71%) Big Data Engineer
8 4 (5.71%) Business Intelligence Developer
8 4 (5.71%) Head of Architecture
8 4 (5.71%) Head of IT
8 4 (5.71%) Internet Developer
8 4 (5.71%) SAP BW Developer
8 4 (5.71%) SAP Developer
9 3 (4.29%) DB2 Administrator
Libraries, Frameworks & Software Standards
1 9 (12.86%) Web Services
2 8 (11.43%) .NET
3 6 (8.57%) Kafka
3 6 (8.57%) Middleware
4 2 (2.86%) AngularJS
4 2 (2.86%) GeoJSON
4 2 (2.86%) JSON
4 2 (2.86%) REST
4 2 (2.86%) SAML
5 1 (1.43%) ASP.NET
5 1 (1.43%) CSS
5 1 (1.43%) CSS3
5 1 (1.43%) HTML
5 1 (1.43%) HTML5
5 1 (1.43%) jQuery
5 1 (1.43%) Kendo UI
5 1 (1.43%) Razor View Engine
5 1 (1.43%) React
5 1 (1.43%) RESTful
5 1 (1.43%) Sass
Miscellaneous
1 13 (18.57%) Analytical Skills
2 12 (17.14%) Clustering
3 8 (11.43%) Management Information System
3 8 (11.43%) Replication
4 4 (5.71%) Data Structures
5 3 (4.29%) Greenfield Project
5 3 (4.29%) HACMP
6 2 (2.86%) Data Centre
Operating Systems
1 15 (21.43%) Windows
2 11 (15.71%) Linux
3 9 (12.86%) Unix
3 9 (12.86%) Windows Server
4 3 (4.29%) AIX
4 3 (4.29%) Red Hat Enterprise Linux
Processes & Methodologies
1 42 (60.00%) Business Intelligence
2 30 (42.86%) ETL
3 25 (35.71%) Performance Tuning
4 18 (25.71%) Data Modelling
5 17 (24.29%) Agile Software Development
5 17 (24.29%) Data Architecture
6 13 (18.57%) Migration
7 12 (17.14%) Analytics
8 11 (15.71%) Data Migration
9 10 (14.29%) ITIL
10 9 (12.86%) Data Integration
10 9 (12.86%) Problem-Solving
11 8 (11.43%) Continuous Improvement
11 8 (11.43%) Data Governance
11 8 (11.43%) PRINCE2
12 6 (8.57%) Data Management
12 6 (8.57%) High Availability
12 6 (8.57%) Machine Learning
12 6 (8.57%) Performance Management
12 6 (8.57%) TOGAF
Programming Languages
1 49 (70.00%) SQL
2 17 (24.29%) T-SQL
3 14 (20.00%) PL/SQL
4 9 (12.86%) Java
5 7 (10.00%) PowerShell
6 4 (5.71%) C
6 4 (5.71%) C#
6 4 (5.71%) JavaScript
7 3 (4.29%) Korn
7 3 (4.29%) Python
7 3 (4.29%) Shell Script
8 2 (2.86%) VB
9 1 (1.43%) Data Analysis Expressions (DAX)
9 1 (1.43%) Perl
9 1 (1.43%) PHP
9 1 (1.43%) VB.NET
Qualifications
1 8 (11.43%) Degree
2 4 (5.71%) SC Cleared
2 4 (5.71%) Security Cleared
3 2 (2.86%) OCP
3 2 (2.86%) Oracle Certification
3 2 (2.86%) TOGAF Certification
4 1 (1.43%) MCP
4 1 (1.43%) MCSE
4 1 (1.43%) Microsoft Certification
Quality Assurance & Compliance
1 10 (14.29%) Data Quality
2 1 (1.43%) PCI DSS
System Software
1 3 (4.29%) Veritas Cluster Server
2 1 (1.43%) Docker
Systems Management
1 10 (14.29%) Data Guard
2 4 (5.71%) Opscode Chef
3 3 (4.29%) Puppet
3 3 (4.29%) Terraform
3 3 (4.29%) Tivoli
3 3 (4.29%) Tivoli Storage Manager
4 1 (1.43%) Oozie
Vendors
1 26 (37.14%) Microsoft
2 20 (28.57%) Oracle
3 7 (10.00%) Tableau
4 5 (7.14%) Databricks
4 5 (7.14%) Google
4 5 (7.14%) SAP
5 3 (4.29%) Facebook
5 3 (4.29%) IBM
5 3 (4.29%) Red Hat
5 3 (4.29%) Veritas
6 2 (2.86%) Cognos
7 1 (1.43%) Adobe
7 1 (1.43%) IFS
7 1 (1.43%) Marketo