Period
to 15 October 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 15 October 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
London > Central London
6 months to
15 Oct 2021
Same period 2020 Same period 2019
Rank 52 75 43
Rank change year-on-year +23 -32 +49
Permanent jobs citing Data Warehouse 348 153 704
As % of all permanent jobs advertised in Central London 5.10% 3.73% 5.52%
As % of the Database & Business Intelligence category 17.33% 13.24% 17.82%
Number of salaries quoted 321 116 627
10th Percentile £51,750 £41,500 £46,109
25th Percentile £61,250 £57,500 £51,250
Median annual salary (50th Percentile) £73,000 £67,500 £62,500
Median % change year-on-year +8.15% +8.00% -3.85%
75th Percentile £91,250 £87,500 £75,000
90th Percentile £108,750 £92,500 £85,000
London median annual salary £70,000 £67,500 £62,500
% change year-on-year +3.70% +8.00% +4.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 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 2,008 1,156 3,950
As % of all permanent IT jobs advertised in Central London 29.45% 28.17% 30.95%
Number of salaries quoted 1,774 982 3,580
10th Percentile £46,250 £42,500 £41,250
25th Percentile £56,250 £52,500 £51,250
Median annual salary (50th Percentile) £72,500 £70,000 £65,000
Median % change year-on-year +3.57% +7.69% -
75th Percentile £93,750 £85,000 £82,500
90th Percentile £107,500 £98,625 £96,250
London median annual salary £70,000 £70,000 £65,000
% change year-on-year - +7.69% +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 15 October 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 15 October 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 +19 303 £72,500 - 74
West End of London -9 7 £70,000 -3.45%
City of Westminster - 2 £58,750 -
Kensington and Chelsea - 1 £64,500 -
Camden - 1 £64,000 -
Data Warehouse
London

For the 6 months to 15 October 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 224 (64.37%) SQL
2 172 (49.43%) Business Intelligence
3 162 (46.55%) ETL
4 149 (42.82%) Analytics
5 138 (39.66%) Azure
6 130 (37.36%) Data Modelling
7 115 (33.05%) Python
8 111 (31.90%) Power Platform
9 110 (31.61%) Data Lake
10 109 (31.32%) Power BI
11 100 (28.74%) Finance
12 91 (26.15%) Agile Software Development
13 85 (24.43%) AWS
14 83 (23.85%) SQL Server Integration Services
14 83 (23.85%) Microsoft
15 69 (19.83%) Data Engineering
16 68 (19.54%) SQL Server
17 61 (17.53%) Big Data
18 58 (16.67%) Social Skills
19 56 (16.09%) SQL Server Reporting Services
20 55 (15.80%) Analytical Skills
21 54 (15.52%) Databricks
22 53 (15.23%) Amazon Redshift
23 49 (14.08%) JIRA
23 49 (14.08%) Azure Data Factory
24 48 (13.79%) Data Management
24 48 (13.79%) Visualisation
25 47 (13.51%) Data Quality
26 46 (13.22%) Data Architecture
26 46 (13.22%) Data Pipeline

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 33 (9.48%) Apache Spark
2 27 (7.76%) Confluence
3 18 (5.17%) Apache
4 15 (4.31%) SharePoint
5 14 (4.02%) Apache Airflow
6 8 (2.30%) SAS
7 4 (1.15%) CMS
7 4 (1.15%) Sitecore CMS
8 3 (0.86%) Apache Pig
9 2 (0.57%) Skype for Business
10 1 (0.29%) Oracle SOA Suite
Applications
1 40 (11.49%) Microsoft Excel
2 3 (0.86%) Microsoft Office
2 3 (0.86%) MS Visio
Business Applications
1 1 (0.29%) Dynamics AX
1 1 (0.29%) Dynamics CRM
Cloud Services
1 138 (39.66%) Azure
2 111 (31.90%) Power Platform
3 85 (24.43%) AWS
4 49 (14.08%) Azure Data Factory
5 42 (12.07%) Snowflake
6 29 (8.33%) GCP
7 25 (7.18%) Amazon S3
8 24 (6.90%) Azure Synapse Analytics
9 16 (4.60%) Amazon EC2
10 15 (4.31%) Serverless
11 14 (4.02%) SaaS
12 12 (3.45%) PowerApps
13 10 (2.87%) Matillion
14 9 (2.59%) AWS CloudFormation
14 9 (2.59%) AWS Step Functions
15 8 (2.30%) Amazon EMR
15 8 (2.30%) AWS Lambda
15 8 (2.30%) Azure Storage
15 8 (2.30%) Microsoft 365
16 6 (1.72%) Azure Functions
Communications & Networking
1 6 (1.72%) Intranet
2 2 (0.57%) Skype
3 1 (0.29%) DNS
3 1 (0.29%) Firewall
3 1 (0.29%) FTP
3 1 (0.29%) Internet
3 1 (0.29%) Network Security
3 1 (0.29%) PuTTY
3 1 (0.29%) Reverse Proxy
3 1 (0.29%) SSH
3 1 (0.29%) WinSCP
Database & Business Intelligence
1 110 (31.61%) Data Lake
2 109 (31.32%) Power BI
3 83 (23.85%) SQL Server Integration Services
4 68 (19.54%) SQL Server
5 61 (17.53%) Big Data
6 56 (16.09%) SQL Server Reporting Services
7 53 (15.23%) Amazon Redshift
8 38 (10.92%) SQL Server Analysis Services
9 36 (10.34%) Tableau
10 35 (10.06%) Azure SQL Database
11 32 (9.20%) Hadoop
11 32 (9.20%) Relational Database
12 25 (7.18%) NoSQL
12 25 (7.18%) PostgreSQL
13 24 (6.90%) Azure SQL Data Warehouse
14 22 (6.32%) Metadata
15 20 (5.75%) Amazon RDS
16 17 (4.89%) MySQL
17 14 (4.02%) Star Schema
18 13 (3.74%) Microsoft Analysis Services
Development Applications
1 49 (14.08%) JIRA
2 22 (6.32%) Git (software)
3 12 (3.45%) ER Studio
3 12 (3.45%) ERwin
3 12 (3.45%) Team Foundation Server
3 12 (3.45%) Visual Studio
4 8 (2.30%) PowerDesigner
5 7 (2.01%) Subversion
6 6 (1.72%) GitLab
6 6 (1.72%) SQL Server Management Studio (SSMS)
7 5 (1.44%) Toad
7 5 (1.44%) TortoiseSVN
8 4 (1.15%) Cucumber
8 4 (1.15%) GDB
8 4 (1.15%) Selenium
8 4 (1.15%) Visual Studio Code
9 3 (0.86%) Jenkins
10 2 (0.57%) Octopus Deploy
11 1 (0.29%) Oracle APEX
11 1 (0.29%) TeamCity
General
1 100 (28.74%) Finance
2 58 (16.67%) Social Skills
3 55 (15.80%) Analytical Skills
4 24 (6.90%) Advertising
5 15 (4.31%) Banking
6 11 (3.16%) Investment Banking
6 11 (3.16%) Law
7 9 (2.59%) Public Sector
8 8 (2.30%) Retail
9 6 (1.72%) Back Office
9 6 (1.72%) Presentation Skills
10 5 (1.44%) French Language
10 5 (1.44%) Front Office
10 5 (1.44%) Legal
11 3 (0.86%) Influencing Skills
11 3 (0.86%) Organisational Skills
12 1 (0.29%) Corporate Banking
12 1 (0.29%) Documentation Skills
12 1 (0.29%) International Banking
12 1 (0.29%) Spanish Language
Job Titles
1 102 (29.31%) Data Engineer
2 57 (16.38%) Analyst
3 56 (16.09%) Architect
4 51 (14.66%) Developer
5 38 (10.92%) Data Architect
6 34 (9.77%) Business Intelligence Developer
7 25 (7.18%) Data Analyst
8 23 (6.61%) Senior Data Engineer
9 21 (6.03%) SQL Analyst
10 20 (5.75%) SSIS Analyst
11 19 (5.46%) Solutions Architect
11 19 (5.46%) Technical Analyst
12 18 (5.17%) ETL Analyst
12 18 (5.17%) Excel Analyst
13 17 (4.89%) AWS Engineer
13 17 (4.89%) Consultant
14 16 (4.60%) Business Intelligence Analyst
14 16 (4.60%) SQL Data Analyst
15 15 (4.31%) Applications Support
16 13 (3.74%) Azure Engineer
Libraries, Frameworks & Software Standards
1 23 (6.61%) PySpark
2 18 (5.17%) .NET
3 15 (4.31%) Kafka
4 11 (3.16%) MDX
5 9 (2.59%) Web Services
6 8 (2.30%) JSON
7 7 (2.01%) .NET Framework
7 7 (2.01%) ASP.NET
8 5 (1.44%) .NET Core
8 5 (1.44%) ASP.NET Core
8 5 (1.44%) Entity Framework
8 5 (1.44%) React
9 4 (1.15%) Gherkin
9 4 (1.15%) Middleware
9 4 (1.15%) pytest
9 4 (1.15%) XML
10 3 (0.86%) ADO.NET
10 3 (0.86%) Dapper ORM
10 3 (0.86%) NHibernate
10 3 (0.86%) Vue.js
Miscellaneous
1 12 (3.45%) Self-Motivation
2 11 (3.16%) User Experience
3 9 (2.59%) Analytical Mindset
3 9 (2.59%) Data Structures
4 8 (2.30%) Virtual Team
5 6 (1.72%) Equities
6 5 (1.44%) Cloud Native
6 5 (1.44%) Derivative
6 5 (1.44%) Legacy Systems
6 5 (1.44%) Reinsurance
7 4 (1.15%) Enterprise Software
7 4 (1.15%) Management Information System
7 4 (1.15%) Reference Data
8 3 (0.86%) Data Centre
8 3 (0.86%) Foreign Exchange (FX)
8 3 (0.86%) Greenfield Project
9 2 (0.57%) Equity Derivative
9 2 (0.57%) Private Cloud
9 2 (0.57%) Public Cloud
9 2 (0.57%) Renewable Energy
Operating Systems
1 20 (5.75%) Unix
2 15 (4.31%) Windows
3 4 (1.15%) Windows 10
4 3 (0.86%) Linux
5 2 (0.57%) Red Hat Enterprise Linux
6 1 (0.29%) VMS
6 1 (0.29%) Windows Server
Processes & Methodologies
1 172 (49.43%) Business Intelligence
2 162 (46.55%) ETL
3 149 (42.82%) Analytics
4 130 (37.36%) Data Modelling
5 91 (26.15%) Agile Software Development
6 69 (19.83%) Data Engineering
7 48 (13.79%) Data Management
7 48 (13.79%) Visualisation
8 46 (13.22%) Data Architecture
8 46 (13.22%) Data Pipeline
9 40 (11.49%) DevOps
10 39 (11.21%) Data Analysis
10 39 (11.21%) Problem-Solving
11 35 (10.06%) Kimball Methodology
12 34 (9.77%) Stakeholder Management
13 33 (9.48%) Data Integration
14 32 (9.20%) Data Science
15 30 (8.62%) Requirements Gathering
16 29 (8.33%) Data Analytics
17 28 (8.05%) Scrum
Programming Languages
1 224 (64.37%) SQL
2 115 (33.05%) Python
3 38 (10.92%) C#
4 36 (10.34%) Java
5 24 (6.90%) T-SQL
6 19 (5.46%) Scala
7 18 (5.17%) PowerShell
8 17 (4.89%) PL/SQL
9 16 (4.60%) Data Analysis Expressions (DAX)
9 16 (4.60%) R
10 10 (2.87%) JavaScript
11 6 (1.72%) ANSI SQL
11 6 (1.72%) VBA
12 5 (1.44%) Shell Script
13 4 (1.15%) HiveQL
14 3 (0.86%) C
14 3 (0.86%) VB
15 2 (0.57%) PHP
16 1 (0.29%) Perl
16 1 (0.29%) VB.NET
Qualifications
1 31 (8.91%) Degree
2 8 (2.30%) Master's Degree
3 7 (2.01%) Computer Science Degree
4 6 (1.72%) ISTQB
5 5 (1.44%) SC Cleared
5 5 (1.44%) Security Cleared
6 4 (1.15%) BPSS Clearance
6 4 (1.15%) ISEB
7 3 (0.86%) SAS Certification
7 3 (0.86%) TOGAF Certification
8 2 (0.57%) ISTQB Advanced Certification
8 2 (0.57%) ISTQB Foundation Certification
8 2 (0.57%) ITIL Certification
8 2 (0.57%) PhD
9 1 (0.29%) IBM Certification
9 1 (0.29%) ITIL Foundation Certificate
9 1 (0.29%) Microsoft Certification
9 1 (0.29%) PMP
9 1 (0.29%) Tableau Certification
Quality Assurance & Compliance
1 47 (13.51%) Data Quality
2 33 (9.48%) QA
3 3 (0.86%) Solvency II
4 1 (0.29%) GDPR
4 1 (0.29%) ISO/IEC 27001
4 1 (0.29%) PMO
4 1 (0.29%) SLA
System Software
1 7 (2.01%) Docker
2 4 (1.15%) HDFS
3 2 (0.57%) Apache Flume
4 1 (0.29%) Active Directory
Systems Management
1 9 (2.59%) Kubernetes
1 9 (2.59%) Terraform
2 4 (1.15%) HP Quality Center
3 3 (0.86%) Control-M
4 2 (0.57%) Ansible
4 2 (0.57%) Microsoft Intune
4 2 (0.57%) Puppet
Vendors
1 83 (23.85%) Microsoft
2 54 (15.52%) Databricks
3 37 (10.63%) Informatica
4 33 (9.48%) Talend
5 32 (9.20%) Oracle
6 16 (4.60%) IBM
7 13 (3.74%) Google
7 13 (3.74%) SAP
8 11 (3.16%) Alteryx
9 8 (2.30%) Salesforce.com
10 7 (2.01%) SnapLogic
11 6 (1.72%) Concur
12 4 (1.15%) Aderant
12 4 (1.15%) Bloomberg
12 4 (1.15%) Fidessa
12 4 (1.15%) Netezza
12 4 (1.15%) Sage
12 4 (1.15%) Sitecore
12 4 (1.15%) Sun
12 4 (1.15%) Teradata