Dimensional Modelling Contracts

Dimensional Modelling
UK

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

6 months to
3 Jun 2024
Same period 2023 Same period 2022
Rank 537 599 750
Rank change year-on-year +62 +151 -144
Contract jobs citing Dimensional Modelling 50 90 101
As % of all contract jobs advertised in the UK 0.12% 0.16% 0.11%
As % of the Processes & Methodologies category 0.14% 0.18% 0.13%
Number of daily rates quoted 31 65 70
10th Percentile £413 £450 £362
25th Percentile £459 £525 £488
Median daily rate (50th Percentile) £500 £575 £550
Median % change year-on-year -13.04% +4.55% +11.11%
75th Percentile £650 £650 £638
90th Percentile £700 £692 £688
UK excluding London median daily rate £490 £533 £563
% change year-on-year -7.98% -5.33% +18.42%
Number of hourly rates quoted 0 2 2
10th Percentile - £71.00 £46.33
25th Percentile - £72.50 £48.31
Median hourly rate - £75.00 £52.25
Median % change year-on-year - +43.54% -
75th Percentile - £77.50 £56.81
90th Percentile - £79.00 £59.18
UK excluding London median hourly rate - - £45.00

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 contract job vacancies with a requirement for process or methodology skills.

Contract vacancies with a requirement for process or methodology skills 36,603 50,558 80,022
As % of all contract IT jobs advertised in the UK 85.40% 89.70% 90.64%
Number of daily rates quoted 23,483 35,017 56,266
10th Percentile £300 £325 £350
25th Percentile £413 £438 £433
Median daily rate (50th Percentile) £525 £550 £538
Median % change year-on-year -4.55% +2.33% +7.50%
75th Percentile £638 £650 £644
90th Percentile £750 £750 £738
UK excluding London median daily rate £500 £500 £488
% change year-on-year - +2.56% +8.33%
Number of hourly rates quoted 2,521 1,671 1,882
10th Percentile £12.75 £10.63 £12.50
25th Percentile £16.00 £15.57 £15.50
Median hourly rate £36.50 £36.00 £25.68
Median % change year-on-year +1.39% +40.19% +10.45%
75th Percentile £60.75 £65.00 £50.00
90th Percentile £72.50 £75.00 £65.00
UK excluding London median hourly rate £38.12 £35.00 £20.00
% change year-on-year +8.91% +75.00% -4.76%

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
Contractor Daily Rate Trend

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

Daily rate trend for Dimensional Modelling in the UK

Dimensional Modelling
Daily Rate Histogram

Daily rate distribution for jobs citing Dimensional Modelling over the 6 months to 3 June 2024.

Daily rate histogram for Dimensional Modelling in the UK

Dimensional Modelling
Contractor Hourly Rate Trend

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

Hourly rate trend for Dimensional Modelling in the UK

Dimensional Modelling
Top 10 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Dimensional Modelling within the UK over the 6 months to 3 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Jobs
England +52 44 £500 -13.04% 34
London +73 27 £513 -14.58% 14
UK excluding London +41 18 £490 -7.98% 21
Work from Home +99 13 £500 -11.11% 21
South East +10 8 £425 -14.14% 1
Midlands +26 6 £700 +28.44% 2
West Midlands +18 6 £700 +28.44% 1
North of England +28 3 £500 +11.11% 11
North West +11 3 £500 +11.11% 4
Scotland - 3 - -

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 3 (6.00%) Confluence
2 2 (4.00%) Apache Spark
Applications
1 7 (14.00%) Microsoft Excel
Cloud Services
1 33 (66.00%) Power Platform
2 16 (32.00%) Azure
3 10 (20.00%) Azure Data Factory
4 6 (12.00%) Serverless
5 4 (8.00%) Azure Functions
5 4 (8.00%) Azure Synapse Analytics
6 3 (6.00%) Amazon S3
6 3 (6.00%) AWS
6 3 (6.00%) Azure DevOps
7 2 (4.00%) Amazon Kinesis
7 2 (4.00%) AWS Lambda
7 2 (4.00%) AWS Step Functions
7 2 (4.00%) dbt
7 2 (4.00%) PowerApps
8 1 (2.00%) Azure Machine Learning
8 1 (2.00%) Azure Stack
8 1 (2.00%) Dynamics 365
8 1 (2.00%) GCP
8 1 (2.00%) IaaS
8 1 (2.00%) PaaS
Database & Business Intelligence
1 42 (84.00%) Data Warehouse
2 33 (66.00%) Power BI
3 14 (28.00%) Data Lake
4 11 (22.00%) SQL Server Integration Services
5 9 (18.00%) SQL Server
5 9 (18.00%) Tableau
6 8 (16.00%) BusinessObjects Business Intelligence
6 8 (16.00%) Star Schema
7 7 (14.00%) Azure SQL Database
7 7 (14.00%) Big Data
7 7 (14.00%) Geospatial Data
8 6 (12.00%) Amazon RDS
9 5 (10.00%) Data Vault
10 4 (8.00%) Relational Database
10 4 (8.00%) SQL Server Reporting Services
11 3 (6.00%) Amazon Athena
11 3 (6.00%) Amazon Redshift
11 3 (6.00%) Data Mining
11 3 (6.00%) Enterprise Data Warehouse
11 3 (6.00%) Snowflake Schema
Development Applications
1 6 (12.00%) JIRA
2 3 (6.00%) ER Studio
3 2 (4.00%) Zephyr
General
1 15 (30.00%) Analytical Skills
2 9 (18.00%) Finance
3 5 (10.00%) Social Skills
4 4 (8.00%) Inclusion and Diversity
4 4 (8.00%) Telecoms
5 2 (4.00%) Presentation Skills
6 1 (2.00%) Advertising
6 1 (2.00%) Law
6 1 (2.00%) Manufacturing
6 1 (2.00%) Public Sector
6 1 (2.00%) Retail
Job Titles
1 13 (26.00%) Analyst
2 12 (24.00%) Data Engineer
3 11 (22.00%) Architect
3 11 (22.00%) Data Architect
4 10 (20.00%) Data Modeller
5 7 (14.00%) Business Analyst
5 7 (14.00%) Developer
5 7 (14.00%) Technical Analyst
6 6 (12.00%) Azure Data Engineer
6 6 (12.00%) Azure Engineer
7 5 (10.00%) Technical Business Analyst
8 4 (8.00%) Data Analyst
8 4 (8.00%) Lead
9 3 (6.00%) Business Intelligence Developer
10 2 (4.00%) Business Intelligence Analyst
10 2 (4.00%) Customer Analyst
10 2 (4.00%) Customer Insight Analyst
10 2 (4.00%) Insight Analyst
10 2 (4.00%) Lead Architect
10 2 (4.00%) Lead Data Architect
Libraries, Frameworks & Software Standards
1 12 (24.00%) XML
2 2 (4.00%) Snowpark
3 1 (2.00%) Web Services
Miscellaneous
1 8 (16.00%) Management Information System
2 7 (14.00%) Data Structures
3 4 (8.00%) Product Ownership
3 4 (8.00%) Smart Meter
4 3 (6.00%) Greenfield Project
5 2 (4.00%) Analytical Mindset
5 2 (4.00%) Data Centre
5 2 (4.00%) Data Fabric
6 1 (2.00%) Data Protection Act
6 1 (2.00%) Onboarding
6 1 (2.00%) Reference Data
6 1 (2.00%) Wiki
Operating Systems
1 4 (8.00%) Linux
1 4 (8.00%) Unix
1 4 (8.00%) Windows
2 1 (2.00%) VMS
Processes & Methodologies
1 34 (68.00%) Business Intelligence
1 34 (68.00%) Data Modelling
2 29 (58.00%) ETL
3 23 (46.00%) Analytics
4 20 (40.00%) Agile
5 15 (30.00%) Scrum
6 11 (22.00%) Data Science
6 11 (22.00%) Kimball Methodology
7 9 (18.00%) Data Management
7 9 (18.00%) Kanban
8 8 (16.00%) Data Analytics
8 8 (16.00%) Data Integration
9 7 (14.00%) Project Management
9 7 (14.00%) Root Cause Analysis
9 7 (14.00%) User Acceptance Testing
9 7 (14.00%) User Stories
10 6 (12.00%) Data Architecture
10 6 (12.00%) Data Migration
10 6 (12.00%) Migration
10 6 (12.00%) Visualisation
Programming Languages
1 28 (56.00%) SQL
2 10 (20.00%) Python
3 7 (14.00%) PL/SQL
3 7 (14.00%) XPath
3 7 (14.00%) XQuery
4 3 (6.00%) T-SQL
5 2 (4.00%) Data Analysis Expressions
6 1 (2.00%) Java
6 1 (2.00%) Scala
6 1 (2.00%) Tcl
Qualifications
1 10 (20.00%) Security Cleared
2 8 (16.00%) Degree
3 3 (6.00%) Computer Science Degree
3 3 (6.00%) SC Cleared
Quality Assurance & Compliance
1 16 (32.00%) Data Quality
2 4 (8.00%) GDPR
Vendors
1 16 (32.00%) Microsoft
2 9 (18.00%) Databricks
2 9 (18.00%) Oracle
2 9 (18.00%) SAP
3 5 (10.00%) Ab Initio
3 5 (10.00%) Autodesk
4 3 (6.00%) IDERA
5 2 (4.00%) Alteryx
6 1 (2.00%) Google
6 1 (2.00%) Informatica
6 1 (2.00%) Salesforce