Period
to 23 January 2022

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Data Lake skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Lake over the 6 months to 23 January 2022 with a comparison to the same period in the previous 2 years.

Data Lakes
Central London > City of London
6 months to
23 Jan 2022
Same period 2021 Same period 2020
Rank 154 127 263
Rank change year-on-year -27 +136 +8
Permanent jobs citing Data Lake 98 97 56
As % of all permanent jobs advertised in the City of London 1.60% 2.25% 0.61%
As % of the Database & Business Intelligence category 5.64% 7.43% 2.24%
Number of salaries quoted 88 88 47
10th Percentile £58,375 £58,225 £43,500
25th Percentile £68,750 £71,250 £58,750
Median annual salary (50th Percentile) £78,750 £87,500 £72,500
Median % change year-on-year -10.00% +20.69% +3.57%
75th Percentile £106,563 £105,000 £87,500
90th Percentile £120,000 £111,250 £91,250
Central London median annual salary £77,500 £87,500 £71,250
% change year-on-year -11.43% +22.81% -1.72%

Data Lake 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,738 1,306 2,504
As % of all permanent IT jobs advertised in the City of London 28.33% 30.36% 27.32%
Number of salaries quoted 1,552 1,109 2,214
10th Percentile £45,125 £45,000 £42,000
25th Percentile £56,250 £56,250 £52,500
Median annual salary (50th Percentile) £72,500 £72,500 £67,500
Median % change year-on-year - +7.41% +3.85%
75th Percentile £92,500 £87,500 £83,750
90th Percentile £108,750 £103,750 £102,500
Central London median annual salary £70,000 £70,000 £67,500
% change year-on-year - +3.70% +3.85%

Data Lake
Job Vacancy Trend in the City of London

Job postings citing Data Lake as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for Data Lake in the City of London

Data Lake
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing Data Lake in the City of London.

Salary trend for Data Lake in the City of London

Data Lake
Salary Histogram in the City of London

Salary distribution for jobs citing Data Lake in the City of London over the 6 months to 23 January 2022.

Salary histogram for Data Lake in the City of London

For the 6 months to 23 January 2022, IT jobs citing Data Lake 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 Lake.

1 62 (63.27%) SQL
1 62 (63.27%) Data Warehouse
2 61 (62.24%) Azure
3 46 (46.94%) Business Intelligence
4 45 (45.92%) Analytics
5 36 (36.73%) Finance
5 36 (36.73%) ETL
6 35 (35.71%) Python
7 34 (34.69%) Databricks
8 33 (33.67%) Data Modelling
9 31 (31.63%) Azure Data Factory
9 31 (31.63%) Big Data
10 29 (29.59%) AWS
11 26 (26.53%) CI/CD
12 24 (24.49%) Power Platform
12 24 (24.49%) Power BI
12 24 (24.49%) DevOps
13 23 (23.47%) Data Engineering
13 23 (23.47%) Data Science
14 20 (20.41%) Data Pipeline
14 20 (20.41%) Microsoft
15 19 (19.39%) Agile Software Development
15 19 (19.39%) Hadoop
15 19 (19.39%) Machine Learning
15 19 (19.39%) Metadata
16 18 (18.37%) Data Strategy
17 17 (17.35%) Social Skills
17 17 (17.35%) Azure Synapse Analytics
17 17 (17.35%) Apache Spark
18 16 (16.33%) Azure SQL Database

Data Lake
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 17 (17.35%) Apache Spark
2 10 (10.20%) Confluence
3 8 (8.16%) SAS
4 7 (7.14%) Elasticsearch
5 4 (4.08%) Apache Airflow
Applications
1 1 (1.02%) Microsoft Excel
Business Applications
1 1 (1.02%) Sparx Enterprise Architect
Cloud Services
1 61 (62.24%) Azure
2 31 (31.63%) Azure Data Factory
3 29 (29.59%) AWS
4 24 (24.49%) Power Platform
5 17 (17.35%) Azure Synapse Analytics
6 13 (13.27%) GCP
7 10 (10.20%) Azure Cosmos DB
8 9 (9.18%) Snowflake
9 7 (7.14%) PaaS
9 7 (7.14%) Serverless
10 6 (6.12%) Azure Monitor
10 6 (6.12%) SaaS
11 5 (5.10%) Azure Machine Learning
12 4 (4.08%) Azure Data Lake Analytics
13 3 (3.06%) Azure Active Directory
13 3 (3.06%) Azure Event Grid
13 3 (3.06%) IaaS
14 2 (2.04%) Azure Logic Apps
15 1 (1.02%) Amazon ECS
15 1 (1.02%) AWS Step Functions
Communications & Networking
1 3 (3.06%) Network Security
2 1 (1.02%) tcpdump
2 1 (1.02%) Wireshark
Database & Business Intelligence
1 62 (63.27%) Data Warehouse
2 31 (31.63%) Big Data
3 24 (24.49%) Power BI
4 19 (19.39%) Hadoop
4 19 (19.39%) Metadata
5 16 (16.33%) Azure SQL Database
6 15 (15.31%) NoSQL
7 11 (11.22%) Relational Database
8 10 (10.20%) SQL Server
9 9 (9.18%) PostgreSQL
10 8 (8.16%) Amazon Redshift
11 7 (7.14%) Amazon Aurora
11 7 (7.14%) Apache Cassandra
11 7 (7.14%) Data Mart
11 7 (7.14%) MySQL
11 7 (7.14%) OLTP
11 7 (7.14%) RDBMS
11 7 (7.14%) SAS Enterprise Guide
12 6 (6.12%) Snowflake Schema
12 6 (6.12%) Star Schema
Development Applications
1 13 (13.27%) Git (software)
2 10 (10.20%) JIRA
2 10 (10.20%) Team Foundation Server
3 7 (7.14%) ER Studio
3 7 (7.14%) ERwin
3 7 (7.14%) PowerDesigner
4 1 (1.02%) Bitbucket
General
1 36 (36.73%) Finance
2 17 (17.35%) Social Skills
3 11 (11.22%) Advertising
4 7 (7.14%) Law
5 6 (6.12%) Analytical Skills
6 4 (4.08%) Front Office
7 3 (3.06%) Public Sector
8 2 (2.04%) Banking
8 2 (2.04%) Influencing Skills
8 2 (2.04%) Retail
9 1 (1.02%) Investment Banking
9 1 (1.02%) Marketing
9 1 (1.02%) Presentation Skills
Job Titles
1 32 (32.65%) Data Engineer
2 31 (31.63%) Architect
3 19 (19.39%) Data Architect
4 14 (14.29%) Senior Data Engineer
5 10 (10.20%) Automation Engineer
5 10 (10.20%) Azure Engineer
5 10 (10.20%) Lead Architect
5 10 (10.20%) QA Automation Engineer
5 10 (10.20%) QA Engineer
6 7 (7.14%) Data Modeller
6 7 (7.14%) Developer
6 7 (7.14%) Lead Data Architect
6 7 (7.14%) Solutions Architect
7 6 (6.12%) Azure Architect
8 5 (5.10%) Consultant
8 5 (5.10%) Enterprise Architect
9 4 (4.08%) Analyst Developer
9 4 (4.08%) Business Intelligence Analyst
9 4 (4.08%) Senior Analyst
9 4 (4.08%) Senior Analyst Developer
Libraries, Frameworks & Software Standards
1 15 (15.31%) PySpark
2 12 (12.24%) Kafka
3 7 (7.14%) .NET
4 6 (6.12%) Web Services
5 5 (5.10%) React
6 3 (3.06%) .NET Core
6 3 (3.06%) ADO.NET
6 3 (3.06%) ARM Templates
6 3 (3.06%) ASP.NET Core
6 3 (3.06%) Dapper ORM
6 3 (3.06%) Entity Framework
6 3 (3.06%) MDX
6 3 (3.06%) Middleware
6 3 (3.06%) NHibernate
6 3 (3.06%) Vue.js
7 1 (1.02%) Elastic Stack
7 1 (1.02%) Ruby on Rails
7 1 (1.02%) Serverless Framework
7 1 (1.02%) Vert.x
7 1 (1.02%) XGBoost
Miscellaneous
1 10 (10.20%) Self-Motivation
2 5 (5.10%) Algorithms
2 5 (5.10%) Replication
3 4 (4.08%) Enterprise Software
3 4 (4.08%) User Experience
4 2 (2.04%) Data Centre
4 2 (2.04%) Data Structures
4 2 (2.04%) Management Information System
4 2 (2.04%) Private Cloud
4 2 (2.04%) Reinsurance
5 1 (1.02%) Greenfield Project
5 1 (1.02%) Hybrid Cloud
5 1 (1.02%) Marketing Technology
5 1 (1.02%) Mobile App
5 1 (1.02%) NHS
Operating Systems
1 4 (4.08%) Linux
2 3 (3.06%) Unix
3 1 (1.02%) Android
3 1 (1.02%) Apple iOS
Processes & Methodologies
1 46 (46.94%) Business Intelligence
2 45 (45.92%) Analytics
3 36 (36.73%) ETL
4 33 (33.67%) Data Modelling
5 26 (26.53%) CI/CD
6 24 (24.49%) DevOps
7 23 (23.47%) Data Engineering
7 23 (23.47%) Data Science
8 20 (20.41%) Data Pipeline
9 19 (19.39%) Agile Software Development
9 19 (19.39%) Machine Learning
10 18 (18.37%) Data Strategy
11 15 (15.31%) Computer Science
11 15 (15.31%) Data Integration
12 14 (14.29%) Data Architecture
13 13 (13.27%) Test Automation
14 12 (12.24%) Data Analytics
14 12 (12.24%) Visualisation
15 11 (11.22%) Data Management
15 11 (11.22%) Data Visualisation
Programming Languages
1 62 (63.27%) SQL
2 35 (35.71%) Python
3 15 (15.31%) Java
4 14 (14.29%) C#
5 11 (11.22%) Data Analysis Expressions (DAX)
6 8 (8.16%) Scala
6 8 (8.16%) T-SQL
7 7 (7.14%) PowerShell
8 5 (5.10%) JavaScript
9 4 (4.08%) U-SQL
10 3 (3.06%) PHP
11 2 (2.04%) R
12 1 (1.02%) C
12 1 (1.02%) Ruby
12 1 (1.02%) VBA
Qualifications
1 7 (7.14%) Degree
2 4 (4.08%) Microsoft Certification
3 2 (2.04%) Computer Science Degree
4 1 (1.02%) IBM Certification
4 1 (1.02%) Master's Degree
4 1 (1.02%) PhD
Quality Assurance & Compliance
1 10 (10.20%) QA
2 9 (9.18%) Data Quality
3 5 (5.10%) GDPR
System Software
1 3 (3.06%) Active Directory
1 3 (3.06%) Virtual Desktop
2 1 (1.02%) Docker
Systems Management
1 7 (7.14%) Kubernetes
2 5 (5.10%) Terraform
3 3 (3.06%) Grafana
3 3 (3.06%) Istio
3 3 (3.06%) Prometheus
Vendors
1 34 (34.69%) Databricks
2 20 (20.41%) Microsoft
3 9 (9.18%) Oracle
4 5 (5.10%) Salesforce.com
5 4 (4.08%) IBM
6 2 (2.04%) Google
6 2 (2.04%) Talend
7 1 (1.02%) Cloudera
7 1 (1.02%) Cognizant
7 1 (1.02%) Dell
7 1 (1.02%) Informatica
7 1 (1.02%) Palantir
7 1 (1.02%) SAP
7 1 (1.02%) Sparx