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

Data Warehousing
England > London
6 months to
27 May 2020
Same period 2019 Same period 2018
Rank 94 76 98
Rank change year-on-year -18 +22 -3
Permanent jobs citing Data Warehouse 1,339 2,233 2,262
As % of all permanent jobs advertised in London 3.53% 3.84% 3.26%
As % of the Database & Business Intelligence category 12.70% 13.33% 10.39%
Number of salaries quoted 1,186 1,913 1,911
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 £95,000 £87,500 £87,500
England median annual salary £60,000 £55,000 £52,500
% change year-on-year +9.09% +4.76% +5.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 10,542 16,757 21,778
As % of all permanent IT jobs advertised in London 27.82% 28.83% 31.41%
Number of salaries quoted 8,570 13,916 17,289
Median annual salary £67,500 £65,000 £60,000
Median salary % change year-on-year +3.85% +8.33% -
10th Percentile £40,000 £38,750 £37,500
90th Percentile £105,000 £95,000 £92,500
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

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 May 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 May 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 -9 310 £67,500 +8.00% 16
West London -9 66 £65,000 +23.81% 5
South London +13 27 £55,000 +4.76% 1
East London -1 11 £72,500 +61.11% 1
North London -4 7 £42,500 -34.62% 1
Data Warehouse
England

For the 6 months to 27 May 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 941 (70.28%) SQL
2 749 (55.94%) Business Intelligence
3 587 (43.84%) SQL Server
4 549 (41.00%) ETL
5 498 (37.19%) Azure
6 484 (36.15%) Python
7 479 (35.77%) Power Platform
8 470 (35.10%) Power BI
9 453 (33.83%) Analytics
10 410 (30.62%) Finance
11 396 (29.57%) Agile Software Development
12 385 (28.75%) SQL Server Integration Services
13 353 (26.36%) Microsoft
14 345 (25.77%) Data Modelling
15 310 (23.15%) AWS
16 290 (21.66%) Data Lake
17 278 (20.76%) SQL Server Analysis Services
18 244 (18.22%) SQL Server Reporting Services
19 237 (17.70%) Tableau
20 209 (15.61%) Oracle
21 206 (15.38%) Analytical Skills
22 202 (15.09%) Big Data
23 200 (14.94%) Visualisation
24 193 (14.41%) Java
25 173 (12.92%) Migration
25 173 (12.92%) T-SQL
26 166 (12.40%) Snowflake Schema
27 164 (12.25%) DevOps
27 164 (12.25%) Data Science
28 155 (11.58%) GCP

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 124 (9.26%) Apache Spark
2 60 (4.48%) Apache
3 36 (2.69%) Apache Airflow
4 17 (1.27%) Confluence
4 17 (1.27%) SharePoint
5 11 (0.82%) Luigi
6 10 (0.75%) Elasticsearch
7 9 (0.67%) SAS
8 8 (0.60%) MQSeries
8 8 (0.60%) Oracle Workflow
9 4 (0.30%) Apache Pig
9 4 (0.30%) Oracle SOA Suite
10 2 (0.15%) Apache Solr
10 2 (0.15%) BizTalk Server
10 2 (0.15%) IBM HTTP Server
10 2 (0.15%) IIS
10 2 (0.15%) Jupyter
11 1 (0.075%) ArcGIS
11 1 (0.075%) Tomcat
11 1 (0.075%) WebLogic
Applications
1 64 (4.78%) Microsoft Excel
2 27 (2.02%) Microsoft Office
3 11 (0.82%) Microsoft PowerPoint
4 2 (0.15%) InfoPath
4 2 (0.15%) Spreadsheet
5 1 (0.075%) SPSS
Business Applications
1 11 (0.82%) Markit EDM
1 11 (0.82%) SAP BPC
2 10 (0.75%) Cognos Business Intelligence
3 7 (0.52%) Dynamics CRM
4 4 (0.30%) RiskWrite
5 2 (0.15%) NetSuite
5 2 (0.15%) Oracle EBS
5 2 (0.15%) Oracle EBS R12
5 2 (0.15%) Raiser's Edge
5 2 (0.15%) SimCorp Dimension
6 1 (0.075%) FLEXCUBE
6 1 (0.075%) Hyperion Planning
6 1 (0.075%) Oracle Applications
6 1 (0.075%) Oracle ERP
6 1 (0.075%) Oracle General Ledger
6 1 (0.075%) Oracle iProcurement
6 1 (0.075%) Oracle Payables
6 1 (0.075%) Oracle Procure-to-Pay
6 1 (0.075%) Sparx Enterprise Architect
6 1 (0.075%) Temenos T24
Cloud Services
1 498 (37.19%) Azure
2 479 (35.77%) Power Platform
3 310 (23.15%) AWS
4 155 (11.58%) GCP
5 139 (10.38%) Azure Data Factory
6 70 (5.23%) Serverless
7 63 (4.71%) PaaS
8 58 (4.33%) SaaS
9 46 (3.44%) AWS Lambda
10 41 (3.06%) Amazon S3
11 30 (2.24%) Amazon ECS
12 27 (2.02%) Data Lake Analytics
13 24 (1.79%) Azure Stack
14 23 (1.72%) IaaS
15 20 (1.49%) Amazon EMR
16 19 (1.42%) Amazon Kinesis
16 19 (1.42%) Google Analytics
17 16 (1.19%) Amazon EC2
17 16 (1.19%) Cloud Computing
17 16 (1.19%) Dynamics 365
Communications & Networking
1 18 (1.34%) Internet
2 5 (0.37%) Intranet
2 5 (0.37%) Skype
2 5 (0.37%) WebEx
3 3 (0.22%) Extranet
3 3 (0.22%) SSH
4 2 (0.15%) Firewall
4 2 (0.15%) VoIP
5 1 (0.075%) FTP
Database & Business Intelligence
1 587 (43.84%) SQL Server
2 470 (35.10%) Power BI
3 385 (28.75%) SQL Server Integration Services
4 290 (21.66%) Data Lake
5 278 (20.76%) SQL Server Analysis Services
6 244 (18.22%) SQL Server Reporting Services
7 202 (15.09%) Big Data
8 166 (12.40%) Snowflake Schema
9 154 (11.50%) Amazon Redshift
10 143 (10.68%) Azure SQL Database
11 133 (9.93%) Relational Database
12 128 (9.56%) NoSQL
13 120 (8.96%) Microsoft Analysis Services
14 114 (8.51%) Azure SQL Data Warehouse
15 113 (8.44%) Hadoop
16 80 (5.97%) BigQuery
17 77 (5.75%) RDBMS
18 74 (5.53%) PostgreSQL
19 69 (5.15%) Looker
20 67 (5.00%) MySQL
Development Applications
1 54 (4.03%) JIRA
2 50 (3.73%) Git (software)
3 35 (2.61%) Visual Studio
4 32 (2.39%) Visual Studio Team System
5 26 (1.94%) SQL Server Management Studio (SSMS)
6 25 (1.87%) Jenkins
7 22 (1.64%) Team Foundation Server
8 18 (1.34%) ERwin
8 18 (1.34%) GitLab
9 14 (1.05%) Artifactory
10 12 (0.90%) PowerDesigner
11 10 (0.75%) TeamCity
12 7 (0.52%) Eclipse
13 6 (0.45%) ER Studio
14 5 (0.37%) GDB
14 5 (0.37%) JUnit
14 5 (0.37%) PyCharm
14 5 (0.37%) Sourcetree
15 4 (0.30%) GoCD
15 4 (0.30%) Visual Studio Code
General
1 410 (30.62%) Finance
2 99 (7.39%) Banking
3 91 (6.80%) Marketing
4 42 (3.14%) Back Office
5 40 (2.99%) Retail
6 25 (1.87%) Advertising
7 23 (1.72%) Games
8 19 (1.42%) Legal
9 17 (1.27%) Investment Banking
10 16 (1.19%) Financial Institution
11 15 (1.12%) Law
12 13 (0.97%) Publishing
13 12 (0.90%) Front Office
14 9 (0.67%) Public Sector
15 5 (0.37%) Pharmaceutical
16 4 (0.30%) Manufacturing
16 4 (0.30%) Telecoms
17 3 (0.22%) Automotive
18 2 (0.15%) Local Government
18 2 (0.15%) Police
Job Titles
1 444 (33.16%) Developer
2 259 (19.34%) Data Engineer
3 205 (15.31%) Analyst
4 178 (13.29%) Architect
5 164 (12.25%) Business Intelligence Developer
6 152 (11.35%) SQL Developer
7 139 (10.38%) Data Warehouse Developer
8 129 (9.63%) Data Architect
9 82 (6.12%) Azure Engineer
10 74 (5.53%) ETL Developer
11 68 (5.08%) Business Intelligence Analyst
11 68 (5.08%) SSIS Developer
12 60 (4.48%) Consultant
13 57 (4.26%) Business Analyst
14 56 (4.18%) Senior Developer
15 51 (3.81%) Data Analyst
16 49 (3.66%) DBA
17 47 (3.51%) Solutions Architect
18 46 (3.44%) Power BI Developer
18 46 (3.44%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 114 (8.51%) Kafka
2 101 (7.54%) .NET
3 90 (6.72%) Web Services
4 49 (3.66%) MDX
5 47 (3.51%) XML
6 34 (2.54%) JSON
7 30 (2.24%) HTML
8 29 (2.17%) REST
9 28 (2.09%) gRPC
10 26 (1.94%) PySpark
11 25 (1.87%) AngularJS
12 20 (1.49%) React
13 18 (1.34%) Middleware
14 14 (1.05%) FIX Protocol
14 14 (1.05%) HTML5
14 14 (1.05%) OAuth
14 14 (1.05%) Swagger
15 11 (0.82%) ASP.NET
15 11 (0.82%) RESTful
16 10 (0.75%) Pandas
Miscellaneous
1 206 (15.38%) Analytical Skills
2 101 (7.54%) Greenfield Project
3 83 (6.20%) Management Information System
4 80 (5.97%) Data Structures
5 33 (2.46%) Hedge funds
6 28 (2.09%) Algorithms
7 24 (1.79%) Foreign Exchange (FX)
8 23 (1.72%) Reinsurance
9 20 (1.49%) Derivative
9 20 (1.49%) FMCG
10 17 (1.27%) Reference Data
11 15 (1.12%) Enterprise Software
12 14 (1.05%) Online Games
12 14 (1.05%) Self-Motivation
12 14 (1.05%) SWIFT
13 12 (0.90%) Clustering
14 11 (0.82%) User Experience
15 10 (0.75%) Cloud Native
15 10 (0.75%) Fixed Income
16 9 (0.67%) OTC Derivatives
Operating Systems
1 48 (3.58%) Windows
2 28 (2.09%) Unix
3 27 (2.02%) Linux
4 17 (1.27%) Windows Server
5 10 (0.75%) Windows 2000
5 10 (0.75%) Windows XP
6 2 (0.15%) AIX
6 2 (0.15%) CentOS
6 2 (0.15%) Red Hat Enterprise Linux
6 2 (0.15%) Windows 10
6 2 (0.15%) Windows 7
6 2 (0.15%) Windows Server 2008
6 2 (0.15%) Windows Server 2012
7 1 (0.075%) Solaris
Processes & Methodologies
1 749 (55.94%) Business Intelligence
2 549 (41.00%) ETL
3 453 (33.83%) Analytics
4 396 (29.57%) Agile Software Development
5 345 (25.77%) Data Modelling
6 200 (14.94%) Visualisation
7 173 (12.92%) Migration
8 164 (12.25%) Data Science
8 164 (12.25%) DevOps
9 149 (11.13%) Data Engineering
10 140 (10.46%) Data Visualisation
10 140 (10.46%) Problem-Solving
11 134 (10.01%) Data Architecture
12 133 (9.93%) Data Management
13 119 (8.89%) Data Analytics
14 105 (7.84%) Data Analysis
15 104 (7.77%) Kimball Methodology
16 103 (7.69%) Stakeholder Management
17 100 (7.47%) Fintech
18 95 (7.09%) Computer Science
Programming Languages
1 941 (70.28%) SQL
2 484 (36.15%) Python
3 193 (14.41%) Java
4 173 (12.92%) T-SQL
5 149 (11.13%) C#
6 116 (8.66%) R
7 85 (6.35%) Data Analysis Expressions (DAX)
8 78 (5.83%) Scala
9 56 (4.18%) PowerShell
10 46 (3.44%) PL/SQL
11 37 (2.76%) VBA
12 32 (2.39%) VB.NET
13 28 (2.09%) Java 8
13 28 (2.09%) JavaScript
14 24 (1.79%) U-SQL
15 22 (1.64%) C
16 19 (1.42%) VB
17 15 (1.12%) PHP
18 11 (0.82%) C++
18 11 (0.82%) Shell Script
Qualifications
1 140 (10.46%) Degree
2 80 (5.97%) Computer Science Degree
3 20 (1.49%) Master's Degree
4 16 (1.19%) AWS Certification
5 14 (1.05%) Sun Certification
6 9 (0.67%) Microsoft Certification
7 8 (0.60%) PRINCE2 Practitioner
8 7 (0.52%) TOGAF Certification
9 6 (0.45%) MBA
9 6 (0.45%) Security Cleared
10 5 (0.37%) Numerate Degree
10 5 (0.37%) PhD
11 4 (0.30%) A+ Certification
11 4 (0.30%) CFA
12 3 (0.22%) SC Cleared
13 2 (0.15%) ACCA
13 2 (0.15%) CIMA
13 2 (0.15%) DV Cleared
13 2 (0.15%) Postgraduate
14 1 (0.075%) CISM
Quality Assurance & Compliance
1 93 (6.95%) Data Quality
2 63 (4.71%) QA
3 16 (1.19%) GDPR
4 15 (1.12%) Actionable Recommendations
5 7 (0.52%) Sarbanes-Oxley
6 6 (0.45%) SLA
7 5 (0.37%) PMO
8 4 (0.30%) UCITS
9 3 (0.22%) Solvency II
10 2 (0.15%) EMIR
10 2 (0.15%) MiFID
11 1 (0.075%) IFRS
System Software
1 50 (3.73%) Docker
2 10 (0.75%) Apache Flume
3 6 (0.45%) HDFS
4 4 (0.30%) Virtual Machines
5 3 (0.22%) VMware Infrastructure
6 2 (0.15%) Apache ZooKeeper
7 1 (0.075%) Oracle RAC
7 1 (0.075%) Postfix
7 1 (0.075%) vSphere
Systems Management
1 76 (5.68%) Kubernetes
2 17 (1.27%) Control-M
3 16 (1.19%) Terraform
4 14 (1.05%) Ansible
5 13 (0.97%) Opscode Chef
6 12 (0.90%) Puppet
7 9 (0.67%) Hadoop YARN
7 9 (0.67%) Oozie
8 5 (0.37%) Salt
9 3 (0.22%) Argo
9 3 (0.22%) Single Sign-On
10 2 (0.15%) Oracle Enterprise Manager
11 1 (0.075%) Data Guard
11 1 (0.075%) Mesos
11 1 (0.075%) Oracle RMAN
11 1 (0.075%) Oracle ZFS
Vendors
1 353 (26.36%) Microsoft
2 237 (17.70%) Tableau
3 209 (15.61%) Oracle
4 135 (10.08%) Google
5 114 (8.51%) Databricks
6 78 (5.83%) Informatica
7 43 (3.21%) SAP
7 43 (3.21%) Talend
8 33 (2.46%) IBM
9 28 (2.09%) Salesforce.com
10 27 (2.02%) Teradata
11 26 (1.94%) Cognos
12 19 (1.42%) Guidewire
13 18 (1.34%) Netezza
13 18 (1.34%) Sybase
14 15 (1.12%) Alteryx
15 14 (1.05%) Hortonworks
15 14 (1.05%) MicroStrategy
16 11 (0.82%) Ab Initio
17 10 (0.75%) Workday