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

3 months to
29 Jun 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 924 972 963
Rank change year-on-year
+48 -9
Permanent jobs citing Snowflake Schema 8 6 26
As % of all permanent IT jobs located in the UK 0.008% 0.005% 0.022%
As % of the Database & Business Intelligence category 0.027% 0.017% 0.068%
Number of salaries quoted 7 6 24
Median salary £60,000 £41,500 £45,000
Median salary % change year-on-year
+44.57% -7.77%
90% offered a salary of more than £55,000 £39,500 £40,000
10% offered a salary of more than £77,500 £50,000 £60,000
UK excluding London median salary £55,000 £41,500 £42,500
% change year-on-year
+32.53% -2.35%

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

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
29362 36301 38224
As % of all permanent IT jobs located in the UK 29.94% 32.67% 32.15%
Number of salaries quoted 25032 30615 32829
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

Snowflake Schema
Jobs Demand Trend

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

Snowflake Schema Jobs Demand Trend in the UK

Snowflake Schema
Salary Trend

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

Snowflake Schema Salary Trend in the UK

Snowflake Schema
Salary Histogram

This chart provides a salary histogram for IT jobs citing Snowflake Schema over the 3 months to 29 June 2016 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 7 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 3 months to 29 June 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
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +50 7 £60,000 +44.57% 1
South West - 3 £55,000 -
Gloucestershire - 3 £55,000 -
Cheltenham - 3 £55,000 -
London +22 2 £78,750 +57.50% 1
North West - 2 £60,000 -
Manchester - 2 £60,000 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 29 June 2016, IT 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 job ads with a requirement for Snowflake Schema.

1 16 (94.12%) Business Intelligence
2 15 (88.24%) Data Warehouse
3 14 (82.35%) SQL
4 13 (76.47%) ETL
5 10 (58.82%) Star Schema
5 10 (58.82%) Microsoft
5 10 (58.82%) SQL Server
5 10 (58.82%) OLAP
5 10 (58.82%) SQL Server Reporting Services
5 10 (58.82%) SQL Server Integration Services
5 10 (58.82%) SQL Server Analysis Services
6 9 (52.94%) Data Mart
6 9 (52.94%) Data Modelling
7 8 (47.06%) RDBMS
7 8 (47.06%) Refactoring
7 8 (47.06%) Kimball Methodology
7 8 (47.06%) Relational Database
8 7 (41.18%) Power BI
9 5 (29.41%) Data Structures
9 5 (29.41%) MDX
9 5 (29.41%) Test Scripting
9 5 (29.41%) OpenView
9 5 (29.41%) BusinessObjects
9 5 (29.41%) MicroStrategy
9 5 (29.41%) BizTalk Server
9 5 (29.41%) C#
9 5 (29.41%) VB
9 5 (29.41%) Visual Studio
9 5 (29.41%) SOAP
9 5 (29.41%) Web Services

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 5 (29.41%) BizTalk Server
2 2 (11.76%) Apache Pig
Business Applications
1 2 (11.76%) Dynamics NAV
Cloud Services
1 3 (17.65%) Microsoft Azure
Database & Business Intelligence
1 15 (88.24%) Data Warehouse
2 10 (58.82%) OLAP
2 10 (58.82%) SQL Server
2 10 (58.82%) SQL Server Analysis Services
2 10 (58.82%) SQL Server Integration Services
2 10 (58.82%) SQL Server Reporting Services
2 10 (58.82%) Star Schema
3 9 (52.94%) Data Mart
4 8 (47.06%) RDBMS
4 8 (47.06%) Relational Database
5 7 (41.18%) Power BI
6 5 (29.41%) BusinessObjects
7 3 (17.65%) Azure SQL Database
7 3 (17.65%) Biml
7 3 (17.65%) SQL Server 2012
8 2 (11.76%) Apache Hive
8 2 (11.76%) Big Data
8 2 (11.76%) Hadoop
8 2 (11.76%) MySQL
8 2 (11.76%) QlikView
Development Applications
1 5 (29.41%) Visual Studio
2 3 (17.65%) ERwin
3 2 (11.76%) Git (software)
3 2 (11.76%) Team Foundation Server
General
1 2 (11.76%) Advertising
2 1 (5.88%) Banking
2 1 (5.88%) Finance
2 1 (5.88%) Legal
Job Titles
1 16 (94.12%) Developer
2 9 (52.94%) Business Intelligence Developer
3 5 (29.41%) Analyst
3 5 (29.41%) Analyst Developer
3 5 (29.41%) Business Intelligence Analyst
3 5 (29.41%) Developer Analyst
3 5 (29.41%) MicroStrategy Developer
3 5 (29.41%) Report Analyst
3 5 (29.41%) Report Developer
4 3 (17.65%) Business Intelligence Lead
4 3 (17.65%) Data Warehouse Developer
4 3 (17.65%) Lead Developer
5 1 (5.88%) Architect
5 1 (5.88%) Business Intelligence Architect
5 1 (5.88%) Data Architect
5 1 (5.88%) Data Integration Architect
5 1 (5.88%) Data Warehouse Architect
5 1 (5.88%) ETL Architect
5 1 (5.88%) Integration Architect
Libraries, Frameworks & Software Standards
1 5 (29.41%) MDX
1 5 (29.41%) SOAP
1 5 (29.41%) Web Services
1 5 (29.41%) XML
1 5 (29.41%) XSL
Miscellaneous
1 5 (29.41%) Data Structures
2 4 (23.53%) Analytical Skills
3 2 (11.76%) Visualisation
4 1 (5.88%) Data Integration
Processes & Methodologies
1 16 (94.12%) Business Intelligence
2 13 (76.47%) ETL
3 9 (52.94%) Data Modelling
4 8 (47.06%) Kimball Methodology
4 8 (47.06%) Refactoring
5 5 (29.41%) Test Scripting
6 4 (23.53%) Analytics
6 4 (23.53%) Data Cleansing
6 4 (23.53%) Data Transformation
6 4 (23.53%) Enterprise Architecture
6 4 (23.53%) High Availability
6 4 (23.53%) Open Source
6 4 (23.53%) Performance Tuning
7 3 (17.65%) Agile Software Development
7 3 (17.65%) Scrum
8 2 (11.76%) E-Commerce
8 2 (11.76%) Mentoring
9 1 (5.88%) Data Architecture
9 1 (5.88%) Kalman Filter
9 1 (5.88%) Master Data Management
Programming Languages
1 14 (82.35%) SQL
2 5 (29.41%) C#
2 5 (29.41%) VB
3 2 (11.76%) Python
3 2 (11.76%) R
3 2 (11.76%) T-SQL
Qualifications
1 4 (23.53%) Degree
Systems Management
1 5 (29.41%) OpenView
2 1 (5.88%) Oracle Enterprise Manager
Vendors
1 10 (58.82%) Microsoft
2 5 (29.41%) MicroStrategy
3 3 (17.65%) Alteryx
3 3 (17.65%) Teradata
4 2 (11.76%) Google
4 2 (11.76%) Oracle
4 2 (11.76%) Tableau
5 1 (5.88%) Cognos
London
Venturi
Salary: £60000.00 - £85000.00 per annum + Bonus and Benefits
Posted: 5 days ago