The table below looks at the statistics for Star 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 Star Schema over the 3 months to 19 September 2014 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
19 Sep 2014
Same period 2013 Same period 2012
Star Schema
Rank 536 498 536
Rank change year-on-year
-38 +38
Contract jobs citing Star Schema 76 88 68
As % of all contract IT jobs located in the UK 0.13% 0.17% 0.12%
As % of the Database & Business Intelligence category 0.64% 0.75% 0.57%
Number of daily rates quoted 55 57 29
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£375 £398 £450
Average daily rate % change year-on-year
-5.66% -11.66%
90% offered a daily rate of more than £292 £337 £275
10% offered a daily rate of more than £483 £525 £478
UK excluding London average daily rate £325 £388 £395
% change year-on-year
-16.12% -1.89%
Number of hourly rates quoted 0 0 2
Average hourly rate - - £40.75
UK excluding London average hourly rate - - £40.75

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
11910 11800 11987
As % of all contract IT jobs located in the UK 20.68% 22.37% 20.79%
Number of daily rates quoted 7516 7332 6837
Average daily rate £400 £388 £375
Average daily rate % change year-on-year
+3.22% +3.33%
90% offered a daily rate of more than £270 £260 £260
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £350 £345 £338
% change year-on-year
+1.44% +2.22%
Number of hourly rates quoted 176 198 331
Average hourly rate £29.75 £30.00 £31.00
Average hourly rate % change year-on-year
-0.83% -3.22%
90% offered a hourly rate of more than £13.00 £15.00 £15.25
10% offered a hourly rate of more than £67.00 £46.00 £45.00
UK excluding London average hourly rate £30.00 £30.00 £32.05
% change year-on-year
- -6.39%

Star Schema
Jobs Demand Trend

This chart provides the 3-month moving total of IT contractor jobs citing Star Schema within the UK as a proportion of the total demand within the Database & Business Intelligence category.

Star Schema Jobs Demand Trend in the UK

Star Schema
Daily Rate Trend

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

Star Schema Daily Rate Trend in the UK

Star Schema
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing Star Schema within the UK over the 3 months to 19 September 2014.

Star Schema Daily Rate Histogram in the UK

Star Schema
Hourly Rate Trend

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Star Schema within the UK.

Star Schema Hourly Rate Trend in the UK

Star Schema
Top 30 Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Star Schema within the UK over the 3 months to 19 September 2014. 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 68 £375 -5.66% 19
London +12 47 £414 +3.59% 9
Yorkshire - 10 £278 -
West Yorkshire - 10 £278 -
Leeds - 8 £284 -
City of London +20 6 £425 -10.52% 4
South East -3 4 £390 -38.33% 6
South Wales - 4 £325 - 1
Wales - 4 £325 - 1
Berkshire +1 3 £380 -39.92% 2
Cardiff - 3 £325 - 1
Scotland -13 2 £400 +8.47% 1
South West -55 2 £425 +11.98%
Manchester - 2 £331 -
North West - 2 £331 -
Reading +7 1 £380 -41.42% 1
East Midlands -1 1 £350 -6.66% 2
Glasgow -12 1 - - 1
East of England -20 1 - - 1
Hertfordshire -23 1 - - 1
Hampshire - 1 £400 - 2
Worcestershire - - - -
Merseyside - - - -
Nottinghamshire - - - -
Somerset - - - -
Surrey - - - - 1
Warwickshire - - - - 1
West Sussex - - - -
Cumbria - - - -
Derbyshire - - - - 2

Star Schema
Top 30 Related IT Skills

For the 6 months to 19 September 2014, IT contractor jobs within the UK citing Star 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 Star Schema.

1 93 (66.43%) SQL
2 88 (62.86%) ETL
3 84 (60.00%) Business Intelligence
4 73 (52.14%) Data Warehouse
4 73 (52.14%) SQL Server
5 71 (50.71%) SQL Server Integration Services
6 56 (40.00%) SQL Server Reporting Services
7 54 (38.57%) Agile Software Development
8 48 (34.29%) Oracle
9 40 (28.57%) Data Modelling
9 40 (28.57%) Kimball Methodology
10 37 (26.43%) SQL Server Analysis Services
11 36 (25.71%) SQL Server 2008
12 35 (25.00%) Microsoft
13 29 (20.71%) Finance
14 27 (19.29%) MS Excel
14 27 (19.29%) XML
15 26 (18.57%) T-SQL
16 23 (16.43%) Dimensional Modelling
17 22 (15.71%) OLAP
17 22 (15.71%) Business Objects
18 21 (15.00%) PL/SQL
18 21 (15.00%) Analytics
18 21 (15.00%) Inmon Methodology
19 19 (13.57%) C#
19 19 (13.57%) Relational Database
20 18 (12.86%) Performance Tuning
20 18 (12.86%) Informatica
21 16 (11.43%) UNIX
21 16 (11.43%) SQL Server 2005

Star Schema
Top Related IT Skills by Category

For the 6 months to 19 September 2014, IT contractor jobs within the UK citing Star 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 Star Schema. Up to 20 skills are shown per category.

Application Platforms
1 11 (7.86%) SharePoint
2 3 (2.14%) SAS
2 3 (2.14%) SharePoint 2010
Applications
1 27 (19.29%) MS Excel
2 7 (5.00%) PowerPivot
3 2 (1.43%) Spreadsheet
Business Applications
1 3 (2.14%) Cognos Business Intelligence
2 2 (1.43%) Dynamics CRM
3 1 (0.71%) Oracle Payables
3 1 (0.71%) Oracle Applications
3 1 (0.71%) Oracle Financials
3 1 (0.71%) Demantra
3 1 (0.71%) JDE World
3 1 (0.71%) Dynamics NAV
Cloud Services
1 2 (1.43%) Office 365
Communications & Networking
1 5 (3.57%) SAN
2 4 (2.86%) FTP
3 2 (1.43%) PuTTY
Database & Business Intelligence
1 73 (52.14%) Data Warehouse
1 73 (52.14%) SQL Server
2 71 (50.71%) SQL Server Integration Services
3 56 (40.00%) SQL Server Reporting Services
4 37 (26.43%) SQL Server Analysis Services
5 36 (25.71%) SQL Server 2008
6 22 (15.71%) OLAP
7 19 (13.57%) Relational Database
8 16 (11.43%) SQL Server 2005
9 15 (10.71%) Big Data
10 14 (10.00%) Oracle Database
11 12 (8.57%) Oracle Database 11g
11 12 (8.57%) SQL Server 2012
12 11 (7.86%) Oracle OLAP
13 9 (6.43%) RDBMS
13 9 (6.43%) Data Mart
13 9 (6.43%) Microsoft Analysis Services
14 6 (4.29%) Oracle ODI
15 5 (3.57%) DataStage
15 5 (3.57%) Oracle Reports
Development Applications
1 4 (2.86%) Toad
2 3 (2.14%) ClearCase
3 2 (1.43%) Selenium
3 2 (1.43%) SoapUI
3 2 (1.43%) Team Foundation Server
3 2 (1.43%) WebDriver
3 2 (1.43%) JMeter
3 2 (1.43%) QuickTest Pro
3 2 (1.43%) LoadUI
4 1 (0.71%) Visual Studio
4 1 (0.71%) Talend Open Studio
General
1 29 (20.71%) Finance
2 6 (4.29%) Banking
3 2 (1.43%) Retail
3 2 (1.43%) Investment Banking
3 2 (1.43%) Marketing
3 2 (1.43%) Games
4 1 (0.71%) Pharmaceutical
4 1 (0.71%) Financial Institution
4 1 (0.71%) Telecoms
4 1 (0.71%) Publishing
4 1 (0.71%) French Language
4 1 (0.71%) Retail Banking
Job Titles
1 96 (68.57%) Developer
2 24 (17.14%) SQL Developer
3 21 (15.00%) ETL Developer
4 20 (14.29%) Business Intelligence Developer
5 17 (12.14%) Analyst
6 13 (9.29%) Microstrategy Developer
7 11 (7.86%) Test Analyst
8 10 (7.14%) Business Developer
9 9 (6.43%) Architect
9 9 (6.43%) SQL Server Developer
10 6 (4.29%) Data Analyst
10 6 (4.29%) Coordinator
10 6 (4.29%) Oracle Developer
10 6 (4.29%) Business Analyst
10 6 (4.29%) Consultant
10 6 (4.29%) Senior Developer
11 5 (3.57%) Business Intelligence Analyst
12 4 (2.86%) Technical Leader
12 4 (2.86%) Tester
13 3 (2.14%) Solutions Architect
Libraries, Frameworks & Software Standards
1 27 (19.29%) XML
2 16 (11.43%) MDX
3 8 (5.71%) .NET
4 6 (4.29%) XHTML
4 6 (4.29%) HTML
4 6 (4.29%) CSS
5 5 (3.57%) Web Services
5 5 (3.57%) Ajax
6 3 (2.14%) SOAP
6 3 (2.14%) ASP.NET
7 2 (1.43%) JSON
8 1 (0.71%) Spring Batch
Miscellaneous
1 15 (10.71%) Analytical Skills
2 8 (5.71%) Computer Science
3 6 (4.29%) CMDB
3 6 (4.29%) Data Integration
3 6 (4.29%) Visualisation
4 3 (2.14%) NHS
4 3 (2.14%) Management Information System
4 3 (2.14%) Reference Data
4 3 (2.14%) Data Conversion
5 2 (1.43%) Freedom of Information
5 2 (1.43%) Data Protection Act
5 2 (1.43%) Freedom of Information Act
5 2 (1.43%) Online Games
5 2 (1.43%) Hedge funds
5 2 (1.43%) Data Extraction
5 2 (1.43%) AS400
5 2 (1.43%) Enterprise Software
6 1 (0.71%) User Experience
6 1 (0.71%) FMCG
6 1 (0.71%) Credit Risk
Operating Systems
1 16 (11.43%) UNIX
2 3 (2.14%) Solaris
2 3 (2.14%) Linux
3 1 (0.71%) Windows
Processes & Methodologies
1 88 (62.86%) ETL
2 84 (60.00%) Business Intelligence
3 54 (38.57%) Agile Software Development
4 40 (28.57%) Data Modelling
4 40 (28.57%) Kimball Methodology
5 23 (16.43%) Dimensional Modelling
6 21 (15.00%) Analytics
6 21 (15.00%) Inmon Methodology
7 18 (12.86%) Performance Tuning
8 11 (7.86%) Performance Improvement
8 11 (7.86%) Continuous Integration
8 11 (7.86%) Data Mapping
8 11 (7.86%) Migration
9 9 (6.43%) Data Migration
9 9 (6.43%) Data Management
10 7 (5.00%) Master Data Management
11 6 (4.29%) User Acceptance Testing
11 6 (4.29%) Unit Testing
12 5 (3.57%) Project Management
12 5 (3.57%) Regression Testing
Programming Languages
1 93 (66.43%) SQL
2 26 (18.57%) T-SQL
3 21 (15.00%) PL/SQL
4 19 (13.57%) C#
5 8 (5.71%) VBA
6 6 (4.29%) JavaScript
7 2 (1.43%) PowerShell
7 2 (1.43%) VB
7 2 (1.43%) Java
7 2 (1.43%) Data Mining Extensions (DMX)
8 1 (0.71%) Data Analysis Expressions (DAX)
8 1 (0.71%) Perl
Qualifications
1 13 (9.29%) Degree
2 7 (5.00%) ISEB
2 7 (5.00%) ISTQB
3 2 (1.43%) HNC
3 2 (1.43%) HND
3 2 (1.43%) ISTQB Foundation Certification
4 1 (0.71%) Microsoft Certification
4 1 (0.71%) MCDBA
4 1 (0.71%) SC Cleared
4 1 (0.71%) Security Cleared
4 1 (0.71%) MCITP
Quality Assurance & Compliance
1 4 (2.86%) QA
2 2 (1.43%) Data Quality
System Software
1 5 (3.57%) Active Directory
Systems Management
1 2 (1.43%) Oracle EDQ
2 1 (0.71%) Control-M
2 1 (0.71%) HP Quality Center
Vendors
1 48 (34.29%) Oracle
2 35 (25.00%) Microsoft
3 22 (15.71%) Business Objects
4 18 (12.86%) Informatica
5 14 (10.00%) Cognos
6 13 (9.29%) MicroStrategy
7 8 (5.71%) Tableau
8 6 (4.29%) Netezza
8 6 (4.29%) Teradata
9 5 (3.57%) Lattice Semiconductor
10 4 (2.86%) Ab Initio
11 3 (2.14%) JD Edwards
11 3 (2.14%) IBM
11 3 (2.14%) SAP
11 3 (2.14%) Greenplum
12 2 (1.43%) Hyperion
12 2 (1.43%) Salesforce.com
13 1 (0.71%) Perforce
13 1 (0.71%) Siebel
13 1 (0.71%) Red Gate
Cardiff, South Glamorgan
Rullion IT Plus
Posted: 21 hours ago
Reading, Berkshire
Coal IT Services
Rate: £380 per day
Posted: Yesterday
Berkshire
Roc Search
Posted: 2 days ago
Fareham, Hampshire
Connectus
Rate: £350 - £400 per day
Posted: 2 days ago
London
Mortimer Spinks
Rate: £300 per day
Posted: 2 days ago
Southampton, Hampshire
Connectus
Rate: £400 per day + flexible
Posted: 4 days ago
London
Mortimer Spinks
Rate: £300 per day
Posted: 4 days ago
City of London
Hays IT - Uk Posting account
Rate: £400.00 - £470.00 per day
Posted: 22 days ago