Period
to 20 November 2017

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

Extract, Transform and Load (ETL)
South West > Wiltshire
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 36 71 67
Rank change year-on-year +35 -4 -8
Contract jobs citing ETL 61 20 30
As % of all contract IT jobs advertised in Wiltshire 4.90% 1.57% 1.96%
As % of the Processes & Methodologies category 5.77% 1.91% 2.47%
Number of daily rates quoted 51 15 16
Wiltshire median daily rate £475 £415 £348
Median daily rate % change year-on-year +14.46% +19.42% -13.13%
10th Percentile £360 £300 £291
90th Percentile £731 £540 £475
South West median daily rate £425 £375 £363
% change year-on-year +13.33% +3.45% +9.85%
Number of hourly rates quoted 0 0 0
Wiltshire median hourly rate - - -
South West median hourly rate £55.00 £48.00 £30.00
% change year-on-year +14.58% +60.00% -21.57%

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

All Process and Methodology Skills
Wiltshire
Contract vacancies with a requirement for process or methodology skills 1058 1045 1213
As % of all contract IT jobs advertised in Wiltshire 85.05% 81.96% 79.23%
Number of daily rates quoted 713 756 830
Wiltshire median daily rate £425 £400 £385
Median daily rate % change year-on-year +6.25% +3.90% -3.75%
10th Percentile £290 £257 £255
90th Percentile £590 £575 £538
South West median daily rate £400 £375 £375
% change year-on-year +6.67% - -
Number of hourly rates quoted 16 23 33
Wiltshire median hourly rate £33.50 £38.50 £34.00
Median hourly rate % change year-on-year -12.99% +13.24% +23.64%
10th Percentile £13.00 £13.30 £13.83
90th Percentile £40.75 £47.50 £45.65
South West median hourly rate £35.00 £31.50 £38.89
% change year-on-year +11.11% -18.99% +49.56%

ETL
Job Vacancy Trend in Wiltshire

Job postings citing ETL as a percentage of all IT jobs advertised in Wiltshire.

Job vacancy trend for ETL in Wiltshire

ETL
Contractor Daily Rate Trend in Wiltshire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in Wiltshire.

Contractor daily rate trend for ETL in Wiltshire

ETL
Contractor Daily Rate Histogram in Wiltshire

The daily rate distribution of IT jobs citing ETL in Wiltshire over the 6 months to 20 November 2017.

Contractor daily rate histogram for ETL in Wiltshire

ETL
Contractor Hourly Rate Trend in Wiltshire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL in Wiltshire.

Contractor hourly rate trend for ETL in Wiltshire

ETL
Contract Job Locations in Wiltshire

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the Wiltshire region over the 6 months to 20 November 2017. 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
Swindon +38 48 £481 +11.92%
Corsham - 2 - -
Warminster - 1 £475 -
ETL
South West

For the 6 months to 20 November 2017, IT contractor jobs citing ETL 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 Wiltshire region with a requirement for ETL.

1 36 (59.02%) Data Warehouse
2 21 (34.43%) Finance
3 19 (31.15%) SQL
4 18 (29.51%) Data Modelling
5 17 (27.87%) Business Intelligence
5 17 (27.87%) SQL Server Integration Services
6 16 (26.23%) Data Analysis
7 15 (24.59%) Agile Software Development
8 14 (22.95%) Open Source
9 13 (21.31%) SQL Server
10 11 (18.03%) Oracle
10 11 (18.03%) Informatica
10 11 (18.03%) Oracle BI EE
10 11 (18.03%) Analytics
10 11 (18.03%) DevOps
11 10 (16.39%) Enterprise Data Warehouse
11 10 (16.39%) Kimball Methodology
12 9 (14.75%) Migration
12 9 (14.75%) Oracle ODI
13 8 (13.11%) Analytical Skills
13 8 (13.11%) Apache Pig
13 8 (13.11%) Big Data
13 8 (13.11%) Apache Hive
13 8 (13.11%) Hadoop
13 8 (13.11%) Enterprise Architecture
13 8 (13.11%) Dimensional Modelling
14 7 (11.48%) JIRA
14 7 (11.48%) Data Migration
14 7 (11.48%) Teradata
14 7 (11.48%) Shell Script

ETL
Co-occurring IT Skills in Wiltshire 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 8 (13.11%) Apache Pig
2 7 (11.48%) SAS
3 2 (3.28%) Confluence
4 1 (1.64%) CMS
Applications
1 2 (3.28%) SPSS
Business Applications
1 2 (3.28%) Salesforce.com CRM
Cloud Services
1 4 (6.56%) Amazon AWS
1 4 (6.56%) Microsoft Azure
2 3 (4.92%) Boomi
3 1 (1.64%) GitHub
Database & Business Intelligence
1 36 (59.02%) Data Warehouse
2 17 (27.87%) SQL Server Integration Services
3 13 (21.31%) SQL Server
4 11 (18.03%) Oracle BI EE
5 10 (16.39%) Enterprise Data Warehouse
6 9 (14.75%) Oracle ODI
7 8 (13.11%) Apache Hive
7 8 (13.11%) Big Data
7 8 (13.11%) Hadoop
8 7 (11.48%) Star Schema
9 5 (8.20%) Amazon Redshift
9 5 (8.20%) Power BI
9 5 (8.20%) SQL Server Analysis Services
9 5 (8.20%) SQL Server Reporting Services
10 4 (6.56%) Data Mining
10 4 (6.56%) SAS Data Integration Studio
10 4 (6.56%) SQL Server 2016
11 3 (4.92%) BusinessObjects
11 3 (4.92%) DataStage
11 3 (4.92%) MySQL
Development Applications
1 7 (11.48%) JIRA
2 2 (3.28%) Talend Open Studio
3 1 (1.64%) Ant
3 1 (1.64%) Eclipse
3 1 (1.64%) ERwin
3 1 (1.64%) Git (software)
General
1 21 (34.43%) Finance
2 6 (9.84%) Marketing
3 4 (6.56%) Back Office
3 4 (6.56%) Retail
4 2 (3.28%) Banking
Job Titles
1 22 (36.07%) Developer
2 16 (26.23%) Architect
3 10 (16.39%) ETL Developer
4 8 (13.11%) Enterprise Architect
5 7 (11.48%) SSIS Developer
6 6 (9.84%) Consultant
7 4 (6.56%) Analyst
7 4 (6.56%) Data Architect
7 4 (6.56%) Designer
7 4 (6.56%) Enterprise Technical Architect
7 4 (6.56%) Salesforce Developer
7 4 (6.56%) SAS Developer
7 4 (6.56%) Technical Architect
8 3 (4.92%) Business Intelligence Architect
8 3 (4.92%) Business Intelligence Developer
8 3 (4.92%) Data Analyst
8 3 (4.92%) Senior Analyst
8 3 (4.92%) Senior Consultant
8 3 (4.92%) Senior Data Analyst
8 3 (4.92%) SQL Developer
Libraries, Frameworks & Software Standards
1 6 (9.84%) .NET
1 6 (9.84%) Velocity
1 6 (9.84%) Web Services
2 4 (6.56%) REST
3 3 (4.92%) Visualforce
3 3 (4.92%) WCF
4 2 (3.28%) SOAP
4 2 (3.28%) WSDL
4 2 (3.28%) XML
4 2 (3.28%) XSD
Miscellaneous
1 8 (13.11%) Analytical Skills
2 3 (4.92%) Greenfield Project
2 3 (4.92%) Management Information System
3 2 (3.28%) NHS
4 1 (1.64%) Data Structures
Operating Systems
1 7 (11.48%) Unix
Processes & Methodologies
1 18 (29.51%) Data Modelling
2 17 (27.87%) Business Intelligence
3 16 (26.23%) Data Analysis
4 15 (24.59%) Agile Software Development
5 14 (22.95%) Open Source
6 11 (18.03%) Analytics
6 11 (18.03%) DevOps
7 10 (16.39%) Kimball Methodology
8 9 (14.75%) Migration
9 8 (13.11%) Dimensional Modelling
9 8 (13.11%) Enterprise Architecture
10 7 (11.48%) Data Migration
11 6 (9.84%) Data Architecture
11 6 (9.84%) Data Ingestion
11 6 (9.84%) Stakeholder Management
11 6 (9.84%) Technical Architecture
12 5 (8.20%) Information Management
12 5 (8.20%) Mentoring
12 5 (8.20%) SOA
12 5 (8.20%) TOGAF
Programming Languages
1 19 (31.15%) SQL
2 7 (11.48%) Shell Script
3 6 (9.84%) Java
4 3 (4.92%) Apex Code
4 3 (4.92%) C#
4 3 (4.92%) JavaScript
4 3 (4.92%) T-SQL
5 2 (3.28%) PL/SQL
5 2 (3.28%) R
Qualifications
1 3 (4.92%) ISTQB
2 1 (1.64%) BPSS Clearance
2 1 (1.64%) MCSA
2 1 (1.64%) MCSE
2 1 (1.64%) Microsoft Certification
2 1 (1.64%) SC Cleared
2 1 (1.64%) Security Cleared
Quality Assurance & Compliance
1 5 (8.20%) QA
2 4 (6.56%) GDPR
2 4 (6.56%) IFRS
2 4 (6.56%) IFRS 9
3 1 (1.64%) Data Quality
Vendors
1 11 (18.03%) Informatica
1 11 (18.03%) Oracle
2 7 (11.48%) Microsoft
2 7 (11.48%) Teradata
3 6 (9.84%) Salesforce.com
4 3 (4.92%) Dell
5 2 (3.28%) SAP
5 2 (3.28%) Tableau
5 2 (3.28%) Talend
6 1 (1.64%) IBM