Physical Data Model
UK

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

6 months to
18 May 2024
Same period 2023 Same period 2022
Rank 766 890 960
Rank change year-on-year +124 +70 -103
Permanent jobs citing Physical Data Model 124 87 285
As % of all permanent jobs advertised in the UK 0.12% 0.088% 0.18%
As % of the Processes & Methodologies category 0.15% 0.092% 0.19%
Number of salaries quoted 95 68 194
10th Percentile £54,000 £52,195 £52,500
25th Percentile £62,700 £58,438 £68,750
Median annual salary (50th Percentile) £80,000 £70,000 £75,000
Median % change year-on-year +14.29% -6.67% -3.23%
75th Percentile £92,500 £98,125 £84,688
90th Percentile £101,000 £106,625 £99,500
UK excluding London median annual salary £80,000 £70,000 £70,000
% change year-on-year +14.29% - +12.00%

All Process and Methodology Skills
UK

Physical Data Model 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 85,135 94,784 153,905
As % of all permanent jobs advertised in the UK 85.22% 95.58% 95.76%
Number of salaries quoted 59,872 55,911 82,488
10th Percentile £29,089 £34,000 £33,635
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £61,180 £60,000
Median % change year-on-year -10.10% +1.97% +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%

Physical Data Model
Job Vacancy Trend

Job postings citing Physical Data Model as a proportion of all IT jobs advertised.

Job vacancy trend for Physical Data Model in the UK

Physical Data Model
Salary Trend

3-month moving average salary quoted in jobs citing Physical Data Model.

Salary trend for Physical Data Model in the UK

Physical Data Model
Salary Histogram

Salary distribution for jobs citing Physical Data Model over the 6 months to 18 May 2024.

Salary histogram for Physical Data Model in the UK

Physical Data Model
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Physical Data Model within the UK over the 6 months to 18 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 +127 119 £80,000 -3.03% 23
UK excluding London +9 62 £80,000 +14.29% 9
London +108 57 £90,000 +9.09% 14
Work from Home +91 44 £67,200 -16.00% 12
North of England +85 36 £80,000 -14.67% 3
North West +28 25 £80,000 -8.57% 3
Midlands -1 13 £67,900 +115.56% 1
West Midlands - 13 £67,900 - 1
Yorkshire +90 8 £80,000 -20.00%
South East +1 4 £70,000 -30.86% 2
South West -27 4 £87,500 -10.26% 1
North East - 3 £55,000 -
East of England - 3 £110,000 - 1
Scotland -62 2 £69,783 -0.31%

Physical Data Model
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 7 (5.65%) SAS
2 5 (4.03%) Confluence
3 2 (1.61%) Apache
3 2 (1.61%) Apache Solr
3 2 (1.61%) Apache Spark
Applications
1 2 (1.61%) Microsoft Excel
1 2 (1.61%) Microsoft Office
1 2 (1.61%) Microsoft PowerPoint
1 2 (1.61%) MS Visio
Business Applications
1 2 (1.61%) SAP S/4HANA
2 1 (0.81%) Oracle EBS
Cloud Services
1 55 (44.35%) AWS
2 45 (36.29%) Azure
3 27 (21.77%) Amazon Kinesis
4 25 (20.16%) Amazon EC2
4 25 (20.16%) Amazon S3
5 21 (16.94%) GCP
6 10 (8.06%) Azure Data Factory
7 8 (6.45%) GitHub
8 7 (5.65%) Power Platform
9 5 (4.03%) Azure Synapse Analytics
9 5 (4.03%) Microsoft Purview
10 4 (3.23%) Snowflake
11 2 (1.61%) AWS Lambda
11 2 (1.61%) Azure DevOps
11 2 (1.61%) dbt
11 2 (1.61%) Figma
11 2 (1.61%) IaaS
11 2 (1.61%) PaaS
11 2 (1.61%) SaaS
11 2 (1.61%) Serverless
Database & Business Intelligence
1 44 (35.48%) Data Warehouse
2 41 (33.06%) Metadata
3 38 (30.65%) Relational Database
4 33 (26.61%) RDBMS
5 30 (24.19%) Amazon Redshift
6 25 (20.16%) Amazon RDS
6 25 (20.16%) Data Lake
6 25 (20.16%) MySQL
7 11 (8.87%) NoSQL
8 8 (6.45%) Ataccama
9 7 (5.65%) Power BI
10 5 (4.03%) Azure SQL Data Warehouse
10 5 (4.03%) Oracle Database
10 5 (4.03%) Semantic Layer
10 5 (4.03%) SQL Server
11 4 (3.23%) BigQuery
12 3 (2.42%) Data Mart
12 3 (2.42%) Star Schema
13 2 (1.61%) OLAP
13 2 (1.61%) Snowflake Schema
Development Applications
1 33 (26.61%) Git
2 25 (20.16%) Postman
3 8 (6.45%) GitLab
4 7 (5.65%) ERwin
5 5 (4.03%) JIRA
6 2 (1.61%) Balsamiq
6 2 (1.61%) ER Studio
General
1 41 (33.06%) Analytical Skills
2 26 (20.97%) Finance
3 25 (20.16%) Inclusion and Diversity
4 24 (19.35%) Banking
5 23 (18.55%) Social Skills
6 17 (13.71%) Retail Banking
7 15 (12.10%) Financial Institution
8 5 (4.03%) Retail
9 2 (1.61%) Legal
9 2 (1.61%) Presentation Skills
10 1 (0.81%) Local Government
10 1 (0.81%) Organisational Skills
10 1 (0.81%) Pharmaceutical
10 1 (0.81%) Publishing
Job Titles
1 49 (39.52%) Architect
2 45 (36.29%) Data Architect
2 45 (36.29%) Senior
3 30 (24.19%) Lead
4 25 (20.16%) Technical Leader
5 24 (19.35%) Senior Architect
5 24 (19.35%) Senior Data Architect
6 17 (13.71%) Analyst
7 13 (10.48%) Data Analyst
7 13 (10.48%) Data Engineer
8 9 (7.26%) Data Modeller
8 9 (7.26%) Senior Analyst
9 7 (5.65%) Senior Data Modeller
10 6 (4.84%) Banking Analyst
10 6 (4.84%) Domain Architect
10 6 (4.84%) Governance Analyst
11 5 (4.03%) Head of Business Intelligence
11 5 (4.03%) Senior Data Engineer
11 5 (4.03%) Solutions Architect
12 4 (3.23%) Technical Analyst
Libraries, Frameworks & Software Standards
1 28 (22.58%) JSON
2 25 (20.16%) Spring
2 25 (20.16%) Spring Boot
3 5 (4.03%) PySpark
4 3 (2.42%) REST
4 3 (2.42%) XML
5 2 (1.61%) ActiveMQ
5 2 (1.61%) Apache Camel
5 2 (1.61%) Lucene
5 2 (1.61%) Regular Expression
6 1 (0.81%) Kafka
6 1 (0.81%) Oracle Fusion
Miscellaneous
1 37 (29.84%) Management Information System
2 29 (23.39%) Cloud Native
3 15 (12.10%) Reference Data
4 11 (8.87%) Onboarding
5 8 (6.45%) Product Ownership
5 8 (6.45%) Self-Motivation
6 6 (4.84%) Public Cloud
6 6 (4.84%) Taxonomies
7 5 (4.03%) Blog
7 5 (4.03%) Data Structures
7 5 (4.03%) Greenfield Project
8 2 (1.61%) FMCG
8 2 (1.61%) Legacy Systems
9 1 (0.81%) Analytical Mindset
9 1 (0.81%) Enterprise Cloud
9 1 (0.81%) Life Science
9 1 (0.81%) Reinsurance
9 1 (0.81%) Virtual Team
Processes & Methodologies
1 124 (100.00%) Data Modelling
2 99 (79.84%) Logical Data Model
3 51 (41.13%) Data Management
4 47 (37.90%) Agile
5 46 (37.10%) Data Architecture
6 43 (34.68%) Data Strategy
7 38 (30.65%) Problem-Solving
8 37 (29.84%) Metadata Management
9 33 (26.61%) Design Patterns
10 30 (24.19%) Computer Science
10 30 (24.19%) SDLC
11 28 (22.58%) CI/CD
11 28 (22.58%) Roadmaps
12 27 (21.77%) DevOps
12 27 (21.77%) Technical Leadership
13 25 (20.16%) Agile Project Management
13 25 (20.16%) Infrastructure as Code
13 25 (20.16%) Product Strategy
13 25 (20.16%) Project Management
13 25 (20.16%) Software Engineering
Programming Languages
1 35 (28.23%) SQL
2 27 (21.77%) Java
3 25 (20.16%) PHP
4 5 (4.03%) PL/SQL
4 5 (4.03%) T-SQL
5 3 (2.42%) Python
6 2 (1.61%) Scala
6 2 (1.61%) XPath
Qualifications
1 33 (26.61%) Degree
2 28 (22.58%) Computer Science Degree
3 15 (12.10%) AWS Certification
3 15 (12.10%) Azure Certification
4 2 (1.61%) CBAP
4 2 (1.61%) IIBA
4 2 (1.61%) Security Cleared
5 1 (0.81%) BPSS Clearance
5 1 (0.81%) Master's Degree
5 1 (0.81%) SC Cleared
5 1 (0.81%) TOGAF Certification
Quality Assurance & Compliance
1 34 (27.42%) Data Quality
2 5 (4.03%) Accessibility
2 5 (4.03%) QA
3 1 (0.81%) GDPR
3 1 (0.81%) GxP
Systems Management
1 27 (21.77%) Terraform
Vendors
1 26 (20.97%) Microsoft
2 9 (7.26%) Databricks
3 8 (6.45%) Oracle
3 8 (6.45%) SAP
4 5 (4.03%) IBM
4 5 (4.03%) Teradata
5 2 (1.61%) Google
5 2 (1.61%) Talend
6 1 (0.81%) Informatica