Period
to 19 July 2018

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

Extract, Transform and Load (ETL)
6 months to
19 Jul 2018
Same period 2017 Same period 2016
Rank 70 52 115
Rank change year-on-year -18 +63 +4
Permanent jobs citing ETL 34 89 32
As % of all permanent IT jobs advertised in Essex 2.38% 4.63% 1.51%
As % of the Processes & Methodologies category 2.86% 5.48% 1.70%
Number of salaries quoted 30 65 31
Essex median annual salary £50,000 £47,500 £50,000
Median salary % change year-on-year +5.26% -5.00% +25.00%
10th Percentile £39,000 £34,250 £36,750
90th Percentile £68,000 £59,500 £75,000
East of England median annual salary £45,000 £45,000 £50,000
% change year-on-year - -10.00% +5.26%

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

All Process and Methodology Skills
Essex
Permanent vacancies with a requirement for process or methodology skills 1,189 1,624 1,882
As % of all permanent IT jobs advertised in Essex 83.38% 84.41% 88.86%
Number of salaries quoted 995 1,288 1,488
Essex median annual salary £45,000 £45,000 £43,375
Median salary % change year-on-year - +3.75% +2.06%
10th Percentile £27,000 £27,500 £22,500
90th Percentile £70,000 £65,000 £65,000
East of England median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +2.51%

ETL
Job Vacancy Trend in Essex

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

Job vacancy trend for ETL in Essex

ETL
Salary Trend in Essex

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

Salary trend for ETL in Essex

ETL
Salary Histogram in Essex

The salary distribution of IT jobs citing ETL in Essex over the 6 months to 19 July 2018.

Salary histogram for ETL in Essex

ETL
Job Locations in Essex

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Essex region over the 6 months to 19 July 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
Colchester -16 15 £50,000 -
Brentwood +12 4 £62,500 -
Chelmsford +6 4 £42,500 -26.72%
Basildon - 3 £50,000 -
Southend-on-Sea - 1 - -
Witham - 1 £70,000 -
ETL
East of England

For the 6 months to 19 July 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 Essex region with a requirement for ETL.

1 31 (91.18%) SQL
2 17 (50.00%) T-SQL
2 17 (50.00%) SQL Server Integration Services
3 16 (47.06%) SQL Server Reporting Services
3 16 (47.06%) SQL Server
3 16 (47.06%) Data Warehouse
4 13 (38.24%) Business Intelligence
5 12 (35.29%) PL/SQL
6 11 (32.35%) RDBMS
6 11 (32.35%) Relational Database
7 10 (29.41%) Microsoft
7 10 (29.41%) Oracle
7 10 (29.41%) Agile Software Development
8 9 (26.47%) Oracle Database
9 8 (23.53%) Advertising
10 7 (20.59%) .NET
10 7 (20.59%) Linux
10 7 (20.59%) Microsoft Azure
11 6 (17.65%) VBA
11 6 (17.65%) C#
11 6 (17.65%) MS Access
12 5 (14.71%) OLTP
12 5 (14.71%) Banking
12 5 (14.71%) OLAP
12 5 (14.71%) SQL Server Analysis Services
12 5 (14.71%) WPF
12 5 (14.71%) Power BI
13 4 (11.76%) Data Migration
13 4 (11.76%) SQL Server 2008
13 4 (11.76%) SQL Server Management Studio (SSMS)

ETL
Co-occurring IT Skills in Essex 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 2 (5.88%) Apache Pig
1 2 (5.88%) Apache Spark
2 1 (2.94%) WebLogic
Applications
1 1 (2.94%) Microsoft Excel
Business Applications
1 1 (2.94%) Adobe Campaign
1 1 (2.94%) FastStats
1 1 (2.94%) FastStats PeopleStage
Cloud Services
1 7 (20.59%) Microsoft Azure
2 2 (5.88%) Amazon AWS
3 1 (2.94%) Boomi
3 1 (2.94%) Cloud Computing
3 1 (2.94%) Heroku
Communications & Networking
1 1 (2.94%) SMS
Database & Business Intelligence
1 17 (50.00%) SQL Server Integration Services
2 16 (47.06%) Data Warehouse
2 16 (47.06%) SQL Server
2 16 (47.06%) SQL Server Reporting Services
3 11 (32.35%) RDBMS
3 11 (32.35%) Relational Database
4 9 (26.47%) Oracle Database
5 6 (17.65%) MS Access
6 5 (14.71%) OLAP
6 5 (14.71%) OLTP
6 5 (14.71%) Power BI
6 5 (14.71%) SQL Server Analysis Services
7 4 (11.76%) SQL Server 2008
8 3 (8.82%) MySQL
8 3 (8.82%) SQL Server 2012
8 3 (8.82%) SQL Server 2016
9 2 (5.88%) Amazon Aurora
9 2 (5.88%) Amazon RDS
9 2 (5.88%) Hadoop
9 2 (5.88%) Impala
Development Applications
1 4 (11.76%) SQL Server Management Studio (SSMS)
2 1 (2.94%) CA Gen
General
1 8 (23.53%) Advertising
2 5 (14.71%) Banking
3 4 (11.76%) Finance
4 3 (8.82%) Marketing
5 2 (5.88%) Games
5 2 (5.88%) Law
6 1 (2.94%) Legal
6 1 (2.94%) Telecoms
Job Titles
1 26 (76.47%) Developer
2 13 (38.24%) Database Developer
2 13 (38.24%) SQL Developer
3 9 (26.47%) Oracle Developer
4 7 (20.59%) Database Programmer
4 7 (20.59%) Oracle Database Developer
4 7 (20.59%) Programmer
5 5 (14.71%) SQL Database Developer
6 4 (11.76%) Access Developer
7 3 (8.82%) Access VBA Developer
7 3 (8.82%) DBA
7 3 (8.82%) Junior
7 3 (8.82%) Microsoft Developer
7 3 (8.82%) SQL Server Developer
7 3 (8.82%) SSRS Developer
7 3 (8.82%) T-SQL Developer
7 3 (8.82%) VBA Developer
8 2 (5.88%) Big Data Engineer
8 2 (5.88%) Data Engineer
8 2 (5.88%) Junior SQL DBA
Libraries, Frameworks & Software Standards
1 7 (20.59%) .NET
2 5 (14.71%) WPF
3 3 (8.82%) ASP.NET
4 2 (5.88%) Kafka
4 2 (5.88%) RabbitMQ
5 1 (2.94%) ADSI
5 1 (2.94%) ASP.NET Web API
5 1 (2.94%) J2EE
5 1 (2.94%) Visualforce
5 1 (2.94%) WCF
5 1 (2.94%) Web Services
Miscellaneous
1 1 (2.94%) Management Information System
1 1 (2.94%) Self-Motivation
Operating Systems
1 7 (20.59%) Linux
2 1 (2.94%) Unix
Processes & Methodologies
1 13 (38.24%) Business Intelligence
2 10 (29.41%) Agile Software Development
3 4 (11.76%) Data Migration
3 4 (11.76%) Data Modelling
3 4 (11.76%) Migration
3 4 (11.76%) Performance Tuning
4 2 (5.88%) Analytics
4 2 (5.88%) Business Analysis
4 2 (5.88%) Data Visualisation
4 2 (5.88%) MapReduce
4 2 (5.88%) Microservices
4 2 (5.88%) Problem-Solving
4 2 (5.88%) Translating Business Requirements
4 2 (5.88%) Visualisation
5 1 (2.94%) Customer-Centricity
5 1 (2.94%) Data Analysis
5 1 (2.94%) Data Management
5 1 (2.94%) Personalization
5 1 (2.94%) Presales
5 1 (2.94%) Single Customer View
Programming Languages
1 31 (91.18%) SQL
2 17 (50.00%) T-SQL
3 12 (35.29%) PL/SQL
4 6 (17.65%) C#
4 6 (17.65%) VBA
5 3 (8.82%) Java
5 3 (8.82%) Perl
6 2 (5.88%) PHP
6 2 (5.88%) PowerShell
6 2 (5.88%) VB
7 1 (2.94%) Apex Code
7 1 (2.94%) Shell Script
Qualifications
1 1 (2.94%) Degree
Quality Assurance & Compliance
1 2 (5.88%) Data Quality
2 1 (2.94%) QA
System Software
1 2 (5.88%) Apache Flume
1 2 (5.88%) Docker
1 2 (5.88%) HDFS
Systems Management
1 1 (2.94%) Systems Management Server (SMS)
Vendors
1 10 (29.41%) Microsoft
1 10 (29.41%) Oracle
2 4 (11.76%) Tableau
3 2 (5.88%) Cloudera
3 2 (5.88%) Hortonworks
3 2 (5.88%) Informatica
3 2 (5.88%) MapR
4 1 (2.94%) Adobe
4 1 (2.94%) BEA
4 1 (2.94%) Dell
4 1 (2.94%) Google
4 1 (2.94%) Jitterbit
4 1 (2.94%) Pega
4 1 (2.94%) Salesforce.com
4 1 (2.94%) webMethods