Period
to 23 January 2018

The following table provides summary statistics for permanent job vacancies advertised in the South West with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 23 January 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > South West
6 months to
23 Jan 2018
Same period 2017 Same period 2016
Rank 122 175 154
Rank change year-on-year +53 -21 -1
Permanent jobs citing ETL 279 176 232
As % of all permanent IT jobs advertised in the South West 2.75% 1.69% 2.03%
As % of the Processes & Methodologies category 3.09% 1.89% 2.26%
Number of salaries quoted 228 135 190
South West median annual salary £40,000 £42,500 £45,000
Median salary % change year-on-year -5.88% -5.56% +8.43%
10th Percentile £29,600 £32,900 £26,250
90th Percentile £57,875 £62,000 £67,625
England median annual salary £50,000 £52,500 £51,000
% change year-on-year -4.76% +2.94% -2.86%

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the South West with a requirement for process or methodology skills.

All Process and Methodology Skills
South West
Permanent vacancies with a requirement for process or methodology skills 9,038 9,305 10,276
As % of all permanent IT jobs advertised in the South West 89.06% 89.49% 89.71%
Number of salaries quoted 7,399 7,703 8,599
South West median annual salary £42,500 £41,500 £40,000
Median salary % change year-on-year +2.41% +3.75% +3.90%
10th Percentile £26,250 £26,250 £25,750
90th Percentile £63,750 £65,000 £63,750
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

ETL
Job Vacancy Trend in the South West

Job postings citing ETL as a percentage of all IT jobs advertised in the South West.

Job vacancy trend for ETL in the South West

ETL
Salary Trend in the South West

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL in the South West.

Salary trend for ETL in the South West

ETL
Salary Histogram in the South West

The salary distribution of IT jobs citing ETL in the South West over the 6 months to 23 January 2018.

Salary histogram for ETL in the South West

ETL
Job Locations in the South West

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the South West region over the 6 months to 23 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Bristol +37 116 £44,471 +4.64% 15
Somerset -4 46 £36,000 -8.86% 4
Dorset +11 41 £42,250 -39.64% 6
Wiltshire +13 32 £40,000 -20.00% 2
Gloucestershire +33 24 £41,250 -19.51% 5
Cornwall -16 10 £27,500 -
Devon +13 5 £40,750 -4.12% 3
ETL
England

For the 6 months to 23 January 2018, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the South West region with a requirement for ETL.

1 236 (84.59%) SQL
2 200 (71.68%) Business Intelligence
3 164 (58.78%) Data Warehouse
4 156 (55.91%) SQL Server
5 146 (52.33%) SQL Server Integration Services
6 125 (44.80%) SQL Server Reporting Services
7 109 (39.07%) T-SQL
8 101 (36.20%) Microsoft
9 79 (28.32%) Power BI
10 70 (25.09%) Agile Software Development
11 69 (24.73%) Microsoft Azure
12 68 (24.37%) Analytics
13 63 (22.58%) Data Modelling
14 58 (20.79%) Amazon AWS
15 54 (19.35%) C#
16 50 (17.92%) Visualisation
16 50 (17.92%) SQL Server Analysis Services
17 49 (17.56%) Migration
18 48 (17.20%) BusinessObjects
19 47 (16.85%) Java
20 46 (16.49%) Tableau
21 45 (16.13%) Python
22 40 (14.34%) Microsoft Excel
22 40 (14.34%) Data Management
23 39 (13.98%) Data Visualisation
24 38 (13.62%) Finance
25 36 (12.90%) Stakeholder Management
25 36 (12.90%) SQL Server 2014
25 36 (12.90%) Data Migration
26 35 (12.54%) Analytical Skills

ETL
Co-occurring IT Skills in the South West 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 34 (12.19%) Apache Spark
2 29 (10.39%) Elasticsearch
3 18 (6.45%) SharePoint
4 13 (4.66%) Apache Pig
5 4 (1.43%) CMS
5 4 (1.43%) Oracle SOA Suite
6 3 (1.08%) Oracle Workflow
7 2 (0.72%) IIS
7 2 (0.72%) Kentico
8 1 (0.36%) BizTalk Server
8 1 (0.36%) Drupal
8 1 (0.36%) GeoServer
8 1 (0.36%) Oracle 10gAS
8 1 (0.36%) WebLogic
8 1 (0.36%) WebSphere
Applications
1 40 (14.34%) Microsoft Excel
2 6 (2.15%) Microsoft Office
3 3 (1.08%) SPSS
3 3 (1.08%) SPSS Modeler
4 1 (0.36%) MS Visio
Business Applications
1 6 (2.15%) Oracle EBS
1 6 (2.15%) Oracle EBS R12
2 4 (1.43%) Oracle ERP
2 4 (1.43%) SAP Business ByDesign
2 4 (1.43%) SAP Business One
3 3 (1.08%) Cognos Business Intelligence
3 3 (1.08%) Dynamics CRM
3 3 (1.08%) Oracle Applications
4 2 (0.72%) Dynamics AX
5 1 (0.36%) Dynamics NAV
5 1 (0.36%) Oracle 11i
5 1 (0.36%) Oracle BPM
Cloud Services
1 69 (24.73%) Microsoft Azure
2 58 (20.79%) Amazon AWS
3 29 (10.39%) Amazon EMR
4 28 (10.04%) Amazon Kinesis
5 16 (5.73%) GitHub
6 9 (3.23%) Google Cloud Platform
7 6 (2.15%) Azure Data Factory
8 5 (1.79%) IaaS
8 5 (1.79%) PaaS
9 3 (1.08%) Office 365
10 2 (0.72%) Amazon EC2
10 2 (0.72%) Cloud Computing
10 2 (0.72%) SaaS
10 2 (0.72%) Virtual Private Cloud
11 1 (0.36%) AWS Data Pipeline
11 1 (0.36%) Cortana Intelligence Suite
Communications & Networking
1 3 (1.08%) Internet
2 2 (0.72%) AMQP
2 2 (0.72%) Ethernet
2 2 (0.72%) SMS
2 2 (0.72%) Wireless
Database & Business Intelligence
1 164 (58.78%) Data Warehouse
2 156 (55.91%) SQL Server
3 146 (52.33%) SQL Server Integration Services
4 125 (44.80%) SQL Server Reporting Services
5 79 (28.32%) Power BI
6 50 (17.92%) SQL Server Analysis Services
7 48 (17.20%) BusinessObjects
8 36 (12.90%) SQL Server 2014
9 34 (12.19%) SQL Server 2012
10 33 (11.83%) Amazon Redshift
11 32 (11.47%) Big Data
12 30 (10.75%) QlikView
13 28 (10.04%) Amazon Athena
13 28 (10.04%) Hadoop
14 27 (9.68%) BigQuery
15 19 (6.81%) Relational Database
16 18 (6.45%) MySQL
17 17 (6.09%) Crystal Reports
17 17 (6.09%) Data Mining
17 17 (6.09%) Enterprise Data Warehouse
Development Applications
1 26 (9.32%) Team Foundation Server
2 21 (7.53%) Visual Studio
3 16 (5.73%) JIRA
4 8 (2.87%) ERwin
5 6 (2.15%) Toad
6 3 (1.08%) JDeveloper
6 3 (1.08%) Oracle Forms
6 3 (1.08%) RStudio
6 3 (1.08%) SQL Server Management Studio (SSMS)
7 2 (0.72%) Selenium
8 1 (0.36%) Git (software)
8 1 (0.36%) JMeter
8 1 (0.36%) LoadRunner
8 1 (0.36%) MSTest
8 1 (0.36%) NUnit
8 1 (0.36%) SoapUI
8 1 (0.36%) SpecFlow
8 1 (0.36%) Visual Studio Team System
8 1 (0.36%) WebDriver
General
1 38 (13.62%) Finance
2 22 (7.89%) Electronics
3 17 (6.09%) Manufacturing
4 10 (3.58%) Retail
5 9 (3.23%) Marketing
6 8 (2.87%) Advertising
7 6 (2.15%) Telecoms
8 5 (1.79%) French Language
9 2 (0.72%) Legal
10 1 (0.36%) Automotive
10 1 (0.36%) Banking
10 1 (0.36%) Law
Job Titles
1 153 (54.84%) Developer
2 99 (35.48%) Business Intelligence Developer
3 59 (21.15%) SQL Developer
4 46 (16.49%) Business Developer
5 44 (15.77%) Analyst
6 39 (13.98%) SQL BI Developer
7 30 (10.75%) SQL Server Developer
8 28 (10.04%) SQL Server BI Developer
9 27 (9.68%) Data Engineer
10 23 (8.24%) Data Warehouse Developer
11 21 (7.53%) Data Analyst
12 19 (6.81%) AWS Engineer
13 17 (6.09%) SSIS Developer
13 17 (6.09%) SSRS Developer
14 16 (5.73%) SQL Analyst
15 15 (5.38%) Consultant
16 13 (4.66%) Business Intelligence Analyst
17 12 (4.30%) Architect
17 12 (4.30%) Senior Data Engineer
18 11 (3.94%) Hadoop Engineer
Libraries, Frameworks & Software Standards
1 25 (8.96%) Web Services
2 22 (7.89%) .NET
2 22 (7.89%) MLlib
2 22 (7.89%) Pandas
3 20 (7.17%) REST
4 14 (5.02%) JSON
4 14 (5.02%) SOAP
5 13 (4.66%) XML
6 11 (3.94%) .NET Framework
7 9 (3.23%) Middleware
8 6 (2.15%) Velocity
9 5 (1.79%) EDI
9 5 (1.79%) MDX
10 4 (1.43%) Oracle Fusion
10 4 (1.43%) RESTful
11 3 (1.08%) CSS
11 3 (1.08%) Entity Framework
11 3 (1.08%) HTML
11 3 (1.08%) J2EE
11 3 (1.08%) jQuery
Miscellaneous
1 35 (12.54%) Analytical Skills
2 23 (8.24%) Clustering
3 20 (7.17%) User Experience
4 17 (6.09%) Data Structures
5 13 (4.66%) Internet of Things
6 10 (3.58%) Management Information System
7 5 (1.79%) Driving Licence
7 5 (1.79%) Greenfield Project
8 3 (1.08%) Wiki
9 2 (0.72%) Fintech
9 2 (0.72%) N-Tier
9 2 (0.72%) PKI
9 2 (0.72%) Social Media
10 1 (0.36%) Algorithms
10 1 (0.36%) Computer Science
10 1 (0.36%) Enterprise Software
10 1 (0.36%) Reference Data
10 1 (0.36%) RIA
10 1 (0.36%) Virtual Team
Operating Systems
1 15 (5.38%) Linux
2 5 (1.79%) Unix
3 3 (1.08%) Windows
4 2 (0.72%) Windows Server
5 1 (0.36%) AIX
5 1 (0.36%) Embedded Linux
Processes & Methodologies
1 200 (71.68%) Business Intelligence
2 70 (25.09%) Agile Software Development
3 68 (24.37%) Analytics
4 63 (22.58%) Data Modelling
5 50 (17.92%) Visualisation
6 49 (17.56%) Migration
7 40 (14.34%) Data Management
8 39 (13.98%) Data Visualisation
9 36 (12.90%) Data Migration
9 36 (12.90%) Stakeholder Management
10 34 (12.19%) Data Analysis
11 33 (11.83%) Data Integration
12 31 (11.11%) Scrum
13 27 (9.68%) ERP
13 27 (9.68%) SDLC
14 26 (9.32%) CRM
14 26 (9.32%) Open Source
15 24 (8.60%) Coaching
15 24 (8.60%) Continuous Delivery
16 23 (8.24%) DevOps
Programming Languages
1 236 (84.59%) SQL
2 109 (39.07%) T-SQL
3 54 (19.35%) C#
4 47 (16.85%) Java
5 45 (16.13%) Python
6 33 (11.83%) Scala
7 11 (3.94%) JavaScript
7 11 (3.94%) R
8 8 (2.87%) PowerShell
8 8 (2.87%) VBA
9 7 (2.51%) PL/SQL
10 5 (1.79%) C
10 5 (1.79%) Shell Script
10 5 (1.79%) VB
11 3 (1.08%) PHP
11 3 (1.08%) Ruby
11 3 (1.08%) U-SQL
12 2 (0.72%) C++
13 1 (0.36%) X++
Qualifications
1 23 (8.24%) Degree
2 15 (5.38%) Security Cleared
3 13 (4.66%) SC Cleared
4 7 (2.51%) Numerate Degree
5 1 (0.36%) APMP
5 1 (0.36%) ISEB
5 1 (0.36%) ISTQB
5 1 (0.36%) ISTQB Foundation Certification
5 1 (0.36%) ITIL Certification
5 1 (0.36%) Microsoft Certification
5 1 (0.36%) Postgraduate
Quality Assurance & Compliance
1 23 (8.24%) QA
2 14 (5.02%) Data Quality
3 2 (0.72%) GCP
3 2 (0.72%) HL7
4 1 (0.36%) GDPR
4 1 (0.36%) SLA
System Software
1 18 (6.45%) Docker
2 4 (1.43%) VMware Infrastructure
3 2 (0.72%) HDFS
4 1 (0.36%) Apache Flume
4 1 (0.36%) Oracle RAC
4 1 (0.36%) Virtual Machines
Systems Management
1 2 (0.72%) Systems Management Server (SMS)
2 1 (0.36%) Ansible
2 1 (0.36%) Enterprise Manager Cloud Control
2 1 (0.36%) Opscode Chef
2 1 (0.36%) Oracle Enterprise Manager
2 1 (0.36%) Puppet
Vendors
1 101 (36.20%) Microsoft
2 46 (16.49%) Tableau
3 18 (6.45%) Oracle
3 18 (6.45%) SAP
4 17 (6.09%) Cognos
5 16 (5.73%) Atlassian
6 14 (5.02%) Informatica
7 11 (3.94%) IBM
8 8 (2.87%) Google
9 6 (2.15%) Siebel
9 6 (2.15%) Talend
10 4 (1.43%) Capita
10 4 (1.43%) VMware
11 2 (0.72%) Hortonworks
11 2 (0.72%) IDERA
11 2 (0.72%) Netezza
11 2 (0.72%) Teradata
12 1 (0.36%) Birst
12 1 (0.36%) Nintex
12 1 (0.36%) SaltStack