Period
to 17 October 2019

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

Data Lakes
Central London > City of London
6 months to
17 Oct 2019
Same period 2018 Same period 2017
Rank 212 241 298
Rank change year-on-year +29 +57 +47
Permanent jobs citing Data Lake 122 108 28
As % of all permanent IT jobs advertised in the City of London 1.22% 0.98% 0.28%
As % of the Database & Business Intelligence category 3.99% 3.19% 0.90%
Number of salaries quoted 109 101 24
City of London median annual salary £77,500 £65,000 £73,750
Median salary % change year-on-year +19.23% -11.86% -18.06%
10th Percentile £43,750 £50,000 £52,500
90th Percentile £105,500 £101,250 £116,250
Central London median annual salary £75,000 £65,000 £75,000
% change year-on-year +15.38% -13.33% -16.67%

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 3,061 3,385 3,116
As % of all permanent IT jobs advertised in the City of London 30.49% 30.59% 31.34%
Number of salaries quoted 2,750 3,074 2,841
City of London median annual salary £67,500 £65,000 £60,000
Median salary % change year-on-year +3.85% +8.33% +4.35%
10th Percentile £43,625 £40,000 £40,000
90th Percentile £98,750 £95,000 £87,500
Central London median annual salary £65,000 £65,000 £60,000
% change year-on-year - +8.33% +9.09%

Data Lake
Job Vacancy Trend in the City of London

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

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

The salary distribution of IT jobs citing Data Lake in the City of London over the 6 months to 17 October 2019.

Salary histogram for Data Lake in the City of London

Data Lake
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 Lake within the City of London region over the 6 months to 17 October 2019. 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 - 3 - -
Data Lake
Central London

For the 6 months to 17 October 2019, 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 92 (75.41%) Azure
2 90 (73.77%) Data Warehouse
3 88 (72.13%) Business Intelligence
4 79 (64.75%) SQL
5 75 (61.48%) Microsoft
6 74 (60.66%) Analytics
7 73 (59.84%) SQL Server
7 73 (59.84%) Finance
8 69 (56.56%) Agile Software Development
9 67 (54.92%) Power BI
9 67 (54.92%) Power Platform
10 65 (53.28%) Python
11 63 (51.64%) Azure Data Factory
12 62 (50.82%) SQL Server Integration Services
13 60 (49.18%) SQL Server Reporting Services
13 60 (49.18%) SQL Server Analysis Services
14 59 (48.36%) Data Modelling
15 50 (40.98%) Data Analytics
16 48 (39.34%) Azure SQL Database
17 46 (37.70%) Data Analysis Expressions (DAX)
17 46 (37.70%) Kimball Methodology
17 46 (37.70%) Databricks
18 44 (36.07%) DevOps
19 43 (35.25%) ETL
20 42 (34.43%) Microsoft Analysis Services
21 41 (33.61%) MDX
21 41 (33.61%) Scrum
22 37 (30.33%) Problem-Solving
23 34 (27.87%) Kanban
24 26 (21.31%) Data Ingestion

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 5 (4.10%) Apache Spark
2 2 (1.64%) Apache Pig
3 1 (0.82%) Apache Solr
3 1 (0.82%) Elasticsearch
3 1 (0.82%) SAS
Applications
1 5 (4.10%) Microsoft Excel
Business Applications
1 2 (1.64%) Markit EDM
Cloud Services
1 92 (75.41%) Azure
2 67 (54.92%) Power Platform
3 63 (51.64%) Azure Data Factory
4 16 (13.11%) AWS
5 7 (5.74%) GCP
6 5 (4.10%) Data Lake Analytics
7 3 (2.46%) PaaS
8 2 (1.64%) Apigee
8 2 (1.64%) Azure Active Directory
8 2 (1.64%) npm
8 2 (1.64%) Serverless
9 1 (0.82%) Amazon Kinesis
9 1 (0.82%) Amazon S3
9 1 (0.82%) Azure Machine Learning
9 1 (0.82%) GitHub
9 1 (0.82%) OpenShift
Communications & Networking
1 1 (0.82%) Broadband
Database & Business Intelligence
1 90 (73.77%) Data Warehouse
2 73 (59.84%) SQL Server
3 67 (54.92%) Power BI
4 62 (50.82%) SQL Server Integration Services
5 60 (49.18%) SQL Server Analysis Services
5 60 (49.18%) SQL Server Reporting Services
6 48 (39.34%) Azure SQL Database
7 42 (34.43%) Microsoft Analysis Services
8 25 (20.49%) Big Data
9 12 (9.84%) Hadoop
10 10 (8.20%) Azure SQL Data Warehouse
10 10 (8.20%) NoSQL
11 8 (6.56%) OLTP
12 7 (5.74%) Amazon Redshift
12 7 (5.74%) Cosmos DB
13 6 (4.92%) PostgreSQL
14 4 (3.28%) Apache Hive
14 4 (3.28%) MS Access
14 4 (3.28%) MySQL
14 4 (3.28%) Snowflake Schema
Development Applications
1 5 (4.10%) ER Studio
1 5 (4.10%) ERwin
1 5 (4.10%) PowerDesigner
2 4 (3.28%) Git (software)
2 4 (3.28%) JIRA
3 3 (2.46%) Hudson
3 3 (2.46%) Jenkins
4 2 (1.64%) Cucumber
4 2 (1.64%) Mocha
4 2 (1.64%) NUnit
4 2 (1.64%) Selenium
4 2 (1.64%) Spock
4 2 (1.64%) SQL Server Management Studio (SSMS)
4 2 (1.64%) Subversion
5 1 (0.82%) JUnit
5 1 (0.82%) Maven
General
1 73 (59.84%) Finance
2 8 (6.56%) Banking
3 7 (5.74%) Advertising
4 5 (4.10%) Retail
5 4 (3.28%) Marketing
6 1 (0.82%) Investment Banking
6 1 (0.82%) Public Sector
Job Titles
1 58 (47.54%) Developer
2 43 (35.25%) Business Intelligence Developer
3 31 (25.41%) Azure Developer
4 29 (23.77%) SQL BI Developer
4 29 (23.77%) SQL Developer
5 26 (21.31%) Database Developer
5 26 (21.31%) SQL Database Developer
6 20 (16.39%) Business Intelligence Lead
7 19 (15.57%) Architect
7 19 (15.57%) Lead Developer
8 14 (11.48%) Azure Specialist
8 14 (11.48%) Business Intelligence Specialist
8 14 (11.48%) Senior Architect
9 12 (9.84%) Enterprise Architect
9 12 (9.84%) Senior Enterprise Architect
10 9 (7.38%) Cloud Architect
10 9 (7.38%) Data Warehouse Developer
10 9 (7.38%) Senior Cloud Architect
11 8 (6.56%) Analyst
11 8 (6.56%) Data Engineer
Libraries, Frameworks & Software Standards
1 41 (33.61%) MDX
2 4 (3.28%) JSON
2 4 (3.28%) Web Services
3 3 (2.46%) AngularJS
3 3 (2.46%) Ruby on Rails
4 2 (1.64%) .NET
4 2 (1.64%) .NET Core
4 2 (1.64%) .NET Framework
4 2 (1.64%) ASP.NET Web API
4 2 (1.64%) CSS
4 2 (1.64%) Entity Framework
4 2 (1.64%) HTML
4 2 (1.64%) Kafka
4 2 (1.64%) Natural Language Processing
4 2 (1.64%) REST
4 2 (1.64%) RESTful
4 2 (1.64%) Spring
5 1 (0.82%) ASP.NET
5 1 (0.82%) ASP.NET MVC
5 1 (0.82%) HTML5
Miscellaneous
1 16 (13.11%) Management Information System
2 9 (7.38%) Analytical Skills
3 2 (1.64%) Derivative
3 2 (1.64%) Equities
3 2 (1.64%) Fixed Income
3 2 (1.64%) Greenfield Project
3 2 (1.64%) OTC Derivatives
4 1 (0.82%) Algorithms
4 1 (0.82%) Analytical Mindset
4 1 (0.82%) Data Centre
4 1 (0.82%) Reinsurance
4 1 (0.82%) User Experience
Operating Systems
1 6 (4.92%) Unix
1 6 (4.92%) Windows
2 2 (1.64%) Linux
2 2 (1.64%) Windows Server
3 1 (0.82%) Red Hat Enterprise Linux
Processes & Methodologies
1 88 (72.13%) Business Intelligence
2 74 (60.66%) Analytics
3 69 (56.56%) Agile Software Development
4 59 (48.36%) Data Modelling
5 50 (40.98%) Data Analytics
6 46 (37.70%) Kimball Methodology
7 44 (36.07%) DevOps
8 43 (35.25%) ETL
9 41 (33.61%) Scrum
10 37 (30.33%) Problem-Solving
11 34 (27.87%) Kanban
12 26 (21.31%) Data Ingestion
13 22 (18.03%) Data Strategy
14 17 (13.93%) Data Architecture
15 15 (12.30%) Migration
16 14 (11.48%) Enterprise Architecture
17 13 (10.66%) Data Integration
17 13 (10.66%) Decision-Making
18 12 (9.84%) Business Process Modelling
18 12 (9.84%) IT Strategy
Programming Languages
1 79 (64.75%) SQL
2 65 (53.28%) Python
3 46 (37.70%) Data Analysis Expressions (DAX)
4 16 (13.11%) R
5 15 (12.30%) C#
6 11 (9.02%) T-SQL
7 6 (4.92%) Java
8 4 (3.28%) Ruby
9 3 (2.46%) JavaScript
9 3 (2.46%) PowerShell
10 2 (1.64%) Bash Shell
10 2 (1.64%) C++
10 2 (1.64%) Java 8
10 2 (1.64%) PL/SQL
11 1 (0.82%) MATLAB
11 1 (0.82%) Perl
11 1 (0.82%) Scala
11 1 (0.82%) VBScript
Qualifications
1 12 (9.84%) TOGAF Certification
2 7 (5.74%) Degree
3 1 (0.82%) APMP
3 1 (0.82%) ITIL Certification
3 1 (0.82%) Microsoft Certification
Quality Assurance & Compliance
1 9 (7.38%) QA
2 6 (4.92%) Data Quality
System Software
1 6 (4.92%) Docker
2 2 (1.64%) Active Directory
2 2 (1.64%) Apache Flume
2 2 (1.64%) Hyper-V
2 2 (1.64%) Virtual Machines
2 2 (1.64%) XenApp
3 1 (0.82%) Apache ZooKeeper
3 1 (0.82%) HDFS
Systems Management
1 6 (4.92%) Kubernetes
2 2 (1.64%) Oozie
3 1 (0.82%) Ansible
3 1 (0.82%) Docker Swarm
3 1 (0.82%) Hadoop YARN
Vendors
1 75 (61.48%) Microsoft
2 46 (37.70%) Databricks
3 4 (3.28%) Cloudera
3 4 (3.28%) Google
3 4 (3.28%) MuleSoft
3 4 (3.28%) Tableau
4 3 (2.46%) Alteryx
4 3 (2.46%) Atlassian
5 2 (1.64%) Citrix
5 2 (1.64%) Informatica
5 2 (1.64%) Netezza
5 2 (1.64%) Oracle
5 2 (1.64%) VMware
6 1 (0.82%) Hortonworks
6 1 (0.82%) MapR
6 1 (0.82%) Red Hat