Star Schema Jobs

Star Schema
UK

The table below provides summary statistics for permanent job vacancies requiring Star Schema skills. It includes a benchmarking guide to the annual salaries offered in vacancies that cited Star Schema over the 6 months leading up to 26 July 2024, comparing them to the same period in the previous two years.

6 months to
26 Jul 2024
Same period 2023 Same period 2022
Rank 806 797 1048
Rank change year-on-year -9 +251 -122
Permanent jobs citing Star Schema 36 90 227
As % of all permanent jobs advertised in the UK 0.040% 0.11% 0.13%
As % of the Database & Business Intelligence category 0.24% 0.53% 0.47%
Number of salaries quoted 26 58 60
10th Percentile £36,250 £38,150 £33,425
25th Percentile £50,375 £53,000 £41,500
Median annual salary (50th Percentile) £65,000 £65,000 £53,750
Median % change year-on-year - +20.93% +14.97%
75th Percentile £83,000 £70,250 £63,750
90th Percentile £92,500 £72,500 £77,625
UK excluding London median annual salary £51,500 £58,750 £52,500
% change year-on-year -12.34% +11.90% +22.81%

All Database and Business Intelligence Skills
UK

Star Schema falls under the Databases and Business Intelligence category. For comparison with the information above, the following table provides summary statistics for all permanent job vacancies requiring database or business intelligence skills.

Permanent vacancies with a requirement for database or business intelligence skills 14,713 16,902 48,438
As % of all permanent jobs advertised in the UK 16.28% 20.95% 27.64%
Number of salaries quoted 9,555 11,871 21,175
10th Percentile £36,250 £37,500 £36,250
25th Percentile £44,942 £47,500 £45,000
Median annual salary (50th Percentile) £60,000 £62,500 £60,000
Median % change year-on-year -4.00% +4.17% +9.09%
75th Percentile £82,500 £81,250 £80,000
90th Percentile £110,000 £100,000 £96,250
UK excluding London median annual salary £52,500 £55,000 £52,500
% change year-on-year -4.55% +4.76% +8.25%

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 26 July 2024.

Salary histogram for Star Schema in the UK

Star Schema
Top 10 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 26 July 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 -16 33 £67,500 +3.85% 3
UK excluding London -62 19 £51,500 -12.34% 3
London +62 14 £83,000 +21.61% 1
South West 0 14 £37,500 -44.44% 3
Work from Home -1 9 £66,379 +0.52%
North of England -23 3 £50,000 -25.45%
West Midlands -3 2 £55,250 -9.80%
North West -7 2 - -
Midlands -20 2 £55,250 -9.80%
Yorkshire +25 1 £50,000 -25.45%

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 7 (19.44%) Apache Spark
2 4 (11.11%) Oracle Application Server
Applications
1 6 (16.67%) Microsoft Office
1 6 (16.67%) Trello
Cloud Services
1 22 (61.11%) Power Platform
2 21 (58.33%) Azure
3 10 (27.78%) Azure DevOps
4 9 (25.00%) Snowflake
5 8 (22.22%) AWS
6 7 (19.44%) Azure Data Factory
7 5 (13.89%) dbt
7 5 (13.89%) Google Analytics
8 4 (11.11%) Azure Synapse Analytics
9 3 (8.33%) Amazon EMR
9 3 (8.33%) Amazon S3
9 3 (8.33%) Dynamics 365
9 3 (8.33%) Fivetran
10 2 (5.56%) Azure Sentinel
10 2 (5.56%) Cloud Computing
10 2 (5.56%) GCP
10 2 (5.56%) Power Automate
10 2 (5.56%) PowerApps
11 1 (2.78%) SaaS
Database & Business Intelligence
1 24 (66.67%) Data Warehouse
2 22 (61.11%) Power BI
3 14 (38.89%) Snowflake Schema
4 12 (33.33%) Big Data
5 10 (27.78%) Tableau
6 8 (22.22%) Data Vault
7 7 (19.44%) Relational Database
7 7 (19.44%) SQL Server Integration Services
8 6 (16.67%) Data Lake
9 5 (13.89%) SQL Server
10 4 (11.11%) Delta Lake
10 4 (11.11%) Oracle BI EE
11 3 (8.33%) Amazon Redshift
11 3 (8.33%) BusinessObjects
11 3 (8.33%) BusinessObjects Web Intelligence
11 3 (8.33%) SAP Data Services
11 3 (8.33%) SQL Server Analysis Services
11 3 (8.33%) SQL Server Reporting Services
12 2 (5.56%) OLAP
12 2 (5.56%) Power Query
Development Applications
1 6 (16.67%) JIRA
2 3 (8.33%) Git
2 3 (8.33%) Jenkins
3 2 (5.56%) Visual Studio
4 1 (2.78%) Eclipse
General
1 8 (22.22%) Finance
2 7 (19.44%) Analytical Skills
2 7 (19.44%) Retail
2 7 (19.44%) Social Skills
3 5 (13.89%) Marketing
4 3 (8.33%) Manufacturing
5 2 (5.56%) Documentation Skills
6 1 (2.78%) Public Sector
Job Titles
1 11 (30.56%) Analyst
2 8 (22.22%) Data Engineer
3 6 (16.67%) Architect
3 6 (16.67%) Business Analyst
3 6 (16.67%) Technical Analyst
3 6 (16.67%) Technical Business Analyst
4 4 (11.11%) Business Data Analyst
4 4 (11.11%) Business Intelligence Analyst
4 4 (11.11%) Business Intelligence Data Analyst
4 4 (11.11%) Data Analyst
4 4 (11.11%) Developer
4 4 (11.11%) Marketing Analyst
4 4 (11.11%) Marketing Data Analyst
4 4 (11.11%) Senior
5 3 (8.33%) Azure Architect
5 3 (8.33%) Business Intelligence Lead
5 3 (8.33%) Business Objects Architect
5 3 (8.33%) Head of Analytics
5 3 (8.33%) Lead
5 3 (8.33%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 4 (11.11%) HTML
1 4 (11.11%) Pandas
1 4 (11.11%) PySpark
2 1 (2.78%) JSON
2 1 (2.78%) Kafka
2 1 (2.78%) MDX
Miscellaneous
1 6 (16.67%) Onboarding
2 3 (8.33%) Blog
2 3 (8.33%) e-Learning
2 3 (8.33%) Video Conferencing
3 2 (5.56%) Product Ownership
3 2 (5.56%) Self-Motivation
4 1 (2.78%) Analytical Mindset
Processes & Methodologies
1 29 (80.56%) ETL
2 27 (75.00%) Business Intelligence
3 25 (69.44%) Analytics
4 24 (66.67%) Data Modelling
5 16 (44.44%) DevOps
6 15 (41.67%) Visualisation
7 14 (38.89%) Problem-Solving
8 13 (36.11%) Data Science
9 12 (33.33%) Data Architecture
10 11 (30.56%) Agile
11 8 (22.22%) CI/CD
11 8 (22.22%) Data Analytics
12 7 (19.44%) Data Analysis
12 7 (19.44%) Data Governance
12 7 (19.44%) Deadline-Driven
13 6 (16.67%) Artificial Intelligence
13 6 (16.67%) Business Analysis
13 6 (16.67%) Data Visualisation
13 6 (16.67%) Dimensional Modelling
13 6 (16.67%) Use Case
Programming Languages
1 30 (83.33%) SQL
2 19 (52.78%) Python
3 7 (19.44%) T-SQL
4 6 (16.67%) R
5 5 (13.89%) Data Analysis Expressions
6 4 (11.11%) PHP
6 4 (11.11%) VBA
7 2 (5.56%) Bicep
7 2 (5.56%) PL/SQL
8 1 (2.78%) C#
8 1 (2.78%) PowerShell
Qualifications
1 9 (25.00%) Security Cleared
2 6 (16.67%) BPSS Clearance
2 6 (16.67%) Degree
2 6 (16.67%) IIBA
2 6 (16.67%) Master's Degree
3 3 (8.33%) SC Cleared
4 2 (5.56%) Azure Certification
Quality Assurance & Compliance
1 8 (22.22%) Data Quality
2 3 (8.33%) QA
Systems Management
1 3 (8.33%) Terraform
Vendors
1 8 (22.22%) Databricks
1 8 (22.22%) Oracle
2 6 (16.67%) Microsoft
3 5 (13.89%) Google
4 3 (8.33%) SAP
5 2 (5.56%) Snow
6 1 (2.78%) Informatica