Snowflake Schema
UK

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

6 months to
5 May 2024
Same period 2023 Same period 2022
Rank 869 927 1127
Rank change year-on-year +58 +200 -264
Permanent jobs citing Snowflake Schema 45 37 108
As % of all permanent jobs advertised in the UK 0.046% 0.036% 0.069%
As % of the Database & Business Intelligence category 0.25% 0.17% 0.25%
Number of salaries quoted 20 15 55
10th Percentile £44,000 - £41,250
25th Percentile £52,250 £52,500 £43,750
Median annual salary (50th Percentile) £67,500 £65,000 £55,000
Median % change year-on-year +3.85% +18.18% -31.25%
75th Percentile £88,750 £75,000 £75,000
90th Percentile £97,500 £82,500 £88,750
UK excluding London median annual salary £60,000 £80,000 £47,500
% change year-on-year -25.00% +68.42% -52.50%

All Database and Business Intelligence Skills
UK

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.

Permanent vacancies with a requirement for database or business intelligence skills 18,114 22,080 43,591
As % of all permanent jobs advertised in the UK 18.39% 21.34% 27.82%
Number of salaries quoted 12,551 13,783 21,426
10th Percentile £35,000 £37,500 £36,250
25th Percentile £42,725 £47,500 £45,000
Median annual salary (50th Percentile) £57,500 £65,000 £60,000
Median % change year-on-year -11.54% +8.33% +9.09%
75th Percentile £76,250 £83,750 £79,750
90th Percentile £95,000 £102,500 £95,000
UK excluding London median annual salary £52,500 £55,000 £52,500
% change year-on-year -4.55% +4.76% +7.14%

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 5 May 2024.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 12 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 May 2024. 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
Jobs
England +116 45 £67,500 -5.00% 17
UK excluding London +8 30 £60,000 -25.00% 11
Work from Home +74 18 £47,500 -13.64% 14
London +124 15 £82,500 +22.95% 6
North of England +46 11 £67,500 - 3
North West - 9 £82,500 - 3
South West -21 7 £85,000 +6.25% 1
South East - 6 - - 3
West Midlands - 5 £35,000 - 4
Midlands - 5 £35,000 - 4
Yorkshire +77 2 £66,250 -
East of England +17 1 £55,000 -12.00%

Snowflake Schema
Co-occurring Skills and Capabilities by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 1 (2.22%) Apache
1 1 (2.22%) Apache Airflow
1 1 (2.22%) Apache Spark
Applications
1 6 (13.33%) Microsoft Office
1 6 (13.33%) Trello
Business Applications
1 1 (2.22%) NetSuite
Cloud Services
1 29 (64.44%) Power Platform
2 23 (51.11%) Azure
3 13 (28.89%) AWS
4 7 (15.56%) Snowflake
5 4 (8.89%) GCP
5 4 (8.89%) PowerApps
6 3 (6.67%) Amazon S3
6 3 (6.67%) SaaS
7 2 (4.44%) Azure DevOps
7 2 (4.44%) dbt
7 2 (4.44%) IaaS
7 2 (4.44%) Matillion
7 2 (4.44%) PaaS
8 1 (2.22%) AWS Lambda
8 1 (2.22%) Azure Data Factory
8 1 (2.22%) Serverless
Database & Business Intelligence
1 29 (64.44%) Power BI
2 27 (60.00%) Star Schema
3 23 (51.11%) Data Warehouse
4 14 (31.11%) Tableau
5 12 (26.67%) SQL Server Analysis Services
5 12 (26.67%) SQL Server Integration Services
5 12 (26.67%) SQL Server Reporting Services
6 10 (22.22%) Big Data
7 8 (17.78%) Data Lake
8 7 (15.56%) Data Vault
8 7 (15.56%) Relational Database
9 6 (13.33%) SQL Server
10 3 (6.67%) NoSQL
11 2 (4.44%) Amazon Redshift
11 2 (4.44%) BigQuery
12 1 (2.22%) Amazon Athena
12 1 (2.22%) Azure SQL Data Warehouse
12 1 (2.22%) Delta Lake
12 1 (2.22%) Impala
12 1 (2.22%) Metadata
Development Applications
1 7 (15.56%) JIRA
2 1 (2.22%) ERwin
2 1 (2.22%) Jenkins
2 1 (2.22%) Visual Studio
General
1 13 (28.89%) Social Skills
2 11 (24.44%) Analytical Skills
2 11 (24.44%) Finance
2 11 (24.44%) Retail
3 7 (15.56%) Documentation Skills
4 1 (2.22%) Banking
4 1 (2.22%) Legal
Job Titles
1 9 (20.00%) Architect
2 8 (17.78%) Data Engineer
3 6 (13.33%) Analyst
3 6 (13.33%) Business Analyst
3 6 (13.33%) Data Architect
3 6 (13.33%) Technical Analyst
3 6 (13.33%) Technical Business Analyst
4 5 (11.11%) Business Intelligence Architect
5 4 (8.89%) Senior
6 3 (6.67%) Business Intelligence Developer
6 3 (6.67%) Business Intelligence Manager
6 3 (6.67%) Business Manager
6 3 (6.67%) Data Modeller
6 3 (6.67%) Developer
6 3 (6.67%) Senior Business Manager
6 3 (6.67%) Senior Manager
6 3 (6.67%) Technical Architect
7 2 (4.44%) Data Manager
7 2 (4.44%) Data Warehouse Architect
7 2 (4.44%) Delivery Manager
Libraries, Frameworks & Software Standards
1 3 (6.67%) .NET
1 3 (6.67%) JSON
1 3 (6.67%) MDX
1 3 (6.67%) XML
2 2 (4.44%) PySpark
3 1 (2.22%) Apache NiFi
3 1 (2.22%) Pandas
Miscellaneous
1 6 (13.33%) Onboarding
2 5 (11.11%) Data Structures
3 3 (6.67%) NHS
4 2 (4.44%) Product Ownership
5 1 (2.22%) Analytical Mindset
5 1 (2.22%) Clustering
5 1 (2.22%) Greenfield Project
5 1 (2.22%) Self-Motivation
5 1 (2.22%) SWIFT Messaging Network
Processes & Methodologies
1 33 (73.33%) Analytics
2 31 (68.89%) Data Modelling
3 30 (66.67%) Business Intelligence
4 26 (57.78%) ETL
5 18 (40.00%) Data Science
6 15 (33.33%) Visualisation
7 13 (28.89%) Migration
8 12 (26.67%) Data Architecture
8 12 (26.67%) Problem-Solving
9 11 (24.44%) Agile
9 11 (24.44%) Data Governance
9 11 (24.44%) Data Transformation
10 10 (22.22%) Data Cleansing
10 10 (22.22%) DevOps
11 9 (20.00%) Data Strategy
11 9 (20.00%) Data Visualisation
11 9 (20.00%) Performance Optimisation
11 9 (20.00%) Stakeholder Management
12 8 (17.78%) Data Engineering
12 8 (17.78%) Storyboarding
Programming Languages
1 29 (64.44%) SQL
2 21 (46.67%) Python
3 14 (31.11%) R
4 11 (24.44%) T-SQL
5 6 (13.33%) Data Analysis Expressions
6 2 (4.44%) C#
7 1 (2.22%) Java
7 1 (2.22%) Scala
Qualifications
1 9 (20.00%) Degree
2 7 (15.56%) Master's Degree
3 6 (13.33%) Azure Certification
3 6 (13.33%) BPSS Clearance
3 6 (13.33%) IIBA
3 6 (13.33%) Security Cleared
4 1 (2.22%) Computer Science Degree
4 1 (2.22%) TOGAF Certification
Quality Assurance & Compliance
1 21 (46.67%) Data Quality
2 1 (2.22%) QA
Systems Management
1 2 (4.44%) Terraform
Vendors
1 7 (15.56%) Microsoft
2 4 (8.89%) BiZZdesign
3 2 (4.44%) Databricks
4 1 (2.22%) Cloudera
4 1 (2.22%) GoldenSource
4 1 (2.22%) Google
4 1 (2.22%) Informatica
4 1 (2.22%) Talend