The table below looks at the statistics for Snowflake Schema skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited Snowflake Schema over the 3 months to 24 September 2016 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
24 Sep 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 641 - 630
Rank change year-on-year
- 0
Contract jobs citing Snowflake Schema 6 0 9
As % of all contract IT jobs located in the UK 0.011% - 0.016%
As % of the Database & Business Intelligence category 0.050% - 0.072%
Number of daily rates quoted 2 0 5
Median daily rate £576 - £363
90% offered a daily rate of more than £557 - £300
10% offered a daily rate of more than £595 - £423
UK excluding London median daily rate - - £300
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised across the UK.

Database & Business Intelligence Category
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
12014 13329 12437
As % of all contract IT jobs located in the UK 22.72% 22.96% 21.49%
Number of daily rates quoted 7942 8828 7829
Median daily rate £425 £415 £400
Median daily rate % change year-on-year
+2.40% +3.75%
90% offered a daily rate of more than £300 £300 £270
10% offered a daily rate of more than £575 £563 £550
UK excluding London median daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 191 199 204
Median hourly rate £35.00 £33.55 £25.00
Median hourly rate % change year-on-year
+4.32% +34.20%
90% offered a hourly rate of more than £13.00 £12.78 £12.60
10% offered a hourly rate of more than £48.00 £45.00 £63.00
UK excluding London median hourly rate £36.00 £33.55 £23.75
% change year-on-year
+7.30% +41.26%

Snowflake Schema
Jobs Demand Trend

The demand trend of contract jobs citing Snowflake Schema as a proportion of all IT contracts with a match in the Database & Business Intelligence category.

Snowflake Schema Jobs Demand Trend in the UK

Snowflake Schema
Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Snowflake Schema within the UK.

Snowflake Schema Daily Rate Trend in the UK

Snowflake Schema
Top 4 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Snowflake Schema within the UK over the 3 months to 24 September 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London - 4 £576 -
England - 4 £576 - 2
Glasgow - 2 - -
Scotland - 2 - -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 24 September 2016, IT contractor jobs citing Snowflake Schema also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for Snowflake Schema.

1 11 (84.62%) Data Warehouse
2 9 (69.23%) Star Schema
2 9 (69.23%) ETL
2 9 (69.23%) Business Intelligence
3 8 (61.54%) Teradata
3 8 (61.54%) Big Data
3 8 (61.54%) Analytics
4 7 (53.85%) Relational Database
4 7 (53.85%) DataStage
4 7 (53.85%) Oracle
5 6 (46.15%) Data Modelling
6 5 (38.46%) Data Analytics
6 5 (38.46%) Finance
7 4 (30.77%) Hadoop
7 4 (30.77%) Data Cleansing
7 4 (30.77%) Big Data Analytics
7 4 (30.77%) SQL Server
7 4 (30.77%) SQL
7 4 (30.77%) MySQL
7 4 (30.77%) MicroStrategy
7 4 (30.77%) Change Data Capture
8 3 (23.08%) Cognos Report Studio
8 3 (23.08%) Mentoring
8 3 (23.08%) Apache Spark
8 3 (23.08%) RDBMS
8 3 (23.08%) IBM
8 3 (23.08%) SQLPlus
8 3 (23.08%) Control-M
8 3 (23.08%) PL/SQL
8 3 (23.08%) Python

Snowflake Schema
Top Related 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 3 (23.08%) Apache Spark
Business Applications
1 2 (15.38%) Cognos Business Intelligence
Database & Business Intelligence
1 11 (84.62%) Data Warehouse
2 9 (69.23%) Star Schema
3 8 (61.54%) Big Data
4 7 (53.85%) DataStage
4 7 (53.85%) Relational Database
5 4 (30.77%) Hadoop
5 4 (30.77%) MySQL
5 4 (30.77%) SQL Server
6 3 (23.08%) Cognos Report Studio
6 3 (23.08%) RDBMS
6 3 (23.08%) SQLPlus
7 2 (15.38%) Apache Hive
7 2 (15.38%) Cognos Framework Manager
7 2 (15.38%) OLAP
7 2 (15.38%) SQL Server Integration Services
8 1 (7.69%) Data Lake
8 1 (7.69%) Data Mart
8 1 (7.69%) OLTP
8 1 (7.69%) Oracle OLAP
8 1 (7.69%) QlikView
Development Applications
1 2 (15.38%) Talend Open Studio
2 1 (7.69%) ERwin
General
1 5 (38.46%) Finance
2 3 (23.08%) Banking
3 1 (7.69%) Corporate Banking
Job Titles
1 10 (76.92%) Developer
2 5 (38.46%) ETL Developer
3 4 (30.77%) Lead Developer
4 3 (23.08%) Data Warehouse Developer
4 3 (23.08%) DataStage Developer
5 2 (15.38%) Applications Developer
5 2 (15.38%) DataStage ETL Developer
5 2 (15.38%) MicroStrategy Developer
6 1 (7.69%) Analyst
6 1 (7.69%) Architect
6 1 (7.69%) Data Analyst
6 1 (7.69%) Data Architect
6 1 (7.69%) Data Integration Architect
6 1 (7.69%) ETL Architect
6 1 (7.69%) ETL Tester
6 1 (7.69%) Integration Architect
6 1 (7.69%) SQL Analyst
6 1 (7.69%) SQL Data Analyst
6 1 (7.69%) SQL Developer
6 1 (7.69%) Tester
Miscellaneous
1 3 (23.08%) Data Integration
2 1 (7.69%) Analytical Skills
2 1 (7.69%) Computer Science
2 1 (7.69%) Data Structures
Processes & Methodologies
1 9 (69.23%) Business Intelligence
1 9 (69.23%) ETL
2 8 (61.54%) Analytics
3 6 (46.15%) Data Modelling
4 5 (38.46%) Data Analytics
5 4 (30.77%) Big Data Analytics
5 4 (30.77%) Change Data Capture
5 4 (30.77%) Data Cleansing
6 3 (23.08%) Data Management
6 3 (23.08%) Mentoring
7 2 (15.38%) Data Analysis
7 2 (15.38%) Data Mapping
7 2 (15.38%) Kimball Methodology
7 2 (15.38%) MapReduce
7 2 (15.38%) SDLC
8 1 (7.69%) Agile Software Development
8 1 (7.69%) Continuous Improvement
8 1 (7.69%) Data Architecture
8 1 (7.69%) Enterprise Architecture
8 1 (7.69%) Systems Analysis
Programming Languages
1 4 (30.77%) SQL
2 3 (23.08%) PL/SQL
2 3 (23.08%) Python
3 2 (15.38%) Java
Quality Assurance & Compliance
1 1 (7.69%) Data Quality
Systems Management
1 3 (23.08%) Control-M
Vendors
1 8 (61.54%) Teradata
2 7 (53.85%) Oracle
3 4 (30.77%) MicroStrategy
4 3 (23.08%) Cognos
4 3 (23.08%) IBM
5 2 (15.38%) Alteryx
5 2 (15.38%) Talend