|
|
|
|
|
The following table provides summary statistics for permanent job vacancies 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 July 2018 with a comparison to the same period in the previous 2 years.
| Extract, Transform and Load (ETL) UK |
|
|
6 months to
20 Jul 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
132 |
141 |
129 |
| Rank change year-on-year |
+9 |
-12 |
-1 |
| Permanent jobs citing ETL |
4,390 |
4,385 |
5,235 |
| As % of all permanent IT jobs advertised in the UK |
2.51% |
2.47% |
2.58% |
| As % of the Processes & Methodologies category |
2.77% |
2.73% |
2.87% |
| Number of salaries quoted |
3,549 |
3,508 |
4,253 |
| UK median annual salary |
£52,500 |
£50,000 |
£52,500 |
| Median salary % change year-on-year |
+5.00% |
-4.76% |
- |
| 10th Percentile |
£35,000 |
£32,500 |
£35,000 |
| 90th Percentile |
£82,500 |
£76,400 |
£76,250 |
| UK excluding London median annual salary |
£45,000 |
£45,000 |
£45,000 |
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 with a requirement for process or methodology skills.
| All Process and Methodology Skills UK |
| Permanent vacancies with a requirement for process or methodology skills |
158,731 |
160,892 |
182,711 |
| As % of all permanent IT jobs advertised in the UK |
90.67% |
90.74% |
90.02% |
| Number of salaries quoted |
126,853 |
129,433 |
151,996 |
| UK median annual salary |
£50,000 |
£49,500 |
£47,500 |
| Median salary % change year-on-year |
+1.01% |
+4.21% |
- |
| 10th Percentile |
£29,000 |
£28,000 |
£27,500 |
| 90th Percentile |
£82,500 |
£80,000 |
£77,500 |
| UK excluding London median annual salary |
£45,000 |
£42,500 |
£42,500 |
| % change year-on-year |
+5.88% |
- |
+1.19% |
|
ETL
Job Vacancy Trend
Job postings citing ETL as a percentage of all IT jobs advertised.
ETL
Salary Trend
This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL.
ETL
Salary Histogram
The salary distribution of IT jobs citing ETL over the 6 months to 20 July 2018.
ETL
Top 16 Job Locations
The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the UK over the 6 months to 20 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 |
| England |
+13 |
4,105 |
£52,500 |
+5.00% |
564 |
| London |
+25 |
2,301 |
£60,000 |
+4.35% |
280 |
| UK excluding London |
-20 |
1,966 |
£45,000 |
- |
309 |
| South East |
+4 |
556 |
£50,000 |
-7.41% |
83 |
| North of England |
-5 |
518 |
£45,000 |
+5.88% |
102 |
| Midlands |
-27 |
282 |
£45,000 |
+5.88% |
56 |
| North West |
-15 |
276 |
£45,000 |
+12.50% |
57 |
| South West |
-10 |
219 |
£45,000 |
+12.50% |
22 |
| Yorkshire |
-3 |
218 |
£45,000 |
- |
32 |
| East of England |
-50 |
199 |
£45,000 |
- |
20 |
| West Midlands |
+19 |
192 |
£50,000 |
+25.00% |
28 |
| Scotland |
-21 |
158 |
£43,750 |
-2.78% |
20 |
| East Midlands |
-36 |
90 |
£42,500 |
-5.56% |
28 |
| Wales |
-5 |
57 |
£42,000 |
-6.67% |
4 |
| North East |
-9 |
24 |
£37,500 |
-44.44% |
13 |
| Northern Ireland |
-17 |
3 |
£30,000 |
-20.00% |
2 |
For the 6 months to 20 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 with a requirement for ETL.
| 1 |
3,025 (68.91%) |
SQL |
| 2 |
2,315 (52.73%) |
Business Intelligence |
| 3 |
2,157 (49.13%) |
Data Warehouse |
| 4 |
2,126 (48.43%) |
SQL Server |
| 5 |
1,859 (42.35%) |
SQL Server Integration Services |
| 6 |
1,382 (31.48%) |
SQL Server Reporting Services |
| 7 |
1,370 (31.21%) |
Microsoft |
| 8 |
1,301 (29.64%) |
Agile Software Development |
| 9 |
1,282 (29.20%) |
Analytics |
| 10 |
1,135 (25.85%) |
T-SQL |
| 11 |
1,094 (24.92%) |
Finance |
| 12 |
1,036 (23.60%) |
SQL Server Analysis Services |
| 13 |
935 (21.30%) |
Data Modelling |
| 14 |
933 (21.25%) |
Big Data |
| 15 |
871 (19.84%) |
Power BI |
|
|
ETL
Co-occurring IT Skills 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:
|
|
|
