Back to Job Search

Physical Data Model (PDM) Developer

Job Description

Join a fast-paced PDM team at a Central Governmnet department, responsible for the development and maintenance of the physical data model. This includes management of all the databases that the model resides within and some of the Azure data services that exist in the ecosystem. 

Key Responsibilities: 
  • Perform updates and changes to the physical data model
  • Creating and updating Postgres functions (stored procedures)
  • Be an SME on the Physical Data Model to become a trusted advisor to other teams that have data requirements and translate these into database function(s)
  • Collaborate with the Data Architect to improve the PDM and surrounding processes
  • Support and mentor members of the Physical Data Model team
  • Work with the team to develop issues in Jira that are ready for development
  • Working closely with the Logical Data Model (LDM) team on collaborative tasks and helping keep both teams aligned
  • Contribution to Data workshops with key stakeholders across business, data and system areas helping to formalise and document requirements. (Multi-Vendor Environment).
  • Development of data architecture and design artefacts aligned to VOA standards.
  • Refining of SQL queries and functions to be more performant
  • Assisting teams in data migrations activities
  • Performing impact analysis on releases to pre-empt any issues these may cause and performing deployments

You'll need:
  • Experience of working with generic/abstract data models
  • Experience with data modelling tools
  • Experience creating and maintaining data and design artefacts
  • Strong problem-solving abilities in the context of complex data models
  • Strong experience with SQL (we use PostgreSQL but SQL Server or PL-SQL should be cross-trainable)
  • Experience creating and tuning complex SQL queries (e.g. self-referencing hierarchies, KVP structures)