Period
to 23 October 2018

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

Data Warehousing
Hertfordshire > Watford
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 77 70 66
Rank change year-on-year -7 -4 +11
Permanent jobs citing Data Warehouse 20 30 30
As % of all permanent IT jobs advertised in Watford 2.12% 2.94% 3.09%
As % of the Database & Business Intelligence category 6.47% 11.11% 15.46%
Number of salaries quoted 10 27 30
Watford median annual salary £55,000 £55,000 £53,750
Median salary % change year-on-year - +2.33% +9.69%
10th Percentile £42,500 £29,900 £32,500
90th Percentile £69,300 £95,000 £65,125
Hertfordshire median annual salary £54,750 £55,000 £52,500
% change year-on-year -0.45% +4.76% +7.14%

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 309 270 194
As % of all permanent IT jobs advertised in Watford 32.80% 26.50% 19.98%
Number of salaries quoted 249 225 175
Watford median annual salary £47,500 £52,500 £50,000
Median salary % change year-on-year -9.52% +5.00% +11.11%
10th Percentile £33,750 £33,750 £32,500
90th Percentile £67,500 £71,250 £70,000
Hertfordshire median annual salary £50,000 £47,250 £50,000
% change year-on-year +5.82% -5.50% +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 23 October 2018.

Salary histogram for Data Warehouse in Watford

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

1 17 (85.00%) SQL
2 13 (65.00%) SQL Server
3 12 (60.00%) T-SQL
3 12 (60.00%) Business Intelligence
4 11 (55.00%) SQL Server Reporting Services
4 11 (55.00%) SQL Server Integration Services
4 11 (55.00%) Microsoft
4 11 (55.00%) SQL Server Analysis Services
4 11 (55.00%) MDX
4 11 (55.00%) Power BI
5 9 (45.00%) Performance Tuning
6 7 (35.00%) Data Modelling
6 7 (35.00%) ETL
6 7 (35.00%) MS Access
6 7 (35.00%) VBA
6 7 (35.00%) SQL Server 2012
6 7 (35.00%) ETL Development
6 7 (35.00%) SQL Server 2016
6 7 (35.00%) Problem-Solving
6 7 (35.00%) Unit Testing
6 7 (35.00%) PowerShell
6 7 (35.00%) Database Tuning
6 7 (35.00%) Team Foundation Server
7 6 (30.00%) Data Quality
7 6 (30.00%) Data Lineage
7 6 (30.00%) Analytical Skills
7 6 (30.00%) Data Governance
8 5 (25.00%) Degree
9 4 (20.00%) Firewall
9 4 (20.00%) Management Information System

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:

Application Platforms
1 1 (5.00%) JBoss
1 1 (5.00%) Tomcat
1 1 (5.00%) WebLogic
1 1 (5.00%) WebSphere
1 1 (5.00%) WebSphere Application Server
Cloud Services
1 4 (20.00%) Microsoft Azure
Communications & Networking
1 4 (20.00%) DNS
1 4 (20.00%) Firewall
Database & Business Intelligence
1 13 (65.00%) SQL Server
2 11 (55.00%) Power BI
2 11 (55.00%) SQL Server Analysis Services
2 11 (55.00%) SQL Server Integration Services
2 11 (55.00%) SQL Server Reporting Services
3 7 (35.00%) MS Access
3 7 (35.00%) SQL Server 2012
3 7 (35.00%) SQL Server 2016
4 4 (20.00%) SAP Data Services
5 1 (5.00%) DB2
5 1 (5.00%) MySQL
5 1 (5.00%) OLTP
Development Applications
1 7 (35.00%) Team Foundation Server
General
1 2 (10.00%) Finance
2 1 (5.00%) Retail
Job Titles
1 12 (60.00%) Developer
2 9 (45.00%) Business Intelligence Developer
3 7 (35.00%) Analyst
3 7 (35.00%) SQL Developer
4 6 (30.00%) Data Warehouse Developer
4 6 (30.00%) ETL Developer
4 6 (30.00%) SQL BI Developer
5 4 (20.00%) Data Analyst
5 4 (20.00%) Database Developer
5 4 (20.00%) SQL Database Developer
5 4 (20.00%) SSIS Developer
6 3 (15.00%) Data Warehouse Analyst
7 2 (10.00%) Data Quality Analyst
8 1 (5.00%) Data Business Analyst
8 1 (5.00%) Governance Analyst
8 1 (5.00%) QA Leader
8 1 (5.00%) QA Test Manager
8 1 (5.00%) Senior Architect
8 1 (5.00%) Senior Infrastructure Architect
8 1 (5.00%) Test Project Leader
Libraries, Frameworks & Software Standards
1 11 (55.00%) MDX
2 4 (20.00%) .NET
2 4 (20.00%) REST
2 4 (20.00%) SOAP
2 4 (20.00%) Web Services
3 1 (5.00%) J2EE
3 1 (5.00%) Middleware
3 1 (5.00%) RabbitMQ
3 1 (5.00%) SAML
Miscellaneous
1 6 (30.00%) Analytical Skills
2 4 (20.00%) Computer Science
2 4 (20.00%) Greenfield Project
2 4 (20.00%) Management Information System
3 1 (5.00%) Enterprise Software
3 1 (5.00%) Mobile Payment
3 1 (5.00%) PKI
Operating Systems
1 3 (15.00%) Linux
2 1 (5.00%) AIX
2 1 (5.00%) Solaris
2 1 (5.00%) Unix
2 1 (5.00%) Windows
Processes & Methodologies
1 12 (60.00%) Business Intelligence
2 9 (45.00%) Performance Tuning
3 7 (35.00%) Data Modelling
3 7 (35.00%) Database Tuning
3 7 (35.00%) ETL
3 7 (35.00%) ETL Development
3 7 (35.00%) Problem-Solving
3 7 (35.00%) Unit Testing
4 6 (30.00%) Data Governance
4 6 (30.00%) Data Lineage
5 4 (20.00%) Continuous Improvement
5 4 (20.00%) Migration
5 4 (20.00%) Time Management
5 4 (20.00%) Visualisation
6 2 (10.00%) Dimensional Modelling
6 2 (10.00%) PRINCE2
6 2 (10.00%) Test Strategy
7 1 (5.00%) Functional Testing
7 1 (5.00%) Non-Functional Testing
7 1 (5.00%) Root Cause Analysis
Programming Languages
1 17 (85.00%) SQL
2 12 (60.00%) T-SQL
3 7 (35.00%) PowerShell
3 7 (35.00%) VBA
4 4 (20.00%) Data Analysis Expressions (DAX)
5 2 (10.00%) Java
6 1 (5.00%) Shell Script
Qualifications
1 5 (25.00%) Degree
Quality Assurance & Compliance
1 6 (30.00%) Data Quality
2 1 (5.00%) QA
System Software
1 1 (5.00%) Microsoft App-V
1 1 (5.00%) VMware Infrastructure
Systems Management
1 1 (5.00%) OpenView
1 1 (5.00%) Tivoli
Vendors
1 11 (55.00%) Microsoft
2 4 (20.00%) SAP
3 2 (10.00%) Oracle
4 1 (5.00%) AppDynamics
4 1 (5.00%) BMC
4 1 (5.00%) IBM
4 1 (5.00%) New Relic
4 1 (5.00%) Sun
4 1 (5.00%) Sybase
4 1 (5.00%) VMware