Period
to 20 November 2017

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

Data Warehousing
Hertfordshire > Watford
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 66 59 77
Rank change year-on-year -7 +18 +23
Permanent jobs citing Data Warehouse 33 32 25
As % of all permanent IT jobs advertised in Watford 3.40% 3.10% 2.34%
As % of the Database & Business Intelligence category 11.54% 15.76% 7.16%
Number of salaries quoted 30 32 23
Watford median annual salary £55,000 £55,000 £49,000
Median salary % change year-on-year - +12.24% -2.00%
10th Percentile £29,900 £32,500 £35,000
90th Percentile £74,750 £79,750 £58,750
Hertfordshire median annual salary £53,750 £52,500 £49,000
% change year-on-year +2.38% +7.14% +3.16%

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 Watford with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Watford
Permanent vacancies with a requirement for database or business intelligence skills 286 203 349
As % of all permanent IT jobs advertised in Watford 29.42% 19.65% 32.71%
Number of salaries quoted 249 188 277
Watford median annual salary £55,000 £50,000 £45,000
Median salary % change year-on-year +10.00% +11.11% +8.43%
10th Percentile £33,750 £32,500 £27,800
90th Percentile £68,750 £72,500 £61,100
Hertfordshire median annual salary £47,500 £50,000 £45,000
% change year-on-year -5.00% +11.11% -

Data Warehouse
Job Vacancy Trend in Watford

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

Job vacancy trend for Data Warehouse in Watford

Data Warehouse
Salary Trend in Watford

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

Salary trend for Data Warehouse in Watford

Data Warehouse
Salary Histogram in Watford

The salary distribution of IT jobs citing Data Warehouse in Watford over the 6 months to 20 November 2017.

Salary histogram for Data Warehouse in Watford

For the 6 months to 20 November 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 Watford region with a requirement for Data Warehouse.

1 32 (96.97%) SQL
2 31 (93.94%) ETL
3 24 (72.73%) Business Intelligence
3 24 (72.73%) Data Modelling
3 24 (72.73%) SQL Server
3 24 (72.73%) SQL Server Integration Services
4 20 (60.61%) SQL Server Analysis Services
5 19 (57.58%) T-SQL
6 18 (54.55%) Microsoft
7 17 (51.52%) .NET
7 17 (51.52%) SQL Server 2012
7 17 (51.52%) Kimball Methodology
7 17 (51.52%) Power BI
8 16 (48.48%) Inmon Methodology
8 16 (48.48%) REST
8 16 (48.48%) PowerShell
8 16 (48.48%) Database Tuning
8 16 (48.48%) Team Foundation Server
8 16 (48.48%) Unit Testing
8 16 (48.48%) Performance Tuning
8 16 (48.48%) ETL Development
8 16 (48.48%) SQL Server 2014
8 16 (48.48%) SQL Server 2016
8 16 (48.48%) SOAP
8 16 (48.48%) Web Services
8 16 (48.48%) VBA
8 16 (48.48%) MS Access
8 16 (48.48%) Cognos
8 16 (48.48%) IBM
8 16 (48.48%) MDX

Data Warehouse
Co-occurring IT Skills in Watford 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:

Applications
1 2 (6.06%) Microsoft Excel
Communications & Networking
1 14 (42.42%) DNS
1 14 (42.42%) Firewall
Database & Business Intelligence
1 24 (72.73%) SQL Server
1 24 (72.73%) SQL Server Integration Services
2 20 (60.61%) SQL Server Analysis Services
3 17 (51.52%) Power BI
3 17 (51.52%) SQL Server 2012
4 16 (48.48%) MS Access
4 16 (48.48%) SQL Server 2014
4 16 (48.48%) SQL Server 2016
5 14 (42.42%) SAP Data Services
6 9 (27.27%) SAP BW
7 7 (21.21%) Oracle Database
8 4 (12.12%) SQL Server Reporting Services
9 3 (9.09%) Oracle ODI
10 2 (6.06%) Microsoft Analysis Services
11 1 (3.03%) Big Data
11 1 (3.03%) Data Lake
11 1 (3.03%) OLAP
11 1 (3.03%) OLAP Cube
11 1 (3.03%) RDBMS
11 1 (3.03%) Relational Database
Development Applications
1 16 (48.48%) Team Foundation Server
2 1 (3.03%) Visual Studio
General
1 6 (18.18%) Finance
2 3 (9.09%) Banking
3 2 (6.06%) Legal
Job Titles
1 31 (93.94%) Developer
2 20 (60.61%) Business Intelligence Developer
3 8 (24.24%) Senior Developer
4 7 (21.21%) Data Warehouse Developer
5 6 (18.18%) Senior Data Warehouse Developer
6 5 (15.15%) ETL Developer
6 5 (15.15%) Microsoft BI Developer
7 4 (12.12%) Junior
7 4 (12.12%) Junior Developer
7 4 (12.12%) Junior ETL Developer
7 4 (12.12%) Microsoft Developer
8 3 (9.09%) Analyst
9 2 (6.06%) Business Analyst
9 2 (6.06%) Insurance Business Analyst
9 2 (6.06%) Software Analyst
9 2 (6.06%) SQL BI Developer
9 2 (6.06%) SQL Developer
9 2 (6.06%) SQL Server BI Developer
9 2 (6.06%) SQL Server Developer
9 2 (6.06%) SSIS Developer
Libraries, Frameworks & Software Standards
1 17 (51.52%) .NET
2 16 (48.48%) MDX
2 16 (48.48%) REST
2 16 (48.48%) SOAP
2 16 (48.48%) Web Services
Miscellaneous
1 4 (12.12%) Analytical Skills
1 4 (12.12%) NHS
2 3 (9.09%) Management Information System
3 1 (3.03%) Computer Science
Processes & Methodologies
1 31 (93.94%) ETL
2 24 (72.73%) Business Intelligence
2 24 (72.73%) Data Modelling
3 17 (51.52%) Kimball Methodology
4 16 (48.48%) Database Tuning
4 16 (48.48%) ETL Development
4 16 (48.48%) Inmon Methodology
4 16 (48.48%) Performance Tuning
4 16 (48.48%) Unit Testing
5 7 (21.21%) Agile Software Development
6 5 (15.15%) SDLC
7 4 (12.12%) Data Extraction
7 4 (12.12%) Data Protection
7 4 (12.12%) Disaster Recovery
7 4 (12.12%) Parallel Processing
7 4 (12.12%) Physical Data Model
8 3 (9.09%) Mentoring
8 3 (9.09%) OO
8 3 (9.09%) OOA/OOD
8 3 (9.09%) Waterfall
Programming Languages
1 32 (96.97%) SQL
2 19 (57.58%) T-SQL
3 16 (48.48%) PowerShell
3 16 (48.48%) VBA
4 6 (18.18%) PL/SQL
5 3 (9.09%) Shell Script
6 1 (3.03%) C#
6 1 (3.03%) VB.NET
Qualifications
1 5 (15.15%) Degree
Systems Management
1 4 (12.12%) Tivoli
Vendors
1 18 (54.55%) Microsoft
2 16 (48.48%) Cognos
2 16 (48.48%) IBM
3 11 (33.33%) SAP
4 7 (21.21%) Oracle
4 7 (21.21%) Teradata