Period
to 30 July 2021

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

Data Warehousing
London > Central London
6 months to
30 Jul 2021
Same period 2020 Same period 2019
Rank 63 72 49
Rank change year-on-year +9 -23 +28
Permanent jobs citing Data Warehouse 287 247 674
As % of all permanent jobs advertised in Central London 4.30% 3.78% 5.13%
As % of the Database & Business Intelligence category 15.15% 15.20% 16.38%
Number of salaries quoted 257 208 617
10th Percentile £49,000 £42,500 £44,600
25th Percentile £53,750 £54,688 £51,000
Median annual salary (50th Percentile) £70,000 £67,500 £62,500
Median % change year-on-year +3.70% +8.00% -3.85%
75th Percentile £90,000 £80,000 £72,500
90th Percentile £107,500 £93,750 £85,000
London median annual salary £70,000 £70,000 £62,500
% change year-on-year - +12.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 Central London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Central London
Permanent vacancies with a requirement for database or business intelligence skills 1,895 1,625 4,114
As % of all permanent IT jobs advertised in Central London 28.38% 24.85% 31.34%
Number of salaries quoted 1,669 1,430 3,739
10th Percentile £45,000 £41,250 £41,250
25th Percentile £53,750 £51,563 £51,250
Median annual salary (50th Percentile) £70,000 £70,000 £65,000
Median % change year-on-year - +7.69% +4.00%
75th Percentile £88,750 £85,000 £82,500
90th Percentile £107,500 £96,250 £97,500
London median annual salary £70,000 £67,500 £65,000
% change year-on-year +3.70% +3.85% +4.00%

Data Warehouse
Job Vacancy Trend in Central London

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

Job vacancy trend for Data Warehouse in Central London

Data Warehouse
Salary Trend in Central London

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

Salary trend for Data Warehouse in Central London

Data Warehouse
Salary Histogram in Central London

Salary distribution for jobs citing Data Warehouse in Central London over the 6 months to 30 July 2021.

Salary histogram for Data Warehouse in Central London

Data Warehouse
Job Locations in Central 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 Central London region over the 6 months to 30 July 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
City of London -10 222 £67,500 -1.82% 42
City of Westminster +8 8 £58,750 -48.91%
West End of London -3 6 £65,000 -13.33%
Southwark +10 1 £80,000 +113.33%
Data Warehouse
London

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

1 172 (59.93%) SQL
2 169 (58.89%) Business Intelligence
3 126 (43.90%) ETL
4 120 (41.81%) Analytics
5 115 (40.07%) Azure
6 109 (37.98%) Power Platform
7 108 (37.63%) Power BI
8 89 (31.01%) SQL Server Integration Services
9 87 (30.31%) Data Lake
10 83 (28.92%) Data Modelling
11 78 (27.18%) Finance
12 77 (26.83%) Python
13 74 (25.78%) SQL Server
14 69 (24.04%) Microsoft
14 69 (24.04%) Agile Software Development
14 69 (24.04%) SQL Server Reporting Services
15 55 (19.16%) AWS
16 48 (16.72%) SQL Server Analysis Services
17 46 (16.03%) Analytical Skills
17 46 (16.03%) Social Skills
18 44 (15.33%) Azure Data Factory
18 44 (15.33%) Data Engineering
19 42 (14.63%) Data Analysis
20 41 (14.29%) Big Data
21 40 (13.94%) Problem-Solving
22 39 (13.59%) Databricks
23 37 (12.89%) Amazon Redshift
24 36 (12.54%) Tableau
25 34 (11.85%) DevOps
26 32 (11.15%) Data Architecture

Data Warehouse
Co-occurring IT Skills in Central 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 (9.06%) Apache Spark
2 15 (5.23%) Apache
2 15 (5.23%) SharePoint
3 9 (3.14%) Confluence
4 6 (2.09%) CMS
5 4 (1.39%) Apache Airflow
5 4 (1.39%) Sitecore CMS
6 2 (0.70%) Apache Pig
6 2 (0.70%) Skype for Business
7 1 (0.35%) Oracle SOA Suite
7 1 (0.35%) SAS
Applications
1 27 (9.41%) Microsoft Excel
2 3 (1.05%) Microsoft Office
3 2 (0.70%) MS Visio
4 1 (0.35%) Microsoft PowerPoint
4 1 (0.35%) Spreadsheet
Business Applications
1 4 (1.39%) HFM
1 4 (1.39%) Hyperion Planning
1 4 (1.39%) Oracle Subledger Accounting
2 2 (0.70%) Dynamics AX
3 1 (0.35%) Dynamics CRM
3 1 (0.35%) NetSuite
Cloud Services
1 115 (40.07%) Azure
2 109 (37.98%) Power Platform
3 55 (19.16%) AWS
4 44 (15.33%) Azure Data Factory
5 28 (9.76%) Snowflake
6 17 (5.92%) Amazon EC2
7 16 (5.57%) PowerApps
8 15 (5.23%) Amazon S3
8 15 (5.23%) GCP
9 14 (4.88%) SaaS
10 12 (4.18%) Azure Synapse Analytics
11 11 (3.83%) Azure Storage
11 11 (3.83%) Power Automate
12 10 (3.48%) Serverless
13 9 (3.14%) Matillion
14 8 (2.79%) Microsoft 365
15 7 (2.44%) AWS CloudFormation
16 6 (2.09%) AWS Data Pipeline
16 6 (2.09%) Azure Cosmos DB
17 5 (1.74%) Azure Functions
Communications & Networking
1 4 (1.39%) SSH
2 2 (0.70%) Skype
3 1 (0.35%) Firewall
3 1 (0.35%) FTP
3 1 (0.35%) Intranet
3 1 (0.35%) Network Security
3 1 (0.35%) PuTTY
3 1 (0.35%) Reverse Proxy
3 1 (0.35%) WinSCP
Database & Business Intelligence
1 108 (37.63%) Power BI
2 89 (31.01%) SQL Server Integration Services
3 87 (30.31%) Data Lake
4 74 (25.78%) SQL Server
5 69 (24.04%) SQL Server Reporting Services
6 48 (16.72%) SQL Server Analysis Services
7 41 (14.29%) Big Data
8 37 (12.89%) Amazon Redshift
9 36 (12.54%) Tableau
10 29 (10.10%) Relational Database
11 27 (9.41%) Azure SQL Database
12 24 (8.36%) Azure SQL Data Warehouse
12 24 (8.36%) Hadoop
13 21 (7.32%) NoSQL
14 19 (6.62%) Amazon RDS
15 18 (6.27%) Metadata
16 16 (5.57%) Microsoft Analysis Services
17 15 (5.23%) PostgreSQL
18 10 (3.48%) OLTP
19 9 (3.14%) Star Schema
Development Applications
1 30 (10.45%) JIRA
2 11 (3.83%) ER Studio
2 11 (3.83%) ERwin
2 11 (3.83%) Visual Studio
3 8 (2.79%) Git (software)
4 7 (2.44%) PowerDesigner
5 6 (2.09%) SQL Server Management Studio (SSMS)
6 4 (1.39%) Cucumber
6 4 (1.39%) GDB
6 4 (1.39%) Selenium
6 4 (1.39%) Subversion
6 4 (1.39%) Toad
6 4 (1.39%) TortoiseSVN
6 4 (1.39%) Visual Studio Code
7 3 (1.05%) Team Foundation Server
8 2 (0.70%) Jenkins
9 1 (0.35%) Octopus Deploy
9 1 (0.35%) Oracle APEX
9 1 (0.35%) Sourcetree
9 1 (0.35%) TeamCity
General
1 78 (27.18%) Finance
2 46 (16.03%) Analytical Skills
2 46 (16.03%) Social Skills
3 12 (4.18%) Advertising
4 10 (3.48%) Back Office
4 10 (3.48%) Banking
5 7 (2.44%) Investment Banking
6 6 (2.09%) Law
7 5 (1.74%) French Language
7 5 (1.74%) Legal
7 5 (1.74%) Presentation Skills
8 3 (1.05%) Front Office
8 3 (1.05%) Marketing
8 3 (1.05%) Organisational Skills
8 3 (1.05%) Publishing
9 2 (0.70%) Documentation Skills
9 2 (0.70%) Pharmaceutical
9 2 (0.70%) Retail
10 1 (0.35%) Influencing Skills
10 1 (0.35%) Social Housing
Job Titles
1 76 (26.48%) Data Engineer
2 54 (18.82%) Architect
3 50 (17.42%) Analyst
3 50 (17.42%) Developer
4 37 (12.89%) Data Architect
5 36 (12.54%) Business Intelligence Developer
6 19 (6.62%) Data Analyst
7 18 (6.27%) Applications Support
7 18 (6.27%) Senior Data Engineer
7 18 (6.27%) Solutions Architect
8 17 (5.92%) AWS Engineer
9 16 (5.57%) Senior Architect
9 16 (5.57%) SQL Analyst
10 15 (5.23%) SSIS Analyst
11 14 (4.88%) Azure Engineer
12 13 (4.53%) Business Intelligence Analyst
13 11 (3.83%) Big Data Engineer
13 11 (3.83%) Consultant
13 11 (3.83%) Team Leader
14 10 (3.48%) ETL Analyst
Libraries, Frameworks & Software Standards
1 16 (5.57%) .NET
2 13 (4.53%) PySpark
3 11 (3.83%) MDX
4 10 (3.48%) Kafka
5 7 (2.44%) .NET Framework
5 7 (2.44%) JSON
6 6 (2.09%) ASP.NET
7 4 (1.39%) Gherkin
7 4 (1.39%) pytest
8 3 (1.05%) Middleware
8 3 (1.05%) Oracle GoldenGate
8 3 (1.05%) React
8 3 (1.05%) Vert.x
8 3 (1.05%) WebRTC
8 3 (1.05%) XML
9 2 (0.70%) .NET Core
9 2 (0.70%) AngularJS
9 2 (0.70%) ASP.NET Core
9 2 (0.70%) Entity Framework
9 2 (0.70%) Spark Streaming
Miscellaneous
1 13 (4.53%) Management Information System
2 10 (3.48%) Data Structures
3 8 (2.79%) Cloud Native
3 8 (2.79%) Equities
3 8 (2.79%) Reinsurance
4 7 (2.44%) Legacy Systems
5 6 (2.09%) Derivative
6 5 (1.74%) Analytical Mindset
6 5 (1.74%) Data Centre
6 5 (1.74%) Fixed Income
6 5 (1.74%) Greenfield Project
6 5 (1.74%) Reference Data
7 4 (1.39%) Enterprise Software
7 4 (1.39%) Life Science
8 3 (1.05%) Equity Derivative
8 3 (1.05%) Private Cloud
9 2 (0.70%) Foreign Exchange (FX)
9 2 (0.70%) Public Cloud
9 2 (0.70%) Renewable Energy
9 2 (0.70%) User Experience
Operating Systems
1 23 (8.01%) Windows
2 17 (5.92%) Unix
3 6 (2.09%) Linux
3 6 (2.09%) Red Hat Enterprise Linux
4 4 (1.39%) Windows 10
5 1 (0.35%) VMS
5 1 (0.35%) Windows Server
Processes & Methodologies
1 169 (58.89%) Business Intelligence
2 126 (43.90%) ETL
3 120 (41.81%) Analytics
4 83 (28.92%) Data Modelling
5 69 (24.04%) Agile Software Development
6 44 (15.33%) Data Engineering
7 42 (14.63%) Data Analysis
8 40 (13.94%) Problem-Solving
9 34 (11.85%) DevOps
10 32 (11.15%) Data Architecture
11 29 (10.10%) Data Analytics
11 29 (10.10%) Data Pipeline
12 27 (9.41%) Visualisation
13 24 (8.36%) Data Strategy
14 23 (8.01%) Data Governance
15 22 (7.67%) Data Transformation
16 21 (7.32%) ETL Development
17 20 (6.97%) Dashboard Development
17 20 (6.97%) Data Management
17 20 (6.97%) Kimball Methodology
Programming Languages
1 172 (59.93%) SQL
2 77 (26.83%) Python
3 23 (8.01%) Java
4 20 (6.97%) C#
5 17 (5.92%) Data Analysis Expressions (DAX)
6 16 (5.57%) PowerShell
7 14 (4.88%) T-SQL
8 9 (3.14%) Scala
9 8 (2.79%) R
10 6 (2.09%) JavaScript
11 5 (1.74%) VBA
12 4 (1.39%) C
12 4 (1.39%) Perl
12 4 (1.39%) PL/SQL
12 4 (1.39%) Shell Script
13 3 (1.05%) VB
14 1 (0.35%) Clojure
14 1 (0.35%) PHP
14 1 (0.35%) Ruby
14 1 (0.35%) VB.NET
Qualifications
1 22 (7.67%) Degree
2 6 (2.09%) Computer Science Degree
2 6 (2.09%) ISTQB
2 6 (2.09%) Master's Degree
3 4 (1.39%) ISEB
3 4 (1.39%) ITIL Foundation Certificate
4 3 (1.05%) TOGAF Certification
5 2 (0.70%) ISTQB Advanced Certification
5 2 (0.70%) ISTQB Foundation Certification
6 1 (0.35%) BPSS Clearance
6 1 (0.35%) ITIL Certification
6 1 (0.35%) PhD
6 1 (0.35%) PMP
6 1 (0.35%) SAS Certification
Quality Assurance & Compliance
1 24 (8.36%) QA
2 21 (7.32%) Data Quality
3 1 (0.35%) PMO
3 1 (0.35%) SLA
System Software
1 5 (1.74%) Docker
2 3 (1.05%) Apache Flume
3 1 (0.35%) Active Directory
3 1 (0.35%) Apache ZooKeeper
Systems Management
1 8 (2.79%) Kubernetes
2 5 (1.74%) Terraform
3 4 (1.39%) HP Quality Center
4 2 (0.70%) Microsoft Intune
4 2 (0.70%) Puppet
5 1 (0.35%) Ansible
5 1 (0.35%) Control-M
5 1 (0.35%) Failover Clustering
Vendors
1 69 (24.04%) Microsoft
2 39 (13.59%) Databricks
3 23 (8.01%) Oracle
4 20 (6.97%) Talend
5 12 (4.18%) Informatica
6 9 (3.14%) Alteryx
6 9 (3.14%) Google
7 6 (2.09%) IBM
7 6 (2.09%) Red Hat
7 6 (2.09%) SnapLogic
8 5 (1.74%) Bloomberg
8 5 (1.74%) Sage
8 5 (1.74%) Teradata
9 4 (1.39%) Concur
9 4 (1.39%) Fidessa
9 4 (1.39%) Hyperion
9 4 (1.39%) Netezza
9 4 (1.39%) SAP
9 4 (1.39%) Sitecore
9 4 (1.39%) Sun