Dimensional Modelling Jobs

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

6 months to
2 Jun 2024
Same period 2023 Same period 2022
Rank 856 616 956
Rank change year-on-year -240 +340 -163
Permanent jobs citing Dimensional Modelling 49 352 310
As % of all permanent jobs advertised in the UK 0.047% 0.37% 0.18%
As % of the Processes & Methodologies category 0.056% 0.39% 0.19%
Number of salaries quoted 38 183 163
10th Percentile £43,179 £46,500 £46,500
25th Percentile £48,750 £53,000 £50,000
Median annual salary (50th Percentile) £70,000 £65,000 £65,000
Median % change year-on-year +7.69% - +4.00%
75th Percentile £85,000 £72,500 £77,500
90th Percentile £97,000 £85,000 £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 87,980 90,493 162,202
As % of all permanent jobs advertised in the UK 83.59% 95.46% 95.93%
Number of salaries quoted 61,356 54,578 82,967
10th Percentile £29,284 £34,000 £33,500
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £60,899 £60,000
Median % change year-on-year -9.69% +1.50% +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 2 June 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 2 June 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 -193 45 £70,000 +7.69% 34
UK excluding London -118 27 £55,000 -12.00% 21
Work from Home -43 22 £72,500 +11.54% 21
London -82 20 £80,000 +16.44% 14
Midlands -30 10 £45,000 -14.29% 2
West Midlands -20 7 £46,000 -3.16% 1
East of England -14 6 £58,750 -7.48% 1
South West -43 4 £70,000 +2.19% 6
North of England +26 3 £50,000 -4.76% 11
East Midlands -24 3 £45,000 -18.18% 1
North West -18 2 £48,750 -7.14% 4
South East -43 2 £75,000 +20.00% 1
Wales - 2 £46,131 -
Yorkshire +60 1 £65,000 +20.93% 5

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.33%) Apache Spark
2 1 (2.04%) Apache
2 1 (2.04%) Apache Airflow
2 1 (2.04%) Confluence
Cloud Services
1 35 (71.43%) Azure
2 29 (59.18%) Power Platform
3 11 (22.45%) AWS
3 11 (22.45%) Azure Data Factory
4 9 (18.37%) Azure Synapse Analytics
5 8 (16.33%) Serverless
6 6 (12.24%) Snowflake
7 5 (10.20%) Azure DevOps
7 5 (10.20%) GCP
8 4 (8.16%) Amazon S3
9 3 (6.12%) dbt
9 3 (6.12%) Fivetran
9 3 (6.12%) GitHub
10 2 (4.08%) Azure Functions
10 2 (4.08%) Microsoft 365
10 2 (4.08%) PowerApps
11 1 (2.04%) Azure Cognitive Search
11 1 (2.04%) GitHub Actions
11 1 (2.04%) Google Analytics
11 1 (2.04%) Power Automate
Database & Business Intelligence
1 40 (81.63%) Data Warehouse
2 29 (59.18%) Power BI
3 14 (28.57%) SQL Server Integration Services
4 13 (26.53%) SQL Server
5 10 (20.41%) Data Lake
6 8 (16.33%) SQL Server Reporting Services
7 7 (14.29%) Data Vault
7 7 (14.29%) Delta Lake
7 7 (14.29%) Metadata
7 7 (14.29%) Semantic Layer
7 7 (14.29%) SQL Server Analysis Services
8 6 (12.24%) Tableau
9 5 (10.20%) Star Schema
10 4 (8.16%) NoSQL
10 4 (8.16%) Power Query
11 3 (6.12%) Azure SQL Database
11 3 (6.12%) Big Data
11 3 (6.12%) Qlik Sense
11 3 (6.12%) QlikView
12 2 (4.08%) Snowflake Schema
Development Applications
1 8 (16.33%) Git
2 3 (6.12%) Subversion
3 1 (2.04%) Bitbucket
3 1 (2.04%) Eclipse
3 1 (2.04%) Jenkins
3 1 (2.04%) JIRA
General
1 14 (28.57%) Finance
2 12 (24.49%) Social Skills
3 8 (16.33%) Inclusion and Diversity
4 6 (12.24%) Analytical Skills
5 5 (10.20%) Public Sector
6 4 (8.16%) Retail
7 3 (6.12%) Manufacturing
8 2 (4.08%) Marketing
9 1 (2.04%) Legal
9 1 (2.04%) Local Government
9 1 (2.04%) Presentation Skills
9 1 (2.04%) Telecoms
Job Titles
1 22 (44.90%) Data Engineer
2 8 (16.33%) Architect
2 8 (16.33%) Data Architect
2 8 (16.33%) Developer
3 7 (14.29%) Senior
4 5 (10.20%) Analyst
4 5 (10.20%) Business Intelligence Developer
5 4 (8.16%) Data Analyst
5 4 (8.16%) Lead
5 4 (8.16%) Power BI Developer
5 4 (8.16%) Power BI Engineer
5 4 (8.16%) Senior Data Engineer
6 3 (6.12%) Head of Analytics
6 3 (6.12%) Head of Data Analytics
6 3 (6.12%) Senior Developer
7 2 (4.08%) Azure Engineer
7 2 (4.08%) Business Intelligence Analyst
7 2 (4.08%) Business Intelligence Data Analyst
7 2 (4.08%) Lead Data Analyst
7 2 (4.08%) Power BI Analyst
Libraries, Frameworks & Software Standards
1 6 (12.24%) JSON
1 6 (12.24%) XML
2 3 (6.12%) MDX
3 1 (2.04%) Kafka
3 1 (2.04%) PySpark
Miscellaneous
1 4 (8.16%) Clustering
1 4 (8.16%) Distributed Systems
2 3 (6.12%) Data Structures
2 3 (6.12%) Management Information System
3 1 (2.04%) Data Fabric
3 1 (2.04%) IoT
3 1 (2.04%) Product Ownership
3 1 (2.04%) Smart Meter
Operating Systems
1 1 (2.04%) Linux
1 1 (2.04%) Unix
1 1 (2.04%) Windows
Processes & Methodologies
1 42 (85.71%) Data Modelling
2 38 (77.55%) Business Intelligence
3 27 (55.10%) ETL
4 18 (36.73%) Analytics
5 16 (32.65%) Data Pipeline
6 12 (24.49%) Agile
6 12 (24.49%) Data Science
6 12 (24.49%) Kimball Methodology
6 12 (24.49%) Visualisation
7 11 (22.45%) CI/CD
7 11 (22.45%) Data Analysis
7 11 (22.45%) Data Engineering
8 9 (18.37%) ETL Development
9 7 (14.29%) Coaching
9 7 (14.29%) Data Visualisation
9 7 (14.29%) DevOps
9 7 (14.29%) Mentoring
9 7 (14.29%) Problem-Solving
9 7 (14.29%) Project Delivery
10 6 (12.24%) Use Case
Programming Languages
1 44 (89.80%) SQL
2 21 (42.86%) Python
3 18 (36.73%) Data Analysis Expressions
4 8 (16.33%) T-SQL
5 5 (10.20%) Scala
6 3 (6.12%) Julia
6 3 (6.12%) R
7 2 (4.08%) PL/SQL
8 1 (2.04%) C#
Qualifications
1 4 (8.16%) BPSS Clearance
2 3 (6.12%) Degree
3 2 (4.08%) Microsoft Certification
3 2 (4.08%) SC Cleared
3 2 (4.08%) Security Cleared
4 1 (2.04%) Azure Certification
4 1 (2.04%) Computer Science Degree
4 1 (2.04%) DBS Check
4 1 (2.04%) TOGAF Certification
Quality Assurance & Compliance
1 8 (16.33%) Data Quality
2 2 (4.08%) QA
3 1 (2.04%) GDPR
Vendors
1 18 (36.73%) Databricks
2 13 (26.53%) Microsoft
3 3 (6.12%) Oracle
4 2 (4.08%) Informatica
5 1 (2.04%) Ab Initio
5 1 (2.04%) Denodo
5 1 (2.04%) Google