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

Data Modelling
Central London > City of London
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 104 134 119
Rank change year-on-year +30 -15 +3
Permanent jobs citing Data Modelling 285 253 428
As % of all permanent IT jobs advertised in the City of London 2.79% 2.17% 2.52%
As % of the Processes & Methodologies category 3.09% 2.43% 2.83%
Number of salaries quoted 261 226 392
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,325
90th Percentile £95,000 £85,625 £87,500
Central London median annual salary £60,000 £60,000 £62,500
% change year-on-year - -4.00% +6.38%

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 9214 10414 15148
As % of all permanent IT jobs advertised in the City of London 90.12% 89.41% 89.15%
Number of salaries quoted 8320 9490 13129
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 £95,000 £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 23 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 23 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 23 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 186 (65.26%) SQL
2 150 (52.63%) SQL Server
3 148 (51.93%) Finance
4 108 (37.89%) Data Warehouse
5 103 (36.14%) Business Intelligence
6 95 (33.33%) Microsoft
7 94 (32.98%) Agile Software Development
8 83 (29.12%) SQL Server Integration Services
9 76 (26.67%) ETL
10 71 (24.91%) Analytics
11 70 (24.56%) Data Management
12 69 (24.21%) SQL Server Reporting Services
13 57 (20.00%) Banking
14 56 (19.65%) C#
15 55 (19.30%) Analytical Skills
16 54 (18.95%) Tableau
17 52 (18.25%) T-SQL
17 52 (18.25%) Oracle
18 51 (17.89%) Java
18 51 (17.89%) Data Quality
19 50 (17.54%) .NET
20 48 (16.84%) Degree
21 47 (16.49%) Python
22 43 (15.09%) Data Analysis
23 39 (13.68%) OO
24 36 (12.63%) Microsoft Excel
25 35 (12.28%) ITIL
25 35 (12.28%) Visualisation
25 35 (12.28%) Physical Data Model
26 34 (11.93%) Big Data

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.32%) Apache Spark
2 10 (3.51%) JBoss
2 10 (3.51%) Tomcat
2 10 (3.51%) WebLogic
2 10 (3.51%) WebSphere
3 7 (2.46%) SAS
4 2 (0.70%) Apache Geronimo
4 2 (0.70%) CMS
4 2 (0.70%) Confluence
4 2 (0.70%) SharePoint
4 2 (0.70%) WildFly
5 1 (0.35%) Apache
5 1 (0.35%) Apache Solr
5 1 (0.35%) Elasticsearch
5 1 (0.35%) Skype for Business
Applications
1 36 (12.63%) Microsoft Excel
2 11 (3.86%) MS Visio
3 6 (2.11%) Spreadsheet
4 4 (1.40%) SPSS
5 2 (0.70%) Microsoft Office
Business Applications
1 2 (0.70%) OpenText MBPM
1 2 (0.70%) Oracle Applications
2 1 (0.35%) Dynamics AX
2 1 (0.35%) Dynamics CRM
2 1 (0.35%) Eagle PACE
Cloud Services
1 23 (8.07%) Amazon AWS
2 20 (7.02%) Microsoft Azure
3 12 (4.21%) Azure Machine Learning
4 7 (2.46%) Google Cloud Platform
5 4 (1.40%) IBM Blueworks
6 3 (1.05%) SaaS
7 1 (0.35%) Boomi
7 1 (0.35%) Force.com
7 1 (0.35%) Salesforce Service Cloud
7 1 (0.35%) Serverless
Communications & Networking
1 2 (0.70%) SAN
2 1 (0.35%) Network Security
2 1 (0.35%) VPN
Database & Business Intelligence
1 150 (52.63%) SQL Server
2 108 (37.89%) Data Warehouse
3 83 (29.12%) SQL Server Integration Services
4 69 (24.21%) SQL Server Reporting Services
5 34 (11.93%) Big Data
6 33 (11.58%) SQL Server 2012
7 31 (10.88%) Power BI
8 29 (10.18%) Relational Database
8 29 (10.18%) SQL Server Analysis Services
9 27 (9.47%) SQL Server 2014
10 25 (8.77%) Hadoop
11 24 (8.42%) SQL Server 2008
12 18 (6.32%) Amazon Redshift
13 17 (5.96%) QlikView
14 15 (5.26%) Amazon RDS
14 15 (5.26%) BusinessObjects
15 13 (4.56%) NoSQL
15 13 (4.56%) Oracle Database
16 8 (2.81%) OLAP
17 6 (2.11%) IBM InfoSphere
Development Applications
1 17 (5.96%) Visual Studio
2 16 (5.61%) SQL Server Management Studio (SSMS)
3 11 (3.86%) Team Foundation Server
4 10 (3.51%) ERwin
5 5 (1.75%) JIRA
6 4 (1.40%) PowerDesigner
7 3 (1.05%) Talend Open Studio
8 1 (0.35%) Balsamiq Mockups
8 1 (0.35%) Eclipse
8 1 (0.35%) Gradle
8 1 (0.35%) Jasmine
8 1 (0.35%) Maven
8 1 (0.35%) NetBeans
8 1 (0.35%) Selenium
8 1 (0.35%) Toad
General
1 148 (51.93%) Finance
2 57 (20.00%) Banking
3 27 (9.47%) Investment Banking
4 15 (5.26%) Front Office
5 10 (3.51%) Retail Banking
6 8 (2.81%) Retail
7 7 (2.46%) Back Office
8 6 (2.11%) Marketing
9 5 (1.75%) Financial Institution
10 3 (1.05%) Legal
10 3 (1.05%) Publishing
11 2 (0.70%) Advertising
12 1 (0.35%) Automotive
12 1 (0.35%) Electronics
12 1 (0.35%) Games
12 1 (0.35%) International Banking
12 1 (0.35%) Manufacturing
Job Titles
1 103 (36.14%) Developer
2 73 (25.61%) Analyst
3 39 (13.68%) Architect
4 37 (12.98%) Business Analyst
5 36 (12.63%) Business Intelligence Developer
6 26 (9.12%) Consultant
6 26 (9.12%) Senior Developer
7 25 (8.77%) SQL Developer
8 24 (8.42%) Data Architect
9 23 (8.07%) Java Developer
10 22 (7.72%) DBA
10 22 (7.72%) Investment Banking Java Developer
10 22 (7.72%) SQL DBA
11 21 (7.37%) SQL Analyst
11 21 (7.37%) SQL Server DBA
12 19 (6.67%) C# Developer
13 16 (5.61%) Administrator
13 16 (5.61%) Data Consultant
14 15 (5.26%) Analyst Developer
14 15 (5.26%) Senior Java Developer
Libraries, Frameworks & Software Standards
1 50 (17.54%) .NET
2 27 (9.47%) ASP.NET
3 23 (8.07%) .NET Framework
4 18 (6.32%) AngularJS
5 14 (4.91%) jQuery
6 13 (4.56%) XML
7 11 (3.86%) Ajax
7 11 (3.86%) ASP.NET Web Forms
7 11 (3.86%) CSS
7 11 (3.86%) HTML
8 10 (3.51%) Spring
9 9 (3.16%) JMS
10 8 (2.81%) HTML5
10 8 (2.81%) Kafka
10 8 (2.81%) Web Services
11 6 (2.11%) Akka
11 6 (2.11%) GraphX
12 5 (1.75%) Node.js
12 5 (1.75%) XSLT
13 4 (1.40%) SOAP
Miscellaneous
1 55 (19.30%) Analytical Skills
2 28 (9.82%) Management Information System
3 13 (4.56%) Computer Science
3 13 (4.56%) Equities
4 11 (3.86%) Data Structures
4 11 (3.86%) Greenfield Project
5 8 (2.81%) Enterprise Software
6 6 (2.11%) Algorithms
6 6 (2.11%) Reinsurance
7 4 (1.40%) Clustering
7 4 (1.40%) Linux Command Line
8 3 (1.05%) Fixed Income
8 3 (1.05%) PMI
9 2 (0.70%) Data Centre
9 2 (0.70%) Hedge funds
9 2 (0.70%) Mobile App
9 2 (0.70%) Replication
10 1 (0.35%) Arduino
10 1 (0.35%) Fintech
10 1 (0.35%) Social Media
Operating Systems
1 17 (5.96%) Linux
2 13 (4.56%) Unix
3 11 (3.86%) Windows
4 1 (0.35%) Android
Processes & Methodologies
1 103 (36.14%) Business Intelligence
2 94 (32.98%) Agile Software Development
3 76 (26.67%) ETL
4 71 (24.91%) Analytics
5 70 (24.56%) Data Management
6 43 (15.09%) Data Analysis
7 39 (13.68%) OO
8 35 (12.28%) ITIL
8 35 (12.28%) Physical Data Model
8 35 (12.28%) Visualisation
9 34 (11.93%) Data Analytics
10 33 (11.58%) Data Architecture
11 30 (10.53%) Mathematics
11 30 (10.53%) Migration
12 26 (9.12%) Performance Tuning
13 22 (7.72%) Data Integration
14 21 (7.37%) CRM
14 21 (7.37%) Data Governance
14 21 (7.37%) Data Visualisation
14 21 (7.37%) Master Data Management
Programming Languages
1 186 (65.26%) SQL
2 56 (19.65%) C#
3 52 (18.25%) T-SQL
4 51 (17.89%) Java
5 47 (16.49%) Python
6 26 (9.12%) JavaScript
7 25 (8.77%) VBA
8 20 (7.02%) R
8 20 (7.02%) Scala
9 17 (5.96%) C++
10 10 (3.51%) C
10 10 (3.51%) PL/SQL
10 10 (3.51%) VB
11 4 (1.40%) Shell Script
11 4 (1.40%) VB6
12 3 (1.05%) MATLAB
12 3 (1.05%) VB.NET
13 2 (0.70%) Data Analysis Expressions (DAX)
14 1 (0.35%) SOQL
14 1 (0.35%) SOSL
Qualifications
1 48 (16.84%) Degree
2 19 (6.67%) MCITP
2 19 (6.67%) Microsoft Certification
3 4 (1.40%) ISEB
3 4 (1.40%) ITIL Foundation Certificate
4 3 (1.05%) Computer Science Degree
4 3 (1.05%) Oracle Certification
4 3 (1.05%) PMI Certification
5 2 (0.70%) Numerate Degree
6 1 (0.35%) DV Cleared
6 1 (0.35%) IIBA
6 1 (0.35%) Master's Degree
6 1 (0.35%) OCP
6 1 (0.35%) PhD
6 1 (0.35%) PMP
6 1 (0.35%) Security Cleared
Quality Assurance & Compliance
1 51 (17.89%) Data Quality
2 17 (5.96%) QA
3 6 (2.11%) PMO
4 3 (1.05%) GCP
5 2 (0.70%) GDPR
5 2 (0.70%) ISO 20022
5 2 (0.70%) SLA
5 2 (0.70%) Solvency II
6 1 (0.35%) IFRS
6 1 (0.35%) IFRS 9
System Software
1 6 (2.11%) Apache Flume
2 2 (0.70%) Apache ZooKeeper
2 2 (0.70%) HDFS
3 1 (0.35%) Docker
3 1 (0.35%) VMware Infrastructure
Systems Management
1 6 (2.11%) Hadoop YARN
1 6 (2.11%) Mesos
2 2 (0.70%) Control-M
2 2 (0.70%) Opscode Chef
2 2 (0.70%) Puppet
Vendors
1 95 (33.33%) Microsoft
2 54 (18.95%) Tableau
3 52 (18.25%) Oracle
4 13 (4.56%) Alteryx
5 11 (3.86%) IBM
6 8 (2.81%) Cognos
6 8 (2.81%) Salesforce.com
7 7 (2.46%) Google
7 7 (2.46%) Informatica
8 6 (2.11%) Siebel
8 6 (2.11%) Sybase
9 5 (1.75%) MicroStrategy
9 5 (1.75%) SAP
10 3 (1.05%) Adobe
10 3 (1.05%) EXASOL
10 3 (1.05%) Talend
10 3 (1.05%) Twitter
11 2 (0.70%) Birst
11 2 (0.70%) Netezza
11 2 (0.70%) Pega