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

6 months to
20 May 2024
Same period 2023 Same period 2022
Rank 761 887 960
Rank change year-on-year +126 +73 -85
Permanent jobs citing Physical Data Model 123 88 286
As % of all permanent jobs advertised in the UK 0.12% 0.088% 0.18%
As % of the Processes & Methodologies category 0.14% 0.093% 0.18%
Number of salaries quoted 94 69 192
10th Percentile £54,000 £52,000 £52,500
25th Percentile £63,113 £57,500 £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 £93,125 £97,500 £84,063
90th Percentile £102,000 £106,500 £97,000
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,108 95,066 155,930
As % of all permanent jobs advertised in the UK 85.18% 95.58% 95.78%
Number of salaries quoted 59,794 56,135 83,138
10th Percentile £29,071 £34,000 £33,645
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% +10.53%

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 20 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 20 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 +121 118 £80,000 - 23
UK excluding London +29 62 £80,000 +14.29% 9
London +107 57 £90,000 +9.09% 14
Work from Home +102 44 £67,200 -16.00% 12
North of England +69 36 £80,000 -14.67% 3
North West +22 25 £80,000 -8.57% 3
Midlands +1 13 £67,900 +115.56% 1
West Midlands - 13 £67,900 - 1
Yorkshire +89 8 £80,000 -20.00%
South East +10 4 £70,000 -30.86% 2
South West -24 4 £87,500 -10.26% 1
North East - 3 £55,000 -
East of England - 3 £110,000 - 1
Scotland -64 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.69%) SAS
2 5 (4.07%) Confluence
3 2 (1.63%) Apache
3 2 (1.63%) Apache Solr
3 2 (1.63%) Apache Spark
Applications
1 2 (1.63%) Microsoft Excel
1 2 (1.63%) Microsoft Office
1 2 (1.63%) Microsoft PowerPoint
1 2 (1.63%) MS Visio
Business Applications
1 2 (1.63%) SAP S/4HANA
2 1 (0.81%) Oracle EBS
Cloud Services
1 55 (44.72%) AWS
2 45 (36.59%) Azure
3 27 (21.95%) Amazon Kinesis
4 25 (20.33%) Amazon EC2
4 25 (20.33%) Amazon S3
5 21 (17.07%) GCP
6 10 (8.13%) Azure Data Factory
7 8 (6.50%) GitHub
8 7 (5.69%) Power Platform
9 5 (4.07%) Azure Synapse Analytics
9 5 (4.07%) Microsoft Purview
10 4 (3.25%) Snowflake
11 2 (1.63%) AWS Lambda
11 2 (1.63%) Azure DevOps
11 2 (1.63%) dbt
11 2 (1.63%) Figma
11 2 (1.63%) IaaS
11 2 (1.63%) PaaS
11 2 (1.63%) SaaS
11 2 (1.63%) Serverless
Database & Business Intelligence
1 44 (35.77%) Data Warehouse
2 41 (33.33%) Metadata
3 38 (30.89%) Relational Database
4 33 (26.83%) RDBMS
5 30 (24.39%) Amazon Redshift
6 25 (20.33%) Amazon RDS
6 25 (20.33%) Data Lake
6 25 (20.33%) MySQL
7 11 (8.94%) NoSQL
8 8 (6.50%) Ataccama
9 7 (5.69%) Power BI
10 5 (4.07%) Azure SQL Data Warehouse
10 5 (4.07%) Oracle Database
10 5 (4.07%) Semantic Layer
10 5 (4.07%) SQL Server
11 4 (3.25%) BigQuery
12 3 (2.44%) Data Mart
12 3 (2.44%) Star Schema
13 2 (1.63%) OLAP
13 2 (1.63%) Snowflake Schema
Development Applications
1 33 (26.83%) Git
2 25 (20.33%) Postman
3 8 (6.50%) GitLab
4 7 (5.69%) ERwin
5 5 (4.07%) JIRA
6 2 (1.63%) Balsamiq
6 2 (1.63%) ER Studio
General
1 41 (33.33%) Analytical Skills
2 26 (21.14%) Finance
3 25 (20.33%) Inclusion and Diversity
4 24 (19.51%) Banking
5 23 (18.70%) Social Skills
6 17 (13.82%) Retail Banking
7 15 (12.20%) Financial Institution
8 5 (4.07%) Retail
9 2 (1.63%) Legal
9 2 (1.63%) 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 48 (39.02%) Architect
2 44 (35.77%) Data Architect
2 44 (35.77%) Senior
3 30 (24.39%) Lead
4 25 (20.33%) Technical Leader
5 23 (18.70%) Senior Architect
5 23 (18.70%) Senior Data Architect
6 17 (13.82%) Analyst
7 13 (10.57%) Data Analyst
7 13 (10.57%) Data Engineer
8 9 (7.32%) Senior Analyst
9 8 (6.50%) Data Modeller
10 6 (4.88%) Banking Analyst
10 6 (4.88%) Domain Architect
10 6 (4.88%) Governance Analyst
10 6 (4.88%) Senior Data Modeller
11 5 (4.07%) Head of Business Intelligence
11 5 (4.07%) Senior Data Engineer
11 5 (4.07%) Solutions Architect
12 4 (3.25%) Technical Analyst
Libraries, Frameworks & Software Standards
1 28 (22.76%) JSON
2 25 (20.33%) Spring
2 25 (20.33%) Spring Boot
3 5 (4.07%) PySpark
4 3 (2.44%) REST
4 3 (2.44%) XML
5 2 (1.63%) ActiveMQ
5 2 (1.63%) Apache Camel
5 2 (1.63%) Lucene
5 2 (1.63%) Regular Expression
6 1 (0.81%) Kafka
6 1 (0.81%) Oracle Fusion
Miscellaneous
1 37 (30.08%) Management Information System
2 29 (23.58%) Cloud Native
3 15 (12.20%) Reference Data
4 11 (8.94%) Onboarding
5 8 (6.50%) Product Ownership
5 8 (6.50%) Self-Motivation
6 6 (4.88%) Public Cloud
7 5 (4.07%) Blog
7 5 (4.07%) Data Structures
7 5 (4.07%) Greenfield Project
7 5 (4.07%) Taxonomies
8 2 (1.63%) FMCG
8 2 (1.63%) 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 123 (100.00%) Data Modelling
2 98 (79.67%) Logical Data Model
3 51 (41.46%) Data Management
4 47 (38.21%) Agile
5 45 (36.59%) Data Architecture
6 43 (34.96%) Data Strategy
7 38 (30.89%) Problem-Solving
8 37 (30.08%) Metadata Management
9 33 (26.83%) Design Patterns
10 30 (24.39%) Computer Science
10 30 (24.39%) SDLC
11 28 (22.76%) CI/CD
11 28 (22.76%) Roadmaps
12 27 (21.95%) DevOps
13 26 (21.14%) Technical Leadership
14 25 (20.33%) Agile Project Management
14 25 (20.33%) Infrastructure as Code
14 25 (20.33%) Product Strategy
14 25 (20.33%) Project Management
14 25 (20.33%) Software Engineering
Programming Languages
1 35 (28.46%) SQL
2 27 (21.95%) Java
3 25 (20.33%) PHP
4 5 (4.07%) PL/SQL
4 5 (4.07%) T-SQL
5 3 (2.44%) Python
6 2 (1.63%) Scala
6 2 (1.63%) XPath
Qualifications
1 33 (26.83%) Degree
2 28 (22.76%) Computer Science Degree
3 15 (12.20%) AWS Certification
3 15 (12.20%) Azure Certification
4 2 (1.63%) CBAP
4 2 (1.63%) IIBA
4 2 (1.63%) 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.64%) Data Quality
2 5 (4.07%) Accessibility
2 5 (4.07%) QA
3 1 (0.81%) GDPR
3 1 (0.81%) GxP
Systems Management
1 27 (21.95%) Terraform
Vendors
1 26 (21.14%) Microsoft
2 9 (7.32%) Databricks
3 8 (6.50%) Oracle
3 8 (6.50%) SAP
4 5 (4.07%) IBM
4 5 (4.07%) Teradata
5 2 (1.63%) Google
5 2 (1.63%) Talend
6 1 (0.81%) Informatica