Star Schema
UK

The following table provides summary statistics for permanent job vacancies with a requirement for Star Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Star Schema over the 6 months to 28 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
28 May 2024
Same period 2023 Same period 2022
Rank 833 852 1066
Rank change year-on-year +19 +214 -202
Permanent jobs citing Star Schema 81 100 171
As % of all permanent jobs advertised in the UK 0.079% 0.10% 0.10%
As % of the Database & Business Intelligence category 0.44% 0.48% 0.36%
Number of salaries quoted 66 80 68
10th Percentile - £52,500 £35,000
25th Percentile £35,000 £54,688 £41,938
Median annual salary (50th Percentile) £37,500 £65,000 £52,500
Median % change year-on-year -42.31% +23.81% +0.96%
75th Percentile £71,250 £71,250 £62,500
90th Percentile £91,250 £72,625 £79,125
UK excluding London median annual salary £35,000 £67,071 £52,500
% change year-on-year -47.82% +27.75% +17.51%

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

Permanent vacancies with a requirement for database or business intelligence skills 18,328 21,007 47,066
As % of all permanent jobs advertised in the UK 17.86% 21.58% 28.19%
Number of salaries quoted 12,523 13,073 21,105
10th Percentile £35,000 £37,500 £36,250
25th Percentile £42,725 £47,500 £45,000
Median annual salary (50th Percentile) £57,500 £65,000 £60,000
Median % change year-on-year -11.54% +8.33% +9.09%
75th Percentile £77,500 £82,500 £80,000
90th Percentile £97,500 £103,750 £95,000
UK excluding London median annual salary £52,500 £55,000 £52,500
% change year-on-year -4.55% +4.76% +10.53%

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
Salary Trend

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

Salary trend for Star Schema in the UK

Star Schema
Salary Histogram

Salary distribution for jobs citing Star Schema over the 6 months to 28 May 2024.

Salary histogram for Star Schema in the UK

Star Schema
Top 12 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Star Schema within the UK over the 6 months to 28 May 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Jobs
England +64 81 £37,500 -43.21% 18
UK excluding London -5 56 £35,000 -47.82% 7
Work from Home +54 40 £35,000 -47.82% 12
London +121 25 £81,500 +25.38% 12
North of England +50 25 £35,000 -46.15%
North West - 22 £35,000 -
Midlands +10 18 £35,000 -33.33% 3
West Midlands +22 15 £35,000 -33.33% 3
South West -27 11 £37,500 -44.44%
Yorkshire +59 3 £35,000 -46.15%
East Midlands - 3 £35,000 -
South East - 2 £47,500 - 2

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 5 (6.17%) Apache Spark
2 3 (3.70%) Oracle Application Server
3 2 (2.47%) SharePoint
4 1 (1.23%) Apache
Applications
1 6 (7.41%) Microsoft Office
1 6 (7.41%) Trello
Cloud Services
1 62 (76.54%) Azure
2 42 (51.85%) Snowflake
3 35 (43.21%) Power Platform
4 32 (39.51%) Matillion
5 30 (37.04%) Azure Cosmos DB
6 9 (11.11%) AWS
7 7 (8.64%) dbt
8 6 (7.41%) Azure Data Factory
9 5 (6.17%) Amazon EMR
9 5 (6.17%) Amazon S3
10 4 (4.94%) Azure DevOps
10 4 (4.94%) Google Analytics
10 4 (4.94%) Power Automate
11 3 (3.70%) Fivetran
11 3 (3.70%) GCP
11 3 (3.70%) SaaS
12 2 (2.47%) Azure Sentinel
12 2 (2.47%) Azure Synapse Analytics
12 2 (2.47%) IaaS
12 2 (2.47%) PaaS
Database & Business Intelligence
1 65 (80.25%) Data Warehouse
2 50 (61.73%) Data Lake
3 45 (55.56%) SQL Server
4 35 (43.21%) Power BI
5 30 (37.04%) Elasticsearch
6 25 (30.86%) Snowflake Schema
7 18 (22.22%) SQL Server Integration Services
8 15 (18.52%) Data Vault
9 13 (16.05%) SQL Server Analysis Services
10 12 (14.81%) SQL Server Reporting Services
11 10 (12.35%) Big Data
12 9 (11.11%) Tableau
13 8 (9.88%) Power Query
14 7 (8.64%) Relational Database
15 6 (7.41%) PowerPivot
16 5 (6.17%) Amazon Redshift
16 5 (6.17%) Oracle BI EE
17 4 (4.94%) Delta Lake
18 3 (3.70%) NoSQL
19 2 (2.47%) SSDT
Development Applications
1 30 (37.04%) GitLab
2 6 (7.41%) JIRA
2 6 (7.41%) SQL Server Management Studio (SSMS)
3 3 (3.70%) Git
4 1 (1.23%) Eclipse
4 1 (1.23%) Jenkins
General
1 13 (16.05%) Social Skills
2 7 (8.64%) Documentation Skills
3 6 (7.41%) Finance
4 5 (6.17%) Analytical Skills
5 4 (4.94%) Marketing
5 4 (4.94%) Retail
6 3 (3.70%) Manufacturing
7 1 (1.23%) Banking
7 1 (1.23%) Investment Banking
Job Titles
1 40 (49.38%) Data Engineer
2 12 (14.81%) Analyst
3 9 (11.11%) Business Intelligence Manager
3 9 (11.11%) Business Manager
3 9 (11.11%) Senior
4 8 (9.88%) Architect
5 6 (7.41%) Business Analyst
5 6 (7.41%) Technical Analyst
5 6 (7.41%) Technical Business Analyst
6 5 (6.17%) Business Intelligence Architect
6 5 (6.17%) Data Architect
6 5 (6.17%) Senior Data Engineer
7 3 (3.70%) Business Intelligence Analyst
7 3 (3.70%) Developer
7 3 (3.70%) Head of Analytics
7 3 (3.70%) Head of Data Analytics
7 3 (3.70%) Senior Business Manager
7 3 (3.70%) Senior Manager
7 3 (3.70%) Technical Architect
8 2 (2.47%) SQL DBA
Libraries, Frameworks & Software Standards
1 6 (7.41%) Pandas
2 4 (4.94%) MDX
2 4 (4.94%) XML
3 3 (3.70%) .NET
3 3 (3.70%) HTML
4 2 (2.47%) JSON
4 2 (2.47%) PySpark
4 2 (2.47%) REST
5 1 (1.23%) Apache NiFi
5 1 (1.23%) Kafka
5 1 (1.23%) SOAP
Miscellaneous
1 35 (43.21%) Data Structures
2 30 (37.04%) Self-Motivation
3 6 (7.41%) Onboarding
4 3 (3.70%) NHS
5 2 (2.47%) Product Ownership
6 1 (1.23%) Analytical Mindset
Processes & Methodologies
1 71 (87.65%) Analytics
2 70 (86.42%) ETL
3 69 (85.19%) Data Modelling
4 49 (60.49%) Data Science
5 42 (51.85%) Machine Learning
6 40 (49.38%) Problem-Solving
7 39 (48.15%) Data Analytics
7 39 (48.15%) Data Engineering
7 39 (48.15%) Data Pipeline
8 36 (44.44%) Artificial Intelligence
8 36 (44.44%) Business Intelligence
8 36 (44.44%) CI/CD
9 35 (43.21%) Data Integration
10 33 (40.74%) Data Transformation
11 18 (22.22%) Visualisation
12 13 (16.05%) Design Patterns
13 12 (14.81%) Migration
13 12 (14.81%) Stakeholder Management
14 11 (13.58%) Agile
14 11 (13.58%) Data Architecture
Programming Languages
1 70 (86.42%) SQL
2 58 (71.60%) Python
3 14 (17.28%) Data Analysis Expressions
4 11 (13.58%) T-SQL
5 6 (7.41%) R
6 3 (3.70%) PHP
6 3 (3.70%) VBA
7 2 (2.47%) PL/SQL
7 2 (2.47%) PowerShell
8 1 (1.23%) C#
8 1 (1.23%) Java
8 1 (1.23%) Scala
Qualifications
1 10 (12.35%) Degree
2 6 (7.41%) Azure Certification
2 6 (7.41%) BPSS Clearance
2 6 (7.41%) IIBA
2 6 (7.41%) Master's Degree
2 6 (7.41%) Security Cleared
Quality Assurance & Compliance
1 42 (51.85%) Data Quality
2 6 (7.41%) QA
Systems Management
1 1 (1.23%) Control-M
1 1 (1.23%) Terraform
Vendors
1 14 (17.28%) Microsoft
2 7 (8.64%) Databricks
3 5 (6.17%) Google
3 5 (6.17%) Oracle
4 4 (4.94%) BiZZdesign
5 2 (2.47%) Informatica
5 2 (2.47%) Snow
6 1 (1.23%) BMC
6 1 (1.23%) Talend