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

6 months to
27 May 2024
Same period 2023 Same period 2022
Rank 859 621 932
Rank change year-on-year -238 +311 -170
Permanent jobs citing Dimensional Modelling 50 368 310
As % of all permanent jobs advertised in the UK 0.049% 0.38% 0.19%
As % of the Processes & Methodologies category 0.058% 0.39% 0.19%
Number of salaries quoted 41 189 163
10th Percentile £42,500 £47,250 £46,500
25th Percentile £47,500 £53,000 £50,000
Median annual salary (50th Percentile) £70,000 £67,500 £65,000
Median % change year-on-year +3.70% +3.85% +4.00%
75th Percentile £85,000 £73,250 £77,500
90th Percentile £92,500 £85,500 £92,250
UK excluding London median annual salary £55,000 £62,500 £54,000
% change year-on-year -12.00% +15.74% +13.50%

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 86,141 93,563 159,256
As % of all permanent jobs advertised in the UK 84.33% 95.54% 95.88%
Number of salaries quoted 60,433 55,405 83,263
10th Percentile £29,250 £34,000 £33,500
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £61,000 £60,000
Median % change year-on-year -9.84% +1.67% +9.09%
75th Percentile £72,500 £81,250 £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 27 May 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 27 May 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 -205 45 £70,000 +7.69% 30
UK excluding London -90 28 £55,000 -12.00% 13
Work from Home -48 23 £70,000 +7.69% 12
London -105 19 £80,000 +16.44% 21
Midlands -29 10 £45,000 -14.29% 2
West Midlands -8 8 £42,500 -10.53% 1
East of England -9 6 £58,750 -7.48%
North of England +41 4 £57,500 +9.52% 1
South West -40 4 £70,000 +2.94% 4
North West +3 3 £50,000 -4.76% 1
East Midlands -28 2 £45,000 -18.18% 1
South East -29 2 £75,000 +20.00% 6
Wales - 2 £46,131 -
Yorkshire +68 1 £65,000 +20.93%

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 38 (76.00%) Azure
2 27 (54.00%) Power Platform
3 13 (26.00%) Azure Data Factory
4 11 (22.00%) AWS
4 11 (22.00%) Azure Synapse Analytics
5 9 (18.00%) Serverless
6 6 (12.00%) Snowflake
7 5 (10.00%) Azure DevOps
7 5 (10.00%) GCP
8 4 (8.00%) Amazon S3
9 3 (6.00%) Azure Functions
9 3 (6.00%) dbt
9 3 (6.00%) Fivetran
9 3 (6.00%) GitHub
10 2 (4.00%) Azure Cognitive Search
10 2 (4.00%) Azure Cognitive Services
10 2 (4.00%) Microsoft 365
10 2 (4.00%) PowerApps
11 1 (2.00%) Google Analytics
11 1 (2.00%) Power Automate
Database & Business Intelligence
1 41 (82.00%) Data Warehouse
2 27 (54.00%) Power BI
3 15 (30.00%) SQL Server Integration Services
4 13 (26.00%) SQL Server
5 12 (24.00%) Data Lake
6 9 (18.00%) Data Vault
6 9 (18.00%) Delta Lake
6 9 (18.00%) Metadata
7 8 (16.00%) SQL Server Reporting Services
8 7 (14.00%) Semantic Layer
8 7 (14.00%) SQL Server Analysis Services
9 6 (12.00%) Tableau
10 5 (10.00%) Star Schema
11 4 (8.00%) Big Data
11 4 (8.00%) NoSQL
11 4 (8.00%) Parquet
12 3 (6.00%) Azure SQL Database
12 3 (6.00%) Qlik Sense
12 3 (6.00%) QlikView
13 2 (4.00%) Snowflake Schema
Development Applications
1 8 (16.00%) Git
2 3 (6.00%) Subversion
3 1 (2.00%) Bitbucket
3 1 (2.00%) Eclipse
3 1 (2.00%) Jenkins
3 1 (2.00%) JIRA
General
1 14 (28.00%) Finance
2 12 (24.00%) Social Skills
3 7 (14.00%) Analytical Skills
4 6 (12.00%) Inclusion and Diversity
5 5 (10.00%) Public Sector
6 4 (8.00%) Retail
7 3 (6.00%) Manufacturing
8 2 (4.00%) Legal
8 2 (4.00%) Marketing
9 1 (2.00%) Local Government
9 1 (2.00%) Presentation Skills
9 1 (2.00%) Telecoms
Job Titles
1 24 (48.00%) Data Engineer
2 9 (18.00%) Developer
3 8 (16.00%) Architect
3 8 (16.00%) Data Architect
4 7 (14.00%) Senior
5 5 (10.00%) Business Intelligence Developer
6 4 (8.00%) Azure Engineer
6 4 (8.00%) Lead
6 4 (8.00%) Power BI Developer
6 4 (8.00%) Power BI Engineer
6 4 (8.00%) Senior Data Engineer
7 3 (6.00%) Analyst
7 3 (6.00%) Azure Data Engineer
7 3 (6.00%) Head of Analytics
7 3 (6.00%) Head of Data Analytics
7 3 (6.00%) Senior Developer
8 2 (4.00%) Data Analyst
8 2 (4.00%) Lead Data Analyst
9 1 (2.00%) Azure Data Architect
9 1 (2.00%) Lead Data Engineer
Libraries, Frameworks & Software Standards
1 7 (14.00%) JSON
1 7 (14.00%) XML
2 3 (6.00%) MDX
3 2 (4.00%) Kafka
4 1 (2.00%) PySpark
Miscellaneous
1 4 (8.00%) Clustering
1 4 (8.00%) Distributed Systems
2 3 (6.00%) Data Structures
2 3 (6.00%) Management Information System
3 2 (4.00%) IoT
4 1 (2.00%) Data Fabric
4 1 (2.00%) Product Ownership
4 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 37 (74.00%) Business Intelligence
3 28 (56.00%) ETL
4 18 (36.00%) Analytics
4 18 (36.00%) Data Pipeline
5 14 (28.00%) Agile
6 13 (26.00%) Data Science
7 12 (24.00%) Kimball Methodology
7 12 (24.00%) Visualisation
8 11 (22.00%) CI/CD
8 11 (22.00%) Data Analysis
8 11 (22.00%) Data Engineering
9 10 (20.00%) DevOps
10 9 (18.00%) ETL Development
11 7 (14.00%) Coaching
11 7 (14.00%) Data Governance
11 7 (14.00%) Data Visualisation
11 7 (14.00%) Mentoring
11 7 (14.00%) Problem-Solving
11 7 (14.00%) Project Delivery
Programming Languages
1 44 (88.00%) SQL
2 23 (46.00%) Python
3 16 (32.00%) Data Analysis Expressions
4 8 (16.00%) T-SQL
5 5 (10.00%) Scala
6 3 (6.00%) Julia
6 3 (6.00%) R
7 2 (4.00%) C#
7 2 (4.00%) PL/SQL
Qualifications
1 4 (8.00%) BPSS Clearance
2 3 (6.00%) Degree
3 2 (4.00%) Microsoft Certification
3 2 (4.00%) SC Cleared
3 2 (4.00%) Security Cleared
4 1 (2.00%) Azure Certification
4 1 (2.00%) Computer Science Degree
4 1 (2.00%) DBS Check
4 1 (2.00%) TOGAF Certification
Quality Assurance & Compliance
1 8 (16.00%) Data Quality
2 2 (4.00%) QA
3 1 (2.00%) GDPR
Vendors
1 20 (40.00%) Databricks
2 11 (22.00%) Microsoft
3 3 (6.00%) Oracle
4 2 (4.00%) Informatica
5 1 (2.00%) Ab Initio
5 1 (2.00%) Denodo
5 1 (2.00%) Google