Period
to 16 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Gloucestershire 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 16 January 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
South West > Gloucestershire
6 months to
16 Jan 2018
Same period 2017 Same period 2016
Rank 111 146 98
Rank change year-on-year +35 -48 +22
Permanent jobs citing ETL 23 22 48
As % of all permanent IT jobs advertised in Gloucestershire 1.62% 0.98% 2.41%
As % of the Processes & Methodologies category 1.82% 1.08% 2.67%
Number of salaries quoted 17 17 34
Gloucestershire median annual salary £42,500 £62,000 £45,000
Median salary % change year-on-year -31.45% +37.78% +9.09%
10th Percentile £27,500 £35,000 £37,500
90th Percentile £62,500 £70,500 £63,750
South West median annual salary £40,000 £42,500 £45,000
% change year-on-year -5.88% -5.56% +8.43%

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

All Process and Methodology Skills
Gloucestershire
Permanent vacancies with a requirement for process or methodology skills 1,266 2,040 1,801
As % of all permanent IT jobs advertised in Gloucestershire 89.22% 91.28% 90.46%
Number of salaries quoted 1,042 1,677 1,381
Gloucestershire median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +6.25%
10th Percentile £25,525 £27,500 £26,250
90th Percentile £62,500 £62,500 £65,000
South West median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% +3.90%

ETL
Job Vacancy Trend in Gloucestershire

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

Job vacancy trend for ETL in Gloucestershire

ETL
Salary Trend in Gloucestershire

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

Salary trend for ETL in Gloucestershire

ETL
Salary Histogram in Gloucestershire

The salary distribution of IT jobs citing ETL in Gloucestershire over the 6 months to 16 January 2018.

Salary histogram for ETL in Gloucestershire

ETL
Job Locations in Gloucestershire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Gloucestershire region over the 6 months to 16 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
Cirencester -8 10 £56,250 - 2
Gloucester - 8 £40,000 - 2
Cheltenham +22 1 £37,500 -42.31% 2
ETL
South West

For the 6 months to 16 January 2018, 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 Gloucestershire region with a requirement for ETL.

1 22 (95.65%) SQL
2 20 (86.96%) Data Warehouse
3 17 (73.91%) SQL Server Integration Services
4 15 (65.22%) Data Modelling
5 14 (60.87%) Business Intelligence
6 12 (52.17%) SQL Server
6 12 (52.17%) Power BI
7 7 (30.43%) Data Management
7 7 (30.43%) Data Analysis
7 7 (30.43%) Degree
7 7 (30.43%) Migration
7 7 (30.43%) BusinessObjects
7 7 (30.43%) Microsoft Excel
7 7 (30.43%) ERwin
7 7 (30.43%) T-SQL
7 7 (30.43%) Microsoft Azure
7 7 (30.43%) Analytical Skills
8 6 (26.09%) Qlik Sense
8 6 (26.09%) Analytics
8 6 (26.09%) Tableau
8 6 (26.09%) Statistical Modelling
8 6 (26.09%) Numerate Degree
8 6 (26.09%) Mathematics
8 6 (26.09%) SQL Server Analysis Services
8 6 (26.09%) Data Mapping
8 6 (26.09%) Manufacturing
8 6 (26.09%) SQL Server Reporting Services
9 5 (21.74%) IBM
10 4 (17.39%) Microsoft
10 4 (17.39%) Cognos

ETL
Co-occurring IT Skills in Gloucestershire 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 1 (4.35%) WebLogic
1 1 (4.35%) WebSphere
Applications
1 7 (30.43%) Microsoft Excel
Business Applications
1 3 (13.04%) Cognos Business Intelligence
2 1 (4.35%) Oracle BPM
Cloud Services
1 7 (30.43%) Microsoft Azure
2 3 (13.04%) Azure Data Factory
3 1 (4.35%) Amazon AWS
3 1 (4.35%) IaaS
3 1 (4.35%) PaaS
Database & Business Intelligence
1 20 (86.96%) Data Warehouse
2 17 (73.91%) SQL Server Integration Services
3 12 (52.17%) Power BI
3 12 (52.17%) SQL Server
4 7 (30.43%) BusinessObjects
5 6 (26.09%) Qlik Sense
5 6 (26.09%) SQL Server Analysis Services
5 6 (26.09%) SQL Server Reporting Services
6 3 (13.04%) Cognos Framework Manager
6 3 (13.04%) Cognos Report Studio
6 3 (13.04%) DecisionStream
6 3 (13.04%) Semantic Layer
7 2 (8.70%) IBM InfoSphere
8 1 (4.35%) Azure SQL Database
8 1 (4.35%) Big Data
Development Applications
1 7 (30.43%) ERwin
2 1 (4.35%) JMeter
2 1 (4.35%) LoadRunner
2 1 (4.35%) Selenium
2 1 (4.35%) SoapUI
General
1 6 (26.09%) Manufacturing
2 3 (13.04%) Finance
3 1 (4.35%) Banking
Job Titles
1 12 (52.17%) Developer
2 10 (43.48%) Analyst
3 9 (39.13%) Data Analyst
4 7 (30.43%) SQL Developer
5 6 (26.09%) Business Intelligence Developer
6 3 (13.04%) Business Developer
6 3 (13.04%) Business Intelligence Analyst
6 3 (13.04%) Cognos BI Developer
6 3 (13.04%) Cognos Developer
6 3 (13.04%) SQL BI Developer
7 2 (8.70%) Business Data Analyst
7 2 (8.70%) Business Intelligence Data Analyst
7 2 (8.70%) Junior
7 2 (8.70%) Junior Developer
7 2 (8.70%) Junior SQL Developer
8 1 (4.35%) C++/Java Developer
8 1 (4.35%) Developer Analyst
8 1 (4.35%) Report Developer
8 1 (4.35%) SQL Server Developer
8 1 (4.35%) Systems Architect
Libraries, Frameworks & Software Standards
1 1 (4.35%) JSON
1 1 (4.35%) SOAP
1 1 (4.35%) Web Services
1 1 (4.35%) XML
1 1 (4.35%) XSD
Miscellaneous
1 7 (30.43%) Analytical Skills
2 1 (4.35%) Greenfield Project
Operating Systems
1 1 (4.35%) AIX
1 1 (4.35%) Linux
Processes & Methodologies
1 15 (65.22%) Data Modelling
2 14 (60.87%) Business Intelligence
3 7 (30.43%) Data Analysis
3 7 (30.43%) Data Management
3 7 (30.43%) Migration
4 6 (26.09%) Analytics
4 6 (26.09%) Data Mapping
4 6 (26.09%) Mathematics
4 6 (26.09%) Statistical Modelling
5 4 (17.39%) Kimball Methodology
5 4 (17.39%) Visualisation
6 3 (13.04%) Data Visualisation
6 3 (13.04%) Translating Business Requirements
7 2 (8.70%) Mentoring
7 2 (8.70%) SDLC
7 2 (8.70%) Stakeholder Management
8 1 (4.35%) Agile Software Development
8 1 (4.35%) Data Integration
8 1 (4.35%) OOP
8 1 (4.35%) Scrum
Programming Languages
1 22 (95.65%) SQL
2 7 (30.43%) T-SQL
3 3 (13.04%) PowerShell
3 3 (13.04%) U-SQL
4 1 (4.35%) C
4 1 (4.35%) C++
4 1 (4.35%) Java
4 1 (4.35%) Python
4 1 (4.35%) Shell Script
Qualifications
1 7 (30.43%) Degree
2 6 (26.09%) Numerate Degree
3 1 (4.35%) Security Cleared
Quality Assurance & Compliance
1 1 (4.35%) Data Quality
Vendors
1 6 (26.09%) Tableau
2 5 (21.74%) IBM
3 4 (17.39%) Cognos
3 4 (17.39%) Microsoft
4 2 (8.70%) Oracle
5 1 (4.35%) Teradata