Period
to 15 October 2019

The following table provides summary statistics for permanent job vacancies 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 15 October 2019 with a comparison to the same period in the previous 2 years.

Enterprise Data Warehouse (EDW)
UK
6 months to
15 Oct 2019
Same period 2018 Same period 2017
Rank 904 1018 1010
Rank change year-on-year +114 -8 -11
Permanent jobs citing Enterprise Data Warehouse 167 148 182
As % of all permanent IT jobs advertised in the UK 0.12% 0.090% 0.10%
As % of the Database & Business Intelligence category 0.45% 0.30% 0.34%
Number of salaries quoted 132 104 127
UK median annual salary £65,000 £70,000 £51,500
Median salary % change year-on-year -7.14% +35.92% -14.17%
10th Percentile £44,833 £42,500 £37,500
90th Percentile £93,750 £94,250 £71,750
UK excluding London median annual salary £52,500 £60,000 £45,000
% change year-on-year -12.50% +33.33% -14.29%

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 37,147 48,585 52,948
As % of all permanent IT jobs advertised in the UK 27.01% 29.52% 30.46%
Number of salaries quoted 30,451 39,654 43,565
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,500 £31,250 £30,000
90th Percentile £86,250 £82,500 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +2.41%

Enterprise Data Warehouse
Job Vacancy Trend

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

Job vacancy trend for Enterprise Data Warehouse in the UK

Enterprise Data Warehouse
Salary Trend

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

Salary trend for Enterprise Data Warehouse in the UK

Enterprise Data Warehouse
Salary Histogram

The salary distribution of IT jobs citing Enterprise Data Warehouse over the 6 months to 15 October 2019.

Salary histogram for Enterprise Data Warehouse in the UK

Enterprise Data Warehouse
Top 13 Job Locations

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 UK over the 6 months to 15 October 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
England +122 143 £65,000 -7.14% 19
London +100 87 £65,000 -7.14% 9
UK excluding London +83 74 £52,500 -12.50% 14
North of England +33 25 £65,000 +18.18% 4
North West +47 19 £65,000 +18.18% 1
Scotland +26 16 £52,500 +35.48% 3
East of England +83 15 £52,500 -12.50%
South West +12 8 £55,000 -31.25% 1
South East +43 7 £60,000 -4.00% 2
Yorkshire +8 6 £47,500 -13.64% 3
Wales - 2 £41,000 - 1
East Midlands +25 1 £44,000 -9.74% 1
Midlands +24 1 £44,000 -45.00% 3

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

1 160 (95.81%) Data Warehouse
2 114 (68.26%) ETL
3 107 (64.07%) Business Intelligence
4 98 (58.68%) SQL
5 87 (52.10%) Agile Software Development
6 75 (44.91%) SQL Server
7 71 (42.51%) Data Architecture
8 67 (40.12%) Analytics
9 64 (38.32%) Azure
10 53 (31.74%) SDLC
10 53 (31.74%) Power BI
10 53 (31.74%) Power Platform
11 50 (29.94%) Data Modelling
12 49 (29.34%) Oracle
12 49 (29.34%) Microsoft
13 47 (28.14%) SQL Server Integration Services
14 46 (27.54%) SQL Server Analysis Services
15 44 (26.35%) Kimball Methodology
16 42 (25.15%) SQL Server Reporting Services
17 41 (24.55%) Analytical Skills
18 40 (23.95%) AWS
19 36 (21.56%) Data Integration
20 34 (20.36%) Degree
21 33 (19.76%) PL/SQL
22 31 (18.56%) SAP
22 31 (18.56%) Master Data Management
22 31 (18.56%) Data Analysis Expressions (DAX)
23 30 (17.96%) Tableau
23 30 (17.96%) Data Quality
23 30 (17.96%) Finance

Enterprise Data Warehouse
Co-occurring IT Skills 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 16 (9.58%) Apache Spark
2 15 (8.98%) Oracle SOA Suite
3 6 (3.59%) Apache Pig
4 3 (1.80%) Apache
Applications
1 4 (2.40%) Microsoft Excel
2 2 (1.20%) Microsoft Office
2 2 (1.20%) MS Visio
2 2 (1.20%) SPSS
Business Applications
1 3 (1.80%) SAP ERP
2 2 (1.20%) SAP S/4HANA
Cloud Services
1 64 (38.32%) Azure
2 53 (31.74%) Power Platform
3 40 (23.95%) AWS
4 20 (11.98%) GCP
5 7 (4.19%) Azure Data Factory
6 4 (2.40%) Amazon S3
6 4 (2.40%) PaaS
6 4 (2.40%) Serverless
7 2 (1.20%) Cloud Computing
8 1 (0.60%) IaaS
Communications & Networking
1 9 (5.39%) Broadband
2 5 (2.99%) Internet
Database & Business Intelligence
1 160 (95.81%) Data Warehouse
2 75 (44.91%) SQL Server
3 53 (31.74%) Power BI
4 47 (28.14%) SQL Server Integration Services
5 46 (27.54%) SQL Server Analysis Services
6 42 (25.15%) SQL Server Reporting Services
7 25 (14.97%) BusinessObjects
8 24 (14.37%) Oracle Database
9 21 (12.57%) PostgreSQL
9 21 (12.57%) Relational Database
10 20 (11.98%) OLTP
10 20 (11.98%) SAP Data Services
11 19 (11.38%) Hadoop
11 19 (11.38%) OLAP
12 18 (10.78%) Azure SQL Database
13 17 (10.18%) Oracle Database 12c
14 16 (9.58%) SQL Server 2016
14 16 (9.58%) Star Schema
15 15 (8.98%) Big Data
15 15 (8.98%) BigQuery
Development Applications
1 5 (2.99%) Team Foundation Server
2 4 (2.40%) Git (software)
3 3 (1.80%) Subversion
4 2 (1.20%) JIRA
5 1 (0.60%) Hudson
General
1 30 (17.96%) Finance
2 7 (4.19%) Banking
3 4 (2.40%) Advertising
3 4 (2.40%) Marketing
4 1 (0.60%) Back Office
4 1 (0.60%) Games
4 1 (0.60%) Retail Banking
Job Titles
1 67 (40.12%) Developer
2 37 (22.16%) Business Intelligence Developer
3 33 (19.76%) Architect
4 28 (16.77%) Data Architect
5 21 (12.57%) DBA
6 20 (11.98%) Data Engineer
7 19 (11.38%) Administrator
8 18 (10.78%) Lead Developer
9 15 (8.98%) Senior Business Intelligence Developer
9 15 (8.98%) Senior Developer
10 12 (7.19%) ETL Developer
11 11 (6.59%) Data Warehouse Developer
12 9 (5.39%) Analyst
12 9 (5.39%) Business Intelligence Lead
12 9 (5.39%) SQL Developer
13 7 (4.19%) Data Analyst
13 7 (4.19%) Enterprise Architect
13 7 (4.19%) Enterprise Data Architect
13 7 (4.19%) Senior Data Engineer
13 7 (4.19%) Solutions Architect
Libraries, Frameworks & Software Standards
1 22 (13.17%) Web Services
2 7 (4.19%) Apache Flex
2 7 (4.19%) RESTful
2 7 (4.19%) SOAP
2 7 (4.19%) XML
3 6 (3.59%) JSON
3 6 (3.59%) REST
4 5 (2.99%) Node.js
5 4 (2.40%) Pyramid
6 3 (1.80%) Kafka
6 3 (1.80%) MDX
Miscellaneous
1 41 (24.55%) Analytical Skills
2 30 (17.96%) Data Centre
3 15 (8.98%) Replication
4 13 (7.78%) Management Information System
4 13 (7.78%) Self-Motivation
5 5 (2.99%) Data Structures
5 5 (2.99%) Virtual Team
6 4 (2.40%) Reinsurance
7 3 (1.80%) Cloud Native
8 2 (1.20%) Greenfield Project
8 2 (1.20%) Reference Data
9 1 (0.60%) Marketing Technology
Operating Systems
1 15 (8.98%) Linux
2 3 (1.80%) Unix
Processes & Methodologies
1 114 (68.26%) ETL
2 107 (64.07%) Business Intelligence
3 87 (52.10%) Agile Software Development
4 71 (42.51%) Data Architecture
5 67 (40.12%) Analytics
6 53 (31.74%) SDLC
7 50 (29.94%) Data Modelling
8 44 (26.35%) Kimball Methodology
9 36 (21.56%) Data Integration
10 31 (18.56%) Master Data Management
11 29 (17.37%) Dashboard Development
12 28 (16.77%) Computer Science
13 27 (16.17%) Data Management
14 24 (14.37%) Business Analytics
15 21 (12.57%) Performance Optimisation
16 20 (11.98%) Data Governance
17 19 (11.38%) Data Strategy
17 19 (11.38%) Information Management
17 19 (11.38%) Machine Learning
18 18 (10.78%) Software Engineering
Programming Languages
1 98 (58.68%) SQL
2 33 (19.76%) PL/SQL
3 31 (18.56%) Data Analysis Expressions (DAX)
4 29 (17.37%) T-SQL
5 24 (14.37%) Python
6 10 (5.99%) C#
7 6 (3.59%) Java
7 6 (3.59%) R
7 6 (3.59%) VB
8 5 (2.99%) JavaScript
9 4 (2.40%) PowerShell
9 4 (2.40%) U-SQL
9 4 (2.40%) VBA
10 2 (1.20%) MATLAB
11 1 (0.60%) C
11 1 (0.60%) Scala
Qualifications
1 34 (20.36%) Degree
2 24 (14.37%) Computer Science Degree
3 5 (2.99%) ISTQB
4 3 (1.80%) ISEB
4 3 (1.80%) PhD
4 3 (1.80%) Security Cleared
5 2 (1.20%) ITIL Foundation Certificate
5 2 (1.20%) Microsoft Certification
6 1 (0.60%) DBS Check
6 1 (0.60%) Master's Degree
6 1 (0.60%) Numerate Degree
Quality Assurance & Compliance
1 30 (17.96%) Data Quality
2 15 (8.98%) SLA
3 6 (3.59%) GDPR
4 4 (2.40%) QA
5 2 (1.20%) PMO
Systems Management
1 15 (8.98%) Foglight
1 15 (8.98%) LiteSpeed
2 10 (5.99%) SCOM
3 7 (4.19%) BMC PATROL
4 2 (1.20%) Oozie
Vendors
1 49 (29.34%) Microsoft
1 49 (29.34%) Oracle
2 31 (18.56%) SAP
3 30 (17.96%) Tableau
4 20 (11.98%) Teradata
5 14 (8.38%) Informatica
6 8 (4.79%) Cognos
6 8 (4.79%) Vertica
7 7 (4.19%) IBM
7 7 (4.19%) Netezza
8 4 (2.40%) Ab Initio
8 4 (2.40%) Alteryx
8 4 (2.40%) Databricks
8 4 (2.40%) MicroStrategy
9 3 (1.80%) Cloudera
9 3 (1.80%) Google
9 3 (1.80%) Hortonworks
9 3 (1.80%) Salesforce.com
9 3 (1.80%) Talend
10 2 (1.20%) Dataiku