Period
to 12 December 2017

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 12 December 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > South West
6 months to
12 Dec 2017
Same period 2016 Same period 2015
Rank 135 191 163
Rank change year-on-year +56 -28 -7
Permanent jobs citing ETL 270 161 227
As % of all permanent IT jobs advertised in the South West 2.64% 1.49% 1.96%
As % of the Processes & Methodologies category 2.95% 1.67% 2.19%
Number of salaries quoted 212 121 189
South West median annual salary £40,000 £42,500 £45,000
Median salary % change year-on-year -5.88% -5.56% +7.14%
10th Percentile £29,250 £33,500 £26,950
90th Percentile £61,000 £60,000 £67,500
England median annual salary £50,000 £52,500 £50,000
% change year-on-year -4.76% +5.00% -4.76%

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 9139 9625 10356
As % of all permanent IT jobs advertised in the South West 89.34% 88.94% 89.29%
Number of salaries quoted 7512 8007 8744
South West median annual salary £42,500 £40,500 £40,000
Median salary % change year-on-year +4.94% +1.25% +3.90%
10th Percentile £26,250 £26,250 £25,000
90th Percentile £65,000 £63,750 £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 12 December 2017.

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 12 December 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Bristol +36 103 £42,500 - 7
Somerset -2 54 £35,750 -9.49% 1
Dorset +21 39 £42,250 -15.50% 2
Wiltshire +7 31 £40,000 -15.79% 1
Gloucestershire +36 22 £41,250 -23.61% 1
Devon +19 9 £40,000 -5.88%
Cornwall -5 8 - - 1
ETL
England

For the 6 months to 12 December 2017, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the South West region with a requirement for ETL.

1 236 (87.41%) SQL
2 194 (71.85%) Business Intelligence
3 160 (59.26%) Data Warehouse
4 157 (58.15%) SQL Server
5 145 (53.70%) SQL Server Integration Services
6 129 (47.78%) SQL Server Reporting Services
7 115 (42.59%) T-SQL
8 102 (37.78%) Microsoft
9 74 (27.41%) Power BI
10 72 (26.67%) Agile Software Development
11 64 (23.70%) Data Modelling
11 64 (23.70%) Analytics
12 63 (23.33%) Microsoft Azure
13 52 (19.26%) SQL Server Analysis Services
14 49 (18.15%) Migration
14 49 (18.15%) Amazon AWS
15 46 (17.04%) BusinessObjects
15 46 (17.04%) C#
16 42 (15.56%) Java
16 42 (15.56%) Tableau
17 40 (14.81%) Microsoft Excel
17 40 (14.81%) Finance
18 39 (14.44%) Stakeholder Management
18 39 (14.44%) Visualisation
19 38 (14.07%) Python
19 38 (14.07%) Data Management
20 37 (13.70%) Analytical Skills
20 37 (13.70%) SQL Server 2014
21 36 (13.33%) SQL Server 2012
22 34 (12.59%) QlikView

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 30 (11.11%) Apache Spark
2 22 (8.15%) Elasticsearch
3 19 (7.04%) SharePoint
4 9 (3.33%) Apache Pig
5 3 (1.11%) IIS
6 2 (0.74%) BizTalk Server
6 2 (0.74%) CMS
6 2 (0.74%) Kentico
7 1 (0.37%) Oracle 10gAS
7 1 (0.37%) WebLogic
7 1 (0.37%) WebSphere
Applications
1 40 (14.81%) Microsoft Excel
2 6 (2.22%) Microsoft Office
3 4 (1.48%) SPSS
3 4 (1.48%) SPSS Modeler
4 2 (0.74%) MS Visio
Business Applications
1 4 (1.48%) Cognos Business Intelligence
1 4 (1.48%) SAP Business ByDesign
1 4 (1.48%) SAP Business One
2 2 (0.74%) Dynamics AX
2 2 (0.74%) Dynamics CRM
3 1 (0.37%) Cognos TM1
3 1 (0.37%) Dynamics NAV
3 1 (0.37%) Oracle 11i
3 1 (0.37%) Oracle BPM
3 1 (0.37%) Oracle EBS
3 1 (0.37%) Oracle EBS R12
3 1 (0.37%) Oracle ERP
Cloud Services
1 63 (23.33%) Microsoft Azure
2 49 (18.15%) Amazon AWS
3 22 (8.15%) Amazon EMR
3 22 (8.15%) Amazon Kinesis
4 12 (4.44%) GitHub
5 9 (3.33%) Google Cloud Platform
6 4 (1.48%) IaaS
6 4 (1.48%) PaaS
7 3 (1.11%) Azure Data Factory
8 2 (0.74%) Amazon EC2
8 2 (0.74%) Cloud Computing
8 2 (0.74%) Office 365
8 2 (0.74%) SaaS
8 2 (0.74%) Virtual Private Cloud
9 1 (0.37%) AWS Data Pipeline
9 1 (0.37%) Cortana Intelligence Suite
9 1 (0.37%) Salesforce Sales Cloud
9 1 (0.37%) Salesforce Service Cloud
Communications & Networking
1 2 (0.74%) AMQP
1 2 (0.74%) Internet
2 1 (0.37%) SMS
Database & Business Intelligence
1 160 (59.26%) Data Warehouse
2 157 (58.15%) SQL Server
3 145 (53.70%) SQL Server Integration Services
4 129 (47.78%) SQL Server Reporting Services
5 74 (27.41%) Power BI
6 52 (19.26%) SQL Server Analysis Services
7 46 (17.04%) BusinessObjects
8 37 (13.70%) SQL Server 2014
9 36 (13.33%) SQL Server 2012
10 34 (12.59%) QlikView
11 24 (8.89%) Amazon Redshift
12 23 (8.52%) BigQuery
12 23 (8.52%) Hadoop
13 22 (8.15%) Big Data
14 20 (7.41%) MySQL
15 19 (7.04%) Data Mining
15 19 (7.04%) Enterprise Data Warehouse
16 18 (6.67%) Relational Database
17 17 (6.30%) Crystal Reports
18 16 (5.93%) NoSQL
Development Applications
1 24 (8.89%) Team Foundation Server
2 21 (7.78%) Visual Studio
3 12 (4.44%) JIRA
4 9 (3.33%) ERwin
5 6 (2.22%) Talend Open Studio
6 5 (1.85%) Toad
7 4 (1.48%) RStudio
8 3 (1.11%) MSTest
8 3 (1.11%) NUnit
8 3 (1.11%) SQL Server Management Studio (SSMS)
9 2 (0.74%) Selenium
10 1 (0.37%) Git (software)
10 1 (0.37%) JMeter
10 1 (0.37%) LoadRunner
10 1 (0.37%) SoapUI
10 1 (0.37%) SpecFlow
10 1 (0.37%) TestRail
10 1 (0.37%) Visual Studio Team System
10 1 (0.37%) WebDriver
General
1 40 (14.81%) Finance
2 19 (7.04%) Electronics
3 14 (5.19%) Manufacturing
4 13 (4.81%) Marketing
4 13 (4.81%) Retail
5 10 (3.70%) Advertising
6 7 (2.59%) Telecoms
7 5 (1.85%) French Language
8 1 (0.37%) Automotive
8 1 (0.37%) Banking
8 1 (0.37%) Law
Job Titles
1 149 (55.19%) Developer
2 98 (36.30%) Business Intelligence Developer
3 55 (20.37%) SQL Developer
4 46 (17.04%) Business Developer
5 36 (13.33%) Analyst
6 35 (12.96%) SQL BI Developer
7 30 (11.11%) SQL Server Developer
8 26 (9.63%) SQL Server BI Developer
9 21 (7.78%) Data Engineer
10 20 (7.41%) Data Warehouse Developer
11 19 (7.04%) Data Analyst
12 18 (6.67%) SSRS Developer
13 17 (6.30%) SSIS Developer
14 15 (5.56%) AWS Engineer
14 15 (5.56%) SQL Analyst
15 14 (5.19%) Consultant
16 11 (4.07%) Senior Developer
17 10 (3.70%) Business Intelligence Consultant
18 9 (3.33%) Architect
18 9 (3.33%) DBA
Libraries, Frameworks & Software Standards
1 22 (8.15%) .NET
2 21 (7.78%) Web Services
3 20 (7.41%) REST
4 16 (5.93%) MLlib
4 16 (5.93%) Pandas
5 14 (5.19%) JSON
5 14 (5.19%) XML
6 13 (4.81%) SOAP
7 7 (2.59%) .NET Framework
8 6 (2.22%) Middleware
8 6 (2.22%) Velocity
9 4 (1.48%) EDI
9 4 (1.48%) HTML
9 4 (1.48%) MDX
10 3 (1.11%) ASP.NET
10 3 (1.11%) CSS
11 2 (0.74%) LINQ
11 2 (0.74%) WCF
11 2 (0.74%) WF
11 2 (0.74%) WPF
Miscellaneous
1 37 (13.70%) Analytical Skills
2 21 (7.78%) Data Structures
3 17 (6.30%) Clustering
4 16 (5.93%) User Experience
5 14 (5.19%) Management Information System
6 11 (4.07%) Internet of Things
7 6 (2.22%) Greenfield Project
8 5 (1.85%) Driving Licence
9 4 (1.48%) Renewable Energy
10 3 (1.11%) Wiki
11 2 (0.74%) N-Tier
11 2 (0.74%) PKI
11 2 (0.74%) Social Media
12 1 (0.37%) Algorithms
12 1 (0.37%) Computer Science
12 1 (0.37%) Data Protection Act
12 1 (0.37%) Reference Data
12 1 (0.37%) Smart City
Operating Systems
1 11 (4.07%) Linux
2 8 (2.96%) Windows
3 6 (2.22%) Unix
4 3 (1.11%) Windows Server
5 2 (0.74%) Solaris
6 1 (0.37%) AIX
6 1 (0.37%) Embedded Linux
6 1 (0.37%) Windows Server 2003
Processes & Methodologies
1 194 (71.85%) Business Intelligence
2 72 (26.67%) Agile Software Development
3 64 (23.70%) Analytics
3 64 (23.70%) Data Modelling
4 49 (18.15%) Migration
5 39 (14.44%) Stakeholder Management
5 39 (14.44%) Visualisation
6 38 (14.07%) Data Management
7 33 (12.22%) Data Analysis
7 33 (12.22%) Data Integration
8 32 (11.85%) Data Migration
8 32 (11.85%) Data Visualisation
9 25 (9.26%) Scrum
9 25 (9.26%) SDLC
10 24 (8.89%) ERP
11 22 (8.15%) Open Source
12 21 (7.78%) Continuous Integration
12 21 (7.78%) Software Engineering
13 20 (7.41%) Coaching
13 20 (7.41%) Continuous Delivery
Programming Languages
1 236 (87.41%) SQL
2 115 (42.59%) T-SQL
3 46 (17.04%) C#
4 42 (15.56%) Java
5 38 (14.07%) Python
6 26 (9.63%) Scala
7 13 (4.81%) R
8 12 (4.44%) JavaScript
9 10 (3.70%) VBA
10 6 (2.22%) C++
11 5 (1.85%) PowerShell
12 4 (1.48%) C
12 4 (1.48%) PL/SQL
12 4 (1.48%) VB
13 3 (1.11%) Ruby
14 2 (0.74%) PHP
15 1 (0.37%) Apex Code
15 1 (0.37%) Shell Script
15 1 (0.37%) X++
Qualifications
1 26 (9.63%) Degree
2 17 (6.30%) Security Cleared
3 14 (5.19%) SC Cleared
4 9 (3.33%) Numerate Degree
5 6 (2.22%) ISTQB
6 5 (1.85%) ISEB
7 1 (0.37%) APMP
7 1 (0.37%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 31 (11.48%) QA
2 14 (5.19%) Data Quality
3 2 (0.74%) GCP
3 2 (0.74%) GDPR
3 2 (0.74%) HL7
4 1 (0.37%) SLA
System Software
1 14 (5.19%) Docker
2 4 (1.48%) VMware Infrastructure
3 2 (0.74%) HDFS
4 1 (0.37%) Apache Flume
4 1 (0.37%) Oracle RAC
4 1 (0.37%) Virtual Machines
Systems Management
1 5 (1.85%) Systems Management Server (SMS)
2 1 (0.37%) Enterprise Manager Cloud Control
2 1 (0.37%) Oracle Enterprise Manager
Vendors
1 102 (37.78%) Microsoft
2 42 (15.56%) Tableau
3 16 (5.93%) Cognos
4 15 (5.56%) SAP
5 12 (4.44%) Atlassian
5 12 (4.44%) IBM
6 11 (4.07%) Oracle
7 9 (3.33%) Informatica
8 8 (2.96%) Google
9 6 (2.22%) Talend
9 6 (2.22%) VMware
10 4 (1.48%) Capita
11 2 (0.74%) Hortonworks
11 2 (0.74%) IDERA
11 2 (0.74%) NetApp
11 2 (0.74%) Netezza
11 2 (0.74%) Sybase
11 2 (0.74%) Teradata
12 1 (0.37%) Birst
12 1 (0.37%) Nintex