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

6 months to
2 Mar 2024
Same period 2023 Same period 2022
Rank 759 875 959
Rank change year-on-year +116 +84 -150
Permanent jobs citing Star Schema 86 153 185
As % of all permanent jobs advertised in the UK 0.11% 0.14% 0.13%
As % of the Database & Business Intelligence category 0.54% 0.62% 0.49%
Number of salaries quoted 76 118 97
10th Percentile - £49,925 £38,000
25th Percentile £35,000 £53,000 £41,750
Median annual salary (50th Percentile) £37,500 £61,000 £52,500
Median % change year-on-year -38.52% +16.19% +16.67%
75th Percentile £71,546 £71,250 £60,000
90th Percentile £84,000 £75,750 £73,000
UK excluding London median annual salary £35,000 £65,000 £48,750
% change year-on-year -46.15% +33.33% +8.33%

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 15,876 24,878 37,845
As % of all permanent jobs advertised in the UK 19.50% 22.21% 26.66%
Number of salaries quoted 11,728 15,316 21,906
10th Percentile £35,000 £37,500 £36,250
25th Percentile £43,500 £47,500 £44,000
Median annual salary (50th Percentile) £57,500 £62,500 £60,000
Median % change year-on-year -8.00% +4.17% +9.09%
75th Percentile £75,000 £83,750 £77,500
90th Percentile £95,000 £102,000 £95,000
UK excluding London median annual salary £52,500 £55,000 £50,000
% change year-on-year -4.55% +10.00% +2.04%

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 2 March 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 2 March 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 +124 85 £37,500 -39.27% 8
UK excluding London +84 59 £35,000 -46.15% 4
Work from Home +130 45 £35,000 -47.82%
London +144 26 £76,250 +27.08% 4
North of England +94 26 £35,000 -42.62% 3
North West +76 21 £35,000 - 1
Midlands +75 16 £35,000 -33.01%
West Midlands +79 13 £35,000 -33.01%
South West +16 11 £37,500 -44.44% 1
South East +58 6 £52,500 -12.50%
Yorkshire +82 5 £35,000 -42.62% 2
East Midlands - 3 £35,000 -

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 8 (9.30%) Oracle Application Server
2 2 (2.33%) Apache Airflow
2 2 (2.33%) SharePoint
3 1 (1.16%) Apache
3 1 (1.16%) Confluence
Business Applications
1 1 (1.16%) HFM
1 1 (1.16%) Oracle EBS
Cloud Services
1 55 (63.95%) Azure
2 44 (51.16%) Snowflake
3 33 (38.37%) Power Platform
4 32 (37.21%) Matillion
5 30 (34.88%) Azure Cosmos DB
6 8 (9.30%) Google Analytics
7 7 (8.14%) GCP
8 6 (6.98%) SaaS
9 4 (4.65%) Azure Data Factory
9 4 (4.65%) dbt
9 4 (4.65%) IaaS
9 4 (4.65%) PaaS
9 4 (4.65%) Power Automate
10 3 (3.49%) Amazon EMR
10 3 (3.49%) Amazon S3
10 3 (3.49%) AWS
11 2 (2.33%) Azure DevOps
11 2 (2.33%) Azure Sentinel
11 2 (2.33%) Azure Synapse Analytics
11 2 (2.33%) PowerApps
Database & Business Intelligence
1 69 (80.23%) Data Warehouse
2 49 (56.98%) Data Lake
3 47 (54.65%) SQL Server
4 33 (38.37%) Power BI
5 30 (34.88%) Elasticsearch
6 20 (23.26%) Snowflake Schema
6 20 (23.26%) SQL Server Integration Services
7 11 (12.79%) Oracle BI EE
7 11 (12.79%) SQL Server Analysis Services
7 11 (12.79%) SQL Server Reporting Services
8 8 (9.30%) Data Vault
8 8 (9.30%) Power Query
8 8 (9.30%) Tableau
9 6 (6.98%) BigQuery
9 6 (6.98%) PowerPivot
10 5 (5.81%) Amazon Redshift
11 4 (4.65%) Big Data
11 4 (4.65%) NoSQL
12 3 (3.49%) OLAP
12 3 (3.49%) OLAP Cube
Development Applications
1 30 (34.88%) GitLab
2 6 (6.98%) SQL Server Management Studio (SSMS)
3 3 (3.49%) Jenkins
4 2 (2.33%) Git
5 1 (1.16%) JIRA
5 1 (1.16%) Team Foundation Server
5 1 (1.16%) Visual Studio
General
1 18 (20.93%) Social Skills
2 11 (12.79%) Analytical Skills
3 8 (9.30%) Marketing
3 8 (9.30%) Retail
4 7 (8.14%) Documentation Skills
4 7 (8.14%) Finance
5 4 (4.65%) Banking
6 3 (3.49%) Retail Banking
7 2 (2.33%) Legal
8 1 (1.16%) Games
8 1 (1.16%) Investment Banking
Job Titles
1 43 (50.00%) Data Engineer
2 15 (17.44%) Analyst
3 12 (13.95%) Business Intelligence Analyst
4 10 (11.63%) Architect
5 9 (10.47%) Business Intelligence Manager
5 9 (10.47%) Business Manager
5 9 (10.47%) Senior
6 7 (8.14%) Data Architect
7 6 (6.98%) Business Intelligence Architect
7 6 (6.98%) Developer
8 5 (5.81%) Senior Data Engineer
9 4 (4.65%) Power BI Analyst
9 4 (4.65%) SQL Developer
10 3 (3.49%) Data Analyst
10 3 (3.49%) Senior Business Manager
10 3 (3.49%) Senior Manager
10 3 (3.49%) Technical Architect
11 2 (2.33%) Business Intelligence Developer
11 2 (2.33%) Data Analytics Manager
11 2 (2.33%) Database Analyst
Libraries, Frameworks & Software Standards
1 8 (9.30%) HTML
2 6 (6.98%) XML
3 3 (3.49%) .NET
3 3 (3.49%) JSON
3 3 (3.49%) MDX
3 3 (3.49%) Pandas
4 2 (2.33%) ADO
4 2 (2.33%) REST
5 1 (1.16%) Apache NiFi
5 1 (1.16%) Oracle GoldenGate
5 1 (1.16%) SOAP
Miscellaneous
1 35 (40.70%) Data Structures
2 30 (34.88%) Self-Motivation
3 4 (4.65%) NHS
4 3 (3.49%) Greenfield Project
4 3 (3.49%) Product Ownership
4 3 (3.49%) Public Cloud
5 1 (1.16%) Analytical Mindset
5 1 (1.16%) Oracle Exalytics
Processes & Methodologies
1 67 (77.91%) Data Modelling
2 66 (76.74%) Analytics
3 55 (63.95%) ETL
4 42 (48.84%) Data Analytics
5 41 (47.67%) Data Engineering
6 39 (45.35%) Data Pipeline
7 38 (44.19%) Machine Learning
7 38 (44.19%) Problem-Solving
8 37 (43.02%) Data Science
9 35 (40.70%) CI/CD
10 33 (38.37%) Data Integration
11 32 (37.21%) Business Intelligence
12 31 (36.05%) Data Transformation
13 30 (34.88%) Artificial Intelligence
14 16 (18.60%) Data Visualisation
14 16 (18.60%) Visualisation
15 12 (13.95%) Migration
15 12 (13.95%) Roadmaps
16 11 (12.79%) Collaborative Working
17 10 (11.63%) Stakeholder Management
Programming Languages
1 75 (87.21%) SQL
2 48 (55.81%) Python
3 14 (16.28%) Data Analysis Expressions
4 9 (10.47%) T-SQL
5 8 (9.30%) PHP
5 8 (9.30%) VBA
6 4 (4.65%) Java
7 2 (2.33%) PowerShell
8 1 (1.16%) PL/SQL
8 1 (1.16%) Scala
Qualifications
1 6 (6.98%) Degree
2 4 (4.65%) Azure Certification
3 1 (1.16%) SC Cleared
3 1 (1.16%) Security Cleared
Quality Assurance & Compliance
1 50 (58.14%) Data Quality
2 6 (6.98%) QA
Systems Management
1 3 (3.49%) Kubernetes
2 2 (2.33%) Terraform
3 1 (1.16%) Control-M
Vendors
1 13 (15.12%) Microsoft
2 12 (13.95%) Google
3 10 (11.63%) Oracle
4 4 (4.65%) BiZZdesign
5 3 (3.49%) Databricks
6 2 (2.33%) Informatica
6 2 (2.33%) Snow
7 1 (1.16%) BMC
7 1 (1.16%) Hyperion
7 1 (1.16%) Talend