Dimensional Modelling
UK

The following table provides summary statistics for permanent job vacancies with a requirement for Dimensional Modelling skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Dimensional Modelling over the 6 months to 25 April 2024 with a comparison to the same period in the previous 2 years.

6 months to
25 Apr 2024
Same period 2023 Same period 2022
Rank 844 612 924
Rank change year-on-year -232 +312 -159
Permanent jobs citing Dimensional Modelling 50 427 274
As % of all permanent jobs advertised in the UK 0.051% 0.41% 0.18%
As % of the Processes & Methodologies category 0.059% 0.42% 0.19%
Number of salaries quoted 41 198 176
10th Percentile £42,500 £47,500 £44,694
25th Percentile £47,500 £53,750 £50,000
Median annual salary (50th Percentile) £70,000 £67,500 £65,000
Median % change year-on-year +3.70% +3.85% +18.18%
75th Percentile £83,500 £73,250 £75,000
90th Percentile £92,500 £85,000 £92,500
UK excluding London median annual salary £52,500 £62,500 £54,750
% change year-on-year -16.00% +14.16% +20.33%

All Process and Methodology Skills
UK

Dimensional Modelling is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for process or methodology skills.

Permanent vacancies with a requirement for process or methodology skills 84,476 100,576 147,122
As % of all permanent jobs advertised in the UK 86.05% 95.63% 95.59%
Number of salaries quoted 59,789 58,947 82,930
10th Percentile £29,000 £34,000 £33,476
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £61,700 £60,000
Median % change year-on-year -10.86% +2.83% +9.09%
75th Percentile £72,500 £82,500 £80,000
90th Percentile £92,500 £100,000 £96,250
UK excluding London median annual salary £50,000 £55,000 £52,500
% change year-on-year -9.09% +4.76% +9.38%

Dimensional Modelling
Job Vacancy Trend

Job postings citing Dimensional Modelling as a proportion of all IT jobs advertised.

Job vacancy trend for Dimensional Modelling in the UK

Dimensional Modelling
Salary Trend

3-month moving average salary quoted in jobs citing Dimensional Modelling.

Salary trend for Dimensional Modelling in the UK

Dimensional Modelling
Salary Histogram

Salary distribution for jobs citing Dimensional Modelling over the 6 months to 25 April 2024.

Salary histogram for Dimensional Modelling in the UK

Dimensional Modelling
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Dimensional Modelling within the UK over the 6 months to 25 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 -207 43 £70,000 +3.70% 14
UK excluding London -88 29 £52,500 -16.00% 4
Work from Home -18 21 £70,000 +3.70% 4
London -112 17 £80,000 +15.35% 11
Midlands -18 11 £43,750 -20.45% 2
West Midlands +4 9 £42,500 -19.05% 1
East of England +18 6 £58,750 -2.89%
North of England +31 4 £57,500 +6.98% 1
South East -5 4 £72,500 +16.00%
North West +4 3 £50,000 -4.76% 1
Wales - 3 £46,131 - 1
East Midlands -26 2 £45,000 -18.18% 1
Yorkshire +85 1 £65,000 +18.18%
South West -41 1 £70,000 +3.70%

Dimensional Modelling
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 (16.00%) Apache Spark
2 1 (2.00%) Apache
2 1 (2.00%) Apache Airflow
2 1 (2.00%) Apache Synapse
2 1 (2.00%) Confluence
Cloud Services
1 39 (78.00%) Azure
2 26 (52.00%) Power Platform
3 16 (32.00%) Azure Data Factory
4 14 (28.00%) Azure Synapse Analytics
5 11 (22.00%) AWS
5 11 (22.00%) Serverless
6 5 (10.00%) Azure DevOps
6 5 (10.00%) Azure Functions
6 5 (10.00%) GCP
6 5 (10.00%) Snowflake
7 4 (8.00%) Amazon S3
7 4 (8.00%) Azure Cognitive Search
7 4 (8.00%) Azure Cognitive Services
8 3 (6.00%) Fivetran
8 3 (6.00%) GitHub
9 2 (4.00%) dbt
9 2 (4.00%) Microsoft 365
9 2 (4.00%) PowerApps
10 1 (2.00%) Google Analytics
10 1 (2.00%) Power Automate
Database & Business Intelligence
1 42 (84.00%) Data Warehouse
2 26 (52.00%) Power BI
3 16 (32.00%) Data Lake
3 16 (32.00%) SQL Server Integration Services
4 13 (26.00%) Data Vault
4 13 (26.00%) Delta Lake
5 12 (24.00%) Metadata
5 12 (24.00%) SQL Server
6 8 (16.00%) Parquet
6 8 (16.00%) SQL Server Analysis Services
6 8 (16.00%) SQL Server Reporting Services
7 6 (12.00%) Semantic Layer
8 5 (10.00%) Big Data
9 4 (8.00%) NoSQL
9 4 (8.00%) Star Schema
9 4 (8.00%) Tableau
10 3 (6.00%) Azure SQL Database
10 3 (6.00%) QlikView
11 2 (4.00%) Power Query
11 2 (4.00%) Snowflake Schema
Development Applications
1 5 (10.00%) Git
2 1 (2.00%) Bitbucket
2 1 (2.00%) ERwin
2 1 (2.00%) Jenkins
2 1 (2.00%) JIRA
General
1 13 (26.00%) Finance
2 12 (24.00%) Social Skills
3 6 (12.00%) Inclusion and Diversity
4 5 (10.00%) Public Sector
5 4 (8.00%) Analytical Skills
5 4 (8.00%) Retail
6 3 (6.00%) Legal
6 3 (6.00%) Manufacturing
7 2 (4.00%) Marketing
7 2 (4.00%) Presentation Skills
8 1 (2.00%) Documentation Skills
8 1 (2.00%) Local Government
8 1 (2.00%) Telecoms
Job Titles
1 25 (50.00%) Data Engineer
2 11 (22.00%) Developer
3 9 (18.00%) Architect
3 9 (18.00%) Data Architect
4 7 (14.00%) Azure Engineer
5 6 (12.00%) Business Intelligence Developer
5 6 (12.00%) Senior
6 4 (8.00%) Azure Data Engineer
6 4 (8.00%) Power BI Developer
6 4 (8.00%) Power BI Engineer
7 3 (6.00%) Head of Analytics
7 3 (6.00%) Head of Data Analytics
7 3 (6.00%) Senior Data Engineer
7 3 (6.00%) Senior Developer
8 2 (4.00%) Data Modeller
8 2 (4.00%) Database Developer
9 1 (2.00%) Analytics Developer
9 1 (2.00%) Azure Consultant
9 1 (2.00%) E-Commerce Engineer
9 1 (2.00%) Python Engineer
Libraries, Frameworks & Software Standards
1 10 (20.00%) JSON
1 10 (20.00%) XML
2 3 (6.00%) MDX
3 2 (4.00%) Kafka
Miscellaneous
1 4 (8.00%) Clustering
1 4 (8.00%) Distributed Systems
2 3 (6.00%) IoT
2 3 (6.00%) Management Information System
3 1 (2.00%) Data Fabric
3 1 (2.00%) Product Ownership
3 1 (2.00%) Smart Meter
Operating Systems
1 1 (2.00%) Linux
1 1 (2.00%) Unix
1 1 (2.00%) Windows
Processes & Methodologies
1 42 (84.00%) Data Modelling
2 36 (72.00%) Business Intelligence
3 29 (58.00%) ETL
4 21 (42.00%) Data Pipeline
5 18 (36.00%) Analytics
6 16 (32.00%) Visualisation
7 14 (28.00%) DevOps
8 13 (26.00%) Agile
8 13 (26.00%) Data Science
9 12 (24.00%) Data Analysis
10 11 (22.00%) CI/CD
10 11 (22.00%) Kimball Methodology
11 10 (20.00%) Data Governance
11 10 (20.00%) Data Visualisation
12 9 (18.00%) Data Engineering
12 9 (18.00%) ETL Development
13 8 (16.00%) Problem-Solving
14 7 (14.00%) Project Delivery
15 6 (12.00%) Machine Learning
15 6 (12.00%) Translating Business Requirements
Programming Languages
1 43 (86.00%) SQL
2 21 (42.00%) Python
3 16 (32.00%) Data Analysis Expressions
4 8 (16.00%) T-SQL
5 5 (10.00%) Scala
6 4 (8.00%) C#
7 1 (2.00%) PL/SQL
Qualifications
1 4 (8.00%) BPSS Clearance
1 4 (8.00%) Degree
2 3 (6.00%) Microsoft Certification
3 2 (4.00%) Computer Science Degree
3 2 (4.00%) SC Cleared
3 2 (4.00%) Security Cleared
4 1 (2.00%) Azure Certification
4 1 (2.00%) DBS Check
4 1 (2.00%) Master's Degree
4 1 (2.00%) MCSA
4 1 (2.00%) MCSE
4 1 (2.00%) TOGAF Certification
Quality Assurance & Compliance
1 9 (18.00%) Data Quality
2 2 (4.00%) QA
3 1 (2.00%) GDPR
Vendors
1 22 (44.00%) Databricks
2 10 (20.00%) Microsoft
3 2 (4.00%) Informatica
3 2 (4.00%) Oracle
4 1 (2.00%) Ab Initio
4 1 (2.00%) Denodo
4 1 (2.00%) Google
4 1 (2.00%) IBM