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 18 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
18 May 2024
Same period 2023 Same period 2022
Rank 806 871 1077
Rank change year-on-year +65 +206 -215
Permanent jobs citing Star Schema 84 106 167
As % of all permanent jobs advertised in the UK 0.084% 0.11% 0.10%
As % of the Database & Business Intelligence category 0.46% 0.50% 0.37%
Number of salaries quoted 69 92 68
10th Percentile - £52,500 £36,025
25th Percentile £35,000 £53,000 £42,375
Median annual salary (50th Percentile) £37,500 £65,000 £52,500
Median % change year-on-year -42.31% +23.81% -4.98%
75th Percentile £72,433 £71,250 £62,500
90th Percentile £90,500 £72,500 £79,125
UK excluding London median annual salary £35,000 £67,071 £52,500
% change year-on-year -47.82% +27.75% +15.38%

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,257 21,342 45,094
As % of all permanent jobs advertised in the UK 18.27% 21.52% 28.06%
Number of salaries quoted 12,529 13,306 21,042
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 £76,250 £83,750 £80,000
90th Percentile £96,539 £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 18 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 18 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 +79 84 £37,500 -42.31% 9
UK excluding London -6 60 £35,000 -47.82% 7
Work from Home +60 42 £35,000 -47.00% 6
North of England +60 26 £35,000 -45.10% 2
London +78 24 £82,250 +26.54% 4
North West - 22 £35,000 - 2
Midlands +6 18 £35,000 -33.33% 2
West Midlands +24 15 £35,000 -33.33% 2
South West -25 14 £53,750 -20.37%
Yorkshire +69 4 £35,000 -45.10%
East Midlands - 3 £35,000 -
South East +4 2 £47,500 -13.64% 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 5 (5.95%) Apache Spark
2 4 (4.76%) Oracle Application Server
3 2 (2.38%) SharePoint
4 1 (1.19%) Apache
4 1 (1.19%) Apache Airflow
Applications
1 6 (7.14%) Microsoft Office
1 6 (7.14%) Trello
Cloud Services
1 63 (75.00%) Azure
2 43 (51.19%) Snowflake
3 36 (42.86%) Power Platform
4 32 (38.10%) Matillion
5 30 (35.71%) Azure Cosmos DB
6 10 (11.90%) AWS
7 7 (8.33%) dbt
8 6 (7.14%) Azure Data Factory
8 6 (7.14%) GCP
9 5 (5.95%) Amazon EMR
9 5 (5.95%) Amazon S3
9 5 (5.95%) Google Analytics
10 4 (4.76%) Azure DevOps
10 4 (4.76%) Power Automate
11 3 (3.57%) Fivetran
11 3 (3.57%) SaaS
12 2 (2.38%) Azure Sentinel
12 2 (2.38%) Azure Synapse Analytics
12 2 (2.38%) IaaS
12 2 (2.38%) PaaS
Database & Business Intelligence
1 67 (79.76%) Data Warehouse
2 50 (59.52%) Data Lake
3 45 (53.57%) SQL Server
4 36 (42.86%) Power BI
5 30 (35.71%) Elasticsearch
6 26 (30.95%) Snowflake Schema
7 20 (23.81%) SQL Server Integration Services
8 15 (17.86%) Data Vault
9 13 (15.48%) SQL Server Analysis Services
10 12 (14.29%) SQL Server Reporting Services
11 10 (11.90%) Big Data
11 10 (11.90%) Tableau
12 8 (9.52%) Power Query
13 7 (8.33%) Relational Database
14 6 (7.14%) Amazon Redshift
14 6 (7.14%) Oracle BI EE
14 6 (7.14%) PowerPivot
15 4 (4.76%) BigQuery
15 4 (4.76%) Delta Lake
16 3 (3.57%) NoSQL
Development Applications
1 30 (35.71%) GitLab
2 6 (7.14%) JIRA
2 6 (7.14%) SQL Server Management Studio (SSMS)
3 3 (3.57%) Git
3 3 (3.57%) Jenkins
General
1 14 (16.67%) Social Skills
2 9 (10.71%) Finance
3 7 (8.33%) Documentation Skills
4 6 (7.14%) Analytical Skills
5 5 (5.95%) Marketing
5 5 (5.95%) Retail
6 3 (3.57%) Banking
6 3 (3.57%) Manufacturing
7 2 (2.38%) Retail Banking
8 1 (1.19%) Investment Banking
8 1 (1.19%) Legal
Job Titles
1 43 (51.19%) Data Engineer
2 12 (14.29%) Analyst
3 10 (11.90%) Senior
4 9 (10.71%) Business Intelligence Manager
4 9 (10.71%) Business Manager
5 8 (9.52%) Architect
6 6 (7.14%) Business Analyst
6 6 (7.14%) Senior Data Engineer
6 6 (7.14%) Technical Analyst
6 6 (7.14%) Technical Business Analyst
7 5 (5.95%) Business Intelligence Architect
7 5 (5.95%) Data Architect
8 4 (4.76%) Business Intelligence Analyst
9 3 (3.57%) Developer
9 3 (3.57%) Head of Analytics
9 3 (3.57%) Head of Data Analytics
9 3 (3.57%) Senior Business Manager
9 3 (3.57%) Senior Manager
9 3 (3.57%) Technical Architect
10 2 (2.38%) SQL Analyst
Libraries, Frameworks & Software Standards
1 6 (7.14%) Pandas
2 4 (4.76%) HTML
2 4 (4.76%) MDX
2 4 (4.76%) XML
3 3 (3.57%) .NET
4 2 (2.38%) JSON
4 2 (2.38%) PySpark
4 2 (2.38%) REST
5 1 (1.19%) Apache NiFi
5 1 (1.19%) Kafka
5 1 (1.19%) SOAP
Miscellaneous
1 35 (41.67%) Data Structures
2 30 (35.71%) Self-Motivation
3 6 (7.14%) Onboarding
4 4 (4.76%) Product Ownership
5 3 (3.57%) NHS
6 2 (2.38%) Public Cloud
7 1 (1.19%) Analytical Mindset
7 1 (1.19%) Greenfield Project
Processes & Methodologies
1 73 (86.90%) Analytics
2 71 (84.52%) Data Modelling
3 69 (82.14%) ETL
4 49 (58.33%) Data Science
5 42 (50.00%) Data Engineering
5 42 (50.00%) Machine Learning
6 41 (48.81%) Data Pipeline
6 41 (48.81%) Problem-Solving
7 40 (47.62%) Data Analytics
8 37 (44.05%) CI/CD
9 36 (42.86%) Artificial Intelligence
9 36 (42.86%) Business Intelligence
10 35 (41.67%) Data Integration
11 32 (38.10%) Data Transformation
12 19 (22.62%) Visualisation
13 13 (15.48%) Agile
13 13 (15.48%) Design Patterns
13 13 (15.48%) DevOps
14 12 (14.29%) Migration
14 12 (14.29%) Stakeholder Management
Programming Languages
1 73 (86.90%) SQL
2 60 (71.43%) Python
3 14 (16.67%) Data Analysis Expressions
4 11 (13.10%) T-SQL
5 6 (7.14%) R
6 4 (4.76%) PHP
6 4 (4.76%) VBA
7 3 (3.57%) Java
8 2 (2.38%) PowerShell
9 1 (1.19%) C#
9 1 (1.19%) PL/SQL
9 1 (1.19%) Scala
Qualifications
1 10 (11.90%) Degree
2 6 (7.14%) Azure Certification
2 6 (7.14%) BPSS Clearance
2 6 (7.14%) IIBA
2 6 (7.14%) Master's Degree
2 6 (7.14%) Security Cleared
Quality Assurance & Compliance
1 43 (51.19%) Data Quality
2 6 (7.14%) QA
Systems Management
1 2 (2.38%) Kubernetes
1 2 (2.38%) Terraform
2 1 (1.19%) Control-M
Vendors
1 14 (16.67%) Microsoft
2 8 (9.52%) Google
3 7 (8.33%) Databricks
4 6 (7.14%) Oracle
5 4 (4.76%) BiZZdesign
6 2 (2.38%) Informatica
6 2 (2.38%) Snow
7 1 (1.19%) BMC
7 1 (1.19%) Talend