Period
to 18 December 2018

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 18 December 2018 with a comparison to the same period in the previous 2 years.

Data Modelling
Central London > City of London
6 months to
18 Dec 2018
Same period 2017 Same period 2016
Rank 156 106 143
Rank change year-on-year -50 +37 -24
Permanent jobs citing Data Modelling 211 291 229
As % of all permanent IT jobs advertised in the City of London 1.98% 2.79% 2.04%
As % of the Processes & Methodologies category 2.16% 3.00% 2.24%
Number of salaries quoted 185 263 202
City of London median annual salary £65,000 £62,000 £60,000
Median salary % change year-on-year +4.84% +3.33% -
10th Percentile £45,000 £43,750 £43,750
90th Percentile £91,250 £95,000 £92,000
Central London median annual salary £65,000 £60,000 £60,000
% change year-on-year +8.33% - -4.00%

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 9,764 9,710 10,223
As % of all permanent IT jobs advertised in the City of London 91.83% 92.99% 91.04%
Number of salaries quoted 8,727 8,763 9,309
City of London median annual salary £65,000 £60,000 £60,000
Median salary % change year-on-year +8.33% - +4.35%
10th Percentile £36,750 £36,250 £35,000
90th Percentile £95,000 £95,000 £90,000
Central London median annual salary £65,000 £60,000 £57,500
% change year-on-year +8.33% +4.35% -

Data Modelling
Job Vacancy Trend in the City of London

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

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

The salary distribution of IT jobs citing Data Modelling in the City of London over the 6 months to 18 December 2018.

Salary histogram for Data Modelling in the City of London

For the 6 months to 18 December 2018, 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 119 (56.40%) SQL
2 84 (39.81%) Business Intelligence
3 81 (38.39%) Finance
4 75 (35.55%) ETL
5 70 (33.18%) Agile Software Development
6 68 (32.23%) Data Warehouse
7 65 (30.81%) Microsoft
8 63 (29.86%) Analytics
9 59 (27.96%) Analytical Skills
10 54 (25.59%) SQL Server
11 45 (21.33%) Python
11 45 (21.33%) Data Analysis
12 42 (19.91%) Microsoft Azure
13 39 (18.48%) Power BI
14 37 (17.54%) Tableau
15 36 (17.06%) Problem-Solving
16 34 (16.11%) Data Science
17 33 (15.64%) SQL Server Integration Services
18 32 (15.17%) Microsoft Excel
19 31 (14.69%) QA
19 31 (14.69%) Scrum
20 30 (14.22%) C#
20 30 (14.22%) Machine Learning
21 29 (13.74%) Data Lake
22 28 (13.27%) Visualisation
22 28 (13.27%) T-SQL
22 28 (13.27%) BusinessObjects
23 26 (12.32%) Big Data
24 25 (11.85%) Data Structures
24 25 (11.85%) Oracle

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 12 (5.69%) Apache Spark
2 7 (3.32%) Elasticsearch
3 6 (2.84%) SAS
4 5 (2.37%) SharePoint
5 3 (1.42%) Confluence
5 3 (1.42%) MS Exchange
6 2 (0.95%) Apache
7 1 (0.47%) BizTalk Server
7 1 (0.47%) IPython
7 1 (0.47%) SugarCRM
7 1 (0.47%) WebLogic
Applications
1 32 (15.17%) Microsoft Excel
2 7 (3.32%) MS Visio
3 4 (1.90%) Microsoft PowerPoint
4 2 (0.95%) Camtasia
4 2 (0.95%) Microsoft Office
4 2 (0.95%) Snagit
Business Applications
1 10 (4.74%) IntelliMatch
2 2 (0.95%) Siebel CRM
3 1 (0.47%) Dynamics CRM
3 1 (0.47%) Eagle PACE
3 1 (0.47%) Markit EDM
Cloud Services
1 42 (19.91%) Microsoft Azure
2 21 (9.95%) Amazon AWS
3 16 (7.58%) Azure Data Factory
4 8 (3.79%) SaaS
5 7 (3.32%) Azure Functions
5 7 (3.32%) Serverless
6 6 (2.84%) Data Lake Analytics
7 5 (2.37%) Amazon EC2
7 5 (2.37%) Amazon S3
7 5 (2.37%) Amazon SQS
7 5 (2.37%) Azure Machine Learning
7 5 (2.37%) Cloud Computing
8 3 (1.42%) Google Cloud Platform
8 3 (1.42%) PaaS
9 2 (0.95%) Dynamics 365
10 1 (0.47%) Adobe Analytics
10 1 (0.47%) Amazon EMR
10 1 (0.47%) Google Analytics
10 1 (0.47%) Office 365
Communications & Networking
1 2 (0.95%) Broadband
1 2 (0.95%) Internet
2 1 (0.47%) Unified Communications
Database & Business Intelligence
1 68 (32.23%) Data Warehouse
2 54 (25.59%) SQL Server
3 39 (18.48%) Power BI
4 33 (15.64%) SQL Server Integration Services
5 29 (13.74%) Data Lake
6 28 (13.27%) BusinessObjects
7 26 (12.32%) Big Data
8 22 (10.43%) Relational Database
8 22 (10.43%) SQL Server Analysis Services
9 20 (9.48%) Hadoop
10 19 (9.00%) SQL Server Reporting Services
11 14 (6.64%) Data Mining
12 11 (5.21%) Amazon Redshift
12 11 (5.21%) MongoDB
12 11 (5.21%) NoSQL
13 10 (4.74%) OLAP
13 10 (4.74%) PowerPivot
13 10 (4.74%) RDBMS
14 9 (4.27%) Apache Cassandra
14 9 (4.27%) SAP HANA
Development Applications
1 19 (9.00%) Git (software)
2 9 (4.27%) Visual Studio
3 7 (3.32%) Jenkins
3 7 (3.32%) JIRA
3 7 (3.32%) Visual Studio Team System
4 6 (2.84%) SpecFlow
5 5 (2.37%) Octopus Deploy
5 5 (2.37%) TeamCity
5 5 (2.37%) tSQLt
6 4 (1.90%) ERwin
7 3 (1.42%) RStudio
8 2 (0.95%) ER Studio
8 2 (0.95%) Oracle APEX
8 2 (0.95%) Phabricator
8 2 (0.95%) PowerDesigner
9 1 (0.47%) Eclipse
9 1 (0.47%) MagicDraw
9 1 (0.47%) MSTest
9 1 (0.47%) NUnit
9 1 (0.47%) Team Foundation Server
General
1 81 (38.39%) Finance
2 22 (10.43%) Banking
3 13 (6.16%) Financial Institution
4 10 (4.74%) Retail
5 6 (2.84%) Pharmaceutical
6 5 (2.37%) Advertising
6 5 (2.37%) General Ledger
7 4 (1.90%) Law
7 4 (1.90%) Marketing
7 4 (1.90%) Telecoms
8 3 (1.42%) German Language
8 3 (1.42%) International Banking
8 3 (1.42%) Investment Banking
8 3 (1.42%) Legal
8 3 (1.42%) Retail Banking
9 2 (0.95%) Automotive
9 2 (0.95%) Back Office
9 2 (0.95%) Front Office
9 2 (0.95%) Games
9 2 (0.95%) Spanish Language
Job Titles
1 62 (29.38%) Developer
2 46 (21.80%) Analyst
3 21 (9.95%) Architect
4 19 (9.00%) SQL Developer
5 17 (8.06%) Consultant
6 16 (7.58%) Business Intelligence Developer
7 15 (7.11%) Business Analyst
7 15 (7.11%) Data Analyst
7 15 (7.11%) Data Engineer
8 12 (5.69%) Data Scientist
9 11 (5.21%) Data Architect
9 11 (5.21%) Senior Analyst
10 10 (4.74%) Systems Analyst
11 9 (4.27%) ETL Developer
11 9 (4.27%) Java Developer
11 9 (4.27%) Senior Data Scientist
11 9 (4.27%) Senior Developer
12 7 (3.32%) Python Developer
12 7 (3.32%) SSAS Developer
12 7 (3.32%) SSIS Developer
Libraries, Frameworks & Software Standards
1 20 (9.48%) .NET
2 19 (9.00%) AngularJS
3 14 (6.64%) JSON
4 12 (5.69%) XML
5 10 (4.74%) EDIFACT
5 10 (4.74%) REST
6 8 (3.79%) Kafka
7 6 (2.84%) Spring
8 5 (2.37%) ActiveMQ
8 5 (2.37%) CSS
8 5 (2.37%) Django
8 5 (2.37%) HTML
8 5 (2.37%) MDX
8 5 (2.37%) Velocity
8 5 (2.37%) Vue.js
9 4 (1.90%) .NET Core
9 4 (1.90%) .NET Framework
9 4 (1.90%) NumPy
9 4 (1.90%) Pandas
9 4 (1.90%) Web Services
Miscellaneous
1 59 (27.96%) Analytical Skills
2 25 (11.85%) Data Structures
3 13 (6.16%) Hedge funds
4 11 (5.21%) Management Information System
5 10 (4.74%) Fintech
5 10 (4.74%) SWIFT
5 10 (4.74%) User Experience
6 9 (4.27%) Self-Motivation
7 6 (2.84%) Algorithms
7 6 (2.84%) Equities
7 6 (2.84%) Life Science
7 6 (2.84%) Reference Data
8 5 (2.37%) Greenfield Project
9 4 (1.90%) Taxonomies
9 4 (1.90%) Virtual Team
10 3 (1.42%) Data Protection Act
10 3 (1.42%) Derivative
10 3 (1.42%) Foreign Exchange (FX)
10 3 (1.42%) Reinsurance
10 3 (1.42%) Replication
Operating Systems
1 16 (7.58%) Windows
2 10 (4.74%) Windows Server
3 9 (4.27%) Linux
4 6 (2.84%) Unix
5 4 (1.90%) Windows Server 2012
6 1 (0.47%) Windows Server 2008
Processes & Methodologies
1 84 (39.81%) Business Intelligence
2 75 (35.55%) ETL
3 70 (33.18%) Agile Software Development
4 63 (29.86%) Analytics
5 45 (21.33%) Data Analysis
6 36 (17.06%) Problem-Solving
7 34 (16.11%) Data Science
8 31 (14.69%) Scrum
9 30 (14.22%) Machine Learning
10 28 (13.27%) Visualisation
11 22 (10.43%) Mathematics
12 20 (9.48%) Data Management
13 18 (8.53%) Kimball Methodology
13 18 (8.53%) Migration
13 18 (8.53%) Use Case
14 17 (8.06%) Test Automation
15 16 (7.58%) Performance Tuning
15 16 (7.58%) Stakeholder Management
16 15 (7.11%) Data Analytics
16 15 (7.11%) Microservices
Programming Languages
1 119 (56.40%) SQL
2 45 (21.33%) Python
3 30 (14.22%) C#
4 28 (13.27%) T-SQL
5 22 (10.43%) JavaScript
6 21 (9.95%) R
7 18 (8.53%) Java
8 15 (7.11%) Data Analysis Expressions (DAX)
9 13 (6.16%) PowerShell
10 11 (5.21%) VBA
11 5 (2.37%) MATLAB
11 5 (2.37%) PL/SQL
11 5 (2.37%) U-SQL
11 5 (2.37%) VB
12 4 (1.90%) C
13 3 (1.42%) Perl
13 3 (1.42%) PHP
13 3 (1.42%) Scala
14 2 (0.95%) ES6
14 2 (0.95%) VB6
Qualifications
1 25 (11.85%) Degree
2 8 (3.79%) PhD
3 4 (1.90%) MCSA
3 4 (1.90%) Microsoft Certification
3 4 (1.90%) Security Cleared
4 3 (1.42%) A+ Certification
4 3 (1.42%) Numerate Degree
5 2 (0.95%) Computer Science Degree
6 1 (0.47%) SC Cleared
6 1 (0.47%) TOGAF Certification
Quality Assurance & Compliance
1 31 (14.69%) QA
2 23 (10.90%) Data Quality
3 13 (6.16%) ISO 20022
4 10 (4.74%) SEPA
4 10 (4.74%) TARGET2
5 4 (1.90%) GDPR
6 2 (0.95%) COBIT
6 2 (0.95%) COSO
7 1 (0.47%) MiFID
7 1 (0.47%) PMO
7 1 (0.47%) SLA
7 1 (0.47%) Solvency II
System Software
1 9 (4.27%) Active Directory
1 9 (4.27%) Docker
2 3 (1.42%) HDFS
3 1 (0.47%) Hyper-V
3 1 (0.47%) Virtual Machines
3 1 (0.47%) VMware Infrastructure
Systems Management
1 4 (1.90%) SCCM
2 2 (0.95%) Automic
2 2 (0.95%) Control-M
2 2 (0.95%) Kubernetes
3 1 (0.47%) Cisco CUCM
3 1 (0.47%) SCOM
3 1 (0.47%) SCOrch
Vendors
1 65 (30.81%) Microsoft
2 37 (17.54%) Tableau
3 25 (11.85%) Oracle
4 21 (9.95%) SAP
5 10 (4.74%) Calypso
5 10 (4.74%) FIS
6 9 (4.27%) Informatica
7 8 (3.79%) IBM
7 8 (3.79%) Salesforce.com
8 7 (3.32%) Jedox
8 7 (3.32%) Talend
9 6 (2.84%) Siebel
10 4 (1.90%) Google
11 3 (1.42%) Citrix
11 3 (1.42%) MicroStrategy
11 3 (1.42%) SnapLogic
11 3 (1.42%) Sybase
11 3 (1.42%) Teradata
12 2 (0.95%) Birst
12 2 (0.95%) GoldenSource