Period
to 11 December 2018

The following table provides summary statistics for contract job vacancies advertised in London with a requirement for Physical Data Model skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Physical Data Model over the 6 months to 11 December 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Physical Data Model
England > London
6 months to
11 Dec 2018
Same period 2017 Same period 2016
Rank 516 551 510
Rank change year-on-year +35 -41 +47
Contract jobs citing Physical Data Model 117 98 111
As % of all contract IT jobs advertised in London 0.25% 0.21% 0.25%
As % of the Processes & Methodologies category 0.28% 0.23% 0.29%
Number of daily rates quoted 92 61 55
London median daily rate £575 £500 £480
Median daily rate % change year-on-year +15.00% +4.17% +6.67%
10th Percentile £451 £325 £313
90th Percentile £713 £588 £633
England median daily rate £550 £500 £463
% change year-on-year +10.00% +8.11% +2.78%
Number of hourly rates quoted 0 0 0
London median hourly rate - - -
England median hourly rate £18.50 - -

Physical Data Model is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in London with a requirement for process or methodology skills.

All Process and Methodology Skills
London
Contract vacancies with a requirement for process or methodology skills 41,383 41,867 38,807
As % of all contract IT jobs advertised in London 87.87% 88.17% 87.40%
Number of daily rates quoted 29,849 30,454 27,745
London median daily rate £500 £500 £475
Median daily rate % change year-on-year - +5.26% +5.56%
10th Percentile £325 £313 £306
90th Percentile £675 £675 £638
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% -
Number of hourly rates quoted 470 391 435
London median hourly rate £24.04 £22.50 £22.00
Median hourly rate % change year-on-year +6.84% +2.27% +10.00%
10th Percentile £13.00 £13.30 £12.05
90th Percentile £54.71 £48.75 £50.00
England median hourly rate £22.00 £24.69 £22.84
% change year-on-year -10.88% +8.10% +3.80%

Physical Data Model
Job Vacancy Trend in London

Job postings citing Physical Data Model as a percentage of all IT jobs advertised in London.

Job vacancy trend for Physical Data Model in London

Physical Data Model
Contractor Daily Rate Trend in London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Physical Data Model in London.

Contractor daily rate trend for Physical Data Model in London

Physical Data Model
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing Physical Data Model in London over the 6 months to 11 December 2018.

Contractor daily rate histogram for Physical Data Model in London

Physical Data Model
Contractor Hourly Rate Trend in London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Physical Data Model in London.

Contractor hourly rate trend for Physical Data Model in London

Physical Data Model
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Physical Data Model within the London region over the 6 months to 11 December 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London -20 17 £650 +30.00%
South London -13 10 £525 - 2
West London - 8 £550 - 2
East London -34 2 £563 -
Physical Data Model
England

For the 6 months to 11 December 2018, IT contractor jobs citing Physical Data Model also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the London region with a requirement for Physical Data Model.

1 117 (100.00%) Data Modelling
2 109 (93.16%) Logical Data Model
3 74 (63.25%) Business Intelligence
4 59 (50.43%) SQL
5 51 (43.59%) Data Warehouse
6 42 (35.90%) Finance
7 39 (33.33%) Dimensional Modelling
8 37 (31.62%) Hadoop
8 37 (31.62%) Apache Spark
9 36 (30.77%) Analytics
10 35 (29.91%) Data Architecture
11 34 (29.06%) Visualisation
11 34 (29.06%) JSON
11 34 (29.06%) Agile Software Development
12 33 (28.21%) Front Office
13 29 (24.79%) Data Management
13 29 (24.79%) Tableau
13 29 (24.79%) Big Data
14 28 (23.93%) Translating Business Requirements
15 27 (23.08%) XSD
15 27 (23.08%) JSON Schema
16 26 (22.22%) Oracle
16 26 (22.22%) Technical Analysis
17 25 (21.37%) SQL Server Integration Services
18 24 (20.51%) SQL Server Reporting Services
18 24 (20.51%) T-SQL
18 24 (20.51%) Data Analytics
18 24 (20.51%) Microsoft Azure
18 24 (20.51%) SQL Server Analysis Services
19 22 (18.80%) SQL Server

Physical Data Model
Co-occurring IT Skills in 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 37 (31.62%) Apache Spark
2 17 (14.53%) Apache
3 8 (6.84%) Confluence
4 1 (0.85%) Apache Pig
4 1 (0.85%) Cloud Foundry
4 1 (0.85%) Liferay
4 1 (0.85%) Oracle Workflow
4 1 (0.85%) WebLogic
4 1 (0.85%) WebLogic Portal
Applications
1 6 (5.13%) MS Visio
2 1 (0.85%) Microsoft Office
2 1 (0.85%) Shockwave
Business Applications
1 2 (1.71%) SAP Oil and Gas
2 1 (0.85%) ResourceLink
Cloud Services
1 24 (20.51%) Microsoft Azure
2 9 (7.69%) Amazon AWS
3 6 (5.13%) Amazon S3
4 3 (2.56%) SaaS
5 2 (1.71%) GitHub
6 1 (0.85%) Amazon EMR
6 1 (0.85%) Amazon Kinesis
6 1 (0.85%) AWS Lambda
6 1 (0.85%) IaaS
6 1 (0.85%) OpenShift
6 1 (0.85%) PaaS
6 1 (0.85%) Serverless
Communications & Networking
1 1 (0.85%) Internet
1 1 (0.85%) LAN
1 1 (0.85%) Unified Communications
1 1 (0.85%) WAN
Database & Business Intelligence
1 51 (43.59%) Data Warehouse
2 37 (31.62%) Hadoop
3 29 (24.79%) Big Data
4 25 (21.37%) SQL Server Integration Services
5 24 (20.51%) SQL Server Analysis Services
5 24 (20.51%) SQL Server Reporting Services
6 22 (18.80%) SQL Server
7 20 (17.09%) Power BI
8 15 (12.82%) Relational Database
9 14 (11.97%) Impala
10 8 (6.84%) Apache Kudu
11 7 (5.98%) OLTP
12 6 (5.13%) MySQL
13 5 (4.27%) Amazon RDS
13 5 (4.27%) JanusGraph
13 5 (4.27%) MongoDB
13 5 (4.27%) NoSQL
13 5 (4.27%) OLAP
13 5 (4.27%) Oracle BI EE
13 5 (4.27%) Oracle ODI
Development Applications
1 16 (13.68%) Git (software)
2 14 (11.97%) ERwin
3 13 (11.11%) Subversion
4 10 (8.55%) JIRA
5 7 (5.98%) Atlassian Bamboo
5 7 (5.98%) Cucumber
5 7 (5.98%) FishEye
5 7 (5.98%) jMock
5 7 (5.98%) JUnit
5 7 (5.98%) Maven
5 7 (5.98%) PowerDesigner
6 6 (5.13%) ER Studio
7 4 (3.42%) Toad
7 4 (3.42%) XMLSpy
8 2 (1.71%) Jenkins
8 2 (1.71%) Team Foundation Server
9 1 (0.85%) Rational Rose
9 1 (0.85%) SonarQube
General
1 42 (35.90%) Finance
2 33 (28.21%) Front Office
3 18 (15.38%) Banking
4 9 (7.69%) Investment Banking
5 8 (6.84%) Pharmaceutical
6 6 (5.13%) Retail
Job Titles
1 41 (35.04%) Architect
2 40 (34.19%) Data Modeller
3 36 (30.77%) Data Architect
4 21 (17.95%) Developer
5 10 (8.55%) Java Developer
6 7 (5.98%) Apache Spark Developer
6 7 (5.98%) Data Engineer
7 6 (5.13%) Senior Data Modeller
7 6 (5.13%) Senior Developer
7 6 (5.13%) Senior SQL Developer
7 6 (5.13%) SQL Developer
8 5 (4.27%) Analyst
9 4 (3.42%) Data Analyst
9 4 (3.42%) Technical Leader
10 3 (2.56%) Business Intelligence Developer
10 3 (2.56%) Consultant
10 3 (2.56%) Data Consultant
10 3 (2.56%) Data Warehouse Developer
10 3 (2.56%) Report Developer
10 3 (2.56%) Solutions Architect
Libraries, Frameworks & Software Standards
1 34 (29.06%) JSON
2 27 (23.08%) JSON Schema
2 27 (23.08%) XSD
3 12 (10.26%) XML
4 6 (5.13%) FIX Protocol
4 6 (5.13%) FpML
4 6 (5.13%) REST
4 6 (5.13%) SOAP
5 4 (3.42%) RESTful
6 3 (2.56%) Middleware
6 3 (2.56%) Spring
7 2 (1.71%) Kafka
8 1 (0.85%) .NET
8 1 (0.85%) AngularJS
8 1 (0.85%) ASP.NET
8 1 (0.85%) Java EE
8 1 (0.85%) Oracle Fusion
8 1 (0.85%) Ruby on Rails
8 1 (0.85%) Web Services
Miscellaneous
1 13 (11.11%) Greenfield Project
2 9 (7.69%) Analytical Skills
3 8 (6.84%) Data Structures
3 8 (6.84%) Fixed Income
4 6 (5.13%) Enterprise Software
5 5 (4.27%) Public Cloud
6 2 (1.71%) Taxonomies
7 1 (0.85%) Clustering
7 1 (0.85%) Credit Risk
7 1 (0.85%) FMCG
7 1 (0.85%) Reference Data
7 1 (0.85%) User Experience
7 1 (0.85%) Virtual Team
Operating Systems
1 9 (7.69%) Linux
2 8 (6.84%) Unix
3 1 (0.85%) Oracle Linux
3 1 (0.85%) Windows
Processes & Methodologies
1 117 (100.00%) Data Modelling
2 109 (93.16%) Logical Data Model
3 74 (63.25%) Business Intelligence
4 39 (33.33%) Dimensional Modelling
5 36 (30.77%) Analytics
6 35 (29.91%) Data Architecture
7 34 (29.06%) Agile Software Development
7 34 (29.06%) Visualisation
8 29 (24.79%) Data Management
9 28 (23.93%) Translating Business Requirements
10 26 (22.22%) Technical Analysis
11 24 (20.51%) Data Analytics
12 21 (17.95%) SDLC
13 19 (16.24%) Decision-Making
14 18 (15.38%) Domain Models
15 15 (12.82%) Migration
16 14 (11.97%) Conceptual Models
17 13 (11.11%) Data Integration
18 12 (10.26%) ETL
19 11 (9.40%) Data Mapping
Programming Languages
1 59 (50.43%) SQL
2 24 (20.51%) T-SQL
3 17 (14.53%) Java
4 16 (13.68%) Java 8
5 2 (1.71%) JavaScript
5 2 (1.71%) Python
6 1 (0.85%) C
6 1 (0.85%) PHP
6 1 (0.85%) PL/SQL
6 1 (0.85%) VB
Qualifications
1 8 (6.84%) Security Cleared
2 7 (5.98%) SC Cleared
3 2 (1.71%) Degree
4 1 (0.85%) CISSP
4 1 (0.85%) Computer Science Degree
Quality Assurance & Compliance
1 11 (9.40%) Data Quality
2 5 (4.27%) GDPR
3 1 (0.85%) IFRS
3 1 (0.85%) IFRS 9
3 1 (0.85%) QA
System Software
1 10 (8.55%) HDFS
2 2 (1.71%) Apache Flume
Systems Management
1 2 (1.71%) Oozie
2 1 (0.85%) Consul
2 1 (0.85%) Control-M
2 1 (0.85%) Kubernetes
2 1 (0.85%) Packer
2 1 (0.85%) Terraform
Vendors
1 29 (24.79%) Tableau
2 26 (22.22%) Oracle
3 17 (14.53%) Microsoft
4 10 (8.55%) Cloudera
5 7 (5.98%) Atlassian
5 7 (5.98%) Sybase
6 5 (4.27%) Salesforce.com
7 4 (3.42%) Informatica
8 3 (2.56%) Cognos
8 3 (2.56%) MuleSoft
8 3 (2.56%) SAP
9 2 (1.71%) ServiceNow
10 1 (0.85%) Casewise
10 1 (0.85%) Cisco
10 1 (0.85%) Google
10 1 (0.85%) IBM
10 1 (0.85%) Talend
10 1 (0.85%) Teradata