Period
to 18 January 2019

The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for Enterprise Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Enterprise Data Warehouse over the 6 months to 18 January 2019 with a comparison to the same period in the previous 2 years.

Enterprise Data Warehouse (EDW)
UK > England
6 months to
18 Jan 2019
Same period 2018 Same period 2017
Rank 965 993 974
Rank change year-on-year +28 -19 -14
Permanent jobs citing Enterprise Data Warehouse 123 183 206
As % of all permanent IT jobs advertised in England 0.087% 0.11% 0.12%
As % of the Database & Business Intelligence category 0.31% 0.37% 0.41%
Number of salaries quoted 92 131 167
England median annual salary £60,000 £55,000 £57,500
Median salary % change year-on-year +9.09% -4.35% +4.55%
10th Percentile £42,500 £37,500 £35,000
90th Percentile £95,000 £72,500 £77,500
UK median annual salary £58,500 £55,000 £57,500
% change year-on-year +6.36% -4.35% +4.55%

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

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 40,191 49,735 49,837
As % of all permanent IT jobs advertised in England 28.54% 30.53% 29.78%
Number of salaries quoted 33,269 41,595 42,992
England median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% +3.26%
10th Percentile £31,375 £30,500 £29,750
90th Percentile £85,000 £77,500 £77,500
UK median annual salary £52,500 £48,000 £47,500
% change year-on-year +9.38% +1.05% +5.56%

Enterprise Data Warehouse
Job Vacancy Trend in England

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

Job vacancy trend for Enterprise Data Warehouse in England

Enterprise Data Warehouse
Salary Trend in England

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

Salary trend for Enterprise Data Warehouse in England

Enterprise Data Warehouse
Salary Histogram in England

The salary distribution of IT jobs citing Enterprise Data Warehouse in England over the 6 months to 18 January 2019.

Salary histogram for Enterprise Data Warehouse in England

Enterprise Data Warehouse
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Enterprise Data Warehouse within the England region over the 6 months to 18 January 2019. 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
London +34 85 £58,500 -2.50% 13
Midlands +38 14 £70,000 +47.37% 3
West Midlands +41 12 £70,000 +55.56% 3
South East +36 9 £61,250 +36.11% 2
North of England +24 8 £55,000 +10.00% 3
South West +19 5 £65,000 +52.94% 1
Yorkshire -2 5 £52,500 -4.55% 2
North West +23 3 £82,500 +126.03% 1
East Midlands +12 2 £87,500 +75.00%
Enterprise Data Warehouse
UK

For the 6 months to 18 January 2019, IT jobs citing Enterprise 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 England region with a requirement for Enterprise Data Warehouse.

1 109 (88.62%) Data Warehouse
2 98 (79.67%) Business Intelligence
3 86 (69.92%) SQL
4 68 (55.28%) ETL
5 61 (49.59%) SQL Server
5 61 (49.59%) Analytics
6 53 (43.09%) Agile Software Development
7 50 (40.65%) Data Modelling
8 49 (39.84%) Oracle
9 47 (38.21%) Big Data
10 39 (31.71%) Data Quality
11 38 (30.89%) Tableau
11 38 (30.89%) Analytical Skills
12 37 (30.08%) Visualisation
13 31 (25.20%) SQL Server Integration Services
13 31 (25.20%) Hadoop
13 31 (25.20%) Microsoft Azure
14 28 (22.76%) Power BI
15 27 (21.95%) PL/SQL
15 27 (21.95%) T-SQL
16 26 (21.14%) Decision-Making
17 25 (20.33%) Data Lake
17 25 (20.33%) Dimensional Modelling
18 24 (19.51%) Kafka
19 23 (18.70%) Business Analytics
19 23 (18.70%) Microsoft
20 21 (17.07%) SAP
20 21 (17.07%) Kimball Methodology
20 21 (17.07%) Data-Driven Decision Making
21 20 (16.26%) Data Governance

Enterprise Data Warehouse
Co-occurring IT Skills in England 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 11 (8.94%) Apache Spark
2 9 (7.32%) Apache
3 8 (6.50%) SAS
4 5 (4.07%) Apache Pig
Applications
1 10 (8.13%) Microsoft Excel
2 4 (3.25%) MS Visio
3 1 (0.81%) Microsoft Office
Business Applications
1 1 (0.81%) FastStats
Cloud Services
1 31 (25.20%) Microsoft Azure
2 14 (11.38%) PaaS
3 9 (7.32%) Amazon AWS
3 9 (7.32%) SaaS
4 8 (6.50%) Data Lake Analytics
5 5 (4.07%) Azure Data Factory
6 4 (3.25%) Force.com
6 4 (3.25%) Salesforce Sales Cloud
6 4 (3.25%) Salesforce Service Cloud
7 3 (2.44%) Amazon S3
7 3 (2.44%) GitHub
8 1 (0.81%) Azure Functions
8 1 (0.81%) Cortana Intelligence Suite
8 1 (0.81%) Serverless
Database & Business Intelligence
1 109 (88.62%) Data Warehouse
2 61 (49.59%) SQL Server
3 47 (38.21%) Big Data
4 31 (25.20%) Hadoop
4 31 (25.20%) SQL Server Integration Services
5 28 (22.76%) Power BI
6 25 (20.33%) Data Lake
7 20 (16.26%) BusinessObjects
7 20 (16.26%) OLAP
8 19 (15.45%) SQL Server Reporting Services
9 17 (13.82%) SQL Server Analysis Services
10 16 (13.01%) Relational Database
10 16 (13.01%) SAP Data Services
11 15 (12.20%) MySQL
11 15 (12.20%) NoSQL
12 13 (10.57%) Data Mart
12 13 (10.57%) MongoDB
13 11 (8.94%) Oracle OLAP
13 11 (8.94%) QlikView
14 10 (8.13%) Qlik Sense
Development Applications
1 11 (8.94%) ERwin
2 9 (7.32%) ER Studio
3 5 (4.07%) Team Foundation Server
4 4 (3.25%) Oracle APEX
5 2 (1.63%) Git (software)
5 2 (1.63%) Visual Studio
6 1 (0.81%) Eclipse
6 1 (0.81%) Hudson
6 1 (0.81%) Jenkins
6 1 (0.81%) Octopus Deploy
6 1 (0.81%) TeamCity
6 1 (0.81%) tSQLt
6 1 (0.81%) Visual Studio Team System
General
1 18 (14.63%) Finance
2 11 (8.94%) Marketing
3 9 (7.32%) Retail
4 6 (4.88%) Banking
5 2 (1.63%) Billing
6 1 (0.81%) Advertising
6 1 (0.81%) Pharmaceutical
Job Titles
1 32 (26.02%) Analyst
2 31 (25.20%) Developer
3 20 (16.26%) Architect
4 19 (15.45%) Data Analyst
5 14 (11.38%) Business Intelligence Analyst
5 14 (11.38%) Business Intelligence Developer
6 13 (10.57%) Data Architect
6 13 (10.57%) Data Warehouse Analyst
7 10 (8.13%) Business Analyst
7 10 (8.13%) Solutions Architect
7 10 (8.13%) SQL Analyst
8 9 (7.32%) Data Business Analyst
8 9 (7.32%) Data Warehouse Business Analyst
8 9 (7.32%) SQL Data Analyst
9 7 (5.69%) Azure Architect
9 7 (5.69%) Senior Business Intelligence Developer
9 7 (5.69%) Senior Developer
9 7 (5.69%) SQL Developer
9 7 (5.69%) Technical Analyst
9 7 (5.69%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 24 (19.51%) Kafka
2 13 (10.57%) .NET
3 5 (4.07%) AngularJS
3 5 (4.07%) HTML
3 5 (4.07%) HTML5
3 5 (4.07%) jQuery
3 5 (4.07%) Node.js
3 5 (4.07%) Spark Streaming
3 5 (4.07%) Twitter Bootstrap
4 4 (3.25%) Apache NiFi
4 4 (3.25%) RabbitMQ
5 1 (0.81%) Spring
Miscellaneous
1 38 (30.89%) Analytical Skills
2 11 (8.94%) Greenfield Project
3 8 (6.50%) Cloud Native
3 8 (6.50%) Data Structures
4 7 (5.69%) Management Information System
4 7 (5.69%) Self-Motivation
5 5 (4.07%) NHS
6 4 (3.25%) Life Science
6 4 (3.25%) Replication
7 3 (2.44%) Algorithms
7 3 (2.44%) Hedge funds
8 1 (0.81%) Data Centre
8 1 (0.81%) Robotics
8 1 (0.81%) Smart Meter
8 1 (0.81%) User Experience
Operating Systems
1 7 (5.69%) Windows
2 5 (4.07%) Linux
3 4 (3.25%) Unix
4 3 (2.44%) Oracle Linux
Processes & Methodologies
1 98 (79.67%) Business Intelligence
2 68 (55.28%) ETL
3 61 (49.59%) Analytics
4 53 (43.09%) Agile Software Development
5 50 (40.65%) Data Modelling
6 37 (30.08%) Visualisation
7 26 (21.14%) Decision-Making
8 25 (20.33%) Dimensional Modelling
9 23 (18.70%) Business Analytics
10 21 (17.07%) Data-Driven Decision Making
10 21 (17.07%) Kimball Methodology
11 20 (16.26%) Data Governance
12 17 (13.82%) Performance Tuning
12 17 (13.82%) Scrum
13 15 (12.20%) Change Management
13 15 (12.20%) Data Science
13 15 (12.20%) User Acceptance Testing
14 14 (11.38%) Technical Architecture
14 14 (11.38%) User Stories
15 13 (10.57%) UML
Programming Languages
1 86 (69.92%) SQL
2 27 (21.95%) PL/SQL
2 27 (21.95%) T-SQL
3 20 (16.26%) Python
4 11 (8.94%) Java
5 9 (7.32%) C#
6 8 (6.50%) R
7 7 (5.69%) Shell Script
8 6 (4.88%) Scala
9 5 (4.07%) JavaScript
10 4 (3.25%) Apex Code
11 3 (2.44%) VB
12 2 (1.63%) VBA
13 1 (0.81%) Bash Shell
13 1 (0.81%) HiveQL
13 1 (0.81%) Perl
13 1 (0.81%) PowerShell
Qualifications
1 11 (8.94%) Degree
2 10 (8.13%) Computer Science Degree
3 4 (3.25%) Security Cleared
4 2 (1.63%) Master's Degree
4 2 (1.63%) SC Cleared
5 1 (0.81%) ITIL Certification
Quality Assurance & Compliance
1 39 (31.71%) Data Quality
2 14 (11.38%) QA
3 1 (0.81%) Solvency II
System Software
1 5 (4.07%) Apache Flume
1 5 (4.07%) Apache ZooKeeper
1 5 (4.07%) Docker
1 5 (4.07%) HDFS
Systems Management
1 3 (2.44%) Control-M
Vendors
1 49 (39.84%) Oracle
2 38 (30.89%) Tableau
3 23 (18.70%) Microsoft
4 21 (17.07%) SAP
5 14 (11.38%) Informatica
6 11 (8.94%) Teradata
7 8 (6.50%) Hortonworks
7 8 (6.50%) IDERA
7 8 (6.50%) Talend
8 7 (5.69%) Cloudera
8 7 (5.69%) MapR
9 6 (4.88%) Greenplum
10 5 (4.07%) Xamarin
11 4 (3.25%) Salesforce.com
12 3 (2.44%) Cognos
12 3 (2.44%) WorldPay
13 2 (1.63%) Cognizant
13 2 (1.63%) Netezza
14 1 (0.81%) Birst
14 1 (0.81%) MicroStrategy