The following table provides summary statistics for contract job vacancies advertised in Edinburgh with a requirement for Data Modelling skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Modelling over the 3 months to 24 June 2017 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.

Data Modelling
Scotland / Edinburgh
3 months to
24 Jun 2017
Same period 2016 Same period 2015
Rank 51 46 51
Rank change year-on-year -5 +5  
Contract jobs citing Data Modelling 29 54 39
As % of all contract IT jobs advertised in Edinburgh 2.43% 4.01% 2.69%
As % of the Processes & Methodologies category 2.91% 4.70% 3.26%
Number of daily rates quoted 17 32 17
Median daily rate £475 £463 £425
Median daily rate % change year-on-year +2.70% +8.82%  
90% offered a daily rate of more than £350 £370 £311
10% offered a daily rate of more than £550 £500 £590
UK excluding London median daily rate £425 £434 £423
% change year-on-year -2.01% +2.66%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £40.70 - £33.50

Data Modelling is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Edinburgh with a requirement for process and methodology skills.

Contract Process & Methodology Skills
Edinburgh
Contract job vacancies with a requirement for process and methodology skills 997 1148 1196
As % of all contract IT job vacancies advertised in Edinburgh 83.64% 85.23% 82.60%
Number of daily rates quoted 588 629 636
Median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.66%  
90% offered a daily rate of more than £300 £290 £275
10% offered a daily rate of more than £600 £525 £500
UK excluding London median daily rate £415 £400 £380
% change year-on-year +3.75% +5.26%  
Number of hourly rates quoted 9 7 16
Median hourly rate £15.86 £15.82 £35.00
Median hourly rate % change year-on-year +0.28% -54.81%  
90% offered a hourly rate of more than £14.50 £11.61 £12.52
10% offered a hourly rate of more than £43.39 £42.50 £42.50
UK excluding London median hourly rate £34.00 £28.50 £30.00
% change year-on-year +19.29% -5.00%  

Data Modelling
Job Vacancy Trend in Edinburgh

The job posting trend of jobs advertised in Edinburgh citing Data Modelling as a proportion of all contract or permanent IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for Data Modelling in Edinburgh

Data Modelling
Contractor Daily Rate Trend in Edinburgh

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Modelling in Edinburgh.

Contractor daily rate trend for Data Modelling in Edinburgh

Data Modelling
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing Data Modelling in Edinburgh over the 3 months to 24 June 2017.

Contractor daily rate histogram for Data Modelling in Edinburgh

Data Modelling
Contractor Hourly Rate Trend in Edinburgh

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

Contractor hourly rate trend for Data Modelling in Edinburgh

For the 6 months to 24 June 2017, IT contractor 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 contract ads across the Edinburgh region with a requirement for Data Modelling.

1 29 (60.42%) SQL
2 17 (35.42%) Finance
3 16 (33.33%) Data Management
4 15 (31.25%) ETL
4 15 (31.25%) Hadoop
5 14 (29.17%) SQL Server
6 12 (25.00%) Data Warehouse
6 12 (25.00%) Analytics
7 10 (20.83%) Big Data
7 10 (20.83%) SAS
8 9 (18.75%) Asset Management
8 9 (18.75%) Markit EDM
8 9 (18.75%) Relational Database
9 8 (16.67%) FactSet
9 8 (16.67%) Microsoft Analysis Services
9 8 (16.67%) SQL Server Reporting Services
9 8 (16.67%) Data Analysis
9 8 (16.67%) SQL Server Analysis Services
9 8 (16.67%) Banking
9 8 (16.67%) Bloomberg
10 6 (12.50%) Retail
10 6 (12.50%) ERwin
10 6 (12.50%) Retail Banking
11 5 (10.42%) Statistics
11 5 (10.42%) Data Architecture
11 5 (10.42%) SQL Server 2008
11 5 (10.42%) SQL Server 2012
11 5 (10.42%) HBase
11 5 (10.42%) Visualisation
11 5 (10.42%) Teradata

Data Modelling
Co-occurring IT Skills in Edinburgh 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 10 (20.83%) SAS
2 2 (4.17%) Apache Spark
Applications
1 2 (4.17%) MS Visio
2 1 (2.08%) Microsoft Excel
2 1 (2.08%) Microsoft PowerPoint
2 1 (2.08%) Microsoft Project
Business Applications
1 9 (18.75%) Markit EDM
Database & Business Intelligence
1 15 (31.25%) Hadoop
2 14 (29.17%) SQL Server
3 12 (25.00%) Data Warehouse
4 10 (20.83%) Big Data
5 9 (18.75%) Relational Database
6 8 (16.67%) Microsoft Analysis Services
6 8 (16.67%) SQL Server Analysis Services
6 8 (16.67%) SQL Server Reporting Services
7 5 (10.42%) HBase
7 5 (10.42%) OLAP
7 5 (10.42%) SQL Server 2008
7 5 (10.42%) SQL Server 2012
8 3 (6.25%) Apache Hive
8 3 (6.25%) MOLAP
8 3 (6.25%) RDBMS
9 2 (4.17%) Apache Cassandra
9 2 (4.17%) Data Lake
9 2 (4.17%) Oracle Database
10 1 (2.08%) Enterprise Data Warehouse
10 1 (2.08%) TKPROF
Development Applications
1 6 (12.50%) ERwin
2 2 (4.17%) XMLSpy
3 1 (2.08%) Oracle Forms
General
1 17 (35.42%) Finance
2 8 (16.67%) Banking
3 6 (12.50%) Retail
3 6 (12.50%) Retail Banking
4 4 (8.33%) Marketing
5 1 (2.08%) Legal
Job Titles
1 20 (41.67%) Analyst
2 9 (18.75%) Consultant
3 8 (16.67%) Data Modeller
4 6 (12.50%) Data Analyst
5 5 (10.42%) Architect
5 5 (10.42%) Business Analyst
5 5 (10.42%) Data Architect
5 5 (10.42%) Designer
5 5 (10.42%) Solutions Designer
6 4 (8.33%) Senior Analyst
7 3 (6.25%) Big Data Analyst
7 3 (6.25%) DBA
7 3 (6.25%) Developer
7 3 (6.25%) SQL DBA
7 3 (6.25%) Test Analyst
7 3 (6.25%) Test Data Analyst
8 2 (4.17%) Data Analytics Analyst
8 2 (4.17%) Database Analyst
8 2 (4.17%) Senior Test Analyst
8 2 (4.17%) Systems Analyst
Miscellaneous
1 4 (8.33%) Analytical Skills
2 3 (6.25%) Credit Risk
2 3 (6.25%) Taxonomies
3 2 (4.17%) Data Structures
3 2 (4.17%) Greenfield Project
4 1 (2.08%) Social Media
Operating Systems
1 1 (2.08%) Windows
Processes & Methodologies
1 16 (33.33%) Data Management
2 15 (31.25%) ETL
3 12 (25.00%) Analytics
4 9 (18.75%) Asset Management
5 8 (16.67%) Data Analysis
6 5 (10.42%) Business Intelligence
6 5 (10.42%) Data Architecture
6 5 (10.42%) Statistics
6 5 (10.42%) Visualisation
7 4 (8.33%) Agile Software Development
7 4 (8.33%) Data Visualisation
7 4 (8.33%) Logical Data Model
7 4 (8.33%) Migration
7 4 (8.33%) User Acceptance Testing
8 3 (6.25%) Business Analytics
8 3 (6.25%) MapReduce
8 3 (6.25%) Master Data Management
8 3 (6.25%) Performance Tuning
8 3 (6.25%) Scenario Testing
8 3 (6.25%) Use Case
Programming Languages
1 29 (60.42%) SQL
2 2 (4.17%) MATLAB
2 2 (4.17%) R
2 2 (4.17%) Scala
3 1 (2.08%) PL/SQL
Qualifications
1 3 (6.25%) MCITP
1 3 (6.25%) MCSA
1 3 (6.25%) Microsoft Certification
2 2 (4.17%) BPSS Clearance
2 2 (4.17%) Degree
2 2 (4.17%) Numerate Degree
3 1 (2.08%) Oracle Certification
Quality Assurance & Compliance
1 4 (8.33%) Disclosure Scotland
2 1 (2.08%) Data Quality
2 1 (2.08%) QA
Vendors
1 8 (16.67%) Bloomberg
1 8 (16.67%) FactSet
2 5 (10.42%) Oracle
2 5 (10.42%) Teradata
3 4 (8.33%) Cloudera
4 3 (6.25%) Microsoft
5 1 (2.08%) IBM
5 1 (2.08%) Pega
5 1 (2.08%) Splunk
5 1 (2.08%) Trillium