Period
to 4 June 2020

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

Enterprise Data Warehouse (EDW)
UK
6 months to
4 Jun 2020
Same period 2019 Same period 2018
Rank 767 914 1010
Rank change year-on-year +147 +96 +9
Permanent jobs citing Enterprise Data Warehouse 107 180 171
As % of all permanent jobs advertised in the UK 0.12% 0.13% 0.100%
As % of the Database & Business Intelligence category 0.46% 0.45% 0.32%
Number of salaries quoted 105 136 137
Median annual salary £67,500 £62,000 £60,000
Median salary % change year-on-year +8.87% +3.33% +16.50%
10th Percentile £41,250 £38,625 £40,750
90th Percentile £87,500 £83,125 £100,000
UK excluding London median annual salary £70,000 £62,500 £52,500
% change year-on-year +12.00% +19.05% +4.48%

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 23,433 40,002 52,649
As % of all permanent IT jobs advertised in the UK 26.90% 28.01% 30.75%
Number of salaries quoted 19,013 32,595 43,117
Median annual salary £54,000 £52,000 £50,000
Median salary % change year-on-year +3.85% +4.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £90,000 £85,000 £80,000
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +7.14%

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 4 June 2020.

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 4 June 2020. 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 +149 104 £70,000 +7.69% 5
UK excluding London +168 69 £70,000 +12.00% 3
South East +124 36 £77,500 +14.81%
London +104 35 £67,500 +3.85% 2
Midlands +108 13 £51,000 -2.86% 2
West Midlands +79 13 £51,000 -16.73% 2
East of England - 11 £70,000 - 1
North of England +96 7 £48,000 -26.15%
North West +78 5 £48,000 -41.82%
Yorkshire +80 2 £33,500 -48.46%
Work from Home +62 2 £33,500 -56.77% 1
Scotland +57 1 £47,500 +26.67%
Wales - 1 £50,000 -

For the 6 months to 4 June 2020, 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 107 (100.00%) Data Warehouse
2 93 (86.92%) Business Intelligence
3 61 (57.01%) Data Modelling
3 61 (57.01%) SQL
4 56 (52.34%) ETL
5 55 (51.40%) Power BI
5 55 (51.40%) Power Platform
6 50 (46.73%) Microsoft
6 50 (46.73%) SQL Server
7 47 (43.93%) SQL Server Integration Services
8 46 (42.99%) SQL Server Analysis Services
9 45 (42.06%) Analytics
10 44 (41.12%) Visualisation
11 42 (39.25%) Agile Software Development
12 41 (38.32%) Finance
13 34 (31.78%) Tableau
14 33 (30.84%) Management Information System
15 30 (28.04%) Data Quality
15 30 (28.04%) Azure
16 29 (27.10%) Requirements Gathering
17 28 (26.17%) Analytical Skills
17 28 (26.17%) SQL Server Reporting Services
18 27 (25.23%) DevOps
19 25 (23.36%) AWS
20 24 (22.43%) Data Lake
21 23 (21.50%) Data Integration
22 22 (20.56%) Reinsurance
23 21 (19.63%) Data Structures
23 21 (19.63%) Technical Leadership
24 20 (18.69%) SAP

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 4 (3.74%) Oracle SOA Suite
2 3 (2.80%) Apache Spark
3 1 (0.93%) Apache Pig
3 1 (0.93%) BizTalk Server
3 1 (0.93%) Oracle Service Bus
3 1 (0.93%) SharePoint
3 1 (0.93%) WebLogic
Applications
1 2 (1.87%) Microsoft Office
1 2 (1.87%) MS Visio
2 1 (0.93%) Microsoft Excel
Business Applications
1 7 (6.54%) SAP BPC
2 3 (2.80%) SAP ERP
3 1 (0.93%) FLEXCUBE
3 1 (0.93%) Oracle Applications
3 1 (0.93%) Oracle EBS
3 1 (0.93%) SAP IS-U
Cloud Services
1 55 (51.40%) Power Platform
2 30 (28.04%) Azure
3 25 (23.36%) AWS
4 10 (9.35%) GCP
5 5 (4.67%) Dynamics 365
6 4 (3.74%) Azure Data Factory
7 3 (2.80%) SaaS
8 2 (1.87%) Amazon Kinesis
8 2 (1.87%) Amazon S3
8 2 (1.87%) Azure Active Directory
8 2 (1.87%) Cloud Computing
Database & Business Intelligence
1 107 (100.00%) Data Warehouse
2 55 (51.40%) Power BI
3 50 (46.73%) SQL Server
4 47 (43.93%) SQL Server Integration Services
5 46 (42.99%) SQL Server Analysis Services
6 28 (26.17%) SQL Server Reporting Services
7 24 (22.43%) Data Lake
8 16 (14.95%) SAP BW
9 12 (11.21%) BusinessObjects
10 10 (9.35%) Azure SQL Database
11 8 (7.48%) Big Data
11 8 (7.48%) SQL Server 2012
12 7 (6.54%) Data Mining
12 7 (6.54%) Hadoop
12 7 (6.54%) QlikView
12 7 (6.54%) SAP HANA
13 6 (5.61%) BigQuery
13 6 (5.61%) OLAP
14 5 (4.67%) Data Mart
14 5 (4.67%) OLTP
Development Applications
1 4 (3.74%) SQL Server Management Studio (SSMS)
2 2 (1.87%) Git (software)
3 1 (0.93%) ERwin
3 1 (0.93%) JIRA
3 1 (0.93%) Oracle APEX
3 1 (0.93%) Oracle Forms
3 1 (0.93%) Team Foundation Server
3 1 (0.93%) TeamCity
3 1 (0.93%) tSQLt
General
1 41 (38.32%) Finance
2 4 (3.74%) Manufacturing
2 4 (3.74%) Marketing
3 2 (1.87%) Front Office
3 2 (1.87%) Telecoms
Job Titles
1 35 (32.71%) Developer
2 28 (26.17%) Business Intelligence Developer
3 21 (19.63%) Architect
4 18 (16.82%) Technical Leader
5 17 (15.89%) Data Architect
6 14 (13.08%) SQL Developer
7 12 (11.21%) Analyst
8 11 (10.28%) Business Intelligence Analyst
8 11 (10.28%) Business Intelligence Lead
9 9 (8.41%) Solutions Architect
9 9 (8.41%) SQL BI Developer
9 9 (8.41%) SQL Server Developer
10 8 (7.48%) AWS Architect
10 8 (7.48%) Data Engineer
10 8 (7.48%) Power BI Developer
11 7 (6.54%) Data Warehouse Developer
11 7 (6.54%) SQL Server Data Warehouse Developer
12 6 (5.61%) Business Intelligence Architect
12 6 (5.61%) SQL Server BI Developer
12 6 (5.61%) SSIS Developer
Libraries, Frameworks & Software Standards
1 9 (8.41%) Web Services
2 5 (4.67%) MDX
3 4 (3.74%) Kafka
3 4 (3.74%) Middleware
4 3 (2.80%) .NET
5 2 (1.87%) .NET Framework
5 2 (1.87%) AngularJS
5 2 (1.87%) ASP.NET
5 2 (1.87%) ASP.NET Core
5 2 (1.87%) Entity Framework
5 2 (1.87%) Razor View Engine
5 2 (1.87%) Spark Streaming
6 1 (0.93%) LDAP
6 1 (0.93%) Oracle Fusion
6 1 (0.93%) Oracle GoldenGate
6 1 (0.93%) WebCenter
6 1 (0.93%) XML
Miscellaneous
1 33 (30.84%) Management Information System
2 28 (26.17%) Analytical Skills
3 22 (20.56%) Reinsurance
4 21 (19.63%) Data Structures
5 18 (16.82%) Tandem
6 7 (6.54%) FMCG
7 3 (2.80%) Greenfield Project
8 2 (1.87%) Replication
9 1 (0.93%) Clustering
Operating Systems
1 4 (3.74%) Linux
1 4 (3.74%) Unix
Processes & Methodologies
1 93 (86.92%) Business Intelligence
2 61 (57.01%) Data Modelling
3 56 (52.34%) ETL
4 45 (42.06%) Analytics
5 44 (41.12%) Visualisation
6 42 (39.25%) Agile Software Development
7 29 (27.10%) Requirements Gathering
8 27 (25.23%) DevOps
9 23 (21.50%) Data Integration
10 21 (19.63%) Technical Leadership
11 20 (18.69%) Data Visualisation
12 18 (16.82%) Data Analysis
13 17 (15.89%) Data Governance
14 15 (14.02%) ERP
15 14 (13.08%) Data Analytics
16 12 (11.21%) Data Mapping
16 12 (11.21%) Dimensional Modelling
16 12 (11.21%) ETL Development
17 11 (10.28%) Data Architecture
17 11 (10.28%) Data Management
Programming Languages
1 61 (57.01%) SQL
2 14 (13.08%) Python
3 10 (9.35%) T-SQL
4 7 (6.54%) Data Analysis Expressions (DAX)
5 6 (5.61%) C#
6 5 (4.67%) ABAP
6 5 (4.67%) Java
7 4 (3.74%) PHP
7 4 (3.74%) R
8 3 (2.80%) PL/SQL
9 2 (1.87%) TypeScript
10 1 (0.93%) PowerShell
10 1 (0.93%) Tcl
10 1 (0.93%) VB.NET
10 1 (0.93%) VBA
Qualifications
1 3 (2.80%) Degree
2 2 (1.87%) Computer Science Degree
3 1 (0.93%) OCP
3 1 (0.93%) Oracle Certification
3 1 (0.93%) Security Cleared
Quality Assurance & Compliance
1 30 (28.04%) Data Quality
2 7 (6.54%) Sarbanes-Oxley
3 4 (3.74%) GDPR
System Software
1 2 (1.87%) Active Directory
2 1 (0.93%) HDFS
2 1 (0.93%) Oracle RAC
Systems Management
1 2 (1.87%) Kubernetes
2 1 (0.93%) Ansible
2 1 (0.93%) Data Guard
2 1 (0.93%) Oracle Enterprise Manager
2 1 (0.93%) Oracle ZFS
2 1 (0.93%) Single Sign-On
2 1 (0.93%) Terraform
Vendors
1 50 (46.73%) Microsoft
2 34 (31.78%) Tableau
3 20 (18.69%) SAP
4 17 (15.89%) Oracle
5 7 (6.54%) Google
6 6 (5.61%) Alteryx
6 6 (5.61%) Salesforce.com
7 5 (4.67%) Informatica
8 4 (3.74%) Databricks
9 3 (2.80%) Birst
9 3 (2.80%) Cognos
9 3 (2.80%) Concur
9 3 (2.80%) Infor
9 3 (2.80%) Teradata
9 3 (2.80%) Workday
10 2 (1.87%) Dataiku
11 1 (0.93%) CA Agile Central
11 1 (0.93%) Hyperion
11 1 (0.93%) PeopleSoft
11 1 (0.93%) Talend