Period
to 27 September 2020

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

Data Warehousing
England > London
6 months to
27 Sep 2020
Same period 2019 Same period 2018
Rank 95 71 90
Rank change year-on-year -24 +19 +12
Permanent jobs citing Data Warehouse 677 2,298 2,419
As % of all permanent jobs advertised in London 3.46% 4.13% 3.54%
As % of the Database & Business Intelligence category 12.15% 14.52% 11.40%
Number of salaries quoted 576 1,970 2,084
Median annual salary £67,500 £62,500 £60,000
Median salary % change year-on-year +8.00% +4.17% -
10th Percentile £42,500 £42,500 £40,000
90th Percentile £120,000 £90,000 £88,750
England median annual salary £57,500 £55,000 £55,000
% change year-on-year +4.55% - +10.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 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 5,572 15,827 21,210
As % of all permanent IT jobs advertised in London 28.48% 28.43% 31.04%
Number of salaries quoted 4,638 13,094 16,864
Median annual salary £70,000 £65,000 £62,500
Median salary % change year-on-year +7.69% +4.00% +4.17%
10th Percentile £42,500 £38,000 £37,500
90th Percentile £105,000 £97,500 £93,750
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +1.01%

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 27 September 2020.

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 27 September 2020. 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 -32 165 £65,000 +4.00% 29
West London +8 17 £43,250 -27.92% 9
East London +15 16 £71,250 +73.78% 3
South London +29 11 £62,500 +16.28%
Data Warehouse
England

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

1 452 (66.77%) SQL
2 379 (55.98%) Business Intelligence
3 316 (46.68%) Azure
4 283 (41.80%) Finance
5 273 (40.32%) SQL Server
6 251 (37.08%) ETL
7 244 (36.04%) Python
8 226 (33.38%) Agile Software Development
9 221 (32.64%) AWS
10 206 (30.43%) Analytics
11 202 (29.84%) Power Platform
12 201 (29.69%) Power BI
13 168 (24.82%) DevOps
14 165 (24.37%) SQL Server Integration Services
15 163 (24.08%) Data Modelling
16 161 (23.78%) Microsoft
17 159 (23.49%) GCP
18 157 (23.19%) Data Lake
19 145 (21.42%) SQL Server Reporting Services
20 135 (19.94%) Amazon Redshift
21 134 (19.79%) Banking
22 133 (19.65%) Java
23 128 (18.91%) Snowflake Schema
23 128 (18.91%) SQL Server Analysis Services
24 118 (17.43%) Google
25 112 (16.54%) Asset Management
26 105 (15.51%) Microservices
27 96 (14.18%) Apache
28 95 (14.03%) Analytical Skills
29 94 (13.88%) Web Services

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 96 (14.18%) Apache
2 48 (7.09%) Apache Spark
3 10 (1.48%) SharePoint
4 9 (1.33%) Cloud Foundry
5 8 (1.18%) Apache Airflow
6 7 (1.03%) Confluence
7 5 (0.74%) SAS
8 4 (0.59%) Jupyter
9 3 (0.44%) Apache Synapse
9 3 (0.44%) CMS
9 3 (0.44%) Oracle SOA Suite
10 2 (0.30%) Elasticsearch
10 2 (0.30%) Luigi
10 2 (0.30%) MQSeries
11 1 (0.15%) Apache Pig
11 1 (0.15%) Apache Solr
11 1 (0.15%) Oracle Service Bus
11 1 (0.15%) WebLogic
Applications
1 38 (5.61%) Microsoft Excel
2 7 (1.03%) Microsoft PowerPoint
3 5 (0.74%) Microsoft Office
4 4 (0.59%) MS Visio
5 1 (0.15%) SPSS
Business Applications
1 9 (1.33%) SAP BPC
2 3 (0.44%) Markit EDM
2 3 (0.44%) Oracle General Ledger
2 3 (0.44%) Oracle Internet Expenses
2 3 (0.44%) Oracle iProcurement
2 3 (0.44%) Oracle Procure-to-Pay
3 2 (0.30%) Dynamics CRM
4 1 (0.15%) FLEXCUBE
4 1 (0.15%) Oracle Applications
4 1 (0.15%) Oracle EBS
Cloud Services
1 316 (46.68%) Azure
2 221 (32.64%) AWS
3 202 (29.84%) Power Platform
4 159 (23.49%) GCP
5 91 (13.44%) Serverless
6 83 (12.26%) AWS Lambda
7 76 (11.23%) Azure Data Factory
8 72 (10.64%) Amazon ECS
9 50 (7.39%) Apigee
10 26 (3.84%) SaaS
11 22 (3.25%) Amazon S3
12 15 (2.22%) PaaS
13 11 (1.62%) Trello
14 10 (1.48%) Data Lake Analytics
15 8 (1.18%) Amazon EMR
15 8 (1.18%) AWS CloudFormation
16 7 (1.03%) AdWords
16 7 (1.03%) Amazon Kinesis
16 7 (1.03%) Google Analytics
16 7 (1.03%) PowerApps
Communications & Networking
1 7 (1.03%) WebEx
2 4 (0.59%) Internet
2 4 (0.59%) SSH
3 1 (0.15%) Firewall
3 1 (0.15%) LAN
3 1 (0.15%) Skype
3 1 (0.15%) VLAN
3 1 (0.15%) VPN
3 1 (0.15%) WAN
Database & Business Intelligence
1 273 (40.32%) SQL Server
2 201 (29.69%) Power BI
3 165 (24.37%) SQL Server Integration Services
4 157 (23.19%) Data Lake
5 145 (21.42%) SQL Server Reporting Services
6 135 (19.94%) Amazon Redshift
7 128 (18.91%) Snowflake Schema
7 128 (18.91%) SQL Server Analysis Services
8 93 (13.74%) MySQL
9 79 (11.67%) PostgreSQL
10 78 (11.52%) Big Data
11 69 (10.19%) Looker
12 67 (9.90%) Azure SQL Data Warehouse
12 67 (9.90%) NoSQL
13 64 (9.45%) Azure SQL Database
14 60 (8.86%) BigQuery
15 53 (7.83%) OLAP
16 46 (6.79%) Microsoft Analysis Services
16 46 (6.79%) Relational Database
17 39 (5.76%) Hadoop
Development Applications
1 59 (8.71%) Jenkins
2 54 (7.98%) GitLab
3 50 (7.39%) Artifactory
4 44 (6.50%) JIRA
5 41 (6.06%) Git (software)
6 16 (2.36%) Selenium
7 10 (1.48%) ERwin
8 9 (1.33%) Cypress.io
8 9 (1.33%) PowerDesigner
9 6 (0.89%) Visual Studio
10 5 (0.74%) SQL Server Management Studio (SSMS)
10 5 (0.74%) Team Foundation Server
11 4 (0.59%) Cucumber
12 3 (0.44%) ER Studio
12 3 (0.44%) PyCharm
13 2 (0.30%) GDB
13 2 (0.30%) Newman
13 2 (0.30%) Postman
13 2 (0.30%) Sourcetree
13 2 (0.30%) TeamCity
General
1 283 (41.80%) Finance
2 134 (19.79%) Banking
3 85 (12.56%) Back Office
4 42 (6.20%) Marketing
5 18 (2.66%) Advertising
6 12 (1.77%) Financial Institution
6 12 (1.77%) Games
7 9 (1.33%) Front Office
7 9 (1.33%) Legal
7 9 (1.33%) Retail
8 8 (1.18%) Pharmaceutical
9 6 (0.89%) Investment Banking
10 4 (0.59%) Manufacturing
11 3 (0.44%) General Ledger
12 1 (0.15%) Electronics
12 1 (0.15%) Law
12 1 (0.15%) Public Sector
12 1 (0.15%) Retail Banking
12 1 (0.15%) Telecoms
Job Titles
1 229 (33.83%) Developer
2 140 (20.68%) Data Engineer
3 113 (16.69%) Business Intelligence Developer
4 104 (15.36%) Architect
5 93 (13.74%) SQL Developer
6 89 (13.15%) Analyst
7 80 (11.82%) Solutions Architect
8 75 (11.08%) Data Architect
8 75 (11.08%) Data Warehouse Developer
9 55 (8.12%) Cloud Architect
9 55 (8.12%) Cloud Solutions Architect
10 50 (7.39%) AWS Architect
10 50 (7.39%) AWS Solutions Architect
10 50 (7.39%) Java Architect
10 50 (7.39%) Java Solutions Architect
11 43 (6.35%) Azure Engineer
12 42 (6.20%) SQL Server Developer
13 41 (6.06%) Azure Developer
14 39 (5.76%) SQL BI Developer
15 38 (5.61%) SSIS Developer
Libraries, Frameworks & Software Standards
1 94 (13.88%) Web Services
2 72 (10.64%) gRPC
3 67 (9.90%) Kafka
4 50 (7.39%) OAuth
4 50 (7.39%) Swagger
5 33 (4.87%) REST
6 31 (4.58%) MDX
7 30 (4.43%) XML
8 29 (4.28%) JSON
9 27 (3.99%) .NET
10 20 (2.95%) PySpark
11 18 (2.66%) SOAP
12 15 (2.22%) HTML
13 9 (1.33%) FIX Protocol
14 7 (1.03%) LDAP
14 7 (1.03%) Pandas
15 6 (0.89%) AngularJS
15 6 (0.89%) Gherkin
15 6 (0.89%) Middleware
16 5 (0.74%) CSS
Miscellaneous
1 95 (14.03%) Analytical Skills
2 81 (11.96%) Hedge funds
3 42 (6.20%) Management Information System
4 41 (6.06%) Greenfield Project
5 34 (5.02%) Data Structures
6 23 (3.40%) Clustering
7 19 (2.81%) Derivative
8 17 (2.51%) Reference Data
9 12 (1.77%) Foreign Exchange (FX)
9 12 (1.77%) Replication
10 9 (1.33%) Mobile App
10 9 (1.33%) Virtual Team
11 7 (1.03%) FMCG
11 7 (1.03%) Interest Rate Derivative
11 7 (1.03%) Reinsurance
11 7 (1.03%) User Experience
12 6 (0.89%) Mobile Banking
12 6 (0.89%) Online Banking
12 6 (0.89%) SWIFT
13 5 (0.74%) Public Cloud
Operating Systems
1 15 (2.22%) Linux
2 14 (2.07%) Windows
3 13 (1.92%) Unix
4 4 (0.59%) Windows 10
5 2 (0.30%) Red Hat Enterprise Linux
6 1 (0.15%) Windows Server
6 1 (0.15%) Windows Server 2008
Processes & Methodologies
1 379 (55.98%) Business Intelligence
2 251 (37.08%) ETL
3 226 (33.38%) Agile Software Development
4 206 (30.43%) Analytics
5 168 (24.82%) DevOps
6 163 (24.08%) Data Modelling
7 112 (16.54%) Asset Management
8 105 (15.51%) Microservices
9 92 (13.59%) Data Engineering
10 86 (12.70%) Mentoring
11 85 (12.56%) Visualisation
12 83 (12.26%) Investment Management
13 80 (11.82%) Software Engineering
14 71 (10.49%) Data Analytics
15 69 (10.19%) Performance Tuning
16 65 (9.60%) Data Science
17 60 (8.86%) Data Visualisation
18 57 (8.42%) Data Management
19 56 (8.27%) Data Architecture
20 55 (8.12%) SDLC
Programming Languages
1 452 (66.77%) SQL
2 244 (36.04%) Python
3 133 (19.65%) Java
4 77 (11.37%) T-SQL
5 46 (6.79%) C#
6 29 (4.28%) Data Analysis Expressions (DAX)
7 28 (4.14%) Scala
8 20 (2.95%) R
9 16 (2.36%) C
10 15 (2.22%) JavaScript
10 15 (2.22%) PowerShell
11 13 (1.92%) VBA
12 9 (1.33%) Java 8
13 8 (1.18%) U-SQL
14 7 (1.03%) C++
14 7 (1.03%) Shell Script
14 7 (1.03%) VB.NET
15 6 (0.89%) PL/SQL
16 4 (0.59%) PHP
16 4 (0.59%) Ruby
Qualifications
1 50 (7.39%) Sun Certification
2 41 (6.06%) Degree
3 19 (2.81%) Computer Science Degree
4 13 (1.92%) AWS Certification
5 7 (1.03%) Master's Degree
6 4 (0.59%) A+ Certification
6 4 (0.59%) Security Cleared
7 2 (0.30%) CISSP
7 2 (0.30%) DV Cleared
7 2 (0.30%) ISEB
7 2 (0.30%) ISTQB
7 2 (0.30%) ITIL Foundation Certificate
7 2 (0.30%) PhD
8 1 (0.15%) MCSA
8 1 (0.15%) Microsoft Certification
8 1 (0.15%) Numerate Degree
8 1 (0.15%) OCP
8 1 (0.15%) Oracle Certification
8 1 (0.15%) Postgraduate
8 1 (0.15%) SC Cleared
Quality Assurance & Compliance
1 39 (5.76%) Data Quality
2 26 (3.84%) QA
3 20 (2.95%) GDPR
4 9 (1.33%) SLA
5 7 (1.03%) Sarbanes-Oxley
6 4 (0.59%) Actionable Recommendations
7 3 (0.44%) UCITS
8 2 (0.30%) ISO/IEC 27001
8 2 (0.30%) NIST
9 1 (0.15%) COBIT
9 1 (0.15%) HIPAA
9 1 (0.15%) IFRS
9 1 (0.15%) MiFID
9 1 (0.15%) NCSC
9 1 (0.15%) PCI DSS
System Software
1 59 (8.71%) Docker
2 3 (0.44%) Apache Flume
3 2 (0.30%) Active Directory
4 1 (0.15%) HDFS
4 1 (0.15%) Oracle RAC
Systems Management
1 90 (13.29%) Kubernetes
2 12 (1.77%) Terraform
3 4 (0.59%) Control-M
4 3 (0.44%) HP Quality Center
5 1 (0.15%) Ansible
5 1 (0.15%) Argo
5 1 (0.15%) Data Guard
5 1 (0.15%) Microsoft Clustering
5 1 (0.15%) Oozie
5 1 (0.15%) Oracle Enterprise Manager
5 1 (0.15%) Oracle ZFS
5 1 (0.15%) Single Sign-On
Vendors
1 161 (23.78%) Microsoft
2 118 (17.43%) Google
3 92 (13.59%) Tableau
4 89 (13.15%) Databricks
5 76 (11.23%) Oracle
6 13 (1.92%) Cognos
6 13 (1.92%) Informatica
7 10 (1.48%) SAP
8 9 (1.33%) IBM
8 9 (1.33%) Teradata
9 7 (1.03%) DoubleClick
9 7 (1.03%) Hortonworks
9 7 (1.03%) Sybase
10 5 (0.74%) Alteryx
10 5 (0.74%) MicroStrategy
10 5 (0.74%) Netezza
11 4 (0.59%) EXASOL
11 4 (0.59%) Sun
12 3 (0.44%) Talend
13 2 (0.30%) Facebook