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

Data Modelling
Central London > City of London
6 months to
25 Sep 2018
Same period 2017 Same period 2016
Rank 165 116 147
Rank change year-on-year -49 +31 -15
Permanent jobs citing Data Modelling 205 270 247
As % of all permanent IT jobs advertised in the City of London 1.85% 2.66% 2.02%
As % of the Processes & Methodologies category 2.01% 2.90% 2.21%
Number of salaries quoted 178 254 224
City of London median annual salary £65,000 £65,000 £60,000
Median salary % change year-on-year - +8.33% -4.00%
10th Percentile £45,000 £46,250 £45,375
90th Percentile £90,000 £95,000 £85,000
Central London median annual salary £62,500 £62,500 £60,000
% change year-on-year - +4.17% -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 10,213 9,300 11,186
As % of all permanent IT jobs advertised in the City of London 92.21% 91.54% 91.50%
Number of salaries quoted 9,098 8,390 10,237
City of London median annual salary £65,000 £60,000 £60,000
Median salary % change year-on-year +8.33% - +4.35%
10th Percentile £37,000 £36,250 £35,000
90th Percentile £93,750 £92,500 £87,500
Central London median annual salary £62,500 £60,000 £57,500
% change year-on-year +4.17% +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 25 September 2018.

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 25 September 2018. 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
London Bridge - 4 £80,000 -
Data Modelling
Central London

For the 6 months to 25 September 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 (58.05%) SQL
2 91 (44.39%) SQL Server
3 87 (42.44%) Finance
4 86 (41.95%) Business Intelligence
5 85 (41.46%) ETL
6 84 (40.98%) Data Warehouse
7 72 (35.12%) Agile Software Development
8 65 (31.71%) Microsoft
9 60 (29.27%) SQL Server Integration Services
10 50 (24.39%) T-SQL
11 48 (23.41%) SQL Server Reporting Services
11 48 (23.41%) Analytics
12 46 (22.44%) Analytical Skills
13 45 (21.95%) Power BI
14 44 (21.46%) Data Analysis
15 42 (20.49%) Big Data
16 37 (18.05%) Problem-Solving
17 33 (16.10%) Test Automation
18 31 (15.12%) Data Quality
19 30 (14.63%) Degree
19 30 (14.63%) Oracle
19 30 (14.63%) Python
19 30 (14.63%) Relational Database
20 27 (13.17%) SQL Server Analysis Services
20 27 (13.17%) Data Lake
21 25 (12.20%) Data Science
21 25 (12.20%) Tableau
22 24 (11.71%) Java
22 24 (11.71%) Continuous Integration
22 24 (11.71%) Data Strategy

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 11 (5.37%) Apache Spark
2 10 (4.88%) Elasticsearch
3 5 (2.44%) SharePoint
4 3 (1.46%) SAS
5 2 (0.98%) Oracle SOA Suite
5 2 (0.98%) WebLogic
6 1 (0.49%) Apache
6 1 (0.49%) Apache Solr
6 1 (0.49%) Confluence
6 1 (0.49%) IPython
6 1 (0.49%) JBoss
6 1 (0.49%) Oracle Workflow
6 1 (0.49%) SugarCRM
6 1 (0.49%) WebSphere
Applications
1 22 (10.73%) Microsoft Excel
2 5 (2.44%) MS Visio
3 4 (1.95%) Microsoft PowerPoint
4 3 (1.46%) Microsoft Office
5 2 (0.98%) Camtasia
5 2 (0.98%) Snagit
6 1 (0.49%) EViews
6 1 (0.49%) SPSS
Business Applications
1 3 (1.46%) IntelliMatch
2 2 (0.98%) Dynamics CRM
2 2 (0.98%) Siebel CRM
Cloud Services
1 21 (10.24%) Amazon AWS
2 19 (9.27%) Microsoft Azure
3 6 (2.93%) Cloud Computing
4 5 (2.44%) Amazon EC2
4 5 (2.44%) Amazon S3
4 5 (2.44%) Amazon SQS
5 4 (1.95%) SaaS
6 3 (1.46%) Azure Data Factory
6 3 (1.46%) Google Cloud Platform
7 2 (0.98%) Amazon EMR
7 2 (0.98%) Azure Functions
7 2 (0.98%) Data Lake Analytics
7 2 (0.98%) Dynamics 365
7 2 (0.98%) Serverless
8 1 (0.49%) Adobe Analytics
8 1 (0.49%) Boomi
8 1 (0.49%) CloudBees
8 1 (0.49%) Google Analytics
8 1 (0.49%) IBM Blueworks
8 1 (0.49%) PaaS
Communications & Networking
1 4 (1.95%) Internet
Database & Business Intelligence
1 91 (44.39%) SQL Server
2 84 (40.98%) Data Warehouse
3 60 (29.27%) SQL Server Integration Services
4 48 (23.41%) SQL Server Reporting Services
5 45 (21.95%) Power BI
6 42 (20.49%) Big Data
7 30 (14.63%) Relational Database
8 27 (13.17%) Data Lake
8 27 (13.17%) SQL Server Analysis Services
9 21 (10.24%) BusinessObjects
10 20 (9.76%) Hadoop
11 17 (8.29%) SQL Server 2012
12 15 (7.32%) RDBMS
13 14 (6.83%) OLAP
13 14 (6.83%) SQL Server 2008
14 13 (6.34%) Data Mining
15 12 (5.85%) PowerPivot
16 9 (4.39%) MongoDB
16 9 (4.39%) OLAP Cube
17 8 (3.90%) PostgreSQL
Development Applications
1 10 (4.88%) Git (software)
2 8 (3.90%) Visual Studio
3 6 (2.93%) JIRA
4 5 (2.44%) ERwin
5 4 (1.95%) ER Studio
5 4 (1.95%) Jenkins
6 3 (1.46%) SpecFlow
7 2 (0.98%) Moq
7 2 (0.98%) MSTest
7 2 (0.98%) NUnit
7 2 (0.98%) Octopus Deploy
7 2 (0.98%) Rhino Mocks
7 2 (0.98%) Subversion
7 2 (0.98%) TeamCity
7 2 (0.98%) tSQLt
7 2 (0.98%) Visual Studio Team System
8 1 (0.49%) Atlassian Bamboo
8 1 (0.49%) Eclipse
8 1 (0.49%) Maven
8 1 (0.49%) Selenium
General
1 87 (42.44%) Finance
2 14 (6.83%) Marketing
3 10 (4.88%) Retail
4 9 (4.39%) Banking
4 9 (4.39%) General Ledger
5 6 (2.93%) Advertising
5 6 (2.93%) Financial Institution
5 6 (2.93%) Pharmaceutical
6 4 (1.95%) Telecoms
7 3 (1.46%) Games
7 3 (1.46%) International Banking
8 2 (0.98%) Back Office
8 2 (0.98%) Front Office
8 2 (0.98%) Legal
9 1 (0.49%) Aerospace
9 1 (0.49%) Billing
9 1 (0.49%) Investment Banking
9 1 (0.49%) Law
9 1 (0.49%) Mandarin Language
9 1 (0.49%) Publishing
Job Titles
1 67 (32.68%) Developer
2 37 (18.05%) Analyst
3 31 (15.12%) Business Intelligence Developer
4 25 (12.20%) Architect
5 23 (11.22%) SQL Developer
6 22 (10.73%) Consultant
7 19 (9.27%) Data Warehouse Developer
8 15 (7.32%) Data Analyst
9 14 (6.83%) SSIS Developer
10 13 (6.34%) Senior Developer
11 12 (5.85%) Business Analyst
11 12 (5.85%) Data Consultant
12 11 (5.37%) Data Architect
13 10 (4.88%) SSRS Developer
14 9 (4.39%) Data Engineer
14 9 (4.39%) Data Scientist
15 8 (3.90%) Business Consultant
15 8 (3.90%) Business Intelligence Consultant
15 8 (3.90%) SSAS Developer
16 7 (3.41%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 11 (5.37%) .NET
2 9 (4.39%) AngularJS
2 9 (4.39%) REST
3 8 (3.90%) JSON
3 8 (3.90%) MDX
3 8 (3.90%) Spring
3 8 (3.90%) XML
4 6 (2.93%) Kafka
5 5 (2.44%) ActiveMQ
5 5 (2.44%) Django
5 5 (2.44%) Web Services
6 4 (1.95%) .NET Core
6 4 (1.95%) .NET Framework
7 3 (1.46%) EDIFACT
7 3 (1.46%) HTML
7 3 (1.46%) Vue.js
8 2 (0.98%) Ajax
8 2 (0.98%) CGI
8 2 (0.98%) J2EE
8 2 (0.98%) SOAP
Miscellaneous
1 46 (22.44%) Analytical Skills
2 12 (5.85%) Data Structures
3 11 (5.37%) Computer Science
4 10 (4.88%) Self-Motivation
5 9 (4.39%) Greenfield Project
5 9 (4.39%) Hedge funds
6 8 (3.90%) Fintech
7 7 (3.41%) Management Information System
7 7 (3.41%) User Experience
8 6 (2.93%) Life Science
9 4 (1.95%) Reinsurance
9 4 (1.95%) Replication
10 3 (1.46%) Data Protection Act
10 3 (1.46%) Derivative
10 3 (1.46%) SWIFT
10 3 (1.46%) Tandem
11 2 (0.98%) Algorithms
11 2 (0.98%) e-Learning
11 2 (0.98%) Equities
11 2 (0.98%) Social Media
Operating Systems
1 12 (5.85%) Windows
2 10 (4.88%) Windows Server
3 4 (1.95%) Windows Server 2012
4 3 (1.46%) Linux
4 3 (1.46%) Unix
Processes & Methodologies
1 86 (41.95%) Business Intelligence
2 85 (41.46%) ETL
3 72 (35.12%) Agile Software Development
4 48 (23.41%) Analytics
5 44 (21.46%) Data Analysis
6 37 (18.05%) Problem-Solving
7 33 (16.10%) Test Automation
8 25 (12.20%) Data Science
9 24 (11.71%) Continuous Integration
9 24 (11.71%) Data Strategy
10 23 (11.22%) Migration
11 22 (10.73%) Information Governance
12 21 (10.24%) Data Architecture
12 21 (10.24%) Machine Learning
13 20 (9.76%) Scrum
13 20 (9.76%) SDLC
14 19 (9.27%) Data Management
14 19 (9.27%) Data Migration
14 19 (9.27%) Mentoring
14 19 (9.27%) Visualisation
Programming Languages
1 119 (58.05%) SQL
2 50 (24.39%) T-SQL
3 30 (14.63%) Python
4 24 (11.71%) Java
5 18 (8.78%) R
6 17 (8.29%) C#
7 12 (5.85%) Data Analysis Expressions (DAX)
8 7 (3.41%) JavaScript
8 7 (3.41%) Scala
9 4 (1.95%) C
9 4 (1.95%) Perl
9 4 (1.95%) PL/SQL
9 4 (1.95%) PowerShell
9 4 (1.95%) VB
9 4 (1.95%) VBA
10 2 (0.98%) C++
10 2 (0.98%) U-SQL
11 1 (0.49%) Go
11 1 (0.49%) MATLAB
11 1 (0.49%) Shell Script
Qualifications
1 30 (14.63%) Degree
2 10 (4.88%) Security Cleared
3 8 (3.90%) PhD
4 4 (1.95%) Numerate Degree
5 2 (0.98%) Computer Science Degree
6 1 (0.49%) Master's Degree
6 1 (0.49%) MCSA
6 1 (0.49%) Microsoft Certification
Quality Assurance & Compliance
1 31 (15.12%) Data Quality
2 14 (6.83%) QA
3 12 (5.85%) GDPR
4 5 (2.44%) PMO
5 3 (1.46%) ISO 20022
5 3 (1.46%) SEPA
5 3 (1.46%) TARGET2
6 2 (0.98%) COBIT
6 2 (0.98%) COSO
7 1 (0.49%) MiFID
7 1 (0.49%) SLA
System Software
1 7 (3.41%) Docker
2 6 (2.93%) Active Directory
3 4 (1.95%) HDFS
Systems Management
1 4 (1.95%) Oozie
2 1 (0.49%) Ansible
2 1 (0.49%) Kubernetes
2 1 (0.49%) Puppet
Vendors
1 65 (31.71%) Microsoft
2 30 (14.63%) Oracle
3 25 (12.20%) Tableau
4 21 (10.24%) SAP
5 12 (5.85%) IBM
6 10 (4.88%) Informatica
7 6 (2.93%) Salesforce.com
7 6 (2.93%) Siebel
8 5 (2.44%) Talend
9 4 (1.95%) Google
10 3 (1.46%) Bloomberg
10 3 (1.46%) Calypso
10 3 (1.46%) FIS
10 3 (1.46%) Teradata
11 2 (0.98%) Cloudera
11 2 (0.98%) MuleSoft
11 2 (0.98%) SnapLogic
11 2 (0.98%) Sybase
12 1 (0.49%) Alteryx
12 1 (0.49%) MapR