Period
to 28 July 2021

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 28 July 2021 with a comparison to the same period in the previous 2 years.

Snowflake Schema
UK
6 months to
28 Jul 2021
Same period 2020 Same period 2019
Rank 942 715 1073
Rank change year-on-year -227 +358 +73
Permanent jobs citing Snowflake Schema 52 76 47
As % of all permanent jobs advertised in the UK 0.046% 0.11% 0.033%
As % of the Database & Business Intelligence category 0.16% 0.40% 0.12%
Number of salaries quoted 30 76 42
10th Percentile £57,500 £52,500 £32,500
25th Percentile £57,813 £57,500 £37,500
Median annual salary (50th Percentile) £80,000 £72,500 £57,500
Median % change year-on-year +10.34% +26.09% +9.52%
75th Percentile £105,000 £87,500 £66,250
90th Percentile £108,750 £120,000 £77,375
UK excluding London median annual salary £100,000 £55,000 £38,500
% change year-on-year +81.82% +42.86% -14.44%

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 31,724 19,182 40,086
As % of all permanent IT jobs advertised in the UK 28.09% 27.60% 27.83%
Number of salaries quoted 21,258 15,747 33,197
10th Percentile £34,500 £32,500 £31,250
25th Percentile £42,500 £41,250 £37,500
Median annual salary (50th Percentile) £55,000 £55,000 £51,786
Median % change year-on-year - +6.21% +3.57%
75th Percentile £75,000 £72,500 £70,000
90th Percentile £92,500 £88,750 £85,000
UK excluding London median annual salary £48,500 £47,500 £45,000
% change year-on-year +2.11% +5.56% -

Snowflake Schema
Job Vacancy Trend

Job postings citing Snowflake Schema as a proportion of all IT jobs advertised.

Job vacancy trend for Snowflake Schema in the UK

Snowflake Schema
Salary Trend

3-month moving average salary quoted in jobs citing Snowflake Schema.

Salary trend for Snowflake Schema in the UK

Snowflake Schema
Salary Histogram

Salary distribution for jobs citing Snowflake Schema over the 6 months to 28 July 2021.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 11 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 28 July 2021. 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 -184 50 £80,000 +10.34% 12
London -144 39 £77,500 - 5
UK excluding London -145 11 £100,000 +81.82% 7
Work from Home -237 5 £87,500 +25.00% 3
South East - 5 - - 5
North of England -62 2 £76,250 +45.24% 2
Midlands -85 2 - -
West Midlands -92 2 - -
Scotland - 2 £100,000 -
North West -49 1 £52,500 - 2
Yorkshire - 1 £100,000 -

For the 6 months to 28 July 2021, 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.

1 40 (76.92%) SQL
2 37 (71.15%) Data Modelling
3 35 (67.31%) Data Warehouse
4 33 (63.46%) Analytics
5 27 (51.92%) Tableau
6 24 (46.15%) Snowflake
7 23 (44.23%) dbt
7 23 (44.23%) Business Intelligence
8 20 (38.46%) ETL
8 20 (38.46%) Google
9 19 (36.54%) Python
10 18 (34.62%) Problem-Solving
11 15 (28.85%) Visualisation
12 14 (26.92%) Google Analytics
12 14 (26.92%) Data Engineering
12 14 (26.92%) Social Skills
13 13 (25.00%) Looker
13 13 (25.00%) Data Analytics
13 13 (25.00%) Agile Software Development
14 12 (23.08%) CRM
15 11 (21.15%) Data Analysis
15 11 (21.15%) AWS
15 11 (21.15%) Data Science
15 11 (21.15%) Apache Airflow
16 10 (19.23%) Power Platform
16 10 (19.23%) Power BI
16 10 (19.23%) Fivetran
16 10 (19.23%) JIRA
16 10 (19.23%) Stakeholder Management
17 9 (17.31%) Azure

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:

Application Platforms
1 11 (21.15%) Apache Airflow
2 4 (7.69%) Apache Spark
3 2 (3.85%) Apache
3 2 (3.85%) Oracle Application Server
Applications
1 2 (3.85%) Microsoft Excel
Cloud Services
1 24 (46.15%) Snowflake
2 23 (44.23%) dbt
3 14 (26.92%) Google Analytics
4 11 (21.15%) AWS
5 10 (19.23%) Fivetran
5 10 (19.23%) Power Platform
6 9 (17.31%) Azure
7 4 (7.69%) Azure Synapse Analytics
7 4 (7.69%) GitHub
7 4 (7.69%) Trello
8 3 (5.77%) Amazon S3
8 3 (5.77%) Google Data Studio
9 2 (3.85%) GCP
9 2 (3.85%) Google Sheets
9 2 (3.85%) Matillion
10 1 (1.92%) Amazon Kinesis
10 1 (1.92%) Azure Data Factory
Communications & Networking
1 1 (1.92%) HTTP
Database & Business Intelligence
1 35 (67.31%) Data Warehouse
2 27 (51.92%) Tableau
3 13 (25.00%) Looker
4 10 (19.23%) Power BI
5 9 (17.31%) Metadata
6 7 (13.46%) Amazon Redshift
7 6 (11.54%) Star Schema
8 5 (9.62%) Data Lake
8 5 (9.62%) NoSQL
9 4 (7.69%) Data Mart
10 3 (5.77%) Amazon Athena
10 3 (5.77%) Amazon QuickSight
10 3 (5.77%) Big Data
11 2 (3.85%) Amazon DynamoDB
11 2 (3.85%) BigQuery
11 2 (3.85%) Oracle Database
11 2 (3.85%) Oracle Database 12c
11 2 (3.85%) Oracle ODI
11 2 (3.85%) Presto
11 2 (3.85%) Relational Database
Development Applications
1 10 (19.23%) JIRA
2 2 (3.85%) GitLab
2 2 (3.85%) Oracle APEX
3 1 (1.92%) ER Studio
3 1 (1.92%) ERwin
3 1 (1.92%) Git (software)
General
1 14 (26.92%) Social Skills
2 6 (11.54%) Analytical Skills
2 6 (11.54%) Organisational Skills
2 6 (11.54%) Presentation Skills
3 5 (9.62%) Finance
4 4 (7.69%) Marketing
5 3 (5.77%) Banking
5 3 (5.77%) Digital Economy
6 2 (3.85%) Publishing
7 1 (1.92%) Retail
Job Titles
1 16 (30.77%) Data Engineer
2 12 (23.08%) Analyst
2 12 (23.08%) Data Analyst
3 7 (13.46%) Architect
3 7 (13.46%) Data Architect
3 7 (13.46%) Senior Data Engineer
4 5 (9.62%) Data Manager
4 5 (9.62%) Developer
4 5 (9.62%) Product Analyst
5 4 (7.69%) Insight Manager
6 3 (5.77%) Data Warehouse Developer
6 3 (5.77%) Principal Engineer
7 2 (3.85%) AWS Developer
7 2 (3.85%) Azure Developer
7 2 (3.85%) Enterprise Architect
7 2 (3.85%) Enterprise Data Architect
7 2 (3.85%) ETL Developer
8 1 (1.92%) AWS Architect
8 1 (1.92%) AWS Consultant
8 1 (1.92%) Data Analytics Manager
Libraries, Frameworks & Software Standards
1 7 (13.46%) Kafka
2 6 (11.54%) PySpark
3 2 (3.85%) JSON
3 2 (3.85%) NumPy
3 2 (3.85%) Oracle GoldenGate
3 2 (3.85%) Pandas
4 1 (1.92%) .NET
4 1 (1.92%) HTML
4 1 (1.92%) PostGIS
4 1 (1.92%) Web Services
4 1 (1.92%) XML
Miscellaneous
1 4 (7.69%) Clustering
2 3 (5.77%) Data Structures
2 3 (5.77%) Video Conferencing
3 2 (3.85%) Management Information System
4 1 (1.92%) Algorithms
4 1 (1.92%) FMCG
4 1 (1.92%) Social Media
Operating Systems
1 1 (1.92%) Linux
Processes & Methodologies
1 37 (71.15%) Data Modelling
2 33 (63.46%) Analytics
3 23 (44.23%) Business Intelligence
4 20 (38.46%) ETL
5 18 (34.62%) Problem-Solving
6 15 (28.85%) Visualisation
7 14 (26.92%) Data Engineering
8 13 (25.00%) Agile Software Development
8 13 (25.00%) Data Analytics
9 12 (23.08%) CRM
10 11 (21.15%) Data Analysis
10 11 (21.15%) Data Science
11 10 (19.23%) Stakeholder Management
12 9 (17.31%) Data Visualisation
13 8 (15.38%) Dashboard Development
14 7 (13.46%) Data Architecture
14 7 (13.46%) Data Pipeline
14 7 (13.46%) Use Case
15 6 (11.54%) B2C
15 6 (11.54%) Backlog Refinement
Programming Languages
1 40 (76.92%) SQL
2 19 (36.54%) Python
3 5 (9.62%) C
4 3 (5.77%) Java
5 2 (3.85%) C#
5 2 (3.85%) PL/SQL
5 2 (3.85%) Scala
6 1 (1.92%) Bash Shell
6 1 (1.92%) LookML
6 1 (1.92%) PowerShell
6 1 (1.92%) R
Qualifications
1 2 (3.85%) Degree
Quality Assurance & Compliance
1 3 (5.77%) Data Quality
1 3 (5.77%) GDPR
System Software
1 1 (1.92%) Docker
Vendors
1 20 (38.46%) Google
2 3 (5.77%) Oracle
3 2 (3.85%) Databricks
3 2 (3.85%) Microsoft
4 1 (1.92%) Netezza
4 1 (1.92%) Sparx