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

Data Warehousing
Central London > City of London
6 months to
26 Jul 2021
Same period 2020 Same period 2019
Rank 68 66 46
Rank change year-on-year -2 -20 +14
Permanent jobs citing Data Warehouse 225 220 577
As % of all permanent jobs advertised in the City of London 4.02% 4.02% 5.57%
As % of the Database & Business Intelligence category 13.88% 16.77% 17.47%
Number of salaries quoted 207 184 528
10th Percentile £46,802 £42,500 £44,000
25th Percentile £52,500 £53,750 £50,000
Median annual salary (50th Percentile) £67,500 £68,750 £62,500
Median % change year-on-year -1.82% +10.00% -3.85%
75th Percentile £86,875 £78,750 £72,500
90th Percentile £105,500 £93,750 £85,000
Central London median annual salary £67,500 £67,500 £62,500
% change year-on-year - +8.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,621 1,312 3,302
As % of all permanent IT jobs advertised in the City of London 28.96% 23.97% 31.90%
Number of salaries quoted 1,439 1,137 2,986
10th Percentile £45,000 £42,500 £42,500
25th Percentile £53,750 £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 £90,000 £85,000 £85,000
90th Percentile £108,350 £96,250 £100,000
Central London median annual salary £70,000 £70,000 £65,000
% change year-on-year - +7.69% +4.00%

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 26 July 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 26 July 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 +5 1 £80,000 +113.33%
Data Warehouse
Central London

For the 6 months to 26 July 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 132 (58.67%) Business Intelligence
2 131 (58.22%) SQL
3 113 (50.22%) ETL
4 95 (42.22%) Analytics
5 87 (38.67%) Power Platform
6 86 (38.22%) Power BI
7 84 (37.33%) Azure
8 75 (33.33%) Data Lake
9 67 (29.78%) SQL Server Integration Services
10 64 (28.44%) SQL Server
11 62 (27.56%) Finance
11 62 (27.56%) Agile Software Development
12 61 (27.11%) Python
13 60 (26.67%) Data Modelling
14 54 (24.00%) SQL Server Reporting Services
15 48 (21.33%) AWS
16 42 (18.67%) Microsoft
17 41 (18.22%) Data Analysis
18 39 (17.33%) Analytical Skills
19 35 (15.56%) Amazon Redshift
19 35 (15.56%) Big Data
19 35 (15.56%) Data Engineering
19 35 (15.56%) Azure Data Factory
20 34 (15.11%) Databricks
20 34 (15.11%) Problem-Solving
21 29 (12.89%) JIRA
22 28 (12.44%) Social Skills
23 27 (12.00%) SQL Server Analysis Services
24 25 (11.11%) Tableau
24 25 (11.11%) Relational Database

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 23 (10.22%) Apache Spark
2 16 (7.11%) Apache
3 13 (5.78%) SharePoint
4 9 (4.00%) Confluence
5 4 (1.78%) Apache Airflow
6 2 (0.89%) Apache Pig
7 1 (0.44%) Oracle SOA Suite
7 1 (0.44%) SAS
Applications
1 24 (10.67%) Microsoft Excel
2 2 (0.89%) Microsoft Office
3 1 (0.44%) Microsoft PowerPoint
3 1 (0.44%) MS Visio
3 1 (0.44%) Spreadsheet
Business Applications
1 1 (0.44%) Dynamics AX
Cloud Services
1 87 (38.67%) Power Platform
2 84 (37.33%) Azure
3 48 (21.33%) AWS
4 35 (15.56%) Azure Data Factory
5 20 (8.89%) Snowflake
6 18 (8.00%) Amazon EC2
7 16 (7.11%) PowerApps
8 15 (6.67%) Power Automate
9 14 (6.22%) Amazon S3
10 12 (5.33%) SaaS
11 8 (3.56%) GCP
11 8 (3.56%) Matillion
12 7 (3.11%) Azure Synapse Analytics
13 6 (2.67%) AWS CloudFormation
13 6 (2.67%) AWS Data Pipeline
13 6 (2.67%) Microsoft 365
13 6 (2.67%) Serverless
14 3 (1.33%) Amazon EMR
14 3 (1.33%) Azure Cosmos DB
14 3 (1.33%) PaaS
Communications & Networking
1 4 (1.78%) SSH
2 1 (0.44%) Firewall
2 1 (0.44%) FTP
2 1 (0.44%) Network Security
2 1 (0.44%) PuTTY
2 1 (0.44%) Reverse Proxy
2 1 (0.44%) WinSCP
Database & Business Intelligence
1 86 (38.22%) Power BI
2 75 (33.33%) Data Lake
3 67 (29.78%) SQL Server Integration Services
4 64 (28.44%) SQL Server
5 54 (24.00%) SQL Server Reporting Services
6 35 (15.56%) Amazon Redshift
6 35 (15.56%) Big Data
7 27 (12.00%) SQL Server Analysis Services
8 25 (11.11%) Relational Database
8 25 (11.11%) Tableau
9 24 (10.67%) Hadoop
10 19 (8.44%) Amazon RDS
10 19 (8.44%) NoSQL
11 15 (6.67%) Azure SQL Database
11 15 (6.67%) Metadata
12 14 (6.22%) Microsoft Analysis Services
13 13 (5.78%) PostgreSQL
14 12 (5.33%) Azure SQL Data Warehouse
15 9 (4.00%) OLTP
16 8 (3.56%) Data Mart
Development Applications
1 29 (12.89%) JIRA
2 8 (3.56%) Visual Studio
3 7 (3.11%) ER Studio
3 7 (3.11%) ERwin
3 7 (3.11%) Git (software)
4 6 (2.67%) PowerDesigner
5 4 (1.78%) Cucumber
5 4 (1.78%) Selenium
5 4 (1.78%) Subversion
5 4 (1.78%) Toad
5 4 (1.78%) TortoiseSVN
6 3 (1.33%) Team Foundation Server
7 2 (0.89%) Jenkins
8 1 (0.44%) GDB
8 1 (0.44%) Octopus Deploy
8 1 (0.44%) Sourcetree
8 1 (0.44%) SQL Server Management Studio (SSMS)
8 1 (0.44%) TeamCity
8 1 (0.44%) Visual Studio Code
General
1 62 (27.56%) Finance
2 39 (17.33%) Analytical Skills
3 28 (12.44%) Social Skills
4 12 (5.33%) Advertising
5 10 (4.44%) Back Office
5 10 (4.44%) Banking
6 7 (3.11%) Investment Banking
7 6 (2.67%) Law
8 5 (2.22%) French Language
8 5 (2.22%) Legal
9 3 (1.33%) Documentation Skills
9 3 (1.33%) Front Office
9 3 (1.33%) Presentation Skills
10 1 (0.44%) Influencing Skills
10 1 (0.44%) Marketing
10 1 (0.44%) Music Industry
10 1 (0.44%) Retail
10 1 (0.44%) Social Housing
Job Titles
1 60 (26.67%) Data Engineer
2 47 (20.89%) Developer
3 44 (19.56%) Analyst
4 34 (15.11%) Business Intelligence Developer
5 28 (12.44%) Architect
6 23 (10.22%) Data Architect
7 18 (8.00%) Applications Support
7 18 (8.00%) AWS Engineer
8 16 (7.11%) SQL Analyst
9 15 (6.67%) Data Analyst
10 14 (6.22%) SSIS Analyst
11 12 (5.33%) Azure Engineer
11 12 (5.33%) Power BI Developer
11 12 (5.33%) Senior Data Engineer
12 10 (4.44%) Business Intelligence Analyst
12 10 (4.44%) SQL Data Analyst
12 10 (4.44%) Team Leader
12 10 (4.44%) Technical Analyst
13 9 (4.00%) Business Intelligence Consultant
13 9 (4.00%) Senior Analyst
Libraries, Frameworks & Software Standards
1 14 (6.22%) .NET
2 11 (4.89%) PySpark
3 7 (3.11%) JSON
4 6 (2.67%) Kafka
4 6 (2.67%) MDX
5 5 (2.22%) .NET Framework
6 4 (1.78%) ASP.NET
6 4 (1.78%) Gherkin
6 4 (1.78%) pytest
7 3 (1.33%) Middleware
7 3 (1.33%) React
7 3 (1.33%) Vert.x
7 3 (1.33%) WebRTC
7 3 (1.33%) XML
8 2 (0.89%) RabbitMQ
8 2 (0.89%) Spark Streaming
9 1 (0.44%) RESTful
9 1 (0.44%) SOAP
9 1 (0.44%) Spring Boot
9 1 (0.44%) Web Services
Miscellaneous
1 9 (4.00%) Management Information System
2 8 (3.56%) Reinsurance
3 7 (3.11%) Equities
4 6 (2.67%) Data Structures
5 5 (2.22%) Analytical Mindset
5 5 (2.22%) Cloud Native
5 5 (2.22%) Derivative
5 5 (2.22%) Reference Data
6 4 (1.78%) Data Centre
6 4 (1.78%) Fixed Income
6 4 (1.78%) Greenfield Project
6 4 (1.78%) Legacy Systems
7 3 (1.33%) Private Cloud
8 2 (0.89%) Equity Derivative
8 2 (0.89%) Public Cloud
8 2 (0.89%) Renewable Energy
8 2 (0.89%) User Experience
9 1 (0.44%) Music Streaming
9 1 (0.44%) Video\Live Streaming
9 1 (0.44%) Wiki
Operating Systems
1 23 (10.22%) Windows
2 17 (7.56%) Unix
3 6 (2.67%) Linux
3 6 (2.67%) Red Hat Enterprise Linux
4 4 (1.78%) Windows 10
5 1 (0.44%) VMS
5 1 (0.44%) Windows Server
Processes & Methodologies
1 132 (58.67%) Business Intelligence
2 113 (50.22%) ETL
3 95 (42.22%) Analytics
4 62 (27.56%) Agile Software Development
5 60 (26.67%) Data Modelling
6 41 (18.22%) Data Analysis
7 35 (15.56%) Data Engineering
8 34 (15.11%) Problem-Solving
9 25 (11.11%) Data Pipeline
10 24 (10.67%) DevOps
11 22 (9.78%) Visualisation
12 21 (9.33%) Data Architecture
12 21 (9.33%) Data Strategy
13 19 (8.44%) Business Analysis
13 19 (8.44%) Data Transformation
14 18 (8.00%) Data Governance
14 18 (8.00%) Decision-Making
15 17 (7.56%) Dashboard Development
15 17 (7.56%) ETL Development
16 16 (7.11%) Data Analytics
Programming Languages
1 131 (58.22%) SQL
2 61 (27.11%) Python
3 18 (8.00%) C#
4 17 (7.56%) Java
5 15 (6.67%) T-SQL
6 14 (6.22%) Data Analysis Expressions (DAX)
7 7 (3.11%) PowerShell
8 5 (2.22%) JavaScript
8 5 (2.22%) VBA
9 4 (1.78%) Perl
9 4 (1.78%) R
9 4 (1.78%) Shell Script
10 3 (1.33%) Scala
11 1 (0.44%) C
11 1 (0.44%) Clojure
11 1 (0.44%) PL/SQL
11 1 (0.44%) Ruby
11 1 (0.44%) VB
11 1 (0.44%) VB.NET
Qualifications
1 12 (5.33%) Degree
2 6 (2.67%) ISTQB
3 5 (2.22%) Computer Science Degree
4 4 (1.78%) ISEB
4 4 (1.78%) ITIL Foundation Certificate
4 4 (1.78%) Master's Degree
5 2 (0.89%) ISTQB Advanced Certification
5 2 (0.89%) ISTQB Foundation Certification
6 1 (0.44%) BPSS Clearance
6 1 (0.44%) ITIL Certification
6 1 (0.44%) PhD
6 1 (0.44%) PMP
6 1 (0.44%) SAS Certification
Quality Assurance & Compliance
1 22 (9.78%) QA
2 13 (5.78%) Data Quality
3 1 (0.44%) PMO
3 1 (0.44%) SLA
System Software
1 4 (1.78%) Docker
2 3 (1.33%) Apache Flume
3 1 (0.44%) Active Directory
3 1 (0.44%) Apache ZooKeeper
Systems Management
1 7 (3.11%) Kubernetes
2 4 (1.78%) HP Quality Center
2 4 (1.78%) Terraform
3 2 (0.89%) Puppet
4 1 (0.44%) Ansible
4 1 (0.44%) Control-M
Vendors
1 42 (18.67%) Microsoft
2 34 (15.11%) Databricks
3 19 (8.44%) Talend
4 14 (6.22%) Oracle
5 12 (5.33%) Informatica
6 6 (2.67%) Red Hat
6 6 (2.67%) SnapLogic
7 5 (2.22%) Bloomberg
7 5 (2.22%) Sage
8 4 (1.78%) Concur
8 4 (1.78%) Fidessa
8 4 (1.78%) Google
8 4 (1.78%) Sun
9 3 (1.33%) Cloudera
9 3 (1.33%) IBM
9 3 (1.33%) SAP
10 2 (0.89%) Aderant
10 2 (0.89%) Alteryx
10 2 (0.89%) Salesforce.com
10 2 (0.89%) Teradata