|
|
|
|
|
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 23 September 2018 with a comparison to the same period in the previous 2 years.
| Extract, Transform and Load (ETL) UK |
|
|
6 months to
23 Sep 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
132 |
147 |
135 |
| Rank change year-on-year |
+15 |
-12 |
-14 |
| Permanent jobs citing ETL |
4,145 |
4,275 |
4,873 |
| As % of all permanent IT jobs advertised in the UK |
2.51% |
2.43% |
2.51% |
| As % of the Processes & Methodologies category |
2.75% |
2.66% |
2.76% |
| Number of salaries quoted |
3,372 |
3,352 |
3,963 |
| UK median annual salary |
£52,500 |
£50,000 |
£50,500 |
| Median salary % change year-on-year |
+5.00% |
-0.99% |
-3.81% |
| 10th Percentile |
£35,000 |
£32,500 |
£35,000 |
| 90th Percentile |
£82,500 |
£76,250 |
£77,500 |
| 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 |
150,479 |
160,844 |
176,344 |
| As % of all permanent IT jobs advertised in the UK |
91.03% |
91.55% |
90.89% |
| Number of salaries quoted |
119,704 |
127,010 |
147,108 |
| 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,500 |
| 90th Percentile |
£82,500 |
£80,000 |
£78,750 |
| UK excluding London median annual salary |
£45,000 |
£42,500 |
£42,500 |
| % change year-on-year |
+5.88% |
- |
- |
|
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 23 September 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 23 September 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 |
+17 |
3,901 |
£52,500 |
+5.00% |
512 |
| London |
+22 |
2,176 |
£60,000 |
+9.09% |
235 |
| UK excluding London |
-12 |
1,859 |
£45,000 |
- |
318 |
| South East |
+15 |
540 |
£50,000 |
-4.76% |
75 |
| North of England |
-17 |
472 |
£45,000 |
+5.88% |
84 |
| Midlands |
-2 |
264 |
£45,000 |
+5.88% |
50 |
| North West |
-10 |
260 |
£45,000 |
+8.43% |
47 |
| East of England |
+9 |
230 |
£47,500 |
+5.56% |
31 |
| South West |
-23 |
189 |
£45,000 |
+12.50% |
38 |
| Yorkshire |
-22 |
179 |
£45,000 |
- |
29 |
| West Midlands |
+7 |
167 |
£45,000 |
+12.50% |
23 |
| Scotland |
-35 |
142 |
£45,000 |
- |
32 |
| East Midlands |
-10 |
96 |
£42,500 |
- |
27 |
| Wales |
-12 |
42 |
£37,500 |
-6.25% |
4 |
| North East |
+8 |
33 |
£38,750 |
-13.89% |
8 |
| Northern Ireland |
-9 |
2 |
£43,750 |
+16.67% |
5 |
For the 6 months to 23 September 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,838 (68.47%) |
SQL |
| 2 |
2,080 (50.18%) |
Business Intelligence |
| 3 |
2,064 (49.79%) |
Data Warehouse |
| 4 |
2,012 (48.54%) |
SQL Server |
| 5 |
1,803 (43.50%) |
SQL Server Integration Services |
| 6 |
1,361 (32.83%) |
SQL Server Reporting Services |
| 7 |
1,314 (31.70%) |
Microsoft |
| 8 |
1,281 (30.90%) |
Agile Software Development |
| 9 |
1,162 (28.03%) |
Finance |
| 10 |
1,135 (27.38%) |
Analytics |
| 11 |
1,062 (25.62%) |
T-SQL |
| 12 |
940 (22.68%) |
SQL Server Analysis Services |
| 13 |
862 (20.80%) |
Big Data |
| 14 |
849 (20.48%) |
Data Modelling |
| 15 |
841 (20.29%) |
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:
|
|
|
