Period
to 20 October 2018

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

Enterprise Data Warehouse (EDW)
UK > England
6 months to
20 Oct 2018
Same period 2017 Same period 2016
Rank 995 978 986
Rank change year-on-year -17 +8 +65
Permanent jobs citing Enterprise Data Warehouse 138 176 231
As % of all permanent IT jobs advertised in England 0.091% 0.11% 0.13%
As % of the Database & Business Intelligence category 0.31% 0.35% 0.43%
Number of salaries quoted 96 124 198
England median annual salary £70,000 £52,500 £60,000
Median salary % change year-on-year +33.33% -12.50% +4.35%
10th Percentile £42,500 £37,500 £32,500
90th Percentile £93,750 £72,125 £75,000
UK median annual salary £65,000 £52,500 £60,000
% change year-on-year +23.81% -12.50% +4.35%

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 44,929 49,633 53,342
As % of all permanent IT jobs advertised in England 29.49% 30.34% 29.61%
Number of salaries quoted 36,819 41,166 45,921
England median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £83,750 £77,500 £76,750
UK median annual salary £50,000 £48,000 £47,500
% change year-on-year +4.17% +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 20 October 2018.

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 20 October 2018. 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 +37 89 £70,000 +19.66% 17
Midlands +28 17 £80,000 +63.27% 1
West Midlands +41 13 £80,000 +82.86%
South East +12 10 £62,500 -7.41% 2
North of England +36 6 £47,500 -13.64% 3
East of England -1 6 £60,000 -
South West -16 6 £80,000 +88.24% 2
East Midlands -5 4 £48,750 -2.99% 1
Yorkshire +19 3 £37,500 -31.82% 1
North West +3 3 £51,250 -8.48% 2
Enterprise Data Warehouse
UK

For the 6 months to 20 October 2018, 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 124 (89.86%) Data Warehouse
2 105 (76.09%) Business Intelligence
3 81 (58.70%) SQL
4 71 (51.45%) SQL Server
5 60 (43.48%) ETL
6 52 (37.68%) SQL Server Integration Services
7 50 (36.23%) Agile Software Development
8 49 (35.51%) Analytics
9 46 (33.33%) Big Data
10 44 (31.88%) Data Modelling
11 41 (29.71%) Microsoft
12 40 (28.99%) Oracle
12 40 (28.99%) Visualisation
13 39 (28.26%) SQL Server Reporting Services
14 38 (27.54%) Tableau
15 37 (26.81%) T-SQL
16 36 (26.09%) Power BI
17 34 (24.64%) Data Quality
17 34 (24.64%) Hadoop
18 29 (21.01%) Dimensional Modelling
19 28 (20.29%) Microsoft Azure
19 28 (20.29%) Finance
20 26 (18.84%) SQL Server Analysis Services
21 23 (16.67%) Analytical Skills
22 22 (15.94%) PL/SQL
22 22 (15.94%) OLAP
22 22 (15.94%) Data Governance
23 21 (15.22%) Kimball Methodology
23 21 (15.22%) Kafka
23 21 (15.22%) Data Architecture

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 13 (9.42%) Apache
2 10 (7.25%) Apache Spark
3 7 (5.07%) SharePoint
4 6 (4.35%) Apache Pig
4 6 (4.35%) SAS
5 1 (0.72%) Confluence
Applications
1 12 (8.70%) Microsoft Excel
2 4 (2.90%) MS Visio
3 2 (1.45%) Microsoft Project
4 1 (0.72%) Microsoft Office
Business Applications
1 2 (1.45%) Eloqua
Cloud Services
1 28 (20.29%) Microsoft Azure
2 11 (7.97%) PaaS
3 7 (5.07%) SaaS
4 6 (4.35%) Amazon AWS
4 6 (4.35%) Azure Data Factory
5 4 (2.90%) Data Lake Analytics
6 1 (0.72%) Cloud Computing
6 1 (0.72%) Cortana Intelligence Suite
Communications & Networking
1 5 (3.62%) FTP
Database & Business Intelligence
1 124 (89.86%) Data Warehouse
2 71 (51.45%) SQL Server
3 52 (37.68%) SQL Server Integration Services
4 46 (33.33%) Big Data
5 39 (28.26%) SQL Server Reporting Services
6 36 (26.09%) Power BI
7 34 (24.64%) Hadoop
8 26 (18.84%) SQL Server Analysis Services
9 22 (15.94%) OLAP
10 21 (15.22%) Data Lake
11 17 (12.32%) Relational Database
12 13 (9.42%) BusinessObjects
12 13 (9.42%) Data Mart
13 12 (8.70%) OLTP
13 12 (8.70%) Oracle OLAP
14 11 (7.97%) MongoDB
14 11 (7.97%) NoSQL
15 10 (7.25%) MySQL
15 10 (7.25%) SAP Data Services
16 9 (6.52%) SQL Server 2016
Development Applications
1 11 (7.97%) ERwin
2 10 (7.25%) Team Foundation Server
3 7 (5.07%) ER Studio
4 4 (2.90%) JIRA
4 4 (2.90%) Visual Studio
5 2 (1.45%) Git (software)
5 2 (1.45%) Oracle APEX
5 2 (1.45%) Oracle Forms
6 1 (0.72%) Hudson
6 1 (0.72%) Visual Studio Team System
General
1 28 (20.29%) Finance
2 16 (11.59%) Marketing
3 7 (5.07%) Retail
4 5 (3.62%) Banking
5 4 (2.90%) Back Office
6 2 (1.45%) Automotive
6 2 (1.45%) Games
6 2 (1.45%) Legal
6 2 (1.45%) Manufacturing
7 1 (0.72%) Billing
7 1 (0.72%) Law
7 1 (0.72%) Pharmaceutical
Job Titles
1 47 (34.06%) Developer
2 32 (23.19%) Business Intelligence Developer
3 30 (21.74%) Architect
4 24 (17.39%) Analyst
5 19 (13.77%) Solutions Architect
6 18 (13.04%) SQL Developer
7 15 (10.87%) Data Analyst
7 15 (10.87%) Data Architect
8 12 (8.70%) Senior Business Intelligence Developer
8 12 (8.70%) Senior Developer
8 12 (8.70%) SQL BI Developer
9 11 (7.97%) Data Warehouse Analyst
10 10 (7.25%) Business Intelligence Analyst
11 9 (6.52%) Business Analyst
11 9 (6.52%) Data Business Analyst
11 9 (6.52%) Data Warehouse Business Analyst
11 9 (6.52%) SQL Analyst
12 8 (5.80%) SQL Data Analyst
13 6 (4.35%) Consultant
13 6 (4.35%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 21 (15.22%) Kafka
2 12 (8.70%) .NET
3 7 (5.07%) AngularJS
3 7 (5.07%) HTML
3 7 (5.07%) HTML5
3 7 (5.07%) jQuery
3 7 (5.07%) Node.js
3 7 (5.07%) Twitter Bootstrap
4 6 (4.35%) RabbitMQ
4 6 (4.35%) Spark Streaming
5 4 (2.90%) MDX
Miscellaneous
1 23 (16.67%) Analytical Skills
2 13 (9.42%) Data Structures
3 11 (7.97%) Hedge funds
3 11 (7.97%) Management Information System
4 10 (7.25%) NHS
5 9 (6.52%) Computer Science
6 8 (5.80%) Greenfield Project
7 5 (3.62%) Algorithms
7 5 (3.62%) Replication
7 5 (3.62%) Self-Motivation
8 4 (2.90%) Cloud Native
9 3 (2.17%) Virtual Team
10 2 (1.45%) Life Science
10 2 (1.45%) Reinsurance
11 1 (0.72%) Analytical Mindset
11 1 (0.72%) Data Centre
11 1 (0.72%) Equities
11 1 (0.72%) Mobile App
11 1 (0.72%) Reference Data
Operating Systems
1 3 (2.17%) Windows
2 2 (1.45%) Unix
Processes & Methodologies
1 105 (76.09%) Business Intelligence
2 60 (43.48%) ETL
3 50 (36.23%) Agile Software Development
4 49 (35.51%) Analytics
5 44 (31.88%) Data Modelling
6 40 (28.99%) Visualisation
7 29 (21.01%) Dimensional Modelling
8 22 (15.94%) Data Governance
9 21 (15.22%) Data Architecture
9 21 (15.22%) Kimball Methodology
10 20 (14.49%) Data Integration
11 17 (12.32%) Data Analysis
11 17 (12.32%) Project Management
12 16 (11.59%) Data Management
12 16 (11.59%) Decision-Making
12 16 (11.59%) Scrum
12 16 (11.59%) SDLC
13 15 (10.87%) Performance Tuning
14 14 (10.14%) Data Visualisation
15 13 (9.42%) Technical Architecture
Programming Languages
1 81 (58.70%) SQL
2 37 (26.81%) T-SQL
3 22 (15.94%) PL/SQL
4 19 (13.77%) Java
5 10 (7.25%) Python
6 7 (5.07%) C#
6 7 (5.07%) JavaScript
7 6 (4.35%) Scala
8 4 (2.90%) R
9 3 (2.17%) Data Analysis Expressions (DAX)
10 2 (1.45%) C
10 2 (1.45%) Delphi
10 2 (1.45%) PowerShell
10 2 (1.45%) Shell Script
11 1 (0.72%) Perl
Qualifications
1 11 (7.97%) Degree
2 8 (5.80%) Computer Science Degree
3 3 (2.17%) Security Cleared
4 2 (1.45%) Master's Degree
5 1 (0.72%) ITIL Certification
Quality Assurance & Compliance
1 34 (24.64%) Data Quality
2 12 (8.70%) QA
3 2 (1.45%) GDPR
System Software
1 7 (5.07%) Docker
2 6 (4.35%) Apache Flume
2 6 (4.35%) Apache ZooKeeper
2 6 (4.35%) HDFS
Systems Management
1 1 (0.72%) Control-M
Vendors
1 41 (29.71%) Microsoft
2 40 (28.99%) Oracle
3 38 (27.54%) Tableau
4 14 (10.14%) Informatica
5 13 (9.42%) SAP
6 10 (7.25%) Cloudera
6 10 (7.25%) Hortonworks
6 10 (7.25%) MapR
7 8 (5.80%) Teradata
8 7 (5.07%) Xamarin
9 4 (2.90%) Cognizant
9 4 (2.90%) IDERA
9 4 (2.90%) Netezza
10 3 (2.17%) Atlassian
11 2 (1.45%) Greenplum
11 2 (1.45%) Marketo
11 2 (1.45%) Talend
12 1 (0.72%) BMC
12 1 (0.72%) CheckPoint
12 1 (0.72%) WSO2