Period
to 12 July 2020

The following table provides summary statistics for permanent job vacancies advertised in the Midlands 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 12 July 2020 with a comparison to the same period in the previous 2 years.

Snowflake Schema
England > Midlands
6 months to
12 Jul 2020
Same period 2019 Same period 2018
Rank 207 - 401
Rank change year-on-year - +401 -4
Permanent jobs citing Snowflake Schema 28 0 1
As % of all permanent jobs advertised in the Midlands 0.47% - 0.007%
As % of the Database & Business Intelligence category 1.75% - 0.023%
Number of salaries quoted 24 0 0
Median annual salary £55,000 - -
England median annual salary £62,500 £52,500 £52,500
% change year-on-year +19.05% - +23.53%

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 advertised in the Midlands with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Midlands
Permanent vacancies with a requirement for database or business intelligence skills 1,604 3,278 4,319
As % of all permanent IT jobs advertised in the Midlands 26.88% 26.94% 29.08%
Number of salaries quoted 1,386 2,653 3,622
Median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +6.25%
10th Percentile £28,875 £26,750 £27,000
90th Percentile £67,500 £65,000 £61,250
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

Snowflake Schema
Job Vacancy Trend in the Midlands

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

Job vacancy trend for Snowflake Schema in the Midlands

Snowflake Schema
Salary Trend in the Midlands

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

Salary trend for Snowflake Schema in the Midlands

Snowflake Schema
Salary Histogram in the Midlands

Salary distribution for jobs citing Snowflake Schema in the Midlands over the 6 months to 12 July 2020.

Salary histogram for Snowflake Schema in the Midlands

Snowflake Schema
Job Locations in the Midlands

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the Midlands region over the 6 months to 12 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
West Midlands - 19 £55,000 -
East Midlands - 9 £75,000 -
Snowflake Schema
England

For the 6 months to 12 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 across the Midlands region with a requirement for Snowflake Schema.

1 28 (100.00%) Data Modelling
2 27 (96.43%) Agile Software Development
3 26 (92.86%) Finance
4 24 (85.71%) ETL
4 24 (85.71%) SQL Server
5 23 (82.14%) Azure
5 23 (82.14%) Big Data
6 22 (78.57%) Data Quality
7 21 (75.00%) SQL
8 20 (71.43%) SQL Server Integration Services
9 19 (67.86%) Business Intelligence
9 19 (67.86%) Microsoft
9 19 (67.86%) DevOps
9 19 (67.86%) Data Engineering
9 19 (67.86%) Power BI
9 19 (67.86%) Power Platform
10 18 (64.29%) Data Lineage
10 18 (64.29%) Data Lake
10 18 (64.29%) ASP.NET Web API
10 18 (64.29%) Dashboard Development
10 18 (64.29%) Data Analysis Expressions (DAX)
10 18 (64.29%) User Stories
10 18 (64.29%) HTML5
10 18 (64.29%) Git (software)
10 18 (64.29%) MVC
10 18 (64.29%) ASP.NET
10 18 (64.29%) CSS
10 18 (64.29%) .NET
10 18 (64.29%) HTML
10 18 (64.29%) SQL Server Analysis Services

Snowflake Schema
Co-occurring IT Skills in the Midlands 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 5 (17.86%) Apache Spark
2 4 (14.29%) Elasticsearch
2 4 (14.29%) nginx
2 4 (14.29%) Tomcat
Business Applications
1 4 (14.29%) Eikon
Cloud Services
1 23 (82.14%) Azure
2 19 (67.86%) Power Platform
3 9 (32.14%) AWS
4 5 (17.86%) Amazon S3
4 5 (17.86%) GCP
5 4 (14.29%) Amazon EC2
5 4 (14.29%) Amazon ECS
5 4 (14.29%) Amazon EKS
5 4 (14.29%) AWS Lambda
5 4 (14.29%) SaaS
5 4 (14.29%) Serverless
Database & Business Intelligence
1 24 (85.71%) SQL Server
2 23 (82.14%) Big Data
3 20 (71.43%) SQL Server Integration Services
4 19 (67.86%) Power BI
5 18 (64.29%) Data Lake
5 18 (64.29%) SQL Server Analysis Services
6 14 (50.00%) Data Warehouse
7 7 (25.00%) NoSQL
8 5 (17.86%) Amazon Redshift
8 5 (17.86%) BigQuery
8 5 (17.86%) PostgreSQL
9 4 (14.29%) Amazon Aurora
9 4 (14.29%) Flink
9 4 (14.29%) Hadoop
9 4 (14.29%) HBase
9 4 (14.29%) MySQL
9 4 (14.29%) OLAP
9 4 (14.29%) SQL Server Reporting Services
10 3 (10.71%) CouchDB
10 3 (10.71%) MongoDB
Development Applications
1 18 (64.29%) Git (software)
2 4 (14.29%) JIRA
3 3 (10.71%) ERwin
3 3 (10.71%) PowerDesigner
General
1 26 (92.86%) Finance
2 2 (7.14%) Marketing
3 1 (3.57%) Banking
Job Titles
1 15 (53.57%) Data Engineer
2 7 (25.00%) Architect
2 7 (25.00%) Data Architect
3 4 (14.29%) Development Engineer
3 4 (14.29%) Senior Architect
3 4 (14.29%) Senior Data Architect
3 4 (14.29%) Web Engineer
4 3 (10.71%) Senior Solutions Architect
4 3 (10.71%) Solutions Architect
5 1 (3.57%) Database Developer
5 1 (3.57%) Developer
5 1 (3.57%) Platform Manager
5 1 (3.57%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 18 (64.29%) .NET
1 18 (64.29%) ASP.NET
1 18 (64.29%) ASP.NET Web API
1 18 (64.29%) CSS
1 18 (64.29%) HTML
1 18 (64.29%) HTML5
2 14 (50.00%) ASP.NET MVC
3 8 (28.57%) Kafka
4 7 (25.00%) JSON
5 4 (14.29%) Apache Avro
5 4 (14.29%) GraphQL
5 4 (14.29%) REST
5 4 (14.29%) SOAP
5 4 (14.29%) Web Services
6 3 (10.71%) FIX Protocol
6 3 (10.71%) XML
Miscellaneous
1 7 (25.00%) Analytical Skills
2 4 (14.29%) Cloud Native
2 4 (14.29%) Replication
2 4 (14.29%) Self-Motivation
3 3 (10.71%) Management Information System
3 3 (10.71%) Reference Data
Processes & Methodologies
1 28 (100.00%) Data Modelling
2 27 (96.43%) Agile Software Development
3 24 (85.71%) ETL
4 19 (67.86%) Business Intelligence
4 19 (67.86%) Data Engineering
4 19 (67.86%) DevOps
5 18 (64.29%) Dashboard Development
5 18 (64.29%) Data Lineage
5 18 (64.29%) MVC
5 18 (64.29%) User Stories
6 8 (28.57%) Analytics
7 7 (25.00%) Software Engineering
8 6 (21.43%) Data Governance
9 5 (17.86%) Data Development
9 5 (17.86%) Microservices
10 4 (14.29%) IT Strategy
10 4 (14.29%) MapReduce
10 4 (14.29%) Scrum
10 4 (14.29%) Software Architecture
10 4 (14.29%) Use Case
Programming Languages
1 21 (75.00%) SQL
2 18 (64.29%) Data Analysis Expressions (DAX)
3 5 (17.86%) Java
3 5 (17.86%) Python
4 1 (3.57%) C#
4 1 (3.57%) PL/SQL
4 1 (3.57%) Scala
Qualifications
1 4 (14.29%) Degree
2 3 (10.71%) AWS Certification
2 3 (10.71%) Computer Science Degree
2 3 (10.71%) Master's Degree
Quality Assurance & Compliance
1 22 (78.57%) Data Quality
2 3 (10.71%) QA
System Software
1 4 (14.29%) Varnish
2 1 (3.57%) Apache Flume
Vendors
1 19 (67.86%) Microsoft
2 8 (28.57%) Oracle
3 4 (14.29%) Google
4 1 (3.57%) MicroStrategy
4 1 (3.57%) SnapLogic
4 1 (3.57%) StreamSets
4 1 (3.57%) Tableau