|
|
|
|
|
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 5 July 2020 with a comparison to the same period in the previous 2 years.
| Snowflake Schema UK |
|
|
6 months to
5 Jul 2020 |
Same period 2019 |
Same period 2018 |
| Rank |
580 |
1020 |
1103 |
| Rank change year-on-year |
+440 |
+83 |
+52 |
| Permanent jobs citing Snowflake Schema |
271 |
92 |
122 |
| As % of all permanent jobs advertised in the UK |
0.34% |
0.062% |
0.069% |
| As % of the Database & Business Intelligence category |
1.28% |
0.23% |
0.22% |
| Number of salaries quoted |
245 |
91 |
92 |
| Median annual salary |
£65,000 |
£52,500 |
£52,500 |
| Median salary % change year-on-year |
+23.81% |
- |
+23.53% |
| 10th Percentile |
£45,500 |
£35,250 |
£33,825 |
| 90th Percentile |
£91,250 |
£90,000 |
£76,250 |
| UK excluding London median annual salary |
£57,500 |
£47,500 |
£45,000 |
| % change year-on-year |
+21.05% |
+5.56% |
+12.50% |
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 |
21,247 |
40,780 |
54,380 |
| As % of all permanent IT jobs advertised in the UK |
26.95% |
27.68% |
30.55% |
| Number of salaries quoted |
17,311 |
33,413 |
44,536 |
| Median annual salary |
£55,000 |
£52,000 |
£50,000 |
| Median salary % change year-on-year |
+5.77% |
+4.00% |
+5.26% |
| 10th Percentile |
£32,500 |
£31,250 |
£31,250 |
| 90th Percentile |
£90,000 |
£85,000 |
£81,250 |
| UK excluding London median annual salary |
£47,500 |
£45,000 |
£45,000 |
| % change year-on-year |
+5.56% |
- |
+5.88% |
|
Snowflake Schema
Job Vacancy Trend
Job postings citing Snowflake Schema as a proportion of all IT jobs advertised.
Snowflake Schema
Salary Trend
3-month moving average salary quoted in jobs citing Snowflake Schema.
Snowflake Schema
Salary Histogram
Salary distribution for jobs citing Snowflake Schema over the 6 months to 5 July 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 5 July 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 |
+432 |
262 |
£65,000 |
+23.81% |
17 |
| London |
+297 |
197 |
£67,500 |
+12.50% |
9 |
| UK excluding London |
+267 |
67 |
£57,500 |
+21.05% |
9 |
| Midlands |
- |
28 |
£55,000 |
- |
2 |
| North of England |
+151 |
21 |
£57,500 |
+15.00% |
3 |
| West Midlands |
- |
19 |
£55,000 |
- |
1 |
| Work from Home |
+79 |
12 |
£75,000 |
-13.04% |
2 |
| Yorkshire |
+123 |
10 |
£60,000 |
-7.69% |
|
| North West |
+111 |
10 |
£57,500 |
+15.00% |
3 |
| East Midlands |
- |
9 |
£75,000 |
- |
1 |
| East of England |
+106 |
8 |
£47,500 |
+11.76% |
1 |
| South East |
+149 |
6 |
£65,000 |
+68.83% |
1 |
| South West |
+107 |
2 |
- |
- |
1 |
| Wales |
+24 |
2 |
£56,750 |
- |
|
| North East |
- |
1 |
£42,000 |
- |
|
For the 6 months to 5 July 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:
|
|
|
