Period
to 27 October 2021

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

Data Modelling
Central London > City of London
6 months to
27 Oct 2021
Same period 2020 Same period 2019
Rank 59 81 102
Rank change year-on-year +22 +21 +70
Permanent jobs citing Data Modelling 280 128 310
As % of all permanent jobs advertised in the City of London 4.66% 3.50% 3.11%
As % of the Processes & Methodologies category 4.94% 3.71% 3.32%
Number of salaries quoted 257 95 273
10th Percentile £51,150 £46,350 £45,250
25th Percentile £56,250 £56,250 £52,500
Median annual salary (50th Percentile) £72,500 £72,500 £65,000
Median % change year-on-year - +11.54% -
75th Percentile £90,000 £91,250 £82,500
90th Percentile £106,250 £98,750 £87,500
Central London median annual salary £70,000 £72,500 £65,000
% change year-on-year -3.45% +11.54% -

Data Modelling is in the Processes and Methodologies 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 process or methodology skills.

All Process and Methodology Skills
City of London
Permanent vacancies with a requirement for process or methodology skills 5,666 3,447 9,348
As % of all permanent IT jobs advertised in the City of London 94.32% 94.28% 93.92%
Number of salaries quoted 5,055 3,038 8,226
10th Percentile £43,100 £45,000 £38,250
25th Percentile £55,000 £55,000 £51,250
Median annual salary (50th Percentile) £72,500 £70,000 £67,500
Median % change year-on-year +3.57% +3.70% +3.85%
75th Percentile £91,250 £85,000 £82,500
90th Percentile £107,500 £100,000 £97,500
Central London median annual salary £70,000 £70,000 £65,000
% change year-on-year - +7.69% +4.00%

Data Modelling
Job Vacancy Trend in the City of London

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

Job vacancy trend for Data Modelling in the City of London

Data Modelling
Salary Trend in the City of London

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

Salary trend for Data Modelling in the City of London

Data Modelling
Salary Histogram in the City of London

Salary distribution for jobs citing Data Modelling in the City of London over the 6 months to 27 October 2021.

Salary histogram for Data Modelling in the City of London

For the 6 months to 27 October 2021, IT jobs citing Data Modelling 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 Modelling.

1 156 (55.71%) SQL
2 126 (45.00%) Analytics
3 117 (41.79%) Business Intelligence
4 112 (40.00%) Data Warehouse
5 103 (36.79%) ETL
6 96 (34.29%) Azure
7 89 (31.79%) Python
8 84 (30.00%) AWS
9 78 (27.86%) Finance
10 70 (25.00%) Power Platform
11 69 (24.64%) Power BI
12 65 (23.21%) Data Analysis
13 64 (22.86%) Data Quality
14 61 (21.79%) Agile Software Development
15 60 (21.43%) Data Architecture
16 47 (16.79%) Microsoft
17 46 (16.43%) Visualisation
18 45 (16.07%) Data Lake
19 44 (15.71%) Data Engineering
20 42 (15.00%) Big Data
20 42 (15.00%) Data Management
21 40 (14.29%) Migration
21 40 (14.29%) Data Strategy
22 38 (13.57%) Tableau
23 37 (13.21%) Looker
23 37 (13.21%) Analytical Skills
24 36 (12.86%) Data Governance
25 35 (12.50%) Social Skills
26 34 (12.14%) Data Pipeline
26 34 (12.14%) Degree

Data Modelling
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 27 (9.64%) Apache Spark
2 13 (4.64%) Apache Airflow
3 10 (3.57%) SAS
4 8 (2.86%) Elasticsearch
5 6 (2.14%) Apache
5 6 (2.14%) SharePoint
6 4 (1.43%) Appian
7 3 (1.07%) Confluence
8 2 (0.71%) Apache Pig
9 1 (0.36%) Oracle SOA Suite
9 1 (0.36%) Oracle Workflow
9 1 (0.36%) SugarCRM
Applications
1 27 (9.64%) Microsoft Excel
2 4 (1.43%) Microsoft Office
3 3 (1.07%) MS Visio
Business Applications
1 1 (0.36%) Elite 3E
1 1 (0.36%) IBM Planning Analytics
1 1 (0.36%) Oracle EBS
1 1 (0.36%) Oracle EBS R12
1 1 (0.36%) Relativity
1 1 (0.36%) SAP BPC
1 1 (0.36%) SAP ERP
1 1 (0.36%) SAP Retail
Cloud Services
1 96 (34.29%) Azure
2 84 (30.00%) AWS
3 70 (25.00%) Power Platform
4 25 (8.93%) Snowflake
5 22 (7.86%) GCP
6 17 (6.07%) Azure Data Factory
7 16 (5.71%) Amazon S3
8 14 (5.00%) Azure Synapse Analytics
9 12 (4.29%) dbt
10 6 (2.14%) AWS CloudFormation
10 6 (2.14%) Collibra
10 6 (2.14%) Matillion
10 6 (2.14%) SaaS
10 6 (2.14%) Serverless
11 5 (1.79%) AWS Step Functions
11 5 (1.79%) GitHub
12 4 (1.43%) Amazon EC2
12 4 (1.43%) AWS Lambda
12 4 (1.43%) Azure Cosmos DB
13 3 (1.07%) Amazon SQS
Communications & Networking
1 6 (2.14%) Intranet
2 2 (0.71%) AMQP
3 1 (0.36%) FTP
3 1 (0.36%) PuTTY
3 1 (0.36%) WinSCP
Database & Business Intelligence
1 112 (40.00%) Data Warehouse
2 69 (24.64%) Power BI
3 45 (16.07%) Data Lake
4 42 (15.00%) Big Data
5 38 (13.57%) Tableau
6 37 (13.21%) Looker
7 30 (10.71%) Amazon Redshift
8 29 (10.36%) Metadata
9 23 (8.21%) Hadoop
9 23 (8.21%) SQL Server Integration Services
10 22 (7.86%) SQL Server
10 22 (7.86%) SQL Server Reporting Services
11 21 (7.50%) MySQL
12 18 (6.43%) PostgreSQL
12 18 (6.43%) SQL Server Analysis Services
13 16 (5.71%) NoSQL
14 12 (4.29%) Apache Hive
14 12 (4.29%) MongoDB
14 12 (4.29%) Relational Database
14 12 (4.29%) Star Schema
Development Applications
1 14 (5.00%) Git (software)
2 10 (3.57%) ERwin
3 9 (3.21%) ER Studio
3 9 (3.21%) JIRA
4 8 (2.86%) Team Foundation Server
5 7 (2.50%) PowerDesigner
5 7 (2.50%) Subversion
6 6 (2.14%) Toad
7 5 (1.79%) TortoiseSVN
8 4 (1.43%) Jenkins
9 3 (1.07%) GitLab
9 3 (1.07%) Visual Studio
10 2 (0.71%) Atlassian Bamboo
10 2 (0.71%) NUnit
10 2 (0.71%) TeamCity
11 1 (0.36%) GDB
11 1 (0.36%) Sourcetree
11 1 (0.36%) SQL Server Management Studio (SSMS)
11 1 (0.36%) Visual Studio Code
11 1 (0.36%) Visual Studio Tools for Office
General
1 78 (27.86%) Finance
2 37 (13.21%) Analytical Skills
3 35 (12.50%) Social Skills
4 22 (7.86%) Advertising
4 22 (7.86%) Banking
5 16 (5.71%) Public Sector
6 15 (5.36%) Law
7 12 (4.29%) Marketing
7 12 (4.29%) Presentation Skills
8 8 (2.86%) Games
9 7 (2.50%) Front Office
9 7 (2.50%) Organisational Skills
10 6 (2.14%) Investment Banking
10 6 (2.14%) Legal
11 4 (1.43%) Influencing Skills
12 3 (1.07%) Local Government
12 3 (1.07%) Pharmaceutical
12 3 (1.07%) Retail
12 3 (1.07%) Retail Banking
13 1 (0.36%) Telecoms
Job Titles
1 74 (26.43%) Data Engineer
2 58 (20.71%) Analyst
3 52 (18.57%) Architect
4 48 (17.14%) Data Architect
5 47 (16.79%) Developer
6 21 (7.50%) Data Analyst
7 18 (6.43%) Business Analyst
7 18 (6.43%) Business Intelligence Developer
8 17 (6.07%) Business Intelligence Analyst
9 15 (5.36%) Senior Data Engineer
10 13 (4.64%) Data Scientist
11 12 (4.29%) Data Manager
12 11 (3.93%) Data Business Analyst
12 11 (3.93%) SQL Developer
13 10 (3.57%) Consultant
13 10 (3.57%) Junior
14 8 (2.86%) Data Consultant
14 8 (2.86%) Senior Analyst
15 7 (2.50%) Power BI Developer
15 7 (2.50%) Senior Consultant
Libraries, Frameworks & Software Standards
1 24 (8.57%) Kafka
2 18 (6.43%) PySpark
3 11 (3.93%) .NET
4 9 (3.21%) JSON
4 9 (3.21%) Web Services
5 7 (2.50%) XML
6 6 (2.14%) Node.js
7 5 (1.79%) RabbitMQ
8 4 (1.43%) .NET Core
8 4 (1.43%) .NET Framework
8 4 (1.43%) Spring
8 4 (1.43%) Spring Boot
9 3 (1.07%) EDI
9 3 (1.07%) Flask
9 3 (1.07%) Middleware
9 3 (1.07%) REST
10 2 (0.71%) ASP.NET Web API
10 2 (0.71%) Jinja
10 2 (0.71%) Ninject
10 2 (0.71%) Unity DI Container
Miscellaneous
1 23 (8.21%) Data Structures
2 16 (5.71%) Management Information System
3 12 (4.29%) User Experience
4 9 (3.21%) Greenfield Project
5 8 (2.86%) Mobile Games
6 7 (2.50%) Cloud Native
7 5 (1.79%) Reinsurance
8 4 (1.43%) Algorithms
9 3 (1.07%) Derivative
9 3 (1.07%) Housing Association
10 2 (0.71%) Analytical Mindset
10 2 (0.71%) Enterprise Software
10 2 (0.71%) Private Cloud
10 2 (0.71%) Renewable Energy
11 1 (0.36%) e-Learning
11 1 (0.36%) Legacy Systems
11 1 (0.36%) Marketing Technology
11 1 (0.36%) Mobile App
11 1 (0.36%) N-Tier
11 1 (0.36%) Wiki
Operating Systems
1 14 (5.00%) Unix
2 6 (2.14%) Linux
3 2 (0.71%) Windows
Processes & Methodologies
1 126 (45.00%) Analytics
2 117 (41.79%) Business Intelligence
3 103 (36.79%) ETL
4 65 (23.21%) Data Analysis
5 61 (21.79%) Agile Software Development
6 60 (21.43%) Data Architecture
7 46 (16.43%) Visualisation
8 44 (15.71%) Data Engineering
9 42 (15.00%) Data Management
10 40 (14.29%) Data Strategy
10 40 (14.29%) Migration
11 36 (12.86%) Data Governance
12 34 (12.14%) Data Pipeline
13 33 (11.79%) Data Science
14 31 (11.07%) Data Visualisation
14 31 (11.07%) Problem-Solving
15 29 (10.36%) Data Integration
16 27 (9.64%) Data Migration
17 26 (9.29%) Data Analytics
18 24 (8.57%) Decision-Making
Programming Languages
1 156 (55.71%) SQL
2 89 (31.79%) Python
3 27 (9.64%) C#
4 26 (9.29%) Java
5 20 (7.14%) R
6 19 (6.79%) PL/SQL
7 14 (5.00%) Scala
8 13 (4.64%) T-SQL
9 7 (2.50%) LookML
10 6 (2.14%) ANSI SQL
10 6 (2.14%) VBA
11 5 (1.79%) HiveQL
12 4 (1.43%) PowerShell
13 3 (1.07%) ABAP
13 3 (1.07%) Shell Script
14 2 (0.71%) Data Analysis Expressions (DAX)
14 2 (0.71%) JavaScript
15 1 (0.36%) PHP
15 1 (0.36%) VB
15 1 (0.36%) VB.NET
Qualifications
1 34 (12.14%) Degree
2 12 (4.29%) SC Cleared
2 12 (4.29%) Security Cleared
3 7 (2.50%) Computer Science Degree
4 5 (1.79%) Master's Degree
5 3 (1.07%) BPSS Clearance
5 3 (1.07%) DV Cleared
6 1 (0.36%) IBM Certification
6 1 (0.36%) Microsoft Certification
6 1 (0.36%) PhD
6 1 (0.36%) Tableau Certification
Quality Assurance & Compliance
1 64 (22.86%) Data Quality
2 12 (4.29%) QA
3 3 (1.07%) MiFID
3 3 (1.07%) Solvency II
4 2 (0.71%) GDPR
4 2 (0.71%) SLA
System Software
1 8 (2.86%) Docker
2 7 (2.50%) HDFS
3 2 (0.71%) Apache Flume
4 1 (0.36%) Active Directory
4 1 (0.36%) ISA Server
Systems Management
1 4 (1.43%) Terraform
2 3 (1.07%) Kubernetes
3 1 (0.36%) Ansible
3 1 (0.36%) Grafana
3 1 (0.36%) Mesos
3 1 (0.36%) Prometheus
Vendors
1 47 (16.79%) Microsoft
2 30 (10.71%) Oracle
3 29 (10.36%) Informatica
4 24 (8.57%) Databricks
5 20 (7.14%) SAP
6 19 (6.79%) Talend
7 12 (4.29%) Alteryx
7 12 (4.29%) Google
8 11 (3.93%) IBM
9 8 (2.86%) Cloudera
10 6 (2.14%) Facebook
10 6 (2.14%) Workday
11 4 (1.43%) Hortonworks
12 3 (1.07%) Atlassian
12 3 (1.07%) Salesforce.com
13 2 (0.71%) PeopleSoft
13 2 (0.71%) SnapLogic
14 1 (0.36%) Cognos
14 1 (0.36%) iManage
14 1 (0.36%) Trillium