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

Data Warehousing
Central London > City of London
6 months to
24 Feb 2020
Same period 2019 Same period 2018
Rank 74 88 87
Rank change year-on-year +14 -1 -20
Permanent jobs citing Data Warehouse 330 344 372
As % of all permanent IT jobs advertised in the City of London 3.65% 3.35% 3.48%
As % of the Database & Business Intelligence category 14.52% 11.11% 11.37%
Number of salaries quoted 290 329 315
City of London median annual salary £67,500 £60,000 £60,000
Median salary % change year-on-year +12.50% - -
10th Percentile £48,650 £42,250 £43,000
90th Percentile £87,500 £86,250 £77,500
Central London median annual salary £70,000 £60,000 £60,000
% change year-on-year +16.67% - -

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 2,273 3,097 3,271
As % of all permanent IT jobs advertised in the City of London 25.17% 30.19% 30.62%
Number of salaries quoted 1,984 2,793 2,929
City of London median annual salary £67,500 £65,000 £60,500
Median salary % change year-on-year +3.85% +7.44% +2.54%
10th Percentile £42,500 £41,250 £41,250
90th Percentile £105,000 £96,250 £90,000
Central London median annual salary £67,500 £65,000 £60,000
% change year-on-year +3.85% +8.33% +4.35%

Data Warehouse
Job Vacancy Trend in the City of London

Job postings citing Data Warehouse as a percentage 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

This chart provides the 3-month moving average for salaries quoted in permanent IT 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

The salary distribution of IT jobs citing Data Warehouse in the City of London over the 6 months to 24 February 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 24 February 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 -9 5 £65,000 -7.14%
Data Warehouse
Central London

For the 6 months to 24 February 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 224 (67.88%) SQL
2 181 (54.85%) Business Intelligence
3 145 (43.94%) Power BI
3 145 (43.94%) Power Platform
4 143 (43.33%) ETL
5 141 (42.73%) SQL Server
6 132 (40.00%) Azure
7 127 (38.48%) Analytics
7 127 (38.48%) SQL Server Integration Services
8 107 (32.42%) Agile Software Development
9 104 (31.52%) Microsoft
10 100 (30.30%) SQL Server Analysis Services
11 97 (29.39%) Finance
12 90 (27.27%) Python
13 82 (24.85%) Data Modelling
14 81 (24.55%) SQL Server Reporting Services
15 69 (20.91%) Big Data
16 67 (20.30%) Visualisation
17 52 (15.76%) Microsoft Analysis Services
17 52 (15.76%) AWS
18 51 (15.45%) Analytical Skills
18 51 (15.45%) T-SQL
18 51 (15.45%) Java
19 49 (14.85%) Management Information System
19 49 (14.85%) Tableau
20 48 (14.55%) Data Management
21 46 (13.94%) C#
22 42 (12.73%) Data Quality
22 42 (12.73%) DevOps
22 42 (12.73%) Data Science

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 35 (10.61%) Apache Spark
2 8 (2.42%) Apache Airflow
3 7 (2.12%) SAS
4 6 (1.82%) Apache
4 6 (1.82%) Confluence
5 4 (1.21%) Luigi
6 3 (0.91%) Apache Pig
6 3 (0.91%) SharePoint
7 1 (0.30%) IBM HTTP Server
Applications
1 21 (6.36%) Microsoft Excel
2 5 (1.52%) Microsoft Office
3 4 (1.21%) Microsoft PowerPoint
Business Applications
1 4 (1.21%) Dynamics CRM
2 3 (0.91%) Cognos Business Intelligence
3 2 (0.61%) RiskWrite
4 1 (0.30%) Eagle PACE
4 1 (0.30%) FastStats
4 1 (0.30%) HFM
4 1 (0.30%) Hyperion Planning
4 1 (0.30%) Markit EDM
4 1 (0.30%) PolarLake
4 1 (0.30%) Salesforce.com CRM
4 1 (0.30%) Sparx Enterprise Architect
4 1 (0.30%) thinkFolio
Cloud Services
1 145 (43.94%) Power Platform
2 132 (40.00%) Azure
3 52 (15.76%) AWS
4 24 (7.27%) Azure Data Factory
5 15 (4.55%) GCP
6 9 (2.73%) Amazon S3
7 7 (2.12%) PaaS
8 6 (1.82%) Amazon EMR
8 6 (1.82%) IaaS
9 5 (1.52%) Data Lake Analytics
10 3 (0.91%) Google Analytics
11 2 (0.61%) Amazon Kinesis
11 2 (0.61%) Cloud Computing
11 2 (0.61%) Google Tag Manager
11 2 (0.61%) Mimecast
11 2 (0.61%) SaaS
11 2 (0.61%) Serverless
12 1 (0.30%) Azure Functions
12 1 (0.30%) Azure Machine Learning
12 1 (0.30%) Google Sheets
Database & Business Intelligence
1 145 (43.94%) Power BI
2 141 (42.73%) SQL Server
3 127 (38.48%) SQL Server Integration Services
4 100 (30.30%) SQL Server Analysis Services
5 81 (24.55%) SQL Server Reporting Services
6 69 (20.91%) Big Data
7 52 (15.76%) Microsoft Analysis Services
8 41 (12.42%) Data Lake
9 38 (11.52%) Relational Database
10 35 (10.61%) Hadoop
11 26 (7.88%) Apache Hive
11 26 (7.88%) Snowflake Schema
12 24 (7.27%) NoSQL
13 22 (6.67%) Azure SQL Database
13 22 (6.67%) MongoDB
13 22 (6.67%) PostgreSQL
14 16 (4.85%) RDBMS
15 15 (4.55%) OLAP
16 14 (4.24%) Amazon Redshift
17 13 (3.94%) Pentaho
Development Applications
1 22 (6.67%) Team Foundation Server
2 21 (6.36%) JIRA
3 12 (3.64%) SQL Server Management Studio (SSMS)
4 9 (2.73%) Visual Studio Team System
5 7 (2.12%) ERwin
5 7 (2.12%) Git (software)
5 7 (2.12%) Jenkins
5 7 (2.12%) PowerDesigner
6 4 (1.21%) Visual Studio
7 3 (0.91%) JUnit
7 3 (0.91%) Octopus Deploy
7 3 (0.91%) TeamCity
8 2 (0.61%) Eclipse
9 1 (0.30%) ER Studio
9 1 (0.30%) Jasmine
9 1 (0.30%) Karma Test Runner
9 1 (0.30%) MSTest
9 1 (0.30%) NUnit
9 1 (0.30%) Selenium
General
1 97 (29.39%) Finance
2 18 (5.45%) Marketing
3 12 (3.64%) Banking
4 10 (3.03%) Retail
5 5 (1.52%) Advertising
6 3 (0.91%) Billing
6 3 (0.91%) Law
6 3 (0.91%) Telecoms
7 2 (0.61%) Legal
7 2 (0.61%) Public Sector
7 2 (0.61%) Publishing
8 1 (0.30%) Back Office
8 1 (0.30%) Front Office
8 1 (0.30%) Games
8 1 (0.30%) Investment Banking
8 1 (0.30%) Polish Language
Job Titles
1 103 (31.21%) Developer
2 73 (22.12%) Business Intelligence Developer
3 56 (16.97%) Analyst
4 47 (14.24%) Data Engineer
5 42 (12.73%) Architect
6 27 (8.18%) Data Architect
6 27 (8.18%) SQL Developer
7 23 (6.97%) DBA
8 22 (6.67%) SQL DBA
9 21 (6.36%) SQL BI Developer
10 19 (5.76%) Business Intelligence Analyst
11 18 (5.45%) Business Analyst
12 15 (4.55%) Administrator
12 15 (4.55%) Data Warehouse Developer
12 15 (4.55%) Power BI Developer
13 14 (4.24%) Data Analyst
13 14 (4.24%) ETL Developer
14 13 (3.94%) Senior Business Intelligence Developer
14 13 (3.94%) Senior Developer
14 13 (3.94%) SSRS Developer
Libraries, Frameworks & Software Standards
1 29 (8.79%) MDX
2 22 (6.67%) Kafka
3 18 (5.45%) .NET
4 17 (5.15%) XML
5 15 (4.55%) D3.js
5 15 (4.55%) Vue.js
6 12 (3.64%) JSON
7 7 (2.12%) ASP.NET
7 7 (2.12%) FIX Protocol
8 6 (1.82%) GraphQL
8 6 (1.82%) RESTful
8 6 (1.82%) SOAP
9 5 (1.52%) HTML
9 5 (1.52%) Web Services
10 4 (1.21%) .NET Framework
10 4 (1.21%) AngularJS
10 4 (1.21%) CSS
10 4 (1.21%) Node.js
10 4 (1.21%) PySpark
10 4 (1.21%) Twitter Bootstrap
Miscellaneous
1 51 (15.45%) Analytical Skills
2 49 (14.85%) Management Information System
3 20 (6.06%) Reinsurance
4 14 (4.24%) Self-Motivation
5 11 (3.33%) Greenfield Project
6 8 (2.42%) Reference Data
7 7 (2.12%) Data Structures
7 7 (2.12%) Foreign Exchange (FX)
8 6 (1.82%) Public Cloud
8 6 (1.82%) User Experience
9 3 (0.91%) Analytical Mindset
9 3 (0.91%) Client/Server
9 3 (0.91%) N-Tier
9 3 (0.91%) Private Cloud
9 3 (0.91%) Taxonomies
10 2 (0.61%) Algorithms
10 2 (0.61%) Semantic Web
10 2 (0.61%) SWIFT
11 1 (0.30%) Data Centre
11 1 (0.30%) Hedge funds
Operating Systems
1 20 (6.06%) Windows
2 17 (5.15%) Windows Server
3 4 (1.21%) Linux
4 3 (0.91%) Unix
Processes & Methodologies
1 181 (54.85%) Business Intelligence
2 143 (43.33%) ETL
3 127 (38.48%) Analytics
4 107 (32.42%) Agile Software Development
5 82 (24.85%) Data Modelling
6 67 (20.30%) Visualisation
7 48 (14.55%) Data Management
8 42 (12.73%) Data Science
8 42 (12.73%) DevOps
9 41 (12.42%) Decision-Making
10 39 (11.82%) Data Visualisation
11 38 (11.52%) Data Architecture
11 38 (11.52%) Problem-Solving
12 34 (10.30%) User Acceptance Testing
13 33 (10.00%) Fintech
14 32 (9.70%) Migration
15 31 (9.39%) Data Analysis
16 30 (9.09%) Business Analytics
16 30 (9.09%) Stakeholder Management
17 29 (8.79%) Project Management
Programming Languages
1 224 (67.88%) SQL
2 90 (27.27%) Python
3 51 (15.45%) Java
3 51 (15.45%) T-SQL
4 46 (13.94%) C#
5 31 (9.39%) Data Analysis Expressions (DAX)
6 26 (7.88%) PL/SQL
7 22 (6.67%) R
8 13 (3.94%) VBA
9 12 (3.64%) Scala
10 8 (2.42%) JavaScript
11 6 (1.82%) VB
12 5 (1.52%) TypeScript
13 4 (1.21%) Go
13 4 (1.21%) PowerShell
13 4 (1.21%) VB.NET
14 3 (0.91%) Shell Script
15 2 (0.61%) HiveQL
15 2 (0.61%) VB6
16 1 (0.30%) Bash Shell
Qualifications
1 30 (9.09%) Degree
2 19 (5.76%) Computer Science Degree
3 8 (2.42%) ITIL Foundation Certificate
4 7 (2.12%) AWS Certification
4 7 (2.12%) Master's Degree
5 3 (0.91%) Postgraduate
5 3 (0.91%) Security Cleared
6 1 (0.30%) MBA
6 1 (0.30%) Microsoft Certification
Quality Assurance & Compliance
1 42 (12.73%) Data Quality
2 14 (4.24%) QA
3 4 (1.21%) GDPR
4 1 (0.30%) Basel III
4 1 (0.30%) IFRS
4 1 (0.30%) IFRS 9
System Software
1 4 (1.21%) Apache Flume
1 4 (1.21%) Docker
2 3 (0.91%) HDFS
Systems Management
1 9 (2.73%) Control-M
2 7 (2.12%) Ansible
3 5 (1.52%) Kubernetes
4 4 (1.21%) Hadoop YARN
4 4 (1.21%) Opscode Chef
4 4 (1.21%) Puppet
4 4 (1.21%) Salt
5 3 (0.91%) Terraform
Vendors
1 104 (31.52%) Microsoft
2 49 (14.85%) Tableau
3 37 (11.21%) Oracle
4 31 (9.39%) Informatica
5 28 (8.48%) Google
6 21 (6.36%) Talend
7 15 (4.55%) Guidewire
7 15 (4.55%) Teradata
8 12 (3.64%) Databricks
8 12 (3.64%) SAP
9 11 (3.33%) Cognos
10 9 (2.73%) RedGate
11 8 (2.42%) IBM
12 7 (2.12%) SnapLogic
13 5 (1.52%) Alteryx
13 5 (1.52%) Netezza
14 4 (1.21%) Cloudera
15 3 (0.91%) Hortonworks
15 3 (0.91%) MapR
15 3 (0.91%) Veeam