Period
to 24 June 2019

The following table provides summary statistics for contract job vacancies advertised in England with a requirement for Star Schema skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Star Schema over the 6 months to 24 June 2019 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Star Schema
UK > England
6 months to
24 Jun 2019
Same period 2018 Same period 2017
Rank 664 699 736
Rank change year-on-year +35 +37 0
Contract jobs citing Star Schema 141 152 72
As % of all contract IT jobs advertised in England 0.17% 0.17% 0.085%
As % of the Database & Business Intelligence category 0.76% 0.73% 0.38%
Number of daily rates quoted 107 126 33
England median daily rate £485 £513 £464
Median daily rate % change year-on-year -5.37% +10.45% +0.05%
10th Percentile £363 £413 £353
90th Percentile £575 £575 £572
UK median daily rate £483 £513 £450
% change year-on-year -5.85% +13.89% -
Number of hourly rates quoted 0 0 0
England median hourly rate - - -
UK median hourly rate - - -

Star Schema is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Contract vacancies with a requirement for database or business intelligence skills 18,579 20,767 19,113
As % of all contract IT jobs advertised in England 22.38% 22.69% 22.64%
Number of daily rates quoted 12,881 14,579 12,813
England median daily rate £480 £475 £450
Median daily rate % change year-on-year +1.05% +5.56% +5.88%
10th Percentile £325 £313 £300
90th Percentile £650 £638 £620
UK median daily rate £475 £463 £441
% change year-on-year +2.70% +4.93% +3.71%
Number of hourly rates quoted 225 217 239
England median hourly rate £35.00 £34.00 £30.00
Median hourly rate % change year-on-year +2.94% +13.33% +2.56%
10th Percentile £14.26 £14.00 £9.25
90th Percentile £57.50 £54.25 £50.00
UK median hourly rate £35.00 £33.75 £30.00
% change year-on-year +3.70% +12.50% +5.26%

Star Schema
Job Vacancy Trend in England

Job postings citing Star Schema as a percentage of all IT jobs advertised in England.

Job vacancy trend for Star Schema in England

Star Schema
Contractor Daily Rate Trend in England

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

Contractor daily rate trend for Star Schema in England

Star Schema
Contractor Daily Rate Histogram in England

The daily rate distribution of IT jobs citing Star Schema in England over the 6 months to 24 June 2019.

Contractor daily rate histogram for Star Schema in England

Star Schema
Contractor Hourly Rate Trend in England

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

Contractor hourly rate trend for Star Schema in England

Star Schema
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Star Schema within the England region over the 6 months to 24 June 2019. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London +42 109 £550 +4.76% 2
North of England +20 16 £350 -9.09% 1
North West +23 14 £375 -2.60%
South East +33 9 £425 -8.11% 2
East of England +4 4 - -
Midlands +20 3 - -
West Midlands +8 3 - -
Yorkshire +13 2 £310 -27.06% 1
Star Schema
UK

For the 6 months to 24 June 2019, IT contractor jobs citing Star Schema also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the England region with a requirement for Star Schema.

1 118 (83.69%) SQL
2 114 (80.85%) Data Warehouse
3 83 (58.87%) Analytics
4 77 (54.61%) Finance
5 74 (52.48%) Big Data
6 73 (51.77%) Data Modelling
7 66 (46.81%) SQL Server
8 64 (45.39%) Business Intelligence
9 61 (43.26%) ETL
9 61 (43.26%) SQL Server Integration Services
10 52 (36.88%) Microsoft
11 51 (36.17%) Data Quality
12 49 (34.75%) Agile Software Development
13 46 (32.62%) Microsoft Azure
14 44 (31.21%) Machine Learning
14 44 (31.21%) OLAP
15 43 (30.50%) Hadoop
15 43 (30.50%) OLAP Cube
15 43 (30.50%) Apache Spark
16 42 (29.79%) Kafka
16 42 (29.79%) Data Science
17 41 (29.08%) Oozie
17 41 (29.08%) Enterprise Data Warehouse
17 41 (29.08%) SQL Optimisation
17 41 (29.08%) Apache Hive
18 38 (26.95%) Kimball Methodology
19 33 (23.40%) .NET
20 32 (22.70%) C#
21 30 (21.28%) Performance Tuning
21 30 (21.28%) Power BI

Star Schema
Co-occurring IT Skills in England 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 43 (30.50%) Apache Spark
2 13 (9.22%) SharePoint
2 13 (9.22%) SharePoint 2010
3 2 (1.42%) CMS
3 2 (1.42%) Elasticsearch
3 2 (1.42%) Oracle Workflow
3 2 (1.42%) SAS
Applications
1 15 (10.64%) Microsoft Excel
2 1 (0.71%) MS Visio
Cloud Services
1 46 (32.62%) Microsoft Azure
2 30 (21.28%) Power Platform
3 7 (4.96%) Amazon AWS
4 4 (2.84%) Azure Data Factory
5 2 (1.42%) Azure Machine Learning
6 1 (0.71%) Amazon S3
6 1 (0.71%) Amazon SQS
6 1 (0.71%) Cloud Computing
6 1 (0.71%) PaaS
Database & Business Intelligence
1 114 (80.85%) Data Warehouse
2 74 (52.48%) Big Data
3 66 (46.81%) SQL Server
4 61 (43.26%) SQL Server Integration Services
5 44 (31.21%) OLAP
6 43 (30.50%) Hadoop
6 43 (30.50%) OLAP Cube
7 41 (29.08%) Apache Hive
7 41 (29.08%) Enterprise Data Warehouse
8 30 (21.28%) Power BI
9 21 (14.89%) SQL Server Analysis Services
10 20 (14.18%) SQL Server 2008
11 16 (11.35%) Oracle Database
11 16 (11.35%) SQL Server 2012
11 16 (11.35%) SQL Server Reporting Services
12 15 (10.64%) Oracle BI EE
13 13 (9.22%) PerformancePoint
14 8 (5.67%) Oracle Database 11g
14 8 (5.67%) Oracle ODI
14 8 (5.67%) Relational Database
Development Applications
1 5 (3.55%) ERwin
2 3 (2.13%) JIRA
2 3 (2.13%) Visual Studio
3 1 (0.71%) Git (software)
3 1 (0.71%) Jenkins
3 1 (0.71%) JIRA Agile
3 1 (0.71%) Sonatype Nexus
3 1 (0.71%) Team Foundation Server
General
1 77 (54.61%) Finance
2 17 (12.06%) Banking
3 4 (2.84%) Financial Institution
4 2 (1.42%) Legal
4 2 (1.42%) Pharmaceutical
4 2 (1.42%) Retail
5 1 (0.71%) Manufacturing
5 1 (0.71%) Marketing
Job Titles
1 75 (53.19%) Developer
2 44 (31.21%) Data Engineer
3 41 (29.08%) Hadoop Engineer
4 20 (14.18%) SQL Developer
5 15 (10.64%) .NET Developer
5 15 (10.64%) Business Intelligence Developer
6 13 (9.22%) C# Developer
7 12 (8.51%) C# .NET Developer
8 11 (7.80%) Analytics Developer
9 9 (6.38%) Senior Developer
10 8 (5.67%) Power BI Developer
11 7 (4.96%) Data Modeller
12 6 (4.26%) Analyst
12 6 (4.26%) WinForms Developer
13 5 (3.55%) C# WCF Developer
13 5 (3.55%) Oracle Developer
13 5 (3.55%) WCF Developer
14 4 (2.84%) C# VB.NET Developer
14 4 (2.84%) SSIS Developer
14 4 (2.84%) Systems Developer
Libraries, Frameworks & Software Standards
1 42 (29.79%) Kafka
2 33 (23.40%) .NET
3 17 (12.06%) MDX
4 16 (11.35%) Middleware
5 14 (9.93%) .NET Framework
5 14 (9.93%) WinForms
6 13 (9.22%) ASP.NET
7 12 (8.51%) ASP.NET Web API
8 10 (7.09%) WCF
9 4 (2.84%) XML
10 3 (2.13%) RESTful
11 2 (1.42%) .NET Core
11 2 (1.42%) AngularJS
11 2 (1.42%) CSS
11 2 (1.42%) HTML
11 2 (1.42%) SOAP
12 1 (0.71%) Velocity
Miscellaneous
1 28 (19.86%) Analytical Skills
2 26 (18.44%) Self-Motivation
3 5 (3.55%) Data Structures
3 5 (3.55%) User Experience
3 5 (3.55%) Virtual Team
4 2 (1.42%) Greenfield Project
4 2 (1.42%) Linux Command Line
4 2 (1.42%) Management Information System
5 1 (0.71%) Algorithms
5 1 (0.71%) Data Protection Act
5 1 (0.71%) DataPower
5 1 (0.71%) Equities
5 1 (0.71%) Freedom of Information
5 1 (0.71%) Freedom of Information Act
5 1 (0.71%) Smart Meter
5 1 (0.71%) Video\Live Streaming
Operating Systems
1 2 (1.42%) Linux
1 2 (1.42%) Unix
Processes & Methodologies
1 83 (58.87%) Analytics
2 73 (51.77%) Data Modelling
3 64 (45.39%) Business Intelligence
4 61 (43.26%) ETL
5 49 (34.75%) Agile Software Development
6 44 (31.21%) Machine Learning
7 42 (29.79%) Data Science
8 41 (29.08%) SQL Optimisation
9 38 (26.95%) Kimball Methodology
10 30 (21.28%) Performance Tuning
11 28 (19.86%) Inmon Methodology
12 24 (17.02%) Scrum
13 23 (16.31%) Migration
14 17 (12.06%) Dimensional Modelling
15 16 (11.35%) SOLID
15 16 (11.35%) Unit Testing
16 15 (10.64%) Data Migration
17 14 (9.93%) SDLC
18 13 (9.22%) Data Analysis
18 13 (9.22%) People Management
Programming Languages
1 118 (83.69%) SQL
2 32 (22.70%) C#
3 23 (16.31%) T-SQL
4 21 (14.89%) PL/SQL
5 14 (9.93%) VB.NET
6 13 (9.22%) VBA
7 8 (5.67%) Data Analysis Expressions (DAX)
8 4 (2.84%) VB
9 3 (2.13%) Python
10 2 (1.42%) R
10 2 (1.42%) SAS Macro
10 2 (1.42%) Shell Script
10 2 (1.42%) Tcl
11 1 (0.71%) PowerShell
11 1 (0.71%) U-SQL
Qualifications
1 6 (4.26%) Degree
2 1 (0.71%) PhD
2 1 (0.71%) SC Cleared
2 1 (0.71%) Security Cleared
Quality Assurance & Compliance
1 51 (36.17%) Data Quality
2 5 (3.55%) IFRS
2 5 (3.55%) QA
3 2 (1.42%) GDPR
System Software
1 6 (4.26%) Oracle RAC
Systems Management
1 41 (29.08%) Oozie
2 2 (1.42%) Control-M
Vendors
1 52 (36.88%) Microsoft
2 24 (17.02%) Oracle
3 13 (9.22%) Tableau
4 7 (4.96%) Cognos
5 6 (4.26%) MicroStrategy
6 5 (3.55%) SAP
7 4 (2.84%) Cadence
7 4 (2.84%) Informatica
8 3 (2.13%) IBM
9 2 (1.42%) Atlassian
9 2 (1.42%) BMC
9 2 (1.42%) Talend
10 1 (0.71%) Databricks
10 1 (0.71%) Salesforce.com
10 1 (0.71%) Teradata