Period
to 19 June 2021

The following table provides summary statistics for permanent job vacancies advertised in 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 19 June 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > London
6 months to
19 Jun 2021
Same period 2020 Same period 2019
Rank 95 93 74
Rank change year-on-year -2 -19 +23
Permanent jobs citing Data Warehouse 1,399 1,207 2,277
As % of all permanent jobs advertised in London 3.57% 3.54% 3.96%
As % of the Database & Business Intelligence category 11.60% 12.60% 13.71%
Number of salaries quoted 1,168 1,033 1,908
10th Percentile £47,500 £43,750 £42,500
25th Percentile £56,250 £55,000 £49,938
Median annual salary (50th Percentile) £70,000 £70,000 £62,500
Median % change year-on-year - +12.00% +4.17%
75th Percentile £85,000 £81,000 £77,500
90th Percentile £97,500 £100,000 £88,750
England median annual salary £60,000 £60,000 £55,000
% change year-on-year - +9.09% +4.76%

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 London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 12,064 9,581 16,607
As % of all permanent IT jobs advertised in London 30.82% 28.08% 28.86%
Number of salaries quoted 7,867 7,812 13,934
10th Percentile £43,750 £41,250 £38,000
25th Percentile £52,500 £50,000 £47,500
Median annual salary (50th Percentile) £70,000 £67,500 £65,000
Median % change year-on-year +3.70% +3.85% +8.33%
75th Percentile £87,500 £85,000 £82,500
90th Percentile £102,500 £103,750 £95,000
England median annual salary £55,000 £55,000 £52,500
% change year-on-year - +4.76% +5.00%

Data Warehouse
Job Vacancy Trend in London

Job postings citing Data Warehouse as a proportion of all IT jobs advertised in London.

Job vacancy trend for Data Warehouse in London

Data Warehouse
Salary Trend in London

3-month moving average salary quoted in jobs citing Data Warehouse in London.

Salary trend for Data Warehouse in London

Data Warehouse
Salary Histogram in London

Salary distribution for jobs citing Data Warehouse in London over the 6 months to 19 June 2021.

Salary histogram for Data Warehouse in London

Data Warehouse
Job Locations in 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 London region over the 6 months to 19 June 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
Central London +21 278 £68,500 +1.48% 56
South London +14 30 £57,500 -8.00% 7
West London -29 29 £72,500 +11.54% 20
East London +4 2 £65,000 -10.34% 12
North London +15 1 - - 2
Data Warehouse
England

For the 6 months to 19 June 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 London region with a requirement for Data Warehouse.

1 881 (62.97%) SQL
2 806 (57.61%) Business Intelligence
3 590 (42.17%) ETL
4 570 (40.74%) Analytics
5 519 (37.10%) Python
6 502 (35.88%) Azure
7 500 (35.74%) Power Platform
8 484 (34.60%) Power BI
9 450 (32.17%) AWS
10 392 (28.02%) Data Modelling
11 383 (27.38%) Finance
12 368 (26.30%) SQL Server
13 360 (25.73%) SQL Server Integration Services
14 324 (23.16%) Agile Software Development
15 321 (22.94%) SQL Server Reporting Services
16 283 (20.23%) Microsoft
17 250 (17.87%) Big Data
18 246 (17.58%) Social Skills
19 236 (16.87%) Data Lake
20 235 (16.80%) Visualisation
21 234 (16.73%) SQL Server Analysis Services
22 218 (15.58%) Data Architecture
23 216 (15.44%) Data Engineering
24 210 (15.01%) Tableau
25 208 (14.87%) Analytical Skills
25 208 (14.87%) Data Science
26 193 (13.80%) Data Pipeline
27 182 (13.01%) DevOps
28 176 (12.58%) GCP
29 173 (12.37%) Java

Data Warehouse
Co-occurring IT Skills in 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 163 (11.65%) Apache Spark
2 103 (7.36%) Apache Airflow
3 64 (4.57%) Apache
4 24 (1.72%) SharePoint
5 23 (1.64%) Confluence
6 20 (1.43%) SAS
7 17 (1.22%) Elasticsearch
7 17 (1.22%) Oracle Application Server
8 13 (0.93%) Gunicorn
9 11 (0.79%) Oracle Workflow
10 10 (0.71%) Luigi
11 6 (0.43%) Apache Pig
11 6 (0.43%) IIS
12 5 (0.36%) CMS
13 3 (0.21%) Sitecore CMS
14 2 (0.14%) Mule
14 2 (0.14%) Mule ESB
15 1 (0.071%) Jupyter
15 1 (0.071%) WebSphere
15 1 (0.071%) WebSphere Application Server
Applications
1 67 (4.79%) Microsoft Excel
2 18 (1.29%) Microsoft Office
3 5 (0.36%) MS Visio
4 3 (0.21%) Microsoft PowerPoint
4 3 (0.21%) Microsoft Project
5 2 (0.14%) Spreadsheet
6 1 (0.071%) Chatbot
6 1 (0.071%) SPSS
Business Applications
1 18 (1.29%) Dynamics AX
2 7 (0.50%) Dynamics CRM
2 7 (0.50%) Magento
3 4 (0.29%) HFM
3 4 (0.29%) Hyperion Planning
3 4 (0.29%) NetSuite
3 4 (0.29%) Oracle Subledger Accounting
3 4 (0.29%) Shopify
4 3 (0.21%) Sentinel
5 1 (0.071%) SAP ERP
5 1 (0.071%) SAP S/4HANA
Cloud Services
1 502 (35.88%) Azure
2 500 (35.74%) Power Platform
3 450 (32.17%) AWS
4 176 (12.58%) GCP
5 163 (11.65%) Azure Data Factory
6 162 (11.58%) Snowflake
7 78 (5.58%) Amazon S3
8 67 (4.79%) Serverless
9 56 (4.00%) Azure Synapse Analytics
10 47 (3.36%) Amazon EC2
10 47 (3.36%) dbt
11 45 (3.22%) Google Analytics
12 44 (3.15%) PaaS
13 42 (3.00%) SaaS
14 41 (2.93%) AWS Lambda
15 37 (2.64%) PowerApps
16 33 (2.36%) Azure Stack
17 32 (2.29%) AWS CloudFormation
18 24 (1.72%) Amazon Kinesis
18 24 (1.72%) Cloud Computing
Communications & Networking
1 22 (1.57%) SSH
2 8 (0.57%) FTP
2 8 (0.57%) Internet
3 7 (0.50%) Extranet
3 7 (0.50%) Intranet
4 6 (0.43%) Network Security
5 4 (0.29%) HTTP
6 3 (0.21%) DNS
6 3 (0.21%) VPN
7 2 (0.14%) Firewall
7 2 (0.14%) MQTT
7 2 (0.14%) PuTTY
7 2 (0.14%) SAN
7 2 (0.14%) WinSCP
8 1 (0.071%) Kerberos
8 1 (0.071%) LAN
8 1 (0.071%) Software-Defined Networking
8 1 (0.071%) VLAN
8 1 (0.071%) WAN
Database & Business Intelligence
1 484 (34.60%) Power BI
2 368 (26.30%) SQL Server
3 360 (25.73%) SQL Server Integration Services
4 321 (22.94%) SQL Server Reporting Services
5 250 (17.87%) Big Data
6 236 (16.87%) Data Lake
7 234 (16.73%) SQL Server Analysis Services
8 210 (15.01%) Tableau
9 156 (11.15%) NoSQL
10 153 (10.94%) Amazon Redshift
11 133 (9.51%) Relational Database
12 114 (8.15%) Hadoop
13 106 (7.58%) Azure SQL Data Warehouse
14 93 (6.65%) Azure SQL Database
15 80 (5.72%) Microsoft Analysis Services
16 73 (5.22%) BigQuery
17 66 (4.72%) PostgreSQL
18 63 (4.50%) Looker
19 57 (4.07%) Amazon RDS
20 49 (3.50%) Oracle Database
Development Applications
1 75 (5.36%) JIRA
2 55 (3.93%) Git (software)
3 25 (1.79%) Jenkins
4 24 (1.72%) Bitbucket
4 24 (1.72%) Visual Studio
5 22 (1.57%) Oracle APEX
6 18 (1.29%) Team Foundation Server
7 16 (1.14%) SQL Server Management Studio (SSMS)
8 13 (0.93%) CircleCI
9 12 (0.86%) ERwin
10 10 (0.71%) PowerDesigner
11 8 (0.57%) ER Studio
11 8 (0.57%) Selenium
11 8 (0.57%) Sonatype Nexus
12 6 (0.43%) Jasmine
12 6 (0.43%) Mocha
12 6 (0.43%) MSTest
12 6 (0.43%) Visual Studio Code
13 5 (0.36%) Spinnaker
14 4 (0.29%) kappa
General
1 383 (27.38%) Finance
2 246 (17.58%) Social Skills
3 208 (14.87%) Analytical Skills
4 104 (7.43%) Banking
5 75 (5.36%) Back Office
6 57 (4.07%) Marketing
7 40 (2.86%) Retail
8 33 (2.36%) Investment Banking
9 24 (1.72%) Advertising
9 24 (1.72%) Presentation Skills
10 18 (1.29%) Legal
10 18 (1.29%) Public Sector
11 17 (1.22%) Influencing Skills
12 14 (1.00%) Law
13 13 (0.93%) Manufacturing
14 12 (0.86%) Organisational Skills
14 12 (0.86%) Publishing
14 12 (0.86%) Russian Language
15 9 (0.64%) Czech Language
16 8 (0.57%) Automotive
Job Titles
1 333 (23.80%) Data Engineer
2 287 (20.51%) Developer
3 229 (16.37%) Analyst
4 210 (15.01%) Architect
5 172 (12.29%) Business Intelligence Developer
6 150 (10.72%) Data Architect
7 85 (6.08%) Data Analyst
8 66 (4.72%) Senior Data Engineer
9 64 (4.57%) Applications Support
10 58 (4.15%) Azure Engineer
11 54 (3.86%) Solutions Architect
12 50 (3.57%) Business Intelligence Analyst
13 49 (3.50%) Support Analyst
14 48 (3.43%) Consultant
15 46 (3.29%) Business Developer
16 43 (3.07%) Power BI Developer
16 43 (3.07%) Senior Architect
17 39 (2.79%) Big Data Engineer
18 37 (2.64%) Applications Support Analyst
18 37 (2.64%) AWS Engineer
Libraries, Frameworks & Software Standards
1 131 (9.36%) Kafka
2 76 (5.43%) .NET
3 66 (4.72%) REST
4 64 (4.57%) Web Services
5 44 (3.15%) XML
6 37 (2.64%) JSON
6 37 (2.64%) React
7 36 (2.57%) HTML
8 33 (2.36%) Oracle GoldenGate
9 25 (1.79%) Node.js
10 24 (1.72%) Pandas
11 23 (1.64%) PySpark
12 20 (1.43%) Apache Beam
12 20 (1.43%) Middleware
13 19 (1.36%) GraphQL
13 19 (1.36%) Redux
14 18 (1.29%) MDX
14 18 (1.29%) NumPy
15 17 (1.22%) pytest
16 13 (0.93%) Spark Streaming
Miscellaneous
1 76 (5.43%) Data Structures
2 41 (2.93%) Management Information System
3 40 (2.86%) Algorithms
4 39 (2.79%) Self-Motivation
5 36 (2.57%) Greenfield Project
6 25 (1.79%) Hedge funds
6 25 (1.79%) SWIFT
7 20 (1.43%) Enterprise Software
8 19 (1.36%) Video\Live Streaming
9 17 (1.22%) Cloud Native
9 17 (1.22%) New Media
10 16 (1.14%) User Experience
10 16 (1.14%) Video Conferencing
11 15 (1.07%) Reinsurance
12 14 (1.00%) Data Centre
12 14 (1.00%) Reference Data
13 12 (0.86%) Analytical Mindset
14 11 (0.79%) Derivative
15 10 (0.71%) Blog
15 10 (0.71%) Public Cloud
Operating Systems
1 110 (7.86%) Linux
2 92 (6.58%) Windows
3 63 (4.50%) Unix
4 38 (2.72%) Red Hat Enterprise Linux
5 11 (0.79%) Windows Server
6 10 (0.71%) Windows 10
7 6 (0.43%) Android
7 6 (0.43%) Apple iOS
7 6 (0.43%) Windows 7
8 2 (0.14%) CentOS
9 1 (0.071%) Ubuntu
9 1 (0.071%) zOS
Processes & Methodologies
1 806 (57.61%) Business Intelligence
2 590 (42.17%) ETL
3 570 (40.74%) Analytics
4 392 (28.02%) Data Modelling
5 324 (23.16%) Agile Software Development
6 235 (16.80%) Visualisation
7 218 (15.58%) Data Architecture
8 216 (15.44%) Data Engineering
9 208 (14.87%) Data Science
10 193 (13.80%) Data Pipeline
11 182 (13.01%) DevOps
12 163 (11.65%) Migration
13 156 (11.15%) Data Analytics
14 145 (10.36%) Data Management
15 135 (9.65%) Data Visualisation
16 125 (8.93%) Data Governance
17 117 (8.36%) Data Analysis
18 111 (7.93%) Problem-Solving
19 101 (7.22%) Artificial Intelligence
20 99 (7.08%) Stakeholder Management
Programming Languages
1 881 (62.97%) SQL
2 519 (37.10%) Python
3 173 (12.37%) Java
4 128 (9.15%) T-SQL
5 84 (6.00%) C#
6 75 (5.36%) R
7 64 (4.57%) Data Analysis Expressions (DAX)
8 57 (4.07%) Scala
9 37 (2.64%) PowerShell
10 36 (2.57%) PL/SQL
11 33 (2.36%) Shell Script
12 32 (2.29%) C++
12 32 (2.29%) JavaScript
13 25 (1.79%) Go
14 24 (1.72%) Perl
15 22 (1.57%) C
16 18 (1.29%) Bash Shell
16 18 (1.29%) Kotlin
17 17 (1.22%) VBA
18 16 (1.14%) PHP
Qualifications
1 128 (9.15%) Degree
2 31 (2.22%) Computer Science Degree
3 24 (1.72%) Microsoft Certification
4 20 (1.43%) Security Cleared
5 18 (1.29%) SC Cleared
6 16 (1.14%) Master's Degree
7 14 (1.00%) Numerate Degree
8 9 (0.64%) PhD
9 8 (0.57%) TOGAF Certification
10 7 (0.50%) AWS Certification
11 5 (0.36%) ISTQB
11 5 (0.36%) ITIL Foundation Certificate
12 4 (0.29%) ISEB
13 3 (0.21%) DBS Check
14 2 (0.14%) DV Cleared
14 2 (0.14%) SAS Certification
15 1 (0.071%) ISSAP
15 1 (0.071%) ISSEP
15 1 (0.071%) PMI Certification
15 1 (0.071%) PMP
Quality Assurance & Compliance
1 125 (8.93%) Data Quality
2 67 (4.79%) QA
3 46 (3.29%) GDPR
4 17 (1.22%) GRC
5 3 (0.21%) Accessibility
5 3 (0.21%) SLA
6 2 (0.14%) COBIT
6 2 (0.14%) ISO/IEC 27001
6 2 (0.14%) PMO
6 2 (0.14%) Solvency II
7 1 (0.071%) NIST
7 1 (0.071%) SOC 2
System Software
1 91 (6.50%) Docker
2 8 (0.57%) Apache ZooKeeper
3 7 (0.50%) etcd
4 6 (0.43%) Ceph
5 5 (0.36%) Active Directory
6 4 (0.29%) Apache Flume
7 3 (0.21%) HDFS
8 2 (0.14%) Virtual Machines
8 2 (0.14%) VirtualBox
9 1 (0.071%) VMware Infrastructure
Systems Management
1 72 (5.15%) Kubernetes
2 51 (3.65%) Terraform
3 25 (1.79%) Puppet
4 19 (1.36%) Ansible
5 18 (1.29%) Opscode Chef
6 13 (0.93%) Grafana
6 13 (0.93%) Prometheus
7 7 (0.50%) Consul
8 6 (0.43%) Galera Cluster
9 4 (0.29%) HP Quality Center
9 4 (0.29%) Oozie
10 2 (0.14%) Docker Swarm
10 2 (0.14%) Failover Clustering
11 1 (0.071%) Active Directory Federation Services
11 1 (0.071%) Control-M
11 1 (0.071%) Hadoop YARN
11 1 (0.071%) Mesos
11 1 (0.071%) vCenter Server
Vendors
1 283 (20.23%) Microsoft
2 143 (10.22%) Google
3 122 (8.72%) Oracle
4 114 (8.15%) Databricks
5 64 (4.57%) Informatica
6 54 (3.86%) SAP
7 48 (3.43%) Talend
8 46 (3.29%) Alteryx
9 42 (3.00%) Salesforce.com
10 40 (2.86%) Red Hat
11 21 (1.50%) Teradata
12 19 (1.36%) IBM
13 12 (0.86%) Atlassian
14 11 (0.79%) MuleSoft
15 10 (0.71%) Cloudera
15 10 (0.71%) SmartStream
16 8 (0.57%) Cognos
17 7 (0.50%) Splunk
18 6 (0.43%) Hortonworks
18 6 (0.43%) Percona