Period
to

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 20 May 2022 with a comparison to the same period in the previous 2 years.

Data Warehousing
Central London > City of London
6 months to
20 May 2022
Same period 2021 Same period 2020
Rank 50 80 76
Rank change year-on-year +30 -4 -11
Permanent jobs citing Data Warehouse 392 186 260
As % of all permanent jobs advertised in the City of London 5.31% 3.72% 3.65%
As % of the Database & Business Intelligence category 20.86% 13.05% 15.69%
Number of salaries quoted 363 168 231
10th Percentile £50,250 £43,925 £45,000
25th Percentile £58,750 £52,500 £55,000
Median annual salary (50th Percentile) £71,000 £65,000 £65,000
Median % change year-on-year +9.23% - +4.00%
75th Percentile £87,500 £82,500 £77,500
90th Percentile £96,250 £105,000 £87,500
Central London median annual salary £71,000 £65,000 £67,500
% change year-on-year +9.23% -3.70% +8.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,879 1,425 1,657
As % of all permanent IT jobs advertised in the City of London 25.43% 28.50% 23.25%
Number of salaries quoted 1,620 1,260 1,447
10th Percentile £45,000 £45,000 £41,250
25th Percentile £56,250 £53,750 £51,250
Median annual salary (50th Percentile) £72,500 £72,500 £66,500
Median % change year-on-year - +9.02% +2.31%
75th Percentile £92,500 £88,750 £82,500
90th Percentile £106,250 £107,500 £97,500
Central London median annual salary £70,000 £70,000 £67,500
% change year-on-year - +3.70% +3.85%

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 20 May 2022.

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 20 May 2022. 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
Jobs
Moorgate - 2 £97,500 -
London Bridge -6 1 £84,000 +5.00%
Data Warehouse
Central London

For the 6 months to 20 May 2022, 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 274 (69.90%) SQL
2 199 (50.77%) Business Intelligence
3 187 (47.70%) ETL
4 161 (41.07%) Analytics
5 156 (39.80%) Azure
6 146 (37.24%) Data Modelling
7 135 (34.44%) Power BI
7 135 (34.44%) Power Platform
8 130 (33.16%) Agile
9 113 (28.83%) Microsoft
10 106 (27.04%) Social Skills
11 102 (26.02%) SQL Server Integration Services
12 97 (24.74%) Python
13 88 (22.45%) Finance
14 87 (22.19%) SQL Server
14 87 (22.19%) Data Lake
15 81 (20.66%) AWS
16 79 (20.15%) Data Engineering
17 75 (19.13%) Data Quality
17 75 (19.13%) Data Management
18 71 (18.11%) DevOps
19 70 (17.86%) Analytical Skills
20 68 (17.35%) SQL Server Reporting Services
20 68 (17.35%) Snowflake
21 64 (16.33%) Informatica
22 62 (15.82%) Big Data
23 61 (15.56%) Problem-Solving
24 59 (15.05%) Oracle
25 57 (14.54%) Data Science
26 56 (14.29%) T-SQL

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 (8.16%) SAS
2 23 (5.87%) Apache Spark
3 17 (4.34%) Confluence
4 13 (3.32%) Apache
4 13 (3.32%) Apache Airflow
5 10 (2.55%) SharePoint
6 6 (1.53%) Elasticsearch
7 3 (0.77%) Apache Pig
Applications
1 26 (6.63%) Microsoft Excel
2 13 (3.32%) Microsoft Office
3 2 (0.51%) Microsoft PowerPoint
3 2 (0.51%) Microsoft Project
4 1 (0.26%) MS Visio
Business Applications
1 3 (0.77%) Cognos Business Intelligence
Cloud Services
1 156 (39.80%) Azure
2 135 (34.44%) Power Platform
3 81 (20.66%) AWS
4 68 (17.35%) Snowflake
5 47 (11.99%) Azure Data Factory
6 37 (9.44%) GCP
7 26 (6.63%) Azure Synapse Analytics
8 22 (5.61%) Matillion
9 18 (4.59%) Amazon S3
10 16 (4.08%) Microsoft 365
11 14 (3.57%) dbt
11 14 (3.57%) PowerApps
12 12 (3.06%) Azure Cosmos DB
12 12 (3.06%) SaaS
13 11 (2.81%) Serverless
14 9 (2.30%) AWS Lambda
14 9 (2.30%) PaaS
14 9 (2.30%) Trello
15 8 (2.04%) Power Automate
16 7 (1.79%) AWS Step Functions
Communications & Networking
1 9 (2.30%) Network Security
2 1 (0.26%) Skype
Database & Business Intelligence
1 135 (34.44%) Power BI
2 102 (26.02%) SQL Server Integration Services
3 87 (22.19%) Data Lake
3 87 (22.19%) SQL Server
4 68 (17.35%) SQL Server Reporting Services
5 62 (15.82%) Big Data
6 43 (10.97%) Tableau
7 42 (10.71%) Amazon Redshift
8 32 (8.16%) Metadata
8 32 (8.16%) NoSQL
9 31 (7.91%) Hadoop
9 31 (7.91%) PostgreSQL
9 31 (7.91%) SQL Server Analysis Services
10 29 (7.40%) Relational Database
11 24 (6.12%) Azure SQL Data Warehouse
12 22 (5.61%) Apache Hive
13 21 (5.36%) Power Query
14 20 (5.10%) Azure SQL Database
14 20 (5.10%) MySQL
14 20 (5.10%) OLTP
Development Applications
1 33 (8.42%) JIRA
2 22 (5.61%) Git (software)
3 19 (4.85%) Team Foundation Server
4 14 (3.57%) PowerDesigner
5 13 (3.32%) ER Studio
5 13 (3.32%) ERwin
6 6 (1.53%) Mercurial
6 6 (1.53%) Octopus Deploy
6 6 (1.53%) Visual Studio
7 5 (1.28%) Selenium
7 5 (1.28%) SQL Server Management Studio (SSMS)
8 4 (1.02%) GitLab
9 3 (0.77%) Cucumber
9 3 (0.77%) SpecFlow
10 2 (0.51%) Eclipse
10 2 (0.51%) Jenkins
11 1 (0.26%) kappa
11 1 (0.26%) Spinnaker
11 1 (0.26%) Subversion
General
1 106 (27.04%) Social Skills
2 88 (22.45%) Finance
3 70 (17.86%) Analytical Skills
4 45 (11.48%) Advertising
5 24 (6.12%) Influencing Skills
6 23 (5.87%) Retail
7 16 (4.08%) Law
8 14 (3.57%) Banking
9 11 (2.81%) Legal
10 10 (2.55%) Public Sector
11 6 (1.53%) Pharmaceutical
12 5 (1.28%) Marketing
13 4 (1.02%) Spanish Language
14 3 (0.77%) Games
14 3 (0.77%) Inclusion and Diversity
14 3 (0.77%) Manufacturing
15 2 (0.51%) Local Government
16 1 (0.26%) International Banking
16 1 (0.26%) Investment Banking
16 1 (0.26%) Music Industry
Job Titles
1 101 (25.77%) Data Engineer
2 80 (20.41%) Developer
3 70 (17.86%) Analyst
4 56 (14.29%) Architect
5 48 (12.24%) Data Architect
6 46 (11.73%) Business Intelligence Developer
7 40 (10.20%) Senior Data Engineer
8 23 (5.87%) Consultant
9 22 (5.61%) Support Analyst
10 21 (5.36%) Applications Support
10 21 (5.36%) Applications Support Analyst
11 20 (5.10%) Data Analyst
12 19 (4.85%) Power BI Developer
13 18 (4.59%) ETL Developer
14 14 (3.57%) Technical Analyst
15 13 (3.32%) Senior Architect
15 13 (3.32%) Senior Developer
16 12 (3.06%) Azure Engineer
16 12 (3.06%) Senior Data Architect
17 11 (2.81%) Senior Consultant
Libraries, Frameworks & Software Standards
1 23 (5.87%) Kafka
2 20 (5.10%) .NET
3 8 (2.04%) ASP.NET
3 8 (2.04%) RESTful
4 7 (1.79%) ASP.NET Core
4 7 (1.79%) Blazor
4 7 (1.79%) PySpark
5 3 (0.77%) Apache Beam
5 3 (0.77%) Gherkin
5 3 (0.77%) Lambda Expressions
5 3 (0.77%) React
6 2 (0.51%) Middleware
6 2 (0.51%) Spark Streaming
6 2 (0.51%) Spring
7 1 (0.26%) JSON
7 1 (0.26%) MDX
7 1 (0.26%) Ruby on Rails
7 1 (0.26%) SOAP
7 1 (0.26%) Web Services
7 1 (0.26%) XML
Miscellaneous
1 19 (4.85%) Data Structures
2 14 (3.57%) Virtual Team
3 11 (2.81%) Reinsurance
3 11 (2.81%) User Experience
4 8 (2.04%) Management Information System
5 7 (1.79%) Self-Motivation
6 6 (1.53%) Greenfield Project
7 5 (1.28%) Cloud Native
7 5 (1.28%) Private Cloud
8 4 (1.02%) Derivative
8 4 (1.02%) iSeries
9 3 (0.77%) Algorithms
9 3 (0.77%) FMCG
9 3 (0.77%) Social Media
10 2 (0.51%) Housing Association
10 2 (0.51%) IoT
10 2 (0.51%) Legacy Systems
10 2 (0.51%) NHS
11 1 (0.26%) Data Fabric
11 1 (0.26%) Legacy Applications
Operating Systems
1 30 (7.65%) Linux
2 25 (6.38%) Unix
3 15 (3.83%) Windows
4 13 (3.32%) Red Hat Enterprise Linux
5 1 (0.26%) Android
5 1 (0.26%) Apple iOS
Processes & Methodologies
1 199 (50.77%) Business Intelligence
2 187 (47.70%) ETL
3 161 (41.07%) Analytics
4 146 (37.24%) Data Modelling
5 130 (33.16%) Agile
6 79 (20.15%) Data Engineering
7 75 (19.13%) Data Management
8 71 (18.11%) DevOps
9 61 (15.56%) Problem-Solving
10 57 (14.54%) Data Science
11 56 (14.29%) Visualisation
12 55 (14.03%) Data Architecture
12 55 (14.03%) Data Pipeline
13 54 (13.78%) Data Integration
14 50 (12.76%) Data Analytics
15 47 (11.99%) Data Governance
16 45 (11.48%) Data Strategy
17 42 (10.71%) Machine Learning
18 40 (10.20%) Kimball Methodology
19 37 (9.44%) Data Analysis
Programming Languages
1 274 (69.90%) SQL
2 97 (24.74%) Python
3 56 (14.29%) T-SQL
4 38 (9.69%) Java
5 23 (5.87%) PL/SQL
6 22 (5.61%) C#
7 19 (4.85%) Data Analysis Expressions (DAX)
8 14 (3.57%) ANSI SQL
8 14 (3.57%) Scala
9 10 (2.55%) JavaScript
10 8 (2.04%) HiveQL
10 8 (2.04%) R
10 8 (2.04%) XMLA
11 7 (1.79%) Perl
11 7 (1.79%) Shell Script
12 6 (1.53%) Ruby
13 5 (1.28%) PowerShell
14 4 (1.02%) TypeScript
14 4 (1.02%) U-SQL
15 3 (0.77%) Kotlin
Qualifications
1 55 (14.03%) Degree
2 13 (3.32%) Computer Science Degree
3 8 (2.04%) Microsoft Certification
4 7 (1.79%) Master's Degree
5 6 (1.53%) SC Cleared
5 6 (1.53%) Security Cleared
6 2 (0.51%) ITIL Certification
6 2 (0.51%) TOGAF Certification
7 1 (0.26%) PhD
7 1 (0.26%) SAS Certification
Quality Assurance & Compliance
1 75 (19.13%) Data Quality
2 8 (2.04%) Solvency II
3 7 (1.79%) SLA
4 6 (1.53%) GDPR
5 3 (0.77%) QA
6 2 (0.51%) Sarbanes-Oxley
7 1 (0.26%) MiFID
System Software
1 13 (3.32%) Docker
2 8 (2.04%) HDFS
3 6 (1.53%) Active Directory
4 3 (0.77%) Apache Flume
Systems Management
1 9 (2.30%) Terraform
2 5 (1.28%) Kubernetes
3 4 (1.02%) Ansible
4 1 (0.26%) Control-M
4 1 (0.26%) Puppet
Vendors
1 113 (28.83%) Microsoft
2 64 (16.33%) Informatica
3 59 (15.05%) Oracle
4 41 (10.46%) Databricks
5 32 (8.16%) Talend
6 19 (4.85%) Google
7 16 (4.08%) SAP
8 15 (3.83%) Splunk
9 13 (3.32%) Red Hat
10 12 (3.06%) IBM
11 10 (2.55%) SnapLogic
12 9 (2.30%) Salesforce.com
13 8 (2.04%) Cognos
14 7 (1.79%) Atlassian
15 6 (1.53%) Alteryx
16 5 (1.28%) RedGate
16 5 (1.28%) SolarWinds
17 4 (1.02%) Cloudera
17 4 (1.02%) Facebook
17 4 (1.02%) MuleSoft