|
|
|
|
|
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 21 April 2018 with a comparison to the same period in the previous 2 years.
| Extract, Transform and Load (ETL) UK |
|
|
6 months to
21 Apr 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
136 |
139 |
113 |
| Rank change year-on-year |
+3 |
-26 |
+16 |
| Permanent jobs citing ETL |
4,326 |
4,120 |
5,763 |
| As % of all permanent IT jobs advertised in the UK |
2.44% |
2.41% |
2.82% |
| As % of the Processes & Methodologies category |
2.68% |
2.66% |
3.13% |
| Number of salaries quoted |
3,535 |
3,413 |
4,742 |
| UK median annual salary |
£52,500 |
£50,000 |
£50,000 |
| Median salary % change year-on-year |
+5.00% |
- |
-4.76% |
| 10th Percentile |
£34,200 |
£32,500 |
£33,500 |
| 90th Percentile |
£81,250 |
£77,500 |
£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 |
161,258 |
154,906 |
183,888 |
| As % of all permanent IT jobs advertised in the UK |
90.84% |
90.43% |
89.94% |
| Number of salaries quoted |
130,650 |
127,515 |
152,786 |
| UK median annual salary |
£50,000 |
£47,500 |
£47,500 |
| Median salary % change year-on-year |
+5.26% |
- |
+5.56% |
| 10th Percentile |
£29,127 |
£27,875 |
£27,500 |
| 90th Percentile |
£81,250 |
£78,750 |
£77,500 |
| UK excluding London median annual salary |
£45,000 |
£42,500 |
£42,500 |
| % change year-on-year |
+5.88% |
- |
+5.66% |
|
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 21 April 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 21 April 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 |
+7 |
4,030 |
£52,500 |
+5.00% |
439 |
| London |
+14 |
2,110 |
£60,000 |
+4.35% |
214 |
| UK excluding London |
-6 |
2,107 |
£45,000 |
- |
249 |
| North of England |
+9 |
569 |
£45,000 |
+12.50% |
49 |
| South East |
-26 |
544 |
£50,000 |
-7.41% |
64 |
| Midlands |
-14 |
312 |
£47,500 |
+11.76% |
53 |
| Yorkshire |
+40 |
273 |
£45,000 |
+5.88% |
17 |
| North West |
-21 |
272 |
£45,000 |
+20.00% |
27 |
| South West |
+22 |
262 |
£40,000 |
-5.88% |
32 |
| West Midlands |
+30 |
236 |
£50,000 |
+18.69% |
34 |
| East of England |
-60 |
215 |
£49,000 |
+3.16% |
24 |
| Scotland |
-13 |
163 |
£42,500 |
-5.56% |
24 |
| East Midlands |
-60 |
75 |
£42,500 |
-10.53% |
19 |
| Wales |
-19 |
51 |
£37,500 |
-6.25% |
2 |
| North East |
-14 |
24 |
£35,500 |
-21.11% |
5 |
| Northern Ireland |
-3 |
4 |
£33,750 |
-11.76% |
1 |
For the 6 months to 21 April 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,903 (67.11%) |
SQL |
| 2 |
2,418 (55.89%) |
Business Intelligence |
| 3 |
2,159 (49.91%) |
Data Warehouse |
| 4 |
2,071 (47.87%) |
SQL Server |
| 5 |
1,792 (41.42%) |
SQL Server Integration Services |
| 6 |
1,329 (30.72%) |
SQL Server Reporting Services |
| 7 |
1,318 (30.47%) |
Microsoft |
| 8 |
1,211 (27.99%) |
Analytics |
| 9 |
1,141 (26.38%) |
Agile Software Development |
| 10 |
1,107 (25.59%) |
T-SQL |
| 11 |
1,043 (24.11%) |
SQL Server Analysis Services |
| 12 |
1,020 (23.58%) |
Finance |
| 13 |
932 (21.54%) |
Data Modelling |
| 14 |
818 (18.91%) |
Big Data |
| 15 |
781 (18.05%) |
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:
|
|
|
