Period
to 20 November 2017

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

Extract, Transform and Load (ETL)
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 64 83 118
Rank change year-on-year +19 +35 -24
Permanent jobs citing ETL 47 49 34
As % of all permanent IT jobs advertised in Essex 3.36% 2.33% 1.29%
As % of the Processes & Methodologies category 3.97% 2.66% 1.54%
Number of salaries quoted 41 43 30
Essex median annual salary £50,000 £45,000 £37,500
Median salary % change year-on-year +11.11% +20.00% -20.21%
10th Percentile £37,500 £30,400 £32,175
90th Percentile £67,500 £65,000 £56,375
East of England median annual salary £47,500 £50,000 £47,500
% change year-on-year -5.00% +5.26% -5.00%

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 1183 1843 2214
As % of all permanent IT jobs advertised in Essex 84.50% 87.80% 84.12%
Number of salaries quoted 983 1411 1607
Essex median annual salary £45,001 £45,000 £40,000
Median salary % change year-on-year +0.00% +12.50% -9.09%
10th Percentile £27,500 £27,500 £24,300
90th Percentile £66,250 £68,750 £67,500
East of England median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +3.45%

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 20 November 2017.

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 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Colchester +14 23 £50,000 +11.11%
Brentwood - 6 £65,000 -
Basildon +15 3 £40,000 -20.00%
Chelmsford -7 3 £61,000 +62.67%
Southend-on-Sea - 1 £40,000 -
ETL
East of England

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

1 43 (91.49%) SQL
2 24 (51.06%) Data Warehouse
3 23 (48.94%) Oracle
3 23 (48.94%) PL/SQL
3 23 (48.94%) Oracle Database
4 22 (46.81%) Agile Software Development
4 22 (46.81%) Business Intelligence
5 20 (42.55%) SQL Server
5 20 (42.55%) SQL Server Integration Services
6 18 (38.30%) Microsoft
7 17 (36.17%) SQL Server Reporting Services
8 16 (34.04%) OLAP
8 16 (34.04%) T-SQL
9 15 (31.91%) SQL Server Analysis Services
9 15 (31.91%) Performance Tuning
10 14 (29.79%) Relational Database
10 14 (29.79%) OLTP
10 14 (29.79%) RDBMS
11 13 (27.66%) Linux
12 12 (25.53%) C#
12 12 (25.53%) .NET
13 10 (21.28%) Finance
14 9 (19.15%) Microsoft Excel
14 9 (19.15%) Data Modelling
15 8 (17.02%) Advertising
15 8 (17.02%) Data Analysis
15 8 (17.02%) Degree
15 8 (17.02%) Data Quality
15 8 (17.02%) Physical Data Model
16 7 (14.89%) Power BI

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 1 (2.13%) Apache Spark
Applications
1 9 (19.15%) Microsoft Excel
2 5 (10.64%) MS Visio
3 1 (2.13%) Microsoft Office
Cloud Services
1 4 (8.51%) Microsoft Azure
Database & Business Intelligence
1 24 (51.06%) Data Warehouse
2 23 (48.94%) Oracle Database
3 20 (42.55%) SQL Server
3 20 (42.55%) SQL Server Integration Services
4 17 (36.17%) SQL Server Reporting Services
5 16 (34.04%) OLAP
6 15 (31.91%) SQL Server Analysis Services
7 14 (29.79%) OLTP
7 14 (29.79%) RDBMS
7 14 (29.79%) Relational Database
8 7 (14.89%) Power BI
9 6 (12.77%) SQL Server 2008
10 5 (10.64%) Enterprise Data Warehouse
10 5 (10.64%) QlikView
11 3 (6.38%) BusinessObjects
11 3 (6.38%) BusinessObjects Business Intelligence
11 3 (6.38%) Lumira
11 3 (6.38%) MS Access
11 3 (6.38%) SAP BW
11 3 (6.38%) SAP HANA
Development Applications
1 5 (10.64%) SQL Server Management Studio (SSMS)
2 1 (2.13%) Git (software)
General
1 10 (21.28%) Finance
2 8 (17.02%) Advertising
3 3 (6.38%) Banking
4 2 (4.26%) Law
5 1 (2.13%) Automotive
5 1 (2.13%) Telecoms
Job Titles
1 39 (82.98%) Developer
2 23 (48.94%) Oracle Developer
3 20 (42.55%) ETL Developer
4 17 (36.17%) SQL Developer
5 16 (34.04%) Database Developer
6 15 (31.91%) Oracle Database Developer
7 12 (25.53%) Oracle ETL Developer
7 12 (25.53%) PL/SQL Developer
7 12 (25.53%) SQL Database Developer
8 11 (23.40%) Data Warehouse Developer
8 11 (23.40%) Oracle Data Warehouse Developer
9 6 (12.77%) Analyst
10 3 (6.38%) Access Developer
10 3 (6.38%) Business Intelligence Developer
10 3 (6.38%) Consultant
10 3 (6.38%) Data Analyst
10 3 (6.38%) Lead Developer
10 3 (6.38%) Microsoft Developer
10 3 (6.38%) SAP Consultant
10 3 (6.38%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 12 (25.53%) .NET
2 7 (14.89%) MDX
3 4 (8.51%) WPF
4 3 (6.38%) ASP.NET
4 3 (6.38%) ASP.NET Web API
4 3 (6.38%) WCF
5 2 (4.26%) .NET Framework
5 2 (4.26%) XML
6 1 (2.13%) ADSI
6 1 (2.13%) HTML
6 1 (2.13%) Web Services
Miscellaneous
1 6 (12.77%) Analytical Skills
2 2 (4.26%) Credit Risk
2 2 (4.26%) Management Information System
3 1 (2.13%) N-Tier
Operating Systems
1 13 (27.66%) Linux
Processes & Methodologies
1 22 (46.81%) Agile Software Development
1 22 (46.81%) Business Intelligence
2 15 (31.91%) Performance Tuning
3 9 (19.15%) Data Modelling
4 8 (17.02%) Data Analysis
4 8 (17.02%) Physical Data Model
5 6 (12.77%) Logical Data Model
6 5 (10.64%) Data Integration
6 5 (10.64%) Data Transformation
6 5 (10.64%) ITIL
6 5 (10.64%) Kimball Methodology
6 5 (10.64%) Ticket Management
7 2 (4.26%) Analytics
7 2 (4.26%) Business Analysis
7 2 (4.26%) Change Control
7 2 (4.26%) Continuous Improvement
7 2 (4.26%) Data Architecture
7 2 (4.26%) Information Governance
7 2 (4.26%) Performance Monitoring
7 2 (4.26%) Single Customer View
Programming Languages
1 43 (91.49%) SQL
2 23 (48.94%) PL/SQL
3 16 (34.04%) T-SQL
4 12 (25.53%) C#
5 6 (12.77%) VB.NET
6 5 (10.64%) VBScript
7 3 (6.38%) VBA
Qualifications
1 8 (17.02%) Degree
2 5 (10.64%) Microsoft Certification
Quality Assurance & Compliance
1 8 (17.02%) Data Quality
Vendors
1 23 (48.94%) Oracle
2 18 (38.30%) Microsoft
3 3 (6.38%) Jedox
3 3 (6.38%) SAP
4 2 (4.26%) MicroStrategy
5 1 (2.13%) Atlassian