Period
to 21 November 2017

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

Data Modelling
Central London > City of London
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 106 133 115
Rank change year-on-year +27 -18 +8
Permanent jobs citing Data Modelling 280 254 427
As % of all permanent IT jobs advertised in the City of London 2.73% 2.19% 2.51%
As % of the Processes & Methodologies category 3.03% 2.44% 2.82%
Number of salaries quoted 258 227 389
City of London median annual salary £62,000 £60,000 £60,000
Median salary % change year-on-year +3.33% - -
10th Percentile £46,250 £45,000 £41,250
90th Percentile £95,000 £85,500 £86,700
Central London median annual salary £60,000 £60,000 £62,500
% change year-on-year - -4.00% +4.17%

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 9247 10392 15168
As % of all permanent IT jobs advertised in the City of London 90.08% 89.44% 89.12%
Number of salaries quoted 8347 9474 13149
City of London median annual salary £60,000 £60,000 £57,500
Median salary % change year-on-year - +4.35% +4.55%
10th Percentile £36,250 £35,000 £33,750
90th Percentile £93,750 £90,000 £87,500
Central London median annual salary £60,000 £57,500 £57,500
% change year-on-year +4.35% - +4.55%

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 November 2017.

Salary histogram for Data Modelling in the City of London

Data Modelling
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 Modelling within the City of London region over the 6 months to 21 November 2017. 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
Moorgate - 1 £55,000 -
Data Modelling
Central London

For the 6 months to 21 November 2017, IT jobs citing Data Modelling also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the City of London region with a requirement for Data Modelling.

1 182 (65.00%) SQL
2 147 (52.50%) SQL Server
3 143 (51.07%) Finance
4 106 (37.86%) Data Warehouse
5 99 (35.36%) Business Intelligence
6 95 (33.93%) Microsoft
7 91 (32.50%) Agile Software Development
8 83 (29.64%) SQL Server Integration Services
9 74 (26.43%) ETL
10 69 (24.64%) Data Management
10 69 (24.64%) SQL Server Reporting Services
10 69 (24.64%) Analytics
11 57 (20.36%) Banking
12 56 (20.00%) C#
13 55 (19.64%) Analytical Skills
14 53 (18.93%) T-SQL
15 52 (18.57%) Data Quality
16 51 (18.21%) Tableau
16 51 (18.21%) Java
16 51 (18.21%) Oracle
17 50 (17.86%) .NET
18 47 (16.79%) Python
19 46 (16.43%) Degree
20 41 (14.64%) Data Analysis
21 39 (13.93%) OO
22 36 (12.86%) Microsoft Excel
23 35 (12.50%) Physical Data Model
24 33 (11.79%) Big Data
24 33 (11.79%) Data Architecture
24 33 (11.79%) Visualisation

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 18 (6.43%) Apache Spark
2 10 (3.57%) JBoss
2 10 (3.57%) Tomcat
2 10 (3.57%) WebLogic
2 10 (3.57%) WebSphere
3 5 (1.79%) SAS
4 2 (0.71%) Apache Geronimo
4 2 (0.71%) CMS
4 2 (0.71%) Confluence
4 2 (0.71%) SharePoint
4 2 (0.71%) WildFly
5 1 (0.36%) Apache
5 1 (0.36%) Apache Solr
5 1 (0.36%) Elasticsearch
5 1 (0.36%) Skype for Business
Applications
1 36 (12.86%) Microsoft Excel
2 11 (3.93%) MS Visio
3 6 (2.14%) Spreadsheet
4 2 (0.71%) Microsoft Office
4 2 (0.71%) SPSS
Business Applications
1 2 (0.71%) OpenText MBPM
1 2 (0.71%) Oracle Applications
2 1 (0.36%) Dynamics AX
2 1 (0.36%) Dynamics CRM
2 1 (0.36%) Eagle PACE
Cloud Services
1 23 (8.21%) Amazon AWS
2 20 (7.14%) Microsoft Azure
3 12 (4.29%) Azure Machine Learning
4 7 (2.50%) Google Cloud Platform
5 4 (1.43%) IBM Blueworks
6 3 (1.07%) SaaS
7 1 (0.36%) Boomi
7 1 (0.36%) Force.com
7 1 (0.36%) Salesforce Service Cloud
7 1 (0.36%) Serverless
Communications & Networking
1 2 (0.71%) SAN
2 1 (0.36%) Network Security
2 1 (0.36%) VPN
Database & Business Intelligence
1 147 (52.50%) SQL Server
2 106 (37.86%) Data Warehouse
3 83 (29.64%) SQL Server Integration Services
4 69 (24.64%) SQL Server Reporting Services
5 33 (11.79%) Big Data
6 32 (11.43%) SQL Server 2012
7 31 (11.07%) Power BI
8 29 (10.36%) Relational Database
8 29 (10.36%) SQL Server Analysis Services
9 26 (9.29%) SQL Server 2014
10 25 (8.93%) Hadoop
11 23 (8.21%) SQL Server 2008
12 18 (6.43%) Amazon Redshift
13 16 (5.71%) QlikView
14 15 (5.36%) Amazon RDS
15 13 (4.64%) BusinessObjects
15 13 (4.64%) NoSQL
16 12 (4.29%) Oracle Database
17 8 (2.86%) OLAP
18 6 (2.14%) IBM InfoSphere
Development Applications
1 17 (6.07%) Visual Studio
2 16 (5.71%) SQL Server Management Studio (SSMS)
3 11 (3.93%) Team Foundation Server
4 8 (2.86%) ERwin
5 5 (1.79%) JIRA
6 4 (1.43%) PowerDesigner
7 3 (1.07%) Talend Open Studio
8 1 (0.36%) Balsamiq Mockups
8 1 (0.36%) Eclipse
8 1 (0.36%) Gradle
8 1 (0.36%) Jasmine
8 1 (0.36%) Maven
8 1 (0.36%) NetBeans
8 1 (0.36%) Selenium
8 1 (0.36%) Toad
General
1 143 (51.07%) Finance
2 57 (20.36%) Banking
3 27 (9.64%) Investment Banking
4 16 (5.71%) Front Office
5 10 (3.57%) Retail Banking
6 8 (2.86%) Retail
7 7 (2.50%) Back Office
8 6 (2.14%) Marketing
9 5 (1.79%) Financial Institution
10 3 (1.07%) Legal
10 3 (1.07%) Publishing
11 2 (0.71%) Advertising
12 1 (0.36%) Automotive
12 1 (0.36%) Electronics
12 1 (0.36%) Games
12 1 (0.36%) International Banking
12 1 (0.36%) Manufacturing
Job Titles
1 101 (36.07%) Developer
2 69 (24.64%) Analyst
3 39 (13.93%) Architect
4 36 (12.86%) Business Analyst
4 36 (12.86%) Business Intelligence Developer
5 26 (9.29%) Senior Developer
6 25 (8.93%) Consultant
6 25 (8.93%) SQL Developer
7 23 (8.21%) Data Architect
7 23 (8.21%) Java Developer
8 22 (7.86%) Investment Banking Java Developer
9 21 (7.50%) DBA
9 21 (7.50%) SQL Analyst
9 21 (7.50%) SQL DBA
10 20 (7.14%) SQL Server DBA
11 19 (6.79%) C# Developer
12 15 (5.36%) Administrator
12 15 (5.36%) Data Consultant
12 15 (5.36%) Senior Investment Banking Java Developer
12 15 (5.36%) Senior Java Developer
Libraries, Frameworks & Software Standards
1 50 (17.86%) .NET
2 27 (9.64%) ASP.NET
3 23 (8.21%) .NET Framework
4 18 (6.43%) AngularJS
5 14 (5.00%) jQuery
6 12 (4.29%) XML
7 11 (3.93%) Ajax
7 11 (3.93%) ASP.NET Web Forms
7 11 (3.93%) CSS
7 11 (3.93%) HTML
8 10 (3.57%) Spring
9 9 (3.21%) JMS
10 8 (2.86%) HTML5
10 8 (2.86%) Kafka
10 8 (2.86%) Web Services
11 6 (2.14%) Akka
11 6 (2.14%) GraphX
11 6 (2.14%) XSLT
12 5 (1.79%) Node.js
13 4 (1.43%) MDX
Miscellaneous
1 55 (19.64%) Analytical Skills
2 27 (9.64%) Management Information System
3 13 (4.64%) Equities
4 11 (3.93%) Computer Science
4 11 (3.93%) Data Structures
4 11 (3.93%) Greenfield Project
5 8 (2.86%) Enterprise Software
6 6 (2.14%) Algorithms
7 5 (1.79%) Reinsurance
8 4 (1.43%) Clustering
8 4 (1.43%) Linux Command Line
9 3 (1.07%) Fixed Income
9 3 (1.07%) PMI
10 2 (0.71%) Data Centre
10 2 (0.71%) Hedge funds
10 2 (0.71%) Mobile App
10 2 (0.71%) Replication
11 1 (0.36%) Arduino
11 1 (0.36%) Fintech
11 1 (0.36%) Social Media
Operating Systems
1 17 (6.07%) Linux
2 13 (4.64%) Unix
3 11 (3.93%) Windows
4 1 (0.36%) Android
Processes & Methodologies
1 99 (35.36%) Business Intelligence
2 91 (32.50%) Agile Software Development
3 74 (26.43%) ETL
4 69 (24.64%) Analytics
4 69 (24.64%) Data Management
5 41 (14.64%) Data Analysis
6 39 (13.93%) OO
7 35 (12.50%) Physical Data Model
8 33 (11.79%) Data Architecture
8 33 (11.79%) ITIL
8 33 (11.79%) Visualisation
9 32 (11.43%) Data Analytics
10 28 (10.00%) Mathematics
10 28 (10.00%) Migration
11 26 (9.29%) Performance Tuning
12 22 (7.86%) Data Integration
13 21 (7.50%) CRM
13 21 (7.50%) Data Lineage
13 21 (7.50%) Data Visualisation
13 21 (7.50%) Master Data Management
Programming Languages
1 182 (65.00%) SQL
2 56 (20.00%) C#
3 53 (18.93%) T-SQL
4 51 (18.21%) Java
5 47 (16.79%) Python
6 25 (8.93%) VBA
7 24 (8.57%) JavaScript
8 20 (7.14%) R
8 20 (7.14%) Scala
9 17 (6.07%) C++
10 10 (3.57%) C
10 10 (3.57%) VB
11 9 (3.21%) PL/SQL
12 4 (1.43%) Shell Script
12 4 (1.43%) VB6
13 3 (1.07%) MATLAB
13 3 (1.07%) VB.NET
14 2 (0.71%) Data Analysis Expressions (DAX)
15 1 (0.36%) SOQL
15 1 (0.36%) SOSL
Qualifications
1 46 (16.43%) Degree
2 18 (6.43%) MCITP
2 18 (6.43%) Microsoft Certification
3 4 (1.43%) ISEB
3 4 (1.43%) ITIL Foundation Certificate
4 3 (1.07%) Computer Science Degree
4 3 (1.07%) Oracle Certification
4 3 (1.07%) PMI Certification
5 2 (0.71%) Numerate Degree
6 1 (0.36%) DV Cleared
6 1 (0.36%) IIBA
6 1 (0.36%) Master's Degree
6 1 (0.36%) OCP
6 1 (0.36%) PhD
6 1 (0.36%) PMP
6 1 (0.36%) Security Cleared
Quality Assurance & Compliance
1 52 (18.57%) Data Quality
2 17 (6.07%) QA
3 6 (2.14%) PMO
4 3 (1.07%) GCP
4 3 (1.07%) ISO 20022
5 2 (0.71%) GDPR
5 2 (0.71%) SLA
5 2 (0.71%) Solvency II
6 1 (0.36%) IFRS
6 1 (0.36%) IFRS 9
System Software
1 6 (2.14%) Apache Flume
2 2 (0.71%) Apache ZooKeeper
2 2 (0.71%) HDFS
3 1 (0.36%) Docker
3 1 (0.36%) VMware Infrastructure
Systems Management
1 6 (2.14%) Hadoop YARN
1 6 (2.14%) Mesos
2 2 (0.71%) Control-M
2 2 (0.71%) Opscode Chef
2 2 (0.71%) Puppet
Vendors
1 95 (33.93%) Microsoft
2 51 (18.21%) Oracle
2 51 (18.21%) Tableau
3 13 (4.64%) Alteryx
4 11 (3.93%) IBM
5 8 (2.86%) Salesforce.com
6 7 (2.50%) Cognos
6 7 (2.50%) Google
6 7 (2.50%) Informatica
7 6 (2.14%) Siebel
7 6 (2.14%) Sybase
8 5 (1.79%) MicroStrategy
8 5 (1.79%) SAP
9 3 (1.07%) Adobe
9 3 (1.07%) EXASOL
9 3 (1.07%) Talend
9 3 (1.07%) Twitter
10 2 (0.71%) Birst
10 2 (0.71%) Pega
10 2 (0.71%) SnapLogic