Period
to 25 July 2017

The following table provides summary statistics for permanent job vacancies advertised in Hertfordshire 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 July 2017 with a comparison to the same period in the previous 2 years.

Data Warehousing
East of England > Hertfordshire
6 months to
25 Jul 2017
Same period 2016 Same period 2015
Rank 162 110 118
Rank change year-on-year -52 +8 -16
Permanent jobs citing Data Warehouse 51 117 139
As % of all permanent IT jobs advertised in Hertfordshire 1.19% 2.45% 2.52%
As % of the Database & Business Intelligence category 4.42% 9.85% 7.74%
Number of salaries quoted 49 104 99
Hertfordshire median annual salary £60,000 £52,500 £49,000
Median salary % change year-on-year +14.29% +7.14% +8.89%
10th Percentile £41,150 £30,200 £37,250
90th Percentile £95,000 £68,375 £64,000
East of England median annual salary £49,000 £45,000 £47,500
% change year-on-year +8.89% -5.26% +5.56%

Data Warehouse is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Hertfordshire with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
Hertfordshire
Permanent job vacancies with a requirement for database and business intelligence skills 1155 1188 1795
As % of all permanent IT job vacancies advertised in Hertfordshire 26.90% 24.87% 32.53%
Number of salaries quoted 1019 988 1498
Hertfordshire median annual salary £47,500 £45,000 £45,000
Median salary % change year-on-year +5.56% - +5.88%
10th Percentile £31,250 £27,500 £28,166
90th Percentile £70,000 £67,500 £67,500
East of England median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +4.94%

Data Warehouse
Job Vacancy Trend in Hertfordshire

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

Job vacancy trend for Data Warehouse in Hertfordshire

Data Warehouse
Salary Trend in Hertfordshire

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

Salary trend for Data Warehouse in Hertfordshire

Data Warehouse
Salary Histogram in Hertfordshire

The salary distribution of IT jobs citing Data Warehouse in Hertfordshire over the 6 months to 25 July 2017.

Salary histogram for Data Warehouse in Hertfordshire

Data Warehouse
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Hertfordshire region over the 6 months to 25 July 2017. 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
Watford -4 19 £71,250 +35.71% 1
Hatfield +7 9 £42,500 +28.79% 1
St Albans - 5 £55,000 -
Rickmansworth +3 4 £75,000 +30.43%
Hemel Hempstead -2 3 £42,500 -17.07%
Letchworth - 2 - -
Data Warehouse
East of England

For the 6 months to 25 July 2017, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Hertfordshire region with a requirement for Data Warehouse.

1 44 (86.27%) SQL
2 37 (72.55%) ETL
3 27 (52.94%) Agile Software Development
4 23 (45.10%) Oracle
5 22 (43.14%) Data Modelling
5 22 (43.14%) Teradata
6 21 (41.18%) SQL Server
7 19 (37.25%) SQL Server Integration Services
7 19 (37.25%) T-SQL
7 19 (37.25%) PL/SQL
8 18 (35.29%) Oracle Database
9 17 (33.33%) SQL Server Reporting Services
10 16 (31.37%) Finance
11 15 (29.41%) Microsoft
11 15 (29.41%) Business Intelligence
12 14 (27.45%) OO
12 14 (27.45%) SQL Server Analysis Services
13 12 (23.53%) Tivoli
13 12 (23.53%) Oracle ODI
14 11 (21.57%) SQL Server 2008
15 10 (19.61%) Shell Script
15 10 (19.61%) OOA/OOD
15 10 (19.61%) SQL Server 2012
15 10 (19.61%) Parallel Processing
15 10 (19.61%) Analytical Skills
15 10 (19.61%) SDLC
15 10 (19.61%) Physical Data Model
16 9 (17.65%) QlikView
16 9 (17.65%) Scrum
17 8 (15.69%) Banking

Data Warehouse
Co-occurring IT Skills in Hertfordshire 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 (5.88%) SharePoint
2 1 (1.96%) Apache Spark
2 1 (1.96%) SAS
Applications
1 3 (5.88%) MS Visio
2 2 (3.92%) Microsoft PowerPoint
3 1 (1.96%) Microsoft Excel
Cloud Services
1 2 (3.92%) Microsoft Azure
2 1 (1.96%) Google Cloud Platform
Communications & Networking
1 2 (3.92%) Cisco ASA
1 2 (3.92%) Firewall
1 2 (3.92%) LAN
1 2 (3.92%) VLAN
1 2 (3.92%) VPN
1 2 (3.92%) WAN
1 2 (3.92%) Wireless
Database & Business Intelligence
1 21 (41.18%) SQL Server
2 19 (37.25%) SQL Server Integration Services
3 18 (35.29%) Oracle Database
4 17 (33.33%) SQL Server Reporting Services
5 14 (27.45%) SQL Server Analysis Services
6 12 (23.53%) Oracle ODI
7 11 (21.57%) SQL Server 2008
8 10 (19.61%) SQL Server 2012
9 9 (17.65%) QlikView
10 7 (13.73%) Big Data
11 6 (11.76%) Power BI
12 5 (9.80%) OLAP
13 4 (7.84%) OLAP Cube
13 4 (7.84%) SQL Server 2016
14 3 (5.88%) DTS
14 3 (5.88%) Relational Database
14 3 (5.88%) Star Schema
15 2 (3.92%) BusinessObjects
15 2 (3.92%) Enterprise Data Warehouse
15 2 (3.92%) SQL Server 2005
Development Applications
1 2 (3.92%) Octopus Deploy
2 1 (1.96%) Visual Studio
General
1 16 (31.37%) Finance
2 8 (15.69%) Banking
3 3 (5.88%) Marketing
4 2 (3.92%) Advertising
4 2 (3.92%) Retail
5 1 (1.96%) Pharmaceutical
Job Titles
1 36 (70.59%) Developer
2 21 (41.18%) Senior Developer
3 20 (39.22%) Data Warehouse Developer
4 16 (31.37%) Senior Data Warehouse Developer
5 9 (17.65%) Business Intelligence Developer
6 7 (13.73%) SQL Developer
7 5 (9.80%) Analyst
7 5 (9.80%) Architect
7 5 (9.80%) Data Architect
7 5 (9.80%) SSIS Developer
8 4 (7.84%) Business Intelligence Analyst
8 4 (7.84%) C# Developer
8 4 (7.84%) Senior C# Developer
8 4 (7.84%) SSRS Developer
9 3 (5.88%) Analyst Developer
9 3 (5.88%) Developer Analyst
9 3 (5.88%) ETL Developer
9 3 (5.88%) Report Developer
10 2 (3.92%) SQL DBA
10 2 (3.92%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 5 (9.80%) .NET
2 4 (7.84%) AngularJS
2 4 (7.84%) ASP.NET
2 4 (7.84%) ASP.NET MVC
3 2 (3.92%) .NET Framework
3 2 (3.92%) Entity Framework
3 2 (3.92%) React
3 2 (3.92%) SAP XI
3 2 (3.92%) Twitter Bootstrap
Miscellaneous
1 10 (19.61%) Analytical Skills
2 3 (5.88%) Greenfield Project
3 2 (3.92%) Clustering
3 2 (3.92%) Computer Science
3 2 (3.92%) Data Centre
3 2 (3.92%) PMI
3 2 (3.92%) Replication
Operating Systems
1 4 (7.84%) Windows
2 2 (3.92%) Windows Server
Processes & Methodologies
1 37 (72.55%) ETL
2 27 (52.94%) Agile Software Development
3 22 (43.14%) Data Modelling
4 15 (29.41%) Business Intelligence
5 14 (27.45%) OO
6 10 (19.61%) OOA/OOD
6 10 (19.61%) Parallel Processing
6 10 (19.61%) Physical Data Model
6 10 (19.61%) SDLC
7 9 (17.65%) Scrum
8 8 (15.69%) Mentoring
9 7 (13.73%) Kimball Methodology
10 6 (11.76%) Data Integration
10 6 (11.76%) Waterfall
11 5 (9.80%) Analytics
11 5 (9.80%) Migration
12 4 (7.84%) Data Analysis
12 4 (7.84%) ITIL
12 4 (7.84%) MVC
12 4 (7.84%) TDD
Programming Languages
1 44 (86.27%) SQL
2 19 (37.25%) PL/SQL
2 19 (37.25%) T-SQL
3 10 (19.61%) Shell Script
4 5 (9.80%) C#
5 4 (7.84%) JavaScript
6 3 (5.88%) Python
7 2 (3.92%) R
8 1 (1.96%) Java
8 1 (1.96%) Scala
8 1 (1.96%) VB.NET
8 1 (1.96%) VBA
Qualifications
1 4 (7.84%) Degree
2 2 (3.92%) CBAP
2 2 (3.92%) CCNA
2 2 (3.92%) Cisco Certification
2 2 (3.92%) Computer Science Degree
2 2 (3.92%) ISEB
2 2 (3.92%) PMI Certification
3 1 (1.96%) MCSA
3 1 (1.96%) MCSE
3 1 (1.96%) Microsoft Certification
Quality Assurance & Compliance
1 2 (3.92%) SLA
System Software
1 2 (3.92%) Active Directory
1 2 (3.92%) Hyper-V
1 2 (3.92%) VMware Infrastructure
Systems Management
1 12 (23.53%) Tivoli
2 2 (3.92%) vCenter Server
Vendors
1 23 (45.10%) Oracle
2 22 (43.14%) Teradata
3 15 (29.41%) Microsoft
4 4 (7.84%) Tableau
5 2 (3.92%) Cisco
5 2 (3.92%) Informatica
5 2 (3.92%) SAP
5 2 (3.92%) VMware
6 1 (1.96%) Google
Watford, Hertfordshire
TLP Consultancy Ltd.
Salary: £50000 - £55000 per annum
Posted: 3 days ago
Hatfield, Hertfordshire
Computacenter
Salary: Benefits
Posted: 4 days ago
Hertfordshire
Harvey Nash plc
Salary: £65000 - £75000 per annum + Bonus, additional benefits
Posted: 4 days ago