Period
to 20 April 2018

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

Data Analysis
Scotland > Edinburgh
6 months to
20 Apr 2018
Same period 2017 Same period 2016
Rank 34 70 65
Rank change year-on-year +36 -5 -7
Contract jobs citing Data Analysis 118 39 72
As % of all contract IT jobs advertised in Edinburgh 4.20% 2.11% 2.48%
As % of the Processes & Methodologies category 4.82% 2.44% 2.93%
Number of daily rates quoted 75 27 34
Edinburgh median daily rate £400 £375 £410
Median daily rate % change year-on-year +6.67% -8.54% +2.50%
10th Percentile £303 £309 £291
90th Percentile £475 £433 £493
Scotland median daily rate £390 £365 £375
% change year-on-year +6.85% -2.67% -6.25%
Number of hourly rates quoted 1 0 0
Edinburgh median hourly rate £187.50 - -
Scotland median hourly rate £187.50 £17.32 £22.10
% change year-on-year +982.56% -21.64% -34.51%

Data Analysis 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 Edinburgh with a requirement for process or methodology skills.

All Process and Methodology Skills
Edinburgh
Contract vacancies with a requirement for process or methodology skills 2,448 1,597 2,455
As % of all contract IT jobs advertised in Edinburgh 87.09% 86.32% 84.39%
Number of daily rates quoted 1,473 998 1,330
Edinburgh median daily rate £410 £400 £400
Median daily rate % change year-on-year +2.50% - +3.23%
10th Percentile £288 £263 £270
90th Percentile £575 £550 £563
Scotland median daily rate £400 £375 £380
% change year-on-year +6.67% -1.32% +1.33%
Number of hourly rates quoted 20 21 14
Edinburgh median hourly rate £28.00 £18.00 £22.75
Median hourly rate % change year-on-year +55.56% -20.88% -28.35%
10th Percentile £14.59 £13.00 £14.13
90th Percentile £119.33 £47.23 £42.43
Scotland median hourly rate £21.00 £17.45 £33.71
% change year-on-year +20.38% -48.25% +23.14%

Data Analysis
Job Vacancy Trend in Edinburgh

Job postings citing Data Analysis as a percentage of all IT jobs advertised in Edinburgh.

Job vacancy trend for Data Analysis in Edinburgh

Data Analysis
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for Data Analysis in Edinburgh

Data Analysis
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing Data Analysis in Edinburgh over the 6 months to 20 April 2018.

Contractor daily rate histogram for Data Analysis in Edinburgh

Data Analysis
Contractor Hourly Rate Trend in Edinburgh

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

Contractor hourly rate trend for Data Analysis in Edinburgh

For the 6 months to 20 April 2018, IT contractor jobs citing Data Analysis 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 Edinburgh region with a requirement for Data Analysis.

1 66 (55.93%) Finance
2 57 (48.31%) SQL
3 48 (40.68%) Banking
4 40 (33.90%) Stakeholder Management
5 35 (29.66%) ETL
6 33 (27.97%) Migration
7 31 (26.27%) Agile Software Development
8 30 (25.42%) Oracle
9 27 (22.88%) Data Modelling
9 27 (22.88%) Data Quality
10 26 (22.03%) Data Migration
11 23 (19.49%) ETL Development
11 23 (19.49%) Data Warehouse
12 22 (18.64%) Informatica
13 20 (16.95%) Teradata
13 20 (16.95%) PowerCenter
14 19 (16.10%) Hadoop
15 18 (15.25%) Business Analysis
16 17 (14.41%) Unix
16 17 (14.41%) Oracle Database
17 14 (11.86%) Analytical Skills
17 14 (11.86%) SQL Server
17 14 (11.86%) PowerExchange
18 12 (10.17%) PL/SQL
18 12 (10.17%) Microsoft Excel
18 12 (10.17%) ERwin
18 12 (10.17%) CA
18 12 (10.17%) SAS
19 11 (9.32%) Data Integration
20 10 (8.47%) JIRA

Data Analysis
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 14 (11.86%) PowerExchange
2 12 (10.17%) SAS
3 7 (5.93%) Confluence
4 4 (3.39%) SharePoint
5 1 (0.85%) Apache Pig
5 1 (0.85%) Apache Spark
Applications
1 12 (10.17%) Microsoft Excel
2 3 (2.54%) Microsoft Office
3 1 (0.85%) Microsoft PowerPoint
3 1 (0.85%) Spreadsheet
Business Applications
1 4 (3.39%) thinkFolio
2 1 (0.85%) HiPortfolio
2 1 (0.85%) Markit EDM
2 1 (0.85%) MultiFonds
Cloud Services
1 1 (0.85%) Cloud Computing
1 1 (0.85%) Google Analytics
Communications & Networking
1 1 (0.85%) SMS
Database & Business Intelligence
1 23 (19.49%) Data Warehouse
2 20 (16.95%) PowerCenter
3 19 (16.10%) Hadoop
4 17 (14.41%) Oracle Database
5 14 (11.86%) SQL Server
6 8 (6.78%) Data Lake
7 7 (5.93%) Big Data
8 4 (3.39%) Pentaho
8 4 (3.39%) SQL Server Analysis Services
8 4 (3.39%) SQL Server Integration Services
8 4 (3.39%) SQL Server Reporting Services
9 3 (2.54%) BusinessObjects
9 3 (2.54%) Enterprise Data Warehouse
9 3 (2.54%) Microsoft Analysis Services
9 3 (2.54%) Parquet
10 2 (1.69%) Relational Database
11 1 (0.85%) Apache Hive
11 1 (0.85%) Data Mining
11 1 (0.85%) QlikView
11 1 (0.85%) SAS Enterprise Guide
Development Applications
1 12 (10.17%) ERwin
2 10 (8.47%) JIRA
3 1 (0.85%) Git (software)
3 1 (0.85%) Jenkins
3 1 (0.85%) JIRA Agile
3 1 (0.85%) Oracle APEX
3 1 (0.85%) Oracle Forms
General
1 66 (55.93%) Finance
2 48 (40.68%) Banking
3 6 (5.08%) Legal
4 4 (3.39%) Front Office
4 4 (3.39%) Retail Banking
5 2 (1.69%) Corporate Banking
5 2 (1.69%) Financial Institution
5 2 (1.69%) Investment Banking
6 1 (0.85%) Billing
6 1 (0.85%) General Ledger
6 1 (0.85%) Private Banking
6 1 (0.85%) Retail
Job Titles
1 63 (53.39%) Analyst
2 36 (30.51%) Business Analyst
3 30 (25.42%) Developer
4 21 (17.80%) Data Analyst
5 20 (16.95%) Informatica Developer
6 9 (7.63%) Consultant
7 7 (5.93%) Data Business Analyst
8 6 (5.08%) Senior Analyst
8 6 (5.08%) Technical Analyst
9 5 (4.24%) Business Manager
9 5 (4.24%) Lead Developer
10 4 (3.39%) Agile Business Analyst
10 4 (3.39%) Business Data Analyst
10 4 (3.39%) Digital Transformation
10 4 (3.39%) Digital Transformation Consultant
10 4 (3.39%) ETL Developer
10 4 (3.39%) Front Office Business Analyst
10 4 (3.39%) Senior Business Analyst
10 4 (3.39%) Technical Business Analyst
10 4 (3.39%) Transformation Consultant
Libraries, Frameworks & Software Standards
1 4 (3.39%) FIX Protocol
2 3 (2.54%) ActiveMQ
3 1 (0.85%) Elastic Stack
3 1 (0.85%) PostGIS
Miscellaneous
1 14 (11.86%) Analytical Skills
2 8 (6.78%) Mainframe
3 5 (4.24%) Equities
3 5 (4.24%) Fixed Income
4 3 (2.54%) Computer Science
4 3 (2.54%) Enterprise Software
4 3 (2.54%) Online Banking
5 2 (1.69%) Data Structures
5 2 (1.69%) Management Information System
6 1 (0.85%) Credit Risk
6 1 (0.85%) Driving Licence
6 1 (0.85%) Foreign Exchange (FX)
6 1 (0.85%) Freedom of Information
6 1 (0.85%) Greenfield Project
6 1 (0.85%) VSAM
Operating Systems
1 17 (14.41%) Unix
2 1 (0.85%) Linux
Processes & Methodologies
1 40 (33.90%) Stakeholder Management
2 35 (29.66%) ETL
3 33 (27.97%) Migration
4 31 (26.27%) Agile Software Development
5 27 (22.88%) Data Modelling
6 26 (22.03%) Data Migration
7 23 (19.49%) ETL Development
8 18 (15.25%) Business Analysis
9 11 (9.32%) Data Integration
10 10 (8.47%) Business Intelligence
11 9 (7.63%) Analytics
11 9 (7.63%) Data Mapping
12 7 (5.93%) Data Governance
13 6 (5.08%) Data Architecture
13 6 (5.08%) Performance Tuning
13 6 (5.08%) Waterfall
14 5 (4.24%) Coaching
14 5 (4.24%) DevOps
14 5 (4.24%) Mentoring
14 5 (4.24%) Target Operating Model
Programming Languages
1 57 (48.31%) SQL
2 12 (10.17%) PL/SQL
3 5 (4.24%) Java
4 4 (3.39%) Python
5 1 (0.85%) MATLAB
5 1 (0.85%) Perl
5 1 (0.85%) R
5 1 (0.85%) Scala
5 1 (0.85%) VBA
Qualifications
1 4 (3.39%) Degree
2 1 (0.85%) ISEB
2 1 (0.85%) Numerate Degree
Quality Assurance & Compliance
1 27 (22.88%) Data Quality
2 6 (5.08%) Disclosure Scotland
2 6 (5.08%) QA
3 2 (1.69%) GDPR
3 2 (1.69%) PMO
4 1 (0.85%) FATCA
4 1 (0.85%) MiFID
System Software
1 1 (0.85%) Docker
Systems Management
1 4 (3.39%) Oracle Flashback
2 3 (2.54%) Kibana
3 1 (0.85%) Ambari
3 1 (0.85%) Ansible
Vendors
1 30 (25.42%) Oracle
2 22 (18.64%) Informatica
3 20 (16.95%) Teradata
4 12 (10.17%) CA
5 4 (3.39%) Charles River
5 4 (3.39%) Microsoft
6 3 (2.54%) Planview
7 2 (1.69%) Misys
8 1 (0.85%) Google
8 1 (0.85%) Sybase
8 1 (0.85%) Tableau
8 1 (0.85%) Twitter