Star Schema Contracts

Star Schema
UK

The following table provides summary statistics for contract job vacancies 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 26 April 2024 with a comparison to the same period in the previous 2 years.

6 months to
26 Apr 2024
Same period 2023 Same period 2022
Rank 539 626 800
Rank change year-on-year +87 +174 -206
Contract jobs citing Star Schema 40 74 60
As % of all contract jobs advertised in the UK 0.092% 0.12% 0.068%
As % of the Database & Business Intelligence category 0.55% 0.68% 0.33%
Number of daily rates quoted 29 55 55
10th Percentile £413 £388 £358
25th Percentile £425 £425 £419
Median daily rate (50th Percentile) £575 £520 £475
Median % change year-on-year +10.58% +9.47% +0.26%
75th Percentile £688 £588 £525
90th Percentile £775 £661 £610
UK excluding London median daily rate £450 £525 £475
% change year-on-year -14.29% +10.53% +8.57%

All Database and Business Intelligence Skills
UK

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 with a requirement for database or business intelligence skills.

Contract vacancies with a requirement for database or business intelligence skills 7,306 10,806 17,919
As % of all contract IT jobs advertised in the UK 16.77% 18.02% 20.20%
Number of daily rates quoted 5,191 7,697 12,774
10th Percentile £350 £375 £375
25th Percentile £425 £450 £450
Median daily rate (50th Percentile) £525 £540 £542
Median % change year-on-year -2.78% -0.41% +8.45%
75th Percentile £650 £660 £650
90th Percentile £763 £750 £750
UK excluding London median daily rate £483 £500 £488
% change year-on-year -3.50% +2.56% +10.80%
Number of hourly rates quoted 146 184 186
10th Percentile £14.00 £21.24 £15.00
25th Percentile £20.98 £35.00 £22.40
Median hourly rate £40.00 £60.00 £42.50
Median % change year-on-year -33.33% +41.18% +57.64%
75th Percentile £57.61 £71.75 £60.00
90th Percentile £72.50 £79.19 £69.05
UK excluding London median hourly rate £40.00 £57.50 £35.00
% change year-on-year -30.43% +64.29% +45.83%

Star Schema
Job Vacancy Trend

Job postings citing Star Schema as a proportion of all IT jobs advertised.

Job vacancy trend for Star Schema in the UK

Star Schema
Contractor Daily Rate Trend

3-month moving average daily rate quoted in jobs citing Star Schema.

Daily rate trend for Star Schema in the UK

Star Schema
Daily Rate Histogram

Daily rate distribution for jobs citing Star Schema over the 6 months to 26 April 2024.

Daily rate histogram for Star Schema in the UK

Star Schema
Contractor Hourly Rate Trend

3-month moving average hourly rates quoted in jobs citing Star Schema.

Hourly rate trend for Star Schema in the UK

Star Schema
Top 10 Contract Locations

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 UK over the 6 months to 26 April 2024. 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
Jobs
England +73 32 £535 +4.90% 6
London +84 22 £575 +15.00% 3
UK excluding London +61 13 £450 -14.29% 3
Work from Home +99 12 £650 +30.00% 2
Scotland +38 6 £563 -2.17%
South West +21 5 £450 -20.00% 2
North of England +29 3 - - 1
North West +22 3 - - 1
Midlands - 1 - - 1
West Midlands - 1 - - 1

Star Schema
Co-occurring Skills and Capabilities by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 1 (2.50%) Apache
1 1 (2.50%) Apache Spark
Business Applications
1 3 (7.50%) Oracle EBS
Cloud Services
1 17 (42.50%) Azure
2 11 (27.50%) Power Platform
3 6 (15.00%) Azure Data Factory
4 3 (7.50%) AWS
4 3 (7.50%) Azure Synapse Analytics
5 2 (5.00%) Serverless
6 1 (2.50%) Azure Cosmos DB
6 1 (2.50%) Azure Machine Learning
6 1 (2.50%) dbt
6 1 (2.50%) GitHub
6 1 (2.50%) Microsoft Purview
6 1 (2.50%) Snowflake
Database & Business Intelligence
1 28 (70.00%) Data Warehouse
2 11 (27.50%) Power BI
3 8 (20.00%) Relational Database
4 7 (17.50%) Data Lake
4 7 (17.50%) Snowflake Schema
5 6 (15.00%) Big Data
5 6 (15.00%) SQL Server
6 5 (12.50%) Data Mart
6 5 (12.50%) Delta Lake
6 5 (12.50%) Oracle Database
6 5 (12.50%) RDBMS
7 4 (10.00%) Data Vault
8 3 (7.50%) Oracle BI EE
8 3 (7.50%) Oracle Database 11g
8 3 (7.50%) Oracle ODI
8 3 (7.50%) SQL Server Integration Services
9 2 (5.00%) Azure SQL Database
9 2 (5.00%) GIS
9 2 (5.00%) PostgreSQL
9 2 (5.00%) PowerCenter
Development Applications
1 7 (17.50%) ERwin
2 3 (7.50%) ER Studio
3 1 (2.50%) Jenkins
General
1 12 (30.00%) Finance
2 8 (20.00%) Social Skills
3 4 (10.00%) Inclusion and Diversity
3 4 (10.00%) Public Sector
4 3 (7.50%) Marketing
4 3 (7.50%) Publishing
5 2 (5.00%) Analytical Skills
5 2 (5.00%) Back Office
6 1 (2.50%) Banking
Job Titles
1 13 (32.50%) Data Modeller
2 10 (25.00%) Architect
3 6 (15.00%) Data Architect
3 6 (15.00%) Data Engineer
3 6 (15.00%) Senior
4 5 (12.50%) Azure Engineer
5 4 (10.00%) Senior Architect
5 4 (10.00%) Senior Data Architect
5 4 (10.00%) Solutions Architect
6 3 (7.50%) Data Analytics Architect
6 3 (7.50%) Lead
6 3 (7.50%) Oracle Architect
6 3 (7.50%) Oracle Solutions Architect
7 2 (5.00%) Analytics Manager
7 2 (5.00%) Consultant
7 2 (5.00%) Data Analytics Manager
7 2 (5.00%) Data Consultant
7 2 (5.00%) Data Integration Consultant
7 2 (5.00%) Delivery Manager
7 2 (5.00%) Finance Modeller
Libraries, Frameworks & Software Standards
1 7 (17.50%) PySpark
2 3 (7.50%) XML
3 2 (5.00%) .NET
3 2 (5.00%) Kafka
3 2 (5.00%) Unity DI Container
4 1 (2.50%) Apache Avro
4 1 (2.50%) JSON
4 1 (2.50%) JSON Schema
4 1 (2.50%) SOAP
4 1 (2.50%) YAML
Miscellaneous
1 6 (15.00%) Data Protection Act
2 5 (12.50%) Data Structures
2 5 (12.50%) Market Risk
3 4 (10.00%) Freedom of Information
3 4 (10.00%) Freedom of Information Act
3 4 (10.00%) Management Information System
4 3 (7.50%) Virtual Team
5 1 (2.50%) Greenfield Project
5 1 (2.50%) Product Ownership
Operating Systems
1 1 (2.50%) Unix
Processes & Methodologies
1 35 (87.50%) Data Modelling
2 20 (50.00%) Business Intelligence
3 18 (45.00%) Analytics
4 17 (42.50%) ETL
5 14 (35.00%) Agile
5 14 (35.00%) Kimball Methodology
6 10 (25.00%) Physical Data Model
7 9 (22.50%) Data Engineering
8 8 (20.00%) Dimensional Modelling
8 8 (20.00%) Logical Data Model
9 6 (15.00%) Data Protection
9 6 (15.00%) Inmon Methodology
10 5 (12.50%) Data Mapping
10 5 (12.50%) Requirements Analysis
11 4 (10.00%) Computer Science
11 4 (10.00%) Conceptual Models
11 4 (10.00%) Data Integration
11 4 (10.00%) Master Data Management
11 4 (10.00%) Migration
11 4 (10.00%) Problem-Solving
Programming Languages
1 17 (42.50%) SQL
2 7 (17.50%) Python
3 3 (7.50%) Java
4 2 (5.00%) C#
5 1 (2.50%) Data Analysis Expressions
5 1 (2.50%) Gremlin
5 1 (2.50%) Scala
5 1 (2.50%) Tcl
Qualifications
1 4 (10.00%) Degree
2 3 (7.50%) Security Cleared
3 2 (5.00%) SC Cleared
4 1 (2.50%) DV Cleared
Quality Assurance & Compliance
1 6 (15.00%) Data Quality
System Software
1 2 (5.00%) Docker
Systems Management
1 1 (2.50%) Control-M
1 1 (2.50%) Ganglia
Vendors
1 13 (32.50%) Databricks
2 9 (22.50%) Oracle
3 6 (15.00%) Informatica
3 6 (15.00%) Microsoft
4 3 (7.50%) IDERA
5 1 (2.50%) BMC