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 2 October 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
2 Oct 2014
Same period 2013 Same period 2012
Star Schema
Rank 547 490 514
Rank change year-on-year
-57 +24
Contract jobs citing Star Schema 76 84 71
As % of all contract IT jobs located in the UK 0.13% 0.16% 0.13%
As % of the Database & Business Intelligence category 0.64% 0.72% 0.60%
Number of daily rates quoted 56 55 28
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£375 £400 £450
Average daily rate % change year-on-year
-6.25% -11.11%
90% offered a daily rate of more than £293 £336 £275
10% offered a daily rate of more than £450 £525 £500
UK excluding London average daily rate £350 £394 £400
% change year-on-year
-11.11% -1.56%
Number of hourly rates quoted 0 0 3
Average hourly rate - - £42.50
UK excluding London average hourly rate - - £42.50

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
11864 11694 11830
As % of all contract IT jobs located in the UK 20.44% 22.49% 20.94%
Number of daily rates quoted 7585 7242 6801
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 £273 £255 £260
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £350 £340 £338
% change year-on-year
+2.94% +0.74%
Number of hourly rates quoted 176 198 336
Average hourly rate £32.00 £30.00 £30.00
Average hourly rate % change year-on-year
+6.66% -
90% offered a hourly rate of more than £13.02 £14.00 £15.25
10% offered a hourly rate of more than £67.00 £46.00 £45.00
UK excluding London average hourly rate £33.00 £32.03 £30.00
% change year-on-year
+3.03% +6.75%

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 2 October 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 2 October 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 -46 67 £378 -5.62% 22
London +2 44 £375 -6.25% 13
South East -8 9 £380 -39.92% 3
West Yorkshire - 7 £278 -
Yorkshire - 7 £278 -
City of London +13 6 £425 -10.52% 7
Berkshire +9 6 £380 -39.92% 2
South Wales - 5 £325 -
Leeds - 5 £284 -
Wales - 5 £325 -
Cardiff - 4 £325 -
Reading +17 3 £380 -41.42%
Bournemouth +5 3 £425 - 3
Dorset +1 3 £425 - 3
South West -35 3 £425 +9.67% 3
Hampshire - 3 £400 -
Scotland -5 2 £230 -31.85% 1
East Midlands -1 1 £350 -6.66% 1
Glasgow -14 1 - - 1
Edinburgh - 1 £230 -
Manchester - 1 £325 -
Hertfordshire - 1 - - 1
East of England - 1 - - 1
North West - 1 £325 -
West Midlands - - - - 1
Nottinghamshire - - - -
Somerset - - - -
Surrey - - - -
Warwickshire - - - - 1
West Sussex - - - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 2 October 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 96 (65.31%) SQL
1 96 (65.31%) ETL
2 88 (59.86%) Business Intelligence
3 78 (53.06%) Data Warehouse
4 77 (52.38%) SQL Server
5 74 (50.34%) SQL Server Integration Services
6 57 (38.78%) SQL Server Reporting Services
7 56 (38.10%) Agile Software Development
8 46 (31.29%) Oracle
9 45 (30.61%) Data Modelling
10 44 (29.93%) Kimball Methodology
11 38 (25.85%) SQL Server 2008
12 36 (24.49%) SQL Server Analysis Services
13 34 (23.13%) Microsoft
14 28 (19.05%) T-SQL
15 27 (18.37%) XML
16 26 (17.69%) MS Excel
16 26 (17.69%) Finance
17 25 (17.01%) Dimensional Modelling
18 24 (16.33%) OLAP
19 23 (15.65%) Analytics
20 21 (14.29%) Inmon Methodology
20 21 (14.29%) Business Objects
21 20 (13.61%) Informatica
22 19 (12.93%) C#
22 19 (12.93%) PL/SQL
22 19 (12.93%) Relational Database
23 18 (12.24%) Cognos
23 18 (12.24%) SQL Server 2005
24 17 (11.56%) Performance Tuning

Star Schema
Top Related IT Skills by Category

For the 6 months to 2 October 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.48%) SharePoint
2 3 (2.04%) SAS
2 3 (2.04%) SharePoint 2010
Applications
1 26 (17.69%) MS Excel
2 7 (4.76%) PowerPivot
3 4 (2.72%) Spreadsheet
Business Applications
1 7 (4.76%) Cognos Business Intelligence
2 2 (1.36%) Dynamics CRM
3 1 (0.68%) Oracle Payables
3 1 (0.68%) Oracle Financials
3 1 (0.68%) Oracle Applications
3 1 (0.68%) Dynamics NAV
3 1 (0.68%) Demantra
3 1 (0.68%) JDE World
Cloud Services
1 1 (0.68%) Office 365
Communications & Networking
1 5 (3.40%) FTP
1 5 (3.40%) SAN
2 2 (1.36%) PuTTY
Database & Business Intelligence
1 78 (53.06%) Data Warehouse
2 77 (52.38%) SQL Server
3 74 (50.34%) SQL Server Integration Services
4 57 (38.78%) SQL Server Reporting Services
5 38 (25.85%) SQL Server 2008
6 36 (24.49%) SQL Server Analysis Services
7 24 (16.33%) OLAP
8 19 (12.93%) Relational Database
9 18 (12.24%) SQL Server 2005
10 15 (10.20%) Oracle Database
10 15 (10.20%) Big Data
11 13 (8.84%) Oracle Database 11g
11 13 (8.84%) Data Mart
12 11 (7.48%) SQL Server 2012
13 10 (6.80%) Oracle OLAP
14 9 (6.12%) RDBMS
14 9 (6.12%) Microsoft Analysis Services
15 8 (5.44%) Cognos Framework Manager
16 7 (4.76%) Cognos Transformer
16 7 (4.76%) Oracle ODI
Development Applications
1 4 (2.72%) Toad
2 2 (1.36%) SoapUI
2 2 (1.36%) WebDriver
2 2 (1.36%) Team Foundation Server
2 2 (1.36%) Selenium
2 2 (1.36%) JMeter
2 2 (1.36%) QuickTest Pro
2 2 (1.36%) LoadUI
3 1 (0.68%) Visual Studio
3 1 (0.68%) Talend Open Studio
General
1 26 (17.69%) Finance
2 5 (3.40%) Banking
3 3 (2.04%) Retail
4 2 (1.36%) Marketing
4 2 (1.36%) Games
5 1 (0.68%) Pharmaceutical
5 1 (0.68%) Publishing
5 1 (0.68%) Telecoms
5 1 (0.68%) Retail Banking
5 1 (0.68%) Investment Banking
5 1 (0.68%) French Language
Job Titles
1 100 (68.03%) Developer
2 23 (15.65%) SQL Developer
3 22 (14.97%) Business Intelligence Developer
4 21 (14.29%) ETL Developer
5 18 (12.24%) Analyst
6 13 (8.84%) Microstrategy Developer
7 12 (8.16%) Test Analyst
8 11 (7.48%) Business Developer
9 10 (6.80%) Architect
10 9 (6.12%) SQL Server Developer
11 7 (4.76%) Data Analyst
12 6 (4.08%) Business Analyst
12 6 (4.08%) Consultant
12 6 (4.08%) Coordinator
12 6 (4.08%) Senior Developer
13 5 (3.40%) Business Intelligence Analyst
14 4 (2.72%) Technical Leader
14 4 (2.72%) Tester
15 3 (2.04%) Solutions Architect
15 3 (2.04%) Informatica Developer
Libraries, Frameworks & Software Standards
1 27 (18.37%) XML
2 15 (10.20%) MDX
3 8 (5.44%) .NET
4 6 (4.08%) HTML
4 6 (4.08%) CSS
4 6 (4.08%) XHTML
5 5 (3.40%) Web Services
5 5 (3.40%) Ajax
6 3 (2.04%) SOAP
6 3 (2.04%) ASP.NET
7 2 (1.36%) JSON
8 1 (0.68%) Spring Batch
Miscellaneous
1 14 (9.52%) Analytical Skills
2 8 (5.44%) Computer Science
3 6 (4.08%) Data Integration
3 6 (4.08%) Visualisation
3 6 (4.08%) CMDB
4 4 (2.72%) Data Structures
5 3 (2.04%) NHS
5 3 (2.04%) Management Information System
5 3 (2.04%) Reference Data
5 3 (2.04%) Data Conversion
6 2 (1.36%) Hedge funds
6 2 (1.36%) Enterprise Software
6 2 (1.36%) Data Extraction
6 2 (1.36%) Online Games
6 2 (1.36%) Data Protection Act
6 2 (1.36%) Freedom of Information Act
6 2 (1.36%) Freedom of Information
6 2 (1.36%) AS400
7 1 (0.68%) User Experience
7 1 (0.68%) Credit Risk
Operating Systems
1 14 (9.52%) UNIX
2 1 (0.68%) Windows
Processes & Methodologies
1 96 (65.31%) ETL
2 88 (59.86%) Business Intelligence
3 56 (38.10%) Agile Software Development
4 45 (30.61%) Data Modelling
5 44 (29.93%) Kimball Methodology
6 25 (17.01%) Dimensional Modelling
7 23 (15.65%) Analytics
8 21 (14.29%) Inmon Methodology
9 17 (11.56%) Performance Tuning
10 12 (8.16%) Data Mapping
10 12 (8.16%) Migration
11 11 (7.48%) Performance Improvement
11 11 (7.48%) Continuous Integration
12 10 (6.80%) Data Migration
13 9 (6.12%) Data Management
14 7 (4.76%) Master Data Management
15 6 (4.08%) User Acceptance Testing
15 6 (4.08%) Unit Testing
15 6 (4.08%) Data Analysis
16 5 (3.40%) RAD
Programming Languages
1 96 (65.31%) SQL
2 28 (19.05%) T-SQL
3 19 (12.93%) C#
3 19 (12.93%) PL/SQL
4 8 (5.44%) VBA
5 6 (4.08%) JavaScript
6 4 (2.72%) VB
7 2 (1.36%) PowerShell
7 2 (1.36%) Java
7 2 (1.36%) Data Mining Extensions (DMX)
8 1 (0.68%) Data Analysis Expressions (DAX)
Qualifications
1 13 (8.84%) Degree
2 8 (5.44%) ISTQB
2 8 (5.44%) ISEB
3 2 (1.36%) HNC
3 2 (1.36%) HND
3 2 (1.36%) ISTQB Foundation Certification
4 1 (0.68%) Microsoft Certification
4 1 (0.68%) MCDBA
4 1 (0.68%) MCITP
4 1 (0.68%) SC Cleared
4 1 (0.68%) Security Cleared
Quality Assurance & Compliance
1 4 (2.72%) QA
2 2 (1.36%) Data Quality
System Software
1 5 (3.40%) Active Directory
Systems Management
1 2 (1.36%) Oracle EDQ
2 1 (0.68%) HP Quality Center
Vendors
1 46 (31.29%) Oracle
2 34 (23.13%) Microsoft
3 21 (14.29%) Business Objects
4 20 (13.61%) Informatica
5 18 (12.24%) Cognos
6 13 (8.84%) MicroStrategy
7 10 (6.80%) Tableau
8 6 (4.08%) Netezza
8 6 (4.08%) Teradata
9 5 (3.40%) Ab Initio
9 5 (3.40%) Lattice Semiconductor
10 3 (2.04%) JD Edwards
10 3 (2.04%) SAP
10 3 (2.04%) Greenplum
11 2 (1.36%) Salesforce.com
11 2 (1.36%) Hyperion
11 2 (1.36%) IBM
12 1 (0.68%) Siebel
12 1 (0.68%) Talend
12 1 (0.68%) Red Gate
London
HAYS INFORMATION TECHNOLOGY
Rate: £430.00 - £478.00 per annum
Posted: Yesterday
London
HAYS INFORMATION TECHNOLOGY
Rate: £400.00 - £454.00 per annum
Posted: Yesterday
Bracknell, Berkshire
Roc Search
Rate: £450 - £451 per day
Posted: Yesterday
Berkshire
Roc Search
Posted: 2 days ago