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)