Period
to 25 April 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 25 April 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
South East > Hampshire
6 months to
25 Apr 2018
Same period 2017 Same period 2016
Rank 189 174 183
Rank change year-on-year -15 +9 -33
Permanent jobs citing Data Warehouse 87 68 88
As % of all permanent IT jobs advertised in Hampshire 1.21% 1.13% 1.31%
As % of the Database & Business Intelligence category 3.72% 3.69% 3.85%
Number of salaries quoted 79 64 75
Hampshire median annual salary £42,500 £43,750 £45,000
Median salary % change year-on-year -2.86% -2.78% +0.56%
10th Percentile £28,875 £29,750 £33,250
90th Percentile £52,500 £53,375 £66,300
South East median annual salary £50,000 £50,000 £45,500
% change year-on-year - +9.89% -3.70%

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 2,339 1,843 2,288
As % of all permanent IT jobs advertised in Hampshire 32.50% 30.50% 34.13%
Number of salaries quoted 2,047 1,655 2,081
Hampshire median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - -
10th Percentile £27,500 £26,250 £26,250
90th Percentile £62,500 £62,500 £60,000
South East median annual salary £45,000 £45,000 £45,000

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 25 April 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 25 April 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
Southampton -13 33 £32,500 -18.75% 3
Havant -1 13 £45,000 +12.50%
Portsmouth +2 8 £47,500 +18.72% 10
Winchester -9 8 £29,500 +0.28%
Ringwood - 4 £37,500 - 1
Basingstoke - 3 - -
Farnborough - 3 £50,000 -
Fareham +4 2 - - 3
Wallington - 2 £45,000 -
Hook - 1 £55,000 -
Data Warehouse
South East

For the 6 months to 25 April 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 80 (91.95%) SQL
2 73 (83.91%) SQL Server
3 58 (66.67%) Business Intelligence
4 54 (62.07%) SQL Server Reporting Services
5 48 (55.17%) SQL Server Integration Services
6 40 (45.98%) SQL Server Analysis Services
7 36 (41.38%) T-SQL
8 27 (31.03%) Performance Tuning
9 25 (28.74%) Power BI
10 24 (27.59%) Analytical Skills
11 22 (25.29%) ETL
12 19 (21.84%) Microsoft
13 16 (18.39%) Analytics
14 14 (16.09%) PowerShell
14 14 (16.09%) Data Modelling
15 13 (14.94%) Windows
15 13 (14.94%) Data Transformation
15 13 (14.94%) Relational Database
16 12 (13.79%) Digital Transformation Programme
16 12 (13.79%) Performance Management
16 12 (13.79%) Tableau
17 11 (12.64%) Data Quality
17 11 (12.64%) SQL Server 2016
18 10 (11.49%) Proactive Monitoring
18 10 (11.49%) Database Mirroring
18 10 (11.49%) SQL Server 2005
18 10 (11.49%) C#
18 10 (11.49%) OLAP
18 10 (11.49%) .NET
19 9 (10.34%) Business Continuity

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 3 (3.45%) SAS
2 2 (2.30%) Apache Spark
Applications
1 5 (5.75%) Microsoft Excel
Business Applications
1 4 (4.60%) SAP ERP
Cloud Services
1 7 (8.05%) Amazon AWS
1 7 (8.05%) Microsoft Azure
2 2 (2.30%) Amazon EMR
2 2 (2.30%) Google Cloud Platform
Communications & Networking
1 4 (4.60%) Internet
Database & Business Intelligence
1 73 (83.91%) SQL Server
2 54 (62.07%) SQL Server Reporting Services
3 48 (55.17%) SQL Server Integration Services
4 40 (45.98%) SQL Server Analysis Services
5 25 (28.74%) Power BI
6 13 (14.94%) Relational Database
7 11 (12.64%) SQL Server 2016
8 10 (11.49%) OLAP
8 10 (11.49%) SQL Server 2005
9 8 (9.20%) Microsoft Analysis Services
10 7 (8.05%) Big Data
10 7 (8.05%) SQL Server 2014
11 6 (6.90%) Oracle Database
12 5 (5.75%) OLAP Cube
12 5 (5.75%) RDBMS
12 5 (5.75%) SQL Server 2008
13 4 (4.60%) Amazon RDS
13 4 (4.60%) Data Mart
13 4 (4.60%) Oracle OLAP
13 4 (4.60%) SAP BW
Development Applications
1 3 (3.45%) JIRA
2 2 (2.30%) Visual Studio
General
1 4 (4.60%) Advertising
2 3 (3.45%) Finance
2 3 (3.45%) Marketing
3 2 (2.30%) Retail
4 1 (1.15%) Law
Job Titles
1 46 (52.87%) Developer
2 26 (29.89%) Business Intelligence Developer
3 25 (28.74%) SQL Developer
4 23 (26.44%) SQL Server Developer
5 22 (25.29%) DBA
6 20 (22.99%) SQL DBA
7 19 (21.84%) Systems Developer
7 19 (21.84%) T-SQL Developer
8 16 (18.39%) SQL Server DBA
9 13 (14.94%) SQL BI Developer
9 13 (14.94%) SSIS Developer
9 13 (14.94%) SSRS Developer
10 12 (13.79%) SQL Server BI Developer
11 10 (11.49%) Analyst
11 10 (11.49%) Business Intelligence Analyst
12 8 (9.20%) Administrator
13 7 (8.05%) Production DBA
13 7 (8.05%) SQL Server Production DBA
14 5 (5.75%) Business Intelligence Data Analyst
14 5 (5.75%) SQL Analyst
Libraries, Frameworks & Software Standards
1 10 (11.49%) .NET
2 7 (8.05%) CSS
2 7 (8.05%) HTML
2 7 (8.05%) XML
3 5 (5.75%) Middleware
4 2 (2.30%) MDX
Miscellaneous
1 24 (27.59%) Analytical Skills
2 7 (8.05%) Clustering
3 5 (5.75%) Replication
4 3 (3.45%) Management Information System
5 2 (2.30%) Data Centre
6 1 (1.15%) Greenfield Project
6 1 (1.15%) Self-Motivation
Operating Systems
1 13 (14.94%) Windows
2 4 (4.60%) Windows Server
Processes & Methodologies
1 58 (66.67%) Business Intelligence
2 27 (31.03%) Performance Tuning
3 22 (25.29%) ETL
4 16 (18.39%) Analytics
5 14 (16.09%) Data Modelling
6 13 (14.94%) Data Transformation
7 12 (13.79%) Digital Transformation Programme
7 12 (13.79%) Performance Management
8 10 (11.49%) Database Mirroring
8 10 (11.49%) Proactive Monitoring
9 9 (10.34%) Business Continuity
9 9 (10.34%) Data Analysis
9 9 (10.34%) Data Governance
9 9 (10.34%) Database Security
9 9 (10.34%) ETL Development
9 9 (10.34%) High Availability
10 8 (9.20%) Continuous Improvement
11 7 (8.05%) Data Architecture
12 6 (6.90%) Data Extraction
13 5 (5.75%) Visualisation
Programming Languages
1 80 (91.95%) SQL
2 36 (41.38%) T-SQL
3 14 (16.09%) PowerShell
4 10 (11.49%) C#
5 7 (8.05%) JavaScript
5 7 (8.05%) VB.NET
6 5 (5.75%) C
7 2 (2.30%) Data Analysis Expressions (DAX)
7 2 (2.30%) PL/SQL
7 2 (2.30%) VB
8 1 (1.15%) Python
Qualifications
1 4 (4.60%) SC Cleared
1 4 (4.60%) Security Cleared
2 2 (2.30%) OCP
2 2 (2.30%) Oracle Certification
3 1 (1.15%) TOGAF Certification
Quality Assurance & Compliance
1 11 (12.64%) Data Quality
2 4 (4.60%) PCI DSS
3 1 (1.15%) QA
Systems Management
1 2 (2.30%) Data Guard
2 1 (1.15%) Oozie
2 1 (1.15%) Opscode Chef
Vendors
1 19 (21.84%) Microsoft
2 12 (13.79%) Tableau
3 9 (10.34%) Oracle
4 7 (8.05%) SAP
5 4 (4.60%) Teradata
6 3 (3.45%) Atlassian
6 3 (3.45%) Facebook
6 3 (3.45%) MuleSoft
6 3 (3.45%) SolarWinds
7 2 (2.30%) Cognos
7 2 (2.30%) Google
8 1 (1.15%) IBM