|
|
|
|
|
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 November 2018 with a comparison to the same period in the previous 2 years.
| Data Warehousing UK |
|
|
6 months to
20 Nov 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
114 |
117 |
109 |
| Rank change year-on-year |
+3 |
-8 |
-26 |
| Permanent jobs citing Data Warehouse |
4,697 |
4,984 |
5,312 |
| As % of all permanent IT jobs advertised in the UK |
2.88% |
2.77% |
2.84% |
| As % of the Database & Business Intelligence category |
9.89% |
9.16% |
9.58% |
| Number of salaries quoted |
3,894 |
3,934 |
4,565 |
| UK median annual salary |
£55,000 |
£50,001 |
£54,000 |
| Median salary % change year-on-year |
+10.00% |
-7.41% |
+8.00% |
| 10th Percentile |
£35,000 |
£32,500 |
£33,750 |
| 90th Percentile |
£85,000 |
£77,500 |
£81,750 |
| UK excluding London median annual salary |
£47,500 |
£45,000 |
£47,500 |
| % change year-on-year |
+5.56% |
-5.26% |
+5.56% |
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 |
47,487 |
54,413 |
55,467 |
| As % of all permanent IT jobs advertised in the UK |
29.11% |
30.24% |
29.65% |
| Number of salaries quoted |
39,061 |
44,798 |
47,411 |
| UK median annual salary |
£50,000 |
£47,500 |
£47,500 |
| Median salary % change year-on-year |
+5.26% |
- |
+5.56% |
| 10th Percentile |
£31,250 |
£30,000 |
£29,000 |
| 90th Percentile |
£83,750 |
£77,500 |
£77,500 |
| UK excluding London median annual salary |
£45,000 |
£42,500 |
£42,500 |
| % change year-on-year |
+5.88% |
- |
+6.25% |
|
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 November 2018.
Data Warehouse
Top 17 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 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 |
+6 |
4,431 |
£55,000 |
+6.80% |
666 |
| London |
+14 |
2,403 |
£62,500 |
+4.17% |
310 |
| UK excluding London |
+5 |
2,219 |
£47,500 |
+5.56% |
403 |
| South East |
+31 |
619 |
£52,000 |
+4.00% |
82 |
| North of England |
-13 |
586 |
£45,000 |
- |
114 |
| Midlands |
-15 |
323 |
£45,000 |
-3.74% |
58 |
| North West |
-16 |
316 |
£45,000 |
+5.88% |
67 |
| East of England |
+64 |
245 |
£47,500 |
-9.52% |
49 |
| South West |
-9 |
235 |
£50,000 |
+17.65% |
55 |
| Yorkshire |
-30 |
235 |
£46,250 |
+2.78% |
29 |
| East Midlands |
+35 |
166 |
£43,000 |
-4.44% |
25 |
| West Midlands |
-42 |
156 |
£45,000 |
-5.26% |
33 |
| Scotland |
-11 |
155 |
£50,000 |
+11.11% |
34 |
| Wales |
+52 |
66 |
£42,500 |
+21.43% |
12 |
| North East |
+33 |
51 |
£56,250 |
+40.63% |
18 |
| Northern Ireland |
+3 |
5 |
- |
- |
1 |
| Channel Islands |
-10 |
1 |
£45,000 |
-25.00% |
|
For the 6 months to 20 November 2018, 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 |
3,122 (66.47%) |
SQL |
| 2 |
2,993 (63.72%) |
Business Intelligence |
| 3 |
2,293 (48.82%) |
SQL Server |
| 4 |
2,093 (44.56%) |
ETL |
| 5 |
2,037 (43.37%) |
SQL Server Integration Services |
| 6 |
1,715 (36.51%) |
Microsoft |
| 7 |
1,610 (34.28%) |
SQL Server Reporting Services |
| 8 |
1,428 (30.40%) |
Agile Software Development |
| 9 |
1,310 (27.89%) |
Finance |
| 10 |
1,271 (27.06%) |
SQL Server Analysis Services |
| 11 |
1,265 (26.93%) |
Analytics |
| 12 |
1,215 (25.87%) |
T-SQL |
| 13 |
1,133 (24.12%) |
Power BI |
| 14 |
1,003 (21.35%) |
Data Modelling |
| 15 |
892 (18.99%) |
Microsoft Azure |
|
|
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:
|
|
|
