|
|
|
|
|
The following table provides summary statistics for permanent job vacancies with a requirement for Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Warehouse over the 6 months to 20 January 2020 with a comparison to the same period in the previous 2 years.
| Data Warehousing UK |
|
|
6 months to
20 Jan 2020 |
Same period 2019 |
Same period 2018 |
| Rank |
115 |
122 |
124 |
| Rank change year-on-year |
+7 |
+2 |
-16 |
| Permanent jobs citing Data Warehouse |
3,484 |
4,196 |
4,668 |
| As % of all permanent IT jobs advertised in the UK |
2.78% |
2.81% |
2.70% |
| As % of the Database & Business Intelligence category |
10.36% |
9.79% |
8.83% |
| Number of salaries quoted |
2,850 |
3,469 |
3,733 |
| UK median annual salary |
£57,500 |
£55,000 |
£50,000 |
| Median salary % change year-on-year |
+4.55% |
+10.00% |
-7.41% |
| 10th Percentile |
£36,250 |
£35,641 |
£32,500 |
| 90th Percentile |
£87,500 |
£85,000 |
£77,500 |
| UK excluding London median annual salary |
£47,500 |
£47,500 |
£45,000 |
| % change year-on-year |
- |
+5.56% |
-5.26% |
Data Warehouse is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.
| All Database and Business Intelligence Skills UK |
| Permanent vacancies with a requirement for database or business intelligence skills |
33,619 |
42,843 |
52,894 |
| As % of all permanent IT jobs advertised in the UK |
26.81% |
28.64% |
30.55% |
| Number of salaries quoted |
27,603 |
35,189 |
43,854 |
| UK median annual salary |
£52,500 |
£52,500 |
£48,000 |
| Median salary % change year-on-year |
- |
+9.38% |
+1.05% |
| 10th Percentile |
£32,000 |
£31,250 |
£30,000 |
| 90th Percentile |
£88,750 |
£85,000 |
£77,500 |
| UK excluding London median annual salary |
£45,000 |
£45,000 |
£42,500 |
| % change year-on-year |
- |
+5.88% |
- |
|
Data Warehouse
Job Vacancy Trend
Job postings citing Data Warehouse as a percentage of all IT jobs advertised.
Data Warehouse
Salary Trend
This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse.
Data Warehouse
Salary Histogram
The salary distribution of IT jobs citing Data Warehouse over the 6 months to 20 January 2020.
Data Warehouse
Top 18 Job Locations
The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the UK over the 6 months to 20 January 2020.
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 |
+5 |
3,279 |
£58,000 |
+5.45% |
572 |
| London |
-2 |
1,783 |
£65,000 |
+6.43% |
259 |
| UK excluding London |
+10 |
1,656 |
£47,500 |
- |
350 |
| North of England |
+46 |
514 |
£47,500 |
+5.56% |
103 |
| South East |
-39 |
343 |
£50,000 |
-1.48% |
75 |
| North West |
+71 |
334 |
£47,500 |
+5.56% |
63 |
| Midlands |
+31 |
282 |
£45,000 |
- |
50 |
| West Midlands |
+67 |
228 |
£45,000 |
-5.26% |
27 |
| East of England |
+43 |
172 |
£52,500 |
+16.67% |
39 |
| South West |
-18 |
168 |
£45,000 |
-14.29% |
46 |
| Yorkshire |
-11 |
131 |
£47,500 |
- |
27 |
| Scotland |
-21 |
94 |
£43,250 |
-13.50% |
18 |
| Wales |
+13 |
70 |
£42,500 |
- |
18 |
| East Midlands |
-57 |
54 |
£45,000 |
+5.88% |
23 |
| North East |
+14 |
50 |
£40,177 |
-33.04% |
13 |
| Northern Ireland |
+13 |
12 |
£45,000 |
- |
1 |
| Channel Islands |
- |
1 |
£60,000 |
- |
|
| Isle of Man |
- |
1 |
£37,500 |
- |
|
For the 6 months to 20 January 2020, IT jobs citing Data Warehouse 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 Data Warehouse.
| 1 |
2,291 (65.76%) |
SQL |
| 2 |
2,158 (61.94%) |
Business Intelligence |
| 3 |
1,608 (46.15%) |
ETL |
| 4 |
1,502 (43.11%) |
SQL Server |
| 5 |
1,169 (33.55%) |
SQL Server Integration Services |
| 6 |
1,139 (32.69%) |
Analytics |
| 7 |
1,094 (31.40%) |
Power BI |
| 7 |
1,094 (31.40%) |
Power Platform |
| 8 |
1,034 (29.68%) |
Azure |
| 9 |
1,027 (29.48%) |
Microsoft |
| 10 |
954 (27.38%) |
Agile Software Development |
| 11 |
930 (26.69%) |
Data Modelling |
| 12 |
892 (25.60%) |
SQL Server Reporting Services |
| 13 |
804 (23.08%) |
Finance |
| 14 |
785 (22.53%) |
SQL Server Analysis Services |
|
|
Data Warehouse
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:
|
|
|
