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

6 months to
1 Dec 2023
Same period 2022 Same period 2021
Rank 674 899 960
Rank change year-on-year +225 +61 -242
Permanent jobs citing Star Schema 70 186 136
As % of all permanent jobs advertised in the UK 0.13% 0.15% 0.11%
As % of the Database & Business Intelligence category 0.61% 0.64% 0.39%
Number of salaries quoted 46 91 101
10th Percentile - £41,250 £38,000
25th Percentile £36,750 £51,750 £40,750
Median annual salary (50th Percentile) £51,250 £60,000 £50,000
Median % change year-on-year -14.58% +20.00% -23.08%
75th Percentile £61,875 £70,000 £66,053
90th Percentile £80,000 £77,500 £80,000
UK excluding London median annual salary £45,000 £55,500 £42,500
% change year-on-year -18.92% +30.59% -5.56%

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 11,403 29,265 35,282
As % of all permanent jobs advertised in the UK 21.24% 23.36% 27.25%
Number of salaries quoted 8,598 17,806 22,715
10th Percentile £37,000 £36,750 £35,500
25th Percentile £47,000 £46,250 £42,500
Median annual salary (50th Percentile) £60,000 £62,500 £58,500
Median % change year-on-year -4.00% +6.84% +6.36%
75th Percentile £80,000 £82,500 £77,500
90th Percentile £95,000 £100,000 £95,000
UK excluding London median annual salary £55,000 £55,000 £50,000
% change year-on-year - +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 1 December 2023.

Salary histogram for Star Schema in the UK

Star Schema
Top 9 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 1 December 2023. 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 +192 69 £51,250 -14.58% 15
UK excluding London +204 56 £45,000 -18.92% 6
Work from Home +192 45 £56,250 -7.92% 8
North of England +110 31 £45,000 - 2
Yorkshire +96 28 £45,000 -15.09% 1
South West +88 15 £37,500 -44.44% 2
London +204 13 £65,000 +8.33% 10
South East +148 10 £51,250 -6.82% 2
North West +81 3 £46,250 +26.71% 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 10 (14.29%) Oracle Application Server
2 2 (2.86%) Apache Airflow
3 1 (1.43%) Confluence
3 1 (1.43%) SAS
Applications
1 4 (5.71%) Microsoft Excel
2 2 (2.86%) Microsoft Office
2 2 (2.86%) Trello
Business Applications
1 1 (1.43%) Dynamics NAV
1 1 (1.43%) HFM
1 1 (1.43%) Oracle EBS
Cloud Services
1 49 (70.00%) Power Platform
2 34 (48.57%) Azure
3 27 (38.57%) Azure DevOps
4 11 (15.71%) Google Analytics
5 10 (14.29%) Snowflake
6 9 (12.86%) SaaS
7 6 (8.57%) GCP
8 5 (7.14%) AWS
9 3 (4.29%) IaaS
9 3 (4.29%) PaaS
10 2 (2.86%) PowerApps
11 1 (1.43%) Azure Data Factory
11 1 (1.43%) Azure Synapse Analytics
Communications & Networking
1 2 (2.86%) FTP
Database & Business Intelligence
1 49 (70.00%) Power BI
2 34 (48.57%) Data Warehouse
3 21 (30.00%) Power Query
4 15 (21.43%) SQL Server
5 13 (18.57%) Snowflake Schema
6 12 (17.14%) SQL Server Integration Services
6 12 (17.14%) Tableau
7 11 (15.71%) Oracle BI EE
8 10 (14.29%) SQL Server Analysis Services
9 8 (11.43%) SQL Server Reporting Services
10 7 (10.00%) Data Lake
10 7 (10.00%) Microsoft Analysis Services
10 7 (10.00%) Relational Database
11 6 (8.57%) Big Data
11 6 (8.57%) BigQuery
12 4 (5.71%) DTS
12 4 (5.71%) NoSQL
12 4 (5.71%) Oracle Reports
13 3 (4.29%) OLAP
13 3 (4.29%) OLAP Cube
Development Applications
1 5 (7.14%) Git
2 3 (4.29%) Jenkins
2 3 (4.29%) JIRA
2 3 (4.29%) SQL Server Management Studio (SSMS)
3 2 (2.86%) Visual Studio
4 1 (1.43%) Team Foundation Server
General
1 35 (50.00%) Analytical Skills
2 32 (45.71%) Marketing
3 21 (30.00%) Electronics
3 21 (30.00%) Manufacturing
4 14 (20.00%) Social Skills
5 10 (14.29%) Finance
5 10 (14.29%) Retail
6 6 (8.57%) Documentation Skills
7 5 (7.14%) Public Sector
8 3 (4.29%) Banking
8 3 (4.29%) Legal
8 3 (4.29%) Retail Banking
9 1 (1.43%) Games
9 1 (1.43%) Law
Job Titles
1 33 (47.14%) Developer
2 21 (30.00%) Business Intelligence Developer
2 21 (30.00%) Power BI Developer
3 18 (25.71%) Analyst
4 14 (20.00%) Business Intelligence Analyst
5 12 (17.14%) SQL Developer
6 10 (14.29%) Data Engineer
7 4 (5.71%) Architect
7 4 (5.71%) Power BI Analyst
7 4 (5.71%) Senior
7 4 (5.71%) SQL Server Developer
8 3 (4.29%) Data Analyst
8 3 (4.29%) Data Architect
8 3 (4.29%) Junior
8 3 (4.29%) Junior Developer
8 3 (4.29%) Junior SQL Developer
8 3 (4.29%) Junior SQL Server Developer
8 3 (4.29%) Senior Data Engineer
8 3 (4.29%) Technical Specialist
9 2 (2.86%) Business Intelligence Data Analyst
Libraries, Frameworks & Software Standards
1 10 (14.29%) HTML
2 7 (10.00%) XML
3 6 (8.57%) ADO
4 3 (4.29%) JSON
5 1 (1.43%) Oracle GoldenGate
Miscellaneous
1 7 (10.00%) Management Information System
1 7 (10.00%) Product Ownership
2 4 (5.71%) Data Structures
2 4 (5.71%) Enterprise Software
3 3 (4.29%) Greenfield Project
3 3 (4.29%) Public Cloud
4 2 (2.86%) Onboarding
5 1 (1.43%) Cloud Native
5 1 (1.43%) Legacy Systems
5 1 (1.43%) NHS
5 1 (1.43%) Oracle Exalytics
Processes & Methodologies
1 52 (74.29%) Business Intelligence
2 50 (71.43%) Analytics
3 48 (68.57%) Data Modelling
4 39 (55.71%) DevOps
5 37 (52.86%) Visualisation
6 21 (30.00%) Business Analytics
7 15 (21.43%) Agile
7 15 (21.43%) Problem-Solving
7 15 (21.43%) Scrum
8 14 (20.00%) Collaborative Working
8 14 (20.00%) Data Visualisation
9 11 (15.71%) Data Architecture
10 10 (14.29%) Data Analytics
10 10 (14.29%) Product Marketing
11 9 (12.86%) Data Analysis
11 9 (12.86%) ETL
12 7 (10.00%) Computer Science
13 6 (8.57%) Data Engineering
13 6 (8.57%) Data Integration
13 6 (8.57%) Unit Testing
Programming Languages
1 64 (91.43%) SQL
2 26 (37.14%) Data Analysis Expressions
3 16 (22.86%) T-SQL
4 10 (14.29%) PHP
4 10 (14.29%) VBA
5 8 (11.43%) Python
6 3 (4.29%) Java
7 2 (2.86%) R
8 1 (1.43%) PL/SQL
8 1 (1.43%) PowerShell
Qualifications
1 30 (42.86%) Degree
2 3 (4.29%) Security Cleared
3 2 (2.86%) BPSS Clearance
3 2 (2.86%) IIBA
3 2 (2.86%) SC Cleared
4 1 (1.43%) Master's Degree
Quality Assurance & Compliance
1 24 (34.29%) Data Quality
Systems Management
1 3 (4.29%) Kubernetes
2 2 (2.86%) Terraform
Vendors
1 15 (21.43%) Oracle
2 14 (20.00%) Google
3 8 (11.43%) Microsoft
4 1 (1.43%) Databricks
4 1 (1.43%) Hyperion
4 1 (1.43%) Informatica
4 1 (1.43%) Salesforce
4 1 (1.43%) ServiceNow