Period
to 1 October 2020

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

Data Warehousing
Central London > City of London
6 months to
1 Oct 2020
Same period 2019 Same period 2018
Rank 69 41 69
Rank change year-on-year -28 +28 +9
Permanent jobs citing Data Warehouse 149 618 469
As % of all permanent jobs advertised in the City of London 4.02% 6.10% 4.27%
As % of the Database & Business Intelligence category 14.91% 19.81% 13.82%
Number of salaries quoted 115 558 424
Median annual salary £70,000 £62,500 £65,000
Median salary % change year-on-year +12.00% -3.85% +8.33%
10th Percentile £40,500 £46,250 £42,000
90th Percentile £92,500 £86,625 £87,500
Central London median annual salary £65,000 £62,500 £65,000
% change year-on-year +4.00% -3.85% +8.33%

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 999 3,119 3,394
As % of all permanent IT jobs advertised in the City of London 26.97% 30.80% 30.89%
Number of salaries quoted 829 2,808 3,074
Median annual salary £70,000 £67,500 £65,000
Median salary % change year-on-year +3.70% +3.85% +8.33%
10th Percentile £42,500 £43,750 £40,000
90th Percentile £100,000 £100,000 £95,000
Central London median annual salary £70,000 £65,000 £65,000
% change year-on-year +7.69% - +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 1 October 2020.

Salary histogram for Data Warehouse in the City of London

For the 6 months to 1 October 2020, 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 110 (73.83%) Business Intelligence
2 102 (68.46%) SQL
3 80 (53.69%) Azure
4 65 (43.62%) ETL
5 62 (41.61%) SQL Server Integration Services
6 61 (40.94%) Power BI
6 61 (40.94%) Power Platform
7 60 (40.27%) SQL Server
8 58 (38.93%) Agile Software Development
9 53 (35.57%) SQL Server Analysis Services
9 53 (35.57%) Data Modelling
10 52 (34.90%) SQL Server Reporting Services
11 51 (34.23%) Microsoft
11 51 (34.23%) Analytics
12 44 (29.53%) Data Lake
13 37 (24.83%) Finance
14 35 (23.49%) Data Analytics
15 32 (21.48%) Azure SQL Data Warehouse
15 32 (21.48%) Problem-Solving
16 28 (18.79%) Analytical Skills
16 28 (18.79%) Azure Data Factory
17 26 (17.45%) DevOps
17 26 (17.45%) OLAP
18 24 (16.11%) Databricks
19 22 (14.77%) Dashboard Development
20 21 (14.09%) SDLC
20 21 (14.09%) Python
20 21 (14.09%) Microsoft Excel
21 18 (12.08%) OLAP Cube
21 18 (12.08%) Migration

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 8 (5.37%) SharePoint
2 4 (2.68%) Apache Spark
3 3 (2.01%) CMS
4 2 (1.34%) Apache
4 2 (1.34%) MQSeries
5 1 (0.67%) Apache Airflow
5 1 (0.67%) Apache Synapse
5 1 (0.67%) Luigi
Applications
1 21 (14.09%) Microsoft Excel
2 4 (2.68%) Microsoft Office
2 4 (2.68%) Microsoft PowerPoint
3 2 (1.34%) MS Visio
Business Applications
1 3 (2.01%) Oracle General Ledger
1 3 (2.01%) Oracle Internet Expenses
1 3 (2.01%) Oracle iProcurement
1 3 (2.01%) Oracle Procure-to-Pay
2 2 (1.34%) Markit EDM
Cloud Services
1 80 (53.69%) Azure
2 61 (40.94%) Power Platform
3 28 (18.79%) Azure Data Factory
4 10 (6.71%) AWS
5 5 (3.36%) SaaS
6 4 (2.68%) Office 365
7 2 (1.34%) Amazon Kinesis
7 2 (1.34%) PowerApps
8 1 (0.67%) Azure Stack
8 1 (0.67%) Data Lake Analytics
8 1 (0.67%) Dynamics 365
8 1 (0.67%) GCP
8 1 (0.67%) IaaS
8 1 (0.67%) Logic Apps
8 1 (0.67%) PaaS
8 1 (0.67%) Power Automate
Communications & Networking
1 2 (1.34%) SSH
Database & Business Intelligence
1 62 (41.61%) SQL Server Integration Services
2 61 (40.94%) Power BI
3 60 (40.27%) SQL Server
4 53 (35.57%) SQL Server Analysis Services
5 52 (34.90%) SQL Server Reporting Services
6 44 (29.53%) Data Lake
7 32 (21.48%) Azure SQL Data Warehouse
8 26 (17.45%) OLAP
9 18 (12.08%) OLAP Cube
10 17 (11.41%) Microsoft Analysis Services
11 16 (10.74%) OLTP
12 15 (10.07%) Azure SQL Database
13 13 (8.72%) Big Data
14 10 (6.71%) Data Mining
14 10 (6.71%) MySQL
15 9 (6.04%) MS Access
16 8 (5.37%) SQL Server 2016
17 7 (4.70%) Snowflake Schema
18 4 (2.68%) NoSQL
18 4 (2.68%) RDBMS
Development Applications
1 14 (9.40%) Selenium
2 9 (6.04%) Cypress.io
3 4 (2.68%) Cucumber
4 3 (2.01%) JIRA
5 2 (1.34%) Eclipse
5 2 (1.34%) Jenkins
5 2 (1.34%) PowerDesigner
5 2 (1.34%) Visual Studio
General
1 37 (24.83%) Finance
2 5 (3.36%) Banking
2 5 (3.36%) Financial Institution
2 5 (3.36%) Pharmaceutical
2 5 (3.36%) Retail
3 4 (2.68%) Advertising
3 4 (2.68%) Back Office
4 3 (2.01%) General Ledger
5 2 (1.34%) Investment Banking
5 2 (1.34%) Marketing
6 1 (0.67%) Front Office
6 1 (0.67%) Games
6 1 (0.67%) Law
6 1 (0.67%) Legal
Job Titles
1 70 (46.98%) Developer
2 55 (36.91%) Business Intelligence Developer
3 34 (22.82%) Analyst
4 32 (21.48%) Azure Developer
5 23 (15.44%) Data Warehouse Developer
5 23 (15.44%) SQL Developer
5 23 (15.44%) SSIS Developer
6 21 (14.09%) ETL Developer
7 20 (13.42%) Senior Developer
7 20 (13.42%) SSAS Developer
8 19 (12.75%) SQL BI Developer
9 18 (12.08%) OLAP Developer
10 16 (10.74%) Excel Developer
10 16 (10.74%) Microsoft BI Developer
10 16 (10.74%) SQL Server BI Developer
10 16 (10.74%) SQL Server Developer
11 15 (10.07%) Senior Business Intelligence Developer
12 14 (9.40%) SQL Server Data Warehouse Developer
13 13 (8.72%) Data Engineer
13 13 (8.72%) Test Analyst
Libraries, Frameworks & Software Standards
1 17 (11.41%) REST
2 16 (10.74%) JSON
2 16 (10.74%) SOAP
2 16 (10.74%) XML
3 15 (10.07%) MDX
4 6 (4.03%) .NET
5 5 (3.36%) pytest
6 4 (2.68%) Gherkin
7 3 (2.01%) ADO
7 3 (2.01%) AngularJS
7 3 (2.01%) Kafka
7 3 (2.01%) Oracle Fusion
8 2 (1.34%) D3.js
8 2 (1.34%) Middleware
8 2 (1.34%) React
8 2 (1.34%) Vue.js
8 2 (1.34%) WebRTC
9 1 (0.67%) ASP.NET
9 1 (0.67%) CSS
9 1 (0.67%) jQuery
Miscellaneous
1 28 (18.79%) Analytical Skills
2 13 (8.72%) Management Information System
3 8 (5.37%) Replication
4 6 (4.03%) Derivative
5 5 (3.36%) Greenfield Project
5 5 (3.36%) User Experience
6 3 (2.01%) Data Structures
6 3 (2.01%) Mobile App
6 3 (2.01%) Public Cloud
7 2 (1.34%) Algorithms
7 2 (1.34%) Hedge funds
7 2 (1.34%) SWIFT
8 1 (0.67%) Client/Server
8 1 (0.67%) Clustering
8 1 (0.67%) Data Centre
8 1 (0.67%) Private Cloud
8 1 (0.67%) Reference Data
8 1 (0.67%) Reinsurance
8 1 (0.67%) Social Media
8 1 (0.67%) Virtual Team
Operating Systems
1 7 (4.70%) Windows
2 4 (2.68%) Windows 10
3 2 (1.34%) Unix
Processes & Methodologies
1 110 (73.83%) Business Intelligence
2 65 (43.62%) ETL
3 58 (38.93%) Agile Software Development
4 53 (35.57%) Data Modelling
5 51 (34.23%) Analytics
6 35 (23.49%) Data Analytics
7 32 (21.48%) Problem-Solving
8 26 (17.45%) DevOps
9 22 (14.77%) Dashboard Development
10 21 (14.09%) SDLC
11 18 (12.08%) Migration
12 17 (11.41%) Data Analysis
12 17 (11.41%) Data Management
12 17 (11.41%) Performance Tuning
12 17 (11.41%) Test Automation
13 16 (10.74%) Data Migration
14 15 (10.07%) BDD
14 15 (10.07%) Kimball Methodology
15 14 (9.40%) TDD
15 14 (9.40%) Visualisation
Programming Languages
1 102 (68.46%) SQL
2 21 (14.09%) Python
3 16 (10.74%) T-SQL
4 9 (6.04%) Data Analysis Expressions (DAX)
5 7 (4.70%) C#
6 5 (3.36%) Java
7 4 (2.68%) JavaScript
7 4 (2.68%) VBA
8 3 (2.01%) Ruby
8 3 (2.01%) Scala
9 2 (1.34%) Korn
9 2 (1.34%) Perl
9 2 (1.34%) Shell Script
10 1 (0.67%) PHP
10 1 (0.67%) VB
Qualifications
1 6 (4.03%) Degree
2 4 (2.68%) A+ Certification
3 2 (1.34%) ISEB
3 2 (1.34%) ISTQB
3 2 (1.34%) ITIL Foundation Certificate
4 1 (0.67%) CISSP
4 1 (0.67%) Computer Science Degree
Quality Assurance & Compliance
1 9 (6.04%) QA
2 5 (3.36%) Data Quality
3 4 (2.68%) GDPR
3 4 (2.68%) SLA
4 1 (0.67%) HIPAA
4 1 (0.67%) ISO/IEC 27001
4 1 (0.67%) NIST
System Software
1 1 (0.67%) Docker
Systems Management
1 3 (2.01%) HP Quality Center
1 3 (2.01%) Kubernetes
2 2 (1.34%) Control-M
3 1 (0.67%) Argo
3 1 (0.67%) Microsoft Clustering
3 1 (0.67%) Oozie
Vendors
1 51 (34.23%) Microsoft
2 24 (16.11%) Databricks
3 16 (10.74%) Oracle
4 8 (5.37%) Tableau
5 4 (2.68%) Informatica
5 4 (2.68%) Sun
6 2 (1.34%) Google
6 2 (1.34%) IBM
6 2 (1.34%) OutSystems
6 2 (1.34%) SnapLogic
6 2 (1.34%) Sybase
6 2 (1.34%) Talend
7 1 (0.67%) Guidewire
7 1 (0.67%) Hortonworks
7 1 (0.67%) MicroStrategy
7 1 (0.67%) Pega