Period
to 25 May 2020

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

Data Warehousing
Central London > City of London
6 months to
25 May 2020
Same period 2019 Same period 2018
Rank 76 59 67
Rank change year-on-year -17 +8 -10
Permanent jobs citing Data Warehouse 258 431 480
As % of all permanent jobs advertised in the City of London 3.71% 4.25% 4.48%
As % of the Database & Business Intelligence category 15.50% 13.79% 14.29%
Number of salaries quoted 236 404 424
Median annual salary £65,000 £62,500 £65,000
Median salary % change year-on-year +4.00% -3.85% +13.04%
10th Percentile £43,125 £44,000 £45,000
90th Percentile £87,500 £85,000 £85,000
Central London median annual salary £67,500 £62,500 £65,000
% change year-on-year +8.00% -3.85% +10.17%

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,664 3,125 3,359
As % of all permanent IT jobs advertised in the City of London 23.90% 30.84% 31.34%
Number of salaries quoted 1,441 2,822 3,002
Median annual salary £67,500 £67,500 £65,000
Median salary % change year-on-year - +3.85% +8.33%
10th Percentile £42,110 £41,250 £41,250
90th Percentile £100,000 £97,500 £90,000
Central London median annual salary £70,000 £65,000 £62,500
% change year-on-year +7.69% +4.00% +4.17%

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 25 May 2020.

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 25 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
London Bridge - 1 £37,500 -
Data Warehouse
Central London

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

1 189 (73.26%) SQL
2 136 (52.71%) Business Intelligence
3 105 (40.70%) Power BI
3 105 (40.70%) Power Platform
4 100 (38.76%) Agile Software Development
5 99 (38.37%) SQL Server
6 95 (36.82%) Azure
7 91 (35.27%) Analytics
8 89 (34.50%) ETL
9 84 (32.56%) SQL Server Integration Services
10 81 (31.40%) Microsoft
10 81 (31.40%) Finance
11 78 (30.23%) Data Modelling
12 65 (25.19%) Python
12 65 (25.19%) SQL Server Reporting Services
13 60 (23.26%) Data Lake
14 58 (22.48%) SQL Server Analysis Services
15 57 (22.09%) Big Data
16 48 (18.60%) Analytical Skills
17 45 (17.44%) T-SQL
17 45 (17.44%) Management Information System
18 40 (15.50%) Business Analysis
19 39 (15.12%) AWS
20 32 (12.40%) Data Management
21 31 (12.02%) Degree
21 31 (12.02%) Visualisation
22 30 (11.63%) Problem-Solving
22 30 (11.63%) Migration
23 29 (11.24%) C#
24 28 (10.85%) Oracle

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 26 (10.08%) Apache Spark
2 8 (3.10%) Apache Airflow
2 8 (3.10%) Luigi
3 7 (2.71%) Apache
4 6 (2.33%) SharePoint
5 5 (1.94%) Confluence
6 3 (1.16%) Apache Pig
6 3 (1.16%) MQSeries
7 2 (0.78%) SAS
Applications
1 20 (7.75%) Microsoft Excel
2 10 (3.88%) Microsoft Office
3 9 (3.49%) Microsoft PowerPoint
4 1 (0.39%) SPSS
Business Applications
1 3 (1.16%) Cognos Business Intelligence
1 3 (1.16%) Dynamics CRM
1 3 (1.16%) Markit EDM
2 2 (0.78%) RiskWrite
2 2 (0.78%) SAP BPC
3 1 (0.39%) Oracle General Ledger
3 1 (0.39%) Oracle Internet Expenses
3 1 (0.39%) Oracle iProcurement
3 1 (0.39%) Oracle Procure-to-Pay
3 1 (0.39%) Sparx Enterprise Architect
Cloud Services
1 105 (40.70%) Power Platform
2 95 (36.82%) Azure
3 39 (15.12%) AWS
4 17 (6.59%) Azure Data Factory
5 11 (4.26%) GCP
6 8 (3.10%) Amazon S3
6 8 (3.10%) IaaS
6 8 (3.10%) PaaS
7 5 (1.94%) Amazon EMR
8 4 (1.55%) Data Lake Analytics
9 2 (0.78%) Amazon Kinesis
10 1 (0.39%) Azure Stack
10 1 (0.39%) Google Analytics
10 1 (0.39%) Google Sheets
10 1 (0.39%) Logic Apps
10 1 (0.39%) Office 365
10 1 (0.39%) Serverless
Communications & Networking
1 1 (0.39%) SSH
Database & Business Intelligence
1 105 (40.70%) Power BI
2 99 (38.37%) SQL Server
3 84 (32.56%) SQL Server Integration Services
4 65 (25.19%) SQL Server Reporting Services
5 60 (23.26%) Data Lake
6 58 (22.48%) SQL Server Analysis Services
7 57 (22.09%) Big Data
8 28 (10.85%) NoSQL
9 26 (10.08%) Hadoop
9 26 (10.08%) Snowflake Schema
10 25 (9.69%) Microsoft Analysis Services
11 24 (9.30%) Relational Database
12 21 (8.14%) MongoDB
13 19 (7.36%) Apache Hive
13 19 (7.36%) Azure SQL Database
14 16 (6.20%) RDBMS
15 15 (5.81%) Azure SQL Data Warehouse
16 14 (5.43%) Apache Cassandra
16 14 (5.43%) OLAP
17 13 (5.04%) Data Mining
Development Applications
1 18 (6.98%) Team Foundation Server
2 14 (5.43%) JIRA
3 11 (4.26%) Visual Studio
4 10 (3.88%) SQL Server Management Studio (SSMS)
5 7 (2.71%) ERwin
5 7 (2.71%) PowerDesigner
6 6 (2.33%) Visual Studio Team System
7 3 (1.16%) Git (software)
7 3 (1.16%) Jenkins
7 3 (1.16%) JUnit
7 3 (1.16%) Octopus Deploy
7 3 (1.16%) TeamCity
8 2 (0.78%) Eclipse
9 1 (0.39%) ER Studio
9 1 (0.39%) Jasmine
9 1 (0.39%) Karma Test Runner
9 1 (0.39%) MSTest
9 1 (0.39%) NUnit
General
1 81 (31.40%) Finance
2 14 (5.43%) Banking
2 14 (5.43%) Marketing
3 8 (3.10%) Advertising
4 7 (2.71%) Law
5 6 (2.33%) Back Office
6 5 (1.94%) Retail
7 2 (0.78%) Financial Institution
7 2 (0.78%) Games
7 2 (0.78%) Pharmaceutical
7 2 (0.78%) Publishing
8 1 (0.39%) Front Office
8 1 (0.39%) General Ledger
8 1 (0.39%) Investment Banking
8 1 (0.39%) Public Sector
Job Titles
1 77 (29.84%) Developer
2 68 (26.36%) Analyst
3 39 (15.12%) Data Engineer
4 34 (13.18%) Business Intelligence Developer
5 30 (11.63%) Business Analyst
6 27 (10.47%) SQL Developer
7 25 (9.69%) Data Warehouse Developer
8 22 (8.53%) Architect
9 18 (6.98%) SSIS Developer
10 16 (6.20%) Business Intelligence Analyst
10 16 (6.20%) SQL BI Developer
10 16 (6.20%) SSRS Developer
11 15 (5.81%) Systems Analyst
12 13 (5.04%) Data Architect
12 13 (5.04%) DBA
12 13 (5.04%) ETL Developer
13 12 (4.65%) SQL DBA
14 11 (4.26%) Data Analyst
14 11 (4.26%) Technical Analyst
15 9 (3.49%) Insurance Business Analyst
Libraries, Frameworks & Software Standards
1 25 (9.69%) Kafka
2 16 (6.20%) .NET
2 16 (6.20%) MDX
3 15 (5.81%) XML
4 13 (5.04%) JSON
5 7 (2.71%) AngularJS
5 7 (2.71%) FIX Protocol
5 7 (2.71%) GraphQL
6 6 (2.33%) ASP.NET
7 5 (1.94%) Elastic Stack
7 5 (1.94%) Middleware
7 5 (1.94%) PySpark
8 4 (1.55%) CSS
8 4 (1.55%) HTML
8 4 (1.55%) RESTful
8 4 (1.55%) SOAP
8 4 (1.55%) Web Services
9 3 (1.16%) HTML5
9 3 (1.16%) Node.js
9 3 (1.16%) XML Schema
Miscellaneous
1 48 (18.60%) Analytical Skills
2 45 (17.44%) Management Information System
3 14 (5.43%) Greenfield Project
3 14 (5.43%) Reinsurance
4 8 (3.10%) Reference Data
5 7 (2.71%) Foreign Exchange (FX)
6 5 (1.94%) User Experience
7 4 (1.55%) Algorithms
8 3 (1.16%) Client/Server
8 3 (1.16%) N-Tier
8 3 (1.16%) SWIFT
8 3 (1.16%) Taxonomies
9 2 (0.78%) Analytical Mindset
9 2 (0.78%) Derivative
9 2 (0.78%) Hedge funds
9 2 (0.78%) Mobile App
9 2 (0.78%) Semantic Web
10 1 (0.39%) Data Structures
10 1 (0.39%) Public Cloud
10 1 (0.39%) Self-Motivation
Operating Systems
1 12 (4.65%) Windows
2 8 (3.10%) Windows Server
3 2 (0.78%) Linux
3 2 (0.78%) Unix
Processes & Methodologies
1 136 (52.71%) Business Intelligence
2 100 (38.76%) Agile Software Development
3 91 (35.27%) Analytics
4 89 (34.50%) ETL
5 78 (30.23%) Data Modelling
6 40 (15.50%) Business Analysis
7 32 (12.40%) Data Management
8 31 (12.02%) Visualisation
9 30 (11.63%) Migration
9 30 (11.63%) Problem-Solving
10 27 (10.47%) Data Science
11 26 (10.08%) Data Architecture
11 26 (10.08%) Fintech
11 26 (10.08%) User Acceptance Testing
12 25 (9.69%) DevOps
13 24 (9.30%) Business Analytics
13 24 (9.30%) Machine Learning
13 24 (9.30%) Stakeholder Management
14 23 (8.91%) Computer Science
14 23 (8.91%) Project Management
Programming Languages
1 189 (73.26%) SQL
2 65 (25.19%) Python
3 45 (17.44%) T-SQL
4 29 (11.24%) C#
5 27 (10.47%) Data Analysis Expressions (DAX)
6 20 (7.75%) Java
7 18 (6.98%) R
8 14 (5.43%) Scala
9 12 (4.65%) VBA
10 9 (3.49%) PL/SQL
11 6 (2.33%) JavaScript
11 6 (2.33%) VB.NET
12 5 (1.94%) PowerShell
13 4 (1.55%) Shell Script
13 4 (1.55%) TypeScript
14 3 (1.16%) Go
14 3 (1.16%) VB
15 2 (0.78%) HiveQL
15 2 (0.78%) VB6
16 1 (0.39%) Korn
Qualifications
1 31 (12.02%) Degree
2 22 (8.53%) Computer Science Degree
3 7 (2.71%) AWS Certification
3 7 (2.71%) Master's Degree
4 4 (1.55%) A+ Certification
4 4 (1.55%) CFA
5 2 (0.78%) ACCA
5 2 (0.78%) CIMA
6 1 (0.39%) ITIL Foundation Certificate
6 1 (0.39%) MBA
6 1 (0.39%) Postgraduate
Quality Assurance & Compliance
1 20 (7.75%) Data Quality
2 11 (4.26%) QA
3 4 (1.55%) SLA
4 1 (0.39%) GDPR
System Software
1 4 (1.55%) Docker
2 3 (1.16%) Apache Flume
2 3 (1.16%) HDFS
Systems Management
1 8 (3.10%) Ansible
1 8 (3.10%) Kubernetes
2 5 (1.94%) Control-M
2 5 (1.94%) Opscode Chef
2 5 (1.94%) Puppet
2 5 (1.94%) Salt
3 4 (1.55%) Hadoop YARN
3 4 (1.55%) Terraform
4 3 (1.16%) Argo
4 3 (1.16%) Oozie
Vendors
1 81 (31.40%) Microsoft
2 28 (10.85%) Oracle
3 25 (9.69%) Tableau
4 18 (6.98%) Guidewire
5 13 (5.04%) Informatica
6 12 (4.65%) Google
7 9 (3.49%) Databricks
7 9 (3.49%) Talend
8 8 (3.10%) SnapLogic
9 7 (2.71%) RedGate
10 6 (2.33%) Cognos
11 5 (1.94%) SAP
12 4 (1.55%) Hortonworks
12 4 (1.55%) Sun
13 3 (1.16%) Cloudera
13 3 (1.16%) IBM
13 3 (1.16%) MapR
14 2 (0.78%) Infragistics
14 2 (0.78%) MicroStrategy
14 2 (0.78%) Netezza