The table below looks at the statistics for Data Warehouse skills in IT jobs advertised for the Hertfordshire region. Included is a guide to the salaries offered in IT jobs that have cited Data Warehouse over the 3 months to 3 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
3 May 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 95 115 87
Rank change year-on-year
+20 -28
Permanent jobs citing Data Warehouse 50 46 69
As % of all permanent IT jobs located in Hertfordshire 2.25% 1.98% 2.72%
As % of the Database & Business Intelligence category 9.82% 5.84% 9.34%
Number of salaries quoted 45 32 49
Median salary £52,500 £52,250 £47,500
Median salary % change year-on-year
+0.47% +10.00%
90% offered a salary of more than £30,600 £40,000 £22,500
10% offered a salary of more than £69,000 £69,500 £72,500
UK excluding London median salary £45,000 £45,000 £45,000
Data Warehouse
East of England

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the Hertfordshire region.

Database & Business Intelligence Category
Hertfordshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
509 788 739
As % of all permanent IT jobs located in Hertfordshire 22.94% 33.91% 29.16%
Number of salaries quoted 422 657 641
Median salary £45,000 £47,500 £42,500
Median salary % change year-on-year
-5.26% +11.76%
90% offered a salary of more than £31,500 £30,000 £32,000
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London median salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

Data Warehouse
Jobs Demand Trend in Hertfordshire

The demand trend of job ads across the Hertfordshire region citing Data Warehouse as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

Data Warehouse Jobs Demand Trend 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 across the Hertfordshire region.

Data Warehouse Salary Trend in Hertfordshire

Data Warehouse
Salary Histogram in Hertfordshire

This chart provides a salary histogram for IT jobs citing Data Warehouse across the Hertfordshire region over the 3 months to 3 May 2016.

Data Warehouse Salary Histogram 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 3 months to 3 May 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Stevenage - 9 £41,000 -
Hemel Hempstead +11 5 £47,500 +2.15%
Broxbourne - 3 £60,000 -
Watford +7 2 £53,750 -8.51%
Bishop's Stortford - 1 £50,000 -
Potters Bar - 1 £50,000 -
Rickmansworth - 1 £75,000 -
Royston - 1 £50,000 -
Data Warehouse
East of England

Data Warehouse
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 3 May 2016, 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 98 (79.03%) Business Intelligence
2 94 (75.81%) SQL
3 69 (55.65%) SQL Server
4 67 (54.03%) SQL Server Integration Services
5 65 (52.42%) SQL Server Reporting Services
6 56 (45.16%) T-SQL
7 44 (35.48%) Microsoft
7 44 (35.48%) Data Integration
8 43 (34.68%) MS Excel
9 38 (30.65%) ETL
10 31 (25.00%) Analytical Skills
10 31 (25.00%) SQL Server Analysis Services
11 29 (23.39%) Oracle
12 21 (16.94%) Analytics
13 20 (16.13%) Degree
14 17 (13.71%) Computer Science
14 17 (13.71%) Tableau
15 15 (12.10%) Hadoop
15 15 (12.10%) OLAP
16 14 (11.29%) Finance
16 14 (11.29%) Retail
17 13 (10.48%) Data Analysis
17 13 (10.48%) PL/SQL
17 13 (10.48%) Data Modelling
18 12 (9.68%) ERP
18 12 (9.68%) Migration
18 12 (9.68%) Dimensional Modelling
18 12 (9.68%) Oracle Database
19 11 (8.87%) Data Analytics
19 11 (8.87%) MDX

Data Warehouse
Top Related 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 9 (7.26%) SAS
2 7 (5.65%) SharePoint
3 5 (4.03%) Apache Spark
4 3 (2.42%) IIS
Applications
1 43 (34.68%) MS Excel
2 2 (1.61%) MS Office
Business Applications
1 4 (3.23%) JDE OneWorld
2 2 (1.61%) Dynamics AX
2 2 (1.61%) Dynamics CRM
2 2 (1.61%) JDE EnterpriseOne
2 2 (1.61%) MetaTrader
2 2 (1.61%) Oracle Applications
3 1 (0.81%) Oracle EBS
3 1 (0.81%) SAP BPC
Cloud Services
1 5 (4.03%) Amazon AWS
1 5 (4.03%) Amazon Kinesis
2 2 (1.61%) Microsoft Azure
2 2 (1.61%) Office 365
Communications & Networking
1 1 (0.81%) Firewall
Database & Business Intelligence
1 69 (55.65%) SQL Server
2 67 (54.03%) SQL Server Integration Services
3 65 (52.42%) SQL Server Reporting Services
4 31 (25.00%) SQL Server Analysis Services
5 15 (12.10%) Hadoop
5 15 (12.10%) OLAP
6 12 (9.68%) Oracle Database
7 11 (8.87%) Oracle BI EE
8 10 (8.06%) Enterprise Data Warehouse
9 9 (7.26%) Data Mining
10 8 (6.45%) Oracle OLAP
11 7 (5.65%) Microsoft Analysis Services
11 7 (5.65%) Oracle BI Publisher
11 7 (5.65%) QlikView
12 6 (4.84%) Big Data
12 6 (4.84%) OLAP Cube
13 5 (4.03%) HBase
13 5 (4.03%) SQL Server 2008
13 5 (4.03%) SQL Server 2012
14 4 (3.23%) Star Schema
Development Applications
1 2 (1.61%) Oracle Forms
1 2 (1.61%) Team Foundation Server
1 2 (1.61%) Visual Studio
General
1 14 (11.29%) Finance
1 14 (11.29%) Retail
2 5 (4.03%) Games
3 4 (3.23%) Marketing
4 3 (2.42%) Advertising
4 3 (2.42%) Manufacturing
5 1 (0.81%) Back Office
5 1 (0.81%) Banking
5 1 (0.81%) Pharmaceutical
Job Titles
1 57 (45.97%) Developer
2 49 (39.52%) SQL Developer
3 37 (29.84%) Business Intelligence Developer
4 35 (28.23%) SQL BI Developer
5 26 (20.97%) Analyst
6 15 (12.10%) Architect
6 15 (12.10%) Data Architect
7 11 (8.87%) Report Analyst
7 11 (8.87%) Senior Analyst
7 11 (8.87%) Senior Reporting Analyst
8 9 (7.26%) Oracle Analyst
8 9 (7.26%) Senior Oracle Analyst
9 8 (6.45%) DBA
9 8 (6.45%) Excel Developer
9 8 (6.45%) SQL DBA
9 8 (6.45%) SQL Server Developer
9 8 (6.45%) Tableau Developer
10 7 (5.65%) SQL Server DBA
11 6 (4.84%) Data Warehouse Analyst
11 6 (4.84%) Junior
Libraries, Frameworks & Software Standards
1 11 (8.87%) MDX
2 5 (4.03%) Apache Camel
3 4 (3.23%) .NET
4 3 (2.42%) HTML
5 2 (1.61%) .NET Framework
5 2 (1.61%) Ajax
5 2 (1.61%) ASP.NET
5 2 (1.61%) ASP.NET MVC
5 2 (1.61%) ASP.NET Web Forms
5 2 (1.61%) CSS
5 2 (1.61%) Entity Framework
5 2 (1.61%) jQuery
5 2 (1.61%) JSON
5 2 (1.61%) REST
5 2 (1.61%) SOAP
5 2 (1.61%) Twitter Bootstrap
5 2 (1.61%) Web Services
5 2 (1.61%) XML
6 1 (0.81%) COM
Miscellaneous
1 44 (35.48%) Data Integration
2 31 (25.00%) Analytical Skills
3 17 (13.71%) Computer Science
4 7 (5.65%) Mathematics
5 6 (4.84%) Data Structures
6 5 (4.03%) Data Conversion
6 5 (4.03%) Physics
7 4 (3.23%) Replication
8 3 (2.42%) Clustering
8 3 (2.42%) Data Extraction
8 3 (2.42%) Management Information System
9 2 (1.61%) Visualisation
10 1 (0.81%) Economics
10 1 (0.81%) Statistics
Operating Systems
1 2 (1.61%) Linux
1 2 (1.61%) Windows
2 1 (0.81%) Red Hat Enterprise Linux
2 1 (0.81%) Windows Server
2 1 (0.81%) Windows Server 2008
2 1 (0.81%) Windows Server 2012
Processes & Methodologies
1 98 (79.03%) Business Intelligence
2 38 (30.65%) ETL
3 21 (16.94%) Analytics
4 13 (10.48%) Data Analysis
4 13 (10.48%) Data Modelling
5 12 (9.68%) Dimensional Modelling
5 12 (9.68%) ERP
5 12 (9.68%) Migration
6 11 (8.87%) Data Analytics
6 11 (8.87%) Data Migration
7 10 (8.06%) Agile Software Development
8 9 (7.26%) E-Commerce
8 9 (7.26%) Mentoring
9 8 (6.45%) Performance Tuning
9 8 (6.45%) Quality Management
10 7 (5.65%) Data Management
10 7 (5.65%) Project Management
10 7 (5.65%) Technical Architecture
11 6 (4.84%) CRM
11 6 (4.84%) Kimball Methodology
Programming Languages
1 94 (75.81%) SQL
2 56 (45.16%) T-SQL
3 13 (10.48%) PL/SQL
4 8 (6.45%) VB
5 7 (5.65%) VBA
6 6 (4.84%) Java
6 6 (4.84%) VBScript
7 5 (4.03%) Python
7 5 (4.03%) Scala
8 2 (1.61%) C#
8 2 (1.61%) Data Analysis Expressions (DAX)
8 2 (1.61%) JavaScript
8 2 (1.61%) Shell Script
9 1 (0.81%) PowerShell
Qualifications
1 20 (16.13%) Degree
2 2 (1.61%) Oracle Certification
Quality Assurance & Compliance
1 5 (4.03%) Data Quality
System Software
1 1 (0.81%) Hyper-V
1 1 (0.81%) VMware Infrastructure
1 1 (0.81%) vSphere
Systems Management
1 1 (0.81%) HP Data Protector
1 1 (0.81%) SCCM
1 1 (0.81%) SCOM
Vendors
1 44 (35.48%) Microsoft
2 29 (23.39%) Oracle
3 17 (13.71%) Tableau
4 9 (7.26%) Netezza
4 9 (7.26%) Teradata
5 5 (4.03%) JD Edwards
6 4 (3.23%) SAP
7 3 (2.42%) MicroStrategy
8 2 (1.61%) Cognos
8 2 (1.61%) Facebook
8 2 (1.61%) VMware
9 1 (0.81%) 3PAR
9 1 (0.81%) Endeca
9 1 (0.81%) HP
9 1 (0.81%) Informatica
9 1 (0.81%) Red Hat
9 1 (0.81%) RedGate