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

Data Warehousing
Central London > City of London
6 months to
25 Oct 2021
Same period 2020 Same period 2019
Rank 53 79 43
Rank change year-on-year +26 -36 +37
Permanent jobs citing Data Warehouse 315 135 570
As % of all permanent jobs advertised in the City of London 5.28% 3.74% 5.72%
As % of the Database & Business Intelligence category 17.63% 13.46% 18.81%
Number of salaries quoted 291 97 512
10th Percentile £50,000 £41,700 £46,250
25th Percentile £60,625 £57,500 £51,250
Median annual salary (50th Percentile) £72,500 £72,500 £65,000
Median % change year-on-year - +11.54% -
75th Percentile £88,750 £87,500 £75,313
90th Percentile £106,250 £92,500 £86,250
Central London median annual salary £72,500 £70,000 £62,500
% change year-on-year +3.57% +12.00% -3.85%

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,787 1,003 3,031
As % of all permanent IT jobs advertised in the City of London 29.95% 27.76% 30.44%
Number of salaries quoted 1,585 838 2,715
10th Percentile £46,250 £42,500 £43,000
25th Percentile £56,250 £52,500 £52,500
Median annual salary (50th Percentile) £72,500 £70,000 £67,500
Median % change year-on-year +3.57% +3.70% +3.85%
75th Percentile £95,000 £85,188 £85,000
90th Percentile £108,750 £100,000 £100,000
Central London median annual salary £72,500 £70,000 £65,000
% change year-on-year +3.57% +7.69% -

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 25 October 2021.

Salary histogram for Data Warehouse in the City of London

For the 6 months to 25 October 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 211 (66.98%) SQL
2 158 (50.16%) ETL
3 157 (49.84%) Business Intelligence
4 138 (43.81%) Analytics
5 112 (35.56%) Data Modelling
6 111 (35.24%) Azure
7 104 (33.02%) Python
8 99 (31.43%) Power Platform
9 97 (30.79%) Data Lake
9 97 (30.79%) Finance
9 97 (30.79%) Power BI
10 81 (25.71%) Agile Software Development
11 79 (25.08%) AWS
12 76 (24.13%) SQL Server Integration Services
13 71 (22.54%) Microsoft
14 57 (18.10%) SQL Server
14 57 (18.10%) Big Data
14 57 (18.10%) Data Engineering
15 53 (16.83%) Amazon Redshift
16 52 (16.51%) Analytical Skills
16 52 (16.51%) Social Skills
17 51 (16.19%) JIRA
17 51 (16.19%) SQL Server Reporting Services
18 48 (15.24%) Databricks
19 47 (14.92%) Data Quality
20 46 (14.60%) Visualisation
21 44 (13.97%) Data Architecture
21 44 (13.97%) Data Management
22 41 (13.02%) Microsoft Excel
22 41 (13.02%) Data Pipeline

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 32 (10.16%) Apache Spark
2 29 (9.21%) Confluence
3 18 (5.71%) Apache
4 13 (4.13%) SharePoint
5 12 (3.81%) Apache Airflow
6 8 (2.54%) SAS
7 3 (0.95%) Apache Pig
8 1 (0.32%) Oracle SOA Suite
Applications
1 41 (13.02%) Microsoft Excel
2 3 (0.95%) Microsoft Office
3 2 (0.63%) MS Visio
Business Applications
1 1 (0.32%) Dynamics AX
Cloud Services
1 111 (35.24%) Azure
2 99 (31.43%) Power Platform
3 79 (25.08%) AWS
4 40 (12.70%) Azure Data Factory
4 40 (12.70%) Snowflake
5 29 (9.21%) GCP
6 24 (7.62%) Amazon S3
7 19 (6.03%) Azure Synapse Analytics
8 16 (5.08%) Amazon EC2
9 12 (3.81%) SaaS
10 10 (3.17%) Matillion
10 10 (3.17%) Serverless
11 9 (2.86%) AWS CloudFormation
12 8 (2.54%) Amazon EMR
12 8 (2.54%) AWS Step Functions
13 7 (2.22%) AWS Lambda
14 6 (1.90%) Microsoft 365
14 6 (1.90%) PowerApps
15 5 (1.59%) Amazon SQS
15 5 (1.59%) Azure Logic Apps
Communications & Networking
1 6 (1.90%) Intranet
2 1 (0.32%) DNS
2 1 (0.32%) Firewall
2 1 (0.32%) FTP
2 1 (0.32%) Internet
2 1 (0.32%) Network Security
2 1 (0.32%) PuTTY
2 1 (0.32%) Reverse Proxy
2 1 (0.32%) SSH
2 1 (0.32%) WinSCP
Database & Business Intelligence
1 97 (30.79%) Data Lake
1 97 (30.79%) Power BI
2 76 (24.13%) SQL Server Integration Services
3 57 (18.10%) Big Data
3 57 (18.10%) SQL Server
4 53 (16.83%) Amazon Redshift
5 51 (16.19%) SQL Server Reporting Services
6 35 (11.11%) Tableau
7 31 (9.84%) Hadoop
8 29 (9.21%) SQL Server Analysis Services
9 28 (8.89%) Relational Database
10 24 (7.62%) Azure SQL Database
10 24 (7.62%) NoSQL
11 21 (6.67%) Metadata
12 20 (6.35%) PostgreSQL
13 19 (6.03%) Amazon RDS
14 14 (4.44%) MySQL
15 13 (4.13%) Azure SQL Data Warehouse
15 13 (4.13%) Star Schema
16 11 (3.49%) Snowflake Schema
Development Applications
1 51 (16.19%) JIRA
2 22 (6.98%) Git (software)
3 13 (4.13%) Team Foundation Server
4 10 (3.17%) Visual Studio
5 8 (2.54%) ER Studio
5 8 (2.54%) ERwin
6 7 (2.22%) PowerDesigner
6 7 (2.22%) Subversion
7 5 (1.59%) Toad
7 5 (1.59%) TortoiseSVN
8 4 (1.27%) Cucumber
8 4 (1.27%) Selenium
9 3 (0.95%) GitLab
10 2 (0.63%) SQL Server Management Studio (SSMS)
11 1 (0.32%) GDB
11 1 (0.32%) Jenkins
11 1 (0.32%) Octopus Deploy
11 1 (0.32%) Sourcetree
11 1 (0.32%) TeamCity
11 1 (0.32%) Visual Studio Code
General
1 97 (30.79%) Finance
2 52 (16.51%) Analytical Skills
2 52 (16.51%) Social Skills
3 24 (7.62%) Advertising
4 16 (5.08%) Banking
5 12 (3.81%) Investment Banking
6 11 (3.49%) Law
7 10 (3.17%) Public Sector
8 7 (2.22%) Presentation Skills
9 6 (1.90%) Back Office
9 6 (1.90%) Legal
9 6 (1.90%) Retail
10 5 (1.59%) French Language
10 5 (1.59%) Front Office
11 2 (0.63%) Spanish Language
12 1 (0.32%) Corporate Banking
12 1 (0.32%) Documentation Skills
12 1 (0.32%) Financial Institution
12 1 (0.32%) International Banking
12 1 (0.32%) Organisational Skills
Job Titles
1 89 (28.25%) Data Engineer
2 61 (19.37%) Analyst
3 53 (16.83%) Developer
4 38 (12.06%) Architect
5 34 (10.79%) Business Intelligence Developer
6 31 (9.84%) Data Architect
7 25 (7.94%) Data Analyst
8 22 (6.98%) Technical Analyst
9 21 (6.67%) Senior Data Engineer
9 21 (6.67%) SQL Analyst
10 20 (6.35%) SSIS Analyst
11 19 (6.03%) ETL Analyst
11 19 (6.03%) Excel Analyst
12 17 (5.40%) Applications Support
12 17 (5.40%) AWS Engineer
13 16 (5.08%) Consultant
13 16 (5.08%) SQL Data Analyst
14 15 (4.76%) Business Intelligence Analyst
15 11 (3.49%) Azure Engineer
15 11 (3.49%) QA Engineer
Libraries, Frameworks & Software Standards
1 22 (6.98%) PySpark
2 15 (4.76%) .NET
2 15 (4.76%) Kafka
3 10 (3.17%) MDX
4 8 (2.54%) JSON
4 8 (2.54%) Web Services
5 5 (1.59%) .NET Framework
5 5 (1.59%) ASP.NET
5 5 (1.59%) React
6 4 (1.27%) .NET Core
6 4 (1.27%) Gherkin
6 4 (1.27%) pytest
6 4 (1.27%) XML
7 3 (0.95%) ADO.NET
7 3 (0.95%) ASP.NET Core
7 3 (0.95%) Dapper ORM
7 3 (0.95%) Entity Framework
7 3 (0.95%) Middleware
7 3 (0.95%) NHibernate
7 3 (0.95%) Vue.js
Miscellaneous
1 10 (3.17%) Self-Motivation
1 10 (3.17%) User Experience
1 10 (3.17%) Virtual Team
2 8 (2.54%) Data Structures
2 8 (2.54%) Reinsurance
3 6 (1.90%) Analytical Mindset
3 6 (1.90%) Equities
4 5 (1.59%) Cloud Native
4 5 (1.59%) Derivative
4 5 (1.59%) Legacy Systems
4 5 (1.59%) Management Information System
5 4 (1.27%) Enterprise Software
5 4 (1.27%) Reference Data
6 3 (0.95%) Foreign Exchange (FX)
6 3 (0.95%) Greenfield Project
7 2 (0.63%) Data Centre
7 2 (0.63%) Equity Derivative
7 2 (0.63%) Fixed Income
7 2 (0.63%) iSeries
7 2 (0.63%) Renewable Energy
Operating Systems
1 18 (5.71%) Unix
2 16 (5.08%) Windows
3 5 (1.59%) Linux
4 4 (1.27%) Windows 10
5 2 (0.63%) Red Hat Enterprise Linux
6 1 (0.32%) VMS
6 1 (0.32%) Windows Server
Processes & Methodologies
1 158 (50.16%) ETL
2 157 (49.84%) Business Intelligence
3 138 (43.81%) Analytics
4 112 (35.56%) Data Modelling
5 81 (25.71%) Agile Software Development
6 57 (18.10%) Data Engineering
7 46 (14.60%) Visualisation
8 44 (13.97%) Data Architecture
8 44 (13.97%) Data Management
9 41 (13.02%) Data Pipeline
10 39 (12.38%) Problem-Solving
11 32 (10.16%) Data Analysis
12 31 (9.84%) Requirements Gathering
13 30 (9.52%) Data Integration
14 29 (9.21%) Kimball Methodology
15 28 (8.89%) Data Science
15 28 (8.89%) Decision-Making
15 28 (8.89%) DevOps
15 28 (8.89%) Scrum
16 27 (8.57%) Data Analytics
Programming Languages
1 211 (66.98%) SQL
2 104 (33.02%) Python
3 32 (10.16%) C#
3 32 (10.16%) Java
4 25 (7.94%) T-SQL
5 15 (4.76%) Data Analysis Expressions (DAX)
6 14 (4.44%) Scala
7 13 (4.13%) PL/SQL
8 12 (3.81%) R
9 11 (3.49%) PowerShell
10 9 (2.86%) JavaScript
11 6 (1.90%) ANSI SQL
11 6 (1.90%) VBA
12 5 (1.59%) HiveQL
13 2 (0.63%) PHP
13 2 (0.63%) Shell Script
14 1 (0.32%) C
14 1 (0.32%) Perl
14 1 (0.32%) VB
14 1 (0.32%) VB.NET
Qualifications
1 28 (8.89%) Degree
2 7 (2.22%) Computer Science Degree
3 6 (1.90%) ISTQB
3 6 (1.90%) Master's Degree
4 5 (1.59%) SC Cleared
4 5 (1.59%) Security Cleared
5 4 (1.27%) ISEB
6 3 (0.95%) BPSS Clearance
6 3 (0.95%) ITIL Certification
7 2 (0.63%) ISTQB Advanced Certification
7 2 (0.63%) ISTQB Foundation Certification
7 2 (0.63%) Microsoft Certification
7 2 (0.63%) PhD
7 2 (0.63%) SAS Certification
8 1 (0.32%) IBM Certification
8 1 (0.32%) ITIL Foundation Certificate
8 1 (0.32%) PMI Certification
8 1 (0.32%) PMP
8 1 (0.32%) Tableau Certification
Quality Assurance & Compliance
1 47 (14.92%) Data Quality
2 34 (10.79%) QA
3 4 (1.27%) Solvency II
4 1 (0.32%) GDPR
4 1 (0.32%) ISO/IEC 27001
4 1 (0.32%) PMO
4 1 (0.32%) SLA
System Software
1 5 (1.59%) Docker
1 5 (1.59%) HDFS
2 2 (0.63%) Apache Flume
3 1 (0.32%) Active Directory
Systems Management
1 7 (2.22%) Kubernetes
1 7 (2.22%) Terraform
2 4 (1.27%) HP Quality Center
3 3 (0.95%) Ansible
4 2 (0.63%) Control-M
5 1 (0.32%) Puppet
Vendors
1 71 (22.54%) Microsoft
2 48 (15.24%) Databricks
3 39 (12.38%) Informatica
4 34 (10.79%) Talend
5 25 (7.94%) Oracle
6 13 (4.13%) IBM
6 13 (4.13%) SAP
7 11 (3.49%) Google
8 9 (2.86%) Salesforce.com
9 8 (2.54%) Alteryx
10 6 (1.90%) SnapLogic
11 4 (1.27%) Bloomberg
11 4 (1.27%) Concur
11 4 (1.27%) Fidessa
11 4 (1.27%) Sage
11 4 (1.27%) Sun
12 3 (0.95%) Cloudera
12 3 (0.95%) Splunk
13 2 (0.63%) Cognos
13 2 (0.63%) Guidewire