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

6 months to
4 May 2024
Same period 2023 Same period 2022
Rank 864 630 926
Rank change year-on-year -234 +296 -154
Permanent jobs citing Dimensional Modelling 47 401 290
As % of all permanent jobs advertised in the UK 0.048% 0.39% 0.19%
As % of the Processes & Methodologies category 0.056% 0.40% 0.19%
Number of salaries quoted 39 196 173
10th Percentile £42,400 £47,500 £45,100
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% +18.18%
75th Percentile £85,000 £73,250 £75,000
90th Percentile £95,500 £85,000 £92,250
UK excluding London median annual salary £50,000 £62,500 £54,500
% change year-on-year -20.00% +14.68% +21.11%

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,620 99,018 149,592
As % of all permanent jobs advertised in the UK 85.90% 95.62% 95.60%
Number of salaries quoted 59,724 58,165 83,321
10th Percentile £29,000 £34,000 £33,500
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £61,500 £60,000
Median % change year-on-year -10.57% +2.50% +9.09%
75th Percentile £72,500 £81,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 4 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 4 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 -210 41 £68,500 +1.48% 17
UK excluding London -101 25 £50,000 -20.00% 6
Work from Home -35 21 £70,000 +3.70% 5
London -98 18 £81,000 +17.90% 11
Midlands -7 11 £43,750 -16.67% 2
West Midlands +3 9 £42,500 -15.00% 1
East of England +12 6 £58,750 -2.89%
North of England +26 4 £57,500 +9.52% 2
North West +4 3 £50,000 -4.76% 2
East Midlands -23 2 £45,000 -18.18% 1
Wales - 2 £46,131 -
Yorkshire +88 1 £65,000 +18.18%
South East -13 1 - - 1
South West -40 1 £70,000 +3.70% 1

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 (17.02%) Apache Spark
2 1 (2.13%) Apache
2 1 (2.13%) Apache Airflow
2 1 (2.13%) Apache Synapse
2 1 (2.13%) Confluence
Cloud Services
1 37 (78.72%) Azure
2 23 (48.94%) Power Platform
3 14 (29.79%) Azure Data Factory
4 12 (25.53%) Azure Synapse Analytics
5 11 (23.40%) AWS
6 9 (19.15%) Serverless
7 5 (10.64%) Azure DevOps
7 5 (10.64%) GCP
7 5 (10.64%) Snowflake
8 4 (8.51%) Amazon S3
9 3 (6.38%) Azure Functions
9 3 (6.38%) Fivetran
9 3 (6.38%) GitHub
10 2 (4.26%) Azure Cognitive Search
10 2 (4.26%) Azure Cognitive Services
10 2 (4.26%) dbt
10 2 (4.26%) Microsoft 365
10 2 (4.26%) PowerApps
11 1 (2.13%) Google Analytics
11 1 (2.13%) Power Automate
Database & Business Intelligence
1 39 (82.98%) Data Warehouse
2 23 (48.94%) Power BI
3 15 (31.91%) SQL Server Integration Services
4 13 (27.66%) Data Lake
5 12 (25.53%) SQL Server
6 10 (21.28%) Data Vault
6 10 (21.28%) Delta Lake
6 10 (21.28%) Metadata
7 7 (14.89%) Semantic Layer
7 7 (14.89%) SQL Server Analysis Services
7 7 (14.89%) SQL Server Reporting Services
8 5 (10.64%) Big Data
8 5 (10.64%) Parquet
9 4 (8.51%) NoSQL
9 4 (8.51%) Star Schema
10 3 (6.38%) Azure SQL Database
10 3 (6.38%) QlikView
10 3 (6.38%) Tableau
11 2 (4.26%) Power Query
11 2 (4.26%) Snowflake Schema
Development Applications
1 5 (10.64%) Git
2 1 (2.13%) Bitbucket
2 1 (2.13%) Jenkins
2 1 (2.13%) JIRA
General
1 14 (29.79%) Finance
2 12 (25.53%) Social Skills
3 6 (12.77%) Inclusion and Diversity
4 5 (10.64%) Public Sector
5 4 (8.51%) Analytical Skills
5 4 (8.51%) Retail
6 3 (6.38%) Legal
6 3 (6.38%) Manufacturing
7 2 (4.26%) Marketing
8 1 (2.13%) Local Government
8 1 (2.13%) Presentation Skills
8 1 (2.13%) Telecoms
Job Titles
1 24 (51.06%) Data Engineer
2 10 (21.28%) Developer
3 8 (17.02%) Architect
3 8 (17.02%) Data Architect
4 6 (12.77%) Senior
5 5 (10.64%) Azure Engineer
5 5 (10.64%) Business Intelligence Developer
6 4 (8.51%) Azure Data Engineer
6 4 (8.51%) Power BI Developer
6 4 (8.51%) Power BI Engineer
7 3 (6.38%) Head of Analytics
7 3 (6.38%) Head of Data Analytics
7 3 (6.38%) Senior Data Engineer
7 3 (6.38%) Senior Developer
8 2 (4.26%) Database Developer
9 1 (2.13%) Ab Initio Consultant
9 1 (2.13%) Consultant
9 1 (2.13%) Data Consultant
9 1 (2.13%) Data Modeller
9 1 (2.13%) Solutions Architect
Libraries, Frameworks & Software Standards
1 7 (14.89%) JSON
1 7 (14.89%) XML
2 3 (6.38%) MDX
3 2 (4.26%) Kafka
Miscellaneous
1 4 (8.51%) Clustering
1 4 (8.51%) Distributed Systems
2 3 (6.38%) IoT
2 3 (6.38%) Management Information System
3 1 (2.13%) Data Fabric
3 1 (2.13%) Product Ownership
3 1 (2.13%) Smart Meter
Operating Systems
1 1 (2.13%) Linux
1 1 (2.13%) Unix
1 1 (2.13%) Windows
Processes & Methodologies
1 39 (82.98%) Data Modelling
2 33 (70.21%) Business Intelligence
3 28 (59.57%) ETL
4 18 (38.30%) Data Pipeline
5 14 (29.79%) Analytics
6 13 (27.66%) Visualisation
7 12 (25.53%) DevOps
7 12 (25.53%) Kimball Methodology
8 11 (23.40%) Agile
8 11 (23.40%) Data Analysis
8 11 (23.40%) Data Science
9 10 (21.28%) CI/CD
10 9 (19.15%) Data Engineering
10 9 (19.15%) ETL Development
11 8 (17.02%) Data Governance
11 8 (17.02%) Data Visualisation
12 7 (14.89%) Problem-Solving
12 7 (14.89%) Project Delivery
13 6 (12.77%) Translating Business Requirements
13 6 (12.77%) Use Case
Programming Languages
1 40 (85.11%) SQL
2 19 (40.43%) Python
3 16 (34.04%) Data Analysis Expressions
4 8 (17.02%) T-SQL
5 5 (10.64%) Scala
6 2 (4.26%) C#
7 1 (2.13%) PL/SQL
Qualifications
1 4 (8.51%) BPSS Clearance
2 3 (6.38%) Degree
3 2 (4.26%) Microsoft Certification
3 2 (4.26%) SC Cleared
3 2 (4.26%) Security Cleared
4 1 (2.13%) Azure Certification
4 1 (2.13%) Computer Science Degree
4 1 (2.13%) DBS Check
4 1 (2.13%) TOGAF Certification
Quality Assurance & Compliance
1 8 (17.02%) Data Quality
2 2 (4.26%) QA
3 1 (2.13%) GDPR
Vendors
1 20 (42.55%) Databricks
2 11 (23.40%) Microsoft
3 2 (4.26%) Informatica
3 2 (4.26%) Oracle
4 1 (2.13%) Ab Initio
4 1 (2.13%) Denodo
4 1 (2.13%) Google