Period
to 21 April 2019

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

Data Modelling
Central London > City of London
6 months to
21 Apr 2019
Same period 2018 Same period 2017
Rank 110 116 138
Rank change year-on-year +6 +22 -16
Permanent jobs citing Data Modelling 278 290 225
As % of all permanent IT jobs advertised in the City of London 2.72% 2.68% 2.17%
As % of the Processes & Methodologies category 2.95% 2.88% 2.36%
Number of salaries quoted 255 253 202
City of London median annual salary £67,500 £60,000 £65,000
Median salary % change year-on-year +12.50% -7.69% +8.33%
10th Percentile £42,500 £41,250 £41,250
90th Percentile £92,500 £93,750 £94,750
Central London median annual salary £67,500 £60,000 £65,000
% change year-on-year +12.50% -7.69% +8.33%

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,424 10,084 9,514
As % of all permanent IT jobs advertised in the City of London 92.18% 93.32% 91.71%
Number of salaries quoted 8,344 8,892 8,633
City of London median annual salary £65,000 £61,500 £60,000
Median salary % change year-on-year +5.69% +2.50% +4.35%
10th Percentile £36,250 £36,250 £36,250
90th Percentile £96,250 £93,750 £92,500
Central London median annual salary £65,000 £60,000 £60,000
% 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 21 April 2019.

Salary histogram for Data Modelling in the City of London

For the 6 months to 21 April 2019, 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 158 (56.83%) SQL
2 115 (41.37%) Analytics
3 112 (40.29%) Business Intelligence
4 104 (37.41%) Data Warehouse
5 95 (34.17%) Finance
6 92 (33.09%) Agile Software Development
7 91 (32.73%) SQL Server
8 90 (32.37%) ETL
9 88 (31.65%) Python
10 76 (27.34%) Microsoft
11 68 (24.46%) Microsoft Azure
12 67 (24.10%) Power BI
13 63 (22.66%) Data Analysis
14 57 (20.50%) SQL Server Integration Services
15 53 (19.06%) Analytical Skills
16 50 (17.99%) Data Analytics
16 50 (17.99%) Data Science
17 49 (17.63%) SQL Server Analysis Services
18 46 (16.55%) Big Data
19 45 (16.19%) Data Quality
20 44 (15.83%) SQL Server Reporting Services
21 42 (15.11%) Data Lake
22 39 (14.03%) Oracle
22 39 (14.03%) Data Analysis Expressions (DAX)
22 39 (14.03%) Problem-Solving
23 38 (13.67%) Tableau
24 37 (13.31%) Data Integration
24 37 (13.31%) SAP
25 36 (12.95%) Data Management
25 36 (12.95%) Scrum

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 16 (5.76%) Apache Spark
2 9 (3.24%) Apache
3 4 (1.44%) MS Exchange
3 4 (1.44%) SharePoint
4 3 (1.08%) GlassFish
4 3 (1.08%) WebLogic
4 3 (1.08%) WebSphere
4 3 (1.08%) WebSphere Application Server
5 2 (0.72%) Jupyter
6 1 (0.36%) Apache Pig
6 1 (0.36%) BizTalk Server
6 1 (0.36%) Confluence
6 1 (0.36%) DNN
6 1 (0.36%) Elasticsearch
6 1 (0.36%) SAS
Applications
1 30 (10.79%) Microsoft Excel
2 4 (1.44%) SPSS
3 3 (1.08%) MS Visio
4 2 (0.72%) Microsoft Office
Business Applications
1 5 (1.80%) Dynamics CRM
1 5 (1.80%) IntelliMatch
2 4 (1.44%) Cognos Business Intelligence
3 1 (0.36%) Actimize
3 1 (0.36%) Cognos TM1
3 1 (0.36%) Eagle PACE
3 1 (0.36%) Markit EDM
3 1 (0.36%) Siebel CRM
3 1 (0.36%) thinkFolio
Cloud Services
1 68 (24.46%) Microsoft Azure
2 36 (12.95%) Azure Data Factory
3 28 (10.07%) Amazon AWS
4 11 (3.96%) Google Cloud Platform
5 8 (2.88%) PaaS
5 8 (2.88%) SaaS
6 5 (1.80%) Data Lake Analytics
6 5 (1.80%) Serverless
7 4 (1.44%) Dynamics 365
8 3 (1.08%) AWS Lambda
8 3 (1.08%) Azure Machine Learning
9 2 (0.72%) Amazon EMR
9 2 (0.72%) Amazon Kinesis
9 2 (0.72%) Amazon S3
9 2 (0.72%) Azure Functions
9 2 (0.72%) IaaS
9 2 (0.72%) Office 365
10 1 (0.36%) Boomi
10 1 (0.36%) GitHub
10 1 (0.36%) Heroku
Communications & Networking
1 3 (1.08%) Internet
2 2 (0.72%) Broadband
3 1 (0.36%) Unified Communications
Database & Business Intelligence
1 104 (37.41%) Data Warehouse
2 91 (32.73%) SQL Server
3 67 (24.10%) Power BI
4 57 (20.50%) SQL Server Integration Services
5 49 (17.63%) SQL Server Analysis Services
6 46 (16.55%) Big Data
7 44 (15.83%) SQL Server Reporting Services
8 42 (15.11%) Data Lake
9 27 (9.71%) Microsoft Analysis Services
10 25 (8.99%) Azure SQL Database
11 21 (7.55%) Relational Database
12 15 (5.40%) BusinessObjects
12 15 (5.40%) Hadoop
13 14 (5.04%) Azure SQL Data Warehouse
13 14 (5.04%) NoSQL
14 10 (3.60%) Apache Cassandra
14 10 (3.60%) MongoDB
14 10 (3.60%) MySQL
14 10 (3.60%) RDBMS
15 8 (2.88%) Amazon Redshift
Development Applications
1 15 (5.40%) Git (software)
2 8 (2.88%) ERwin
3 6 (2.16%) JIRA
3 6 (2.16%) PowerDesigner
4 5 (1.80%) ER Studio
5 3 (1.08%) Ant
5 3 (1.08%) Maven
5 3 (1.08%) RStudio
6 2 (0.72%) Jenkins
6 2 (0.72%) Oracle APEX
6 2 (0.72%) Visual Studio
6 2 (0.72%) Visual Studio Team System
7 1 (0.36%) Bitbucket
7 1 (0.36%) Hudson
7 1 (0.36%) MagicDraw
7 1 (0.36%) Octopus Deploy
7 1 (0.36%) SpecFlow
7 1 (0.36%) TeamCity
7 1 (0.36%) tSQLt
7 1 (0.36%) webpack
General
1 95 (34.17%) Finance
2 28 (10.07%) Banking
3 14 (5.04%) Advertising
3 14 (5.04%) Legal
3 14 (5.04%) Retail
4 10 (3.60%) Investment Banking
5 9 (3.24%) Financial Institution
6 8 (2.88%) Law
7 3 (1.08%) Front Office
7 3 (1.08%) German Language
7 3 (1.08%) Marketing
8 2 (0.72%) Automotive
8 2 (0.72%) Retail Banking
8 2 (0.72%) Spanish Language
9 1 (0.36%) Back Office
9 1 (0.36%) Electronics
9 1 (0.36%) Telecoms
Job Titles
1 84 (30.22%) Developer
2 69 (24.82%) Analyst
3 41 (14.75%) Architect
4 37 (13.31%) Business Intelligence Developer
5 32 (11.51%) Data Analyst
6 31 (11.15%) SQL Developer
7 20 (7.19%) Data Architect
8 19 (6.83%) Business Analyst
9 17 (6.12%) Data Engineer
9 17 (6.12%) SQL BI Developer
10 16 (5.76%) Consultant
10 16 (5.76%) SQL Analyst
11 13 (4.68%) Azure Developer
11 13 (4.68%) Senior Developer
12 12 (4.32%) Business Intelligence Analyst
12 12 (4.32%) Data Scientist
12 12 (4.32%) Excel Analyst
12 12 (4.32%) SQL Data Analyst
12 12 (4.32%) SSIS Developer
12 12 (4.32%) SSRS Developer
Libraries, Frameworks & Software Standards
1 21 (7.55%) MDX
2 15 (5.40%) .NET
3 13 (4.68%) AngularJS
3 13 (4.68%) XML
4 9 (3.24%) HTML
4 9 (3.24%) Kafka
4 9 (3.24%) Web Services
5 8 (2.88%) CSS
5 8 (2.88%) JSON
6 7 (2.52%) REST
7 6 (2.16%) Twitter Bootstrap
8 5 (1.80%) EDIFACT
9 4 (1.44%) ASP.NET Web API
9 4 (1.44%) MLlib
9 4 (1.44%) RESTful
9 4 (1.44%) scikit-learn
10 3 (1.08%) Apache Flex
10 3 (1.08%) Node.js
10 3 (1.08%) NumPy
10 3 (1.08%) Spring
Miscellaneous
1 53 (19.06%) Analytical Skills
2 28 (10.07%) Data Structures
3 15 (5.40%) Fintech
3 15 (5.40%) Management Information System
4 12 (4.32%) Algorithms
5 11 (3.96%) Reinsurance
6 10 (3.60%) User Experience
7 8 (2.88%) Hedge funds
8 7 (2.52%) Greenfield Project
9 5 (1.80%) Equities
9 5 (1.80%) SWIFT
10 4 (1.44%) Data Protection Act
10 4 (1.44%) Enterprise Software
10 4 (1.44%) Foreign Exchange (FX)
10 4 (1.44%) Reference Data
10 4 (1.44%) Taxonomies
10 4 (1.44%) Virtual Team
11 3 (1.08%) Data Centre
11 3 (1.08%) Mobile App
11 3 (1.08%) Robotics
Operating Systems
1 13 (4.68%) Linux
2 11 (3.96%) Windows
3 8 (2.88%) Unix
4 3 (1.08%) Android
5 2 (0.72%) Windows Server
6 1 (0.36%) Windows Server 2008
6 1 (0.36%) Windows Server 2012
Processes & Methodologies
1 115 (41.37%) Analytics
2 112 (40.29%) Business Intelligence
3 92 (33.09%) Agile Software Development
4 90 (32.37%) ETL
5 63 (22.66%) Data Analysis
6 50 (17.99%) Data Analytics
6 50 (17.99%) Data Science
7 39 (14.03%) Problem-Solving
8 37 (13.31%) Data Integration
9 36 (12.95%) Data Management
9 36 (12.95%) Scrum
10 35 (12.59%) Visualisation
11 33 (11.87%) Master Data Management
12 31 (11.15%) Kimball Methodology
13 30 (10.79%) Information Governance
14 28 (10.07%) DevOps
15 27 (9.71%) Data Governance
15 27 (9.71%) Machine Learning
15 27 (9.71%) Mathematics
15 27 (9.71%) Migration
Programming Languages
1 158 (56.83%) SQL
2 88 (31.65%) Python
3 39 (14.03%) Data Analysis Expressions (DAX)
4 29 (10.43%) R
5 26 (9.35%) Java
6 23 (8.27%) T-SQL
7 21 (7.55%) C#
8 19 (6.83%) JavaScript
9 17 (6.12%) VBA
10 13 (4.68%) PowerShell
11 9 (3.24%) PL/SQL
12 6 (2.16%) C
12 6 (2.16%) Scala
12 6 (2.16%) VB
13 5 (1.80%) Apex Code
14 4 (1.44%) Bash Shell
14 4 (1.44%) MATLAB
14 4 (1.44%) Shell Script
15 3 (1.08%) Kotlin
15 3 (1.08%) XPath
Qualifications
1 34 (12.23%) Degree
2 14 (5.04%) Security Cleared
3 5 (1.80%) MCSA
3 5 (1.80%) Microsoft Certification
3 5 (1.80%) PhD
4 4 (1.44%) A+ Certification
5 3 (1.08%) AWS Certification
5 3 (1.08%) Master's Degree
6 2 (0.72%) MCSE
7 1 (0.36%) Computer Science Degree
7 1 (0.36%) Numerate Degree
7 1 (0.36%) SC Cleared
7 1 (0.36%) TOGAF Certification
Quality Assurance & Compliance
1 45 (16.19%) Data Quality
2 20 (7.19%) QA
3 14 (5.04%) GDPR
4 9 (3.24%) Solvency II
5 8 (2.88%) ISO 20022
6 5 (1.80%) SEPA
6 5 (1.80%) TARGET2
System Software
1 8 (2.88%) Docker
2 4 (1.44%) Active Directory
3 2 (0.72%) Apache Flume
4 1 (0.36%) HDFS
4 1 (0.36%) Hyper-V
4 1 (0.36%) VMware Infrastructure
4 1 (0.36%) zsh
Systems Management
1 7 (2.52%) Kubernetes
2 5 (1.80%) SCCM
3 2 (0.72%) HP Quality Center
4 1 (0.36%) Automic
4 1 (0.36%) Cisco CUCM
4 1 (0.36%) Control-M
4 1 (0.36%) Microsoft Intune
4 1 (0.36%) SCOM
4 1 (0.36%) SCOrch
4 1 (0.36%) Terraform
Vendors
1 76 (27.34%) Microsoft
2 39 (14.03%) Oracle
3 38 (13.67%) Tableau
4 37 (13.31%) SAP
5 26 (9.35%) IBM
6 19 (6.83%) Databricks
7 13 (4.68%) Informatica
8 10 (3.60%) Cognos
9 8 (2.88%) Salesforce.com
10 6 (2.16%) Teradata
11 5 (1.80%) Calypso
11 5 (1.80%) FIS
11 5 (1.80%) Google
11 5 (1.80%) Hortonworks
11 5 (1.80%) MicroStrategy
12 4 (1.44%) Citrix
12 4 (1.44%) Jedox
12 4 (1.44%) MuleSoft
12 4 (1.44%) Talend
13 3 (1.08%) Splunk