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

Data Modelling
Central London > City of London
6 months to
25 Feb 2018
Same period 2017 Same period 2016
Rank 112 150 120
Rank change year-on-year +38 -30 +2
Permanent jobs citing Data Modelling 295 211 369
As % of all permanent IT jobs advertised in the City of London 2.78% 2.03% 2.64%
As % of the Processes & Methodologies category 3.05% 2.27% 2.94%
Number of salaries quoted 262 192 326
City of London median annual salary £62,500 £62,500 £60,000
Median salary % change year-on-year - +4.17% +4.35%
10th Percentile £42,500 £41,250 £40,750
90th Percentile £97,500 £93,625 £90,000
Central London median annual salary £61,250 £62,500 £60,000
% change year-on-year -2.00% +4.17% +4.35%

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,680 9,314 12,567
As % of all permanent IT jobs advertised in the City of London 91.11% 89.59% 89.76%
Number of salaries quoted 8,618 8,478 11,083
City of London median annual salary £62,250 £60,000 £57,500
Median salary % change year-on-year +3.75% +4.35% +4.55%
10th Percentile £37,000 £35,750 £35,750
90th Percentile £95,000 £92,500 £90,000
Central London median annual salary £60,000 £58,000 £57,500
% change year-on-year +3.45% +0.87% +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 25 February 2018.

Salary histogram for Data Modelling in the City of London

For the 6 months to 25 February 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 166 (56.27%) Finance
2 157 (53.22%) SQL
3 130 (44.07%) SQL Server
4 111 (37.63%) Business Intelligence
5 101 (34.24%) Agile Software Development
6 88 (29.83%) Data Warehouse
7 85 (28.81%) Analytics
8 77 (26.10%) Microsoft
9 71 (24.07%) SQL Server Integration Services
10 70 (23.73%) ETL
11 64 (21.69%) SQL Server Reporting Services
12 62 (21.02%) Tableau
13 60 (20.34%) Data Management
14 57 (19.32%) Degree
15 53 (17.97%) C#
16 52 (17.63%) Data Analysis
17 48 (16.27%) Java
18 46 (15.59%) Python
18 46 (15.59%) Mathematics
19 45 (15.25%) Data Analytics
20 42 (14.24%) Data Quality
21 41 (13.90%) .NET
21 41 (13.90%) Analytical Skills
22 40 (13.56%) Microsoft Azure
23 39 (13.22%) Migration
23 39 (13.22%) Power BI
24 38 (12.88%) SQL Server Analysis Services
25 37 (12.54%) Banking
26 35 (11.86%) Oracle
27 34 (11.53%) ASP.NET

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 15 (5.08%) Apache Spark
2 9 (3.05%) Elasticsearch
3 8 (2.71%) SAS
4 6 (2.03%) SharePoint
5 3 (1.02%) CMS
6 2 (0.68%) Apache
7 1 (0.34%) Apache Geronimo
7 1 (0.34%) DataSynapse
7 1 (0.34%) JBoss
7 1 (0.34%) Oracle Coherence
7 1 (0.34%) Skype for Business
7 1 (0.34%) Tomcat
7 1 (0.34%) WebLogic
7 1 (0.34%) WebSphere
7 1 (0.34%) WildFly
Applications
1 28 (9.49%) Microsoft Excel
2 14 (4.75%) Spreadsheet
3 9 (3.05%) SPSS
4 8 (2.71%) Microsoft Office
5 4 (1.36%) MS Visio
5 4 (1.36%) Stata
6 2 (0.68%) AutoCAD
6 2 (0.68%) Revit
7 1 (0.34%) Adobe Illustrator
7 1 (0.34%) Fireworks
7 1 (0.34%) InVision
7 1 (0.34%) Microsoft Project
7 1 (0.34%) Photoshop
Business Applications
1 6 (2.03%) Dynamics CRM
2 4 (1.36%) OpenText MBPM
3 2 (0.68%) Oracle Applications
3 2 (0.68%) Primavera
Cloud Services
1 40 (13.56%) Microsoft Azure
2 25 (8.47%) Amazon AWS
3 12 (4.07%) Azure Machine Learning
4 9 (3.05%) PaaS
5 5 (1.69%) Google Cloud Platform
5 5 (1.69%) SaaS
6 2 (0.68%) Boomi
6 2 (0.68%) Cloud Computing
6 2 (0.68%) Cortana Intelligence Suite
6 2 (0.68%) Force.com
6 2 (0.68%) IBM Blueworks
6 2 (0.68%) Salesforce Sales Cloud
6 2 (0.68%) Salesforce Service Cloud
6 2 (0.68%) Twilio
Communications & Networking
1 4 (1.36%) VPN
2 3 (1.02%) Firewall
3 2 (0.68%) AMQP
3 2 (0.68%) Cisco ASA
3 2 (0.68%) Internet
3 2 (0.68%) LAN
3 2 (0.68%) Network Security
3 2 (0.68%) SSL
3 2 (0.68%) WAN
4 1 (0.34%) VLAN
Database & Business Intelligence
1 130 (44.07%) SQL Server
2 88 (29.83%) Data Warehouse
3 71 (24.07%) SQL Server Integration Services
4 64 (21.69%) SQL Server Reporting Services
5 39 (13.22%) Power BI
6 38 (12.88%) SQL Server Analysis Services
7 28 (9.49%) Big Data
8 27 (9.15%) SQL Server 2012
9 25 (8.47%) Hadoop
10 22 (7.46%) QlikView
10 22 (7.46%) Relational Database
11 18 (6.10%) Amazon Redshift
12 16 (5.42%) Amazon RDS
12 16 (5.42%) SQL Server 2008
13 14 (4.75%) SQL Server 2014
14 13 (4.41%) NoSQL
15 12 (4.07%) BusinessObjects
15 12 (4.07%) OLAP
16 11 (3.73%) Data Mining
16 11 (3.73%) Oracle Database
Development Applications
1 20 (6.78%) ERwin
2 17 (5.76%) Team Foundation Server
3 11 (3.73%) Git (software)
3 11 (3.73%) Visual Studio
4 10 (3.39%) Moq
4 10 (3.39%) MSTest
4 10 (3.39%) NUnit
5 9 (3.05%) SQL Server Management Studio (SSMS)
6 3 (1.02%) JIRA
7 2 (0.68%) LINQPad
8 1 (0.34%) Axure RP
8 1 (0.34%) Balsamiq Mockups
8 1 (0.34%) Rhino Mocks
8 1 (0.34%) SpecFlow
8 1 (0.34%) Toad
General
1 166 (56.27%) Finance
2 37 (12.54%) Banking
3 17 (5.76%) Investment Banking
4 15 (5.08%) Financial Institution
5 8 (2.71%) Back Office
5 8 (2.71%) Front Office
6 7 (2.37%) Marketing
7 5 (1.69%) Retail
8 4 (1.36%) Legal
9 3 (1.02%) Retail Banking
9 3 (1.02%) Telecoms
10 2 (0.68%) Advertising
10 2 (0.68%) Electronics
10 2 (0.68%) Military
11 1 (0.34%) General Ledger
11 1 (0.34%) International Banking
Job Titles
1 117 (39.66%) Developer
2 68 (23.05%) Analyst
3 40 (13.56%) Senior Developer
4 39 (13.22%) Business Analyst
5 36 (12.20%) Architect
6 31 (10.51%) Business Intelligence Developer
7 29 (9.83%) Data Architect
8 28 (9.49%) Java Developer
9 20 (6.78%) Senior Java Developer
10 19 (6.44%) SQL Developer
11 18 (6.10%) C# Developer
11 18 (6.10%) DBA
11 18 (6.10%) SQL DBA
12 17 (5.76%) Consultant
12 17 (5.76%) Data Analyst
12 17 (5.76%) SSIS Developer
13 16 (5.42%) SQL Analyst
14 15 (5.08%) Investment Banking Java Developer
15 14 (4.75%) Business Intelligence Analyst
15 14 (4.75%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 41 (13.90%) .NET
2 34 (11.53%) ASP.NET
3 20 (6.78%) XML
4 18 (6.10%) REST
4 18 (6.10%) Web Services
5 17 (5.76%) AngularJS
6 16 (5.42%) ASP.NET Web API
7 13 (4.41%) jQuery
7 13 (4.41%) SOAP
8 12 (4.07%) CSS
8 12 (4.07%) HTML
9 10 (3.39%) .NET Framework
9 10 (3.39%) Ajax
10 9 (3.05%) ASP.NET Core
10 9 (3.05%) HTML5
10 9 (3.05%) Kafka
10 9 (3.05%) RESTful
11 8 (2.71%) ASP.NET Web Forms
11 8 (2.71%) Mason
11 8 (2.71%) MDX
Miscellaneous
1 41 (13.90%) Analytical Skills
2 30 (10.17%) Computer Science
3 29 (9.83%) Management Information System
4 17 (5.76%) Enterprise Software
5 15 (5.08%) Data Structures
6 13 (4.41%) Market Risk
7 11 (3.73%) Equities
8 9 (3.05%) Greenfield Project
8 9 (3.05%) Reinsurance
9 6 (2.03%) Algorithms
10 5 (1.69%) Derivative
11 4 (1.36%) Fintech
11 4 (1.36%) Foreign Exchange (FX)
12 3 (1.02%) Contract for Difference
12 3 (1.02%) Hedge funds
12 3 (1.02%) Mobile App
12 3 (1.02%) Spread Betting
12 3 (1.02%) Taxonomies
12 3 (1.02%) Virtual Team
13 2 (0.68%) Arduino
Operating Systems
1 14 (4.75%) Windows
2 10 (3.39%) Linux
3 4 (1.36%) Unix
4 2 (0.68%) Windows Server
4 2 (0.68%) Windows Server 2008
4 2 (0.68%) Windows Server 2012
Processes & Methodologies
1 111 (37.63%) Business Intelligence
2 101 (34.24%) Agile Software Development
3 85 (28.81%) Analytics
4 70 (23.73%) ETL
5 60 (20.34%) Data Management
6 52 (17.63%) Data Analysis
7 46 (15.59%) Mathematics
8 45 (15.25%) Data Analytics
9 39 (13.22%) Migration
10 34 (11.53%) Visualisation
11 29 (9.83%) Data Architecture
12 28 (9.49%) Data Governance
13 24 (8.14%) Dimensional Modelling
13 24 (8.14%) OO
14 23 (7.80%) Creative Thinking
15 22 (7.46%) ITIL
15 22 (7.46%) Performance Tuning
15 22 (7.46%) Waterfall
16 21 (7.12%) CRM
17 19 (6.44%) Software Engineering
Programming Languages
1 157 (53.22%) SQL
2 53 (17.97%) C#
3 48 (16.27%) Java
4 46 (15.59%) Python
5 28 (9.49%) T-SQL
6 26 (8.81%) VBA
7 24 (8.14%) JavaScript
8 21 (7.12%) R
9 14 (4.75%) VB
10 12 (4.07%) Scala
11 11 (3.73%) Apex Code
12 10 (3.39%) PL/SQL
13 9 (3.05%) PowerShell
14 7 (2.37%) C++
15 5 (1.69%) VB.NET
16 4 (1.36%) Data Analysis Expressions (DAX)
17 2 (0.68%) C
17 2 (0.68%) Cypher
17 2 (0.68%) Prolog
17 2 (0.68%) VBScript
Qualifications
1 57 (19.32%) Degree
2 14 (4.75%) MCITP
2 14 (4.75%) Microsoft Certification
3 6 (2.03%) PhD
4 5 (1.69%) ISEB
4 5 (1.69%) Security Cleared
5 4 (1.36%) Computer Science Degree
6 2 (0.68%) IIBA
6 2 (0.68%) PMP
6 2 (0.68%) Six Sigma Yellow Belt
7 1 (0.34%) DV Cleared
7 1 (0.34%) ITIL Certification
7 1 (0.34%) Numerate Degree
7 1 (0.34%) OCP
7 1 (0.34%) Oracle Certification
7 1 (0.34%) PMI Certification
Quality Assurance & Compliance
1 42 (14.24%) Data Quality
2 12 (4.07%) QA
3 5 (1.69%) PMO
4 4 (1.36%) GDPR
5 2 (0.68%) Solvency II
6 1 (0.34%) Dodd-Frank
6 1 (0.34%) EMIR
6 1 (0.34%) FATCA
6 1 (0.34%) IFRS
6 1 (0.34%) IFRS 9
6 1 (0.34%) MiFID
System Software
1 6 (2.03%) Apache Flume
2 4 (1.36%) VMware Infrastructure
3 3 (1.02%) Virtual Machines
4 2 (0.68%) Active Directory
4 2 (0.68%) Apache ZooKeeper
4 2 (0.68%) HDFS
Systems Management
1 6 (2.03%) Hadoop YARN
1 6 (2.03%) Mesos
2 2 (0.68%) Opscode Chef
2 2 (0.68%) Puppet
2 2 (0.68%) Single Sign-On
2 2 (0.68%) Terraform
3 1 (0.34%) Systems Management Server (SMS)
Vendors
1 77 (26.10%) Microsoft
2 62 (21.02%) Tableau
3 35 (11.86%) Oracle
4 21 (7.12%) Salesforce.com
5 13 (4.41%) Alteryx
6 10 (3.39%) Cognos
6 10 (3.39%) Google
7 7 (2.37%) IBM
7 7 (2.37%) Informatica
8 6 (2.03%) SAP
9 4 (1.36%) OpenText
9 4 (1.36%) Pega
9 4 (1.36%) VMware
10 3 (1.02%) Twitter
11 2 (0.68%) Apple
11 2 (0.68%) Cisco
11 2 (0.68%) Dell
11 2 (0.68%) Siebel
11 2 (0.68%) TIBCO
11 2 (0.68%) Xerox