Period
to 20 June 2018

The following table provides summary statistics for contract job vacancies advertised in Scotland 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 June 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
UK > Scotland
6 months to
20 Jun 2018
Same period 2017 Same period 2016
Rank 64 62 106
Rank change year-on-year -2 +44 -63
Contract jobs citing Data Analysis 165 108 102
As % of all contract IT jobs advertised in Scotland 3.13% 2.82% 1.86%
As % of the Processes & Methodologies category 3.66% 3.34% 2.16%
Number of daily rates quoted 100 58 57
Scotland median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - -1.32%
10th Percentile £246 £275 £225
90th Percentile £489 £488 £485
UK median daily rate £450 £432 £400
% change year-on-year +4.23% +7.94% -
Number of hourly rates quoted 1 2 4
Scotland median hourly rate £187.50 £14.91 £13.75
Median hourly rate % change year-on-year +1157.55% +8.44% -60.71%
10th Percentile £181.25 £11.86 £10.53
90th Percentile £193.75 £16.96 £25.78
UK median hourly rate £25.00 £19.50 £17.75
% change year-on-year +28.21% +9.86% -19.32%

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

All Process and Methodology Skills
Scotland
Contract vacancies with a requirement for process or methodology skills 4,509 3,233 4,712
As % of all contract IT jobs advertised in Scotland 85.54% 84.54% 85.75%
Number of daily rates quoted 2,710 1,891 2,637
Scotland median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - -
10th Percentile £261 £250 £235
90th Percentile £546 £513 £525
UK median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% +6.25%
Number of hourly rates quoted 89 73 91
Scotland median hourly rate £17.50 £26.00 £36.00
Median hourly rate % change year-on-year -32.69% -27.78% +20.00%
10th Percentile £10.56 £11.30 £11.25
90th Percentile £55.25 £47.08 £43.75
UK median hourly rate £21.50 £25.00 £25.00
% change year-on-year -14.00% - +17.37%

Data Analysis
Job Vacancy Trend in Scotland

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

Job vacancy trend for Data Analysis in Scotland

Data Analysis
Contractor Daily Rate Trend in Scotland

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

Contractor daily rate trend for Data Analysis in Scotland

Data Analysis
Contractor Daily Rate Histogram in Scotland

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

Contractor daily rate histogram for Data Analysis in Scotland

Data Analysis
Contractor Hourly Rate Trend in Scotland

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

Contractor hourly rate trend for Data Analysis in Scotland

Data Analysis
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Data Analysis within the Scotland region over the 6 months to 20 June 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
Edinburgh +4 99 £400 +6.67% 6
Glasgow -11 50 £350 +7.69% 5
Stirling 0 11 £450 -5.26% 1
Inverclyde -2 1 £355 -25.26%
Dundee -7 1 £258 -
North Lanarkshire - 1 - -
Data Analysis
UK

For the 6 months to 20 June 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 Scotland region with a requirement for Data Analysis.

1 86 (52.12%) Finance
2 81 (49.09%) SQL
3 51 (30.91%) Oracle
4 50 (30.30%) Migration
5 45 (27.27%) Banking
6 42 (25.45%) Agile Software Development
6 42 (25.45%) Analytical Skills
7 39 (23.64%) Data Migration
8 38 (23.03%) ETL
9 37 (22.42%) Stakeholder Management
10 34 (20.61%) Data Quality
11 30 (18.18%) Data Warehouse
12 29 (17.58%) Problem-Solving
13 28 (16.97%) Data Modelling
14 27 (16.36%) Business Intelligence
15 25 (15.15%) Unix
16 24 (14.55%) Oracle Database
17 23 (13.94%) Analytics
17 23 (13.94%) Microsoft Excel
17 23 (13.94%) Microsoft
18 22 (13.33%) Business Analysis
19 21 (12.73%) ETL Development
20 20 (12.12%) Informatica
20 20 (12.12%) Workflow
21 19 (11.52%) PL/SQL
22 18 (10.91%) Project Management
22 18 (10.91%) Teradata
22 18 (10.91%) Hadoop
23 17 (10.30%) QA
23 17 (10.30%) PowerCenter

Data Analysis
Co-occurring IT Skills in Scotland 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 (8.48%) SAS
2 13 (7.88%) PowerExchange
3 5 (3.03%) Confluence
3 5 (3.03%) SharePoint
4 2 (1.21%) Apache Spark
5 1 (0.61%) Apache Pig
5 1 (0.61%) Oracle SOA Suite
5 1 (0.61%) Oracle Workflow
Applications
1 23 (13.94%) Microsoft Excel
2 8 (4.85%) Microsoft PowerPoint
3 6 (3.64%) Microsoft Office
4 4 (2.42%) MS Visio
5 2 (1.21%) SPSS
6 1 (0.61%) Microsoft Project
6 1 (0.61%) Spreadsheet
Business Applications
1 10 (6.06%) Sonata
2 6 (3.64%) Dynamics AX
3 5 (3.03%) Oracle BPM
4 4 (2.42%) AquaLogic BPM
4 4 (2.42%) thinkFolio
5 2 (1.21%) Oracle EBS
5 2 (1.21%) Oracle EBS R12
6 1 (0.61%) HiPortfolio
6 1 (0.61%) MultiFonds
6 1 (0.61%) Oracle 11i
Cloud Services
1 3 (1.82%) Azure Data Factory
1 3 (1.82%) Cloud Computing
1 3 (1.82%) Microsoft Azure
2 2 (1.21%) Dynamics 365
3 1 (0.61%) Google Analytics
3 1 (0.61%) Serverless
Communications & Networking
1 1 (0.61%) SMS
Database & Business Intelligence
1 30 (18.18%) Data Warehouse
2 24 (14.55%) Oracle Database
3 18 (10.91%) Hadoop
4 17 (10.30%) PowerCenter
5 11 (6.67%) QlikView
6 10 (6.06%) BusinessObjects
6 10 (6.06%) Power BI
6 10 (6.06%) SQL Server
7 9 (5.45%) Big Data
7 9 (5.45%) SQL Server Reporting Services
8 8 (4.85%) Data Lake
9 7 (4.24%) SQL Server Integration Services
10 6 (3.64%) Relational Database
11 5 (3.03%) Pentaho
12 4 (2.42%) Microsoft Analysis Services
12 4 (2.42%) RDBMS
12 4 (2.42%) SQL Server Analysis Services
13 3 (1.82%) DB2
13 3 (1.82%) Oracle Database 11g
14 2 (1.21%) Apache Hive
Development Applications
1 12 (7.27%) JIRA
2 10 (6.06%) ERwin
3 2 (1.21%) ClearCase
3 2 (1.21%) Eclipse
3 2 (1.21%) Hudson
3 2 (1.21%) MagicDraw
3 2 (1.21%) Subversion
4 1 (0.61%) Git (software)
4 1 (0.61%) Jenkins
4 1 (0.61%) JIRA Agile
4 1 (0.61%) Oracle APEX
4 1 (0.61%) Oracle Forms
General
1 86 (52.12%) Finance
2 45 (27.27%) Banking
3 8 (4.85%) Front Office
4 7 (4.24%) Investment Banking
5 5 (3.03%) Legal
6 2 (1.21%) Financial Institution
6 2 (1.21%) Manufacturing
6 2 (1.21%) Retail Banking
7 1 (0.61%) Marketing
7 1 (0.61%) Private Banking
7 1 (0.61%) Retail
Job Titles
1 95 (57.58%) Analyst
2 43 (26.06%) Business Analyst
3 40 (24.24%) Developer
4 35 (21.21%) Data Analyst
5 17 (10.30%) Informatica Developer
6 10 (6.06%) Consultant
6 10 (6.06%) Support Analyst
7 9 (5.45%) Applications Support
7 9 (5.45%) Applications Support Analyst
7 9 (5.45%) Java Developer
8 6 (3.64%) ETL Developer
8 6 (3.64%) Lead Developer
8 6 (3.64%) Migration Analyst
8 6 (3.64%) Senior Analyst
9 5 (3.03%) Agile Business Analyst
9 5 (3.03%) Data Business Analyst
9 5 (3.03%) Oracle Developer
9 5 (3.03%) Report Analyst
9 5 (3.03%) Senior Business Analyst
9 5 (3.03%) Technical Analyst
Libraries, Frameworks & Software Standards
1 9 (5.45%) Hibernate
1 9 (5.45%) Spring
2 7 (4.24%) Apache Camel
2 7 (4.24%) Apache MINA
2 7 (4.24%) JMS
2 7 (4.24%) SOAP
2 7 (4.24%) XML
3 4 (2.42%) ActiveMQ
3 4 (2.42%) FIX Protocol
4 2 (1.21%) J2EE
5 1 (0.61%) PostGIS
Miscellaneous
1 42 (25.45%) Analytical Skills
2 8 (4.85%) Derivative
3 7 (4.24%) Data Structures
3 7 (4.24%) Self-Motivation
4 5 (3.03%) Equities
4 5 (3.03%) Fixed Income
4 5 (3.03%) Mainframe
5 4 (2.42%) Equity Derivative
5 4 (2.42%) Management Information System
5 4 (2.42%) OTC Derivatives
5 4 (2.42%) Reference Data
6 3 (1.82%) Computer Science
6 3 (1.82%) Credit Risk
7 2 (1.21%) Online Banking
7 2 (1.21%) User Experience
8 1 (0.61%) Algorithms
8 1 (0.61%) Cyberthreat
8 1 (0.61%) Driving Licence
8 1 (0.61%) Freedom of Information
8 1 (0.61%) Market Risk
Operating Systems
1 25 (15.15%) Unix
2 1 (0.61%) Linux
Processes & Methodologies
1 50 (30.30%) Migration
2 42 (25.45%) Agile Software Development
3 39 (23.64%) Data Migration
4 38 (23.03%) ETL
5 37 (22.42%) Stakeholder Management
6 29 (17.58%) Problem-Solving
7 28 (16.97%) Data Modelling
8 27 (16.36%) Business Intelligence
9 23 (13.94%) Analytics
10 22 (13.33%) Business Analysis
11 21 (12.73%) ETL Development
12 20 (12.12%) Workflow
13 18 (10.91%) Project Management
14 14 (8.48%) Scrum
15 11 (6.67%) Data Analytics
15 11 (6.67%) Risk Management
15 11 (6.67%) Wealth Management
16 10 (6.06%) Mentoring
17 9 (5.45%) Data Integration
17 9 (5.45%) Data Mapping
Programming Languages
1 81 (49.09%) SQL
2 19 (11.52%) PL/SQL
3 17 (10.30%) Java
4 11 (6.67%) Python
5 7 (4.24%) XPath
6 2 (1.21%) R
6 2 (1.21%) VBA
7 1 (0.61%) C++
7 1 (0.61%) MATLAB
7 1 (0.61%) Perl
7 1 (0.61%) Scala
7 1 (0.61%) T-SQL
Qualifications
1 12 (7.27%) Degree
2 1 (0.61%) CISA
2 1 (0.61%) CISSP
2 1 (0.61%) CRISC
2 1 (0.61%) ISEB
Quality Assurance & Compliance
1 34 (20.61%) Data Quality
2 17 (10.30%) QA
3 6 (3.64%) Disclosure Scotland
3 6 (3.64%) PMO
4 4 (2.42%) Dodd-Frank
4 4 (2.42%) EMIR
4 4 (2.42%) MiFID
System Software
1 1 (0.61%) Docker
1 1 (0.61%) HDFS
Systems Management
1 5 (3.03%) Oracle Flashback
2 1 (0.61%) Ambari
2 1 (0.61%) Ansible
Vendors
1 51 (30.91%) Oracle
2 23 (13.94%) Microsoft
3 20 (12.12%) Informatica
4 18 (10.91%) Teradata
5 10 (6.06%) CA
5 10 (6.06%) FNZ
6 9 (5.45%) Tableau
7 4 (2.42%) Charles River
8 3 (1.82%) Planview
9 1 (0.61%) AppDynamics
9 1 (0.61%) Cloudera
9 1 (0.61%) Google
9 1 (0.61%) Splunk
9 1 (0.61%) Sybase
9 1 (0.61%) Twitter