Period
to 11 April 2021

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Warehouse over the 6 months to 11 April 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
Central London > City of London
6 months to
11 Apr 2021
Same period 2020 Same period 2019
Rank 84 85 80
Rank change year-on-year +1 -5 -7
Permanent jobs citing Data Warehouse 160 282 373
As % of all permanent jobs advertised in the City of London 3.31% 3.33% 3.63%
As % of the Database & Business Intelligence category 11.22% 13.77% 11.83%
Number of salaries quoted 138 250 356
10th Percentile £43,750 £47,500 £42,750
25th Percentile £52,500 £57,500 £52,500
Median annual salary (50th Percentile) £63,750 £70,000 £62,500
Median % change year-on-year -8.93% +12.00% -
75th Percentile £78,438 £78,438 £76,563
90th Percentile £105,000 £87,625 £85,000
Central London median annual salary £65,000 £70,000 £62,500
% change year-on-year -7.14% +12.00% -

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

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 1,426 2,048 3,152
As % of all permanent IT jobs advertised in the City of London 29.46% 24.19% 30.64%
Number of salaries quoted 1,247 1,805 2,842
10th Percentile £43,750 £42,500 £41,250
25th Percentile £53,750 £51,250 £51,250
Median annual salary (50th Percentile) £72,500 £67,500 £67,500
Median % change year-on-year +7.41% - +8.00%
75th Percentile £88,750 £83,750 £82,500
90th Percentile £105,000 £100,000 £97,500
Central London median annual salary £70,000 £67,500 £65,000
% change year-on-year +3.70% +3.85% +8.33%

Data Warehouse
Job Vacancy Trend in the City of London

Job postings citing Data Warehouse as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for Data Warehouse in the City of London

Data Warehouse
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing Data Warehouse in the City of London.

Salary trend for Data Warehouse in the City of London

Data Warehouse
Salary Histogram in the City of London

Salary distribution for jobs citing Data Warehouse in the City of London over the 6 months to 11 April 2021.

Salary histogram for Data Warehouse in the City of London

Data Warehouse
Job Locations in the City of London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the City of London region over the 6 months to 11 April 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
London Bridge +10 1 £80,000 +113.33%
Data Warehouse
Central London

For the 6 months to 11 April 2021, IT jobs citing 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 City of London region with a requirement for Data Warehouse.

1 96 (60.00%) Business Intelligence
2 88 (55.00%) ETL
3 87 (54.38%) SQL
4 74 (46.25%) SQL Server
5 66 (41.25%) Azure
6 65 (40.63%) Power BI
6 65 (40.63%) Power Platform
7 61 (38.13%) Analytics
8 57 (35.63%) SQL Server Integration Services
9 51 (31.88%) Finance
10 48 (30.00%) AWS
11 47 (29.38%) SQL Server Reporting Services
12 40 (25.00%) Data Modelling
13 39 (24.38%) SQL Server Analysis Services
14 38 (23.75%) Data Lake
15 37 (23.13%) Agile Software Development
16 33 (20.63%) Python
17 30 (18.75%) Microsoft
18 29 (18.13%) Analytical Skills
19 25 (15.63%) Tableau
20 24 (15.00%) Big Data
20 24 (15.00%) Migration
21 23 (14.38%) T-SQL
21 23 (14.38%) Visualisation
22 22 (13.75%) Data Strategy
23 21 (13.13%) Azure Data Factory
23 21 (13.13%) Amazon Redshift
23 21 (13.13%) Business Analysis
24 19 (11.88%) Decision-Making
24 19 (11.88%) Data Analysis

Data Warehouse
Co-occurring IT Skills in the City of London 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 14 (8.75%) Apache Spark
2 9 (5.63%) Apache
3 2 (1.25%) SharePoint
Applications
1 9 (5.63%) Microsoft Excel
2 1 (0.63%) Microsoft PowerPoint
2 1 (0.63%) Spreadsheet
Business Applications
1 1 (0.63%) Dynamics CRM
Cloud Services
1 66 (41.25%) Azure
2 65 (40.63%) Power Platform
3 48 (30.00%) AWS
4 21 (13.13%) Azure Data Factory
5 12 (7.50%) GCP
6 11 (6.88%) Power Automate
6 11 (6.88%) PowerApps
7 7 (4.38%) Amazon EC2
8 3 (1.88%) Amazon EMR
8 3 (1.88%) Matillion
8 3 (1.88%) SaaS
8 3 (1.88%) Serverless
9 2 (1.25%) Amazon S3
9 2 (1.25%) AWS CloudFormation
9 2 (1.25%) AWS Lambda
9 2 (1.25%) IaaS
9 2 (1.25%) Microsoft 365
9 2 (1.25%) PaaS
10 1 (0.63%) Data Lake Analytics
10 1 (0.63%) Google Analytics
Communications & Networking
1 4 (2.50%) SSH
2 1 (0.63%) HTTP
Database & Business Intelligence
1 74 (46.25%) SQL Server
2 65 (40.63%) Power BI
3 57 (35.63%) SQL Server Integration Services
4 47 (29.38%) SQL Server Reporting Services
5 39 (24.38%) SQL Server Analysis Services
6 38 (23.75%) Data Lake
7 25 (15.63%) Tableau
8 24 (15.00%) Big Data
9 21 (13.13%) Amazon Redshift
10 17 (10.63%) Hadoop
11 13 (8.13%) NoSQL
12 12 (7.50%) Microsoft Analysis Services
12 12 (7.50%) Relational Database
13 11 (6.88%) Data Mart
14 10 (6.25%) Snowflake Schema
15 9 (5.63%) Amazon RDS
16 8 (5.00%) PostgreSQL
17 7 (4.38%) MySQL
18 5 (3.13%) Azure SQL Data Warehouse
18 5 (3.13%) BusinessObjects
Development Applications
1 5 (3.13%) Team Foundation Server
2 4 (2.50%) JIRA
3 3 (1.88%) Git (software)
3 3 (1.88%) Visual Studio
4 2 (1.25%) ER Studio
4 2 (1.25%) ERwin
4 2 (1.25%) PowerDesigner
5 1 (0.63%) Toad
General
1 51 (31.88%) Finance
2 13 (8.13%) Banking
3 7 (4.38%) Back Office
4 4 (2.50%) Law
4 4 (2.50%) Marketing
5 3 (1.88%) Advertising
6 2 (1.25%) Legal
6 2 (1.25%) Public Sector
7 1 (0.63%) Front Office
7 1 (0.63%) Investment Banking
7 1 (0.63%) Music Industry
7 1 (0.63%) Retail
7 1 (0.63%) Social Housing
7 1 (0.63%) Telecoms
Job Titles
1 51 (31.88%) Developer
2 37 (23.13%) Business Intelligence Developer
3 36 (22.50%) Analyst
4 26 (16.25%) Architect
5 22 (13.75%) Data Architect
6 20 (12.50%) Data Engineer
7 15 (9.38%) Consultant
8 13 (8.13%) Power BI Developer
9 12 (7.50%) Business Intelligence Analyst
10 11 (6.88%) Applications Support
10 11 (6.88%) Azure Architect
11 10 (6.25%) Analyst Developer
12 9 (5.63%) Data Analyst
13 8 (5.00%) Data Consultant
14 7 (4.38%) Business Intelligence Consultant
14 7 (4.38%) Data Migration Consultant
14 7 (4.38%) Data Warehouse Developer
14 7 (4.38%) Migration Consultant
14 7 (4.38%) SQL Analyst
15 6 (3.75%) AWS Engineer
Libraries, Frameworks & Software Standards
1 12 (7.50%) .NET
2 9 (5.63%) Web Services
3 7 (4.38%) Kafka
4 2 (1.25%) CSS
4 2 (1.25%) HTML
4 2 (1.25%) JSON
4 2 (1.25%) MDX
4 2 (1.25%) Spark Streaming
4 2 (1.25%) WebRTC
5 1 (0.63%) GraphQL
5 1 (0.63%) GraphX
5 1 (0.63%) LDAP
5 1 (0.63%) Oracle GoldenGate
5 1 (0.63%) PySpark
5 1 (0.63%) React
5 1 (0.63%) Spring Boot
5 1 (0.63%) Vert.x
5 1 (0.63%) XML
Miscellaneous
1 29 (18.13%) Analytical Skills
2 14 (8.75%) Management Information System
3 11 (6.88%) Reinsurance
4 9 (5.63%) Data Structures
5 3 (1.88%) Data Centre
5 3 (1.88%) Derivative
5 3 (1.88%) Fixed Income
6 2 (1.25%) Equities
6 2 (1.25%) Greenfield Project
6 2 (1.25%) User Experience
7 1 (0.63%) Client/Server
7 1 (0.63%) Clustering
7 1 (0.63%) Equity Derivative
7 1 (0.63%) Mainframe
7 1 (0.63%) Music Streaming
7 1 (0.63%) Private Cloud
7 1 (0.63%) Reference Data
7 1 (0.63%) Replication
Operating Systems
1 13 (8.13%) Windows
2 9 (5.63%) Linux
2 9 (5.63%) Unix
3 7 (4.38%) Red Hat Enterprise Linux
4 1 (0.63%) Android
4 1 (0.63%) Apple iOS
Processes & Methodologies
1 96 (60.00%) Business Intelligence
2 88 (55.00%) ETL
3 61 (38.13%) Analytics
4 40 (25.00%) Data Modelling
5 37 (23.13%) Agile Software Development
6 24 (15.00%) Migration
7 23 (14.38%) Visualisation
8 22 (13.75%) Data Strategy
9 21 (13.13%) Business Analysis
10 19 (11.88%) Data Analysis
10 19 (11.88%) Decision-Making
11 18 (11.25%) Data Management
11 18 (11.25%) Problem-Solving
12 17 (10.63%) Data Integration
13 16 (10.00%) Dashboard Development
13 16 (10.00%) Data Architecture
14 15 (9.38%) Data Governance
14 15 (9.38%) Data Science
15 14 (8.75%) Data Mapping
15 14 (8.75%) Mentoring
Programming Languages
1 87 (54.38%) SQL
2 33 (20.63%) Python
3 23 (14.38%) T-SQL
4 13 (8.13%) C#
4 13 (8.13%) Data Analysis Expressions (DAX)
4 13 (8.13%) Java
5 5 (3.13%) JavaScript
5 5 (3.13%) R
6 4 (2.50%) Perl
6 4 (2.50%) Shell Script
7 3 (1.88%) Scala
8 2 (1.25%) PL/SQL
8 2 (1.25%) VB
9 1 (0.63%) Clojure
9 1 (0.63%) Julia
9 1 (0.63%) Korn
9 1 (0.63%) PowerShell
9 1 (0.63%) Ruby
Qualifications
1 15 (9.38%) Degree
2 4 (2.50%) ITIL Foundation Certificate
3 2 (1.25%) Computer Science Degree
4 1 (0.63%) Microsoft Certification
Quality Assurance & Compliance
1 16 (10.00%) Data Quality
2 11 (6.88%) QA
3 1 (0.63%) COBIT
3 1 (0.63%) GDPR
System Software
1 3 (1.88%) Apache Flume
2 1 (0.63%) Apache ZooKeeper
2 1 (0.63%) Oracle RAC
Systems Management
1 3 (1.88%) Kubernetes
2 2 (1.25%) Terraform
3 1 (0.63%) Enterprise Manager Cloud Control
3 1 (0.63%) Failover Clustering
3 1 (0.63%) Foglight
3 1 (0.63%) Microsoft Clustering
3 1 (0.63%) Oracle Enterprise Manager
Vendors
1 30 (18.75%) Microsoft
2 17 (10.63%) Talend
3 15 (9.38%) Databricks
4 14 (8.75%) Informatica
4 14 (8.75%) Oracle
5 11 (6.88%) Google
6 9 (5.63%) IBM
7 8 (5.00%) Salesforce.com
7 8 (5.00%) SAP
8 7 (4.38%) Red Hat
9 3 (1.88%) Palantir
10 2 (1.25%) Foundry
10 2 (1.25%) MicroStrategy
10 2 (1.25%) Teradata
11 1 (0.63%) Ab Initio
11 1 (0.63%) Cisco
11 1 (0.63%) Cloudera
11 1 (0.63%) Facebook
11 1 (0.63%) MEDITECH
11 1 (0.63%) Sage