|
|
|
|
|
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 19 November 2018 with a comparison to the same period in the previous 2 years.
| Extract, Transform and Load (ETL) UK |
|
|
6 months to
19 Nov 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
136 |
142 |
137 |
| Rank change year-on-year |
+6 |
-5 |
-24 |
| Permanent jobs citing ETL |
4,054 |
4,341 |
4,587 |
| As % of all permanent IT jobs advertised in the UK |
2.50% |
2.43% |
2.43% |
| As % of the Processes & Methodologies category |
2.74% |
2.66% |
2.67% |
| Number of salaries quoted |
3,317 |
3,417 |
3,804 |
| UK median annual salary |
£55,000 |
£50,000 |
£51,000 |
| Median salary % change year-on-year |
+10.00% |
-1.96% |
+2.00% |
| 10th Percentile |
£35,721 |
£32,500 |
£34,500 |
| 90th Percentile |
£82,500 |
£75,000 |
£80,000 |
| 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 |
147,698 |
163,216 |
171,560 |
| As % of all permanent IT jobs advertised in the UK |
91.11% |
91.49% |
90.94% |
| Number of salaries quoted |
117,431 |
129,024 |
142,667 |
| UK median annual salary |
£50,000 |
£50,000 |
£48,000 |
| Median salary % change year-on-year |
- |
+4.17% |
+1.05% |
| 10th Percentile |
£29,000 |
£28,250 |
£27,615 |
| 90th Percentile |
£84,250 |
£80,000 |
£78,750 |
| UK excluding London median annual salary |
£45,000 |
£43,000 |
£42,500 |
| % change year-on-year |
+4.65% |
+1.18% |
- |
|
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 19 November 2018.
ETL
Top 17 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 19 November 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 |
+12 |
3,834 |
£55,000 |
+10.00% |
577 |
| London |
+21 |
2,113 |
£60,000 |
+9.09% |
280 |
| UK excluding London |
-2 |
1,879 |
£45,000 |
- |
332 |
| South East |
+10 |
551 |
£50,000 |
-4.76% |
69 |
| North of England |
-23 |
465 |
£45,000 |
+5.88% |
93 |
| Midlands |
-15 |
263 |
£45,000 |
+2.27% |
56 |
| North West |
-8 |
260 |
£45,000 |
+5.88% |
45 |
| East of England |
+18 |
227 |
£52,500 |
+10.53% |
37 |
| South West |
-14 |
209 |
£48,750 |
+21.88% |
42 |
| West Midlands |
-5 |
173 |
£45,000 |
- |
39 |
| Yorkshire |
-48 |
171 |
£42,500 |
- |
39 |
| Scotland |
-41 |
132 |
£45,000 |
- |
31 |
| East Midlands |
-2 |
89 |
£42,500 |
+6.25% |
17 |
| Wales |
+4 |
43 |
£40,000 |
- |
3 |
| North East |
+16 |
34 |
£39,250 |
-7.65% |
9 |
| Northern Ireland |
-2 |
7 |
£27,500 |
-31.25% |
1 |
| Channel Islands |
- |
1 |
£37,500 |
- |
|
For the 6 months to 19 November 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 |
2,762 (68.13%) |
SQL |
| 2 |
2,083 (51.38%) |
Business Intelligence |
| 3 |
2,076 (51.21%) |
Data Warehouse |
| 4 |
1,987 (49.01%) |
SQL Server |
| 5 |
1,775 (43.78%) |
SQL Server Integration Services |
| 6 |
1,320 (32.56%) |
Agile Software Development |
| 7 |
1,313 (32.39%) |
SQL Server Reporting Services |
| 8 |
1,290 (31.82%) |
Microsoft |
| 9 |
1,105 (27.26%) |
Finance |
| 10 |
1,084 (26.74%) |
Analytics |
| 11 |
1,026 (25.31%) |
T-SQL |
| 12 |
940 (23.19%) |
Data Modelling |
| 13 |
897 (22.13%) |
SQL Server Analysis Services |
| 14 |
826 (20.37%) |
Big Data |
| 15 |
817 (20.15%) |
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:
|
|
|
