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

Data Warehousing
Central London > City of London
6 months to
18 Jan 2021
Same period 2020 Same period 2019
Rank 98 66 93
Rank change year-on-year -32 +27 +1
Permanent jobs citing Data Warehouse 129 366 339
As % of all permanent jobs advertised in the City of London 3.02% 4.01% 3.30%
As % of the Database & Business Intelligence category 10.03% 14.56% 10.88%
Number of salaries quoted 105 327 334
Median annual salary £72,500 £65,000 £60,000
Median salary % change year-on-year +11.54% +8.33% +4.35%
10th Percentile £47,400 £47,500 £41,250
90th Percentile £97,000 £85,000 £90,500
Central London median annual salary £71,250 £65,000 £62,000
% change year-on-year +9.62% +4.84% +7.83%

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,286 2,513 3,115
As % of all permanent IT jobs advertised in the City of London 30.10% 27.55% 30.33%
Number of salaries quoted 1,077 2,234 2,819
Median annual salary £72,500 £67,500 £65,000
Median salary % change year-on-year +7.41% +3.85% +8.33%
10th Percentile £45,450 £42,500 £41,250
90th Percentile £103,750 £102,500 £96,250
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 18 January 2021.

Salary histogram for Data Warehouse in the City of London

For the 6 months to 18 January 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 85 (65.89%) SQL
2 82 (63.57%) Business Intelligence
3 81 (62.79%) Azure
4 80 (62.02%) ETL
5 64 (49.61%) SQL Server
6 48 (37.21%) Analytics
7 47 (36.43%) SQL Server Integration Services
8 45 (34.88%) Data Modelling
9 44 (34.11%) SQL Server Analysis Services
10 43 (33.33%) Agile Software Development
11 42 (32.56%) Power BI
11 42 (32.56%) Power Platform
12 40 (31.01%) Finance
13 38 (29.46%) Data Lake
14 36 (27.91%) Azure Data Factory
14 36 (27.91%) AWS
15 35 (27.13%) SQL Server Reporting Services
16 34 (26.36%) Migration
16 34 (26.36%) Microsoft
17 30 (23.26%) Databricks
18 23 (17.83%) Data Migration
19 22 (17.05%) Oracle
20 21 (16.28%) Python
20 21 (16.28%) Big Data
21 20 (15.50%) DevOps
21 20 (15.50%) Problem-Solving
22 19 (14.73%) Data Integration
23 18 (13.95%) T-SQL
23 18 (13.95%) Data Management
23 18 (13.95%) Azure SQL Data Warehouse

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 7 (5.43%) Apache Spark
2 5 (3.88%) Apache
3 2 (1.55%) SharePoint
4 1 (0.78%) CMS
Applications
1 6 (4.65%) Microsoft Excel
2 2 (1.55%) MS Visio
Business Applications
1 1 (0.78%) Dynamics CRM
Cloud Services
1 81 (62.79%) Azure
2 42 (32.56%) Power Platform
3 36 (27.91%) AWS
3 36 (27.91%) Azure Data Factory
4 13 (10.08%) GCP
5 4 (3.10%) SaaS
6 3 (2.33%) Amazon EC2
6 3 (2.33%) IaaS
6 3 (2.33%) PaaS
6 3 (2.33%) PowerApps
7 2 (1.55%) AWS Lambda
7 2 (1.55%) Logic Apps
7 2 (1.55%) Power Automate
7 2 (1.55%) Serverless
8 1 (0.78%) Amazon Kinesis
8 1 (0.78%) AWS CloudFormation
8 1 (0.78%) Azure Stack
8 1 (0.78%) Data Lake Analytics
8 1 (0.78%) Dynamics 365
8 1 (0.78%) Virtual Private Cloud
Communications & Networking
1 1 (0.78%) HTTP
1 1 (0.78%) SSH
Database & Business Intelligence
1 64 (49.61%) SQL Server
2 47 (36.43%) SQL Server Integration Services
3 44 (34.11%) SQL Server Analysis Services
4 42 (32.56%) Power BI
5 38 (29.46%) Data Lake
6 35 (27.13%) SQL Server Reporting Services
7 21 (16.28%) Big Data
8 18 (13.95%) Azure SQL Data Warehouse
9 17 (13.18%) Azure SQL Database
10 14 (10.85%) MySQL
11 13 (10.08%) Amazon Redshift
12 12 (9.30%) Hadoop
13 10 (7.75%) Microsoft Analysis Services
13 10 (7.75%) OLAP
13 10 (7.75%) Tableau
14 9 (6.98%) MS Access
14 9 (6.98%) NoSQL
15 8 (6.20%) Snowflake Schema
16 7 (5.43%) OLAP Cube
16 7 (5.43%) OLTP
Development Applications
1 9 (6.98%) Cypress.io
1 9 (6.98%) Selenium
2 3 (2.33%) Git (software)
2 3 (2.33%) JIRA
2 3 (2.33%) PowerDesigner
2 3 (2.33%) Team Foundation Server
3 2 (1.55%) Visual Studio
4 1 (0.78%) ER Studio
4 1 (0.78%) ERwin
4 1 (0.78%) Jenkins
4 1 (0.78%) Toad
General
1 40 (31.01%) Finance
2 9 (6.98%) Banking
3 4 (3.10%) Retail
4 3 (2.33%) Legal
4 3 (2.33%) Marketing
5 2 (1.55%) Advertising
5 2 (1.55%) Back Office
5 2 (1.55%) Financial Institution
5 2 (1.55%) Law
5 2 (1.55%) Public Sector
6 1 (0.78%) Front Office
6 1 (0.78%) Investment Banking
6 1 (0.78%) Telecoms
Job Titles
1 50 (38.76%) Developer
2 45 (34.88%) Business Intelligence Developer
3 22 (17.05%) Analyst
3 22 (17.05%) Azure Developer
4 20 (15.50%) Architect
5 15 (11.63%) Data Architect
6 14 (10.85%) Lead Developer
7 12 (9.30%) Business Intelligence Lead
7 12 (9.30%) Consultant
7 12 (9.30%) Data Engineer
8 10 (7.75%) Data Consultant
8 10 (7.75%) Senior Business Intelligence Developer
8 10 (7.75%) Senior Developer
9 9 (6.98%) ETL Developer
9 9 (6.98%) SQL BI Developer
9 9 (6.98%) SQL Developer
10 8 (6.20%) ETL Analyst
10 8 (6.20%) Migration Consultant
10 8 (6.20%) SSAS Developer
10 8 (6.20%) SSIS Developer
Libraries, Frameworks & Software Standards
1 13 (10.08%) MDX
2 10 (7.75%) Web Services
3 6 (4.65%) JSON
4 5 (3.88%) REST
4 5 (3.88%) SOAP
4 5 (3.88%) XML
5 4 (3.10%) .NET
5 4 (3.10%) Kafka
6 3 (2.33%) CSS
6 3 (2.33%) HTML
7 2 (1.55%) PySpark
7 2 (1.55%) React
7 2 (1.55%) WebRTC
8 1 (0.78%) jQuery
8 1 (0.78%) LDAP
8 1 (0.78%) Oracle GoldenGate
8 1 (0.78%) Vert.x
Miscellaneous
1 15 (11.63%) Analytical Skills
2 11 (8.53%) Management Information System
3 8 (6.20%) Data Structures
4 5 (3.88%) Reinsurance
5 4 (3.10%) Derivative
5 4 (3.10%) Replication
6 2 (1.55%) Client/Server
6 2 (1.55%) Clustering
6 2 (1.55%) Data Centre
7 1 (0.78%) Analytical Mindset
7 1 (0.78%) Greenfield Project
7 1 (0.78%) Private Cloud
7 1 (0.78%) User Experience
Operating Systems
1 5 (3.88%) Windows
2 4 (3.10%) Linux
3 2 (1.55%) Red Hat Enterprise Linux
3 2 (1.55%) Unix
4 1 (0.78%) Android
4 1 (0.78%) Apple iOS
Processes & Methodologies
1 82 (63.57%) Business Intelligence
2 80 (62.02%) ETL
3 48 (37.21%) Analytics
4 45 (34.88%) Data Modelling
5 43 (33.33%) Agile Software Development
6 34 (26.36%) Migration
7 23 (17.83%) Data Migration
8 20 (15.50%) DevOps
8 20 (15.50%) Problem-Solving
9 19 (14.73%) Data Integration
10 18 (13.95%) Data Management
11 15 (11.63%) Data Analytics
11 15 (11.63%) Data Architecture
12 14 (10.85%) Data Strategy
13 13 (10.08%) Visualisation
14 12 (9.30%) Data Analysis
14 12 (9.30%) Kimball Methodology
14 12 (9.30%) SDLC
14 12 (9.30%) Stakeholder Management
14 12 (9.30%) Strategic Roadmap
Programming Languages
1 85 (65.89%) SQL
2 21 (16.28%) Python
3 18 (13.95%) T-SQL
4 10 (7.75%) Data Analysis Expressions (DAX)
5 9 (6.98%) Java
6 6 (4.65%) JavaScript
7 5 (3.88%) C#
8 2 (1.55%) R
9 1 (0.78%) Julia
9 1 (0.78%) Korn
9 1 (0.78%) Perl
9 1 (0.78%) PHP
9 1 (0.78%) PL/SQL
9 1 (0.78%) PowerShell
9 1 (0.78%) Scala
9 1 (0.78%) Shell Script
9 1 (0.78%) VB
Qualifications
1 12 (9.30%) Degree
2 1 (0.78%) CISSP
2 1 (0.78%) Computer Science Degree
2 1 (0.78%) ITIL Foundation Certificate
2 1 (0.78%) Microsoft Certification
Quality Assurance & Compliance
1 12 (9.30%) Data Quality
2 4 (3.10%) QA
3 2 (1.55%) GDPR
4 1 (0.78%) HIPAA
4 1 (0.78%) ISO/IEC 27001
4 1 (0.78%) NIST
System Software
1 1 (0.78%) Apache Flume
1 1 (0.78%) Docker
1 1 (0.78%) Oracle RAC
Systems Management
1 3 (2.33%) Kubernetes
2 2 (1.55%) Microsoft Clustering
3 1 (0.78%) Enterprise Manager Cloud Control
3 1 (0.78%) Failover Clustering
3 1 (0.78%) Foglight
3 1 (0.78%) Oracle Enterprise Manager
Vendors
1 34 (26.36%) Microsoft
2 30 (23.26%) Databricks
3 22 (17.05%) Oracle
4 15 (11.63%) Talend
5 11 (8.53%) Google
6 10 (7.75%) Informatica
7 9 (6.98%) IBM
7 9 (6.98%) Salesforce.com
7 9 (6.98%) SAP
8 3 (2.33%) Palantir
9 2 (1.55%) Foundry
9 2 (1.55%) Red Hat
9 2 (1.55%) Sybase
10 1 (0.78%) Ab Initio
10 1 (0.78%) Cisco
10 1 (0.78%) Guidewire
10 1 (0.78%) MEDITECH
10 1 (0.78%) OutSystems
10 1 (0.78%) Salesforce Marketing Cloud
10 1 (0.78%) Teradata