The table below looks at the statistics for Snowflake Schema skills in IT contracts advertised across the UK. Included is a guide to the average contractor rates offered in IT contracts that have cited Snowflake Schema over the 3 months to 31 July 2015 with a comparison to the same period in 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.

Location
3 months to
31 Jul 2015
Same period 2014 Same period 2013
Snowflake Schema
Rank 617 606 572
Rank change year-on-year
-11 -34
Contract jobs citing Snowflake Schema 3 5 7
As % of all contract IT jobs located in the UK 0.005% 0.009% 0.014%
As % of the Database & Business Intelligence category 0.024% 0.043% 0.063%
Number of daily rates quoted 0 3 4
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
- £425 £450
Average daily rate % change year-on-year
- -5.55%
UK excluding London average daily rate - - £338
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average 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
12658 11687 11165
As % of all contract IT jobs located in the UK 22.26% 21.38% 21.85%
Number of daily rates quoted 8266 7232 6823
Average daily rate £400 £400 £400
90% offered a daily rate of more than £288 £270 £250
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £365 £350 £350
% change year-on-year
+4.28% -
Number of hourly rates quoted 168 185 218
Average hourly rate £28.50 £28.99 £30.00
Average hourly rate % change year-on-year
-1.69% -3.36%
90% offered a hourly rate of more than £17.00 £13.27 £17.00
10% offered a hourly rate of more than £54.31 £67.00 £51.30
UK excluding London average hourly rate £30.00 £28.50 £30.00
% change year-on-year
+5.26% -5.00%

Snowflake Schema
Jobs Demand Trend

This chart provides the 3-month moving total of IT contractor jobs citing Snowflake Schema within the UK as a proportion of the total demand within 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 average contractor rates quoted in IT jobs citing Snowflake Schema within the UK over the 3 months to 31 July 2015. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -27 3 - - 1
London -3 2 - -
Dorset - 1 - -
South West - 1 - -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 31 July 2015, IT contractor jobs within the UK citing Snowflake Schema also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Snowflake Schema.

1 12 (92.31%) Data Warehouse
2 10 (76.92%) ETL
3 9 (69.23%) Star Schema
3 9 (69.23%) SQL
3 9 (69.23%) Data Modelling
4 7 (53.85%) Performance Tuning
5 6 (46.15%) Finance
5 6 (46.15%) Business Intelligence
6 5 (38.46%) OLAP
6 5 (38.46%) Informatica
6 5 (38.46%) Agile Software Development
7 3 (23.08%) Oracle
7 3 (23.08%) Cognos
7 3 (23.08%) Time Management
7 3 (23.08%) Dimensional Modelling
7 3 (23.08%) QlikView
7 3 (23.08%) ActiveReports
7 3 (23.08%) Cognos Report Studio
7 3 (23.08%) Cognos Framework Manager
7 3 (23.08%) Analytics
7 3 (23.08%) Security Architecture
7 3 (23.08%) Analytical Skills
7 3 (23.08%) Logical Data Model
7 3 (23.08%) Physical Data Model
8 2 (15.38%) Coaching
8 2 (15.38%) Tableau
8 2 (15.38%) Test Strategy
8 2 (15.38%) Kimball Methodology
8 2 (15.38%) Oracle Payables
8 2 (15.38%) Visualisation

Snowflake Schema
Top Related IT Skills by Category

For the 6 months to 31 July 2015, IT contractor jobs within the UK citing Snowflake Schema also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Snowflake Schema. Up to 20 skills are shown per category.

Applications
1 2 (15.38%) MS Excel
Business Applications
1 2 (15.38%) Oracle Financials
1 2 (15.38%) Oracle Payables
Database & Business Intelligence
1 12 (92.31%) Data Warehouse
2 9 (69.23%) Star Schema
3 5 (38.46%) OLAP
4 3 (23.08%) QlikView
4 3 (23.08%) ActiveReports
4 3 (23.08%) Cognos Report Studio
4 3 (23.08%) Cognos Framework Manager
5 2 (15.38%) SQL Server Integration Services
6 1 (7.69%) Oracle OLAP
6 1 (7.69%) SQL Server Analysis Services
6 1 (7.69%) Oracle BI EE
6 1 (7.69%) SQL Server
6 1 (7.69%) OLTP
6 1 (7.69%) Oracle Database 10g
6 1 (7.69%) BusinessObjects
6 1 (7.69%) PowerCenter
6 1 (7.69%) DataStage
6 1 (7.69%) Oracle OWB
6 1 (7.69%) SQL Server Reporting Services
6 1 (7.69%) Data Mart
Development Applications
1 2 (15.38%) ERwin
General
1 6 (46.15%) Finance
2 1 (7.69%) Games
2 1 (7.69%) Banking
2 1 (7.69%) Marketing
2 1 (7.69%) French Language
Job Titles
1 7 (53.85%) Developer
2 4 (30.77%) Data Architect
2 4 (30.77%) Architect
3 3 (23.08%) Lead Developer
3 3 (23.08%) Data Warehouse Developer
3 3 (23.08%) SQL Developer
4 2 (15.38%) Team Leader
5 1 (7.69%) Database Developer
5 1 (7.69%) Enterprise Architect
5 1 (7.69%) Data Modeller
5 1 (7.69%) Data Warehouse Architect
5 1 (7.69%) Database Team Leader
5 1 (7.69%) SQL Database Developer
5 1 (7.69%) Business Intelligence Developer
5 1 (7.69%) Enterprise Data Architect
5 1 (7.69%) OBIEE Developer
5 1 (7.69%) Senior Data Modeller
5 1 (7.69%) QlikView Developer
Libraries, Frameworks & Software Standards
1 1 (7.69%) DOM
1 1 (7.69%) MDX
Miscellaneous
1 3 (23.08%) Analytical Skills
2 2 (15.38%) Visualisation
3 1 (7.69%) NHS
3 1 (7.69%) Data Structures
Operating Systems
1 2 (15.38%) UNIX
1 2 (15.38%) Linux
2 1 (7.69%) MVS
2 1 (7.69%) Windows
Processes & Methodologies
1 10 (76.92%) ETL
2 9 (69.23%) Data Modelling
3 7 (53.85%) Performance Tuning
4 6 (46.15%) Business Intelligence
5 5 (38.46%) Agile Software Development
6 3 (23.08%) Time Management
6 3 (23.08%) Dimensional Modelling
6 3 (23.08%) Security Architecture
6 3 (23.08%) Logical Data Model
6 3 (23.08%) Physical Data Model
6 3 (23.08%) Analytics
7 2 (15.38%) Test Strategy
7 2 (15.38%) Kimball Methodology
7 2 (15.38%) Coaching
7 2 (15.38%) User Acceptance Testing
7 2 (15.38%) ERP
7 2 (15.38%) Requirements Analysis
7 2 (15.38%) Project Management
8 1 (7.69%) Risk Management
8 1 (7.69%) Migration
Programming Languages
1 9 (69.23%) SQL
2 2 (15.38%) PL/SQL
Qualifications
1 1 (7.69%) Degree
Quality Assurance & Compliance
1 2 (15.38%) QA
Vendors
1 5 (38.46%) Informatica
2 3 (23.08%) Oracle
2 3 (23.08%) Cognos
3 2 (15.38%) SAP
3 2 (15.38%) Tableau
3 2 (15.38%) Microsoft
4 1 (7.69%) IBM