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 6 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
6 Jul 2015
Same period 2014 Same period 2013
Star Schema
Rank 564 524 504
Rank change year-on-year
-40 -20
Contract jobs citing Star Schema 45 67 51
As % of all contract IT jobs located in the UK 0.082% 0.13% 0.10%
As % of the Database & Business Intelligence category 0.36% 0.60% 0.49%
Number of daily rates quoted 31 46 38
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£413 £410 £415
Average daily rate % change year-on-year
+0.60% -1.20%
90% offered a daily rate of more than £375 £263 £309
10% offered a daily rate of more than £463 £488 £497
UK excluding London average daily rate £294 £305 £350
% change year-on-year
-3.68% -12.85%
Number of hourly rates quoted 1 0 0
Average hourly rate £57.75 - -
UK excluding London average hourly rate £57.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
12350 11175 10514
As % of all contract IT jobs located in the UK 22.51% 21.12% 21.35%
Number of daily rates quoted 8092 6953 6312
Average daily rate £400 £400 £388
Average daily rate % change year-on-year
- +3.22%
90% offered a daily rate of more than £280 £270 £250
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £350 £350 £338
% change year-on-year
- +3.70%
Number of hourly rates quoted 166 168 224
Average hourly rate £27.78 £27.50 £27.50
Average hourly rate % change year-on-year
+1.01% -
90% offered a hourly rate of more than £16.80 £13.50 £17.50
10% offered a hourly rate of more than £55.00 £52.50 £51.00
UK excluding London average hourly rate £29.35 £28.50 £30.00
% change year-on-year
+2.96% -5.00%

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 6 July 2015.

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 15 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 6 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 -24 45 £413 -1.78% 10
London +9 36 £413 -2.94% 6
City of London -1 10 £413 +6.45% 4
South East -11 5 £200 -52.94% 1
Berkshire +4 3 - - 1
Feltham - 3 £398 -
South West -8 2 £388 -20.51% 1
North West -15 2 £433 +28.14%
Surrey - 2 £200 -
Cumbria - 2 £433 -
Uxbridge - 2 £388 - 1
Reading +3 1 - -
Gloucestershire -7 1 £388 -22.50% 1
Dorset - 1 - -
Barrow-in-Furness - 1 - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 6 July 2015, 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 92 (73.02%) ETL
2 89 (70.63%) Data Warehouse
3 75 (59.52%) SQL
4 61 (48.41%) SQL Server
4 61 (48.41%) Business Intelligence
5 58 (46.03%) SQL Server Integration Services
6 53 (42.06%) Data Modelling
7 46 (36.51%) Agile Software Development
8 43 (34.13%) Finance
9 34 (26.98%) Performance Tuning
10 33 (26.19%) SQL Server Reporting Services
11 29 (23.02%) Microsoft
12 27 (21.43%) T-SQL
12 27 (21.43%) Greenplum
12 27 (21.43%) SQL Server Analysis Services
12 27 (21.43%) Kimball Methodology
12 27 (21.43%) Analytical Skills
13 24 (19.05%) Oracle
14 22 (17.46%) ETL Development
15 21 (16.67%) XML
15 21 (16.67%) Security Cleared
15 21 (16.67%) Unit Testing
15 21 (16.67%) Requirements Analysis
16 20 (15.87%) UNIX
16 20 (15.87%) MS Excel
17 19 (15.08%) Informatica
17 19 (15.08%) SC Cleared
18 17 (13.49%) SQL Server 2008
18 17 (13.49%) Data Analysis
18 17 (13.49%) Python

Star Schema
Top Related IT Skills by Category

For the 6 months to 6 July 2015, 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 4 (3.17%) SharePoint
2 3 (2.38%) SAS
3 1 (0.79%) BizTalk Server
3 1 (0.79%) CMS
3 1 (0.79%) Sitecore CMS
3 1 (0.79%) Apache Pig
Applications
1 20 (15.87%) MS Excel
2 8 (6.35%) PowerPivot
3 7 (5.56%) MS Visio
4 1 (0.79%) SPSS
4 1 (0.79%) MS PowerPoint
4 1 (0.79%) MS Project
4 1 (0.79%) MS Office
Business Applications
1 4 (3.17%) Oracle Financials
1 4 (3.17%) Oracle Payables
2 2 (1.59%) Dynamics NAV
2 2 (1.59%) Dynamics CRM
Communications & Networking
1 1 (0.79%) Intranet
Database & Business Intelligence
1 89 (70.63%) Data Warehouse
2 61 (48.41%) SQL Server
3 58 (46.03%) SQL Server Integration Services
4 33 (26.19%) SQL Server Reporting Services
5 27 (21.43%) SQL Server Analysis Services
6 17 (13.49%) SQL Server 2008
7 15 (11.90%) QlikView
7 15 (11.90%) OLAP
8 14 (11.11%) SQL Server 2012
9 12 (9.52%) Oracle Database
9 12 (9.52%) Big Data
9 12 (9.52%) Snowflake Schema
10 11 (8.73%) BusinessObjects XI
11 10 (7.94%) DB2
11 10 (7.94%) Relational Database
12 9 (7.14%) Data Mart
13 7 (5.56%) KDB
13 7 (5.56%) DataStage
13 7 (5.56%) Microsoft Power View
14 6 (4.76%) Oracle ODI
Development Applications
1 7 (5.56%) ERwin
2 6 (4.76%) Talend Open Studio
2 6 (4.76%) Team Foundation Server
3 4 (3.17%) JIRA
3 4 (3.17%) SQL Server Management Studio (SSMS)
4 3 (2.38%) TestDirector
4 3 (2.38%) Visual Studio
5 1 (0.79%) Toad
5 1 (0.79%) ProC
5 1 (0.79%) PyUnit
General
1 43 (34.13%) Finance
2 15 (11.90%) Banking
3 8 (6.35%) Retail
4 7 (5.56%) Investment Banking
5 4 (3.17%) Marketing
6 3 (2.38%) Telecoms
7 2 (1.59%) Financial Institution
7 2 (1.59%) Advertising
8 1 (0.79%) Legal
8 1 (0.79%) French Language
Job Titles
1 82 (65.08%) Developer
2 34 (26.98%) ETL Developer
3 25 (19.84%) Analyst
4 16 (12.70%) SQL Developer
5 15 (11.90%) Business Intelligence Developer
6 14 (11.11%) Architect
7 11 (8.73%) Data Architect
8 10 (7.94%) Data Warehouse Developer
8 10 (7.94%) Designer
9 9 (7.14%) Business Analyst
10 8 (6.35%) Consultant
11 7 (5.56%) Systems Analyst
12 6 (4.76%) Database Developer
13 5 (3.97%) Microsoft Developer
13 5 (3.97%) Analyst Developer
14 4 (3.17%) Technical Analyst
14 4 (3.17%) Lead Developer
14 4 (3.17%) Data Warehouse Consultant
14 4 (3.17%) Business Developer
14 4 (3.17%) ETL Designer
Libraries, Frameworks & Software Standards
1 21 (16.67%) XML
2 10 (7.94%) .NET
3 9 (7.14%) MDX
4 3 (2.38%) Web Services
5 1 (0.79%) ASP.NET
5 1 (0.79%) JDBC
5 1 (0.79%) WCF
5 1 (0.79%) WF
5 1 (0.79%) ASP.NET MVC
5 1 (0.79%) ASP.NET MVC 2
5 1 (0.79%) Entity Framework
5 1 (0.79%) Middleware
5 1 (0.79%) DAO
5 1 (0.79%) NHibernate
5 1 (0.79%) .NET Framework
Miscellaneous
1 27 (21.43%) Analytical Skills
2 11 (8.73%) Visualisation
2 11 (8.73%) Computer Science
3 8 (6.35%) Data Structures
4 5 (3.97%) Fixed Income
4 5 (3.97%) Equities
4 5 (3.97%) Derivative
4 5 (3.97%) Equity Derivative
5 4 (3.17%) Reference Data
5 4 (3.17%) Data Integration
5 4 (3.17%) Management Information System
6 1 (0.79%) Economics
6 1 (0.79%) Algorithms
6 1 (0.79%) FMCG
6 1 (0.79%) Statistics
6 1 (0.79%) Mathematics
6 1 (0.79%) Applied Mathematics
Operating Systems
1 20 (15.87%) UNIX
2 17 (13.49%) Linux
3 6 (4.76%) Windows
4 1 (0.79%) MVS
4 1 (0.79%) Oracle Linux
Processes & Methodologies
1 92 (73.02%) ETL
2 61 (48.41%) Business Intelligence
3 53 (42.06%) Data Modelling
4 46 (36.51%) Agile Software Development
5 34 (26.98%) Performance Tuning
6 27 (21.43%) Kimball Methodology
7 22 (17.46%) ETL Development
8 21 (16.67%) Requirements Analysis
8 21 (16.67%) Unit Testing
9 17 (13.49%) Data Analysis
10 16 (12.70%) Data Mapping
11 14 (11.11%) Analytics
12 13 (10.32%) Data Management
13 12 (9.52%) Inmon Methodology
13 12 (9.52%) Dimensional Modelling
14 11 (8.73%) Technical Analysis
15 10 (7.94%) Project Management
16 9 (7.14%) Stakeholder Management
17 8 (6.35%) GAP Analysis
17 8 (6.35%) Logical Data Model
Programming Languages
1 75 (59.52%) SQL
2 27 (21.43%) T-SQL
3 17 (13.49%) Python
3 17 (13.49%) PL/SQL
4 9 (7.14%) Shell Script
5 8 (6.35%) Perl
6 5 (3.97%) Java
7 4 (3.17%) Data Analysis Expressions (DAX)
8 2 (1.59%) C#
9 1 (0.79%) C
9 1 (0.79%) Bash Shell
9 1 (0.79%) ANSI SQL
Qualifications
1 21 (16.67%) Security Cleared
2 19 (15.08%) SC Cleared
3 14 (11.11%) Degree
4 5 (3.97%) DV Cleared
5 3 (2.38%) ISTQB
5 3 (2.38%) ISEB
5 3 (2.38%) ISTQB Foundation Certification
6 1 (0.79%) Microsoft Certification
6 1 (0.79%) MCP
6 1 (0.79%) PhD
Quality Assurance & Compliance
1 9 (7.14%) Data Quality
2 6 (4.76%) QA
3 2 (1.59%) Solvency II
System Software
1 1 (0.79%) Apache ZooKeeper
1 1 (0.79%) HDFS
Systems Management
1 2 (1.59%) Oracle EDQ
2 1 (0.79%) HP Quality Center
Vendors
1 29 (23.02%) Microsoft
2 27 (21.43%) Greenplum
3 24 (19.05%) Oracle
4 19 (15.08%) Informatica
5 15 (11.90%) Tableau
6 11 (8.73%) Netezza
7 10 (7.94%) Teradata
7 10 (7.94%) Cognos
8 8 (6.35%) IBM
9 7 (5.56%) Business Objects
10 6 (4.76%) Vertica
10 6 (4.76%) Talend
11 4 (3.17%) SAP
11 4 (3.17%) Sybase
12 2 (1.59%) Sun
12 2 (1.59%) Nintex
12 2 (1.59%) Salesforce.com
13 1 (0.79%) Ab Initio
13 1 (0.79%) Google
13 1 (0.79%) Sitecore
Newbury, Berkshire
LA International
Posted: 2 days ago
South West London
HAYS INFORMATION TECHNOLOGY
Rate: £400.00 - £454.00 per annum
Posted: 4 days ago
City, London
HAYS INFORMATION TECHNOLOGY
Rate: £350.00 - £400.00 per day
Posted: 5 days ago
City of London
Lawrence Harvey
Rate: £1.00 - £2.00 per hour + Negotiable
Posted: 11 days ago
Gloucestershire
Austin Fraser Limited
Rate: £375 - £400 per day
Posted: 25 days ago