Star Schema Contracts

Star Schema
UK

The table below provides summary statistics for contract job vacancies requiring Star Schema skills. It includes a benchmarking guide to the contractor rates offered in vacancies that cited Star Schema over the 6 months leading up to 20 June 2024, comparing them to the same period in the previous two years.

6 months to
20 Jun 2024
Same period 2023 Same period 2022
Rank 543 635 800
Rank change year-on-year +92 +165 -154
Contract jobs citing Star Schema 41 62 48
As % of all contract jobs advertised in the UK 0.094% 0.11% 0.055%
As % of the Database & Business Intelligence category 0.55% 0.64% 0.28%
Number of daily rates quoted 27 46 38
10th Percentile £398 £388 £313
25th Percentile £425 £414 £380
Median daily rate (50th Percentile) £550 £500 £475
Median % change year-on-year +10.00% +5.26% +5.56%
75th Percentile £663 £588 £568
90th Percentile £713 £663 £640
UK excluding London median daily rate £525 £513 £395
% change year-on-year +2.44% +29.75% -9.71%

All Database and Business Intelligence Skills
UK

Star Schema falls under the Databases and Business Intelligence category. For comparison with the information above, the following table provides summary statistics for all contract job vacancies requiring database or business intelligence skills.

Contract vacancies with a requirement for database or business intelligence skills 7,468 9,744 17,110
As % of all contract IT jobs advertised in the UK 17.10% 17.54% 19.63%
Number of daily rates quoted 5,332 6,905 12,217
10th Percentile £350 £375 £375
25th Percentile £425 £450 £450
Median daily rate (50th Percentile) £525 £545 £550
Median % change year-on-year -3.67% -0.91% +10.00%
75th Percentile £650 £663 £650
90th Percentile £775 £750 £750
UK excluding London median daily rate £475 £500 £500
% change year-on-year -5.00% - +11.11%
Number of hourly rates quoted 155 173 179
10th Percentile £14.00 £21.24 £15.38
25th Percentile £20.77 £32.40 £21.25
Median hourly rate £40.00 £58.59 £43.95
Median % change year-on-year -31.73% +33.31% +62.78%
75th Percentile £53.94 £73.75 £63.30
90th Percentile £72.50 £82.00 £75.00
UK excluding London median hourly rate £34.47 £56.95 £35.00
% change year-on-year -39.48% +62.71% +41.02%

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 20 June 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 12 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 20 June 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 +57 33 £475 -5.00% 19
UK excluding London +32 22 £525 +2.44% 6
Work from Home +102 17 £625 +25.00% 11
London +55 14 £475 -5.00% 12
Scotland - 6 £563 -
South West 0 5 £450 -20.00% 2
Midlands - 5 - -
North of England +19 4 £650 +33.33% 3
North West +17 4 £650 +33.33% 1
South East +14 4 £675 +50.00% 1
East Midlands - 4 - -
West Midlands - 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.44%) Apache
1 1 (2.44%) Apache Spark
Business Applications
1 5 (12.20%) Sparx Enterprise Architect
Cloud Services
1 19 (46.34%) Azure
2 10 (24.39%) Power Platform
3 7 (17.07%) AWS
4 6 (14.63%) Azure Data Factory
5 5 (12.20%) dbt
5 5 (12.20%) GitHub
5 5 (12.20%) Snowflake
6 4 (9.76%) Fivetran
7 2 (4.88%) Azure Logic Apps
8 1 (2.44%) Azure Cosmos DB
8 1 (2.44%) Azure Machine Learning
8 1 (2.44%) Azure Synapse Analytics
8 1 (2.44%) Microsoft Purview
Database & Business Intelligence
1 23 (56.10%) Data Warehouse
2 14 (34.15%) Data Lake
3 13 (31.71%) Snowflake Schema
4 9 (21.95%) Power BI
5 8 (19.51%) SQL Server
6 7 (17.07%) Big Data
7 6 (14.63%) Relational Database
8 5 (12.20%) Amazon Redshift
8 5 (12.20%) RDBMS
9 4 (9.76%) Data Vault
9 4 (9.76%) Tableau
10 3 (7.32%) SQL Server Integration Services
11 2 (4.88%) Delta Lake
11 2 (4.88%) GIS
11 2 (4.88%) PostgreSQL
12 1 (2.44%) Apache Cassandra
12 1 (2.44%) Metadata
12 1 (2.44%) MongoDB
12 1 (2.44%) Neo4j
12 1 (2.44%) NoSQL
Development Applications
1 12 (29.27%) ERwin
2 3 (7.32%) ER Studio
3 1 (2.44%) Jenkins
General
1 9 (21.95%) Finance
2 8 (19.51%) Social Skills
3 4 (9.76%) Inclusion and Diversity
3 4 (9.76%) Public Sector
4 3 (7.32%) Publishing
5 2 (4.88%) Analytical Skills
5 2 (4.88%) Marketing
Job Titles
1 13 (31.71%) Data Modeller
2 12 (29.27%) Architect
3 11 (26.83%) Data Architect
3 11 (26.83%) Data Engineer
4 6 (14.63%) Senior
5 4 (9.76%) Senior Architect
5 4 (9.76%) Senior Data Architect
6 3 (7.32%) Data Analytics Architect
6 3 (7.32%) Lead
7 2 (4.88%) Business Intelligence Developer
7 2 (4.88%) Developer
7 2 (4.88%) Finance Modeller
7 2 (4.88%) Senior Data Engineer
7 2 (4.88%) Snowflake Data Engineer
7 2 (4.88%) Snowflake Engineer
8 1 (2.44%) Data Analyst
8 1 (2.44%) Data Manager
8 1 (2.44%) Delivery Manager
8 1 (2.44%) Oracle Data Warehouse Developer
8 1 (2.44%) Oracle Developer
Libraries, Frameworks & Software Standards
1 4 (9.76%) PySpark
2 2 (4.88%) pytest
2 2 (4.88%) XML
3 1 (2.44%) Apache Avro
3 1 (2.44%) JSON
3 1 (2.44%) JSON Schema
3 1 (2.44%) YAML
Miscellaneous
1 6 (14.63%) Data Protection Act
1 6 (14.63%) Data Structures
2 4 (9.76%) Freedom of Information
2 4 (9.76%) Freedom of Information Act
2 4 (9.76%) Legacy Systems
2 4 (9.76%) Management Information System
3 3 (7.32%) Virtual Team
4 1 (2.44%) Greenfield Project
4 1 (2.44%) Product Ownership
Operating Systems
1 1 (2.44%) Unix
Processes & Methodologies
1 38 (92.68%) Data Modelling
2 18 (43.90%) ETL
3 15 (36.59%) Analytics
4 14 (34.15%) Kimball Methodology
5 12 (29.27%) Agile
5 12 (29.27%) Business Intelligence
6 10 (24.39%) Physical Data Model
7 9 (21.95%) Migration
8 8 (19.51%) Conceptual Models
8 8 (19.51%) Dimensional Modelling
8 8 (19.51%) Logical Data Model
9 7 (17.07%) Data Governance
10 6 (14.63%) Data Migration
10 6 (14.63%) Data Protection
10 6 (14.63%) Inmon Methodology
10 6 (14.63%) Reverse Engineering
11 5 (12.20%) Computer Science
11 5 (12.20%) Data Architecture
11 5 (12.20%) Data Engineering
11 5 (12.20%) Requirements Analysis
Programming Languages
1 18 (43.90%) SQL
2 8 (19.51%) Python
3 2 (4.88%) Java
3 2 (4.88%) PowerShell
4 1 (2.44%) C++
4 1 (2.44%) Data Analysis Expressions
4 1 (2.44%) Gremlin
4 1 (2.44%) PHP
4 1 (2.44%) R
4 1 (2.44%) Scala
4 1 (2.44%) Tcl
Qualifications
1 5 (12.20%) Degree
2 3 (7.32%) Security Cleared
3 2 (4.88%) SC Cleared
4 1 (2.44%) Computer Science Degree
4 1 (2.44%) DV Cleared
Quality Assurance & Compliance
1 10 (24.39%) Data Quality
Systems Management
1 2 (4.88%) Terraform
2 1 (2.44%) Ganglia
Vendors
1 15 (36.59%) Databricks
2 5 (12.20%) Salesforce
2 5 (12.20%) Sparx
3 4 (9.76%) Oracle
4 3 (7.32%) IDERA
5 1 (2.44%) Adobe
5 1 (2.44%) Informatica
5 1 (2.44%) Microsoft