Period
to 12 June 2021

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 12 June 2021 with a comparison to the same period in the previous 2 years.

Enterprise Data Warehouse (EDW)
UK
6 months to
12 Jun 2021
Same period 2020 Same period 2019
Rank 788 776 923
Rank change year-on-year -12 +147 +117
Permanent jobs citing Enterprise Data Warehouse 154 103 188
As % of all permanent jobs advertised in the UK 0.15% 0.12% 0.13%
As % of the Database & Business Intelligence category 0.58% 0.45% 0.47%
Number of salaries quoted 111 99 142
10th Percentile £29,075 £41,550 £41,025
25th Percentile £42,250 £47,750 £45,313
Median annual salary (50th Percentile) £60,000 £67,500 £65,000
Median % change year-on-year -11.11% +3.85% +8.33%
75th Percentile £79,375 £78,750 £70,938
90th Percentile £82,500 £87,500 £82,500
UK excluding London median annual salary £50,000 £70,000 £62,500
% change year-on-year -28.57% +12.00% +19.05%

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 26,738 22,903 40,417
As % of all permanent IT jobs advertised in the UK 26.72% 27.12% 28.12%
Number of salaries quoted 19,446 18,762 33,255
10th Percentile £33,750 £32,500 £31,250
25th Percentile £41,250 £41,250 £37,500
Median annual salary (50th Percentile) £55,000 £54,000 £52,000
Median % change year-on-year +1.85% +3.85% +4.00%
75th Percentile £75,000 £72,500 £70,000
90th Percentile £90,000 £90,000 £85,000
UK excluding London median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% -

Enterprise Data Warehouse
Job Vacancy Trend

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

Job vacancy trend for Enterprise Data Warehouse in the UK

Enterprise Data Warehouse
Salary Trend

3-month moving average salary quoted in jobs citing Enterprise Data Warehouse.

Salary trend for Enterprise Data Warehouse in the UK

Enterprise Data Warehouse
Salary Histogram

Salary distribution for jobs citing Enterprise Data Warehouse over the 6 months to 12 June 2021.

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 12 June 2021. 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 +7 135 £70,000 - 10
UK excluding London -6 108 £50,000 -28.57% 5
North of England +4 41 £45,000 -6.25% 1
London -25 36 £80,000 +18.52% 5
Yorkshire -10 27 £31,650 -5.52% 1
South East -7 24 £82,500 +8.20% 1
Work from Home -178 21 £50,000 +49.25%
North West -10 14 £50,000 +4.17%
West Midlands -32 14 £72,500 +42.16% 1
Midlands -43 14 £72,500 +42.16% 1
Scotland -28 12 £40,250 -15.26%
East of England -11 11 £85,000 +21.43%
South West - 6 £42,500 - 2

For the 6 months to 12 June 2021, 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 152 (98.70%) Data Warehouse
2 107 (69.48%) Business Intelligence
3 99 (64.29%) SQL
4 82 (53.25%) Analytics
5 73 (47.40%) Azure
6 72 (46.75%) ETL
7 62 (40.26%) Data Lake
8 56 (36.36%) Power Platform
8 56 (36.36%) Power BI
9 54 (35.06%) Finance
10 53 (34.42%) Data Modelling
11 47 (30.52%) Data Architecture
12 44 (28.57%) SQL Server Integration Services
12 44 (28.57%) Social Skills
13 43 (27.92%) Data Quality
14 41 (26.62%) Visualisation
14 41 (26.62%) Agile Software Development
14 41 (26.62%) Azure Data Factory
15 40 (25.97%) SQL Server Reporting Services
16 38 (24.68%) Data Analysis
16 38 (24.68%) SQL Server
17 37 (24.03%) Databricks
18 34 (22.08%) Data Governance
18 34 (22.08%) Decision-Making
18 34 (22.08%) Azure Synapse Analytics
19 33 (21.43%) Python
20 32 (20.78%) SQL Server Analysis Services
21 30 (19.48%) Data Strategy
22 29 (18.83%) Data Engineering
23 27 (17.53%) AWS

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 12 (7.79%) Apache Spark
2 8 (5.19%) Apache
3 6 (3.90%) Apache Synapse
4 4 (2.60%) Confluence
4 4 (2.60%) SAS
5 3 (1.95%) Apache Airflow
6 2 (1.30%) SharePoint
Applications
1 10 (6.49%) Microsoft Excel
2 3 (1.95%) Microsoft Office
Business Applications
1 8 (5.19%) Oracle EBS
2 7 (4.55%) Magento
3 2 (1.30%) Oracle Applications
3 2 (1.30%) Oracle EBS R12
3 2 (1.30%) Oracle Financials
4 1 (0.65%) SAP BPC
4 1 (0.65%) SAP S/4HANA
Cloud Services
1 73 (47.40%) Azure
2 56 (36.36%) Power Platform
3 41 (26.62%) Azure Data Factory
4 34 (22.08%) Azure Synapse Analytics
5 27 (17.53%) AWS
6 15 (9.74%) Azure Machine Learning
7 13 (8.44%) Snowflake
8 10 (6.49%) GCP
9 9 (5.84%) Azure Stack
10 7 (4.55%) Serverless
11 6 (3.90%) Azure Functions
12 4 (2.60%) PaaS
13 3 (1.95%) Amazon Kinesis
13 3 (1.95%) IaaS
14 2 (1.30%) Cloud Computing
14 2 (1.30%) PowerApps
15 1 (0.65%) Azure Cosmos DB
15 1 (0.65%) Microsoft 365
Communications & Networking
1 4 (2.60%) DNS
1 4 (2.60%) OpenVPN
1 4 (2.60%) SSL
Database & Business Intelligence
1 152 (98.70%) Data Warehouse
2 62 (40.26%) Data Lake
3 56 (36.36%) Power BI
4 44 (28.57%) SQL Server Integration Services
5 40 (25.97%) SQL Server Reporting Services
6 38 (24.68%) SQL Server
7 32 (20.78%) SQL Server Analysis Services
8 26 (16.88%) Tableau
9 22 (14.29%) Relational Database
10 18 (11.69%) Azure SQL Data Warehouse
10 18 (11.69%) Azure SQL Database
10 18 (11.69%) NoSQL
11 15 (9.74%) Big Data
12 11 (7.14%) Delta Lake
13 10 (6.49%) MongoDB
14 9 (5.84%) Oracle Reports
15 8 (5.19%) Essbase
15 8 (5.19%) Hadoop
15 8 (5.19%) Oracle BI EE
15 8 (5.19%) Spark SQL
Development Applications
1 8 (5.19%) Git (software)
2 4 (2.60%) Jenkins
2 4 (2.60%) JIRA
3 3 (1.95%) ERwin
3 3 (1.95%) SQL Server Management Studio (SSMS)
4 1 (0.65%) Team Foundation Server
4 1 (0.65%) TeamCity
General
1 54 (35.06%) Finance
2 44 (28.57%) Social Skills
3 17 (11.04%) Analytical Skills
4 8 (5.19%) Law
4 8 (5.19%) Marketing
5 6 (3.90%) Presentation Skills
6 4 (2.60%) Banking
6 4 (2.60%) Games
7 3 (1.95%) Legal
7 3 (1.95%) Local Government
8 1 (0.65%) Retail
Job Titles
1 38 (24.68%) Data Engineer
2 36 (23.38%) Architect
3 31 (20.13%) Data Architect
4 23 (14.94%) Analyst
5 21 (13.64%) Azure Engineer
6 20 (12.99%) Developer
7 19 (12.34%) Data Governance Specialist
8 18 (11.69%) Azure Architect
9 17 (11.04%) Business Intelligence Developer
10 9 (5.84%) SQL Analyst
11 8 (5.19%) Business Intelligence Analyst
12 7 (4.55%) Business Analyst
12 7 (4.55%) Investment Banking Business Analyst
12 7 (4.55%) Oracle Analyst
12 7 (4.55%) Python Engineer
12 7 (4.55%) Technical Analyst
12 7 (4.55%) Technical Business Analyst
13 6 (3.90%) Data Analyst
13 6 (3.90%) Senior Architect
13 6 (3.90%) Senior Data Architect
Libraries, Frameworks & Software Standards
1 9 (5.84%) MDX
1 9 (5.84%) PySpark
2 8 (5.19%) Kafka
2 8 (5.19%) XML
3 4 (2.60%) Elastic Stack
4 3 (1.95%) HTML
5 2 (1.30%) .NET
5 2 (1.30%) Oracle Fusion
6 1 (0.65%) Apache NiFi
6 1 (0.65%) JSON
6 1 (0.65%) Web Services
Miscellaneous
1 19 (12.34%) Taxonomies
2 15 (9.74%) Management Information System
3 8 (5.19%) Life Science
4 6 (3.90%) Cloud Native
5 2 (1.30%) Reference Data
6 1 (0.65%) Greenfield Project
6 1 (0.65%) Machine to Machine
6 1 (0.65%) User Experience
Operating Systems
1 4 (2.60%) Linux
Processes & Methodologies
1 107 (69.48%) Business Intelligence
2 82 (53.25%) Analytics
3 72 (46.75%) ETL
4 53 (34.42%) Data Modelling
5 47 (30.52%) Data Architecture
6 41 (26.62%) Agile Software Development
6 41 (26.62%) Visualisation
7 38 (24.68%) Data Analysis
8 34 (22.08%) Data Governance
8 34 (22.08%) Decision-Making
9 30 (19.48%) Data Strategy
10 29 (18.83%) Data Engineering
11 25 (16.23%) Collaborative Working
11 25 (16.23%) Data Visualisation
12 22 (14.29%) Migration
13 21 (13.64%) Data Migration
14 20 (12.99%) Data Analytics
15 19 (12.34%) Artificial Intelligence
15 19 (12.34%) DevOps
15 19 (12.34%) Problem-Solving
Programming Languages
1 99 (64.29%) SQL
2 33 (21.43%) Python
3 24 (15.58%) T-SQL
4 18 (11.69%) Scala
5 12 (7.79%) R
6 9 (5.84%) C#
7 7 (4.55%) PL/SQL
8 6 (3.90%) Java
9 4 (2.60%) Bash Shell
9 4 (2.60%) Go
9 4 (2.60%) Kotlin
10 2 (1.30%) Data Analysis Expressions (DAX)
10 2 (1.30%) HiveQL
10 2 (1.30%) Shell Script
10 2 (1.30%) Tcl
11 1 (0.65%) VB.NET
11 1 (0.65%) VBA
Qualifications
1 16 (10.39%) Degree
2 8 (5.19%) Master's Degree
2 8 (5.19%) PhD
3 5 (3.25%) TOGAF Certification
Quality Assurance & Compliance
1 43 (27.92%) Data Quality
2 4 (2.60%) QA
3 3 (1.95%) GDPR
System Software
1 10 (6.49%) Docker
Systems Management
1 10 (6.49%) Kubernetes
2 2 (1.30%) Oozie
Vendors
1 37 (24.03%) Databricks
2 25 (16.23%) Microsoft
3 15 (9.74%) Oracle
4 8 (5.19%) Google
5 7 (4.55%) Salesforce.com
6 5 (3.25%) Talend
7 4 (2.60%) Teradata
8 3 (1.95%) Xamarin
9 2 (1.30%) ESRI
9 2 (1.30%) Hyperion
9 2 (1.30%) SAP
10 1 (0.65%) Informatica
10 1 (0.65%) Splunk