|
|
|
|
|
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 11 December 2019 with a comparison to the same period in the previous 2 years.
| Snowflake Schema UK |
|
|
6 months to
11 Dec 2019 |
Same period 2018 |
Same period 2017 |
| Rank |
804 |
1030 |
1159 |
| Rank change year-on-year |
+226 |
+129 |
+13 |
| Permanent jobs citing Snowflake Schema |
246 |
115 |
58 |
| As % of all permanent IT jobs advertised in the UK |
0.18% |
0.072% |
0.032% |
| As % of the Database & Business Intelligence category |
0.69% |
0.25% |
0.11% |
| Number of salaries quoted |
213 |
98 |
37 |
| UK median annual salary |
£65,000 |
£55,000 |
£50,000 |
| Median salary % change year-on-year |
+18.18% |
+10.00% |
-7.41% |
| 10th Percentile |
£37,100 |
£34,750 |
£37,500 |
| 90th Percentile |
£115,000 |
£73,750 |
£80,000 |
| UK excluding London median annual salary |
£52,500 |
£50,000 |
£50,000 |
| % change year-on-year |
+5.00% |
- |
+11.11% |
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 |
35,827 |
46,020 |
54,445 |
| As % of all permanent IT jobs advertised in the UK |
26.85% |
28.81% |
30.30% |
| Number of salaries quoted |
29,600 |
37,812 |
44,893 |
| UK median annual salary |
£52,500 |
£50,000 |
£47,500 |
| Median salary % change year-on-year |
+5.00% |
+5.26% |
- |
| 10th Percentile |
£32,000 |
£31,250 |
£30,000 |
| 90th Percentile |
£87,500 |
£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 11 December 2019.
Snowflake Schema
Top 13 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 11 December 2019.
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 |
+231 |
236 |
£65,000 |
+18.18% |
50 |
| London |
+154 |
148 |
£75,000 |
+20.00% |
32 |
| UK excluding London |
+130 |
94 |
£52,500 |
+5.00% |
18 |
| North of England |
+79 |
50 |
£60,000 |
+20.00% |
11 |
| North West |
+86 |
47 |
£60,000 |
+118.18% |
11 |
| South East |
+33 |
14 |
£50,000 |
-4.76% |
3 |
| South West |
+20 |
14 |
£52,500 |
+5.00% |
1 |
| Midlands |
+39 |
9 |
£38,000 |
- |
2 |
| West Midlands |
- |
9 |
£38,000 |
- |
|
| Scotland |
- |
5 |
£52,500 |
- |
|
| Yorkshire |
+19 |
3 |
£80,000 |
+60.00% |
|
| East of England |
+59 |
1 |
- |
- |
1 |
| Wales |
+6 |
1 |
£52,500 |
- |
|
For the 6 months to 11 December 2019, 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:
|
|
|
