|
|
|
|
|
The following table provides summary statistics for permanent job vacancies with a requirement for Snowflake Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Snowflake Schema over the 6 months to 29 February 2020 with a comparison to the same period in the previous 2 years.
| Snowflake Schema UK |
|
|
6 months to
29 Feb 2020 |
Same period 2019 |
Same period 2018 |
| Rank |
705 |
1001 |
1112 |
| Rank change year-on-year |
+296 |
+111 |
+29 |
| Permanent jobs citing Snowflake Schema |
310 |
116 |
94 |
| As % of all permanent IT jobs advertised in the UK |
0.25% |
0.077% |
0.053% |
| As % of the Database & Business Intelligence category |
0.95% |
0.27% |
0.17% |
| Number of salaries quoted |
268 |
99 |
69 |
| UK median annual salary |
£70,000 |
£55,000 |
£55,000 |
| Median salary % change year-on-year |
+27.27% |
- |
+22.22% |
| 10th Percentile |
£42,500 |
£35,150 |
£37,500 |
| 90th Percentile |
£115,000 |
£80,000 |
£80,000 |
| UK excluding London median annual salary |
£55,000 |
£38,500 |
£50,000 |
| % change year-on-year |
+42.86% |
-23.00% |
+17.65% |
Snowflake Schema 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 |
32,722 |
43,263 |
53,766 |
| As % of all permanent IT jobs advertised in the UK |
26.78% |
28.62% |
30.52% |
| Number of salaries quoted |
26,814 |
35,606 |
44,905 |
| UK median annual salary |
£52,500 |
£52,095 |
£50,000 |
| Median salary % change year-on-year |
+0.78% |
+4.19% |
+5.26% |
| 10th Percentile |
£32,500 |
£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% |
- |
|
Snowflake Schema
Job Vacancy Trend
Job postings citing Snowflake Schema as a percentage of all IT jobs advertised.
Snowflake Schema
Salary Trend
This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Snowflake Schema.
Snowflake Schema
Salary Histogram
The salary distribution of IT jobs citing Snowflake Schema over the 6 months to 29 February 2020.
Snowflake Schema
Top 15 Job Locations
The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the UK over the 6 months to 29 February 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 |
+279 |
301 |
£70,000 |
+27.27% |
59 |
| London |
+212 |
224 |
£75,000 |
+25.00% |
39 |
| UK excluding London |
+165 |
81 |
£55,000 |
+42.86% |
24 |
| North of England |
+96 |
44 |
£55,000 |
+10.00% |
13 |
| North West |
+81 |
34 |
£55,000 |
- |
7 |
| Midlands |
+62 |
13 |
£39,000 |
- |
1 |
| West Midlands |
- |
10 |
£38,000 |
- |
|
| East of England |
+74 |
9 |
£62,500 |
+71.23% |
2 |
| Yorkshire |
+40 |
9 |
£57,500 |
+15.00% |
6 |
| South East |
+29 |
6 |
£57,500 |
+49.35% |
3 |
| South West |
+44 |
5 |
£52,500 |
+5.00% |
1 |
| East Midlands |
+28 |
3 |
£65,000 |
- |
1 |
| Scotland |
- |
3 |
£73,750 |
- |
|
| North East |
- |
1 |
£42,000 |
- |
|
| Wales |
- |
1 |
£52,500 |
- |
4 |
For the 6 months to 29 February 2020, IT jobs citing Snowflake Schema 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 Snowflake Schema.
Snowflake Schema
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:
|
|
|
