Period
to 16 January 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 16 January 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
16 Jan 2018
Same period 2017 Same period 2016
Rank 541 500 547
Rank change year-on-year -41 +47 -22
Contract jobs citing Physical Data Model 84 88 53
As % of all contract IT jobs advertised in London 0.18% 0.21% 0.12%
As % of the Processes & Methodologies category 0.21% 0.25% 0.14%
Number of daily rates quoted 55 41 32
London median daily rate £500 £490 £450
Median daily rate % change year-on-year +2.04% +8.89% -10.00%
10th Percentile £310 £325 £371
90th Percentile £650 £663 £538
England median daily rate £500 £475 £450
% change year-on-year +5.26% +5.56% -0.33%
Number of hourly rates quoted 0 0 0
London median hourly rate - - -
England median hourly rate - - -

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 40,206 35,902 37,112
As % of all contract IT jobs advertised in London 86.61% 86.05% 84.74%
Number of daily rates quoted 29,349 25,851 26,433
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% +0.11%
10th Percentile £313 £310 £295
90th Percentile £675 £650 £638
England median daily rate £450 £433 £425
% change year-on-year +4.05% +1.76% +6.25%
Number of hourly rates quoted 412 419 453
London median hourly rate £22.00 £24.00 £20.00
Median hourly rate % change year-on-year -8.33% +20.00% +9.59%
10th Percentile £13.31 £12.25 £11.25
90th Percentile £48.75 £51.25 £51.80
England median hourly rate £24.00 £25.00 £23.00
% change year-on-year -4.00% +8.70% +15.00%

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 16 January 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 16 January 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 +1 18 £500 +14.29% 2
East London -19 5 £558 +17.37%
South London - 2 £525 -
Physical Data Model
England

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

1 84 (100.00%) Data Modelling
2 74 (88.10%) Logical Data Model
3 41 (48.81%) SQL
4 31 (36.90%) ETL
5 27 (32.14%) Data Warehouse
6 26 (30.95%) SQL Server
7 25 (29.76%) Oracle
8 23 (27.38%) Agile Software Development
9 22 (26.19%) Business Intelligence
10 20 (23.81%) PL/SQL
11 17 (20.24%) Java
11 17 (20.24%) Data Cleansing
11 17 (20.24%) Data Quality
12 14 (16.67%) Data Analysis
13 13 (15.48%) Security Cleared
13 13 (15.48%) Data Architecture
14 12 (14.29%) Finance
14 12 (14.29%) T-SQL
14 12 (14.29%) Microsoft
14 12 (14.29%) Informatica
14 12 (14.29%) SQL Server Integration Services
15 11 (13.10%) Data Security
15 11 (13.10%) PostgreSQL
15 11 (13.10%) Migration
15 11 (13.10%) Coaching
15 11 (13.10%) Oracle Database
16 10 (11.90%) Amazon AWS
16 10 (11.90%) Data Mapping
16 10 (11.90%) Data Integration
16 10 (11.90%) Analytics

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 7 (8.33%) Oracle SOA Suite
2 5 (5.95%) Confluence
3 2 (2.38%) Apache Spark
3 2 (2.38%) ArcGIS
3 2 (2.38%) Elasticsearch
3 2 (2.38%) SAS
4 1 (1.19%) Oracle Workflow
4 1 (1.19%) Tomcat
4 1 (1.19%) WebLogic
4 1 (1.19%) WebSphere
Applications
1 3 (3.57%) Microsoft Excel
2 2 (2.38%) SPSS
3 1 (1.19%) Microsoft Office
Business Applications
1 8 (9.52%) NetSuite
Cloud Services
1 10 (11.90%) Amazon AWS
2 8 (9.52%) Boomi
3 2 (2.38%) Microsoft Azure
3 2 (2.38%) SaaS
4 1 (1.19%) Amazon EMR
4 1 (1.19%) Amazon S3
4 1 (1.19%) FinancialForce
4 1 (1.19%) iPaaS
Communications & Networking
1 5 (5.95%) LDAP
2 1 (1.19%) SMS
Database & Business Intelligence
1 27 (32.14%) Data Warehouse
2 26 (30.95%) SQL Server
3 12 (14.29%) SQL Server Integration Services
4 11 (13.10%) Oracle Database
4 11 (13.10%) PostgreSQL
5 9 (10.71%) Relational Database
5 9 (10.71%) SQL Server Reporting Services
6 8 (9.52%) Oracle Database 11g
6 8 (9.52%) Oracle ODI
6 8 (9.52%) SQL Server 2012
7 7 (8.33%) Amazon RDS
7 7 (8.33%) Big Data
8 6 (7.14%) Power BI
9 5 (5.95%) Geospatial Data
9 5 (5.95%) RDBMS
10 4 (4.76%) PowerPivot
10 4 (4.76%) SQL Server 2016
11 3 (3.57%) Electronic Patient Records
11 3 (3.57%) Oracle Database 12c
11 3 (3.57%) Spatial Data
Development Applications
1 8 (9.52%) ERwin
2 6 (7.14%) JIRA
3 5 (5.95%) PowerDesigner
4 4 (4.76%) Jenkins
5 3 (3.57%) Maven
5 3 (3.57%) Sonatype Nexus
6 2 (2.38%) Rational Rhapsody
7 1 (1.19%) Ant
7 1 (1.19%) Bitbucket
7 1 (1.19%) ChangeMan
7 1 (1.19%) Cucumber
7 1 (1.19%) FitNesse
General
1 12 (14.29%) Finance
2 9 (10.71%) Banking
3 6 (7.14%) Pharmaceutical
4 4 (4.76%) Legal
5 3 (3.57%) Manufacturing
6 2 (2.38%) Publishing
6 2 (2.38%) Telecoms
7 1 (1.19%) Advertising
7 1 (1.19%) Marketing
Job Titles
1 40 (47.62%) Architect
2 22 (26.19%) Data Architect
3 21 (25.00%) Developer
4 13 (15.48%) SQL Developer
5 9 (10.71%) Integration Specialist
6 6 (7.14%) Applications Specialist
6 6 (7.14%) Business Intelligence Developer
6 6 (7.14%) Database Architect
6 6 (7.14%) Oracle Architect
7 5 (5.95%) Applications Architect
7 5 (5.95%) Integration Architect
7 5 (5.95%) Oracle Developer
7 5 (5.95%) PL/SQL Developer
7 5 (5.95%) Senior Architect
7 5 (5.95%) Senior Data Architect
7 5 (5.95%) Technical Leader
8 4 (4.76%) Data Modeller
8 4 (4.76%) Java Architect
8 4 (4.76%) Software Architect
8 4 (4.76%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 9 (10.71%) Middleware
2 8 (9.52%) Oracle GoldenGate
3 7 (8.33%) JSON
4 6 (7.14%) Hibernate
4 6 (7.14%) J2EE
4 6 (7.14%) Spring
5 5 (5.95%) MDX
5 5 (5.95%) XML
6 4 (4.76%) AngularJS
7 3 (3.57%) .NET
7 3 (3.57%) JAX-RS
7 3 (3.57%) REST
8 1 (1.19%) COM
8 1 (1.19%) CSS
8 1 (1.19%) EJB
8 1 (1.19%) HTML
8 1 (1.19%) JSP
8 1 (1.19%) Servlets
8 1 (1.19%) Struts
8 1 (1.19%) XHTML
Miscellaneous
1 9 (10.71%) Analytical Skills
2 5 (5.95%) Data Structures
3 3 (3.57%) Computer Science
3 3 (3.57%) Life Science
4 2 (2.38%) Linked Data
4 2 (2.38%) Replication
5 1 (1.19%) Credit Risk
5 1 (1.19%) Mainframe
5 1 (1.19%) Management Information System
5 1 (1.19%) Public Cloud
5 1 (1.19%) Reference Data
5 1 (1.19%) RIA
5 1 (1.19%) Wiki
Operating Systems
1 8 (9.52%) Unix
2 6 (7.14%) Linux
3 1 (1.19%) Windows
Processes & Methodologies
1 84 (100.00%) Data Modelling
2 74 (88.10%) Logical Data Model
3 31 (36.90%) ETL
4 23 (27.38%) Agile Software Development
5 22 (26.19%) Business Intelligence
6 17 (20.24%) Data Cleansing
7 14 (16.67%) Data Analysis
8 13 (15.48%) Data Architecture
9 11 (13.10%) Coaching
9 11 (13.10%) Data Security
9 11 (13.10%) Migration
10 10 (11.90%) Analytics
10 10 (11.90%) Data Integration
10 10 (11.90%) Data Mapping
11 9 (10.71%) Data Lineage
11 9 (10.71%) Data Management
11 9 (10.71%) Information Architecture
11 9 (10.71%) Open Source
12 8 (9.52%) Collaborative Working
12 8 (9.52%) TOGAF
Programming Languages
1 41 (48.81%) SQL
2 20 (23.81%) PL/SQL
3 17 (20.24%) Java
4 12 (14.29%) T-SQL
5 6 (7.14%) JavaScript
6 5 (5.95%) Data Analysis Expressions (DAX)
6 5 (5.95%) Python
7 4 (4.76%) Perl
7 4 (4.76%) Shell Script
8 3 (3.57%) C#
9 2 (2.38%) R
9 2 (2.38%) Scala
10 1 (1.19%) ABAP
10 1 (1.19%) C
10 1 (1.19%) JCL
10 1 (1.19%) REXX
10 1 (1.19%) VB.NET
10 1 (1.19%) VBScript
Qualifications
1 13 (15.48%) Security Cleared
2 9 (10.71%) SC Cleared
3 6 (7.14%) ISEB
4 5 (5.95%) ISTQB
5 4 (4.76%) Degree
6 2 (2.38%) CTC Cleared
6 2 (2.38%) DV Cleared
7 1 (1.19%) OCPJP
Quality Assurance & Compliance
1 17 (20.24%) Data Quality
2 3 (3.57%) GDPR
3 2 (2.38%) QA
4 1 (1.19%) Disclosure Scotland
4 1 (1.19%) GAMP
4 1 (1.19%) IFRS
4 1 (1.19%) IFRS 9
System Software
1 5 (5.95%) Active Directory
2 3 (3.57%) Oracle RAC
3 1 (1.19%) Apache Flume
3 1 (1.19%) HDFS
Systems Management
1 3 (3.57%) Data Guard
1 3 (3.57%) Oracle Enterprise Manager
2 1 (1.19%) CA Endevor
2 1 (1.19%) Hadoop YARN
Vendors
1 25 (29.76%) Oracle
2 12 (14.29%) Informatica
2 12 (14.29%) Microsoft
3 8 (9.52%) MuleSoft
3 8 (9.52%) Salesforce.com
4 7 (8.33%) Sybase
5 6 (7.14%) IBM
6 5 (5.95%) Atlassian
7 4 (4.76%) Talend
8 3 (3.57%) Greenplum
8 3 (3.57%) Teradata
9 2 (2.38%) MicroStrategy
10 1 (1.19%) Ab Initio
10 1 (1.19%) Actian
10 1 (1.19%) Cloudera
10 1 (1.19%) Hortonworks
10 1 (1.19%) ParAccel
10 1 (1.19%) SAP
10 1 (1.19%) Tableau
10 1 (1.19%) TIBCO