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

6 months to
27 Apr 2024
Same period 2023 Same period 2022
Rank 808 836 1069
Rank change year-on-year +28 +233 -216
Permanent jobs citing Star Schema 88 134 163
As % of all permanent jobs advertised in the UK 0.090% 0.13% 0.11%
As % of the Database & Business Intelligence category 0.49% 0.59% 0.38%
Number of salaries quoted 72 109 73
10th Percentile - £52,500 £38,000
25th Percentile £35,000 £53,000 £42,500
Median annual salary (50th Percentile) £37,500 £65,000 £52,500
Median % change year-on-year -42.31% +23.81% +16.67%
75th Percentile £72,762 £71,250 £61,250
90th Percentile £89,875 £72,750 £66,053
UK excluding London median annual salary £35,000 £63,750 £50,000
% change year-on-year -45.10% +27.50% +11.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,076 22,599 42,565
As % of all permanent jobs advertised in the UK 18.44% 21.59% 27.62%
Number of salaries quoted 12,541 13,991 21,425
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 £78,750
90th Percentile £95,000 £103,750 £95,000
UK excluding London median annual salary £52,500 £55,000 £52,000
% change year-on-year -4.55% +5.77% +6.12%

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 27 April 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 27 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Jobs
England +81 88 £37,500 -42.31% 6
UK excluding London +27 62 £35,000 -45.10% 3
Work from Home +73 44 £35,000 -46.15% 2
London +88 26 £82,250 +26.54% 3
North of England +57 26 £35,000 -44.00% 1
North West - 22 £35,000 - 1
Midlands +23 18 £35,000 -33.33% 1
West Midlands +38 15 £35,000 -33.33% 1
South West -1 15 £37,500 -44.44% 2
Yorkshire +77 4 £35,000 -44.00%
South East +26 3 £47,500 -17.39%
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 5 (5.68%) Oracle Application Server
2 4 (4.55%) Apache Spark
3 2 (2.27%) SharePoint
4 1 (1.14%) Apache
4 1 (1.14%) Apache Airflow
Applications
1 6 (6.82%) Microsoft Office
1 6 (6.82%) Trello
Business Applications
1 1 (1.14%) HFM
1 1 (1.14%) Oracle EBS
Cloud Services
1 62 (70.45%) Azure
2 44 (50.00%) Snowflake
3 38 (43.18%) Power Platform
4 32 (36.36%) Matillion
5 30 (34.09%) Azure Cosmos DB
6 10 (11.36%) AWS
7 7 (7.95%) dbt
7 7 (7.95%) GCP
8 6 (6.82%) Azure Data Factory
8 6 (6.82%) Google Analytics
9 5 (5.68%) Amazon EMR
9 5 (5.68%) Amazon S3
10 4 (4.55%) Power Automate
10 4 (4.55%) SaaS
11 3 (3.41%) Azure DevOps
11 3 (3.41%) Fivetran
11 3 (3.41%) IaaS
11 3 (3.41%) PaaS
12 2 (2.27%) Azure Sentinel
12 2 (2.27%) Azure Synapse Analytics
Database & Business Intelligence
1 69 (78.41%) Data Warehouse
2 51 (57.95%) Data Lake
3 45 (51.14%) SQL Server
4 38 (43.18%) Power BI
5 30 (34.09%) Elasticsearch
6 26 (29.55%) Snowflake Schema
7 21 (23.86%) SQL Server Integration Services
8 15 (17.05%) Data Vault
9 13 (14.77%) SQL Server Analysis Services
10 12 (13.64%) SQL Server Reporting Services
11 11 (12.50%) Tableau
12 10 (11.36%) Big Data
13 8 (9.09%) Oracle BI EE
13 8 (9.09%) Power Query
14 7 (7.95%) Relational Database
15 6 (6.82%) Amazon Redshift
15 6 (6.82%) PowerPivot
16 5 (5.68%) BigQuery
17 4 (4.55%) Delta Lake
17 4 (4.55%) NoSQL
Development Applications
1 30 (34.09%) GitLab
2 6 (6.82%) JIRA
2 6 (6.82%) SQL Server Management Studio (SSMS)
3 3 (3.41%) Git
3 3 (3.41%) Jenkins
General
1 16 (18.18%) Social Skills
2 11 (12.50%) Finance
3 7 (7.95%) Analytical Skills
3 7 (7.95%) Documentation Skills
4 6 (6.82%) Marketing
5 5 (5.68%) Retail
6 4 (4.55%) Banking
7 3 (3.41%) Manufacturing
7 3 (3.41%) Retail Banking
8 1 (1.14%) Investment Banking
8 1 (1.14%) Legal
Job Titles
1 44 (50.00%) Data Engineer
2 14 (15.91%) Analyst
3 10 (11.36%) Senior
4 9 (10.23%) Architect
4 9 (10.23%) Business Intelligence Manager
4 9 (10.23%) Business Manager
5 6 (6.82%) Business Analyst
5 6 (6.82%) Business Intelligence Analyst
5 6 (6.82%) Business Intelligence Architect
5 6 (6.82%) Data Architect
5 6 (6.82%) Senior Data Engineer
5 6 (6.82%) Technical Analyst
5 6 (6.82%) Technical Business Analyst
6 3 (3.41%) Developer
6 3 (3.41%) Head of Analytics
6 3 (3.41%) Head of Data Analytics
6 3 (3.41%) Senior Business Manager
6 3 (3.41%) Senior Manager
6 3 (3.41%) Technical Architect
7 2 (2.27%) Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 6 (6.82%) Pandas
2 5 (5.68%) HTML
2 5 (5.68%) XML
3 4 (4.55%) MDX
4 3 (3.41%) .NET
4 3 (3.41%) JSON
5 2 (2.27%) REST
6 1 (1.14%) Apache NiFi
6 1 (1.14%) Kafka
6 1 (1.14%) Oracle GoldenGate
6 1 (1.14%) PySpark
6 1 (1.14%) SOAP
Miscellaneous
1 35 (39.77%) Data Structures
2 30 (34.09%) Self-Motivation
3 6 (6.82%) Onboarding
4 5 (5.68%) Product Ownership
5 3 (3.41%) NHS
5 3 (3.41%) Public Cloud
6 1 (1.14%) Analytical Mindset
6 1 (1.14%) Greenfield Project
6 1 (1.14%) Oracle Exalytics
Processes & Methodologies
1 75 (85.23%) Analytics
2 74 (84.09%) Data Modelling
3 68 (77.27%) ETL
4 49 (55.68%) Data Science
5 43 (48.86%) Data Engineering
6 42 (47.73%) Data Pipeline
6 42 (47.73%) Machine Learning
6 42 (47.73%) Problem-Solving
7 40 (45.45%) Data Analytics
8 38 (43.18%) Business Intelligence
9 36 (40.91%) Artificial Intelligence
9 36 (40.91%) CI/CD
10 35 (39.77%) Data Integration
11 32 (36.36%) Data Transformation
12 20 (22.73%) Visualisation
13 15 (17.05%) Agile
14 14 (15.91%) Stakeholder Management
15 13 (14.77%) Design Patterns
15 13 (14.77%) DevOps
15 13 (14.77%) Migration
Programming Languages
1 77 (87.50%) SQL
2 60 (68.18%) Python
3 15 (17.05%) Data Analysis Expressions
4 11 (12.50%) T-SQL
5 6 (6.82%) R
6 5 (5.68%) PHP
6 5 (5.68%) VBA
7 4 (4.55%) Java
8 2 (2.27%) PL/SQL
8 2 (2.27%) PowerShell
9 1 (1.14%) C#
9 1 (1.14%) Scala
Qualifications
1 11 (12.50%) Degree
2 7 (7.95%) Security Cleared
3 6 (6.82%) Azure Certification
3 6 (6.82%) BPSS Clearance
3 6 (6.82%) IIBA
3 6 (6.82%) Master's Degree
4 1 (1.14%) SC Cleared
Quality Assurance & Compliance
1 45 (51.14%) Data Quality
2 6 (6.82%) QA
Systems Management
1 3 (3.41%) Kubernetes
2 1 (1.14%) Control-M
2 1 (1.14%) Terraform
Vendors
1 14 (15.91%) Microsoft
2 10 (11.36%) Google
3 8 (9.09%) Oracle
4 6 (6.82%) Databricks
5 4 (4.55%) BiZZdesign
6 3 (3.41%) Informatica
7 2 (2.27%) Snow
8 1 (1.14%) BMC
8 1 (1.14%) Hyperion
8 1 (1.14%) Talend